cw2.docx - • Code elsewhere in your app creates an instance...

• Code elsewhere in your app creates an instance of the database helper e.g.
dbHelper = new DatabaseHelper(this);
• DatabaseHelper constructor runs telling superclass (SQLiteOpenHelper) the name and version of
database e.g.
super(context, DATABASE_NAME, null, 1);
• To gain access to the database you call getWriteableDatabase() or getReadableDatabase() to get
the SQLiteDatabase object
database = getWritableDatabase();
• If the database doesn't already exist SQLiteOpenHelper calls onCreate() in your database helper
to create the database e.g.
db.execSQL("CREATE TABLE details (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, dob TEXT,
email TEXT);");
• The SQLiteDatabase object can then be used to query(), insert(), delete() etc the database