zVMY9HsN

1public class DatabaseHelper extends SQLiteOpenHelper {
2
3// Table Name
4public static final String TABLE_NAME = "Contacts";
5
6// Table columns
7public static final String ID = "ID";
8public static final String Contact_Name = "Contact_Name";
9public static final String Phone_Number = "Phone_Number";
10public static final String Favourites = "Favourites";
11
12// Database Information
13static final String DB_NAME = "MessagePlus_Contacts";
14
15// database version
16static final int DB_VERSION = 1;
17
18// Creating table query
19private static final String CREATE_TABLE = "Create Table " + TABLE_NAME + "(" + ID
20        + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Contact_Name + " TEXT NOT NULL, " + Phone_Number + " INT NOT NULL, " + Favourites + " INT NOT NULL);";
21
22private static final String Show_Table = "Select * From " + TABLE_NAME;
23
24public DatabaseHelper(Context context) {
25    super(context, DB_NAME, null, DB_VERSION);
26}
27
28@Override
29public void onCreate(SQLiteDatabase db) {
30    db.execSQL(CREATE_TABLE);
31}
32
33@Override
34public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
35    db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
36    onCreate(db);
37}
38
39public void showData(SQLiteDatabase db){db.execSQL(Show_Table);}
40
41public void insertData(String contactName, String phoneNumber,String favourites) {
42
43    SQLiteDatabase db = this.getWritableDatabase();
44
45    ContentValues values = new ContentValues();
46
47    values.put(DatabaseHelper.Contact_Name, contactName);
48    values.put(DatabaseHelper.Phone_Number, phoneNumber);
49    values.put(DatabaseHelper.Favourites, favourites);
50
51    db.insert(DatabaseHelper.TABLE_NAME, null, values);
52    // close db connection
53    db.close();
54}
55
56public int addToFavourites(String favourites) {
57    SQLiteDatabase db = this.getWritableDatabase();
58
59    ContentValues values = new ContentValues();
60    values.put(DatabaseHelper.Favourites, favourites);
61
62    // updating row
63    return db.update(DatabaseHelper.TABLE_NAME, values, DatabaseHelper.Phone_Number + " = ?", new String[]{favourites});
64}
65
66
67
68public int getCount() {
69    String countQuery = "SELECT * FROM " + DatabaseHelper.TABLE_NAME;
70    SQLiteDatabase db = this.getReadableDatabase();
71    Cursor cursor = db.rawQuery(countQuery, null);
72
73    int count = cursor.getCount();
74    cursor.close();
75
76    // return count
77    return count;
78}