Example #1
0
 public void clearFeedTable() {
   String sql = "DELETE FROM " + SQLHelper.TABLE_CHANNEL + ";";
   SQLiteDatabase db = helper.getWritableDatabase();
   db.execSQL(sql);
   revertSeq();
   System.out.println("我是否删除");
 }
Example #2
0
 @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;
 }
Example #3
0
  @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;
  }
Example #4
0
 @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;
 }
Example #5
0
 private void revertSeq() {
   String sql = "update sqlite_sequence set seq=0 where name='" + SQLHelper.TABLE_CHANNEL + "'";
   SQLiteDatabase db = helper.getWritableDatabase();
   db.execSQL(sql);
 }