Getting Strings from A Cursor in Android?

Question

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

rowid
title => text
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?

Don't write with caps lock. It's like shouting around.

Lukas Knuth
– Lukas Knuth

2011-07-10 12:06:29 +00:00
Commented Jul 10, 2011 at 12:06 — Lukas Knuth
– Lukas Knuth, Commented Jul 10, 2011 at 12:06

CeKup · Accepted Answer · 2011-07-10 12:00:34Z

28

Use this:

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

answered Jul 10, 2011 at 12:00

CeKup

1,08910 silver badges6 bronze badges

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

Comments

Lukas Knuth · Accepted Answer · 2011-07-10 12:04:19Z

8

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.

answered Jul 10, 2011 at 12:04

Lukas Knuth

25.8k16 gold badges88 silver badges114 bronze badges

Collectives™ on Stack Overflow

Getting Strings from A Cursor in Android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related