Android SQLite Database Quiz

Working with SQLite Database

• SQLite is an open source SQL database that stores data to a text file on a device.
• Android comes with built-in SQLite database implementation that supports all the relational database features.
• The android.database.sqlite.SQLiteOpenHelper class is used for database creation and version management.
• The SQLiteOpenHelper class has two constructors and many methods including onCreate(), onUpgrade(), and close().
• The SQLiteDatabase class contains methods to be performed on SQLite database such as create, update, delete, and select.
• The execSQL() method of SQLiteDatabase class executes the SQL query not select query.
• The insert() method of SQLiteDatabase class inserts a record on the database.
• The update() method of SQLiteDatabase class updates a row.
• The query() method of SQLiteDatabase class returns a cursor over the result set.
• The dbHelper.java file contains methods like onUpgrade(), insertNewBook(), getData(), deleteBook(), and updateBook() for performing database operations.
• The MainActivity.java file uses dbHelper object and methods to display book records in a list view and perform CRUD operations.
• The Exercise is to create an application to store books record in SQLite database and apply CRUD operations.