Cursor adapter and sqlite example

Question

Hello  I am looking for sample code in which cursor adapter is used with sqlite

User · Accepted Answer

Really simple example   Here is a really simple  but very effective  example  Once you have the basics down you can easily build off of it   There are two main parts to using a Cursor Adapter with SQLite    Create a proper Cursor from the Database  Create a custom Cursor Adapter that takes the Cursor data from the database and pairs it with the View you intend to represent the data with     1  Create a proper Cursor from the Database   In your Activity   SQLiteOpenHelper sqLiteOpenHelper   new SQLiteOpenHelper           context  DATABASE NAME  null  DATABASE VERSION    SQLiteDatabase sqLiteDatabase   sqLiteOpenHelper getReadableDatabase     String query    SELECT   FROM clients ORDER BY company name ASC      No trailing      Cursor cursor   sqLiteDatabase rawQuery query  null     ClientCursorAdapter adapter   new ClientCursorAdapter          this  R layout clients listview row  cursor  0     this setListAdapter adapter     2  Create a Custom Cursor Adapter   Note  Extending from ResourceCursorAdapter assumes you use XML to create your views   public class ClientCursorAdapter extends ResourceCursorAdapter        public ClientCursorAdapter Context context  int layout  Cursor cursor  int flags            super context  layout  cursor  flags               Override     public void bindView View view  Context context  Cursor cursor            TextView name    TextView  view findViewById R id name           name setText cursor getString cursor getColumnIndex  name               TextView phone    TextView  view findViewById R id phone           phone setText cursor getString cursor getColumnIndex  phone

User · Answer

CursorAdapter Example with Sqlite      DatabaseHelper helper   new DatabaseHelper this   aListView    ListView  findViewById R id aListView   Cursor c   helper getAllContacts    CustomAdapter adapter   new CustomAdapter this  c   aListView setAdapter adapter        class CustomAdapter extends CursorAdapter          CursorAdapter will handle all the moveToFirst    getCount   logic for you         public CustomAdapter Context context  Cursor c            super context  c              public void bindView View view  Context context  Cursor cursor            String id   cursor getString 0           String name   cursor getString 1              Get all the values            Use it however you need to         TextView textView    TextView  view          textView setText name              public View newView Context context  Cursor cursor  ViewGroup parent               Inflate your view here          TextView view   new TextView context           return view           private final class DatabaseHelper extends SQLiteOpenHelper        private static final String DATABASE NAME    db name       private static final int DATABASE VERSION   1      private static final String CREATE TABLE TIMELINE    CREATE TABLE IF NOT EXISTS table name   id INTEGER PRIMARY KEY AUTOINCREMENT  name varchar          public DatabaseHelper Context context            super context  DATABASE NAME  null  DATABASE VERSION               Override     public void onCreate SQLiteDatabase db            db execSQL CREATE TABLE TIMELINE           db execSQL  INSERT INTO ddd  name  VALUES   One              db execSQL  INSERT INTO ddd  name  VALUES   Two              db execSQL  INSERT INTO ddd  name  VALUES   Three                  Override     public void onUpgrade SQLiteDatabase db  int oldVersion  int newVersion               public Cursor getAllContacts             String selectQuery    SELECT    FROM table name          SQLiteDatabase db   this getReadableDatabase            Cursor cursor   db rawQuery selectQuery  null           return cursor

User · Answer

In Android  How to use a Cursor with a raw query in sqlite   Cursor c   sampleDB rawQuery  SELECT FirstName  Age FROM mytable                 where Age  gt  10 LIMIT 5   null    if  c    null         if   c moveToFirst              do               String firstName   c getString c getColumnIndex  FirstName                 int age   c getInt c getColumnIndex  Age                 results add      firstName     Age      age            while  c moveToNext             c close

[android] Cursor adapter and sqlite example

Really simple example.

1. Create a proper Cursor from the Database.

2. Create a Custom Cursor Adapter.

Examples related to android

Examples related to database

Examples related to sqlite

Examples related to android-layout

Examples related to android-cursoradapter