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; } }
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。