jdbcUtil.java
package a_utils;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class jdbcUtils {
/*
* 1.初始化C3P0连接池
* */
private static DataSource dataSource;
static{
dataSource = new ComboPooledDataSource();
}
/*
* 2.创建DBUtils核心工具类对象
* */
public static QueryRunner getQueryRunner(){
//创建QueryRunner对象,传入连接池对象
//在创建QueryRunner对象的时候,如果传入了数据源对象;
//那么在使用QueryRunner对象方法的时候,就不需要传入连接对象;
//会自动从数据源中获取连接(不用关闭连接)
return new QueryRunner(dataSource);
}
}
c3p0-config.xml
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql:///test</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">10</property>
</default-config>
<named-config name="oracleConfig">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql:///test</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">10</property>
</named-config>
</c3p0-config>