- 导入jar包
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>mchange-commons-java</artifactId>
<version>0.2.12</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
</dependency>
- 配置 src下 配置文件(不知道咋回事,配置文件方式死活不生效)
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="user">root</property>
<property name="password">123456</property>
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">
url=jdbc:mysql://localhost:3306/shangpinhoutai?serverTimezone=UTC&useSSL=false
</property>
<property name="initialPoolSize">10</property>
<property name="maxIdleTime">30</property>
<property name="maxPoolSize">100</property>
<property name="minPoolSize">10</property>
</default-config>
</c3p0-config>
硬编码方式
ComboPooledDataSource ds = new ComboPooledDataSource();
ds.setJdbcUrl("jdbc:mysql://localhost:3306/shangpinhoutai?serverTimezone=UTC&useSSL=false");
ds.setUser("root");
ds.setPassword("123456");
ds.setDriverClass("com.mysql.cj.jdbc.Driver");
ds.setMaxPoolSize(3);
System.out.println(ds);
for (int i=0;i<10;i++){
Connection conn = ds.getConnection();
System.out.println(conn);
conn.close();
}