1.所需要的jar包
https://mvnrepository.com/artifact/com.mchange/c3p0
https://mvnrepository.com/artifact/com.mchange/mchange-commons-java/0.2.15
2.配置c3p0-config.xml文件 放在src文件夹下
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<!-- 默认配置 -->
<default-config>
<!-- 连接参数 -->
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/Manager</property>
<property name="user">root</property>
<property name="password">root</property>
<!-- 连接池参数 -->
<!-- 初始化申请的连接数量 -->
<property name="initialPoolSize">5</property>
<!-- 最大的连接数量 -->
<property name="maxPoolSize">10</property>
<!-- 超时时间 -->
<property name="checkoutTimeout">3000</property>
</default-config>
<!--c3p0配置1-->
<named-config name="c3p0">
<!-- 连接参数 -->
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/manager</property>
<property name="user">root</property>
<property name="password">root</property>
<!-- 连接池参数 -->
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">8</property>
<property name="checkoutTimeout">1000</property>
</named-config>
</c3p0-config>
3.配置c3p0数据源工具类
public class ComboPooledDataSourceUtil {
private static ComboPooledDataSource dataSource =new ComboPooledDataSource("c3p0");
//xml编码 public static DataSource getDataSourceByxml(){
return dataSource;
} }
4.测试
@Test
//测试c3p0
public void test_c3p0() throws PropertyVetoException, SQLException {
Connection connection = ComboPooledDataSourceUtil.getDataSourceByxml().getConnection();
//Connection connection = ComboPooledDataSourceUtil.getDataSource().getConnection();
System.out.println(connection);
}