Android Open Source - Android_PhoneBook Contact D B

• Back to App/contact  ↑

From Project

Back to project page Android_PhoneBook.

License

The source code is released under:

GNU General Public License

Java Source Code

package com.blobinfo.contact;
//  ww w  . jav a2 s.c o  m
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

// ContactDb class that encapsulates the database functions of this application
public class ContactDB
{

    // define constants
    public static final String KEY_ROWID = "ContactID";
    public static final String KEY_FirstName= "FirstName";
    public static final String KEY_LastName = "LastName";
    public static final String KEY_emailID = "emailID";
    public static final String KEY_Mobile01 = "Mobile01";
    private static final String TAG = "DBAdapter";

    private static final String DATABASE_NAME = "PhonebookDB";
    private static final String DATABASE_TABLE = "Contacts";
    private static final int DATABASE_VERSION = 1;

    private static final String DATABASE_CREATE = "create table Contacts (ContactID integer primary key autoincrement, FirstName text not null, LastName text not null, emailID text not null, Mobile01 text not null);";

    private final Context context;  

    private DatabaseHelper DBHelper;
    private SQLiteDatabase db;

    public ContactDB(Context ctx) 
    {
        this.context = ctx;
        DBHelper = new DatabaseHelper(context);
    }

    private static class DatabaseHelper extends SQLiteOpenHelper 
    {
        DatabaseHelper(Context context) 
        {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        // creates the db if it does not exist
        @Override
        public void onCreate(SQLiteDatabase db) 
        {
            db.execSQL(DATABASE_CREATE);
        }

        // called when the db needs upgrading
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, 
                              int newVersion) 
        {
            Log.w(TAG, "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
            db.execSQL("DROP TABLE IF EXISTS titles");
            onCreate(db);
        }
    }

  //open db
    public ContactDB open() throws SQLException 
    {
        db = DBHelper.getWritableDatabase();
        return this;
    }

    //close db
    public void close() 
    {
        DBHelper.close();
    }

    //add a record
    public long insertContacts(String FirstName, String LastName, String emailID, String Mobile01) 
    {
        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_FirstName, FirstName);
        initialValues.put(KEY_LastName, LastName);
        initialValues.put(KEY_emailID, emailID);
        initialValues.put(KEY_Mobile01, Mobile01);
        return db.insert(DATABASE_TABLE, null, initialValues);
    }
    
  //delete a record
    public boolean deleteContacts(long rowId) 
    {
        return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
    }

    //get all record
    public Cursor getAllContacts() 
    {
        return db.query(DATABASE_TABLE, new String[] {KEY_ROWID,KEY_FirstName,KEY_LastName,KEY_emailID,KEY_Mobile01}, null, null, null, null, null);
    }

    //get a record
    public Cursor getContacts(long rowId) throws SQLException 
    {
        Cursor mCursor =
                db.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,KEY_FirstName,KEY_LastName, KEY_emailID,KEY_Mobile01}, 
                        KEY_ROWID + "=" + rowId, 
                        null, null, null, null, null);

        if (mCursor != null) {
            mCursor.moveToFirst();
        }
        return mCursor;
    }

    //record update
    public boolean updateContacts(long rowId, String FirstName, String LastName, String emailID, String Mobile01) 
    {
        ContentValues args = new ContentValues();
        args.put(KEY_FirstName, FirstName);
        args.put(KEY_LastName, LastName);
        args.put(KEY_emailID, emailID);
        args.put(KEY_Mobile01, Mobile01);
        return db.update(DATABASE_TABLE, args, 
                         KEY_ROWID + "=" + rowId, null) > 0;
    }
}

Java Source Code List

• Back to App/contact  ↑