【单选题】现有用户信息表userinfo,表结构如下:id integer 主键,自增长;uname text 用户名;password text 密码。如果想查询用户名为李四的用户信息,下面方法不正确的是()
A.
private void select(SQLiteDatabase db){ ... String sql="select * from where uname='李四'"; Cursor cursor = db.rawQuery(sql,null); ... }
B.
private void select(SQLiteDatabase db){ ... String sql="select * from where uname=?"; Cursor cursor = db.rawQuery(sql,new String[]{"李四"}); ... }
C.
private void select(SQLiteDatabase db){ ... Cursor cursor = db.query("userinfo",new String[]{"id","uname","password"},"uname=?",new String[]{"李四"},null,null,null,null); ... }
D.
private void select(SQLiteDatabase db){ ... Cursor cursor = db.query("userinfo",new String[]{"id","uname","password"},"uname=?",null,null,null,null,new String[]{"李四"}); ... }