java代码
import com.mchange.v2.c3p0.ComboPooledDataSource;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
public class Jdbc_4 {
public static void main(String[] args) throws SQLException {
DataSource ds = new ComboPooledDataSource();
for (int i = 1; i <= 11; i++) {
Connection conn = ds.getConnection();
System.out.println(i + ":" + conn);
if(i==5){
conn.close();
}
}
}
}
配置文件(c3p0-config)
<!-- 连接池参数 -->
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">10</property>
<property name="checkoutTimeout">3000</property>
com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/db1 root root
<!-- 连接池参数 -->
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">8</property>
<property name="checkoutTimeout">1000</property>
所需jar包:https://download.csdn.net/download/jb18602754485/15565888