Getting Strings from A Cursor in Android?

Question

My cose is SIMPLE. I have a SQLite-Database with three columns:

1. rowid
2. title => text
3. content => text

This is a method in my dataBase-class:

public Cursor fetchMessage(String tableNane, int id) {
    return myDataBase.rawQuery("SELECT rowid as _id, title FROM "+tableName
    +" WHERE rowid = "+id, null);
}

This method will return only one row.

In my activity I wrote this:

Cursor cursor = myDbHelper.fetchMessage(tableName, id);

Now, I want to store the content field's text in a String.

How can this be done?

Solution 1

Use this:

if (cursor.moveToFirst()) {
    str = cursor.getString(cursor.getColumnIndex("content"));
}

Solution 2

First you'll want to move the Cursor you got from your Query to the first row using the moveToFirst()-method.

After that you can get your fields values by using the getString() or getInt()-methods.

Comments

[iTurki]

Works perfectly. Thanks @CeKup :)