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