java SSM框架整合实战

作者: haiyong6 | 来源:发表于2019-07-21 16:47 被阅读0次

这次的ssm整合比较详细，会从单独的mybatis连接数据库开始，基本会分为以下几个步骤：

1.单独使用mybatis

2.Mybatis整合spring - 有Mapper实现类

3.Mybatis整合spring – 没有Mapper实现类

4.Mybatis整合spring – mapper接口扫描

5.Mybatis 整合spring – 整合jdbc事务

6.整合springmvc

首先，对ssm整合有个大体的认识：

表现层：SpringMVC

包：SpringMVC的jar
配置文件：spring-mvc.xml

业务层：Spring

包：spring-ioc Spring-aop Spring-tx Spring-test
配置文件：applicationContext.xml
添加关于mybatis的配置

持久层：mybatis

包：mybatis自身核心包 Mysql数据库驱动包 C3p0连接池 Mybatis-spring的包
配置文件：sqlMapConfig.xml userMapperxml

一、单独使用mybatis

1.导入必须的包：
a)Mybatis自身核心jar：mybatis-3.4.4.jar
b)Log4j日志jar:log4j-1.2.17.jar
c)Oracle驱动jar：odbc14-10.2.0.4.0.jar
maven添加依赖jar包

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.4</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.4.0</version>
        </dependency>

注意：ojdbc因为版权关系在maven远程仓库中只有目录没有jar包的，如果添加配置报错要手动下载相应jar包放在本地仓库的相应文件夹就好啦。

2.建立测试数据库表

create table da_user
(
user_id NUMBER,
user_name VARCHAR2(10),
sex Integer,
JOB VARCHAR2(64),
tel varchar2(32),
email varchar2(64),
hobby varchar2(64)
);

3.建立实体类
也可以直接用HashMap映射对于比较简单的查询我比较习惯用这个
4.建立mapper接口UserMapper:

package com.ways.app.dao;

import java.util.Map;

public interface UserMapper {

    public void saveUser(Map<String,Object> paramsMap); 
}

5.建立sql映射文件userMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ways.app.dao.UserMapper">
    <insert id="saveUser" parameterType="java.util.HashMap">
        insert into da_user 
        values (decode((select max(user_id) from da_user),null,1,(select max(user_id) + 1 from da_user)),
                ‘${userName}’,${sex},'${job}','${tel}','${email}','${hobby}')
    </insert>
</mapper>

6.建立sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
        
<configuration>  
    <!-- 和spring整合后 environments配置将废除-->
    <environments default="development">
        <environment id="development">
            <!-- 使用jdbc事务管理 -->
            <transactionManager type="JDBC"/>
            <!-- 数据库连接池 -->
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE"/>
                <property name="username" value="zhaohy"/>
                <property name="password" value="oracle"/>
            </dataSource>
        </environment>
    </environments> 
    
    <!-- 查找sql映射文件 -->
    <mappers>
        <mapper resource="com/ways/app/sqlmap/oracle/userMapper.xml"/>
    </mappers>
</configuration>

7.编写测试类

package ssmTest;

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import com.ways.app.dao.UserMapper;

public class MybatisTest {
    @Test
    public void test() throws IOException {
        //1.创建SqlSessionFactoryBuilder
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        // 加载sqlMapConfig.xml文件
        InputStream ins = Resources.getResourceAsStream("sqlMapConfig.xml");
        
        
        //2.创建SqlSessionFactory
        SqlSessionFactory factory = builder.build(ins);
        
        //3.打开SqlSession
        SqlSession sqlSession = factory.openSession();
        
        //4.获取mapper接口的对象
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        
        //操作
        Map<String, Object> paramsMap = new HashMap<String, Object>();
        paramsMap.put("userName", "zhaohy");
        paramsMap.put("sex", 1);
        paramsMap.put("job", "java软件工程师");
        paramsMap.put("tel", "189xxxx0598");
        paramsMap.put("email", "1025XXXX40@qq.com");
        paramsMap.put("hobby", "编程，运动");
        userMapper.saveUser(paramsMap);
        //6.提交事务
        sqlSession.commit();
        
        //7.关闭资源
        sqlSession.close();
    }
}

运行测试类插入成功

深度截图_选择区域_20190721113023.png

