Android Programming with Kotlin for Beginners

Coding the database class

Here, we will put into practice everything we have learned so far and finish coding the Age database app. Before our Fragment classes from the previous section can interact with a shared database, we need a class to handle interaction with, and creation of, the database.

We will create a class that manages our database by implementing SQLiteOpenHelper. It will also define some String variables in a companion object to represent the names of the table and its columns. Furthermore, it will supply a bunch of helper functions we can call to perform all the necessary queries. Where necessary, these helper functions will return a Cursor object that we can use to show the data we have retrieved. It would be trivial then to add ...