SQLite Help Class

1, first write a class inherit from Sqliteopenhelper

 Public  class dbhelper extends sqliteopenhelper{    Private Static Final intDatabase_version =1;//Database version number    Private Static FinalString database_name ="";//Database name     Public DBHelper(Context context) {Super(Context, database_name,NULL, database_version); }@Override     Public void onCreate(Sqlitedatabase db) {String sql ="";    Db.execsql (SQL); }@Override     Public void Onupgrade(Sqlitedatabase DB,intOldversion,intnewversion) {}}

2, need a database management class, such as INSERT, delete, etc.

 Public Abstract  class Dbdao{    PrivateContext context;PrivateDBHelper DBHelper; PublicSqlitedatabase sqlitedatabase; Public Dbdao(Context context) {Super(); This. Context = Context; }/** * Open Database connection * /     Public void opendb(Context context) {DBHelper =NewDBHelper (context);    Sqlitedatabase = Dbhelper.getwritabledatabase (); }/** * Close Database connection * /     Public void Closedb(Context context) {if(Sqlitedatabase.isopen ())        {Sqlitedatabase.close (); }    }/** * Update data * /     Public int Updata(String table_name, contentvalues values,intID) {OPENDB (context);intUpdate = SQLITEDATABASE.UPDATE (table_name, values,"_id=?",NewString[]{string.valueof (ID)}); Closedb (context);returnUpdate }/** * Insert data * /     Public void Insert(String table_name, contentvalues values)        {opendb (context); Sqlitedatabase.insert (TABLE_NAME,NULL, values);    Closedb (context); }/** * Delete data according to unique _id * /     Public void Delete(String table_name,intID) {OPENDB (context);Try{Sqlitedatabase.delete (table_name,"_id=?",NewString[]{string.valueof (ID)}); }Catch(Exception e)        {E.printstacktrace (); }finally{closedb (context); }    }/** * Query data * *     Public void Search(String table_name,intID) {Sqlitedatabase database = Dbhelper.getreadabledatabase (); String sql ="SELECT * from"+ table_name +"where _id =?"; cursor cursor = database.rawquery (SQL,NewString[]{string.valueof (ID)}); }}

SQLite Help class