In this recipe, we're going to demonstrate working with an SQLite database. If you are already familiar with SQL databases from other platforms, then much of what you know will apply. If you are new to SQLite, take a look at the reference links in the "See also" section as this recipe assumes a basic understanding of database concepts including schemas, tables, cursors, and raw SQL.
To get you up and running with an SQLite database quickly, our example implements the basic CRUD operations. Generally, when creating a database in Android, you create a class that extends SQLiteOpenHelper, which is where your database functionality is implemented. Here is a list of the functions to provide each of the basic operations:
Create:
insert()Read:
query()andrawQuery()Update:
update()Delete:
delete()
To demonstrate a fully working database, we will create a simple Dictionary database, so we can store words and their definitions. We'll demonstrate the CRUD operations...