Rapid Android Development

Working with the KetaiSQLite Class

To use SQLite on the Android, we’ll work with the following KetaiSQLite methods.

KetaiSQLite[238]	Ketai class for working with SQLite databases—it can be used to create a KetaiSQLite database or to load an existing database.
execute	KetaiSQLite method for executing a SQLite query to a database, which doesn’t return data
query	KetaiSQLite method for sending a SQLite query to a database, returning data
getRecordCount	KetaiSQLite method returning all records in a specified table, using the table name as parameter
getDataCount	KetaiSQLite method returning all records in a database across all tables

Now let’s take a look at the most important declarative SQL we’ll use in our database project.^{[239] ...}