SQLite 问题
db.execSQL("create table testreport(_id integer primary key autoincrement,"
+ "date varchar(20))," //日期
+ "time varchar(20)," //时间
+ "name varchar(20)," //名字
+ "sex varchar(20)," //性别
+ "yuwen varchar(20)," //语文
+ "shuxue varchar(20)," //数学
+ "yingyu varchar(20)" //英语
);
db.execSQL("create table testsubject(_id integer primary key autoincrement,"
+ "yuwen varchar(20)," //语文
+ "shuxue varchar(20)," //数学
+ "yingyu varchar(20)" //英语
);
问题1:_id integer primary key autoincrement要与不要有什么关系。问题2:用SQLite做的学生管理系统,考试科目是放在设置里可以勾选的,默认没改动情况下是全选的,勾选那个就考哪里,然后考试报告根据勾选那个就显示那个结果;不知道用什么方法去取得testsubject哪些是勾选的,然后用listview显示报告。本人菜鸟一枚,望大神回复时贴上代码,指点下。