Uses of Interface
org.jooq.Statement
Packages that use Statement
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Statement in org.jooq
Modifier and TypeInterfaceDescriptioninterfaceDeprecated, 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.interfaceA step in the construction of theALTER DOMAINstatement.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceAlterSequenceFlagsStep<T extends Number>A step in the construction of theALTER SEQUENCEstatement.interfaceAlterSequenceStep<T extends Number>A step in the construction of theALTER SEQUENCEstatement.interfaceThe step in theALTER TABLEDSL used toADDcolumns.interfaceThe step in theALTER TABLEDSL used toDROPcolumns or constraints.interfaceDeprecated, 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.interfaceThe step in theALTER TABLE … ADD CONSTRAINTstatement where an optional index can be specified to enforce the constraint.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceA procedural block.interfaceA step in the construction of theCALLstatement.interfaceAQuerythat holds a reference to the underlyingPreparedStatementwithout closing it, for reuse.interfaceCloseableResultQuery<R extends Record>AResultQuerythat holds a reference to the underlyingPreparedStatementwithout closing it, for reuse.interfaceDeprecated, 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.interfaceA step in the construction of anCONTINUEstatement where aWHENclause can be added.interfaceDeprecated, 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.interfaceA step in the construction of theCREATE DOMAINstatement.interfaceA step in the construction of theCREATE DOMAINstatement.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceA step in the construction of theCREATE INDEXstatement.interfaceA step in the construction of theCREATE INDEXstatement.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceA step in the construction of theCREATE SEQUENCEstatement.interfaceA step in the construction of theCREATE TABLEstatement.interfaceA step in the construction of theCREATE TABLEstatement.interfaceA step in the construction of theCREATE TABLEstatement.interfaceDeprecated, 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.interfaceA step in the construction of theCREATE TABLEstatement.interfaceA step in the construction of theCREATE TABLEstatement.interfaceA step in the construction of theCREATE TABLEstatement.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceA marker interface for all DDL queries.interfaceDeclaration<T>A local variable declaration.interfaceADELETEstatement.interfaceDeleteConditionStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteFinalStep<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.interfaceDeleteLimitStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteOrderByStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteQuery<R extends Record>ADELETEstatement (model API).interfaceDeleteResultStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteReturningStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteUsingStep<R extends Record>This type is used for theDelete's DSL API.interfaceDeleteWhereStep<R extends Record>This type is used for theDelete's DSL API.interfaceinterfaceDeprecated, 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.interfaceA step in the construction of theDROP DOMAINstatement.interfaceDeprecated, 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.interfaceA step in the construction of theDROP INDEXstatement.interfaceDeprecated, 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.interfaceA step in the construction of theDROP INDEXstatement.interfaceDeprecated, 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.interfaceA step in the construction of theDROP SCHEMAstatement.interfaceDeprecated, 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.interfaceDeprecated, 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.interfaceA step in the construction of theDROP TABLEstatement.interfaceDeprecated, 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.interfaceAQuerythat can drop types.interfaceDeprecated, 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.interfaceA step in the construction of anEXITstatement where aWHENclause can be added.interfaceDeprecated, 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.interfaceA step in the construction of theGRANTstatement.interfaceAn intermediate step in building a proceduralIFstatement.interfaceAnINSERTstatement.interfaceInsertFinalStep<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.interfaceInsertOnConflictConditionStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnConflictWhereStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnDuplicateSetMoreStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertOnDuplicateStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertQuery<R extends Record>AnINSERTstatement (model API).interfaceInsertResultStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertReturningStep<R extends Record>This type is used for theInsert's DSL API.interfaceInsertSetMoreStep<R extends Record>This type is used for theInsert's alternative DSL API.interfaceInsertValuesStep1<R extends Record,T1> This type is used for theInsert's DSL API.interfaceInsertValuesStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert's DSL API.interfaceInsertValuesStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert's DSL API.interfaceInsertValuesStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theInsert's DSL API.interfaceInsertValuesStep13<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.interfaceInsertValuesStep14<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.interfaceInsertValuesStep15<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.interfaceInsertValuesStep16<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.interfaceInsertValuesStep17<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.interfaceInsertValuesStep18<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.interfaceInsertValuesStep19<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.interfaceInsertValuesStep2<R extends Record,T1, T2> This type is used for theInsert's DSL API.interfaceInsertValuesStep20<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.interfaceInsertValuesStep21<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.interfaceInsertValuesStep22<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.interfaceInsertValuesStep3<R extends Record,T1, T2, T3> This type is used for theInsert's DSL API.interfaceInsertValuesStep4<R extends Record,T1, T2, T3, T4> This type is used for theInsert's DSL API.interfaceInsertValuesStep5<R extends Record,T1, T2, T3, T4, T5> This type is used for theInsert's DSL API.interfaceInsertValuesStep6<R extends Record,T1, T2, T3, T4, T5, T6> This type is used for theInsert's DSL API.interfaceInsertValuesStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert's DSL API.interfaceInsertValuesStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert's DSL API.interfaceInsertValuesStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert's DSL API.interfaceInsertValuesStepN<R extends Record>This type is used for theInsert's DSL API.interfaceA label for use in procedural code.interfaceAMERGEstatement.interfaceMergeFinalStep<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.interfaceMergeMatchedDeleteStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeNotMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.interfaceMergeOnConditionStep<R extends Record>This type is used for theMerge's DSL API.interfaceAny query.interfaceResultQuery<R extends Record>A query that can return results.interfaceDeprecated, 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.interfaceAny query that is not aResultQuery, and thus possibly produces a row count as a result, instead of aResult.interfaceASELECTstatement.interfaceSelectConditionStep<R extends Record>interfaceSelectConnectByAfterStartWithConditionStep<R extends Record>interfaceSelectConnectByConditionStep<R extends Record>interfaceSelectConnectByStep<R extends Record>interfaceSelectCorrelatedSubqueryStep<R extends Record>interfaceSelectDistinctOnStep<R extends Record>interfaceSelectFinalStep<R extends Record>interfaceSelectForJSONCommonDirectivesStep<R extends Record>interfaceSelectForStep<R extends Record>interfaceSelectForUpdateOfStep<R extends Record>interfaceSelectForUpdateStep<R extends Record>interfaceSelectForUpdateWaitStep<R extends Record>interfaceSelectForXMLCommonDirectivesStep<R extends Record>interfaceSelectForXMLPathDirectivesStep<R extends Record>interfaceSelectForXMLRawDirectivesStep<R extends Record>interfaceSelectFromStep<R extends Record>interfaceSelectGroupByStep<R extends Record>interfaceSelectHavingConditionStep<R extends Record>interfaceSelectHavingStep<R extends Record>interfaceSelectIntoStep<R extends Record>interfaceSelectJoinStep<R extends Record>interfaceSelectLimitAfterOffsetStep<R extends Record>interfaceSelectLimitPercentAfterOffsetStep<R extends Record>interfaceSelectLimitPercentStep<R extends Record>interfaceSelectLimitStep<R extends Record>interfaceSelectOffsetStep<R extends Record>interfaceSelectOnConditionStep<R extends Record>interfaceSelectOptionalOnStep<R extends Record>interfaceSelectOptionStep<R extends Record>interfaceSelectOrderByStep<R extends Record>interfaceSelectQualifyConditionStep<R extends Record>interfaceSelectQualifyStep<R extends Record>interfaceSelectQuery<R extends Record>ASELECTstatement (model API).interfaceSelectSeekLimitStep<R extends Record>interfaceSelectSeekStep1<R extends Record,T1> interfaceSelectSeekStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interfaceSelectSeekStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interfaceSelectSeekStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interfaceSelectSeekStep13<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interfaceSelectSeekStep14<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interfaceSelectSeekStep15<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interfaceSelectSeekStep16<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interfaceSelectSeekStep17<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interfaceSelectSeekStep18<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interfaceSelectSeekStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interfaceSelectSeekStep2<R extends Record,T1, T2> interfaceSelectSeekStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interfaceSelectSeekStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interfaceSelectSeekStep22<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> interfaceSelectSeekStep3<R extends Record,T1, T2, T3> interfaceSelectSeekStep4<R extends Record,T1, T2, T3, T4> interfaceSelectSeekStep5<R extends Record,T1, T2, T3, T4, T5> interfaceSelectSeekStep6<R extends Record,T1, T2, T3, T4, T5, T6> interfaceSelectSeekStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> interfaceSelectSeekStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> interfaceSelectSeekStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> interfaceSelectSeekStepN<R extends Record>interfaceSelectSelectStep<R extends Record>interfaceSelectStartWithStep<R extends Record>interfaceSelectUnionStep<R extends Record>interfaceSelectWhereStep<R extends Record>interfaceSelectWindowStep<R extends Record>interfaceSelectWithTiesAfterOffsetStep<R extends Record>interfaceSelectWithTiesStep<R extends Record>interfaceA step in the construction of theSIGNAL SQL STATEfunction.interfaceStoreQuery<R extends Record>A query storing objects to the database.interfaceA step in the construction of theTRUNCATEstatement.interfaceTruncateCascadeStep<R extends Record>A step in the construction of theTRUNCATEstatement.interfaceTruncateFinalStep<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.interfaceTruncateIdentityStep<R extends Record>A step in the construction of theTRUNCATEstatement.interfaceAnUPDATEstatement.interfaceUpdateConditionStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateFinalStep<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.interfaceUpdateFromStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateLimitStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateOrderByStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateQuery<R extends Record>AnUPDATEstatement (model API).interfaceUpdateResultStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateReturningStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateSetMoreStep<R extends Record>This type is used for theUpdate's DSL API.interfaceUpdateWhereStep<R extends Record>This type is used for theUpdate's DSL API.Modifier and TypeMethodDescription@NotNull StatementIfElseStep.else_(Collection<? extends Statement> statements) Add anELSEclause to theIFstatement.@NotNull StatementAdd anELSEclause to theIFstatement.@NotNull StatementCreate a labelled statement.@NotNull StatementLoopStep.loop(Collection<? extends Statement> statements) Add aLOOPclause to theWHILEorFORloop.@NotNull StatementAdd aLOOPclause to theWHILEorFORloop.@Nullable StatementParser.parseStatement(String sql) Parse a SQL string to a procedural statement.@Nullable StatementParser.parseStatement(String sql, Object... bindings) Parse a SQL string with bind variables to a procedural statement.@NotNull StatementInitialise this declaration.@NotNull StatementInitialise this declaration.@NotNull StatementInitialise this declaration.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow10.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow11.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow12.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow13.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow13.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13) Assign a value to this set of variables.@NotNull StatementRow14.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow14.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14) Assign a value to this set of variables.@NotNull StatementRow15.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow15.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15) Assign a value to this set of variables.@NotNull StatementRow16.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow16.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16) Assign a value to this set of variables.@NotNull StatementRow17.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow17.set(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> value) Assign a value to this set of variables.@NotNull StatementRow17.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17) Assign a value to this set of variables.@NotNull StatementRow18.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow18.set(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> value) Assign a value to this set of variables.@NotNull StatementRow18.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18) Assign a value to this set of variables.@NotNull StatementRow19.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow19.set(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> value) Assign a value to this set of variables.@NotNull StatementRow19.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow20.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow20.set(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> value) Assign a value to this set of variables.@NotNull StatementRow20.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20) Assign a value to this set of variables.@NotNull StatementRow21.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21) Assign a value to this set of variables.@NotNull StatementRow21.set(Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> record) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow21.set(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> value) Assign a value to this set of variables.@NotNull StatementRow21.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21) Assign a value to this set of variables.@NotNull StatementRow22.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22) Assign a value to this set of variables.@NotNull StatementRow22.set(Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> record) Assign a value to this set of variables.@NotNull StatementRow22.set(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row) Assign a value to this set of variables.@NotNull StatementRow22.set(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> value) Assign a value to this set of variables.@NotNull StatementRow22.set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21, T22 t22) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow7.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow8.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow9.set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9) Assign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this variable.@NotNull StatementAssign a value to this variable.@NotNull StatementAssign a value to this variable.@NotNull StatementSignalSetStep.setMessageText(String messageText) Add theSET MESSAGE TEXTclause to theSIGNAL SQL STATEfunction.@NotNull StatementSignalSetStep.setMessageText(Field<String> messageText) Add theSET MESSAGE TEXTclause to theSIGNAL SQL STATEfunction.@NotNull StatementDeclaration.setNull()Initialise this declaration withnull.@NotNull StatementVariable.setNull()Assignnullto this variable.@NotNull StatementAdd anUNTILclause to theREPEATloop.@NotNull StatementAdd aWHENclause to theCONTINUEstatement.@NotNull StatementAdd aWHENclause to theCONTINUEstatement.@NotNull StatementAdd aWHENclause to theEXITstatement.@NotNull StatementAdd aWHENclause to theEXITstatement.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Statement>Block.$statements()Experimental query object model accessor method, see alsoQOM.Modifier and TypeMethodDescription@NotNull DDLQueryAdd theASclause to theCREATE FUNCTIONstatement.@NotNull DDLQueryAdd theASclause to theCREATE FUNCTIONstatement.@NotNull DDLQueryAdd theASclause to theCREATE PROCEDUREstatement.@NotNull DDLQueryAdd theASclause to theCREATE PROCEDUREstatement.@NotNull DDLQueryAdd theASclause to theCREATE TRIGGERstatement.@NotNull DDLQueryAdd theASclause to theCREATE TRIGGERstatement.@NotNull BlockWrap a collection of statements in an anonymous procedural block.@NotNull StatementAdd anELSEclause to theIFstatement.@NotNull StatementCreate a labelled statement.@NotNull StatementAdd aLOOPclause to theWHILEorFORloop.@NotNull BlockDSLContext.statements(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;, unless explicitly needed.@NotNull IfElseStepAdd aTHENclause to theIFstatement.Modifier and TypeMethodDescription@NotNull DDLQueryCreateFunctionAsStep.as(Collection<? extends Statement> body) Add theASclause to theCREATE FUNCTIONstatement.@NotNull DDLQueryCreateProcedureAsStep.as(Collection<? extends Statement> body) Add theASclause to theCREATE PROCEDUREstatement.@NotNull DDLQueryCreateTriggerActionStep.as(Collection<? extends Statement> body) Add theASclause to theCREATE TRIGGERstatement.@NotNull BlockDSLContext.begin(Collection<? extends Statement> statements) Wrap a collection of statements in an anoymous procedural block.@NotNull StatementIfElseStep.else_(Collection<? extends Statement> statements) Add anELSEclause to theIFstatement.@NotNull StatementLoopStep.loop(Collection<? extends Statement> statements) Add aLOOPclause to theWHILEorFORloop.@NotNull BlockDSLContext.statements(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;, unless explicitly needed.@NotNull IfElseStepIfThenStep.then(Collection<? extends Statement> statements) Add aTHENclause to theIFstatement. -
Uses of Statement in org.jooq.impl
Subinterfaces of Statement in org.jooq.implModifier and TypeInterfaceDescriptionstatic interfaceTheALTER DATABASEstatement.static interfaceTheALTER DOMAINstatement.static interfaceTheALTER INDEXstatement.static interfaceTheALTER SCHEMAstatement.static interfaceQOM.AlterSequence<T extends Number>TheALTER SEQUENCEstatement.static interfaceTheALTER TYPEstatement.static interfaceTheALTER VIEWstatement.static interfacestatic interfaceTheCALLstatement.static interfaceTheCOMMENT ON TABLEstatement.static interfacestatic interfaceTheCREATE DATABASEstatement.static interfaceTheCREATE DOMAINstatement.static interfaceTheCREATE FUNCTIONstatement.static interfaceTheCREATE INDEXstatement.static interfaceTheCREATE PROCEDUREstatement.static interfaceTheCREATE SCHEMAstatement.static interfaceTheCREATE SEQUENCEstatement.static interfaceTheCREATE TABLEstatement.static interfaceTheCREATE TRIGGERstatement.static interfacestatic interfaceQOM.CreateView<R extends Record>static interfacestatic interfaceTheDROP DATABASEstatement.static interfaceTheDROP DOMAINstatement.static interfaceTheDROP FUNCTIONstatement.static interfaceTheDROP INDEXstatement.static interfaceTheDROP PROCEDUREstatement.static interfaceTheDROP SCHEMAstatement.static interfaceTheDROP SEQUENCEstatement.static interfaceTheDROP TABLEstatement.static interfaceTheDROP TRIGGERstatement.static interfacestatic interfaceTheDROP VIEWstatement.static interfaceTheEXECUTEfunction.static interfacestatic interfaceTheGOTOfunction.static interfaceTheGRANTstatement.static interfacestatic interfacestatic interfacestatic interfacestatic interfacestatic interfaceTheRETURN_function.static interfaceTheREVOKEstatement.static interfacestatic interfaceTheSET CATALOGstatement.static interfaceTheSETstatement.static interfaceTheSET SCHEMAstatement.static interfaceTheSIGNAL SQL STATEfunction.static interfaceQOM.Truncate<R extends Record>TheTRUNCATEstatement.Classes in org.jooq.impl that implement StatementModifier and TypeClassDescriptionclassA base class for customStatementimplementations in client code.Methods in org.jooq.impl that return StatementModifier and TypeMethodDescription@NotNull StatementQOM.CreateFunction.$body()@NotNull StatementQOM.CreateProcedure.$body()@NotNull StatementQOM.CreateTrigger.$body()@NotNull StatementQOM.LabelledStatement.$statement()static @NotNull StatementDSL.continueWhen(Condition condition) Create anCONTINUEstatement for use in procedural code.static @NotNull StatementDSL.continueWhen(Field<Boolean> condition) Create anCONTINUEstatement for use in procedural code.static @NotNull StatementDSL.declare(Collection<? extends Variable<?>> variables) Create a local variable declaration for use in procedural code.static @NotNull StatementCreate a local variable declaration for use in procedural code.static @NotNull StatementTheEXECUTEfunction.static @NotNull StatementTheEXECUTEfunction.static @NotNull StatementExecute a statement dynamically from within procedural code.static @NotNull StatementCreate anEXITstatement for use in procedural code.static @NotNull StatementCreate anEXITstatement for use in procedural code.static @NotNull StatementTheGOTOfunction.static @NotNull StatementInline all bind variables produced by the argumentStatement.static @NotNull StatementDSL.loop(Collection<? extends Statement> statements) Create aLOOPfor use in procedural code.static @NotNull StatementCreate aLOOPfor use in procedural code.static @NotNull StatementDSL.return_()TheRETURN_function.static @NotNull StatementTheRETURN_function.static @NotNull StatementTheRETURN_function.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.Methods in org.jooq.impl with parameters of type StatementModifier and TypeMethodDescription@NotNull QOM.CreateFunction@NotNull QOM.CreateProcedure@NotNull QOM.CreateTriggerstatic @NotNull BlockWrap a collection of statements in an anonymous procedural block.static @NotNull StatementInline all bind variables produced by the argumentStatement.static @NotNull StatementCreate aLOOPfor use in procedural code.static @NotNull RepeatUntilStepCreate aREPEATloop for use in procedural code.DefaultDSLContext.statements(Statement... statements) static @NotNull BlockDSL.statements(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;, unless explicitly needed.Method parameters in org.jooq.impl with type arguments of type StatementModifier and TypeMethodDescriptionDefaultDSLContext.begin(Collection<? extends Statement> statements) static @NotNull BlockDSL.begin(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block.static @NotNull StatementDSL.loop(Collection<? extends Statement> statements) Create aLOOPfor use in procedural code.static @NotNull RepeatUntilStepDSL.repeat(Collection<? extends Statement> statements) Create aREPEATloop for use in procedural code.DefaultDSLContext.statements(Collection<? extends Statement> statements) static @NotNull BlockDSL.statements(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;, unless explicitly needed.