コード例 #1
0
  // Gets the primary keys to Sync the next set of rows
  public List<String> getKeyColumn(String fieldname, String tabname, String orderby) {
    List<String> keyList = null;
    try {
      String query = "SELECT DISTINCT " + fieldname + " FROM " + tabname + " Order by  " + orderby;
      Cursor cursor = dbOperations.executeRawQuery(query);
      keyList = getKeyColumnResultSet(cursor);
      cursor.close();
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();

      throw new RuntimeException(e.toString());
    }
    return keyList;
  }
コード例 #2
0
  // Gets the specific set of rows for deletion
  public List<String> getRows(String fieldname, String key, String tabname, String value) {
    List<String> keyList = null;
    try {
      String query =
          "SELECT " + fieldname + " FROM " + tabname + " Where " + key + " in (" + value + ")";
      Cursor cursor = dbOperations.executeRawQuery(query);
      keyList = getKeyColumnResultSet(cursor);
      cursor.close();
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();

      throw new RuntimeException(e.toString());
    }
    return keyList;
  }