C3P0数据源
1、拷贝jar包
在c3p0发行包的lib目录中
c3p0-0.9.1.2.jar
c3p0-0.9.1.2-jdk1.3.jar
c3p0-oracle-thin-extras-0.9.1.2.jar(oracle)
2、在类路径下创建一个名为c3p0-config.xml的配置文件
<c3p0-config>
<named-config name="day14">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql:///day14</property>
<property name="user">root</property>
<property name="password">sorry</property>
<property name="acquireIncrement">10</property>
<property name="initialPoolSize">30</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">40</property>
<property name="maxStatements">1000</property>
<property name="maxStatementsPerConnection">100</property>
</named-config>
</c3p0-config>
3、建立一个工具类,根据配置文件获取数据源
private static ComboPooledDataSource ds = new ComboPooledDataSource ("day14");
public static Connection getConn() throws SQLException{
return ds.getConnection();
}
转载于:https://blog.51cto.com/2301703/1149403