Java学习---C3P0的基本操作

c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.jdbcUrl=jdbc:mysql://127.0.0.1:3306/ssm?characterEncoding=UTF-8
c3p0.user=root
c3p0.password=root

public static void main(String[] args) {
        //创建连接池对象  自动读取配置文件
        ComboPooledDataSource source = new ComboPooledDataSource();//连接池对象
        //用于sql操作
        QueryRunner runner = new QueryRunner(source);
        String sql = "select * from products";
        try {
             //自动加载配置文件  自动生产list对象
            //new BeanHandler<>()
            //封装成BEan对象 list
            List<Products> list = runner.query(sql,new BeanListHandler<Products>(Products.class));
            for (Products p : list) {
                System.out.println(p);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }