Example #1
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;
  }