andorid数据库读写类

andorid数据库读写类

andorid读写软件配置文件的方式很多，sqlite是其中一种方式。对于复杂的数量不固定的数据或者对象，在存储时，使用数据库比其他方法好，快捷。

publicclassDBHelper extendsSQLiteOpenHelper {

privatestaticfinalString DB_NAME= "simpleuse.db";

privatestaticfinalintversion= 2;

privatestaticfinalString TBL_NAME= "pkg";

privatestaticfinalString CREATE_TBL= " create table "+ TBL_NAME

+"(_id integer primary keyautoincrement, app_pkg text) ";

privateSQLiteDatabase db;

/*

qlite3database.db

sqlite>create table admin(username text,age integer);

sqlite>insert into admin values('kuang',25);

sqlite>select * from admin;

sqlite>update admin set username='kk',age=24 whereusername='kuang' and age=25;

sqlite>delete from admin where username='kk';

*/

publicDBHelper(Context c) {

super(c,DB_NAME,null,version);

}

@Override

publicvoidonCreate(SQLiteDatabase db) {

this.db= db;

try{

db.execSQL(CREATE_TBL);

}catch(SQLException ex) {

Log.d("AAAAA","create table failure");

}

}

publicbooleaninsert(ContentValues values) {

try{

SQLiteDatabasedb = getWritableDatabase();

db.insert(TBL_NAME,null,values);

db.close();

returntrue;

}catch(SQLException ex) {

Log.d("AAAAA","insert table failure");

returnfalse;

}

}

publicCursor query() {

SQLiteDatabasedb = getWritableDatabase();

Cursorc = db.query(TBL_NAME,null,null,null,null,null,null);

returnc;

}

publicbooleandel(intid) {

try{

if(db ==null){

db= getWritableDatabase();

}

db.delete(TBL_NAME,"_id=?",newString[] { String.valueOf(id)});

returntrue;

}catch(SQLException ex) {

Log.d("AAAAA","update table failure");

returnfalse;

}

}

publicbooleandelpkg(String pkg) {

try{

if(db ==null){

db= getWritableDatabase();

}

db.delete(TBL_NAME,"app_pkg=?",newString[] { pkg });

returntrue;

}catch(SQLException ex) {

Log.d("AAAAA","update table failure");

returnfalse;

}

}

publicbooleanupdate(String pkg, ContentValues values) {

try{

if(db ==null){

db= getWritableDatabase();

}

db.update("weight",values, "app_pkg=?",newString[] { pkg });

db.close();

returntrue;

}catch(SQLException ex) {

Log.d("AAAAA","update table failure");

returnfalse;

}

}

@Override

publicvoidclose() {

if(db !=null)

db.close();

}

@Override

publicvoidonUpgrade(SQLiteDatabase db, intoldVersion, intnewVersion) {

db.execSQL("DROPTABLE IF EXISTS diary");

onCreate(db);

}

}

参考：

http://blog.csdn.net/nieweilin/article/details/5919013

http://www.cnblogs.com/mmy0925/archive/2013/01/22/2871593.html

http://www.educity.cn/wenda/584925.html

http://blog.csdn.net/nieweilin/article/details/5919013