8.9. DatabaseConnector Utility Class

The DatabaseConnector utility class (Figs. 8.51–8.58) manages this app’s interactions with SQLite for creating and manipulating the UserContacts database, which contains one table named contacts.

Click here to view code image

 1   // DatabaseConnector.java
 2   // Provides easy connection and creation of UserContacts database.
 3   package com.deitel.addressbook;
 4
 5   import android.content.ContentValues;
 6   import android.content.Context;
 7   import android.database.Cursor;
 8   import android.database.SQLException;
 9   import android.database.sqlite.SQLiteDatabase;
10   import android.database.sqlite.SQLiteOpenHelper;
11   import android.database.sqlite.SQLiteDatabase.CursorFactory;
12
13   public class DatabaseConnector
14   {
15      // database name
16      private static final String DATABASE_NAME = "UserContacts";
17
18      private SQLiteDatabase database; // for interacting with the database
19      private DatabaseOpenHelper databaseOpenHelper; // creates the database
20

Fig. 8.51 | DatabaseConnector class’s package statement, import statements and instance variables.