DbQuery (Jodd API Documentation)

java.lang.Object
- jodd.db.DbQuery<Q>

All Implemented Interfaces:

java.lang.AutoCloseable

Direct Known Subclasses:

DbOomQuery
```
public class DbQuery<Q extends DbQuery>
extends java.lang.Object
```
Encapsulates Statement and all its operations.
It may be:
- used in an un-managed way, created directly from connection;
- managed by DbSession;
- managed by DbThreadSession i.e. ThreadDbSessionHolder.
Query life-cycle states:
- 1) created: statement == null, initialized == false
- 2) initialized: statement != null, initialized == true
- 3) closed: statement == null, initialized == true

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class jodd.db.DbQueryBase.State
Query states.

Nested Classes
Modifier and Type	Class and Description
`static class`	`jodd.db.DbQueryBase.State` Query states.

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`autoClose`
`protected java.sql.CallableStatement`	`callableStatement`
`protected QueryConcurrencyType`	`concurrencyType`
`protected java.sql.Connection`	`connection`
`protected DbOom`	`dbOom`
`protected boolean`	`debug`
`protected long`	`elapsed`
`protected int`	`fetchSize`
`protected boolean`	`forcePreparedStatement` If set to `true` all created statements will be prepared.
`protected java.lang.String[]`	`generatedColumns`
`protected QueryHoldability`	`holdability`
`protected int`	`maxRows`
`protected java.sql.PreparedStatement`	`preparedStatement`
`protected jodd.db.DbQueryParser`	`query`
`protected jodd.db.DbQueryBase.State`	`queryState`
`protected java.util.Set<java.sql.ResultSet>`	`resultSets`
`protected DbSession`	`session`
`protected java.lang.String`	`sqlString`
`protected long`	`start`
`protected java.sql.Statement`	`statement`
`protected static int`	`totalOpenResultSetCount`
`protected QueryScrollType`	`type`

Constructor Summary

Constructors
Constructor and Description
`DbQuery(DbOom dbOom, java.sql.Connection conn, java.lang.String sqlString)` Creates new query.
`DbQuery(DbOom dbOom, DbSession session, java.lang.String sqlString)` Creates a new query from `DbSession`.
`DbQuery(DbOom dbOom, java.lang.String sqlString)` Creates a new query using default session provider.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected Q`	`_this()`
`Q`	`autoClose()` Defines that query should be automatically closed immediately after using.
`protected void`	`checkCreated()` Checks if query is created (and not yet initialized or closed) and throws an exception if it is not.
`protected void`	`checkInitialized()` Checks if query is initialized and throws an exception if it is not.
`protected void`	`checkNotClosed()` Checks if query is not closed and throws an exception if it is.
`Q`	`clearParameters()` Clears the current parameter values immediately.
`void`	`close()` Closes the query and all created results sets and detaches itself from the session.
`Q`	`closeAllResultSets()` Closes all result sets created by this query.
`Q`	`closeCursorsAtCommit()`
`protected java.sql.SQLException`	`closeQuery()` Closes all assigned result sets and then closes the query.
`void`	`closeResultSet(java.sql.ResultSet rs)` Closes single result set that was created by this query.
`Q`	`concurrentReadOnly()`
`Q`	`concurrentUpdatable()`
`java.sql.ResultSet`	`execute()` Executes the query.
`DbCallResult`	`executeCall()`
`long`	`executeCount()` Special execute() for 'select count(*)' queries.
`protected long`	`executeCount(boolean close)` Executes count queries and optionally closes query afterwards.
`int`	`executeUpdate()` Executes UPDATE, INSERT or DELETE queries.
`protected int`	`executeUpdate(boolean closeQuery)` Executes UPDATE, INSERT or DELETE queries and optionally closes the query.
`<T> T`	`find(QueryMapper<T> queryMapper)` `Executes` the query and `maps` single result row.
`Q`	`forcePreparedStatement()` Forces creation of prepared statements.
`QueryConcurrencyType`	`getConcurrencyType()`
`long`	`getExecutionTime()` Returns query execution elapsed time in milliseconds.
`int`	`getFetchSize()` Returns fetch size.
`java.lang.String[]`	`getGeneratedColumnNames()` Returns generated column names.
`java.sql.ResultSet`	`getGeneratedColumns()` Returns generated columns.
`long`	`getGeneratedKey()` Returns generated key i.e. first generated column as `long`.
`java.lang.Object`	`getGeneratedKeyObject()`
`QueryHoldability`	`getHoldability()`
`int`	`getMaxRows()` Returns max rows.
`int`	`getOpenResultSetCount()` Returns number of created result sets that are still not explicitly closed.
`jodd.db.DbQueryBase.State`	`getQueryState()` Returns query state.
`java.lang.String`	`getQueryString()` Returns query SQL string.
`DbSession`	`getSession()` Returns used `DbSession`.
`static int`	`getTotalOpenResultSetCount()` Returns total number of open result sets.
`QueryScrollType`	`getType()`
`Q`	`holdCursorsOverCommit()`
`void`	`init()` Initializes the query if not already initialized.
`protected void`	`initializeJdbc()` Performs JDBC initialization of the query.
`protected void`	`initSession(DbSession session)` Initializes session.
`boolean`	`isActive()` Returns `true` if query is active: created and possibly initialized.
`boolean`	`isClosed()` Returns `true` if query is closed.
`boolean`	`isInDebugMode()`
`boolean`	`isInitialized()` Returns `true` if query is initialized.
`<T> java.util.List<T>`	`list(QueryMapper<T> queryMapper)` `Executes` the query, iterates result set and `maps` each row.
`<T> java.util.Set<T>`	`listSet(QueryMapper<T> queryMapper)` `Executes` the query, iterates all rows and `maps` them.
`Q`	`outBoolean(int index)`
`Q`	`outBoolean(java.lang.String param)`
`Q`	`outByte(int index)`
`Q`	`outByte(java.lang.String param)`
`Q`	`outDouble(int index)`
`Q`	`outDouble(java.lang.String param)`
`Q`	`outFloat(int index)`
`Q`	`outFloat(java.lang.String param)`
`Q`	`outInteger(int index)`
`Q`	`outInteger(java.lang.String param)`
`Q`	`outLong(int index)`
`Q`	`outLong(java.lang.String param)`
`Q`	`outString(int index)`
`Q`	`outString(java.lang.String param)`
`protected void`	`prepareQuery()` Prepares the query just after the initialization.
`static DbQuery`	`query(java.sql.Connection conn, java.lang.String sqlString)`
`static DbQuery`	`query(DbSession session, java.lang.String sqlString)`
`static DbQuery`	`query(java.lang.String sqlString)`
`Q`	`resetGeneratedColumns()` Resets creating generated columns.
`protected void`	`saveResultSet(java.sql.ResultSet rs)` Stores result set.
`Q`	`setArray(int index, java.sql.Array value)`
`Q`	`setArray(java.lang.String param, java.sql.Array value)`
`Q`	`setAsciiStream(int index, java.io.InputStream stream)`
`Q`	`setAsciiStream(int index, java.io.InputStream stream, int length)`
`Q`	`setAsciiStream(java.lang.String param, java.io.InputStream stream)`
`Q`	`setAsciiStream(java.lang.String param, java.io.InputStream stream, int length)`
`Q`	`setBatch(java.lang.String name, int[] array, int startingIndex)` Sets batch parameters with given array of values.
`Q`	`setBatch(java.lang.String name, long[] array, int startingIndex)` Sets batch parameters with given array of values.
`Q`	`setBatch(java.lang.String name, java.lang.Object[] array, int startingIndex)` Sets batch parameters with given array of values.
`Q`	`setBean(java.lang.String beanName, java.lang.Object bean)` Sets bean parameters from bean.
`Q`	`setBigDecimal(int index, java.math.BigDecimal value)`
`Q`	`setBigDecimal(java.lang.String param, java.math.BigDecimal value)`
`Q`	`setBigInteger(int index, java.math.BigInteger value)`
`Q`	`setBigInteger(java.lang.String param, java.math.BigInteger value)`
`Q`	`setBlob(int index, java.sql.Blob value)`
`Q`	`setBlob(java.lang.String param, java.sql.Blob value)`
`Q`	`setBoolean(int index, boolean value)`
`Q`	`setBoolean(int index, java.lang.Boolean value)`
`Q`	`setBoolean(java.lang.String param, boolean value)`
`Q`	`setBoolean(java.lang.String param, java.lang.Boolean value)`
`Q`	`setByte(int index, byte value)`
`Q`	`setByte(int index, java.lang.Number value)`
`Q`	`setByte(java.lang.String param, byte value)`
`Q`	`setByte(java.lang.String param, java.lang.Number value)`
`Q`	`setBytes(int index, byte[] value)`
`Q`	`setBytes(java.lang.String param, byte[] value)`
`Q`	`setCharacterStream(int index, java.io.Reader reader, int length)`
`Q`	`setCharacterStream(java.lang.String param, java.io.Reader reader, int length)`
`Q`	`setClob(int index, java.sql.Clob value)`
`Q`	`setClob(java.lang.String param, java.sql.Clob value)`
`Q`	`setConcurrencyType(QueryConcurrencyType concurrencyType)`
`Q`	`setDate(int index, java.sql.Date value)`
`Q`	`setDate(java.lang.String param, java.sql.Date value)`
`Q`	`setDebug(boolean debug)`
`Q`	`setDebugMode()`
`Q`	`setDouble(int index, double value)`
`Q`	`setDouble(int index, java.lang.Number value)`
`Q`	`setDouble(java.lang.String param, double value)`
`Q`	`setDouble(java.lang.String param, java.lang.Number value)`
`Q`	`setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
`Q`	`setFloat(int index, float value)`
`Q`	`setFloat(int index, java.lang.Number value)`
`Q`	`setFloat(java.lang.String param, float value)`
`Q`	`setFloat(java.lang.String param, java.lang.Number value)`
`Q`	`setGeneratedColumns(java.lang.String... columns)` Specifies columns which values will be generated by database.
`Q`	`setGeneratedKey()` Specifies that database will generate some columns values, usually the single id.
`Q`	`setHoldability(QueryHoldability holdability)`
`Q`	`setInteger(int index, int value)`
`Q`	`setInteger(int index, java.lang.Number value)`
`Q`	`setInteger(java.lang.String param, int value)`
`Q`	`setInteger(java.lang.String param, java.lang.Number value)`
`Q`	`setLong(int index, long value)`
`Q`	`setLong(int index, java.lang.Number value)`
`Q`	`setLong(java.lang.String param, long value)`
`Q`	`setLong(java.lang.String param, java.lang.Number value)`
`Q`	`setMap(java.util.Map parameters)` Sets properties from the map.
`Q`	`setMaxRows(int maxRows)` Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.
`Q`	`setNull(int index, int type)`
`Q`	`setNull(int index, int type, java.lang.String typeName)`
`Q`	`setNull(java.lang.String param, int type)`
`Q`	`setNull(java.lang.String param, int value, java.lang.String typeName)`
`Q`	`setObject(int index, java.lang.Object value)`
`Q`	`setObject(int index, java.lang.Object value, java.lang.Class<? extends SqlType> sqlTypeClass, int dbSqlType)` Sets object parameter in an advanced way.
`Q`	`setObject(int index, java.lang.Object object, int targetSqlType)` Sets the value of the designated parameter with the given object.
`Q`	`setObject(java.lang.String param, java.lang.Object value)`
`Q`	`setObject(java.lang.String param, java.lang.Object value, java.lang.Class<? extends SqlType> sqlTypeClass, int dbSqlType)`
`Q`	`setObject(java.lang.String param, java.lang.Object object, int targetSqlType)` Sets the value of the designated parameter with the given object.
`Q`	`setObjects(java.lang.Object... objects)` Sets an array of objects parameters in given order.
`Q`	`setObjects(java.lang.String[] names, java.lang.Object[] values)` Sets sql parameters from two arrays: names and values.
`Q`	`setRef(int index, java.sql.Ref value)`
`Q`	`setRef(java.lang.String param, java.sql.Ref value)`
`Q`	`setShort(int index, java.lang.Number value)`
`Q`	`setShort(int index, short value)`
`Q`	`setShort(java.lang.String param, java.lang.Number value)`
`Q`	`setShort(java.lang.String param, short value)`
`Q`	`setString(int index, java.lang.String value)`
`Q`	`setString(java.lang.String param, java.lang.String value)`
`Q`	`setTime(int index, java.sql.Time value)`
`Q`	`setTime(java.lang.String param, java.sql.Time value)`
`Q`	`setTimestamp(int index, java.sql.Timestamp value)`
`Q`	`setTimestamp(java.lang.String param, java.sql.Timestamp value)`
`Q`	`setType(QueryScrollType type)`
`Q`	`setURL(int index, java.net.URL value)`
`Q`	`setURL(java.lang.String param, java.net.URL value)`
`java.lang.String`	`toString()`
`Q`	`typeForwardOnly()`
`Q`	`typeScrollInsensitive()`
`Q`	`typeScrollSensitive()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

dbOom
```
protected final DbOom dbOom
```

queryState

protected jodd.db.DbQueryBase.State queryState

connection

protected java.sql.Connection connection

session
```
protected DbSession session
```

sqlString
```
protected java.lang.String sqlString
```

statement
```
protected java.sql.Statement statement
```

preparedStatement

protected java.sql.PreparedStatement preparedStatement

callableStatement

protected java.sql.CallableStatement callableStatement

resultSets

protected java.util.Set<java.sql.ResultSet> resultSets

query
```
protected jodd.db.DbQueryParser query
```

forcePreparedStatement
```
protected boolean forcePreparedStatement
```
If set to true all created statements will be prepared.

autoClose
```
protected boolean autoClose
```

type
```
protected QueryScrollType type
```

concurrencyType

protected QueryConcurrencyType concurrencyType

holdability
```
protected QueryHoldability holdability
```

debug
```
protected boolean debug
```

generatedColumns

protected java.lang.String[] generatedColumns

fetchSize
```
protected int fetchSize
```

maxRows
```
protected int maxRows
```

start
```
protected long start
```

elapsed
```
protected long elapsed
```

totalOpenResultSetCount

protected static int totalOpenResultSetCount

Constructor Detail

DbQuery

public DbQuery(DbOom dbOom,
               java.sql.Connection conn,
               java.lang.String sqlString)

Creates new query.

DbQuery

public DbQuery(DbOom dbOom,
               DbSession session,
               java.lang.String sqlString)

Creates a new query from DbSession.

DbQuery

public DbQuery(DbOom dbOom,
               java.lang.String sqlString)

Creates a new query using default session provider.

Method Detail

query

public static DbQuery query(java.sql.Connection conn,
                            java.lang.String sqlString)

query

public static DbQuery query(DbSession session,
                            java.lang.String sqlString)

query

public static DbQuery query(java.lang.String sqlString)

clearParameters
```
public Q clearParameters()
```
Clears the current parameter values immediately.
In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method clearParameters.

setNull

public Q setNull(int index,
                 int type)

setNull

public Q setNull(java.lang.String param,
                 int type)

setNull

public Q setNull(int index,
                 int type,
                 java.lang.String typeName)

setNull

public Q setNull(java.lang.String param,
                 int value,
                 java.lang.String typeName)

setInteger

public Q setInteger(int index,
                    int value)

setInteger

public Q setInteger(java.lang.String param,
                    int value)

outInteger
```
public Q outInteger(int index)
```

outInteger

public Q outInteger(java.lang.String param)

setInteger

public Q setInteger(int index,
                    java.lang.Number value)

setInteger

public Q setInteger(java.lang.String param,
                    java.lang.Number value)

setBoolean

public Q setBoolean(int index,
                    boolean value)

setBoolean

public Q setBoolean(java.lang.String param,
                    boolean value)

outBoolean
```
public Q outBoolean(int index)
```

outBoolean

public Q outBoolean(java.lang.String param)

setBoolean

public Q setBoolean(int index,
                    java.lang.Boolean value)

setBoolean

public Q setBoolean(java.lang.String param,
                    java.lang.Boolean value)

setLong

public Q setLong(int index,
                 long value)

setLong

public Q setLong(java.lang.String param,
                 long value)

setLong

public Q setLong(int index,
                 java.lang.Number value)

setLong

public Q setLong(java.lang.String param,
                 java.lang.Number value)

outLong
```
public Q outLong(int index)
```

outLong

public Q outLong(java.lang.String param)

setByte

public Q setByte(int index,
                 byte value)

setByte

public Q setByte(java.lang.String param,
                 byte value)

outByte
```
public Q outByte(int index)
```

outByte

public Q outByte(java.lang.String param)

setByte

public Q setByte(int index,
                 java.lang.Number value)

setByte

public Q setByte(java.lang.String param,
                 java.lang.Number value)

setBytes

public Q setBytes(int index,
                  byte[] value)

setBytes

public Q setBytes(java.lang.String param,
                  byte[] value)

setDouble

public Q setDouble(int index,
                   double value)

setDouble

public Q setDouble(java.lang.String param,
                   double value)

outDouble
```
public Q outDouble(int index)
```

outDouble

public Q outDouble(java.lang.String param)

setDouble

public Q setDouble(int index,
                   java.lang.Number value)

setDouble

public Q setDouble(java.lang.String param,
                   java.lang.Number value)

setFloat

public Q setFloat(int index,
                  float value)

setFloat

public Q setFloat(java.lang.String param,
                  float value)

outFloat
```
public Q outFloat(int index)
```

outFloat

public Q outFloat(java.lang.String param)

setFloat

public Q setFloat(int index,
                  java.lang.Number value)

setFloat

public Q setFloat(java.lang.String param,
                  java.lang.Number value)

setShort

public Q setShort(int index,
                  short value)

setShort

public Q setShort(java.lang.String param,
                  short value)

setShort

public Q setShort(int index,
                  java.lang.Number value)

setShort

public Q setShort(java.lang.String param,
                  java.lang.Number value)

setString

public Q setString(int index,
                   java.lang.String value)

setString

public Q setString(java.lang.String param,
                   java.lang.String value)

outString
```
public Q outString(int index)
```

outString

public Q outString(java.lang.String param)

setDate

public Q setDate(int index,
                 java.sql.Date value)

setDate

public Q setDate(java.lang.String param,
                 java.sql.Date value)

setTime

public Q setTime(int index,
                 java.sql.Time value)

setTime

public Q setTime(java.lang.String param,
                 java.sql.Time value)

setTimestamp

public Q setTimestamp(int index,
                      java.sql.Timestamp value)

setTimestamp

public Q setTimestamp(java.lang.String param,
                      java.sql.Timestamp value)

setBigDecimal

public Q setBigDecimal(int index,
                       java.math.BigDecimal value)

setBigDecimal

public Q setBigDecimal(java.lang.String param,
                       java.math.BigDecimal value)

setBigInteger

public Q setBigInteger(int index,
                       java.math.BigInteger value)

setBigInteger

public Q setBigInteger(java.lang.String param,
                       java.math.BigInteger value)

setURL

public Q setURL(int index,
                java.net.URL value)

setURL

public Q setURL(java.lang.String param,
                java.net.URL value)

setBlob

public Q setBlob(int index,
                 java.sql.Blob value)

setBlob

public Q setBlob(java.lang.String param,
                 java.sql.Blob value)

setClob

public Q setClob(int index,
                 java.sql.Clob value)

setClob

public Q setClob(java.lang.String param,
                 java.sql.Clob value)

setArray

public Q setArray(int index,
                  java.sql.Array value)

setArray

public Q setArray(java.lang.String param,
                  java.sql.Array value)

setRef

public Q setRef(int index,
                java.sql.Ref value)

setRef

public Q setRef(java.lang.String param,
                java.sql.Ref value)

setAsciiStream

public Q setAsciiStream(int index,
                        java.io.InputStream stream)

setAsciiStream

public Q setAsciiStream(java.lang.String param,
                        java.io.InputStream stream)

setAsciiStream

public Q setAsciiStream(int index,
                        java.io.InputStream stream,
                        int length)

setAsciiStream

public Q setAsciiStream(java.lang.String param,
                        java.io.InputStream stream,
                        int length)

setCharacterStream

public Q setCharacterStream(int index,
                            java.io.Reader reader,
                            int length)

setCharacterStream

public Q setCharacterStream(java.lang.String param,
                            java.io.Reader reader,
                            int length)

setBean

public Q setBean(java.lang.String beanName,
                 java.lang.Object bean)

Sets bean parameters from bean. Non-existing bean properties are ignored.

setMap

public Q setMap(java.util.Map parameters)

Sets properties from the map.

setObject
```
public Q setObject(int index,
                   java.lang.Object object,
                   int targetSqlType)
```
Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.

setObject
```
public Q setObject(java.lang.String param,
                   java.lang.Object object,
                   int targetSqlType)
```
Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.

setObject

public Q setObject(int index,
                   java.lang.Object value)

See Also:: setObject(String, Object, Class, int)

setObject
```
public Q setObject(int index,
                   java.lang.Object value,
                   java.lang.Class<? extends SqlType> sqlTypeClass,
                   int dbSqlType)
```
Sets object parameter in an advanced way.
First, it checks if object is null and invokes setNull if so. If object is not null, it tries to resolve sql type (by looking up or using provided class) and use it for setting data. If sql type is not found, default setObject is invoked.

setObject

public Q setObject(java.lang.String param,
                   java.lang.Object value)

See Also:: setObject(String, Object, Class, int)

setObject

public Q setObject(java.lang.String param,
                   java.lang.Object value,
                   java.lang.Class<? extends SqlType> sqlTypeClass,
                   int dbSqlType)

See Also:: setObject(String, Object, Class, int)

setObjects
```
public Q setObjects(java.lang.Object... objects)
```
Sets an array of objects parameters in given order.

setObjects

public Q setObjects(java.lang.String[] names,
                    java.lang.Object[] values)

Sets sql parameters from two arrays: names and values.

setBatch

public Q setBatch(java.lang.String name,
                  int[] array,
                  int startingIndex)

Sets batch parameters with given array of values.

setBatch

public Q setBatch(java.lang.String name,
                  long[] array,
                  int startingIndex)

Sets batch parameters with given array of values.

setBatch

public Q setBatch(java.lang.String name,
                  java.lang.Object[] array,
                  int startingIndex)

Sets batch parameters with given array of values.

autoClose
```
public Q autoClose()
```
Defines that query should be automatically closed immediately after using. Should be called before actual statement execution.

_this
```
protected Q _this()
```

getQueryState

public jodd.db.DbQueryBase.State getQueryState()

Returns query state.

checkNotClosed
```
protected void checkNotClosed()
```
Checks if query is not closed and throws an exception if it is.

checkCreated
```
protected void checkCreated()
```
Checks if query is created (and not yet initialized or closed) and throws an exception if it is not.

checkInitialized
```
protected void checkInitialized()
```
Checks if query is initialized and throws an exception if it is not.

isClosed
```
public boolean isClosed()
```
Returns true if query is closed.

isActive
```
public boolean isActive()
```
Returns true if query is active: created and possibly initialized. Opened query may be not initialized.

isInitialized
```
public boolean isInitialized()
```
Returns true if query is initialized. Initialized query is the one that has created JDBC statements.

getSession
```
public DbSession getSession()
```
Returns used DbSession.

saveResultSet

protected void saveResultSet(java.sql.ResultSet rs)

Stores result set.

forcePreparedStatement
```
public Q forcePreparedStatement()
```
Forces creation of prepared statements.

init
```
public final void init()
```
Initializes the query if not already initialized. Usually, user doesn't have to invoke it at all, since it will be called before all methods that deals directly with JDBC statement. Throws an exception if called on closed query.

initSession
```
protected void initSession(DbSession session)
```
Initializes session. When not specified (i.e. is null), session is fetched from session provider.

initializeJdbc
```
protected void initializeJdbc()
```
Performs JDBC initialization of the query. Obtains connection, parses the SQL query string and creates statements. Initialization is performed only once, when switching to initialized state.

prepareQuery
```
protected void prepareQuery()
```
Prepares the query just after the initialization. Query is fully set and ready.

closeAllResultSets
```
public Q closeAllResultSets()
```
Closes all result sets created by this query. Query remains active.

closeQuery
```
protected java.sql.SQLException closeQuery()
```
Closes all assigned result sets and then closes the query. Query becomes closed.

close
```
public void close()
```
Closes the query and all created results sets and detaches itself from the session.

Specified by:

close in interface java.lang.AutoCloseable

closeResultSet
```
public void closeResultSet(java.sql.ResultSet rs)
```
Closes single result set that was created by this query. It is not necessary to close result sets explicitly, since DbQueryBase.close() method closes all created result sets. Query remains active.

getType
```
public QueryScrollType getType()
```

setType

public Q setType(QueryScrollType type)

typeForwardOnly
```
public Q typeForwardOnly()
```

typeScrollSensitive
```
public Q typeScrollSensitive()
```

typeScrollInsensitive
```
public Q typeScrollInsensitive()
```

getConcurrencyType

public QueryConcurrencyType getConcurrencyType()

setConcurrencyType

public Q setConcurrencyType(QueryConcurrencyType concurrencyType)

concurrentReadOnly
```
public Q concurrentReadOnly()
```

concurrentUpdatable
```
public Q concurrentUpdatable()
```

getHoldability

public QueryHoldability getHoldability()

setHoldability

public Q setHoldability(QueryHoldability holdability)

holdCursorsOverCommit
```
public Q holdCursorsOverCommit()
```

closeCursorsAtCommit
```
public Q closeCursorsAtCommit()
```

isInDebugMode
```
public boolean isInDebugMode()
```

setDebug
```
public Q setDebug(boolean debug)
```

setDebugMode
```
public Q setDebugMode()
```

getGeneratedColumnNames
```
public java.lang.String[] getGeneratedColumnNames()
```
Returns generated column names.

setGeneratedColumns
```
public Q setGeneratedColumns(java.lang.String... columns)
```
Specifies columns which values will be generated by database.

setGeneratedKey
```
public Q setGeneratedKey()
```
Specifies that database will generate some columns values, usually the single id.

resetGeneratedColumns
```
public Q resetGeneratedColumns()
```
Resets creating generated columns.

getFetchSize
```
public int getFetchSize()
```
Returns fetch size.

See Also:

setFetchSize(int)

setFetchSize
```
public Q setFetchSize(int rows)
```
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero.

See Also:

Statement.setFetchSize(int)

getMaxRows
```
public int getMaxRows()
```
Returns max rows.

See Also:

setMaxRows(int)

setMaxRows
```
public Q setMaxRows(int maxRows)
```
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped. Zero means there is no limit.

See Also:

Statement.setMaxRows(int)

getExecutionTime
```
public long getExecutionTime()
```
Returns query execution elapsed time in milliseconds. Returns -1 if query is still not executed.

execute
```
public java.sql.ResultSet execute()
```
Executes the query. If this method is invoked at least once, the query or all created ResultSets must be explicitly closed at the end of query usage. This can be done explicitly by calling DbQueryBase.closeResultSet(ResultSet) оr implicitly, during DbQueryBase.close().

See Also:

Statement.execute(String)

executeCall
```
public DbCallResult executeCall()
```

executeUpdate
```
public int executeUpdate()
```
Executes UPDATE, INSERT or DELETE queries. Query is not closed afterwards unless auto close mode is set.

See Also:

Statement.executeUpdate(String)

executeUpdate
```
protected int executeUpdate(boolean closeQuery)
```
Executes UPDATE, INSERT or DELETE queries and optionally closes the query.

See Also:

Statement.executeUpdate(String)

executeCount
```
public long executeCount()
```
Special execute() for 'select count(*)' queries. Query is not closed after the execution unless auto-close mode is set. Doesn't check if query is really a count query, so it would work for any query that has number in the first column of result. If result set returns zero rows (very unlikely), returns -1.

executeCount
```
protected long executeCount(boolean close)
```
Executes count queries and optionally closes query afterwards.

list

public <T> java.util.List<T> list(QueryMapper<T> queryMapper)

Executes the query, iterates result set and maps each row.

find

public <T> T find(QueryMapper<T> queryMapper)

Executes the query and maps single result row.

listSet

public <T> java.util.Set<T> listSet(QueryMapper<T> queryMapper)

Executes the query, iterates all rows and maps them.

getGeneratedColumns

public java.sql.ResultSet getGeneratedColumns()

Returns generated columns.

getGeneratedKey
```
public long getGeneratedKey()
```
Returns generated key i.e. first generated column as long.

getGeneratedKeyObject

public java.lang.Object getGeneratedKeyObject()

getQueryString
```
public java.lang.String getQueryString()
```
Returns query SQL string. For prepared statements, returned sql string with quick-and-dirty replaced values.

toString
```
public java.lang.String toString()
```
Overrides:

toString in class java.lang.Object

See Also:

getQueryString()

getTotalOpenResultSetCount
```
public static int getTotalOpenResultSetCount()
```
Returns total number of open result sets.

See Also:

getOpenResultSetCount()

getOpenResultSetCount
```
public int getOpenResultSetCount()
```
Returns number of created result sets that are still not explicitly closed.

See Also:

getTotalOpenResultSetCount()

Class DbQuery<Q extends DbQuery>

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

dbOom

queryState

connection

session

sqlString

statement

preparedStatement

callableStatement

resultSets

query

forcePreparedStatement

autoClose

type

concurrencyType

holdability

debug

generatedColumns

fetchSize

maxRows

start

elapsed

totalOpenResultSetCount

Constructor Detail

DbQuery

DbQuery

DbQuery

Method Detail

query

query

query

clearParameters

setNull

setNull

setNull

setNull

setInteger

setInteger

outInteger

outInteger

setInteger

setInteger

setBoolean

setBoolean

outBoolean

outBoolean

setBoolean

setBoolean

setLong

setLong

setLong

setLong

outLong

outLong

setByte

setByte

outByte

outByte

setByte

setByte

setBytes

setBytes

setDouble

setDouble

outDouble

outDouble

setDouble

setDouble

setFloat

setFloat

outFloat

outFloat

setFloat

setFloat