Uses of Interface
org.jooq.Query

Packages that use Query

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.

Uses of Query in org.jooq

Subinterfaces of Query in org.jooq

Modifier and Type	Interface	Description
interface	AlterIndexFinalStep	The final step in the ALTER INDEX DSL.
interface	AlterSchemaFinalStep	The final step in the DROP SCHEMA DSL.
interface	AlterSequenceFinalStep	A Query that can alter sequences.
interface	AlterSequenceFlagsStep	The step in the ALTER SEQUENCE statement where the flags of the sequence are modified or cleared.
interface	AlterSequenceStep<T extends Number>	A Query that can alter sequences.
interface	AlterTableAddStep	The step in the ALTER TABLE DSL used to ADD columns.
interface	AlterTableDropStep	The step in the ALTER TABLE DSL used to DROP columns or constraints.
interface	AlterTableFinalStep	The final step in the ALTER TABLE DSL.
interface	AlterTableUsingIndexStep	The step in the ALTER TABLE ..
interface	AlterTypeFinalStep	A Query that can alter types.
interface	AlterViewFinalStep	The final step in the ALTER VIEW DSL.
interface	Block	A procedural block.
interface	CommentOnFinalStep	The final step for the creation of a COMMENT ON [ object type ] statement.
interface	CreateIndexFinalStep	A Query that can create indexes.
interface	CreateIndexIncludeStep	A Query that can create indexes.
interface	CreateIndexWhereStep	A Query that can create indexes.
interface	CreateSchemaFinalStep	A Query that can create schemas.
interface	CreateSequenceFinalStep	A Query that can create sequences.
interface	CreateSequenceFlagsStep	A Query that can create sequences.
interface	CreateTableColumnStep	A Query that can create tables.
interface	CreateTableCommentStep	A Query that can create tables.
interface	CreateTableConstraintStep	A Query that can create tables.
interface	CreateTableFinalStep	A Query that can create tables.
interface	CreateTableIndexStep	A Query that can create tables.
interface	CreateTableOnCommitStep	A Query that can create tables.
interface	CreateTableStorageStep	A Query that can create tables.
interface	CreateTableWithDataStep	A Query that can create tables.
interface	CreateTypeFinalStep	A Query that can create types.
interface	CreateViewFinalStep	A Query that can create views.
interface	DDLQuery	A marker interface for all DDL queries.
interface	Delete<R extends Record>	A DELETE statement.
interface	DeleteConditionStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteFinalStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteLimitStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteOrderByStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteQuery<R extends Record>	A DELETE statement (model API).
interface	DeleteResultStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteReturningStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteUsingStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteWhereStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DropIndexCascadeStep	A Query that can drop indexes.
interface	DropIndexFinalStep	A Query that can drop indexes.
interface	DropIndexOnStep	A Query that can drop indexes.
interface	DropSchemaFinalStep	The final step in the DROP SCHEMA DSL.
interface	DropSchemaStep	The step in the DROP SCHEMA DSL used to specify DROP behaviour.
interface	DropSequenceFinalStep	A Query that can drop sequences.
interface	DropTableFinalStep	The final step in the DROP TABLE DSL.
interface	DropTableStep	The step in the DROP TABLE DSL used to specify DROP behaviour.
interface	DropTypeFinalStep	A Query that can drop types.
interface	DropTypeStep	A Query that can drop types.
interface	DropViewFinalStep	The final step in the DROP VIEW DSL.
interface	GrantFinalStep	The final step in the creation of a REVOKE statement.
interface	GrantWithGrantOptionStep	The step of creation GRANT statement that assign user or role a grant option.
interface	Insert<R extends Record>	An INSERT statement.
interface	InsertFinalStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnConflictConditionStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnConflictWhereStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnDuplicateSetMoreStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnDuplicateStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertQuery<R extends Record>	An INSERT statement (model API).
interface	InsertResultStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertReturningStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertSetMoreStep<R extends Record>	This type is used for the Insert's alternative DSL API.
interface	InsertValuesStep1<R extends Record,T1>	This type is used for the Insert's DSL API.
interface	InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Insert's DSL API.
interface	InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Insert's DSL API.
interface	InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Insert's DSL API.
interface	InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Insert's DSL API.
interface	InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Insert's DSL API.
interface	InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Insert's DSL API.
interface	InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Insert's DSL API.
interface	InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Insert's DSL API.
interface	InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Insert's DSL API.
interface	InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Insert's DSL API.
interface	InsertValuesStep2<R extends Record,T1,T2>	This type is used for the Insert's DSL API.
interface	InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the Insert's DSL API.
interface	InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	This type is used for the Insert's DSL API.
interface	InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	This type is used for the Insert's DSL API.
interface	InsertValuesStep3<R extends Record,T1,T2,T3>	This type is used for the Insert's DSL API.
interface	InsertValuesStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Insert's DSL API.
interface	InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Insert's DSL API.
interface	InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Insert's DSL API.
interface	InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Insert's DSL API.
interface	InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Insert's DSL API.
interface	InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Insert's DSL API.
interface	InsertValuesStepN<R extends Record>	This type is used for the Insert's DSL API.
interface	Merge<R extends Record>	A MERGE statement.
interface	MergeFinalStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedDeleteStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeOnConditionStep<R extends Record>	This type is used for the Merge's DSL API.
interface	ResultQuery<R extends Record>	A query that can return results.
interface	RevokeFinalStep	The final step in the creation of a REVOKE statement.
interface	RowCountQuery	Any query that is not a ResultQuery, and thus possibly produces a row count as a result, instead of a Result.
interface	Select<R extends Record>	A SELECT statement.
interface	SelectConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByAfterStartWithConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectDistinctOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFinalStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateOfStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateWaitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFromStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectGroupByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectIntoStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectJoinStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOnConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionalOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOrderByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQualifyConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQualifyStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQuery<R extends Record>	A SELECT statement (model API).
interface	SelectSeekLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep1<R extends Record,T1>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep2<R extends Record,T1,T2>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep3<R extends Record,T1,T2,T3>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStepN<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSelectStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectStartWithStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectUnionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWhereStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWindowStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	StoreQuery<R extends Record>	A query storing objects to the database.
interface	Truncate<R extends Record>	A TRUNCATE statement.
interface	TruncateCascadeStep<R extends Record>	A Query that can truncate a table in the database.
interface	TruncateFinalStep<R extends Record>	A Query that can truncate a table in the database.
interface	TruncateIdentityStep<R extends Record>	A Query that can truncate a table in the database.
interface	Update<R extends Record>	An UPDATE statement.
interface	UpdateConditionStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateFinalStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateFromStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateLimitStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateOrderByStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateQuery<R extends Record>	An UPDATE statement (model API).
interface	UpdateResultStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateReturningStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateSetMoreStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateWhereStep<R extends Record>	This type is used for the Update's DSL API.

