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: 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);
- 已知,存在 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));
- 已知,存在 QueryRunner对象 runner , SQL语句: String sql = "select * from user where id=?"; 下面操作中,能实现查询指定记录的选项是()
- 已知,存在 QueryRunner对象 runner ,SQL语句: String sql = "delete from user where id=?"; 下面操作中,能实现删除记录id=1的操作是()
- 【多选题】已知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
内容
- 0
已知用户表 user 有多列,其中字段 id 没有 NULL 值,字段username有NULL值,选项中,不能获得 user 表的总记录数量的 SQL 语句是 A: SELECT COUNT (*) FROM user ; B: SELECT COUNT ( id ) FROM user ; C: SELECT COUNT ( username ) FROM user ; D: SELECT COUNT ( id ) FROM user WHERE 1=1;
- 1
下面选项中,能够更新user表中数据的SQL语句是() A: update into user set id = 'u001'; B: update user set id = 'u001' and username='jack'; C: update user set username='jack' where id = 1; D: update into user set id = 'u001', username='jack';
- 2
假定用户表user有多列,其中字段id中没有null值,字段username中存在null值。下面选项中,不能获得user表的总记录数的SQL语句是( ) A: select count(*) from user; B: select count(id) from user; C: select count(username) from user; D: select count(id) from user where1=1;
- 3
使用SQLiteDatabase对象db,从user表中查找name为tom的记录,使用的语句为: A: db. query("user",null,"name=?",new String[]{"tom"},null,null,null) B: db. query("user",null,"name",new String[]{"tom"},null,null,null) C: db. query("user",null,"name=?",new String[]{tom},null,null,null) D: db. query("user",null,"name=tom",null,null,null,null)
- 4
下面声明一个对象数组正确的是() A: Userinfo user[] =new user[4]; B: Userinfo[] user=new Userinfo[4]; C: Userinfo[4] user=new Userinfo(); D: Userinfo[] user[4]=new Userinfo();