Android SQLite API
There are a number of different ways that the Android API makes it fairly easy to use our app's database. The first class we need to get familiar with is SQLiteOpenHelper.
SQLiteOpenHelper and SQLiteDatabase
The SQLiteDatabase class is the class that represents the actual database. The SQLiteOpenHelper class, however, is where most of the action takes place. This class will enable us to get access to a database and initialize an instance of SQLiteDatabase.
In addition, SQLiteOpenHelper, which we will extend in our Age Database app, has two methods to override. First, it has an onCreate method, which is called the first time a database is used; therefore, it makes sense that we would put our SQL to create our table structure in.
The other method we must override is onUpgrade, which, as you can probably guess, is called when we upgrade our database (use ALTER to change its structure).
Building and executing queries
As our database structures...
