Back to project page AddressBook.
The source code is released under:
GNU General Public License
If you think the Android project AddressBook listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
// DatabaseConnector.java // Provides easy connection and creation of UserContacts database. package com.stark.addressbook; // ww w .ja va2 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.database.sqlite.SQLiteDatabase.CursorFactory; public class DatabaseConnector { // database name private static final String DATABASE_NAME = "UserContacts"; private SQLiteDatabase database; // database object private DatabaseOpenHelper databaseOpenHelper; // database helper // public constructor for DatabaseConnector public DatabaseConnector(Context context) { // create a new DatabaseOpenHelper databaseOpenHelper = new DatabaseOpenHelper(context, DATABASE_NAME, null, 1); } // end DatabaseConnector constructor // open the database connection public void open() throws SQLException { // create or open a database for reading/writing database = databaseOpenHelper.getWritableDatabase(); } // end method open // close the database connection public void close() { if (database != null) database.close(); // close the database connection } // end method close // inserts a new contact in the database public void insertContact(String name, String email, String phone, String state, String city) { ContentValues newContact = new ContentValues(); newContact.put("name", name); newContact.put("email", email); newContact.put("phone", phone); newContact.put("street", state); newContact.put("city", city); open(); // open the database database.insert("contacts", null, newContact); close(); // close the database } // end method insertContact // inserts a new contact in the database public void updateContact(long id, String name, String email, String phone, String state, String city) { ContentValues editContact = new ContentValues(); editContact.put("name", name); editContact.put("email", email); editContact.put("phone", phone); editContact.put("street", state); editContact.put("city", city); open(); // open the database database.update("contacts", editContact, "_id=" + id, null); close(); // close the database } // end method updateContact // return a Cursor with all contact information in the database public Cursor getAllContacts() { return database.query("contacts", new String[] {"_id", "name"}, null, null, null, null, "name"); } // end method getAllContacts // get a Cursor containing all information about the contact specified // by the given id public Cursor getOneContact(long id) { return database.query( "contacts", null, "_id=" + id, null, null, null, null); } // end method getOnContact // delete the contact specified by the given String name public void deleteContact(long id) { open(); // open the database database.delete("contacts", "_id=" + id, null); close(); // close the database } // end method deleteContact private class DatabaseOpenHelper extends SQLiteOpenHelper { // public constructor public DatabaseOpenHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } // end DatabaseOpenHelper constructor // creates the contacts table when the database is created @Override public void onCreate(SQLiteDatabase db) { // query to create a new table named contacts String createQuery = "CREATE TABLE contacts" + "(_id integer primary key autoincrement," + "name TEXT, email TEXT, phone TEXT," + "street TEXT, city TEXT);"; db.execSQL(createQuery); // execute the query } // end method onCreate @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } // end method onUpgrade } // end class DatabaseOpenHelper } // end class DatabaseConnector /************************************************************************** * (C) Copyright 1992-2012 by Deitel & Associates, Inc. and * * Pearson Education, Inc. All Rights Reserved. * * * * DISCLAIMER: The authors and publisher of this book have used their * * best efforts in preparing the book. These efforts include the * * development, research, and testing of the theories and programs * * to determine their effectiveness. The authors and publisher make * * no warranty of any kind, expressed or implied, with regard to these * * programs or to the documentation contained in these books. The authors * * and publisher shall not be liable in any event for incidental or * * consequential damages in connection with, or arising out of, the * * furnishing, performance, or use of these programs. * **************************************************************************/