Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ArrayList getList(){
- ArrayList lst = new ArrayList();
- Random ran = new Random();
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor c = db.rawQuery(" SELECT " +KEY_INTITULE+ " from " +TABLE_QUESTION,null);
- if (c.moveToFirst()) {
- while(c.isAfterLast()==false){
- String t1 = c.getString(c.getColumnIndex(KEY_INTITULE));
- lst.add(t1);
- c.moveToNext();
- }
- }
- return lst;
- }
- int size = lst.size();
- int tmp=-1;
- int rnd;
- String randomID = new String();
- ArrayList <String> listrand = new ArrayList<String>();
- for (int j=0;j<param;j++){
- rnd = rand.nextInt(size)-1;
- if(rnd!=tmp){
- randomID =lst.add(rand);
- listrand.add(randomID);
- // tmp!=rnd;
- }
- }
- return listrand;
- }
- Cursor c = db.rawQuery(" SELECT " +KEY_QUESTION+ " from " +TABLE_QUESTION+ " ORDER BY RANDOM() LIMIT " +param+ ,null);
Add Comment
Please, Sign In to add comment