Fetching values from cursor in android

Question

i am fetching a query from sqlite database like that :

String query = "select distinct(" +MessageCountConstant.To_USER + "), sum(" +MessageCountConstant.SEND_MESSAGE_COUNT + ") , "
            + "sum(" +MessageCountConstant.RECIEVE_MESSAGE_COUNT + ") from " +TABLE_NAME + " where " + MessageCountConstant.DATE  + "= " +date
             + " AND "+ MessageCountConstant.DATE  + " >= "+previousDate + " AND "+ MessageCountConstant.JID + " = '"+ Uname + "'"
                        ;


    SQLiteDatabase db = mOpenHelper.getReadableDatabase();
    cursor = db.rawQuery(query, null);

Now can anyone tell me how can i fetch value from cursor .Thanks in advance.

Usman Kurd · Accepted Answer · 2013-01-09 13:32:25Z

1

you can use it in that way

if (cursor.moveToFirst()){

 do{
      String data = cursor.getString(cursor.getColumnIndex("data");

      // do what ever you want here

   }while(cursor.moveToNext());

}

cursor.close();

answered Jan 9, 2013 at 13:32

Usman Kurd

7,0517 gold badges59 silver badges87 bronze badges

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

Comments

karllindmark · Accepted Answer · 2013-01-09 13:29:29Z

0

Generally speaking, you can get your values from the cursor by doing the following:

while( cursor.moveToNext() ) {
    String value1 = cursor.getString(cursor.getColumnIndex("column1"));
    String value2 = cursor.getString(cursor.getColumnIndex("column2"));
}

answered Jan 9, 2013 at 13:29

karllindmark

6,0601 gold badge28 silver badges41 bronze badges

Comments

hardartcore · Accepted Answer · 2013-01-09 13:35:19Z

0

You can do fetch data like that :

for(cursor.move(0);cursor.moveToNext();cursor.isAfterLast()){
   String first = cursor.getString(cursor.getColumnIndex("string_row"));
   int second cursor.getInt(cursor.getColumgnIndex("int_row"));
}

and don't forget to close your cursor after fetching data : cursor.close();

answered Jan 9, 2013 at 13:35

hardartcore

17.1k12 gold badges78 silver badges102 bronze badges

Collectives™ on Stack Overflow

Fetching values from cursor in android

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related