package com.etc.utils;
import java.sql.Connection;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import com.mchange.v2.c3p0.ComboPooledDataSource;
/**
* 1.初始化c3p0连接
* 2.创建JdbcUtils核心工具类
*
*/
public class JdbcUtils {
//初始化c3p0连接池
private static DataSource dataSource;
static {
ComboPooledDataSource dataSource = new ComboPooledDataSource();
}
//创建JdbcUtils核心工具类
public static QueryRunner getQueryRunner(){
return new QueryRunner(dataSource);
}
}
配置文件中是这样的:
<c3p0-config>
<default-config>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/user</property>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="initialPoolSize">3</property>
<property name="maxPoolSize">6</property>
<property name="maxIdleTime">1000</property>
</default-config>
</c3p0-config>
新学c3p0 做分页,可是启动tomcat,运行时也不报错,数据库中的数据也不显示...