c++实战学习OpenCV3.2+QT5+ffmpeg实战开发视频编辑器视频教程
public static void testFindById() throws SQLException {
// 使用DBUtils执行查询一行数据
// 查询一行数据转换成User对象
QueryRunner queryRunner = new QueryRunner(JDBCTools.getDataSource());
// 编写SQL语句
String sql = "select * from user where id=?";
// queryRunner执行查询的SQL语句，使用query()方法
User user = queryRunner.query(sql, new BeanHandler<>(User.class), 1);
System.out.println(user);
}
public static void testFindMore() throws SQLException {
// 查询多条数据转换成User对象
QueryRunner queryRunner = new QueryRunner(JDBCTools.getDataSource());
// 编写SQL语句
String sql = "select * from user where id<?";
List<User> userList = queryRunner.query(sql, new BeanListHandler<>(User.class), 10);
for (int i = 0; i < userList.size(); i++) {
System.out.println(userList.get(i));
}
}
