Spring整合Mybatis
整合思路
![](https://img-blog.csdnimg.cn/20191031153956570.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MDg3OQ==,size_16,color_FFFFFF,t_70)
连接池
原理图解:
![](https://img-blog.csdnimg.cn/20191031152054363.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MDg3OQ==,size_16,color_FFFFFF,t_70)
常用连接池:c3p0 dbcp druid(阿里巴巴研发)。
开发步骤:maven项目中引入依赖
<!--c3p0连接池-->
<!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!--dbcp连接池-->
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!--aplibaba druid 连接池-->
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
代码案例:通过三种不同方式获取数据库连接
public class TestDataSource {
//C3p0连接池
@Test
public void testC3p0() throws Exception {
// 创建连接池对象
ComboPooledDataSource dataSource = new ComboPooledDataSource();
// 设置连接数据库的参数
dataSource.setDriverClas