Sqlite How to get string elements using cursor

Question

public Cursor getImages(long rowId) throws SQLException
    {
        Cursor mCursor =
                db.rawQuery("select * from Pictures WHERE id=" + rowId + ";", null);
        if (mCursor != null) {
            mCursor.moveToFirst();
        }
        return mCursor;


    }

Columns of tables "id, pic, comment"

I want to take pic and comment values ​​in a string array.

My code is:

int i=0;
        Cursor c1 = db.getImages(memberId);     
        c1.moveToFirst();
        while(c1.isLast()){
            pictures[i]=c1.getString(1);
            comments[i]=c1.getString(2);
            i++;
        }

this does not work.

Answer 1

You should do it like this:

c1.getString(cursor.getColumnIndex("pic"));

and

c1.getString(cursor.getColumnIndex("comment"));

Answer 2

just use moveToNextin your loop to repeat.

while(ct.moveToNext()){
     pictures[i]=c1.getString(1);
     comments[i]=c1.getString(2);
     i++;
}

Answer 3

getColumnIndex()

.

if(cursor.moveToFirst()){
    do{
          String varaible1 = cursor.getString(cursor.getColumnIndex("column_name1"));
          String varaible2 = cursor.getString(cursor.getColumnIndex("column_name2"));

       }while (cursor.moveToNext());
}
cursor.close();

, .

, , , 1 2. , . , .

and this is more readable, and what happened if you have 40 columns? (<- let's say it's bad)

Answer 4

And what you have to do is replace

c1.moveToFirst();
while(c1.isLast()){
     //your code
}

Across

//c1.moveToFirst();
while(c1.moveToNext()){
     //your code
}

Answer 5

Cursor c = db.rawQuery("select username from user_information where username ='" + username_txt.getText() + "'", null);
c.moveToFirst();
if (c.moveToFirst()) {
    username = c.getString(c.getColumnIndex("username"));
}

Use this. Hope this helps you.