JDBC之dbutils

JDBC之dbutils"/>

JDBC之dbutils

dbutils是一个开源的JDBC工具类库，封装了针对于数据库的增删改查

以下是关于dbutils的一些使用

测试插入：

//测试插入@Testpublic void testInsert() throws Exception{Connection conn = null;try {QueryRunner runner = new QueryRunner();conn = JDBCUtils.getConnection2();String sql = "insert into customers(name,email,birth)values(?,?,?)";int insertCount = runner.update(conn,sql,"肖战","xz@qq","1997-09-08");System.out.println("添加了" + insertCount +"条记录");} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {JDBCUtils.closeResource(conn, null);}}

测试查询：

    /** BeanHandler是ResultSetHandler接口的实现类，用于封装表中的一条记录*///测试查询@Testpublic void testQuery1() {Connection conn = null;try {QueryRunner runner = new QueryRunner();conn = JDBCUtils.getConnection2();String sql = "select id,name,email,birth from customers where id = ?";BeanHandler<Customer> handler = new BeanHandler<>(Customer.class);Customer customer = runner.query(conn,sql,handler,22);System.out.println(customer);} catch (Exception e) {e.printStackTrace();} finally {JDBCUtils.closeResource(conn, null);}}

查询2：

    /** 用于封装表中的多条记录构成的集合*/@Testpublic void testQuery2()  {Connection conn = null;try {QueryRunner runner = new QueryRunner();conn = JDBCUtils.getConnection2();String sql = "select id,name,email,birth from customers where id < ?";BeanListHandler<Customer> handler = new BeanListHandler<>(Customer.class);List<Customer> list = runner.query(conn,sql,handler,20);list.forEach(System.out::println);} catch (Exception e) {e.printStackTrace();} finally {JDBCUtils.closeResource(conn, null);}}

查询3：

    /** MapHandler是ResultSetHandler接口的实现类，用于封装表中的一条记录* 将字段及相应字段的集作为map中的key和value*///测试查询@Testpublic void testQuery3() {Connection conn = null;try {QueryRunner runner = new QueryRunner();conn = JDBCUtils.getConnection2();String sql = "select id,name,email,birth from customers where id = ?";MapHandler handler = new MapHandler();Map<String, Object> map = runner.query(conn,sql,handler,22);System.out.println(map);} catch (Exception e) {e.printStackTrace();} finally {JDBCUtils.closeResource(conn, null);}}

查询4：

/** MapListHandler是ResultSetHandler接口的实现类，用于封装表中的多条记录* 将字段及相应字段的集作为map中的key和value*///测试查询@Testpublic void testQuery4() {Connection conn = null;try {QueryRunner runner = new QueryRunner();conn = JDBCUtils.getConnection2();String sql = "select id,name,email,birth from customers where id = ?";MapListHandler handler = new MapListHandler();List<Map<String, Object>> list = runner.query(conn,sql,handler,22);list.forEach(System.out::println);} catch (Exception e) {e.printStackTrace();} finally {JDBCUtils.closeResource(conn, null);}}