Mybatis整合Spring

1.导包 .xml加入依赖

<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

    <!-- spring版本号 -->
    <spring.version>5.0.6.RELEASE</spring.version>

    <!-- mybatis版本号 -->
    <mybatis.version>3.2.8</mybatis.version>

    <!-- mysql驱动版本号 -->
    <mysql-driver.version>5.1.29</mysql-driver.version>

    <!-- log4j日志包版本号 -->
    <slf4j.version>1.7.18</slf4j.version>
    <log4j.version>1.2.17</log4j.version>

</properties>

<dependencies>
    <!-- 添加jstl依赖 -->
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>

    <dependency>
        <groupId>javax</groupId>
        <artifactId>javaee-api</artifactId>
        <version>7.0</version>
    </dependency>

    <!-- 添加junit4依赖 -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <!-- 指定范围，在测试时才会加载 -->
        <scope>test</scope>
    </dependency>

    <!-- 添加spring核心依赖 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- 添加mybatis依赖 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>${mybatis.version}</version>
    </dependency>

    <!-- 添加mybatis/spring整合包依赖 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.2.2</version>
    </dependency>

    <!-- 添加mysql驱动依赖 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-driver.version}</version>
    </dependency>
    <!-- 添加数据库连接池依赖 -->
    <dependency>
        <groupId>commons-dbcp</groupId>
        <artifactId>commons-dbcp</artifactId>
        <version>1.2.2</version>
    </dependency>

    <!-- 添加fastjson -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.1.41</version>
    </dependency>

    <!-- 添加日志相关jar包 -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>${log4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>${slf4j.version}</version>
    </dependency>

    <!-- log end -->
    <!-- 映入JSON -->
    <dependency>
        <groupId>org.codehaus.jackson</groupId>
        <artifactId>jackson-mapper-asl</artifactId>
        <version>1.9.13</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.8.0</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.8.0</version>
    </dependency>

    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.1</version>
    </dependency>

    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.4</version>
    </dependency>

    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>1.9</version>
    </dependency>
</dependencies>
</project>

2.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"
   xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
	http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">

<!--加载配置文件-->
<context:property-placeholder location="classpath:jdbc.properties"/>

<!--dbcp数据源  数据库连接池-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driver}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.user}"/>
    <property name="password" value="${jdbc.password}"/>
    <!--最大连接数-->
    <property name="maxActive" value="10"/>
    <!--最大空闲-->
    <property name="minIdle" value="5"/>
</bean>

<!--MyBatis工厂-->
<bean name="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <!--核心配置文件位置-->
    <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
</bean>

<!--Dao原始Dao-->
<bean id="userDao" class="dao.UserDaoImpl">
    <property name="sqlSessionFactory" ref="sqlSessionFactoryBean"/>
</bean>

<!--Mapper动态代理开发-->
<!--<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
    <property name="sqlSessionFactory" ref="sqlSessionFactoryBean"/>
    <property name="mapperInterface" value="mapper.UserMapper" />
</bean>-->

<!--Mapper动态代理开发扫描版-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <!--指定基本包-->
    <property name="basePackage" value="mapper"/>
</bean>
</beans>

3.UserMapperImpl

 public class UserDaoImpl  extends SqlSessionDaoSupport implements UserDao {
   	 public User selectUserById(Integer id) {
	        SqlSession sqlSession = getSqlSession();
	        User user = sqlSession.selectOne("selectUserById", id);
	        return user;
    }
}
 //继承了SqlSessionDaoSupport  ，UserDaoImpl就有了 SqlSessionFactory的属性，spring配置文件中可以直接配置属性值

4.sqlMapContext.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>
    <!--设置别名-->
    <typeAliases>
        <!--指定扫描包-->
        <package name="pojo"/>
    </typeAliases>
    
    <mappers>
       <!--<package name="mapper"/>-->    //扫描包
        <!--<mapper class="mapper.UserMapper"/>-->   //通过接口
        <mapper resource="mapper/UserMapper.xml"/>   //直接查配置文件路径
    </mappers>
  </configuration>

5.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="mapper.UserMapper">  //接口的包名+接口名
	    <select id="selectUserById" resultType="pojo.User" parameterType="Integer">
	        select * from user where id = #{v}
	    </select>
	</mapper>

6.测试UserDao

  @Test
  public void testMapper(){
        ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext");
        UserDaoImpl userDao = (UserDaoImpl) ac.getBean("userDao");
        User user = userDao.selectUserById(10);
        System.out.println(user);
   }

7.测试UserMapper 动态代理

 @Test
  public void testMapper2(){
      ApplicationContext ac = new  ClassPathXmlApplicationContext("applicationContext");
      UserMapper userMapper = (UserMapper) ac.getBean("userMapper");
      User user = userMapper.selectUserById(10);
      System.out.println(user);
  }

8.测试动态代理扫描版

@Test
public void testMapper3(){
    ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext");
    UserMapper userMapper = ac.getBean(UserMapper.class);  //传入字节码文件
    User user = userMapper.selectUserById(1);
    System.out.println(user);

}