JDBC-Apache_DBUtils

select

public class ApDBUtils_use {
    public void testQueryMany() throws SQLException {// 返回结果是多行的情况
        Connection connection = JDBCUtilsByDruid.getConnection();

        // 创建QueryRunner对象
        QueryRunner queryRunner = new QueryRunner();
        String sql = "select * from actor where id >= ?";
        // 1.connection -> 链接
        // 2.sql -> sql语句
        // 3.new BeanListHandler<>(Actor.class) -> 传入Actor.class，通过反射机制得到Actor的属性->封装到ArrayList
        // 4.参数1 -> 替代占位符？，可以传入多个参数
        List<Actor> list = queryRunner.query(connection, sql, new BeanListHandler<>(Actor.class), 1);
        for (Actor a: list) {
            System.out.println("\n" + a);
        }

        // query获取到ArrayList之后自动关闭ResultSet和preparedStatement，所以只需要关闭connection
        connection.close();
    }
    public void testQuerySingle() throws Exception{
        Connection connection = JDBCUtilsByDruid.getConnection();

        // 创建QueryRunner对象
        QueryRunner queryRunner = new QueryRunner();
        String sql = "select * from actor where id = ?";

        // 返回单行记录<-->单个对象new BeanHandler<>(Actor.class)
        Actor actor = queryRunner.query(connection, sql, new BeanHandler<>(Actor.class), 4);
        System.out.println(actor);

        connection.close();
    }

    public void testQueryObject() throws Exception{// 返回单行单列，也就是返回一个object
        Connection connection = JDBCUtilsByDruid.getConnection();

        // 创建QueryRunner对象
        QueryRunner queryRunner = new QueryRunner();

        String sql = "select name from actor where id = ?";

        // new ScalarHandler()返回一个对象
        Object o = queryRunner.query(connection, sql, new ScalarHandler(), 4);
        System.out.println(o);

        connection.close();
    }
}

DML

public void testDML() throws Exception{
        Connection connection = JDBCUtilsByDruid.getConnection();

        // 创建QueryRunner对象
        QueryRunner queryRunner = new QueryRunner();

        String sql = "update actor set name = ? where id = ?";
        // queryRunner.update可以执行dml操作
        // 返回值是受影响的行数
        queryRunner.update(connection,sql,"cyt",1);

        connection.close();
    }