Head Fisrt Android Development读书笔记（7）Database Persistent

Creating the database

Create a new class called TimeTrackerOpenHelper that extends SQLiteOpenHelper. Pass the database name and the database version to super.

TimeTrackerOpenHelper(Context context)

super(context, "timetracker.db", null, 1)

// timetracker.db is the db name, 1 is version

public void onCreate(SQLiteDatabase database) {

database.execSQL(

"create table timerecords " +

"(id integer primary key, time text, notes text)");

);

}

public void onUpgrade(SQLiteDatabase database) {

database.execSQL("DROP TABLE IF EXISTS timerecords");

onCreate(database);

}

instead of using execSQL, we can use ContentValues

ContentValues contentValues = new ContentValues();

contentValues.put(COLUMN_NAME, VALUE);

database.insert(TABLE_NAME, null, contentValues);

query the database

sqlite queries return cursors

public Cursor getAllTimeRecords() {

return database.rawQuery(

"select * from " + TABLE_NAME, null

);

}

public class TimeTrackerAdapter extends CursorAdapter {

public TimeTrackerAdapter(Context context, Cursor cursor) {

super(content, cursor);

}

}