In android is there any direct method that executes a query and returns a cursor?

Question

In android is there any direct method that executes a query and returns a cursor??

like in java there is statement.getCursor() is there any equivalent method in android?

score 2 · Answer 1 · answered Feb 21 '11 at 05:40

you can execute query this way

Cursor cursor;

String select = "Select * from contactTable";

try {

  cursor = myDataBase.rawQuery(select, null);

  for (int i = 0; i < cursor.getCount(); i++) {
    cursor.moveToNext();
    // your code
  }      
  cursor.close();

} catch (Exception e) {
        e.printStackTrace();
}finally{
        myDataBase.close();
        SQLiteDatabase.releaseMemory();
}

score 1 · Answer 2 · edited May 23 '17 at 12:29

I find the best way to interface with a database in android is to use a DatabaseAdapter class. This is a class loaded up with methods that do everything you could want to do with a database. Some good reading on this can be found here. Just check out listing 4.

Also, make sure to use an SQLiteOpenHelper in conjunction with your database adapter. This will create a database automatically if one doesnt exist, and handle upgrades automatically as well. Be careful though: SQLiteOpenHelper will only help you create one table per database automatically, I get around this by just creating multiple databases. As SQLite doesn't support foreign keys I don't really see a disadvantage to this. Check out the example code here for SQLiteOpenHelper.

In android is there any direct method that executes a query and returns a cursor?

2 Answers2