public void clearFeedTable() { String sql = "DELETE FROM " + SQLHelper.TABLE_CHANNEL + ";"; SQLiteDatabase db = helper.getWritableDatabase(); db.execSQL(sql); revertSeq(); System.out.println("我是否删除"); }
@Override public boolean updateCache(ContentValues values, String whereClause, String[] whereArgs) { // TODO Auto-generated method stub boolean flag = false; SQLiteDatabase database = null; int count = 0; try { database = helper.getWritableDatabase(); count = database.update(SQLHelper.TABLE_CHANNEL, values, whereClause, whereArgs); flag = (count > 0 ? true : false); } catch (Exception e) { // TODO: handle exception } finally { if (database != null) { database.close(); } } return flag; }
@Override public List<Map<String, String>> listCache(String selection, String[] selectionArgs) { // TODO Auto-generated method stub List<Map<String, String>> list = new ArrayList<Map<String, String>>(); SQLiteDatabase database = null; Cursor cursor = null; try { database = helper.getReadableDatabase(); cursor = database.query( false, SQLHelper.TABLE_CHANNEL, null, selection, selectionArgs, null, null, null, null); int cols_len = cursor.getColumnCount(); while (cursor.moveToNext()) { Map<String, String> map = new HashMap<String, String>(); for (int i = 0; i < cols_len; i++) { String cols_name = cursor.getColumnName(i); String cols_values = cursor.getString(cursor.getColumnIndex(cols_name)); if (cols_values == null) { cols_values = ""; } map.put(cols_name, cols_values); } list.add(map); } } catch (Exception e) { // TODO: handle exception } finally { if (database != null) { database.close(); } } return list; }
@Override public boolean addCache(ChannelItem item) { // TODO Auto-generated method stub boolean flag = false; SQLiteDatabase database = null; long id = -1; try { database = helper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("name", item.getName()); values.put("id", item.getId()); values.put("orderId", item.getOrderId()); values.put("selected", item.getSelected()); id = database.insert(SQLHelper.TABLE_CHANNEL, null, values); flag = (id != -1 ? true : false); } catch (Exception e) { // TODO: handle exception } finally { if (database != null) { database.close(); } } return flag; }
private void revertSeq() { String sql = "update sqlite_sequence set seq=0 where name='" + SQLHelper.TABLE_CHANNEL + "'"; SQLiteDatabase db = helper.getWritableDatabase(); db.execSQL(sql); }