Cursor cursor; ... //fill the cursor here for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { // do what you need with the cursor here }
List<String> emails = new ArrayList<String>(); cursor.moveToFirst(); while (!cursor.isAfterLast()) { emails.add(cursor.getString(ProfileQuery.ADDRESS)); cursor.moveToNext();
public static final int getSongCountForAlbumInt(final Context context, final long id) { int songCount = 0; if (id == -1) { return songCount; } Uri uri = ContentUris.withAppendedId(MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI, id); Cursor cursor = context.getContentResolver().query(uri, new String[]{MediaStore.Audio.AlbumColumns.NUMBER_OF_SONGS}, null, null, null); if (cursor != null) { cursor.moveToFirst(); if (!cursor.isAfterLast()) { if (!cursor.isNull(0)) { songCount = cursor.getInt(0); } } cursor.close(); cursor = null; } return songCount; }
Cursor c = db.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null); if (c.moveToFirst()) { while ( !c.isAfterLast() ) { Toast.makeText(activityName.this, "Table Name=> "+c.getString(0), Toast.LENGTH_LONG).show(); c.moveToNext(); } }
public static final int getSongCountForAlbumInt(final Context context, final long id) { int songCount = 0; if (id == -1) { return songCount; } Uri uri = ContentUris.withAppendedId(MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI, id); Cursor cursor = context.getContentResolver().query(uri, new String[]{MediaStore.Audio.AlbumColumns.NUMBER_OF_SONGS}, null, null, null); if (cursor != null) { cursor.moveToFirst(); if (!cursor.isAfterLast()) { if (!cursor.isNull(0)) { songCount = cursor.getInt(0); } } cursor.close(); cursor = null; } return songCount; }
private void cleanupSelected(Cursor cursor) { if (selected.isEmpty()) { return; } Set<Long> selected = new HashSet<>(); for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { long uniqueId = cursor.getLong(uniqueIdColumn); if (this.selected.contains(uniqueId)) { selected.add(uniqueId); } } this.selected = selected; }
ArrayList<String> arrTblNames = new ArrayList<String>(); Cursor c = db.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null); if (c.moveToFirst()) { while ( !c.isAfterLast() ) { arrTblNames.add( c.getString( c.getColumnIndex("name")) ); c.moveToNext(); } }
Uri rawContactUri = null; Cursor rawContactCursor = managedQuery( RawContacts.CONTENT_URI, new String[] {RawContacts._ID}, RawContacts.CONTACT_ID + " = " + contactData.getLastPathSegment(), null, null); if(!rawContactCursor.isAfterLast()) { rawContactCursor.moveToFirst(); rawContactUri = RawContacts.CONTENT_URI.buildUpon().appendPath(""+rawContactCursor.getLong(0)).build(); } rawContactCursor.close();
/** * Close the context menu when the message it was opened for is no longer in the message list. */ private void updateContextMenu(Cursor cursor) { if (contextMenuUniqueId == 0) { return; } for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { long uniqueId = cursor.getLong(uniqueIdColumn); if (uniqueId == contextMenuUniqueId) { return; } } contextMenuUniqueId = 0; Activity activity = getActivity(); if (activity != null) { activity.closeContextMenu(); } }
public ArrayList<String> getAllCars() { ArrayList<String> arrayList = new ArrayList<>(); //hp = new HashMap(); SQLiteDatabase db = this.getReadableDatabase(); Cursor res = db.rawQuery("select * from cars", null); res.moveToFirst(); while (!res.isAfterLast()) { arrayList.add(res.getString(res.getColumnIndex(CARS_COLUMN_NAME))); res.moveToNext(); } return arrayList; }
Cursor cursor = database.query( CityAndAirportsTable.notificationsTable, new String[] { CityAndAirportsTable.notifyFlightId }, null, null, null, null, "Id DESC" ); cursor.moveToFirst(); while( !cursor.isAfterLast() ){ String id = String.valueOf( cursor.getInt( 0 ) ); Cursor flightCursor = database.query( CityAndAirportsTable.flightTable, new String[] { CityAndAirportsTable.fromDestinationCode, CityAndAirportsTable.toDestinationCode, CityAndAirportsTable.currentPrice }, CityAndAirportsTable.flightId + "=" + id, null, null, null, null ); /* Close the cursor here! */ flightCursor.close(); /* ---------------------- */ }
@Test public void testUpdateAll() throws Exception { addChuck(); addJulie(); assertThat(updateName("Belvedere")).isEqualTo(2); Cursor cursor = database.query("table_name", new String[]{"id", "name"}, null, null, null, null, null); assertThat(cursor.moveToFirst()).isTrue(); assertThat(cursor.getCount()).isEqualTo(2); assertIdAndName(cursor, 1234L, "Belvedere"); assertThat(cursor.moveToNext()).isTrue(); assertIdAndName(cursor, 1235L, "Belvedere"); assertThat(cursor.isLast()).isTrue(); assertThat(cursor.moveToNext()).isFalse(); assertThat(cursor.isAfterLast()).isTrue(); assertThat(cursor.moveToNext()).isFalse(); }
public ArrayList<String> getAllCotacts() { ArrayList<String> arrayList = new ArrayList<>(); //hp = new HashMap(); SQLiteDatabase db = this.getReadableDatabase(); Cursor res = db.rawQuery("select * from contacts", null); res.moveToFirst(); while (!res.isAfterLast()) { arrayList.add(res.getString(res.getColumnIndex(CONTACTS_COLUMN_NAME))); res.moveToNext(); } return arrayList; }
private void mapCursorToModels(Cursor c) { videos.clear(); int idColumn=c.getColumnIndex(MediaStore.Video.Media._ID); int uriColumn=c.getColumnIndex(MediaStore.Video.Media.DATA); int mimeTypeColumn= c.getColumnIndex(MediaStore.Video.Media.MIME_TYPE); int titleColumn= c.getColumnIndex(MediaStore.Video.Media.TITLE); for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) { videos.add(new Video(c.getInt(idColumn), c.getString(uriColumn), c.getString(mimeTypeColumn), c.getString(titleColumn))); } c.close(); } }
public static final String getReleaseDateForAlbum(final Context context, final long id) { if (id == -1) { return null; } Uri uri = ContentUris.withAppendedId(MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI, id); Cursor cursor = context.getContentResolver().query(uri, new String[]{ MediaStore.Audio.AlbumColumns.FIRST_YEAR }, null, null, null); String releaseDate = null; if (cursor != null) { cursor.moveToFirst(); if (!cursor.isAfterLast()) { releaseDate = cursor.getString(0); } cursor.close(); cursor = null; } return releaseDate; }
String[] proj = new String[] { Browser.BookmarkColumns.TITLE, Browser.BookmarkColumns.URL }; String sel = Browser.BookmarkColumns.BOOKMARK + " = 0"; // 0 = history, 1 = bookmark Cursor mCur = getContentResolver().query(Browser.BOOKMARKS_URI, proj, sel, null, null); mCur.moveToFirst(); @SuppressWarnings("unused") String title = ""; @SuppressWarnings("unused") String url = ""; if (mCur.moveToFirst() && mCur.getCount() > 0) { boolean cont = true; while (mCur.isAfterLast() == false && cont) { title = mCur.getString(mCur.getColumnIndex(Browser.BookmarkColumns.TITLE)); url = mCur.getString(mCur.getColumnIndex(Browser.BookmarkColumns.URL)); // Do something with title and url mCur.moveToNext(); } }
public static final String getReleaseDateForAlbum(final Context context, final long id) { if (id == -1) { return null; } Uri uri = ContentUris.withAppendedId(MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI, id); Cursor cursor = context.getContentResolver().query(uri, new String[]{ MediaStore.Audio.AlbumColumns.FIRST_YEAR }, null, null, null); String releaseDate = null; if (cursor != null) { cursor.moveToFirst(); if (!cursor.isAfterLast()) { releaseDate = cursor.getString(0); } cursor.close(); cursor = null; } return releaseDate; }
public ArrayList<String> getAllPerson() { ArrayList<String> arrayList = new ArrayList<>(); SQLiteDatabase db = this.getReadableDatabase(DB_PASSWORD); Cursor res = db.rawQuery("select * from person", null); res.moveToFirst(); while (!res.isAfterLast()) { arrayList.add( res.getString(res.getColumnIndex(PERSON_COLUMN_FIRST_NAME)) + " " + res.getString(res.getColumnIndex(PERSON_COLUMN_LAST_NAME))); res.moveToNext(); } res.close(); db.close(); return arrayList; }
String[] proj = new String[] { Browser.BookmarkColumns.TITLE,Browser.BookmarkColumns.URL }; Uri uriCustom = Uri.parse("content://com.android.chrome.browser/bookmarks"); String sel = Browser.BookmarkColumns.BOOKMARK + " = 0"; // 0 = history, 1 = bookmark Cursor mCur = getContentResolver().query(uriCustom, proj, sel, null, null); mCur.moveToFirst(); @SuppressWarnings("unused") String title = ""; @SuppressWarnings("unused") String url = ""; if (mCur.moveToFirst() && mCur.getCount() > 0) { boolean cont = true; while (mCur.isAfterLast() == false && cont) { title = mCur.getString(mCur.getColumnIndex(Browser.BookmarkColumns.TITLE)); url = mCur.getString(mCur.getColumnIndex(Browser.BookmarkColumns.URL)); // Do something with title and url mCur.moveToNext(); } }
public static void dropAllTable(SQLiteDatabase db) { List<String> tables = new ArrayList<String>(); Cursor cursor = db.rawQuery("SELECT * FROM sqlite_master WHERE type='table';", null); cursor.moveToFirst(); while (!cursor.isAfterLast()) { String tableName = cursor.getString(1); if (!tableName.equals("android_metadata") && !tableName.equals("sqlite_sequence")) tables.add(tableName); cursor.moveToNext(); } cursor.close(); for(String tableName : tables) { dropTable(db, tableName); } }