Guest User

Untitled

a guest
Aug 14th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. Android fetch multiple items from sqlite database
  2. public String fetchDay(long rowId) throws SQLException {
  3.  
  4. Cursor mCursor =
  5.  
  6. mapDb.query(true, DAY_TABLE, new String[] {KEY_ROWID, KEY_DAY}, KEY_ROWID + "=" + String.valueOf(rowId), null,
  7. null, null, null, null);
  8. if (mCursor != null) {
  9. mCursor.moveToFirst();
  10. }
  11. String result = mCursor.getString(mCursor.getColumnIndex(KEY_DAY));
  12. mCursor.close();
  13. return result;
  14.  
  15. }
  16.  
  17. KEY_ROWID + " >= " + String.valueOf(firstRowId) + " AND " + KEY_ROWID + " <= " + String.valueOf(lastRowId)
  18.  
  19. mCursor.moveToFirst();
  20. while (!mCursor.isAfterLast()) {
  21. results.add(mCursor.getString(mCursor.getColumnIndex(KEY_DAY)));
  22. mCursor.moveToNext();
  23. }
Add Comment
Please, Sign In to add comment