![最开始的数据库连接](https://img-blog.csdn.net/20170925184630472?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvRXRlcm5hbDAzMDQ=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![优化后的连接池](https://img-blog.csdn.net/20170925184829920?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvRXRlcm5hbDAzMDQ=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test1</property>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="acquireIncrement">3</property>
<property name="initialPoolSize">10</property>
<property name="minPoolSize">2</property>
<property name="maxPoolSize">10</property>
</default-config>
</c3p0-config>
ComboPooledDataSource dataSource = new ComboPooledDataSource();
Connection conn = dataSource.getConnection();