DBUtils的使用

DBUtils 介绍
DBUtils工具类完成 DAO 的封装 ,简化DAO层代码编写

核心类和接口是QueryRunner && ResultSetHandler,一起使用，完成数据表增删改查

QueryRunner 框架核心类 ，所有数据库操作都是必须通过 QueryRunner 进行的
ResultSetHandler 结果集封装接口，完成将ResultSet 结果集 封装为一个Java对象

封装前案例

 @Test
    public void query() throws SQLException, PropertyVetoException {
        Connection connection = JDBCUtils.getDataSource().getConnection();
        String sql = "select * from user  where username=? and password =? ";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, "ww");
        preparedStatement.setInt(2, 789);

        ResultSet resultSet = preparedStatement.executeQuery();
        User user = null;
        while (resultSet.next()) {
            int id = resultSet.getInt("id");
            String username = resultSet.getString("username");
            String password = resultSet.getString("password");
            String email = resultSet.getString("email");
            user = new User(id, username, password, email);
            System.out.println(user);
        }

    }

封装后代码,大大简化了代码

 @Test
    public void query() throws SQLException, PropertyVetoException {
        QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
        String sql = "select * from user  where username=? and password =? ";
        Object[] params = {"ww", 789};
        BeanHandler<User>