Method queryResultStringList

src/redempt/redlib/sql/SQLHelper.java:368–382

Executes a SQL query as a prepared statement, setting its fields to the elements of the vararg passed, returning a String 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 @retur

(String query, Object... fields)

     * column can be parsed into one.
     */
    public List<String> queryResultStringList(String query, Object... fields) {
        List<String> list = new ArrayList<>();
        try {
            PreparedStatement statement = prepareStatement(query, fields);
            ResultSet results = statement.executeQuery();
            while (results.next()) {
                list.add(results.getString(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.