Uses of Interface
org.jooq.Query
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Query in org.jooq
Modifier and TypeInterfaceDescriptioninterface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theALTER DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
AlterSequenceFlagsStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
AlterSequenceStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
The step in theALTER TABLE
DSL used toADD
columns.interface
The step in theALTER TABLE
DSL used toDROP
columns or constraints.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
The step in theALTER TABLE … ADD CONSTRAINT
statement where an optional index can be specified to enforce the constraint.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A procedural block.interface
A step in the construction of theCALL
statement.interface
AQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
CloseableResultQuery<R extends Record>
AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE DOMAIN
statement.interface
A step in the construction of theCREATE DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE INDEX
statement.interface
A step in the construction of theCREATE INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE SEQUENCE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A marker interface for all DDL queries.interface
ADELETE
statement.interface
DeleteConditionStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
DeleteLimitStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteOrderByStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteQuery<R extends Record>
ADELETE
statement (model API).interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteReturningStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteUsingStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteWhereStep<R extends Record>
This type is used for theDelete
's DSL API.interface
interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP SCHEMA
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
AQuery
that can drop types.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theGRANT
statement.interface
AnINSERT
statement.interface
InsertFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
InsertOnConflictConditionStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertQuery<R extends Record>
AnINSERT
statement (model API).interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertReturningStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertSetMoreStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertValuesStep1<R extends Record,
T1> This type is used for theInsert
's DSL API.interface
InsertValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert
's DSL API.interface
InsertValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert
'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 theInsert
'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 theInsert
'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 theInsert
'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 theInsert
'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 theInsert
'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 theInsert
'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 theInsert
'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 theInsert
's DSL API.interface
InsertValuesStep2<R extends Record,
T1, T2> This type is used for theInsert
'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 theInsert
'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 theInsert
'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 theInsert
's DSL API.interface
InsertValuesStep3<R extends Record,
T1, T2, T3> This type is used for theInsert
's DSL API.interface
InsertValuesStep4<R extends Record,
T1, T2, T3, T4> This type is used for theInsert
's DSL API.interface
InsertValuesStep5<R extends Record,
T1, T2, T3, T4, T5> This type is used for theInsert
's DSL API.interface
InsertValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> This type is used for theInsert
's DSL API.interface
InsertValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert
's DSL API.interface
InsertValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert
's DSL API.interface
InsertValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert
's DSL API.interface
InsertValuesStepN<R extends Record>
This type is used for theInsert
's DSL API.interface
AMERGE
statement.interface
MergeFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
MergeMatchedDeleteStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnConditionStep<R extends Record>
This type is used for theMerge
's DSL API.interface
ResultQuery<R extends Record>
A query that can return results.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Any query that is not aResultQuery
, and thus possibly produces a row count as a result, instead of aResult
.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> 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> 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> 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> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
StoreQuery<R extends Record>
A query storing objects to the database.interface
A step in the construction of theTRUNCATE
statement.interface
TruncateCascadeStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
TruncateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
TruncateIdentityStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
AnUPDATE
statement.interface
UpdateConditionStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
UpdateFromStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateLimitStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateOrderByStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateQuery<R extends Record>
AnUPDATE
statement (model API).interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateReturningStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetMoreStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateWhereStep<R extends Record>
This type is used for theUpdate
's DSL API.Modifier and TypeMethodDescription@NotNull Query
CallArgsStep.args
(Collection<? extends Field<?>> args) Add theARGS
clause to theCALL
statement.@NotNull Query
Add theARGS
clause to theCALL
statement.@NotNull Query @NotNull []
ExecuteContext.batchQueries()
The jOOQQuery
objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQQuery
.@NotNull Query
Bind a new value to an indexed parameter.@NotNull Query
Bind a new value to a named parameter.@Nullable Query
Parser.parseQuery
(String sql) Parse a SQL string to a query.@Nullable Query
Parser.parseQuery
(String sql, Object... bindings) Parse a SQL string with bind variables to a query.@NotNull Query
Query.poolable
(boolean poolable) Specify whether any JDBCStatement
created by this query should beStatement.setPoolable(boolean)
.@NotNull Query @NotNull []
Queries.queries()
The wrapped collection of queries.@Nullable Query
ExecuteContext.query()
The jOOQQuery
that is being executed ornull
if the query is unknown, if it is a batch query, or if there was no jOOQQuery
.LoaderError.query()
The query whose execution failed.@NotNull Query
MigrationContext.query()
The currentQuery
that is being executed.@NotNull Query
Query.queryTimeout
(int seconds) Specify the query timeout in number of seconds for the underlying JDBCStatement
.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Query>
Queries.$queries()
Experimental query object model accessor method, see alsoQOM
.Queries.queryStream()
The wrapped collection of queries.Queries.stream()
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6143] - UseQueries.queryStream()
instead.Modifier and TypeMethodDescription@NotNull Meta
Apply a migration to this meta to produce a newMeta
.@NotNull Version
Apply a migration to produce a new version.@NotNull BatchBindStep
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (with bind values).int
Execute aQuery
in the context of thisDSLContext
.@NotNull Explain
Run anEXPLAIN
statement in the database to estimate the cardinality of the query.@NotNull Meta
Create meta data from a set of DDL queries.@NotNull Queries
Wrap a collection of queries.Modifier and TypeMethodDescription@NotNull Meta
Meta.apply
(Collection<? extends Query> migration) Apply a migration to this meta to produce a newMeta
.@NotNull Version
Version.apply
(String id, Collection<? extends Query> migration) Apply a migration to produce a new version.@NotNull Batch
DSLContext.batch
(Collection<? extends Query> queries) Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Queries
DSLContext.queries
(Collection<? extends Query> queries) Wrap a collection of queries. -
Uses of Query in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
TheALTER DATABASE
statement.static interface
TheALTER DOMAIN
statement.static interface
TheALTER INDEX
statement.static interface
TheALTER SCHEMA
statement.static interface
QOM.AlterSequence<T extends Number>
TheALTER SEQUENCE
statement.static interface
TheALTER TYPE
statement.static interface
TheALTER VIEW
statement.static interface
TheCALL
statement.static interface
TheCOMMENT ON TABLE
statement.static interface
TheCREATE DATABASE
statement.static interface
TheCREATE DOMAIN
statement.static interface
TheCREATE FUNCTION
statement.static interface
TheCREATE INDEX
statement.static interface
TheCREATE PROCEDURE
statement.static interface
TheCREATE SCHEMA
statement.static interface
TheCREATE SEQUENCE
statement.static interface
TheCREATE TABLE
statement.static interface
TheCREATE TRIGGER
statement.static interface
static interface
QOM.CreateView<R extends Record>
static interface
TheDROP DATABASE
statement.static interface
TheDROP DOMAIN
statement.static interface
TheDROP FUNCTION
statement.static interface
TheDROP INDEX
statement.static interface
TheDROP PROCEDURE
statement.static interface
TheDROP SCHEMA
statement.static interface
TheDROP SEQUENCE
statement.static interface
TheDROP TABLE
statement.static interface
TheDROP TRIGGER
statement.static interface
static interface
TheDROP VIEW
statement.static interface
TheGRANT
statement.static interface
TheREVOKE
statement.static interface
TheSET CATALOG
statement.static interface
TheSET
statement.static interface
TheSET SCHEMA
statement.static interface
QOM.Truncate<R extends Record>
TheTRUNCATE
statement.Modifier and TypeMethodDescriptionint
static @NotNull Statement
Execute a statement dynamically from within procedural code.static @NotNull Queries
Wrap a collection of queries.Modifier and TypeMethodDescriptionDefaultDSLContext.batch
(Collection<? extends Query> queries) DefaultDSLContext.queries
(Collection<? extends Query> queries) static @NotNull Queries
DSL.queries
(Collection<? extends Query> queries) Wrap a collection of queries.