补充：maven pom.xml

<project
    xmlns="http://maven.apache.org/POM/4.0.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.ways</groupId>
    <artifactId>ssmTest</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>
    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.8.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.tomcat</groupId>
            <artifactId>tomcat-servlet-api</artifactId>
            <version>7.0.94</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.tomcat</groupId>
            <artifactId>tomcat-jsp-api</artifactId>
            <version>7.0.94</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.ow2.asm</groupId>
            <artifactId>asm</artifactId>
            <version>7.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.4</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.4.0</version>
        </dependency>
    </dependencies>
    
    
    
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.7</source>
                    <target>1.7</target>
                     <compilerArguments>
                      <extdirs>src\main\webapp\WEB-INF\lib</extdirs>
                      <bootclasspath>/home/zhaohy/software/jdk1.8.0_181/jre/lib/rt.jar</bootclasspath>
                    </compilerArguments> 
                </configuration>
            </plugin>
            <plugin>
              <groupId>org.apache.tomcat.maven</groupId>
              <artifactId>tomcat7-maven-plugin</artifactId>
              <version>2.2</version>
              <configuration>
                <port>8080</port>
                <path>/</path>
              </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-war-plugin</artifactId>
                <version>2.6</version>
                <!-- <configuration>
                    <webResources>
                        <webResource>
                            <directory>${project.basedir}/lib</directory>
                            <targetPath>WEB-INF/lib</targetPath>
                            <filtering>false</filtering>
                            <includes>
                                <include>**/*.jar</include>
                            </includes>
                        </webResource>
                    </webResources>
                </configuration> -->
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-jar-plugin</artifactId>
                <version>3.0.2</version>
            </plugin>
        </plugins>
        
       <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>
    
    <properties>
       <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 
       <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> 
    </properties>
</project>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns="http://java.sun.com/xml/ns/javaee"
        xmlns:jsp="http://java.sun.com/xml/ns/javaee/jsp"
        xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
        version="3.0"
>
  <display-name>ssmTest</display-name>
</web-app>

项目源码已上传github地址:
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest

二、Mybatis整合spring - 有Mapper实现类

1.在上面的基础上导入必须的包：
Mybatis-spring
Spring自身的包：
spring-ioc
spring-aop
spring-tx
spring-context
c3p0数据库连接池的包
maven 配置：

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.2</version>
        </dependency>
        
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.4</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.8.RELEASE</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.1.8.RELEASE</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.8.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.8.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.1.8.RELEASE</version>
        </dependency>

2.编写Mapper的实现类：

package com.ways.app.dao.impl;

import java.util.Map;

import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.ways.app.dao.UserMapper;

public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {

    @Override
    public void saveUser(Map<String, Object> paramsMap) {
        this.getSqlSession().insert("com.ways.app.dao.UserMapper.saveUser", paramsMap);
        //不需要事务提交 mybatis帮忙提交了
    }

}

3.编写applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:jee="http://www.springframework.org/schema/jee"
       
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/jee 
            http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
       
       <!-- 读取jdbc.properties -->
       <context:property-placeholder location="classpath:jdbc.properties"/>
       
       <!-- 创建数据源DataSource -->
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
              <property name="driverClass" value="${jdbc.driverClassName}" /> 
              <property name="jdbcUrl" value="${jdbc.url}" /> 
              <property name="user" value="${jdbc.username}" /> 
              <property name="password" value="${jdbc.password}" /> 
              <property name="minPoolSize" value="10" /> <!-- 连接池中保留的最小连接数   -->
              <property name="maxPoolSize" value="100" /> <!-- 连接池中保留的最大连接数。Default: 15 -->
              <property name="maxIdleTime" value="600" /> <!-- 1800 --><!-- 最大空闲时间,600秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0  -->
              <property name="acquireIncrement" value="2" /> 
              <property name="maxStatements" value="0" /> 
              <property name="initialPoolSize" value="10" /> 
              <property name="idleConnectionTestPeriod" value="0" /> <!-- 60 --><!-- 每30秒检查所有连接池中的空闲连接。Default: 0 -->
              <property name="testConnectionOnCheckout" value="false" /> 
              <property name="acquireRetryAttempts" value="0" /> <!-- 定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
              <property name="acquireRetryDelay" value="1000" /> <!-- 两次连接中间隔时间，单位毫秒。Default: 1000 -->
              <property name="breakAfterAcquireFailure" value="false" />
       </bean>
       
       <!-- 创建SqlSessionFactory对象 -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!-- 关联连接池 -->
            <property name="dataSource" ref="dataSource"/>
            <!-- 加载sql映射文件集 -->
            <property name="configLocation" value="classpath:mapper/sqlMapConfig.xml" />
            <!-- 加载sql映射具体文件路径 -->
            <!-- <property name="mapperLocations" value="classpath:mapper/*Mappper.xml"/> -->
       </bean>
       
       <!-- 创建CommonMapperImpl对象，注入SqlSessionFactory -->
        <bean id="userMapper" class="com.ways.app.dao.impl.UserMapperImpl">
            <!-- 注入sqlSessionFactory -->
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>
        
</beans>

jdbc.properties文件：

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc\:oracle\:thin\:@127.0.0.1\:1521\:xe
jdbc.username=zhaohy
jdbc.password=oracle

修改sqlMapConfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
        
<configuration>  
    <!-- 和spring整合后 environments配置将废除-->
    <!-- <environments default="development">
        <environment id="development">
            使用jdbc事务管理
            <transactionManager type="JDBC"/>
            数据库连接池
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@172.16.1.37:1521:DBFM"/>
                <property name="username" value="FAWVW"/>
                <property name="password" value="FAWvw419"/>
            </dataSource>
        </environment>
    </environments>  -->
    
    <!-- 查找sql映射文件 -->
    <mappers>
        <mapper resource="com/ways/app/sqlmap/oracle/userMapper.xml"/>
    </mappers>
</configuration>

4.编写测试类MybatisSpringTest：

package ssmTest;

import java.util.HashMap;
import java.util.Map;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ways.app.dao.UserMapper;

public class MybatisSpringTest {
 
    @SuppressWarnings("resource")
    @Test
    public void test() {
        //1.加载spring配置
        ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
        //2.获取对象
        UserMapper commonMapper = (UserMapper) ac.getBean("userMapper");
        //3.调用方法
        Map<String, Object> paramsMap = new HashMap<String, Object>();
        paramsMap.put("userName", "zhaohy1");
        paramsMap.put("sex", 1);
        paramsMap.put("job", "java软件工程师");
        paramsMap.put("tel", "189xxxx0598");
        paramsMap.put("email", "1025XXXX40@qq.com");
        paramsMap.put("hobby", "编程，运动");
        commonMapper.saveUser(paramsMap);
    }
}

运行可以看到第二条已经插入成功！

深度截图_选择区域_20190721121353.png

项目源码已上传github:
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest01

三、Mybatis整合spring - 没有Mapper

修改applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:jee="http://www.springframework.org/schema/jee"
       
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/jee 
            http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
       
       <!-- 读取jdbc.properties -->
       <context:property-placeholder location="classpath:jdbc.properties"/>
       
       <!-- 创建数据源DataSource -->
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
              <property name="driverClass" value="${jdbc.driverClassName}" /> 
              <property name="jdbcUrl" value="${jdbc.url}" /> 
              <property name="user" value="${jdbc.username}" /> 
              <property name="password" value="${jdbc.password}" /> 
              <property name="minPoolSize" value="10" /> <!-- 连接池中保留的最小连接数   -->
              <property name="maxPoolSize" value="100" /> <!-- 连接池中保留的最大连接数。Default: 15 -->
              <property name="maxIdleTime" value="600" /> <!-- 1800 --><!-- 最大空闲时间,600秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0  -->
              <property name="acquireIncrement" value="2" /> 
              <property name="maxStatements" value="0" /> 
              <property name="initialPoolSize" value="10" /> 
              <property name="idleConnectionTestPeriod" value="0" /> <!-- 60 --><!-- 每30秒检查所有连接池中的空闲连接。Default: 0 -->
              <property name="testConnectionOnCheckout" value="false" /> 
              <property name="acquireRetryAttempts" value="0" /> <!-- 定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
              <property name="acquireRetryDelay" value="1000" /> <!-- 两次连接中间隔时间，单位毫秒。Default: 1000 -->
              <property name="breakAfterAcquireFailure" value="false" />
       </bean>
       
       <!-- 创建SqlSessionFactory对象 -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!-- 关联连接池 -->
            <property name="dataSource" ref="dataSource"/>
            <!-- 加载sql映射文件集 -->
            <property name="configLocation" value="classpath:mapper/sqlMapConfig.xml" />
            <!-- 加载sql映射具体文件路径 -->
            <!-- <property name="mapperLocations" value="classpath:mapper/*Mappper.xml"/> -->
       </bean>
       
       <!-- 创建CommonMapperImpl对象，注入SqlSessionFactory -->
        <!-- <bean id="userMapper" class="com.ways.app.dao.impl.UserMapperImpl">
            注入sqlSessionFactory
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> -->

        <!-- 配置Mapper接口 -->
        <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
            <!-- 注入mapper接口 -->
            <property name="mapperInterface" value="com.ways.app.dao.UserMapper"/>
            <!-- 注入SqlSessionFactory -->
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>
        
</beans>

项目源码已上传github地址：
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest02

四、Mybatis整合spring – mapper接口

配置扫描修改applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:jee="http://www.springframework.org/schema/jee"
       
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/jee 
            http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
       
       <!-- 读取jdbc.properties -->
       <context:property-placeholder location="classpath:jdbc.properties"/>
       
       <!-- 创建数据源DataSource -->
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
              <property name="driverClass" value="${jdbc.driverClassName}" /> 
              <property name="jdbcUrl" value="${jdbc.url}" /> 
              <property name="user" value="${jdbc.username}" /> 
              <property name="password" value="${jdbc.password}" /> 
              <property name="minPoolSize" value="10" /> <!-- 连接池中保留的最小连接数   -->
              <property name="maxPoolSize" value="100" /> <!-- 连接池中保留的最大连接数。Default: 15 -->
              <property name="maxIdleTime" value="600" /> <!-- 1800 --><!-- 最大空闲时间,600秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0  -->
              <property name="acquireIncrement" value="2" /> 
              <property name="maxStatements" value="0" /> 
              <property name="initialPoolSize" value="10" /> 
              <property name="idleConnectionTestPeriod" value="0" /> <!-- 60 --><!-- 每30秒检查所有连接池中的空闲连接。Default: 0 -->
              <property name="testConnectionOnCheckout" value="false" /> 
              <property name="acquireRetryAttempts" value="0" /> <!-- 定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
              <property name="acquireRetryDelay" value="1000" /> <!-- 两次连接中间隔时间，单位毫秒。Default: 1000 -->
              <property name="breakAfterAcquireFailure" value="false" />
       </bean>
       
       <!-- 创建SqlSessionFactory对象 -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!-- 关联连接池 -->
            <property name="dataSource" ref="dataSource"/>
            <!-- 加载sql映射文件集 -->
            <property name="configLocation" value="classpath:mapper/sqlMapConfig.xml" />
            <!-- 加载sql映射具体文件路径 -->
            <!-- <property name="mapperLocations" value="classpath:mapper/*Mappper.xml"/> -->
       </bean>
       
       <!-- 创建CommonMapperImpl对象，注入SqlSessionFactory -->
        <!-- <bean id="userMapper" class="com.ways.app.dao.impl.UserMapperImpl">
            注入sqlSessionFactory
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> -->
        <!-- 配置Mapper接口 -->
        <!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
            注入mapper接口
            <property name="mapperInterface" value="com.ways.app.dao.UserMapper"/>
            注入SqlSessionFactory
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> -->
        
        <!-- Mappper接口的扫描 
            注意：如果使用Mapper接口包扫描，那么每个Mapper接口在Spring容器中的id名称为类名：例如：UserMapper -> userMapper(首字母小写)
        -->
         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
               <!-- 配置mapper接口所在的包路径  会扫描此包以及其子包-->
               <property name="basePackage" value="com.ways.app.dao"/>
         </bean>
        
</beans>

项目源码已上传github地址：
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest03

五、Mybatis 整合spring – 整合jdbc事务

1.修改applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:jee="http://www.springframework.org/schema/jee"
       
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/jee 
            http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
       
       <!-- 读取jdbc.properties -->
       <context:property-placeholder location="classpath:jdbc.properties"/>
       
       <!-- 创建数据源DataSource -->
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
              <property name="driverClass" value="${jdbc.driverClassName}" /> 
              <property name="jdbcUrl" value="${jdbc.url}" /> 
              <property name="user" value="${jdbc.username}" /> 
              <property name="password" value="${jdbc.password}" /> 
              <property name="minPoolSize" value="10" /> <!-- 连接池中保留的最小连接数   -->
              <property name="maxPoolSize" value="100" /> <!-- 连接池中保留的最大连接数。Default: 15 -->
              <property name="maxIdleTime" value="600" /> <!-- 1800 --><!-- 最大空闲时间,600秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0  -->
              <property name="acquireIncrement" value="2" /> 
              <property name="maxStatements" value="0" /> 
              <property name="initialPoolSize" value="10" /> 
              <property name="idleConnectionTestPeriod" value="0" /> <!-- 60 --><!-- 每30秒检查所有连接池中的空闲连接。Default: 0 -->
              <property name="testConnectionOnCheckout" value="false" /> 
              <property name="acquireRetryAttempts" value="0" /> <!-- 定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
              <property name="acquireRetryDelay" value="1000" /> <!-- 两次连接中间隔时间，单位毫秒。Default: 1000 -->
              <property name="breakAfterAcquireFailure" value="false" />
       </bean>
       
       <!-- 创建SqlSessionFactory对象 -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!-- 关联连接池 -->
            <property name="dataSource" ref="dataSource"/>
            <!-- 加载sql映射文件集 -->
            <property name="configLocation" value="classpath:mapper/sqlMapConfig.xml" />
            <!-- 加载sql映射具体文件路径 -->
            <!-- <property name="mapperLocations" value="classpath:mapper/*Mappper.xml"/> -->
       </bean>
       
       <!-- 创建CommonMapperImpl对象，注入SqlSessionFactory -->
        <!-- <bean id="userMapper" class="com.ways.app.dao.impl.UserMapperImpl">
            注入sqlSessionFactory
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> -->
        <!-- 配置Mapper接口 -->
        <!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
            注入mapper接口
            <property name="mapperInterface" value="com.ways.app.dao.UserMapper"/>
            注入SqlSessionFactory
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> -->
        
        <!-- Mappper接口的扫描 
            注意：如果使用Mapper接口包扫描，那么每个Mapper接口在Spring容器中的id名称为类名：例如：UserMapper -> userMapper(首字母小写)
        -->
         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
               <!-- 配置mapper接口所在的包路径  会扫描此包以及其子包-->
               <property name="basePackage" value="com.ways.app.dao"/>
         </bean>
         
         <!-- 开启Spring ioc注解扫描 -->
        <context:component-scan base-package="com.ways.app"/>
        
        <!-- 开启spring的事务 -->
        <!-- 事务管理器 -->
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <!-- 注入dataSource -->
            <property name="dataSource" ref="dataSource"/>
        </bean>
        <!-- 启用Spring的事务注解 -->
        <tx:annotation-driven transaction-manager="transactionManager"/>
        
</beans>

2.编写业务接口和实现方法，并在业务方法上添加注解@Transactional
UserService

package com.ways.app.service;

import java.util.Map;

public interface UserService {
    public void saveUser(Map<String, Object> paramsMap);
}

UserServiceImpl

package com.ways.app.service.impl;

import java.util.Map;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.ways.app.dao.UserMapper;
import com.ways.app.service.UserService;

@Service("userService")
@Transactional
public class UserServiceImpl implements UserService {
    //注入Mapper对象
    @Resource
    private UserMapper userMapper;
    @Override
    public void saveUser(Map<String, Object> paramsMap) {
        userMapper.saveUser(paramsMap);
        int i = 100/0;
        userMapper.saveUser(paramsMap);

    }

}

此处故意写了一个int i = 100/0的异常，为了测试事务是否生效，如果生效的话这两次插入都不会被插入数据库

3.测试方法：

package ssmTest;

import java.util.HashMap;
import java.util.Map;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ways.app.service.UserService;

public class MybatisSpringTest {
 
    @Test
    public void test1() {
          //1.加载spring配置
            ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
            //2.获取对象
            UserService commonService = (UserService) ac.getBean("userService");
            Map<String, Object> paramsMap = new HashMap<String, Object>();
            paramsMap.put("userName", "zhaohy4");
            paramsMap.put("sex", 1);
            paramsMap.put("job", "java软件工程师");
            paramsMap.put("tel", "189xxxx0598");
            paramsMap.put("email", "1025XXXX40@qq.com");
            paramsMap.put("hobby", "编程，运动");
            commonService.saveUser(paramsMap);
        }
}

运行测试方法 junit报错，分母不能为0，通过数据库查表得知两条都没有插入成功，说明事务控制成功。事务注解可以对一个单一的方法也可以对整个类控制。

项目源码已上传github:
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest04

六、整合SpringMVC

1.导入springMVC的包
2.配置web.xml
1)启动spring,加载applicationContext.xml
2)启动springmvc,加载spring-mvc.xml

maven配置：

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.1.8.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.58</version>
        </dependency>
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.4</version>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.6</version>
        </dependency>

web.xml:

<?xml version="1.0" encoding="UTF-8"?>
<web-app
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns="http://java.sun.com/xml/ns/javaee"
        xmlns:jsp="http://java.sun.com/xml/ns/javaee/jsp"
        xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
        version="3.0"
>
  <display-name>ssmTest05</display-name>
  
  <!-- 启动spring 监听器-->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  
  <!-- 修改路径：使spring读入applicationContext.xml配置 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classPath:applicationContext.xml</param-value>
  </context-param>
  
  <!-- 启动springmvc -->
  <servlet>
    <servlet-name>DispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 参数：读取spring-mvc.xml -->
    <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classPath:spring-mvc.xml</param-value>
    </init-param>
  </servlet>
  <servlet-mapping>
    <servlet-name>DispatcherServlet</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>

<!-- 配置SpringMVC编码过滤器 -->
  <filter>
    <filter-name>CharacterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
        <param-name>encoding</param-name>
        <param-value>utf-8</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

配置spring-mvc.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:jee="http://www.springframework.org/schema/jee"
       
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/mvc
            http://www.springframework.org/schema/mvc/spring-mvc.xsd
            http://www.springframework.org/schema/jee 
            http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
       
       <!-- 扫描Controller所在的包 -->
       <context:component-scan base-package="com.ways.app.web.controller"/>
       
       <!-- 注解驱动 -->
       <mvc:annotation-driven></mvc:annotation-driven>
        
        <!-- 视图解析器：简化在Controller类编写的视图路径 -->
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <!-- 前缀 -->
            <property name="prefix" value="/WEB-INF/pages/"/>
            <!-- 后缀 -->
            <property name="suffix" value=".jsp"/>
        </bean>
                
</beans>

编写UserController:

package com.ways.app.web.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
public class UserController {
    
    @RequestMapping("/user/test")
    public String test() {
        
        return "test";
    }

}

在WEB-INF/pages/下编写test.jsp


<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <h1>Hello SpringMVC!</h1>
</body>
</html>

请求/user/test.do接口，成功跳转到test.jsp,springmvc配置成功！

深度截图_选择区域_20190721163515.png

在controller写一个保存用户的方法测试一下能不能插入数据：

package com.ways.app.web.controller;

import java.util.HashMap;
import java.util.Map;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.ways.app.service.UserService;
@Controller
public class UserController {
    @Resource
    public UserService userService;
    @RequestMapping("/user/test")
    public String test() {
        
        return "test";
    }
    
    @RequestMapping("/user/saveUser")
    public void saveUser() {
        
        Map<String, Object> paramsMap = new HashMap<String ,Object>();
        paramsMap.put("userName", "zhaohy4");
        paramsMap.put("sex", 1);
        paramsMap.put("job", "java软件工程师");
        paramsMap.put("tel", "189xxxx0598");
        paramsMap.put("email", "1025XXXX40@qq.com");
        paramsMap.put("hobby", "编程，运动");
        userService.saveUser(paramsMap);
    }

}

运行tomcat 请求/user/saveUser.do
可以看到数据库里已经插入了一条信息

深度截图_选择区域_20190721164339.png

至此，一个完整的简单ssm项目就已经搭建完成啦～

项目源码已上传github:
https://github.com/haiyong6/haiyongsRepository/tree/master/code/ssmTest05