MyBatis整合C3P0

MyBatis的默认连接池是POOLED，如果要使用其他连接池

1.添加依赖

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

2.在datasource目录下创建一个C3P0数据源工厂类

package com.MyBatis.datasource;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;

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

3.在mybatis-config.xml中更改dataSource标签内容

<dataSource type="com.MyBatis.datasource.C3P0dataSourceFactory">
    <!--driverClass对应数据库的驱动-->
    <property name="driverClass" value="com.mysql.jdbc.Driver"/>
    <!--jdbcUrl指向xx服务器xx端口xx的MySQL数据库-->
    <property name="jdbcUrl"
            value="jdbc:mysql://localhost:3306/babytun?useSSL=false&amp;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>