Android sqlite从数据库随机获取数据

Question

我的数据库包含问题，每个问题有三个选项。一切工作正常，但当我试图得到的问题和选项随机它给我错误:

我发现了与我的问题类似的问题，但它也不起作用，

下面是我的代码:

public List<Test> getTest() {
List<Test> MyList = new ArrayList<Test>();
myDB=this.getReadableDatabase();
Cursor cursor = myDB.rawQuery("SELECT  * FROM " + My_Table + "ORDER BY RANDOM() LIMIT 1", null);
if (cursor.moveToFirst()) {
do {
Test newQ = new Test();
newQ .setId(cursor.getInt(0));
newQ .setTest(cursor.getString(1));
newQ .setAns(cursor.getString(2));
newQ .setO1(cursor.getString(3));
newQ .setO2(cursor.getString(4));
newQ .setO3(cursor.getString(5));
MyList .add(newQ );
} while (cursor.moveToNext());
}
return MyList ;}

当我将这行添加到我的代码中时:

ORDER BY RANDOM() LIMIT 1

Answer 1

您还需要引用SQL的ORDER BY部分作为Java字符串文字:

"SELECT  * FROM " + My_Table + " ORDER BY RANDOM() LIMIT 1"