举一反三
- 已知，存在 QueryRunner对象 runner ， SQL语句： String sql = "select * from user where id=?"; 下面操作中，能实现查询指定记录的选项是（）
- 已知,存在 QueryRunner对象 runner ,SQL语句: String sql = "delete from user where id=?"; 下面操作中,能实现删除记录id=1的操作是() A: int num =runner.delete(sql, 1); B: int num =runner.update(sql, 1); C: Object num =runner.delete(1, sql); D: Object num =runner.update(1, sql);
- 已知，存在 QueryRunner对象 runner ，SQL语句：String sql = "delete from user where id=?";下面操作中，能实现删除记录id=1的操作是（ ） A: Object num =runner.update(1, sql); B: Object num =runner.delete(1, sql); C: int num =runner.delete(sql, 1); D: int num =runner.update(sql, 1);
- 已知,存在 QueryRunner对象 runner , SQL语句: String sql = "select * from user where id=?"; 下面操作中,能实现查询指定记录的选项是() A: User user=(User)runner.query(sql, new BeanListHandler(User.class), new Object[]{id}); B: User user=(User)runner.query(sql, new BeanHandler(User.class)); C: User user=(User)runner.query(sql, new BeanListHandler(User.class), id); D: User user=(User)runner.query(sql, new BeanHandler(User.class), new Object[]{id});
- 已知，存在 QueryRunner对象 runner ， SQL语句：String sql = "select * from user";下面操作中，能实现查询所有记录的选项是（） A: List<;User>; list=runner.query(sql, newBeanHandler<;User>;(User.class)); B: List<;User>; list=runner.query(sql, new BeanListHandler<;User>;(User.class));Object num =runner.delete(1, sql); C: Object list=runner.query(sql, new BeanHandler<;User>;(User.class)); D: List list=runner.query(sql, new BeanHandler<;User>;(User.class));
内容
- 0
已知，存在 QueryRunner对象 runner ， SQL语句：String sql = "select * from user";下面操作中，能实现查询所有记录的选项是（ ） A: Object list=runner.query(sql, new BeanHandler＜User＞(User.class)); B: List list=runner.query(sql, new BeanHandler＜User＞(User.class)); C: List＜User＞ list=runner.query(sql, new BeanHandler＜User＞(User.class)); D: List＜User＞ list=runner.query(sql, new BeanListHandler＜User＞(User.class));Object num =runner.delete(1, sql);
- 1
删除demo表中id为1001的记录。其SQL语句为（ ）。 A: delete from demo where id=1001 B: delete demo C: delete from dmeo where id=1001 D: delete demo where id=1001
- 2
【多选题】已知user表中存在一个字段id。 下面选项中,能够查询出id编号为u001和u002的用户的SQL语句是 A. select * from user where id = 'u001' and id = 'u002'; B. select * from user where id = 'u001' or id = 'u002'; C. select * from user where
- 3
下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
- 4
删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;