eg:
public class C3p0Utils {
//.在成员变量位置创建一个静态的ComboPooledDtatSource 对象,读取配置数据
private static ComboPooledDataSource dataSource = new ComboPooledDataSource();
//定义一个静态方法 可以返回连接池
public static DataSource getDataSource() {
return dataSource;
}
//定义一个静态方法 ComboPooledDtatSource 对象中获得数据库连接 Coonection
public static Connection getConnection() throws SQLException{
return dataSource.getConnection();
}
import java.sql.SQLException;
import java.util.ArrayList;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import domain.User;
public class C3p0UtilsDao {
public static ArrayList<User> FinAll() throws SQLException {
//创建QueryRunner对象
QueryRunner runner=new QueryRunner(C3p0Utils.getDataSource());
//定义SQL
String sql="select * from user";
//调用方法
ArrayList<User> list=(ArrayList<User>) r