Advertisement
dekzcoding

sqlite get list

Jun 3rd, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.69 KB | None | 0 0
  1. public List<User> getAllUsers(){
  2.         List<User> userList = new ArrayList<User>();
  3.  
  4.         String selectAllUserQuery = "SELECT * FROM "+TABLE_USER;
  5.         SQLiteDatabase db = this.getWritableDatabase();
  6.         Cursor cursor = db.rawQuery(selectAllUserQuery, null);
  7.  
  8.         if (cursor.moveToFirst()){
  9.             do {
  10.                 User user = new User();
  11.                 user.setUserID(Integer.parseInt(cursor.getString(0)));
  12.                 user.setUserUsername(cursor.getString(1));
  13.                 user.setUserPassword(cursor.getString(2));
  14.                 user.setUserFullname(cursor.getString(3));
  15.             }while (cursor.moveToNext());
  16.         }
  17.         return userList;
  18.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement