org.jooq

Interface Query

All Superinterfaces:

Attachable, QueryPart, Serializable

All Known Subinterfaces:

Delete<R>, DeleteConditionStep<R>, DeleteFinalStep<R>, DeleteQuery<R>, DeleteWhereStep<R>, Insert<R>, InsertFinalStep<R>, InsertOnDuplicateSetMoreStep<R>, InsertOnDuplicateStep<R>, InsertQuery<R>, InsertResultStep<R>, InsertSetMoreStep<R>, InsertValuesStep1<R,T1>, InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>, InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>, InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>, InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>, InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>, InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>, InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>, InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>, InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>, InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>, InsertValuesStep2<R,T1,T2>, InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>, InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>, InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>, InsertValuesStep3<R,T1,T2,T3>, InsertValuesStep4<R,T1,T2,T3,T4>, InsertValuesStep5<R,T1,T2,T3,T4,T5>, InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>, InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>, InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>, InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>, InsertValuesStepN<R>, Merge<R>, MergeFinalStep<R>, MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeNotMatchedSetMoreStep<R>, MergeNotMatchedStep<R>, MergeNotMatchedWhereStep<R>, MergeOnConditionStep<R>, ResultQuery<R>, Select<R>, SelectConditionStep<R>, SelectConnectByConditionStep<R>, SelectConnectByStep<R>, SelectFinalStep<R>, SelectForUpdateOfStep<R>, SelectForUpdateStep<R>, SelectForUpdateWaitStep<R>, SelectFromStep<R>, SelectGroupByStep<R>, SelectHavingConditionStep<R>, SelectHavingStep<R>, SelectJoinStep<R>, SelectLimitStep<R>, SelectOffsetStep<R>, SelectOnConditionStep<R>, SelectOptionalOnStep<R>, SelectOrderByStep<R>, SelectQuery<R>, SelectSelectStep<R>, SelectStartWithStep<R>, SelectWhereStep<R>, StoreQuery<R>, Truncate<R>, Update<R>, UpdateConditionStep<R>, UpdateFinalStep<R>, UpdateQuery<R>, UpdateResultStep<R>, UpdateSetMoreStep<R>, UpdateWhereStep<R>

public interface Query
extends QueryPart, Attachable

Any query

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
Query	bind(int index, Object value) Bind a new value to an indexed parameter [#1886] If the bind value at index is inlined ( Param.isInline()) or if this query was created with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.
Query	bind(String param, Object value) Bind a new value to a named parameter [#1886] If the bind value with name param is inlined ( Param.isInline()) or if this query was created with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.
void	cancel() Cancel the underlying statement This cancels the query's underlying Statement or PreparedStatement.
void	close() Close the underlying statement This closes the query's underlying Statement or PreparedStatement if a previous call to keepStatement(boolean) indicated that jOOQ should keep statements open after query execution.
int	execute() Execute the query, if it has been created with a properly configured factory
List<Object>	getBindValues() Retrieve the bind values that will be bound by this Query.
Param<?>	getParam(String name) Get a named parameter from the Query, provided its name.
Map<String,Param<?>>	getParams() Get a Map of named parameters.
String	getSQL() Retrieve the SQL code rendered by this Query This method can be expected to work correctly for any SQL dialect, as a query is usually "attached" when created from a DSLContext.
String	getSQL(boolean inline) Retrieve the SQL code rendered by this Query See getSQL() for more details
boolean	isExecutable() Whether this query is executable in its current state DML queries may be incomplete in structure and thus not executable.
Query	keepStatement(boolean keepStatement) Keep the query's underlying statement open after execution This indicates to jOOQ that the query's underlying Statement or PreparedStatement should be kept open after execution.
Query	queryTimeout(int timeout) Specify the query timeout for the underlying JDBC Statement

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach

Method Detail

execute

int execute()
            throws DataAccessException

Execute the query, if it has been created with a properly configured factory

Returns:

A result value, depending on the concrete implementation of Query:

• Delete : the number of deleted records
• Insert : the number of inserted records
• Merge : the result may have no meaning
• Select : the number of resulting records
• Truncate : the result may have no meaning
• Update : the number of updated records

Throws:

DataAccessException - If anything goes wrong in the database

isExecutable

boolean isExecutable()

Whether this query is executable in its current state

DML queries may be incomplete in structure and thus not executable. Calling execute() on such queries has no effect, but beware that getSQL() may not render valid SQL!

getSQL

String getSQL()

Retrieve the SQL code rendered by this Query

This method can be expected to work correctly for any SQL dialect, as a query is usually "attached" when created from a DSLContext.

Use this method, when you want to use jOOQ for object oriented query creation, but execute the query with some other technology, such as

• JDBC
• Spring Templates
• JPA native queries
• etc...

Note, this is the same as calling getSQL(boolean). The boolean parameter will depend on your DSLContext's Settings:

StatementType	boolean parameter	effect
StatementType.PREPARED_STATEMENT	false (default)	This will render bind variables to be used with a JDBC PreparedStatement. You can extract bind values from this Query using getBindValues()
StatementType.STATIC_STATEMENT	true	This will inline all bind variables in a statement to be used with a JDBC Statement

See Also:

getSQL(boolean)

getSQL

String getSQL(boolean inline)

Retrieve the SQL code rendered by this Query

See getSQL() for more details

Parameters:

inline - Whether to inline bind variables. This overrides values in Settings.getStatementType()

Returns:

The generated SQL

getBindValues

List<Object> getBindValues()

Retrieve the bind values that will be bound by this Query. This List cannot be modified. To modify bind values, use getParams() instead.

See Also:

DSLContext.extractBindValues(QueryPart)

getParams

Map<String,Param<?>> getParams()

Get a Map of named parameters. The Map itself cannot be modified, but the Param elements allow for modifying bind values on an existing Query.

Bind values created with DSL.val(Object) will have their bind index as name.

See Also:

Param, DSL.param(String, Object), DSLContext.extractParams(QueryPart)

getParam

Param<?> getParam(String name)

Get a named parameter from the Query, provided its name.

Bind values created with DSL.val(Object) will have their bind index as name.

See Also:

Param, DSL.param(String, Object), DSLContext.extractParam(QueryPart, String)

bind

Query bind(String param,
         Object value)
           throws IllegalArgumentException,
                  DataTypeException

Bind a new value to a named parameter

[#1886] If the bind value with name param is inlined ( Param.isInline()) or if this query was created with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Parameters:

param - The named parameter name. If this is a number, then this is the same as calling bind(int, Object)

value - The new bind value.

Throws:

IllegalArgumentException - if there is no parameter by the given parameter name or index.

DataTypeException - if value cannot be converted into the parameter's data type

bind

Query bind(int index,
         Object value)
           throws IllegalArgumentException,
                  DataTypeException

Bind a new value to an indexed parameter

[#1886] If the bind value at index is inlined ( Param.isInline()) or if this query was created with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Parameters:

index - The parameter index, starting with 1

value - The new bind value.

Throws:

IllegalArgumentException - if there is no parameter by the given parameter index.

DataTypeException - if value cannot be converted into the parameter's data type

queryTimeout

Query queryTimeout(int timeout)

Specify the query timeout for the underlying JDBC Statement

See Also:

Statement.setQueryTimeout(int)

keepStatement

Query keepStatement(boolean keepStatement)

Keep the query's underlying statement open after execution

This indicates to jOOQ that the query's underlying Statement or PreparedStatement should be kept open after execution. If it is kept open, client code is responsible for properly closing it using close()

Parameters:

keepStatement - Whether to keep the underlying statement open

close

void close()
           throws DataAccessException

Close the underlying statement

This closes the query's underlying Statement or PreparedStatement if a previous call to keepStatement(boolean) indicated that jOOQ should keep statements open after query execution. If there is no underlying open statement, this call is simply ignored.

Throws:

DataAccessException - If something went wrong closing the statement

See Also:

Statement.close()

cancel

void cancel()
            throws DataAccessException

Cancel the underlying statement

This cancels the query's underlying Statement or PreparedStatement. If there is no underlying open and running statement, this call is simply ignored.

Throws:

DataAccessException - If something went wrong cancelling the statement

See Also:

Statement.cancel()