How to get values from database[Cursor Adapter] and store it to an array in java?

Question

I would like to get the values from database of a particular column by executing a query. Is it possible to do it after we do it to the Cursor Adapter or can we attain the values well before itself. Kindly help on this with a snippet or a guide.

See it here: stackoverflow.com/questions/3544913/…

aF.
– aF.

2011-12-19 10:13:48 +00:00
Commented Dec 19, 2011 at 10:13 — aF.
– aF., Commented Dec 19, 2011 at 10:13

duggu · Accepted Answer · 2015-01-19 06:47:52Z

2

Context context = getApplicationContext(); 
final DataBaseHelper db = new DataBaseHelper(context);
...
...
db.createDataBase();
..
...try catch logic etc
....
final Cursor c = db.getAllRows();
....
c.getString(4) // String value of 5th Column in Database

Cursor Adapter to Array

ArrayList<String> mArrayList = new ArrayList<String>(); 
c.moveToFirst(); 
while(!c.isAfterLast()) { 
     mArrayList.add(c.getString(c.getColumnIndex(DataBaseHelper.KEY_NAME)); 
     c.moveToNext(); 
}

DataBaseHelper class has following

public Cursor getAllRows() 
    {
        return myDataBase.query(DATABASE_TABLE, new String[] {
                KEY_ROWID, 
                KEY_NAME,
                KEY_YEAR,
                     KEY_QUOTE,
                     KEY_REF}, 
                null, 
                null, 
                null, 
                null, 
                null);
    }

edited Jan 19, 2015 at 6:47

duggu

38.5k12 gold badges121 silver badges114 bronze badges

answered Dec 19, 2011 at 11:44

Naheed Akhtar

1368 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get values from database[Cursor Adapter] and store it to an array in java?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related