Method queryResultList

src/redempt/redlib/sql/SQLHelper.java:342–356

Executes a SQL query as a prepared statement, setting its fields to the elements of the vararg passed, returning a list of values in the first column of each 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

(String query, Object... fields)

     * @return A list of the value in the first column of each row returned by the query
     */
    public <T> List<T> queryResultList(String query, Object... fields) {
        List<T> list = new ArrayList<>();
        try {
            PreparedStatement statement = prepareStatement(query, fields);
            ResultSet results = statement.executeQuery();
            while (results.next()) {
                list.add((T) results.getObject(1));
            }
            results.close();
            statement.close();
        } catch (SQLException e) {
            sneakyThrow(e);
        }
        return list;
    }

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