12.4 DrySister看妹子应用(第一版)——4.添加数据缓存(加入SQLite)

closeIO(null); } /** 插入一堆妹子(使用事务) */ public void insertSisters(ArrayList<Sister> sisters) { db = getWritableDB(); db.beginTransaction(); try{ for (Sister sister: sisters) { ContentValues contentValues = new ContentValues(); contentValues.put(TableDefine.COLUMN_FULI_ID,sister.get_id()); contentValues.put(TableDefine.COLUMN_FULI_CREATEAT,sister.getCreateAt()); contentValues.put(TableDefine.COLUMN_FULI_DESC,sister.getDesc()); contentValues.put(TableDefine.COLUMN_FULI_PUBLISHEDAT,sister.getPublishedAt()); contentValues.put(TableDefine.COLUMN_FULI_SOURCE,sister.getSource()); contentValues.put(TableDefine.COLUMN_FULI_TYPE,sister.getType()); contentValues.put(TableDefine.COLUMN_FULI_URL,sister.getUrl()); contentValues.put(TableDefine.COLUMN_FULI_USED,sister.getUsed()); contentValues.put(TableDefine.COLUMN_FULI_WHO,sister.getWho()); db.insert(TableDefine.TABLE_FULI,null,contentValues); } db.setTransactionSuccessful(); } finally { if(db != null && db.isOpen()) { db.endTransaction(); closeIO(null); } } } /** 删除妹子(根据_id) */ public void deleteSister(String _id) { db = getWritableDB(); db.delete(TableDefine.TABLE_FULI,"_id =?",new String[]{_id}); closeIO(null); } /** 删除所有妹子 */ public void deleteAllSisters() { db = getWritableDB(); db.delete(TableDefine.TABLE_FULI,null,null); closeIO(null); } /** 更新妹子信息(根据_id) */ public void deleteSister(String _id,Sister sister) { db = getWritableDB(); ContentValues contentValues = new ContentValues(); contentValues.put(TableDefine.COLUMN_FULI_ID,sister.get_id()); contentValues.put(TableDefine.COLUMN_FULI_CREATEAT,sister.getCreateAt()); contentValues.put(TableDefine.COLUMN_FULI_DESC,sister.getDesc()); contentValues.put(TableDefine.COLUMN_FULI_PUBLISHEDAT,sister.getPublishedAt()); contentValues.put(TableDefine.COLUMN_FULI_SOURCE,sister.getSource()); contentValues.put(TableDefine.COLUMN_FULI_TYPE,sister.getType()); contentValues.put(TableDefine.COLUMN_FULI_URL,sister.getUrl()); contentValues.put(TableDefine.COLUMN_FULI_USED,sister.getUsed()); contentValues.put(TableDefine.COLUMN_FULI_WHO,sister.getWho()); db.update(TableDefine.TABLE_FULI,contentValues,"_id =?",new String[]{_id}); closeIO(null); } /** 查询当前表中有多少个妹子 */ public int getSistersCount() { db = getReadableDB(); Cursor cursor = db.rawQuery("SELECT COUNT (*) FROM " + TableDefine.TABLE_FULI,null); cursor.moveToFirst(); int count = cursor.getInt(0); Log.v(TAG,"count：" + count); closeIO(cursor); return count; } /** 分页查询妹子，参数为当前页和每一个的数量，页数从0开始算 */ public List<Sister> getSistersLimit(int curPage,int limit) { db = getReadableDB(); List<Sister> sisters = new ArrayList<>(); String startPos = String.valueOf(curPage * limit); //数据开始位置 if(db != null) { Cursor cursor = db.query(TableDefine.TABLE_FULI,new String[] { TableDefine.COLUMN_FULI_ID, TableDefine.COLUMN_FULI_CREATEAT, TableDefine.COLUMN_FULI_DESC, TableDefine.COLUMN_FULI_PUBLISHEDAT, TableDefine.COLUMN_FULI_SOURCE, TableDefine.COLUMN_FULI_TYPE, TableDefine.COLUMN_FULI_URL, TableDefine.COLUMN_FULI_USED, TableDefine.COLUMN_FULI_WHO, },null,null,null,null,TableDefine.COLUMN_ID,startPos + "," + limit); while (cursor.moveToNext()) { Sister sister = new Sister(); sister.set_id(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_ID))); sister.setCreateAt(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_CREATEAT))); sister.setDesc(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_DESC))); sister.setPublishedAt(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_PUBLISHEDAT))); sister.setSource(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_SOURCE))); sister.setType(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_TYPE))); sister.setUrl(cursor.getString(cursor.getColumnIndex(TableDefine.COLUMN_FULI_URL))); sister.setUsed(cursor.getInt(cursor.getColumnIndex(TableDefine.COLUMN_FULI_USED))); sisters.add(sister); } closeIO(cursor); } return sisters; } /** 查询所有妹子 */ public List<Sister> getAllSisters() { db = getReadableDB(); List<Sister> sisters = new ArrayList<>(); Cursor curs