数据库连接池_C3p0链接

在BiscDataSoucre 中 在h3中将不再提供链接服务，因为有一个很大的bug 

所以采用cp30 这个数据库连接池

需要两个jar文件

Cp30-0.92 与 mchange-commons-0.2

有三中配置方法：

1，通过代码配置

            

ComboPooledDataSource dataSource = new ComboPooledDataSource();
		try {
			dataSource.setDriverClass(pros.getProperty("classFroName"));
		} catch (PropertyVetoException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		dataSource.setJdbcUrl(pros.getProperty("url"));
		dataSource.setUser(pros.getProperty("username"));
		dataSource.setPassword(pros.getProperty("password"));
		//池配置
		dataSource.setAcquireIncrement(5);//增量
		dataSource.setMaxPoolSize(20);
		dataSource.setMinPoolSize(3);
		dataSource.setMaxIdleTime(1000);
		Connection conn = dataSource.getConnection();
		

2，通过默认配置方法配置c3p0-config.xml

        

<c3p0-config>  
    <default-config>  
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/tv_guide  
        </property>  
        <property name="driverClass">com.mysql.jdbc.Driver</property>  
        <property name="user">root</property>  
        <property name="password">root</property>  
  
  
        <property name="checkoutTimeout">30000</property>  
        <property name="idleConnectionTestPeriod">30</property>  
        <property name="initialPoolSize">10</property>  
        <property name="maxIdleTime">30</property>  
        <property name="maxPoolSize">100</property>  
        <property name="minPoolSize">10</property>  
        <property name="maxStatements">200</property>  
    </default-config>  
</c3p0-config>  

3,通过配置文件指定链接

构造参数里传名字参数，可以在配置文件里自动查找：

ComboPooleDataSource dateSoure =new ComboPooleDataSource("name");

<c3p0-config>  
    <named-config name="other">  
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/tv_guide  
        </property>  
        <property name="driverClass">com.mysql.jdbc.Driver</property>  
        <property name="user">root</property>  
        <property name="password">root</property>  
  
  
        <property name="checkoutTimeout">30000</property>  
        <property name="idleConnectionTestPeriod">30</property>  
        <property name="initialPoolSize">10</property>  
        <property name="maxIdleTime">30</property>  
        <property name="maxPoolSize">100</property>  
        <property name="minPoolSize">10</property>  
        <property name="maxStatements">200</property>  
    </named-config>  
</c3p0-config>  

ComboPooledDataSource dataSource = new ComboPooledDataSource("other");