Spring 整合Mybatis

步骤：

1. Maven项目导入相关jar包

   • junit
   • mybatis
   • mysql数据库
   • spring相关的
   • aop织入
   • mybatis-spring

   <dependencies>
       <dependency>
           <groupId>junit</groupId>
           <artifactId>junit</artifactId>
           <version>4.12</version>
       </dependency>
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.47</version>
       </dependency>
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.5.2</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-webmvc</artifactId>
           <version>5.1.9.RELEASE</version>
       </dependency>
       <!--Spring操作数据库的话，还需要一个spring-jdbc-->
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-jdbc</artifactId>
           <version>5.1.9.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.aspectj</groupId>
           <artifactId>aspectjweaver</artifactId>
           <version>1.8.13</version>
       </dependency>
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis-spring</artifactId>
           <version>2.0.2</version>
       </dependency>
       <dependency>
           <groupId>org.projectlombok</groupId>
           <artifactId>lombok</artifactId>
           <version>1.16.10</version>
       </dependency>
   
   </dependencies>
   
   <build>
       <resources>
           <resource>
               <directory>src/main/java</directory>
               <includes>
                   <include>**/*.xml</include>
               </includes>
               <filtering>true</filtering>
           </resource>
       </resources>
   </build>
   

2. 编写配置文件
   spring-dao.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"
          xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans.xsd">
   
       <!--DataSource：使用Spring的数据源替换Mybatis的配置  c3p0  dbcp  druid
       我们这里使用Spring提高的JDBC ： org.springframework.jdbc.datasource
       -->
   
       <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
           <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
           <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false"/>
           <property name="username" value="root"/>
           <property name="password" value="123456"/>
       </bean>
   
       <!--sqlSessionFactory-->
   
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
           <property name="dataSource" ref="dataSource"/>
           <!--绑定Mybatis配置文件-->
           <property name="configLocation" value="classpath:mybatis-config.xml"/>
           <property name="mapperLocations" value="classpath:com/hua/mapper/*.xml"/>
       </bean>
   
       <!--SqlSessionTemplate：就是我们使用的sqlSession-->
       <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
           <!--只能使用构造器注入sqlSessionFactory，因为它没有set方法-->
           <constructor-arg index="0" ref="sqlSessionFactory"/>
       </bean>
   
   </beans>
   

   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"
          xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans.xsd">
   
       <import resource="spring-dao.xml"/>
   
       <!--方法一-->
       <!--需要注入sqlSessionTemplate-->
       <bean id="userMapper" class="com.hua.mapper.UserMapperImpl">
           <property name="sqlSession" ref="sqlSessionTemplate"/>
       </bean>
   
       <!--方法二-->
       <!--需要注入sqlSessionFactory比方法一节省一步-->
       <bean id="userMapper2" class="com.hua.mapper.UserMapperImpl2">
           <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
       </bean>
   
   </beans>
   

3. 测试
   方法一：
   使用set方法获取SqlsessionTemplate获取

   public class UserMapperImpl implements UserMapper{
   
       //我们的所有操作，都使用sqlSession来执行，在原来，现在都使用SqlSessionTemplate；
       private SqlSessionTemplate sqlSession;
   
       public void setSqlSession(SqlSessionTemplate sqlSession) {
           this.sqlSession = sqlSession;
       }
   
       @Override
       public List<User> selectUser() {
           UserMapper mapper = sqlSession.getMapper(UserMapper.class);
           return mapper.selectUser();
       }
   }
   

   测试类

   public class MyTest {
       @Test
       public void test() throws IOException {
   
           ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
   
           UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
           for (User user : userMapper.selectUser()) {
               System.out.println(user);
           }
   
       }
   }
   /*
   测试结果：
   User(id=1, name=狂神, pwd=123456)
   User(id=2, name=张三, pwd=123456)
   User(id=3, name=李四, pwd=123890)
   User(id=4, name=李五, pwd=123123)
   */
   

   方法二：
   继承SqlSessionDaoSupport类，使用getSqlSession()方法直接获取SqlsessionTemplate

   public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper{
   
       @Override
       public List<User> selectUser() {
           UserMapper mapper = getSqlSession().getMapper(UserMapper.class);
           return mapper.selectUser();
       }
   }
   

   测试类

   public class MyTest {
       @Test
       public void test() throws IOException {
   
           ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
   
           UserMapper userMapper = context.getBean("userMapper2", UserMapper.class);
           for (User user : userMapper.selectUser()) {
               System.out.println(user);
           }
   
       }
   }
   /*
   测试结果：
   User(id=1, name=狂神, pwd=123456)
   User(id=2, name=张三, pwd=123456)
   User(id=3, name=李四, pwd=123890)
   User(id=4, name=李五, pwd=123123)
   */