DbUtils

是一个把jdbc进行简单封装的工具包，能够简化代码

Maven

<dependency>
    <groupId>commons-dbutils</groupId>
    <artifactId>commons-dbutils</artifactId>
    <version>1.8.1</version>
</dependency>

核心类

QueryRunner类：执行SQL语句的类
ResultSetHandler接口：转换类型接口
MapListHandler类：实现类，把记录转化成List
BeanListHandler类：实现类，把记录转化成List，使记录为JavaBean类型的对象

核心方法（QueryRunner）

update()：执行insert、update、delete操作
query()：执行select语句
batch()：执行批处理操作

示例代码 - 连接池德鲁伊

update

public void insert() {
    QueryRunner queryRunner = new QueryRunner(DruidUtils.getDataSource());
    String sql = "insert into product value (?,?)";
    queryRunner.update(sql, "属性1", "属性2");
}

query()

返回集合

public void select() {
    QueryRunner queryRunner = new QueryRunner(DruidUtils.getDataSource());
    String sql = "select * from product";
    List<Map<String, Object>> query = queryRunner.query(sql, new MapListHandler());
    for (Map<String, Object> stringObjectMap : query) {
        System.out.println(stringObjectMap);
    }
}

映射到实例

public void select2() throws SQLException {
    QueryRunner queryRunner = new QueryRunner(DruidUtils.getDataSource());
    String sql = "select * from product";
    List<类名> query = queryRunner.query(sql, new BeanListHandler<类名>(类名.class));
    for (product product : query) {
        System.out.println(product);
    }
}