public interface SelectQuery
| Modifier and Type | Method and Description |
|---|---|
SelectQuery |
fetchSize(Integer rows)
Sets fetch size of select statements - the number of rows returned in a single network round-trip.
|
<T> SelectQuery |
filter(java.util.function.Predicate<T> predicate)
Sets a result filter.
|
<T> Optional<T> |
firstResult(Mapper<T> mapper)
Runs the select query and returns first result - if any
|
<T> void |
iterateResult(Mapper<T> mapper,
java.util.function.Consumer<T> consumer)
Runs the select query and provides results to the given consumer
|
<T> List<T> |
listResult(Mapper<T> mapper)
Runs the select query and returns results as an immutable list
|
SelectQuery |
maxRows(Long rows)
Limits the number of rows returned by the database for a select statement.
|
SelectQuery |
namedParam(String name,
Object parameter)
Adds a named query parameter
|
SelectQuery |
namedParams(Map<String,?> namedParams)
Adds named query paramaters.
|
SelectQuery |
params(List<?> params)
Adds positional query parameters.
|
SelectQuery |
params(Object... params)
Adds positional query parameters.
|
<T> Set<T> |
setResult(Mapper<T> mapper)
Runs the select query and returns results as an immutable set
|
<T> T |
singleResult(Mapper<T> mapper)
Runs the select query and returns a single result.
|
SelectQuery params(List<?> params)
params - additional query parametersSelectQuery params(Object... params)
params - additional query parametersSelectQuery namedParams(Map<String,?> namedParams)
namedParams - additional named query parametersSelectQuery namedParam(String name, Object parameter)
name - name of parameterparameter - value of parameter<T> SelectQuery filter(java.util.function.Predicate<T> predicate)
T - result typepredicate - filterSelectQuery fetchSize(Integer rows)
rows - Number of rows fetched by a select statement.SelectQuery maxRows(Long rows)
rows - number of rows<T> Optional<T> firstResult(Mapper<T> mapper)
T - result typemapper - ResultSet mapper<T> T singleResult(Mapper<T> mapper)
T - result typemapper - ResultSet mapperFluentJdbcException - if no result found<T> List<T> listResult(Mapper<T> mapper)
T - result typemapper - ResultSet mapper<T> Set<T> setResult(Mapper<T> mapper)
T - result typemapper - ResultSet mapper<T> void iterateResult(Mapper<T> mapper, java.util.function.Consumer<T> consumer)
T - result typemapper - ResultSet mapperconsumer - Consumer accepting the resultsCopyright © 2016. All rights reserved.