1 <dependency>
 2     <groupId>commons-dbutils</groupId>
 3     <artifactId>commons-dbutils</artifactId>
 4     <version>1.7</version>
 5 </dependency>
 6 
 7 <!-- 连接池 -->
 8 <dependency>
 9    <groupId>com.mchange</groupId>
10    <artifactId>c3p0</artifactId>
11    <version>0.9.5.4</version>
12 </dependency>

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<!-- 默认配置，只可以出现一次 -->
    <default-config>
        <!-- 配置JDBC 四个基本属性 -->
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&amp;useSSL=false
        </property>
        <property name="user">root</property>
        <property name="password">123456</property>
        <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
        <property name="acquireIncrement">3</property>
        <!-- 初始化数据库连接池时连接的数量 -->
        <property name="initialPoolSize">5</property>
        <!-- 数据库连接池中的最小的数据库连接数 -->
        <property name="minPoolSize">2</property>
        <!-- 数据库连接池中的最大的数据库连接数 -->
        <property name="maxPoolSize">10</property>
    </default-config>
</c3p0-config>

//获取c3p0连接池对象
ComboPooledDataSource ds = new ComboPooledDataSource();
QueryRunner runner = new QueryRunner(ds);
String sql2 = "select * from fan_test";
try {
　　　//获取list<Map>
    List<Map<String, Object>> list = (List) runner.query(sql2, new MapListHandler());
    //System.out.println(list);
    for (Object object : list) {
        System.out.println(object);
    }
} catch (SQLException e) {
    e.printStackTrace();
    }

//获取指定数据
private static void findOneMap(Integer id) {
           ComboPooledDataSource ds = new ComboPooledDataSource();
           QueryRunner runner = new QueryRunner(ds);
            String sql = "select * from fan_test where id=?";
             
            try {
                Map map = runner.query(sql, new MapHandler(), uid);
                System.out.println(map);
                
            } catch (SQLException e) {
                e.printStackTrace();
            }
    }
public static void main(String[] args) {
          findOneMap(1);  
    }

 1 public class JDBCUtils {
 2 
 3     // 获得c3p0连接池对象
 4     private static ComboPooledDataSource ds = new ComboPooledDataSource();
 5 /**
 6      * 获得数据库连接对象
 7      *
 8      * @return
 9      * @throws SQLException
10      */
11     public static Connection getConnection() throws SQLException {
12         return ds.getConnection();
13     }
14 
15     /**
16      * 获得c3p0连接池对象
17      * 
18      * @return
19      */
20     public static DataSource getDataSource() {
21         return ds;
22     }    
23 }
24 
25     /**
26      * 删除和添加测试
27      * @throws SQLException
28      */
29 private static void add() throws SQLException {
30     QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
31     //删除
32     runner.update("delete from t_user_test");
33     //添加
34     for (int i = 0; i < 1000; i++) {
35             Object[] objects= new Object[] {UUID.randomUUID().toString(),"test"+i, "pass"+i};
36             runner.update("insert INTO t_user_test(uid,loginname,loginpass) values(?,?,?)", objects);
37         }
38     }

 1 /**
 2 * 修改测试
 3 * @throws SQLException
 4 */
 5 private static void update() throws SQLException {
 6     //ComboPooledDataSource ds = new ComboPooledDataSource();
 7     // dbutis使用数据源
 8     QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
 9     // 可变变量  无限 也可以没有 也可以数组
10     Object[] objects= new Object[] {"123_test","333_test", "14ba4bd0-a0da-4a2c-b136-de036b54e98a"};
11     //runner.update("update t_user_test set loginname=?,loginpass=? where uid=?", "123_dbutils","123_dbutils","14ba4bd0-a0da-4a2c-b136-de036b54e98a");
12     runner.update("update t_user_test set loginname=?,loginpass=? where uid=?", objects);
13     }