Method querySingleResult

src/redempt/redlib/sql/SQLHelper.java:237–252

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 @param query The SQL query to execute @param fields A vararg of the fields to set in the prepared statement @param T

(String query, Object... fields)

     * @return The value in the first column of the first row of the returned results, or null if none is present
     */
    public <T> T querySingleResult(String query, Object... fields) {
        try {
            PreparedStatement statement = prepareStatement(query, fields);
            ResultSet results = statement.executeQuery();
            if (!results.next()) {
                return null;
            }
            T obj = (T) results.getObject(1);
            results.close();
            statement.close();
            return obj;
        } 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,