queryRunner和数据池

1、  新建工程，导入mysql、c3p0、dbUtil的jar包（c3p0有2个）和c3p0的配置文件

2、  设置好配置文件连接数据库的相关信息

 <?xml version="1.0"encoding="UTF-8"?>

 

<c3p0-config>

 

 <named-config name="test">

 <!-- 数据库用户名和密码 -->

  <property name="user">root</property>

   <property name="password">root</property>

     <!-- 数据库路径和加载的驱动 -->

   <property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>

   <property name="driverClass">com.mysql.jdbc.Driver</property>

     <!-- 数据池的相关设置 -->    <property name="acquireIncrement">5</property>

    <property name="initialPoolSize">10</property>

   <property name="minPoolSize">5</property>

   <property name="maxPoolSize">10</property>

 

   <property name="maxStatements">200</property>

   <property name="maxStatementsPerConnection">500</property>

 

 </named-config>

</c3p0-config>

3、  装载dbUtil，实例一个ComboPooledDataSource，并创建一个获取连接的方法getConnection和一个获取连接资源的方法

 

 public classJdbcs {

   private static ComboPooledDataSource ds = null;

   static {

      ds = new ComboPooledDataSource("test");

   }

 

   public static ConnectiongetConnection() throwsSQLException {

      return ds.getConnection();

   }

   public static DataSourcegetDataSourse(){

      return ds;

   }

}

4、      创建一个对数据库操纵的类Demo

 public classDemo {

  

   public void add(){

      QueryRunnerqr=newQueryRunner(Jdbcs.getDataSourse());

      Stringsql="insert into uservalues(?,?,?,?)";

      Objectparams[]={"11","123","name01","school01"};

      try {

        qr.update(sql,params);

      }catch(SQLException e) {

        System.out.println("添加数据出错！");

      }

   }

  

   public void delete(){

      QueryRunnerqr=newQueryRunner(Jdbcs.getDataSourse());

      Stringsql="delete from user where uid=?";

      try {

        qr.update(sql,"11");

      }catch(SQLException e) {

        System.out.println("删除数据出错！");

      }

   }

  

   public void update(){

      QueryRunnerqr=newQueryRunner(Jdbcs.getDataSourse());

      Stringsql="update user set sname=? whereuid=?";

      Objectparams[]={"zhangsan","11"};

      try {

        qr.update(sql,"11");

      }catch(SQLException e) {

        System.out.println("更新数据出错！");

      }

   }

  

   public void select(){

      QueryRunnerqr=newQueryRunner(Jdbcs.getDataSourse());

      Stringsql="select sname from user whereuid=?";

      try {

        Useru=qr.query(sql, "11", new BeanHandler(User.class));

        System.out.println(u.getSname());

      }catch(SQLException e) {

        System.out.println("更新数据出错！");

      }

   }

小伙伴们，赶快将这个方法加载到自己的项目中吧