POJO's versus Cursors in Android

android cursor pojo
benvd picture benvd · Mar 30, 2010 · Viewed 7.5k times · Source

I usually tend to define the model layer of my apps using POJO's, such as Article, Comment, etc.

I was about to implement an AlphabetIndexer in the adapter of one of my ListViews. Right now this adapter accepts a Collection of Articles, which I normally get from my wrapper around an SQLiteDatabase.

The signature of the AlphabetIndexer constructer is as follows:

public AlphabetIndexer (Cursor cursor, int sortedColumnIndex, CharSequence alphabet)

Since this doesn't accept a Collection or something similar, just a Cursor, it got me wondering: maybe I shouldn't be creating objects for my model, and just use the Cursors returned from the database?

So the question is, I guess: what should I do, represent data with Collections of POJO's, or just work with Cursors throughout my app?

Any input?

Answer

CommonsWare picture CommonsWare · Mar 30, 2010

I have run into similar issues. Right now, I am tending away from POJOs. Note, though, that you can create your own Cursor interface for a collection of POJOs, if you so choose.

Related questions

Convert results of SQLite Cursor to my object

I've executed some queries on my SQLite DB on Android. Main instruction used is this: Cursor cursor = myDB.rawQuery(select, null); Now I want the results of this query to be converted to a generic class I've created in the …

Read More
What's the best way to iterate an Android Cursor?

I frequently see code which involves iterating over the result of a database query, doing something with each row, and then moving on to the next row. Typical examples are as follows. Cursor cursor = db.rawQuery(...); cursor.moveToFirst(); while (cursor.…

Read More
Android: Binding data from a database to a CheckBox in a ListView?

I'm trying to bind data from my SQLiteDatabase to a ListView. I'm currently using a SimpleCursorAdapter to fill in my ListView. Unfortunately this doesn't seem to work with setting a CheckBox's checked attribute. This is how I do it now; …

Read More