Android SQLite Query and using cursor to deal with multiple rows

Question

I've got a query, (I'm using rawQuery())

  SELECT * FROM <table>

I'm then storing what it returns using a cursor. From their what I want to do is, start at the first row so.. cursor.moveToFirst() then take each column , column by column and store its particular value in a variable. I then want to move onto the next row and do the same. So I guess my question is How would I get cursor to deal with multiple columns?

Thanks,

ahsan · Accepted Answer · 2011-09-11 08:44:33Z

16

I might be missing something here, wouldn't you have a nested loop.

The outer loop cycles through each records:

while (cursor.moveToNext()) {
  ...
  // inner loop here
  ...
}

and the inner loop would cycle through each column

for (i=0; i<cursor.getColumnCount(); i++) {
  ...
  String var1 = cursor.getString(i);
  ...
}

edited Sep 11, 2011 at 8:44

ahsan

6779 silver badges24 bronze badges

answered Jun 24, 2010 at 14:34

Matty F

3,7934 gold badges34 silver badges48 bronze badges

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

2 Comments

AndyD273 Over a year ago

I know this is already accepted, but a do {}while (cursor.moveToNext()); works better, because if you check .moveToNext first, you skip the first record... Learned from experience...

Matty F Over a year ago

Are you sure? A cursor typically is sitting at position -1 when returned and calling moveToNext() will move it to the first row. Also, with your logic the code block inside do{} will always execute at least once, even if the Cursor contains no records.

Collectives™ on Stack Overflow

Android SQLite Query and using cursor to deal with multiple rows

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related