How to use

simpleQueryForString

method

in

android.database.sqlite.SQLiteStatement

@Test(expected = SQLiteDoneException.class)
public void simpleQueryForStringThrowsSQLiteDoneExceptionTest() throws Exception {
 //throw SQLiteDOneException if no rows returned.
 SQLiteStatement stmt = database.compileStatement("SELECT * FROM `countme` where `name`= 'cessationoftime'");
 assertThat(stmt.simpleQueryForString()).isEqualTo("0");
}

@Test
public void simpleQueryTest() throws Exception {
 SQLiteStatement stmt = database.compileStatement("SELECT count(*) FROM `countme`");
 assertThat(stmt.simpleQueryForLong()).isEqualTo(0L);
 assertThat(stmt.simpleQueryForString()).isEqualTo("0");
 SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `countme` (`name` ,`lastUsed` ) VALUES (?,?)");
 insertStatement.bindString(1, "Leg Press");
 insertStatement.bindLong(2, 0);
 insertStatement.executeInsert();
 assertThat(stmt.simpleQueryForLong()).isEqualTo(1L);
 assertThat(stmt.simpleQueryForString()).isEqualTo("1");
 insertStatement.bindString(1, "Bench Press");
 insertStatement.bindLong(2, 1);
 insertStatement.executeInsert();
 assertThat(stmt.simpleQueryForLong()).isEqualTo(2L);
 assertThat(stmt.simpleQueryForString()).isEqualTo("2");
}

  @Override
  public String simpleQueryForString() {
    return statement.simpleQueryForString();
  }
}

@Override
public String simpleQueryForString(String sql, Object[] bindArgs) {
  SQLiteStatement statement = null;
  try {
    statement = db.compileStatement(sql);
    SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs);
    return statement.simpleQueryForString();
  } finally {
    if (statement != null) {
      statement.close();
    }
  }
}

@Override
public String simpleQueryForString() {
  return mDelegate.simpleQueryForString();
}

public String simpleQueryForString() {
  return statement.simpleQueryForString();
}

@Nullable
@Override
public String simpleQueryForString() {
  return statement.simpleQueryForString();
}

 SQLiteStatement stmt = db.compileStatement("SELECT X FROM Y WHERE Z = ?");
...
stmt.bindString(1, "foo");
String x = stmt.simpleQueryForString();

@Override
synchronized public String getValue(String group, String name) {
  myGetValueStatement.bindString(1, group);
  myGetValueStatement.bindString(2, name);
  try {
    return myGetValueStatement.simpleQueryForString();
  } catch (SQLException e) {
    return null;
  }
}

@Override
synchronized public String getValue(String group, String name) {
  myGetValueStatement.bindString(1, group);
  myGetValueStatement.bindString(2, name);
  try {
    return myGetValueStatement.simpleQueryForString();
  } catch (SQLException e) {
    return null;
  }
}

@Override
synchronized public String getValue(String group, String name) {
  myGetValueStatement.bindString(1, group);
  myGetValueStatement.bindString(2, name);
  try {
    return myGetValueStatement.simpleQueryForString();
  } catch (SQLException e) {
    return null;
  }
}

private String getFirstMessageId(UUID server, String channel) {
  synchronized (mDatabaseLock) {
    waitForDatabase();
    mGetFirstMessageIdStatement.bindString(1, server.toString());
    mGetFirstMessageIdStatement.bindString(2, channel);
    String ret;
    try {
      ret = mGetFirstMessageIdStatement.simpleQueryForString();
    } catch (SQLiteDoneException ignored) {
      ret = null;
    }
    mGetFirstMessageIdStatement.clearBindings();
    return ret;
  }
}

@Override
protected String getHash(long bookId, long lastModified) throws NotAvailable {
  try {
    final SQLiteStatement statement = get(
      "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?"
    );
    synchronized (statement) {
      statement.bindLong(1, bookId);
      statement.bindLong(2, lastModified);
      try {
        return statement.simpleQueryForString();
      } catch (SQLiteDoneException e) {
        return null;
      }
    }
  } catch (Throwable t) {
    throw new NotAvailable();
  }
}

@Override
protected String getHash(long bookId, long lastModified) throws NotAvailable {
  try {
    final SQLiteStatement statement = get(
        "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?"
    );
    synchronized (statement) {
      statement.bindLong(1, bookId);
      statement.bindLong(2, lastModified);
      try {
        return statement.simpleQueryForString();
      } catch (SQLiteDoneException e) {
        return null;
      }
    }
  } catch (Throwable t) {
    throw new NotAvailable();
  }
}

@Override
protected String getHash(long bookId, long lastModified) throws NotAvailable {
  try {
    final SQLiteStatement statement = get(
        "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?"
    );
    synchronized (statement) {
      statement.bindLong(1, bookId);
      statement.bindLong(2, lastModified);
      try {
        return statement.simpleQueryForString();
      } catch (SQLiteDoneException e) {
        return null;
      }
    }
  } catch (Throwable t) {
    throw new NotAvailable();
  }
}

  username = prog.simpleQueryForString();
} catch (SQLiteDoneException e) {
  MyLog.ignored(TAG, e);

@NonNull
public static String conditionToStringColumnValue(SQLiteDatabase dbIn, String tableName, String columnName, String condition) {
  String method = "cond2str";
  SQLiteDatabase db = dbIn == null ? MyContextHolder.get().getDatabase() : dbIn;
  if (db == null) {
    MyLog.v(TAG, () -> method + "; Database is null");
    return "";
  }
  String sql = "SELECT " + columnName + " FROM " + tableName + " WHERE " + condition;
  String columnValue = "";
  if (StringUtils.isEmpty(tableName) || StringUtils.isEmpty(columnName)) {
    throw new IllegalArgumentException(method + " tableName or columnName are empty");
  } else if (StringUtils.isEmpty(columnName)) {
    throw new IllegalArgumentException("columnName is empty: " + sql);
  } else {
    try (SQLiteStatement prog = db.compileStatement(sql)) {
      columnValue = prog.simpleQueryForString();
    } catch (SQLiteDoneException e) {
      MyLog.ignored(TAG, e);
    } catch (Exception e) {
      MyLog.e(TAG, method + " table='" + tableName + "', column='" + columnName + "'", e);
      return "";
    }
    if (MyLog.isVerboseEnabled()) {
      MyLog.v(TAG, method + "; '" + sql + "' -> " + columnValue );
    }
  }
  return StringUtils.isEmpty(columnValue) ? "" : columnValue;
}

oid = prog.simpleQueryForString();