c3p0连接池 加 dbutils

配置文件c3p0-config

<?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
    <default-config>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/myemp?characterEncoding=utf8</property>
        <property name="user">root</property>
        <property name="password">123456</property>
    </default-config>
</c3p0-config>

导包 c3p0-0.9.1.2

工具类

public class ConnectionUtils {
    private static ComboPooledDataSource cpds=new ComboPooledDataSource();

    public static Connection getConnection() throws SQLException {
        return cpds.getConnection();
    }

    public static ComboPooledDataSource getDataSource(){
        return cpds;
    }
}

还要写个相关的beans  类

public class QueryRunnerTest {
    //使用无参数的QueryRunner
    public void fun1() throws SQLException {
        String sql="select * from worker";
        QueryRunner runner=new QueryRunner();//事物手动控制

        Connection con= ConnectionUtils.getConnection();
        List<Worker> list=runner.query(con,sql,new BeanListHandler<Worker>(Worker.class));

        System.out.println(list);
    }

    //使用有参数的QueryRunner
    public void fun2() throws SQLException {
        String sql="select * from worker where id=?";
        QueryRunner runner=new QueryRunner(ConnectionUtils.getDataSource());//事物自动控制

        List<Worker> list=runner.query(sql,new BeanListHandler<Worker>(Worker.class),2);
        System.out.println(list);
    }


    
public static void uFun2() throws Exception{
    String sql="insert into dept values(10,'ACCOUNTING','ShangHai')";

    QueryRunner runner=new QueryRunner(ConntionUtils.getDatesouce());

    System.out.println(runner.update(sql));
}
}