Uses of Class
com.blackrook.sql.SQLResult

Packages that use SQLResult

Package	Description
com.blackrook.sql	Contains classes relevant to querying SQL databases.

Uses of SQLResult in com.blackrook.sql

Methods in com.blackrook.sql that return SQLResult

Modifier and Type	Method	Description
static SQLResult	SQL.callStatement(PreparedStatement statement, boolean update, Object... parameters)	Performs a query on a connection and extracts the data into a SQLResult object.
static SQLResult	SQL.getResult(Connection connection, String query, Object... parameters)	Performs a query on a connection and extracts the data into a SQLResult.
SQLResult	SQLCallable.getResult(String query, Object... parameters)	Performs a query that returns rows and extracts them into a result.
SQLResult	SQLConnection.getResult(String query, Object... parameters)
SQLResult	SQLConnection.Transaction.getResult(String query, Object... parameters)
static SQLResult[]	SQL.getUpdateBatchResult(Connection connection, String query, Object[][] parameterList)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
static SQLResult[]	SQL.getUpdateBatchResult(Connection connection, String query, Collection<Object[]> parameterList)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
default SQLResult[]	SQLCallable.getUpdateBatchResult(String query, Object[][] parameterList)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
SQLResult[]	SQLCallable.getUpdateBatchResult(String query, Collection<Object[]> parameterList)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
SQLResult[]	SQLConnection.getUpdateBatchResult(String query, Collection<Object[]> parameterList)
SQLResult[]	SQLConnection.Transaction.getUpdateBatchResult(String query, Collection<Object[]> parameterList)
static SQLResult	SQL.getUpdateResult(Connection connection, String query, Object... parameters)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) on a connection and extracts the data/affected data/generated data into a SQLResult.
SQLResult	SQLCallable.getUpdateResult(String query, Object... parameters)	Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts the data/affected data/generated data into a SQLResult.
SQLResult	SQLConnection.getUpdateResult(String query, Object... parameters)
SQLResult	SQLConnection.Transaction.getUpdateResult(String query, Object... parameters)

Method parameters in com.blackrook.sql with type arguments of type SQLResult

Modifier and Type	Method	Description
protected Object	SQLAbstractDAO.id(SQLConnectionFunction<SQLResult> handler)	Gets a connection and performs a function on it, and if the affected row count is 1, return the id.
protected Object[]	SQLAbstractDAO.ids(SQLConnectionFunction<SQLResult> handler)	Gets a connection and performs a function on it, and returns the generated ids.
protected int	SQLAbstractDAO.rowCount(SQLConnectionFunction<SQLResult> handler)	Gets a connection and performs a function on it, returning the altered row count.
protected boolean	SQLAbstractDAO.updated(SQLConnectionFunction<SQLResult> handler)	Gets a connection and performs a function on it, and if the affected row count is 1, return true.
protected <V> SortedMap<String,V>	SQLAbstractDAO.valueCaseInsenstiveMap(SQLConnectionFunction<SQLResult> handler, BiConsumer<SQLRow,SortedMap<String,V>> extractor)	Lifts a map of values from a queried SQLResult and returns it as an immutable map of case-insensitive string key to value.
protected <R> List<R>	SQLAbstractDAO.valueList(SQLConnectionFunction<SQLResult> handler, Function<SQLRow,R> extractor)	Lifts a list of single values from a queried SQLResult and returns it as an immutable list.
protected <K, V> Map<K,V>	SQLAbstractDAO.valueMap(SQLConnectionFunction<SQLResult> handler, BiConsumer<SQLRow,Map<K,V>> extractor)	Lifts a map of values from a queried SQLResult and returns it as an immutable map of key to value.
protected <R> Set<R>	SQLAbstractDAO.valueSet(SQLConnectionFunction<SQLResult> handler, Function<SQLRow,R> extractor)	Lifts a list of single values from a queried SQLResult and returns it as an immutable set of unique values.
protected <K, V> SortedMap<K,V>	SQLAbstractDAO.valueSortedMap(SQLConnectionFunction<SQLResult> handler, BiConsumer<SQLRow,SortedMap<K,V>> extractor)	Lifts a sorted map of values from a queried SQLResult and returns it as an immutable map of key to value.
protected <R> SortedSet<R>	SQLAbstractDAO.valueSortedSet(SQLConnectionFunction<SQLResult> handler, Function<SQLRow,R> extractor)	Lifts a list of single values from a queried SQLResult and returns it as an immutable sorted set of unique values.