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?

Answer 1

Use this:

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