[ACCEPTED]-Iterate through rows from Sqlite-query-cursor

Accepted answer

Score: 111

Cursor objects returned by database queries are 2 positioned before the first entry, therefore iteration 1 can be simplified to:

while (cursor.moveToNext()) {
    // Extract data.
}

Reference from SQLiteDatabase.

Score: 82

You can use below code to go through cursor 2 and store them in string array and after 1 you can set them in four textview

String array[] = new String[cursor.getCount()];
i = 0;

cursor.moveToFirst();
while (!cursor.isAfterLast()) {
    array[i] = cursor.getString(0);
    i++;
    cursor.moveToNext();
}

Score: 29

for (boolean hasItem = cursor.moveToFirst(); hasItem; hasItem = cursor.moveToNext()) {
    // use cursor to work with current item
}

Score: 20

Iteration can be done in the following manner:

Cursor cur = sampleDB.rawQuery("SELECT * FROM " + Constants.TABLE_NAME, null);
ArrayList temp = new ArrayList();
if (cur != null) {
    if (cur.moveToFirst()) {
        do {
            temp.add(cur.getString(cur.getColumnIndex("Title"))); // "Title" is the field name(column) of the Table                 
        } while (cur.moveToNext());
    }
}

Score: 4

Found a very simple way to iterate over 1 a cursor

for(cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()){


    // access the curosr
    DatabaseUtils.dumpCurrentRowToString(cursor);
    final long id = cursor.getLong(cursor.getColumnIndex(BaseColumns._ID));


}

Score: 3

I agree to chiranjib, my code is as follow:

if(cursor != null && cursor.getCount() > 0){
  cursor.moveToFirst();
  do{
    //do logic with cursor.
  }while(cursor.moveToNext());
}

Score: 0

public void SQLfunction() {
    SQLiteDatabase db = getReadableDatabase();
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();

    String[] sqlSelect = {"column1","column2" ...};
    String sqlTable = "TableName";
    String selection = "column1= ?"; //optional
    String[] selectionArgs = {Value}; //optional

    qb.setTables(sqlTable);
    final Cursor c = qb.query(db, sqlSelect, selection, selectionArgs, null, null, null);

   if(c !=null && c.moveToFirst()){
        do {
           //do operations
           // example : abcField.setText(c.getString(c.getColumnIndex("ColumnName")))

          }
        while (c.moveToNext());
    }


}

NOTE: to use SQLiteQueryBuilder() you need 2 to add

compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' in 1 your grade file

Source: stackoverflow.com

Copying cursor data into arraylist

android.database.CursorWindowAllocationException when moving a Cursor

How To Test If Cursor Is Empty in a SQLiteDatabase Query

Sqlite how to get string items using cursor

SQLite cursor in Python with statement

Android how to query huge database in android (cursor size is limited to 1MB)

Android: Edittext with gravity center not working on device

Removing newline from string

Access ordered images and video in same Cursor

Kotlin This Cursor should be freed up after use with #close

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.