Android SQLite Services-Create, add and revise

<pre name= "code" class= "java" >import android.content.context;import android.database.sqlite.SQLiteDatabase; Import Android.database.sqlite.sqliteopenhelper;import android.util.log;/** * Create 4 tables in the database by default * * */public class Dbopenhelper extends Sqliteopenhelper {private static final String name = "Database.db";//Database name private static FINA    l INT Version = 1;//database versions public Dbopenhelper (context context) {Super (context, name, null, version); } @Override public void OnCreate (Sqlitedatabase db) {LOG.E ("Dbopenhelper", "Dbopenhelperdbopenhelperdbopenhe        Lperdbopenhelper "); Db.execsql ("CREATE TABLE IF not EXISTS config (ID integer primary key autoincrement, s varchar), RT varchar, St VARC        Har (in), Ru varchar (in), V varchar (60));  Db.execsql ("CREATE TABLE IF not EXISTS application (ID integer primary key autoincrement, S varchar (), TT varchar), St varchar (), TC1 varchar, tc2 varchar, ru varchar, TN varchar, M-Va.Rchar (60)) "); Db.execsql ("CREATE TABLE IF not EXISTS install (ID integer primary key autoincrement, na varchar), it varchar, d var        char (60)) "); Db.execsql ("CREATE TABLE IF not EXISTS smslist (ID integer primary key autoincrement, T varchar, st varchar), N1 VAR    char (60), N2 varchar (in), n varchar (in), M varchar (in), a varchar ()) "); } @Override public void Onupgrade (sqlitedatabase db, int oldversion, int newversion) {log.e ("Dbopenhelper"        , "Onupgradeonupgradeonupgradeonupgrade");        Db.execsql ("DROP TABLE IF EXISTS config");        Db.execsql ("DROP TABLE IF EXISTS application");        Db.execsql ("DROP TABLE IF EXISTS Install");        Db.execsql ("DROP TABLE IF EXISTS smslist");            OnCreate (DB); }    }

Import Android.content.context;import Android.database.cursor;import Com.yangguangfu.bean.applicationinfo;import Com.yangguangfu.bean.configinfo;import Com.yangguangfu.bean.installinfo;import com.yangguangfu.bean.SMSInfo;/** *    The database method encapsulates, creates the table, deletes the table, data (additions and deletions) ... * * */public class Databaseservice {private Dbopenhelper dbopenhelper;    Public Databaseservice (Context context) {Dbopenhelper = new Dbopenhelper (context); The public void droptable (String talename) {dbopenhelper.getwritabledatabase (). Execsql ("DROP tabl    E IF EXISTS "+ talename);                    public void CloseDatabase (String DatabaseName) {dbopenhelper.getwritabledatabase (). Close (); } public void Createconfigtable () {String sql = ' CREATE TABLE IF not EXISTS config (id integer prima        Ry Key AutoIncrement, s varchar, RT varchar, st varchar, RU varchar, v varchar, i-varchar (60)) ";    Dbopenhelper.getwritabledatabase (). execsql (SQL);  }  public void Createtableapplication () {String sql = ' CREATE TABLE IF not EXISTS application (ID integer primary k EY AutoIncrement, s varchar, TT varchar, st varchar, TC1 varchar, tc2 varchar, ru varchar (.), TN varchar.        (a), M varchar (60)) ";    Dbopenhelper.getwritabledatabase (). execsql (SQL); } public void Createtableinstall () {String sql = ' CREATE TABLE IF not EXISTS install (ID integer primary key au        Toincrement, na varchar, it varchar, D varchar (60)) ";    Dbopenhelper.getwritabledatabase (). execsql (SQL); } public void Createtablesmslist () {String sql = ' CREATE TABLE IF not EXISTS smslist (ID integer primary key au        Toincrement, T varchar, st varchar, N1 varchar, n2 varchar, n varchar (in), M varchar (a varchar (60))) ";    Dbopenhelper.getwritabledatabase (). execsql (SQL);                } public void Saveconfiginfo (Configinfo configinfo) {dbopenhelper.getwritabledatabase (). Execsql ( the Insert into Config (s, RT, St, RU, V,i) VALUES (?,?,?,?,?,?) ", new object[] {configinfo.gets (), CONFIGINFO.GETRT (), CONFIGINFO.GETST (), Configinfo.getru (), Configinfo.getv (), Configinfo.geti ()    }); } public void Saveapplicationinfo (ApplicationInfo configinfo) {dbopenhelper. getwritabledatabase (). Execsql ("INSERT into application (S,TT,TC1,TC2,RU,TN,M) VALUES (?,?,?,?,?,?,?)" , new object[] {configinfo.gets (), CONFIGINFO.GETTT (), CONFIGINFO.G                                ETTC1 (), CONFIGINFO.GETTC2 (), Configinfo.getru (), CONFIGINFO.GETTN (),    Configinfo.getm ()});                } public void Savemsminfo (Smsinfo configinfo) {dbopenhelper. Getwritabledatabase ()       . Execsql ("INSERT into smslist (t,st,n1,n2,n,m,a) VALUES (?,?,?,?,?,?,?)",                 New object[] {Configinfo.gett (), CONFIGINFO.GETST (), CONFIGINFO.GETN1 (), CONFIGINFO.GETN2 (), Configinfo.getn (), Configinfo.getm (), CO    Nfiginfo.geta ()});                } public void Saveinstallinfo (Installinfo configinfo) {dbopenhelper.getwritabledatabase (). Execsql (                        Insert into Install (NA,IT,D) values (?,?,?), new object[] {Configinfo.getna (), Configinfo.getit (),    CONFIGINFO.GETD ()});                } public void Updateconfiginfo (Configinfo configinfo) {dbopenhelper.getwritabledatabase (). Execsql ( "Update config set s=?", rt=?, st=?, ru=?, v=?,i=? Where id=? ", new object[] {configinfo.gets (), CONFIGINFO.GETRT (), CONFIGINFO.GETST ( ), Configinfo.getru (), Configinfo.getv (), Configinfo.geti (), Configinfo.geti    D ()}); } public VOID Updateapplicationinfo (ApplicationInfo configinfo) {dbopenhelper. Getwritabledatabase () . Execsql ("Update application set s=?, tt=?, st=?, tc1=?, tc2=?,ru=?,tn=?,m=?" Where id=? ", new object[] {configinfo.gets (), CONFIGINFO.GETTT (), C                                ONFIGINFO.GETST (), CONFIGINFO.GETTC1 (), CONFIGINFO.GETTC2 (), Configinfo.getru (),    CONFIGINFO.GETTN (), Configinfo.getm (), Configinfo.getid ()});                } public void Updateinstallinfo (Installinfo configinfo) {dbopenhelper.getwritabledatabase (). Execsql ( "Update install set na=?", it=?, d=? Where id=? ", new object[] {Configinfo.getna (), Configinfo.getit (), configinfo.getd (    ), Configinfo.getid ()});                } public void Updatesmsinfo (Smsinfo configinfo) {dbopenhelper. Getwritabledatabase () .Execsql ("Update smslist set t=?", st=?, n1=?, n2=?, n=?, m=?, a=? Where id=? ", new object[] {Configinfo.gett (), CONFIGINFO.GETST (), C                                ONFIGINFO.GETN1 (), CONFIGINFO.GETN2 (), Configinfo.getn (), Configinfo.getm (),    Configinfo.geta (), Configinfo.getid ()}); The public void Deleteitemdata (String tableName, Integer id) {dbopenhelper.getwritabledatabase ().    Execsql ("Delete from" + TableName + "where id=?", new object[] {ID});                } public Installinfo Findinstallinfo (Integer ID) {CURSOR cursor = Dbopenhelper.getwritabledatabase (). Rawquery (        "Select Id,na,it,d from Install where id=?", new string[] {string.valueof (ID)});            if (Cursor.movetonext ()) {Installinfo configinfo = new Installinfo ();           Configinfo.setid ((cursor.getint (0))); Configinfo.setna (cursor.getstring (1));            Configinfo.setit (cursor.getstring (2));            CONFIGINFO.SETD (Cursor.getstring (3));        return configinfo;    } return null;                } public Configinfo Findconfiginfo (Integer ID) {CURSOR cursor = Dbopenhelper.getwritabledatabase (). Rawquery (        "Select Id,s,rt,st,ru,v,i from config where id=?", new string[] {string.valueof (ID)});            if (Cursor.movetonext ()) {Configinfo configinfo = new Configinfo ();            Configinfo.setid ((cursor.getint (0)));            Configinfo.sets (cursor.getstring (1));            CONFIGINFO.SETRT (cursor.getstring (2));            CONFIGINFO.SETST (Cursor.getstring (3));            Configinfo.setru (Cursor.getstring (4));            Configinfo.setv (Cursor.getstring (5));            Configinfo.seti (cursor.getstring (6));        return configinfo;    } return null; } public Smsinfo Findsmsinfo (Integer id) {Cursor cursoR = Dbopenhelper.getwritabledatabase (). Rawquery ("Select Id,t,st,n1,n2,n,m,a from Smslist where id=?",        New string[] {string.valueof (ID)});            if (Cursor.movetonext ()) {Smsinfo configinfo = new Smsinfo ();            Configinfo.setid ((cursor.getint (0)));            Configinfo.sett (cursor.getstring (1));            CONFIGINFO.SETST (cursor.getstring (2));            CONFIGINFO.SETN1 (Cursor.getstring (3));            CONFIGINFO.SETN2 (Cursor.getstring (4));            CONFIGINFO.SETN (Cursor.getstring (5));            Configinfo.setm (cursor.getstring (6));            Configinfo.seta (cursor.getstring (7));        return configinfo;    } return null; Public ApplicationInfo findapplication (Integer ID) {CURSOR cursor = Dbopenhelper. getwritabled Atabase (). Rawquery ("Select Id,s,tt,st,tc1,tc2,ru,tn,m from Application where id=?" , new string[] {String.ValueOf (ID)});            if (Cursor.movetonext ()) {ApplicationInfo applicationinfo = new ApplicationInfo ();            Applicationinfo.setid ((cursor.getint (0)));            Applicationinfo.sets (cursor.getstring (1));            APPLICATIONINFO.SETTT (cursor.getstring (2));            APPLICATIONINFO.SETST (Cursor.getstring (3));            APPLICATIONINFO.SETTC1 (Cursor.getstring (4));            APPLICATIONINFO.SETTC2 (Cursor.getstring (5));            Applicationinfo.setru (cursor.getstring (6));            APPLICATIONINFO.SETTN (cursor.getstring (7));            Applicationinfo.setm (cursor.getstring (8));        return applicationinfo;    } return null;                } public long Getdatacount (String tableName) {cursor cursor = Dbopenhelper.getreadabledatabase (). Rawquery (        "SELECT COUNT (*) from" + TableName, NULL);        Cursor.movetofirst ();    Return Cursor.getlong (0);    } public void Close () {dbopenhelper.close (); }}

Android SQLite Services-Create, add and revise