samedi 19 mars 2016

SQL Lite Randomise

My SqlLite problem: its not random query. how i can randomise? i used android studio.

public List<Question> getAllQuestions() {
List<Question> quesList = new ArrayList<Question>();
// Select All Query
String selectQuery = "SELECT  * FROM " + TABLE_QUEST;
dbase = this.getReadableDatabase();
Cursor cursor = dbase.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
    do {
        Question quest = new Question();
        quest.setID(cursor.getInt(0));
        quest.setQUESTION(cursor.getString(1));
        quest.setANSWER(cursor.getString(2));
        quest.setOPTA(cursor.getString(3));
        quest.setOPTB(cursor.getString(4));
        quest.setOPTC(cursor.getString(5));

        quesList.add(quest);
    } while (cursor.moveToNext());
}
// return quest list
return quesList;

}

i try this down code but not work and activity stopped

SELECT * FROM table ORDER BY RANDOM() LIMIT 1;

Aucun commentaire:

Enregistrer un commentaire