c3p0-config.xml文件模板
<?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC</property>
<property name="user">root</property>
<property name="password">1234</property>
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">20</property>
</default-config>
</c3p0-config>
java测试文件
需要导入【c3p0-0.9.2-pre1.jar】与【mysql-connector-java-8.0.19.jar】
如有需要可以私信;
import java.sql.Connection;
import java.sql.SQLException;
import org.junit.Test;
import cn.itcast.jdbc.JdbcUtils;
public class JdbcUtilsTest {
@Test
public void testGetConnection()throws SQLException{
Connection con=JdbcUtils.getConnection();
System.out.println(con);
JdbcUtils.releaseConnection(con);
System.out.println(con.isClosed());
}
}
![6353b516c287a01efa0a2a443fd055f4.png](https://i-blog.csdnimg.cn/blog_migrate/728e2ffaddd6b31fec85a5499f1bcaf6.png)