Android数据库操作工具类分享
本文实例为大家分享了Android数据库操作工具类的具体代码，供大家参考，具体内容如下
HistoryDAO
publicclassHistoryDAO{
privateDBConnectiondbc=null;
privateSQLiteDatabasedb=null;
privateContextcontext;
//数据库上下文
publicHistoryDAO(Contextcontext){
this.context=context;
}
//打开数据库
publicHistoryDAOopen(){
dbc=newDBConnection(context);
db=dbc.getWritableDatabase();
returnthis;
}
//关闭数据库
publicvoidcloseAll(){
db.close();
dbc.close();
}
////增加
//publicvoidadd(Search_HistoryDatadata,Stringtype){
//open();
//ContentValuesvalues=newContentValues();
//values.put("content",data.getContent());
//values.put("type",data.getType());
//db.insert("history",null,values);
//closeAll();
//}
//增加
publicvoidadd(Search_HistoryDatadata,StringtableName){
open();
ContentValuesvalues=newContentValues();
values.put("content",data.getContent());
db.insert(tableName,null,values);
closeAll();
}
//增加工具类的最后五个专用
publicvoidaddLawTool(Search_HistoryDatadata,StringtableName){
open();
ContentValuesvalues=newContentValues();
values.put("content",data.getContent());
values.put("_id",data.getId());
db.insert(tableName,null,values);
closeAll();
}
//全查询
publicListgetAll(StringTableName){
open();
Listar=newArrayList();
Cursorc=db.rawQuery("select*from"+TableName,null);
while(c.moveToNext()){
Mapmap=newHashMap();
map.put("_id",c.getInt(c.getColumnIndex("_id")));
map.put("content",c.getString(c.getColumnIndex("content")));
ar.add(map);
}
closeAll();
returnar;
}
//删除根据id删除
publicvoiddelete(StringtableName,intuid){
open();
db.delete("history","uid="+uid,null);
closeAll();
}
//清空表中所有数据
publicvoiddelete(StringtableName){
open();
db.delete(tableName,null,null);
closeAll();
}
//判断是否存在
publicbooleansearchResult(StringtableName,Stringkey){
open();
Booleanbooleans=
db.rawQuery("select*from"+tableName+"wherecontent=?",newString[]{key}).moveToNext();
closeAll();
returnbooleans;
}
//根据库查询表字段
publicbooleansearchResultToType(Stringcontent,Stringtype){
open();
Booleanbooleans=
db.rawQuery("select*fromhistorywherecontent=?andtype=?",newString[]{content,type}).moveToNext();
closeAll();
returnbooleans;
}
}
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。