UI -> I want a readable database
EditorActivity, CatalogActivity
SQLiteDatabase db = mDbHelper.getReadableDatabase();
PetContract
PetDbHelper
PetDbHelper mDbHelper = new PetDbHelper(this);
Is there a database? no -> Make a database using onCreate() code
SQLiteDatabase
Create Update Delete
->SQLiteDatabase db = mDbHelper.getWritableDatabase();
Select
->SQLiteDatabase db = mDbHelper.getWritableDatabase();
INSERT INTO <table name>( <column_name_1>, <column_name_2>, ...) VALUES ( <values_1>, <values_2> ...) INSERT INTO pets ( _id, name, breed, weight) VALUES ( 1, "Tommy", 1, 4);
Inserting Data: Content Values
Key – Value, COLUMN_PET_NAME – “Garfield”, COLUMN_PET_BREED – “Tabby”, COLUMN PET GENDER – GENDER_MALE, COLUMN_PET_WEIGHT – 14
ContentValues values = new ContentValues(); values.put(PetEntry.COLUMN_PET_NAME, "Garfield"); values.put(PetEntry.COLUMN_PET_BREED, "Tabby"); values.put(PetEntry.COLUMN_PET_GENDER, PetEntry.GENDER_MALE); values.put(PetEntry.COLUMN_PET_WEIGHT, 14);