Display sqlite data on listview

Question

I have to show saved sqlite data on a listview. But only one column's data is enough to show.Here is my codes. I want to get "tarih" column's data.

public class TarihDataSource {

private SQLiteDatabase database;
private DatabaseOlusturma dbOlustur;
private String []allColumns = {"tarih","gunluknotu","resim"};

public TarihDataSource(Context context) {
    dbOlustur = new DatabaseOlusturma(context);
}

public void open() throws SQLException {
    database = dbOlustur.getReadableDatabase();
}

public void close() {
    dbOlustur.close();
}

public List<TarihListHelper> getAllTarih() {
    List<TarihListHelper> tarihlistesi = new ArrayList<TarihListHelper>();
    Cursor cursor = database.query("gunluker", allColumns, null, null,
            null, null, null);
    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
        TarihListHelper comment = cursorToComment(cursor);
        tarihlistesi.add(comment);
        cursor.moveToNext();
    }
    // Make sure to close the cursor
    cursor.close();
    return tarihlistesi;
}

private TarihListHelper cursorToComment(Cursor cursor) {
    TarihListHelper comment = new TarihListHelper();
    comment.setTarih(cursor.getString(1));
    return comment;
  }

}

What is the wrong in this codes?

Umer Farooq · Accepted Answer · 2013-09-13 16:12:44Z

1

This code should help you.

public List<TarihListHelper> getAllTarih()
{       
    List<TarihListHelper> tarihlistesi = new ArrayList<TarihListHelper>();

    Cursor cursor = database.query(DB_NAME, columns, null, null, null, null, null);

    while(cursor.moveToNext())
    {
        TarihListHelper tarihlistesi= cursorToComment(cursor);
        tarihlistesi.add(comment);


    }

    cursor.close();
    return tarihlistesi;
}

Where columns is the String[] which contains the names of all the columns in your database table.

This way you will get all the columns, then you can select from which column do want to read data.

Hope this helps.

edited Sep 13, 2013 at 16:12

answered Sep 13, 2013 at 15:09

Umer Farooq

7,4967 gold badges45 silver badges69 bronze badges

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

8 Comments

emreturka Over a year ago

TarihListHelper data = cursor.getString(c.getColumnIndex(DB_COMMENT_COL)); comments.add(data); // the List you will pass to ListView for displaying data I did'nt understand this row.cursor.getString returns String type.But data's type is TarihListeHelper

emreturka Over a year ago

TarihListHelper data = cursor.getType(cursor.getColumnIndex("tarih")); This is giving error.

Umer Farooq Over a year ago

Would you care to post the logcat?

emreturka Over a year ago

No no.it is not accepted. cursor.getType(...) returns int. But We have TarihListHelper type.

Umer Farooq Over a year ago

type cast the data returned by getType to TarihListHelper

|

JJ86 · Accepted Answer · 2013-09-13 15:10:34Z

0

You simply need an Adapter to your list. In your case i think that a SimpleCursorAdapter is the best.

Check this official page and this example.

answered Sep 13, 2013 at 15:10

JJ86

5,1212 gold badges38 silver badges65 bronze badges

Comments

Kanwaljit Singh · Accepted Answer · 2013-09-13 15:13:17Z

public class TarihDataSource {

private SQLiteDatabase database;
private DatabaseOlusturma dbOlustur;
private final Context context;
private String []allColumns = {"tarih","gunluknotu","resim"};

public TarihDataSource(Context _context) {
    context = _context;
    dbOlustur = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);

public void open() throws SQLException {
    database = dbOlustur.getReadableDatabase();
}

public void close() {
    dbOlustur.close();
}

public List<TarihListHelper> getAllTarih() {
    List<TarihListHelper> tarihlistesi = new ArrayList<TarihListHelper>();
    Cursor cursor = database.query("gunluker", allColumns, null, null,
            null, null, null);
    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
        TarihListHelper comment = cursorToComment(cursor);
        tarihlistesi.add(comment);
        cursor.moveToNext();
    }
    // Make sure to close the cursor
    cursor.close();
    return tarihlistesi;
}

private TarihListHelper cursorToComment(Cursor cursor) {
    TarihListHelper comment = new TarihListHelper();
    comment.setTarih(cursor.getString(1));
    return comment;
  }

}

Try this.

Collectives™ on Stack Overflow

Display sqlite data on listview

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related