A、insert into userinfo(uname,password) values('张三','123');
B、insert into userinfo(uname,password) values(张三,123);
C、insert into userinfo values(null,'张三','123');
D、insert into userinfo(password,uname) values('123','张三');
第1题
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[]{"李四"}); ... }
第2题
A、private void delete(SQLiteDatabase db){ ... String sql="delete from userinfo where uname='张三'"; db.execSQL(sql); ... }
B、private void delete(SQLiteDatabase db){ ... db.delete("userinfo","uname = ?",new String[]{"张三"}) ... }
C、private void delete(SQLiteDatabase db){ ... String sql="delete from userinfo where uname=张三"; db.execSQL(sql); ... }
D、private void delete(SQLiteDatabase db){ ... String uname = "张三"; db.execSQL("delete from userinfo where uname='"+uname+"'"); ... }
第3题
A、private void update(SQLiteDatabase db){ ... String sql="update from userinfo set password = '321' where uname='李四'"; db.execSQL(sql); ... }
B、private void update(SQLiteDatabase db){ ... String sql="update userinfo set password = '321' where uname='李四'"; db.execSQL(sql); ... }
C、private void delete(SQLiteDatabase db){ ... ContentValues cv = new ContentValues(); cv.put("password","321"); db.update("userinfo",cv,"uname = ?",new String[]{"张三"}) ... }
D、private void update(SQLiteDatabase db){ ... String sql="update userinfo password = '321' where uname='李四'"; db.execSQL(sql); ... }
第6题
1).创建一个版本为1的“diaryOpenHelper.db”的数据库,
2).同时创建一个 “diary” 表(包含一个_id主键并自增长,topic字符型100长度, content字符型1000长度)
3).在数据库版本变化时请删除diary表,并重新创建出diary表。
第7题
单位:万人 | |||||||||||
年份 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 |
增长人口 | 869 | 885 | 899 | 913 | 926 | 936 | 948 | 960 | 971 | 983 | 993 |
要求:判断表中数列是否属于直线型,若为直线型,则运用最小二乘法配合直线方程,并根据直线方程求各年人口增长趋势值。
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!