Method querySingleResultString

src/redempt/redlib/sql/SQLHelper.java:264–279

Executes a SQL query as a prepared statement, setting its fields to the elements of the vararg passed, returning the value in the first column of the first row in the results as a String. @param query The SQL query to execute @param fields A vararg of the fields to set in the prepared statement @r

(String query, Object... fields)

     * column can be parsed into one.
     */
    public String querySingleResultString(String query, Object... fields) {
        try {
            PreparedStatement statement = prepareStatement(query, fields);
            ResultSet results = statement.executeQuery();
            if (!results.next()) {
                return null;
            }
            String val = results.getString(1);
            results.close();
            statement.close();
            return val;
        } catch (SQLException e) {
            sneakyThrow(e);
            return null;
        }
    }

    /**
     * Executes a SQL query as a prepared statement, setting its fields to the elements of the vararg passed,