Guest User

Untitled

a guest
Nov 20th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. public ArrayList getList(){
  2. ArrayList lst = new ArrayList();
  3. Random ran = new Random();
  4. SQLiteDatabase db = this.getReadableDatabase();
  5. Cursor c = db.rawQuery(" SELECT " +KEY_INTITULE+ " from " +TABLE_QUESTION,null);
  6. if (c.moveToFirst()) {
  7. while(c.isAfterLast()==false){
  8. String t1 = c.getString(c.getColumnIndex(KEY_INTITULE));
  9. lst.add(t1);
  10. c.moveToNext();
  11. }
  12. }
  13. return lst;
  14. }
  15.  
  16. int size = lst.size();
  17. int tmp=-1;
  18. int rnd;
  19. String randomID = new String();
  20. ArrayList <String> listrand = new ArrayList<String>();
  21. for (int j=0;j<param;j++){
  22. rnd = rand.nextInt(size)-1;
  23. if(rnd!=tmp){
  24. randomID =lst.add(rand);
  25. listrand.add(randomID);
  26. // tmp!=rnd;
  27.  
  28. }
  29. }
  30. return listrand;
  31. }
  32.  
  33. Cursor c = db.rawQuery(" SELECT " +KEY_QUESTION+ " from " +TABLE_QUESTION+ " ORDER BY RANDOM() LIMIT " +param+ ,null);
Add Comment
Please, Sign In to add comment