Android Sqliteopenhelper instance Privatecontactsdbhelper

 Packageprivatecontact;Importandroid.content.ContentValues;ImportAndroid.content.Context;ImportAndroid.database.Cursor;Importandroid.database.sqlite.SQLiteDatabase;ImportAndroid.database.sqlite.SQLiteOpenHelper; Public classPrivatecontactsdbhelperextendsSqliteopenhelper { Public Static FinalString database_name = "Pcontacts.db";  Public Static Final intDatabase_version = 1;  Public Static FinalString table_name = "PContacts";  Public Final StaticString ID = "_id";  Public Final StaticString name = "Name";  Public Final StaticString mobile = "mobile";  Public Final StaticString email = "Email";  PublicPrivatecontactsdbhelper (Context context) {Super(Context, database_name,NULL, database_version); } @Override Public voidonCreate (Sqlitedatabase db) {String SQL= "CREATE TABLE" + table_name + "(" +ID+ "INTEGER primary key AutoIncrement," +NAME+ "text," + MOBILE + "text," + EMAIL + "text);";    Db.execsql (SQL); } @Override Public voidOnupgrade (Sqlitedatabase db,intOldversion,intnewversion) {Db.execsql ("DROP TABLE IF EXISTS" +table_name);    OnCreate (DB); }         PublicCursor Select () {sqlitedatabase db= This. Getreadabledatabase (); Cursor Cursor=db. Query (table_name,NULL,NULL,NULL,NULL,NULL,NULL); returncursor; }     Public LongInsert (String arg1, String arg2, String arg3) {Sqlitedatabase db= This. Getwritabledatabase (); /*contentvalues*/contentvalues CV=Newcontentvalues ();        Cv.put (NAME, arg1);        Cv.put (MOBILE, arg2);        Cv.put (EMAIL, ARG3); Longrow = Db.insert (table_name,NULL, CV); returnRow; }     Public voidDeleteintID) {sqlitedatabase db= This. Getwritabledatabase (); String where= ID + "=?"; String[] Wherevalue={integer.tostring (id)};    Db.delete (table_name, where, wherevalue); }     Public voidUpdateintID, string arg1, String arg2, String arg3) {Sqlitedatabase db= This. Getwritabledatabase (); String where= ID + "=?"; String[] Wherevalue={integer.tostring (id)}; Contentvalues CV=Newcontentvalues ();        Cv.put (NAME, arg1);        Cv.put (MOBILE, arg2);        Cv.put (EMAIL, ARG3);    Db.update (TABLE_NAME, CV, where, wherevalue); }}

Android Sqliteopenhelper instance Privatecontactsdbhelper