public class CategoryListActivity extends ListActivity {
    
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        
        fillList();
    }

    @Override
    protected void onListItemClick(ListView l, View v, int position, long id) {
        super.onListItemClick(l,v,position, id);

        final Intent intent = new Intent(this, ArticleListActivity.class);
        intent.putExtra("category", (Category) v.getTag());
        startActivity(intent);
    }
    
    private void fillList() {
        Cursor categoriesCursor = db.getReadableDatabase().rawQuery(CategoryTable.SQL_SELECT_ALL, null);
        startManagingCursor(categoriesCursor);
        
        SimpleCursorAdapter categoriesAdapter = new SimpleCursorAdapter(this, R.layout.my_simple_list_item_1, categoriesCursor, new String[] {CategoryTable.NAME}, new int[] {android.R.id.text1}) {
            @Override
            public View newView(Context context, Cursor cursor, ViewGroup parent) {
                final View view = super.newView(context, cursor, parent);
                view.setTag(new Category(cursor.getInt(0), cursor.getInt(1), cursor.getString(2)));
                return view;
            }
        };
        setListAdapter(categoriesAdapter);
    }