Methods in org.jooq that return Query

Modifier and Type	Method	Description
Query[]	ExecuteContext.batchQueries()	The jOOQ Query objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQ Query.
Query	Query.bind(int index, Object value)	Bind a new value to an indexed parameter.
Query	Query.bind(String param, Object value)	Bind a new value to a named parameter.
Query	Query.keepStatement(boolean keepStatement)	Keep the query's underlying statement open after execution.
Query	Parser.parseQuery(String sql)	Parse a SQL string to a query.
Query	Parser.parseQuery(String sql, Object... bindings)	Parse a SQL string with bind variables to a query.
Query	Query.poolable(boolean poolable)	Specify whether any JDBC Statement created by this query should be Statement.setPoolable(boolean).
Query[]	Queries.queries()	The wrapped collection of queries.
Query	ExecuteContext.query()	The jOOQ Query that is being executed or null if the query is unknown, if it is a batch query, or if there was no jOOQ Query.
Query	LoaderError.query()	The query whose execution failed.
Query	MigrationContext.query()	The current Query that is being executed.
Query	Query.queryTimeout(int seconds)	Specify the query timeout in number of seconds for the underlying JDBC Statement.

Methods in org.jooq that return types with arguments of type Query

Modifier and Type	Method	Description
Stream<Query>	Queries.queryStream()	The wrapped collection of queries.
Stream<Query>	Queries.stream()	Deprecated. - 3.10 - [#6143] - Use Queries.queryStream() instead.

Methods in org.jooq with parameters of type Query

Modifier and Type	Method	Description
Meta	Meta.apply(Query... migration)	Apply a migration to this meta to produce a new Meta.
Version	Version.apply(String id, Query... migration)	Apply a migration to produce a new version.
BatchBindStep	DSLContext.batch(Query query)	Create a batch statement to execute a set of queries in batch mode (with bind values).
Batch	DSLContext.batch(Query... queries)	Create a batch statement to execute a set of queries in batch mode (without bind values).
Batch	DSLContext.batch(Query query, Object[]... bindings)	Create a batch statement to execute a set of queries in batch mode (with bind values).
int	DSLContext.execute(Query query)	Execute a Query in the context of this DSLContext.
Explain	DSLContext.explain(Query query)	Run an EXPLAIN statement in the database to estimate the cardinality of the query.
Meta	DSLContext.meta(Query... queries)	Create meta data from a set of DDL queries.
Queries	DSLContext.queries(Query... queries)	Wrap a collection of queries.

Method parameters in org.jooq with type arguments of type Query

Modifier and Type	Method	Description
Meta	Meta.apply(Collection<? extends Query> migration)	Apply a migration to this meta to produce a new Meta.
Version	Version.apply(String id, Collection<? extends Query> migration)	Apply a migration to produce a new version.
Batch	DSLContext.batch(Collection<? extends Query> queries)	Create a batch statement to execute a set of queries in batch mode (without bind values).
Queries	DSLContext.queries(Collection<? extends Query> queries)	Wrap a collection of queries.

Uses of Query in org.jooq.impl

Methods in org.jooq.impl with parameters of type Query

Modifier and Type	Method	Description
BatchBindStep	DefaultDSLContext.batch(Query query)
Batch	DefaultDSLContext.batch(Query... queries)
Batch	DefaultDSLContext.batch(Query query, Object[]... bindings)
int	DefaultDSLContext.execute(Query query)
static Statement	DSL.execute(Query sql)	Execute a statement dynamically from within procedural code.
Explain	DefaultDSLContext.explain(Query query)
Meta	DefaultDSLContext.meta(Query... queries)
Queries	DefaultDSLContext.queries(Query... queries)
static Queries	DSL.queries(Query... queries)	Wrap a collection of queries.

Method parameters in org.jooq.impl with type arguments of type Query

Modifier and Type	Method	Description
Batch	DefaultDSLContext.batch(Collection<? extends Query> queries)
Queries	DefaultDSLContext.queries(Collection<? extends Query> queries)
static Queries	DSL.queries(Collection<? extends Query> queries)	Wrap a collection of queries.