1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

public class DatabaseHelper extends SQLiteOpenHelper {
 
	public DatabaseHelper(Context context) {
		super(context, "CursorDemo", null, 1);
	}
 
	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("CREATE TABLE IF NOT EXISTS names ("
				+ BaseColumns._ID
				+ " INTEGER PRIMARY KEY AUTOINCREMENT, first VARCHAR, last VARCHAR)");
		db.execSQL("INSERT INTO names (first, last) VALUES ('John', 'Doe')");
		db.execSQL("INSERT INTO names (first, last) VALUES ('James', 'Kirk')");
	}
 
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// Steps to upgrade the database for the new version ...
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

public class SQLiteDemo extends ListActivity {
	private static final int DIALOG_ID = 100;
 
	private SQLiteDatabase database;
 
	private CursorAdapter dataSource;
 
	private View entryView;
 
	private EditText firstNameEditor;
 
	private EditText lastNameEditor;
 
    private static final String fields[] = { "first", "last",
        BaseColumns._ID };
 
	/** Called when the activity is first created. */
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		DatabaseHelper helper = new DatabaseHelper(this);
		database = helper.getWritableDatabase();
        Cursor data = database.query("names", fields,
            null, null, null, null, null);
 
        dataSource = new SimpleCursorAdapter(this,
            R.layout.row, data, fields,
            new int[] { R.id.first, R.id.last });
 
        ...
 
		setListAdapter(dataSource);
	}
 
    ...
}
 

1
2
3
4
5
6
7
8

ContentValues values = new ContentValues();
values.put("first", firstNameEditor.getText()
    .toString());
values.put("last",
    lastNameEditor.getText().toString());
database.insert("names", null, values);
dataSource.getCursor().requery();