Method prepareStatement

src/redempt/redlib/sql/SQLHelper.java:475–488

Prepares a statement, setting its fields to the elements of the vararg passed @param query The SQL query to prepare @param fields A vararg of the fields to set in the prepared statement @return The PreparedStatement with its fields set

(String query, Object... fields)

     * @return The PreparedStatement with its fields set
     */
    public PreparedStatement prepareStatement(String query, Object... fields) {
        try {
            PreparedStatement statement = connection.prepareStatement(query);
            int i = 1;
            for (Object object : fields) {
                statement.setObject(i, object);
                i++;
            }
            return statement;
        } catch (SQLException e) {
            sneakyThrow(e);
            return null;
        }
    }

    /**
     * Closes the underlying connection this SQLHelper wraps