方法一:
通过ComboPooledDataSource进行创建连接。代码如下:
public static DataSource getDataSourceWithC3P0() throws PropertyVetoException {
ComboPooledDataSource c3p0 = new ComboPooledDataSource();
c3p0.setDriverClass("com.mysql.jdbc.Driver");
c3p0.setJdbcUrl("jdbc:mysql://localhost:3306/stu");
c3p0.setUser("root");
c3p0.setPassword("root");
return c3p0;
}
方法二:
通过c3p0-config.xml文件进行配置。
c3p0-config.xml文件的代码如下:
<?xml version="1.0" encoding="utf-8" ?>
<c3p0-config>
<default-config>
<!--默认的配置方式-->
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/stu</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="checkoutTimeout">30000</property>
</default-config>
<!--自定义的配置方式-->
<named-config name="wpc">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/stu</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="checkoutTimeout">20000</property>
</named-config>
</c3p0-config>
连接创建代码如下:
public static DataSource getDataSourceWithC3P0ByXML() throws PropertyVetoException {
ComboPooledDataSource c3p0 = new ComboPooledDataSource("wpc");
return c3p0;
}
以上两代码依靠的jar包有:c3p0-0.9.5.2.jar及mchange-commons-java-0.2.11.jar