【MyBatis学习笔记】9. MyBatis整合C3P0连接池

---

MyBatis配置C3P0连接池 取代 默认的连接池

1. maven添加依赖

<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.4</version>
</dependercy>

2. 创建C3P0DataSourceFactory

/**
 *   C3P0与MyBatis兼容使用的数据源工厂类
 */
public class C3P0DataSourceFactory extends UnpooledDataSourceFactory{
    public C3P0DataSourceFactory(){
        this.dataSource=new ComboPooledDataSource();
    }
}

3. 修改mybatis-config.xml

<dataSource type="com.imooc.mybatis.datasource.C3P0DataSourceFactory">
    <property name="driverClass" value="com.mysql.jdbc.Driver" />
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/babytun?useUnicode=true$amp;characterEncoding=UTF-8" />
    <property name="user" value="root" />
    <property name="password" value="root" />
    <property name="initialPoolSize" value="5" />
    <property name="maxPoolSize" value="20" />
    <property name="minPoolSize" value="5" />
<dataSource>