Package org.jdbi.v3.core.statement

Class Query

java.lang.Object

org.jdbi.v3.core.statement.BaseStatement<This>

org.jdbi.v3.core.statement.SqlStatement<Query>

org.jdbi.v3.core.statement.Query

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable, Configurable<Query>, ResultBearing

public class Query
extends SqlStatement<Query>
implements ResultBearing

Statement providing convenience result handling for SQL queries.

Nested Class Summary

Nested classes/interfaces inherited from class org.jdbi.v3.core.statement.BaseStatement

BaseStatement.StatementCustomizerInvocation

Field Summary

Fields inherited from class org.jdbi.v3.core.statement.SqlStatement

stmt

Fields inherited from class org.jdbi.v3.core.statement.BaseStatement

typedThis

Constructor Summary

Constructors

Constructor	Description
Query(Handle handle, java.lang.CharSequence sql)
Query(Handle handle, java.lang.String sql)	Backwards compatible constructor that takes an explicit string argument.

Method Summary

Modifier and Type	Method	Description
Query	concurrentUpdatable()	Specify that the result set should be concurrent updatable.
<R> R	execute(ResultProducer<R> producer)	Executes the query, returning the result obtained from the given ResultProducer.
<R> R	scanResultSet(ResultSetScanner<R> resultSetScanner)	Invokes the mapper with a result set supplier, and returns the value returned by the mapper.
Query	setFetchSize(int fetchSize)	Specify the fetch size for the query.
Query	setMaxFieldSize(int maxFields)	Specify the maximum field size in the result set.
Query	setMaxRows(int maxRows)	Specify the maximum number of rows the query is to return.

Methods inherited from class org.jdbi.v3.core.statement.SqlStatement

afterExecution, beforeBinding, beforeExecution, beforeTemplating, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindASCIIStream, bindASCIIStream, bindBean, bindBean, bindBeanList, bindBinaryStream, bindBinaryStream, bindBySqlType, bindBySqlType, bindByType, bindByType, bindByType, bindByType, bindByType, bindByType, bindFields, bindFields, bindList, bindList, bindList, bindList, bindList, bindList, bindList, bindMap, bindMethods, bindMethods, bindMethodsList, bindNamedArgumentFinder, bindNamedArgumentFinder, bindNull, bindNull, bindNVarchar, bindNVarchar, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, cleanupHandleCommit, cleanupHandleRollback, cleanupStatement, createStatement, defineList, defineList, defineNamedBindings, getBinding, getSql, internalExecute, mapperForType, mapperForType, mapperForType, parseSql, setQueryTimeout, toString

Methods inherited from class org.jdbi.v3.core.statement.BaseStatement

addCustomizers, attachToHandleForCleanup, callCustomizers, cleanUpForException, close, equals, getConfig, getContext, getHandle, hashCode

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jdbi.v3.core.config.Configurable

addCustomizer, configure, define, getConfig, registerArgument, registerArgument, registerArrayType, registerArrayType, registerArrayType, registerArrayType, registerCodecFactory, registerCollector, registerCollector, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerExtension, registerRowMapper, registerRowMapper, registerRowMapper, registerRowMapper, setMapKeyColumn, setMapValueColumn, setSqlArrayArgumentStrategy, setSqlLogger, setSqlParser, setTemplateEngine, setTimingCollector

Methods inherited from interface org.jdbi.v3.core.result.ResultBearing

collectInto, collectInto, collectInto, collectRows, map, map, map, mapTo, mapTo, mapTo, mapTo, mapToBean, mapToMap, mapToMap, mapToMap, reduceResultSet, reduceRows, reduceRows, reduceRows

Constructor Detail

Query

public Query(Handle handle,
             java.lang.CharSequence sql)

Query

public Query(Handle handle,
             java.lang.String sql)

Backwards compatible constructor that takes an explicit string argument.

See Also:

Query(Handle, CharSequence)

Method Detail

execute

public <R> R execute(ResultProducer<R> producer)

Executes the query, returning the result obtained from the given ResultProducer.

Type Parameters:

R - the type of the result

Parameters:

producer - the result producer.

Returns:

value returned by the result producer.

scanResultSet

public <R> R scanResultSet(ResultSetScanner<R> resultSetScanner)

Description copied from interface: ResultBearing

Invokes the mapper with a result set supplier, and returns the value returned by the mapper.

Specified by:

scanResultSet in interface ResultBearing

Type Parameters:

R - result type returned by the mapper.

Parameters:

resultSetScanner - result set scanner

Returns:

the value returned by the mapper.

setFetchSize

public Query setFetchSize(int fetchSize)

Specify the fetch size for the query. This should cause the results to be fetched from the underlying RDBMS in groups of rows equal to the number passed. This is useful for doing chunked streaming of results when exhausting memory could be a problem.

Parameters:

fetchSize - the number of rows to fetch in a bunch

Returns:

the modified query

setMaxRows

public Query setMaxRows(int maxRows)

Specify the maximum number of rows the query is to return. This uses the underlying JDBC Statement.setMaxRows(int)}.

Parameters:

maxRows - maximum number of rows to return

Returns:

modified query

setMaxFieldSize

public Query setMaxFieldSize(int maxFields)

Specify the maximum field size in the result set. This uses the underlying JDBC Statement.setMaxFieldSize(int)

Parameters:

maxFields - maximum field size

Returns:

modified query

concurrentUpdatable

public Query concurrentUpdatable()

Specify that the result set should be concurrent updatable. This will allow the update methods to be called on the result set produced by this Query.

Returns:

the modified query