在MyBatis中配置C3P0连接池,你需要确保已经添加了C3P0和MyBatis的依赖,并在MyBatis的配置文件中正确配置了数据源。以下是一个基本的步骤指南:
1. 添加依赖
如果你使用Maven,可以在pom.xml
中添加以下依赖:
<dependencies><!-- MyBatis 依赖 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.7</version></dependency><!-- C3P0 依赖 --><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.5</version></dependency><!-- MySQL 驱动依赖 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.23</version></dependency>
</dependencies>
2. 创建数据源
package com.example.datasource;import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;public class C3P0DataSourceFactory extends UnpooledDataSourceFactory {public C3P0DataSourceFactory() {this.dataSource = new ComboPooledDataSource();}
}
3. 修改mybatis-config.xml
C3PO连接池的配置项名称与mybaties的略有不同,注意进行修改:
<!--使用C3PO连接池--><dataSource type="com.babytun.datasource.C3P0DataSourceFactory"><property name="driverClass" value="com.mysql.cj.jdbc.Driver"/><property name="jdbcUrl" value="jdbc:mysql://localhost:3306/babytun?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true"/><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>