mercredi 18 février 2015

Generate Random Questions in Database

I have 5 table in Sqlite Database: 1.maths 2.boilogy 3.chemestry 4.physics 5.GK.


in all tables 10 Question. and finally we generate random question in test page so what the Query in Sq lite database



public ArrayList<ExamModel> getRandomQuestion() {

ArrayList<ExamModel> list = new ArrayList<ExamModel>();
ExamModel model = null;

Cursor cursor = null;

cursor=myDataBase.query(tbl_MST_CA+","+tbl_MST_Exam+","+tbl_MST_Geography, null, null, null, null, null, "RANDOM()","15");


if (cursor != null && cursor.getCount() > 0) {
cursor.moveToFirst();

for (int i = 0; i < cursor.getCount(); i++) {
model = new ExamModel();

model.setId(cursor.getInt(cursor.getColumnIndex("Id")));
model.setAns1(cursor.getString(cursor.getColumnIndex("Answer1")));
model.setAns2(cursor.getString(cursor.getColumnIndex("Answer2")));
model.setAns3(cursor.getString(cursor.getColumnIndex("Answer3")));
model.setAns4(cursor.getString(cursor.getColumnIndex("Answer4")));
model.setQuestion(cursor.getString(cursor
.getColumnIndex("Question")));
model.setTrueAnswer(cursor.getString(cursor
.getColumnIndex("TrueAnswer")));
model.setLevelId(cursor.getInt(cursor.getColumnIndex("LevelId")));
model.setExamId(cursor.getInt(cursor
.getColumnIndex("ExamIdRef")));

list.add(model);

cursor.moveToNext();
}
}
if (cursor != null)
cursor.close();


return list;
}

Aucun commentaire:

Enregistrer un commentaire