c3p0连接池加 dbutils

最新推荐文章于 2019-02-28 10:13:03 发布

原创最新推荐文章于 2019-02-28 10:13:03 发布 · 288 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个基于C3P0的数据库连接池配置文件示例，并展示了如何通过Java代码利用此连接池获取数据库连接。文中还提供了两个使用QueryRunner执行SQL查询的方法示例，包括无参数和带参数的查询。

配置文件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));
}
}

c3p0连接池 加 dbutils

c3p0连接池加 dbutils