rGjvqgiB

1public QuizHelper(Context context) {
2    super(context, DATABASE_NAME, null, DATABASE_VERSION);
3}
4
5@Override
6public void onCreate(SQLiteDatabase db) {
7    dbase = db;
8    String sql = "CREATE TABLE IF NOT EXISTS " + TABLE_QUEST + " ( "
9            + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_QUES
10            + " TEXT, " + KEY_ANSWER + " TEXT, " + KEY_OPTA + " TEXT, "
11            + KEY_OPTB + " TEXT, " + KEY_OPTC + " TEXT)";
12    db.execSQL(sql);
13    addQuestion();
14    // db.close();
15
16}
17
18private void addQuestion() {
19    Question q1 = new Question("5+2 =", "7", "8", "6", "7");
20    this.addQuestion(q1);
21    Question q2 = new Question("10+10 =", "18", "19", "20", "20");
22    this.addQuestion(q2);
23    Question q3 = new Question("3+4 =", "6", "7", "8", "7");
24    this.addQuestion(q3);
25    Question q4 = new Question("6+6 =", "12", "13", "14", "12");
26    this.addQuestion(q4);
27    Question q5 = new Question("5-3 =", "1", "3", "2", "2");
28    this.addQuestion(q5);
29    Question q6 = new Question("99-98 =", "1", "0", "10", "1");
30    this.addQuestion(q6);
31    Question q7 = new Question("0×0 =", "0", "9", "1", "0");
32    this.addQuestion(q7);
33    Question q8 = new Question("8+1 =", "8", "7", "9", "9");
34    this.addQuestion(q8);
35    Question q9 = new Question("3×2 =", "6", "7", "5", "6");
36    this.addQuestion(q9);
37    // END
38}
39
40}