Spring与Mybatis整合

整合理解：

Mybatis需要SqlSession对象，才能和数据库进行交互，而该会话都是基于SqlSessionFactory创建的。
所以我们只需要将SqlSessionFactory对象的管理权交给Spring管理。让Spring+Mybatis的优点集合在一起。

 

第一步，首先导入需要的jar包或者依赖

<!-- Spring -->  
<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->	
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>5.2.0.RELEASE</version>
</dependency>
  	
<!-- Spring-jdbc -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>5.2.0.RELEASE</version>
</dependency>
  		
<!-- Mybatis -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.5.0</version>
</dependency>
  	
<!-- Spring+Mybatis整合包  非常重要 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>2.0.3</version>
</dependency>
  	  	
<!--  Mysql-jdbc    注意：
	mysql-jdbc8.0 以上JDBC驱动名：com.mysql.cj.jdbc.Driver
	mysql-jdbc8.0 以下JDBC驱动名：com.mysql.jdbc.Driver   -->
<!--  https://mvnrepository.com/artifact/mysql/mysql-connector-java	 -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.47</version>
</dependency>
  		
<!-- log4j 日志包  -->	
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
   <groupId>log4j</groupId>
   <artifactId>log4j</artifactId>
   <version>1.2.17</version>
</dependency>

<!-- C3p0  连接池 -->
<dependency>
  <groupId>com.mchange</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.5.2</version>
</dependency>
	
<!-- 单元测试 -->	
<!-- https://mvnrepository.com/artifact/junit/junit -->
<dependency>
   <groupId>junit</groupId>
   <artifactId>junit</artifactId>
   <version>4.12</version>
   <scope>test</scope>
</dependency>

第二步，编写配置文件