阿帕奇实现CRUD实例

增删改:

  public void testInsert() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       String sql = "insert into customers(name,email,birth) values(?,?,?)";

       int insertCount = runner.update(conn, sql, "周杰伦", "zhou@126.com", "1987-09-19");

       System.out.println("添加了" + insertCount + "条记录");

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

测试查询

BeanHander:是ResultSetHandler接口的实现类,用于封装表中的一条记录

  public void testQuery1() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       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, 25);

     System.out.println(customer);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

BeanListHandler:是ResultSetHandler接口的实现类,用于封装表中多条记录构成的集合.

 

  public void testQuery2() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       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, 25);

     list.forEach(System.out::println);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

MapHandler:是ResultSetHandler接口的实现类,对应表中的一条记录. 将字段及相应字段的值作为Map中的key和value

  public void testQuery3() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       String sql = "select id,name,email,birth from customers where id = ?";

       MapHandler handler = new MapHandler();

       Map<String, Object> map = runner.query(conn, sql, handler, 25);

       System.out.println(map);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

MapListHandler:是ResultSetHandler接口的实现类,对应表中的多条记录. 将字段及相应字段的值作为Map中的key和value,将这些map添加到List中

  public void testQuery4() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       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, 25);

     list.forEach(System.out::println);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

ScalarHandler: 用于查询特殊值

 

  public void testQuery5() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       String sql = "select count(*) from customers";

       ScalarHandler handler = new ScalarHandler();

       Long count = (Long) runner.query(conn, sql, handler);

       System.out.println(count);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

  }

  public void testQuery6() {

     Connection conn = null;

     try {

       QueryRunner runner = new QueryRunner();

       conn = JDBCUtils.getConnection3();

       String sql = "select max(birth) from customers";

       ScalarHandler handler = new ScalarHandler();

       Date date = (Date) runner.query(conn, sql, handler);

       System.out.println(date);

     } catch (Exception e) {

       e.printStackTrace();

     } finally {

     JDBCUtils.clossResource(conn, null);

     }

}