Uses of Interface
org.jooq.Statement

Packages that use Statement

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 Statement in org.jooq

Subinterfaces of Statement 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	AlterTableDropStep	The step in the ALTER TABLE DSL used to DROP columns.
interface	AlterTableFinalStep	The final step in the ALTER TABLE DSL.
interface	AlterTableUsingIndexStep	The step in the ALTER TABLE ..
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	ContinueWhenStep	A step in the construction of an CONTINUE statement where a WHEN clause can be added.
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	Declaration<T>	A local variable declaration.
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	DeleteWhereStep<R extends Record>	This type is used for the Delete's DSL API.
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	ExitWhenStep	A step in the construction of an EXIT statement where a WHEN clause can be added.
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	IfElseStep	An intermediate step in building a procedural IF statement.
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	Query	Any query.
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 Statement

Modifier and Type	Method	Description
Statement	IfElseStep.else_(Collection<? extends Statement> statements)	Add an ELSE clause to the IF statement.
Statement	IfElseStep.else_(Statement... statements)	Add an ELSE clause to the IF statement.
Statement	Label.label(Statement statement)	Create a labelled statement.
Statement	LoopStep.loop(Collection<? extends Statement> statements)	Add a LOOP clause to the WHILE or FOR loop.
Statement	LoopStep.loop(Statement... statements)	Add a LOOP clause to the WHILE or FOR loop.
Statement	Parser.parseStatement(String sql)	Parse a SQL string to a procedural statement.
Statement	Parser.parseStatement(String sql, Object... bindings)	Parse a SQL string with bind variables to a procedural statement.
Statement	Declaration.set(Field<T> value)	Initialise this declaration.
Statement	Declaration.set(Select<? extends Record1<T>> value)	Initialise this declaration.
Statement	Declaration.set(T value)	Initialise this declaration.
Statement	Variable.set(Field<T> value)	Assign a value to this variable.
Statement	Variable.set(Select<? extends Record1<T>> value)	Assign a value to this variable.
Statement	Variable.set(T value)	Assign a value to this variable.
Statement	Declaration.setNull()	Initialise this declaration with null.
Statement	Variable.setNull()	Assign null to this variable.
Statement	RepeatUntilStep.until(Condition condition)	Add an UNTIL clause to the REPEAT loop.
Statement	ContinueWhenStep.when(Condition condition)	Add a WHEN clause to the CONTINUE statement.
Statement	ExitWhenStep.when(Condition condition)	Add a WHEN clause to the EXIT statement.

Methods in org.jooq with parameters of type Statement

Modifier and Type	Method	Description
Block	DSLContext.begin(Statement... statements)	Wrap a collection of statements in an anonymous procedural block.
Statement	IfElseStep.else_(Statement... statements)	Add an ELSE clause to the IF statement.
Statement	Label.label(Statement statement)	Create a labelled statement.
Statement	LoopStep.loop(Statement... statements)	Add a LOOP clause to the WHILE or FOR loop.
Block	DSLContext.statements(Statement... statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
IfElseStep	IfThenStep.then(Statement... statements)	Add a THEN clause to the IF statement.

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

Modifier and Type	Method	Description
Block	DSLContext.begin(Collection<? extends Statement> statements)	Wrap a collection of statements in an anoymous procedural block.
Statement	IfElseStep.else_(Collection<? extends Statement> statements)	Add an ELSE clause to the IF statement.
Statement	LoopStep.loop(Collection<? extends Statement> statements)	Add a LOOP clause to the WHILE or FOR loop.
Block	DSLContext.statements(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..
IfElseStep	IfThenStep.then(Collection<? extends Statement> statements)	Add a THEN clause to the IF statement.

Uses of Statement in org.jooq.impl

Methods in org.jooq.impl that return Statement

Modifier and Type	Method	Description
static Statement	DSL.continueWhen(Condition condition)	Create an CONTINUE statement for use in procedural code.
static Statement	DSL.execute(String sql)	Execute a statement dynamically from within procedural code.
static Statement	DSL.execute(Field<String> sql)	Execute a statement dynamically from within procedural code.
static Statement	DSL.exitWhen(Condition condition)	Create an EXIT statement for use in procedural code.
static Statement	DSL.goto_(Label label)	Create an GOTO statement for use in procedural code.
static Statement	DSL.loop(Collection<? extends Statement> statements)	Create a LOOP for use in procedural code.
static Statement	DSL.loop(Statement... statements)	Create a LOOP for use in procedural code.

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

Modifier and Type	Method	Description
Block	DefaultDSLContext.begin(Statement... statements)
static Block	DSL.begin(Statement... statements)	Wrap a collection of statements in an anonymous procedural block.
static Statement	DSL.loop(Statement... statements)	Create a LOOP for use in procedural code.
static RepeatUntilStep	DSL.repeat(Statement... statements)	Create a REPEAT loop for use in procedural code.
Block	DefaultDSLContext.statements(Statement... statements)
static Block	DSL.statements(Statement... statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..

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

Modifier and Type	Method	Description
Block	DefaultDSLContext.begin(Collection<? extends Statement> statements)
static Block	DSL.begin(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block.
static Statement	DSL.loop(Collection<? extends Statement> statements)	Create a LOOP for use in procedural code.
static RepeatUntilStep	DSL.repeat(Collection<? extends Statement> statements)	Create a REPEAT loop for use in procedural code.
Block	DefaultDSLContext.statements(Collection<? extends Statement> statements)
static Block	DSL.statements(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block that does not wrap in BEGIN ..