【c3p0-0.9.5.5.jar】【mchange-commons-java-0.2.20.jar】【mysql-connector-java-8.0.26.jar】
在src下新建 c3p0-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<named-config name="hellc3p0">
<!-- 提供获取连接的4个基本信息 -->
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql:///data</property>
<property name="user">root</property>
<property name="password">123456</property>
<!-- 进行数据库连接池管理的基本信息 -->
<!-- 当数据库连接池中的连接不够时,3pp0一次性向数据库服务器申请的连接数 -->
<property name="acquireIncrement">5</property>
<!-- c3p0数据库连接池中初始化时的连接数 -->
<property name="initialPoolSize">10</property>
<!-- c3p0数据库连接池维护的最少连接数 -->
<property name="minPoolSize">10</property>
<!-- c3p0数据库连接池维护的最多连接数 -->
<property name="maxPoolSize">100</property>
<!-- c3p0数据库连接池最多维护的statement的个数 -->
<property name="maxStatements">50</property>
<!-- 每个连接中可以最多使用的statement的个数 -->
<property name="maxStatementsPerConnection">2</property>
<!-- -->
</named-config>
</c3p0-config>
--------------------------------------------------------------------------------------------------------------------------------
c3p0连接方式:
package c3p0Connection;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class JDBCutils {
//方式二:采用c3p0方式
private static ComboPooledDataSource cpds = new ComboPooledDataSource("hellc3p0");
public static Connection getConnection() throws SQLException {
Connection conn = cpds.getConnection();
return conn;
}
// 关闭资源
public static void closeResource(Connection conn,Statement ps) {
try {
if(ps !=null)
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}