package dbcp; import java.sql.Connection; import java.sql.SQLException; import org.apache.commons.dbcp2.BasicDataSource; import org.junit.Test; /** * dbcp * @author zzh * */ public class Demo { @Test public void fun() throws SQLException{ BasicDataSource dataSource =new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/mydb1"); dataSource.setUsername("root"); dataSource.setPassword("123"); dataSource.setMaxWaitMillis(1000); dataSource.setMinIdle(3); dataSource.setMaxTotal(20); Connection con = dataSource.getConnection(); System.out.println(con.getClass().getName()); con.close(); //把连接归还给池 } }
<pre name="code" class="html"><?xml version="1.0" encoding="UTF-8" ?> <c3p0-config> <default-config> <property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="user">root</property> <property name="password">123</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>
package c3p0; import java.beans.PropertyVetoException; import java.sql.Connection; import java.sql.SQLException; import org.junit.Test; import com.mchange.v2.c3p0.ComboPooledDataSource; /** * c3p0 * @author zzh * */ public class C3p0Demo { @Test public void fun() throws PropertyVetoException, SQLException{ ComboPooledDataSource dataSource = new ComboPooledDataSource(); //四大参数 dataSource.setDriverClass("com.mysql.jdbc.Driver"); dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mydb1"); dataSource.setUser("root"); dataSource.setPassword("123"); //设置参数 dataSource.setAcquireIncrement(5); dataSource.setInitialPoolSize(20); dataSource.setMaxPoolSize(30); dataSource.setMinPoolSize(2); Connection con = dataSource.getConnection(); System.out.println(con); con.close(); } /** * 配置文件连接 * 位子:src下 名字:c3p0-cofig.xml * @throws SQLException */ @Test public void fun2() throws SQLException{ ComboPooledDataSource dataSource = new ComboPooledDataSource(); Connection con = dataSource.getConnection(); System.out.println(con); con.close(); } }