首先导入c3p0-0.9.2.1.jar这个包 然后再创建一个c3p0-config.xml的配置文件
c3p0-config.xml中配置的属性为
//这些内容是c3p0-config.xml配置的属性 <c3p0-config> <default-config> <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbc </property> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="user">root</property> <property name="password">123</property> <property name="initialPoolSize">3</property> <property name="maxPoolSize">6</property> <property name="maxIdleTime">1000</property> </default-config> <named-config name="mysql_config"> <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbc</property> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="user">root</property> <property name="password">123</property> <property name="initialPoolSize">3</property> <property name="maxPoolSize">6</property> <property name="maxIdleTime">1000</property> </named-config> </c3p0-config> //用了这个配置文件之后只需要对象调用系统就可以直接找到连接的地址 @Test public void t2(){ ComboPooledDataSource cpds = new ComboPooledDataSource(); System.out.println(cpds.getJdbcUrl()); } //这个是没用配置文件自己添加属性写的 public class T { @Test public void t1() throws PropertyVetoException, SQLException { ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setJdbcUrl("jdbc:mysql://localhost:3306/jdbc"); cpds.setDriverClass("com.mysql.jdbc.Driver"); cpds.setUser("root"); cpds.setPassword("111111"); //最大等待时间 cpds.setMaxIdleTime(3000); //池子的最大容量 cpds.setMaxPoolSize(10); //初始化时的连接对象数 cpds.setInitialPoolSize(3); Connection connection = cpds.getConnection(); }