Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Android fetch multiple items from sqlite database
- public String fetchDay(long rowId) throws SQLException {
- Cursor mCursor =
- mapDb.query(true, DAY_TABLE, new String[] {KEY_ROWID, KEY_DAY}, KEY_ROWID + "=" + String.valueOf(rowId), null,
- null, null, null, null);
- if (mCursor != null) {
- mCursor.moveToFirst();
- }
- String result = mCursor.getString(mCursor.getColumnIndex(KEY_DAY));
- mCursor.close();
- return result;
- }
- KEY_ROWID + " >= " + String.valueOf(firstRowId) + " AND " + KEY_ROWID + " <= " + String.valueOf(lastRowId)
- mCursor.moveToFirst();
- while (!mCursor.isAfterLast()) {
- results.add(mCursor.getString(mCursor.getColumnIndex(KEY_DAY)));
- mCursor.moveToNext();
- }
Add Comment
Please, Sign In to add comment