我用 SQLite 做了一個(gè)測驗(yàn),但它很混亂,我不明白如何在代碼中存儲(chǔ)問題,因?yàn)槲抑幌腼@示 15 個(gè)問題,但我想總共有 100 個(gè)問題。我嘗試用 SQLite 存儲(chǔ)它們,但我只是不明白它是如何工作的。私有 SQLiteDatabase 數(shù)據(jù)庫;public QuizDbHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION);}@Overridepublic void onCreate(SQLiteDatabase db) { this.db = db; final String SQL_CREATE_QUESTIONS_TABLE = "CREATE TABLE " + QuestionsTable.TABLE_NAME + " ( " + QuestionsTable._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + QuestionsTable.COLUMN_QUESTION + " TEXT, " + QuestionsTable.COLUMN_OPTION1 + " TEXT, " + QuestionsTable.COLUMN_OPTION2 + " TEXT, " + QuestionsTable.COLUMN_OPTION3 + " TEXT, " + QuestionsTable.COLUMN_OPTION4 + " TEXT, " + QuestionsTable.COLUMN_ANSWER_NR + " INTEGER" + ")"; db.execSQL(SQL_CREATE_QUESTIONS_TABLE); fillQuestionsTable();}@Overridepublic void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) { db.execSQL("DROP TABLE IF EXISTS " + QuestionsTable.TABLE_NAME); onCreate(db);}private void fillQuestionsTable(){ Question q1 = new Question("Who almost killed Thanos in the Final Battle?", "Captain America", "Iron Man", "Captain America", "Scarlet Witch",4); addQuestion(q1); etc...
添加回答
舉報(bào)
0/150
提交
取消