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. |
org.jooq.util.h2 |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.H2 dialect. |
org.jooq.util.hsqldb |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.HSQLDB dialect. |
org.jooq.util.oracle |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.ORACLE dialect. |
org.jooq.util.postgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.POSTGRES dialect. |
Modifier and Type | Interface and Description |
---|---|
interface |
Cursor<R extends Record>
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet . |
interface |
Delete<R extends Record>
A
Query that can delete data in the database. |
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 |
DeleteQuery<R extends Record>
A query used for deletion of data
|
interface |
DeleteWhereStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
ForeignKey<R extends Record,O extends Record>
A
ForeignKey is an object referencing a UniqueKey . |
interface |
ForeignKey<R extends Record,O extends Record>
A
ForeignKey is an object referencing a UniqueKey . |
interface |
FutureResult<R extends Record>
Deprecated.
- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0
|
interface |
Identity<R extends Record,T>
An
Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard. |
interface |
Insert<R extends Record>
A
Query that can insert data in the database. |
interface |
InsertFinalStep<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 |
InsertOnDuplicateSetStep<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>
A query for data insertion
|
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 |
InsertSetStep<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 |
Key<R extends Record>
A
Key is an object representing a UNIQUE KEY , a
PRIMARY KEY , or a FOREIGN KEY . |
interface |
Merge<R extends Record>
A
Query that can merge data in the database. |
interface |
MergeFinalStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeKeyStep1<R extends Record,T1>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep16<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep17<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep18<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep19<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep20<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep21<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep22<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeKeyStepN<R extends Record>
This type is used for the H2-specific variant of 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 |
MergeMatchedSetStep<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 |
MergeNotMatchedSetStep<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 |
MergeNotMatchedValuesStep1<R extends Record,T1>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep16<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep17<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep18<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep19<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep2<R extends Record,T1,T2>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep20<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep21<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep22<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
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStepN<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 |
MergeOnStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeUsingStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeValuesStep1<R extends Record,T1>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep16<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep17<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep18<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep19<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep20<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep21<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep22<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 H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeValuesStepN<R extends Record>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
QuantifiedSelect<R extends Record>
A participant of a quantified comparison predicate
A
QuantifiedSelect models the right hand side of a quantified
comparison predicate. |
interface |
RecordHandler<R extends Record>
A
RecordHandler is a handler that can receive Record
objects, when fetching data from the database. |
interface |
RecordMapper<R extends Record,E>
A
RecordMapper is a mapper that can receive Record
objects, when fetching data from the database, transforming them into a
custom type <E> |
interface |
RecordType<R extends Record>
|
interface |
Result<R extends Record>
A wrapper for database results returned by
|
interface |
ResultQuery<R extends Record>
A query that can return results.
|
interface |
Select<R extends Record>
|
interface |
SelectConditionStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
interface |
SelectFinalStep<R extends Record>
|
interface |
SelectForUpdateOfStep<R extends Record>
|
interface |
SelectForUpdateStep<R extends Record>
|
interface |
SelectForUpdateWaitStep<R extends Record>
|
interface |
SelectFromStep<R extends Record>
|
interface |
SelectGroupByStep<R extends Record>
|
interface |
SelectHavingConditionStep<R extends Record>
|
interface |
SelectHavingStep<R extends Record>
|
interface |
SelectJoinPartitionByStep<R extends Record>
|
interface |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOnStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
interface |
SelectOptionStep<R extends Record>
|
interface |
SelectOrderByStep<R extends Record>
|
interface |
SelectQuery<R extends Record>
A query for data selection
|
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 |
SelectWhereStep<R extends Record>
|
interface |
SelectWindowStep<R extends Record>
|
interface |
StoreQuery<R extends Record>
A query storing objects to the database.
|
interface |
Table<R extends Record>
A table to be used in queries
|
interface |
TableField<R extends Record,T>
A field contained in a table
|
interface |
TableLike<R extends Record>
An object that can behave like a table (a table-like object)
|
interface |
Truncate<R extends Record>
A
Query that can truncate a table in the database. |
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 |
UniqueKey<R extends Record>
A
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY . |
interface |
Update<R extends Record>
A
Query that can update data in the database. |
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 |
UpdateQuery<R extends Record>
A query for data updating
|
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 |
UpdateSetFirstStep<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 |
UpdateSetStep<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. |
interface |
VersionsBetweenAndStep<R extends Record,T>
This type is used for the Oracle
VERSIONS clause DSL API,
providing access to the flashback versions query clauses. |
Modifier and Type | Interface and Description |
---|---|
interface |
Record1<T1>
A model type for a records with degree
1 |
interface |
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
A model type for a records with degree
10 |
interface |
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
A model type for a records with degree
11 |
interface |
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
A model type for a records with degree
12 |
interface |
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
A model type for a records with degree
13 |
interface |
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
A model type for a records with degree
14 |
interface |
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
A model type for a records with degree
15 |
interface |
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
A model type for a records with degree
16 |
interface |
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
A model type for a records with degree
17 |
interface |
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
A model type for a records with degree
18 |
interface |
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
A model type for a records with degree
19 |
interface |
Record2<T1,T2>
A model type for a records with degree
2 |
interface |
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
A model type for a records with degree
20 |
interface |
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
A model type for a records with degree
21 |
interface |
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
A model type for a records with degree
22 |
interface |
Record3<T1,T2,T3>
A model type for a records with degree
3 |
interface |
Record4<T1,T2,T3,T4>
A model type for a records with degree
4 |
interface |
Record5<T1,T2,T3,T4,T5>
A model type for a records with degree
5 |
interface |
Record6<T1,T2,T3,T4,T5,T6>
A model type for a records with degree
6 |
interface |
Record7<T1,T2,T3,T4,T5,T6,T7>
A model type for a records with degree
7 |
interface |
Record8<T1,T2,T3,T4,T5,T6,T7,T8>
A model type for a records with degree
8 |
interface |
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
A model type for a records with degree
9 |
interface |
TableRecord<R extends TableRecord<R>>
A record originating from a single table
|
interface |
UDTRecord<R extends UDTRecord<R>>
An object holding data of a UDT
|
interface |
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again.
|
Modifier and Type | Method and Description |
---|---|
<R extends Record> |
DSLContext.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DSLContext.deleteQuery(Table<R> table)
Create a new
DeleteQuery |
<R extends Record> |
DSLContext.fetch(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
results. |
<R extends Record> |
DSLContext.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
DSLContext.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1 . |
<R extends Record> |
DSLContext.fetchAny(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] LIMIT 1 . |
<Z extends Record> |
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
DSLContext.fetchLazy(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
<R extends Record> |
DSLContext.fetchLazy(Table<R> table)
Execute and return all records lazily for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchLazy(Table<R> table,
Condition condition)
Execute and return all records lazily for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
DSLContext.fetchMany(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
<R extends Record> |
DSLContext.fetchOne(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
<R extends Record> |
DSLContext.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
<Z extends Record> |
ResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchOneInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
<O extends Record> |
Table.getReferencesFrom(Table<O> other)
Get a list of
FOREIGN KEY 's of a specific table, referencing
a this table. |
<O extends Record> |
Table.getReferencesTo(Table<O> other)
Get a list of
FOREIGN KEY 's of this table, referencing a
specific table. |
<R extends Record> |
DSLContext.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
DSLContext.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
DSLContext.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record,T1> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1)
Create a new DSL insert statement.
|
<R extends Record,T1,T2> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new DSL insert statement.
|
<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> |
DSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new DSL insert statement.
|
<R extends Record> |
DSLContext.insertQuery(Table<R> into)
Create a new
InsertQuery |
<R extends Record> |
Record.into(Table<R> table)
Map resulting records onto a custom record type.
|
<Z extends Record> |
Result.into(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
SchemaMapping.map(Table<R> table)
Deprecated.
Apply mapping to a given table
|
<R extends Record> |
DSLContext.map(Table<R> table)
Map a table to another one.
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new DSL merge statement (H2-specific syntax).
|
<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> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
DSLContext.newRecord(Table<R> table)
Create a new
Record that can be inserted into the corresponding
table. |
<R extends Record> |
DSLContext.newRecord(Table<R> table,
Object source)
Create a new pre-filled
Record that can be inserted into the
corresponding table. |
<R extends Record> |
DSLContext.newResult(Table<R> table)
Create a new empty
Result . |
<R extends Record,E> |
RecordMapperProvider.provide(RecordType<R> recordType,
Class<? extends E> type)
Provide a
RecordMapper instance. |
<R extends Record> |
DSLContext.selectFrom(Table<R> table)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
<R extends Record> |
DSLContext.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
DSLContext.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
DSLContext.updateQuery(Table<R> table)
Create a new
UpdateQuery |
Modifier and Type | Method and Description |
---|---|
Record[] |
RecordContext.batchRecords()
The
Record (s) that are being manipulated in batch mode. |
Record |
DSLContext.fetchOne(ResultSet rs)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Class<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
DataType<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Field<?>... fields)
|
Record |
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Record |
UpdatableRecord.key()
A view holding values for the
Table.getPrimaryKey()
This method returns a "view" of this record itself. |
Record |
DSLContext.newRecord(Field<?>... fields)
Create a new empty
Record . |
Record |
Record.original()
Get this record containing the original values as fetched from the
database.
|
Record |
RecordContext.record()
The
Record that is being manipulated. |
Record |
ExecuteContext.record()
The last record that was fetched from the result set, or
null if no record has been fetched. |
Modifier and Type | Method and Description |
---|---|
Table<Record> |
Table.crossApply(String sql)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(String sql,
Object... bindings)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(String sql)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
Result<Record> |
DSLContext.fetch(ResultSet rs)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
Class<?>... types)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
DataType<?>... types)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
Field<?>... fields)
|
Result<Record> |
DSLContext.fetch(String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetchFromCSV(String string)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(String string,
char delimiter)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromJSON(String string)
Fetch all data from a JSON string.
|
Result<Record> |
DSLContext.fetchFromStringData(List<String[]> data)
Fetch all data from a list of strings.
|
Result<Record> |
DSLContext.fetchFromStringData(String[]... data)
Fetch all data from a list of strings.
|
Result<Record> |
DSLContext.fetchFromTXT(String string)
Fetch all data from a formatted string.
|
Result<Record> |
DSLContext.fetchFromTXT(String string,
String nullLiteral)
Fetch all data from a formatted string.
|
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Field<?>[] keys,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given keys and mapped into the given entity type. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Field<?>[] keys,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given keys and mapped by the given mapper. |
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Class<?>... types)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
DataType<?>... types)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Field<?>... fields)
|
Cursor<Record> |
DSLContext.fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
List<Result<Record>> |
ResultQuery.fetchMany()
Execute a query, possibly returning several result sets.
|
<R extends Record> |
DSLContext.fetchMany(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
List<Result<Record>> |
DSLContext.fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
List<Result<Record>> |
DSLContext.fetchMany(String sql,
Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
List<Result<Record>> |
DSLContext.fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Map<Record,R> |
ResultQuery.fetchMap(Field<?>[] keys)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Table<Record> |
PivotInStep.in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(Field<?>... fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(T... values)
Specify the acceptable values for pivoting
|
Map<Record,Result<R>> |
Result.intoGroups(Field<?>[] keys)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(Field<?>[] keys,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<Record,List<E>> |
Result.intoGroups(Field<?>[] keys,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,R> |
Result.intoMap(Field<?>[] keys)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Table<Record> |
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.outerApply(String sql)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(String sql,
Object... bindings)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
ResultQuery<Record> |
DSLContext.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
Table<Record> |
DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
DivideByReturningStep.returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend
|
SelectSelectStep<Record> |
SelectSelectStep.select(Collection<? extends Field<?>> fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(Collection<? extends Field<?>> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
SelectSelectStep.select(Field<?>... fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(Field<?>... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(Field<?>... fields)
Create a new DSL select statement.
|
SelectQuery<Record> |
DSLContext.selectQuery()
Create a new
SelectQuery |
Table<Record> |
TableOnStep.using(Collection<? extends Field<?>> fields)
Join a table with the
USING(column [, column...]) |
Table<Record> |
TableOnStep.using(Field<?>... fields)
Join a table with the
USING(column [, column...]) |
Modifier and Type | Method and Description |
---|---|
Condition |
BetweenAndStepN.and(Record maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStepN |
RowN.between(Record minValue)
Check if this row value expression is within a range of two records.
|
Condition |
RowN.between(Record minValue,
Record maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStepN |
RowN.betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
RowN.betweenSymmetric(Record minValue,
Record maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
RowN.compare(Comparator comparator,
Record record)
Compare this row value expression with a record record
using a dynamic comparator.
|
int |
Record.compareTo(Record record)
Compares this
Record with another Record
according to their natural ordering. |
Condition |
RowN.eq(Record record)
Compare this row value expression with a record for equality.
|
Condition |
RowN.equal(Record record)
Compare this row value expression with a record for equality.
|
Result<R> |
ForeignKey.fetchChildren(O... records)
Fetch child records of a given set of records through this foreign key
This returns childs record referencing any record in a given set of
records through this foreign key
|
Result<O> |
ForeignKey.fetchParents(R... records)
Fetch parent records of a given set of record through this foreign key
This returns parent records referenced by any record in a given set of
records through this foreign key.
|
Condition |
RowN.ge(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.greaterOrEqual(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.greaterThan(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.gt(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.in(Record... record)
Compare this row value expression with a set of records for equality.
|
Condition |
RowN.le(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.lessOrEqual(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.lessThan(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.lt(Record record)
Compare this row value expression with a record for order.
|
Condition |
RowN.ne(Record record)
Compare this row value expression with a record for non-equality.
|
BetweenAndStepN |
RowN.notBetween(Record minValue)
Check if this row value expression is within a range of two records.
|
Condition |
RowN.notBetween(Record minValue,
Record maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStepN |
RowN.notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
RowN.notBetweenSymmetric(Record minValue,
Record maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
RowN.notEqual(Record record)
Compare this row value expression with a record for non-equality
|
Condition |
RowN.notIn(Record... record)
Compare this row value expression with a set of records for non-equality.
|
void |
ExecuteContext.record(Record record)
Calling this has no effect.
|
UpdateSetMoreStep<R> |
UpdateSetStep.set(Record record)
Set a value for a field in the
UPDATE statement. |
MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Record record)
Set multiple values for
INSERT in the MERGE
statement's WHEN NOT MATCHED clause. |
MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Record record)
Set multiple values for
UPDATE in the MERGE
statement's WHEN MATCHED clause. |
InsertSetMoreStep<R> |
InsertSetStep.set(Record record)
Set values in the
INSERT statement. |
InsertOnDuplicateSetMoreStep<R> |
InsertOnDuplicateSetStep.set(Record record)
Set multiple values for
UPDATE in the INSERT
statement's ON DUPLICATE KEY UPDATE clause. |
Modifier and Type | Method and Description |
---|---|
Condition |
RowN.eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
<E> E |
Record.map(RecordMapper<Record,E> mapper)
Map this record into a custom mapper callback.
|
Condition |
RowN.ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Modifier and Type | Class and Description |
---|---|
class |
DefaultRecordMapper<R extends Record,E>
This is the default implementation for
RecordMapper types. |
class |
TableImpl<R extends Record>
A common base type for tables
This type is for JOOQ INTERNAL USE only.
|
Modifier and Type | Class and Description |
---|---|
class |
CustomRecord<R extends TableRecord<R>>
A base class for custom
TableRecord implementations in client code. |
class |
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single table
This type is for JOOQ INTERNAL USE only.
|
class |
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDT
This type is for JOOQ INTERNAL USE only.
|
class |
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary key
This type is for JOOQ INTERNAL USE only.
|
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
SQLDataType.RESULT
The
ResultSet type. |
Modifier and Type | Method and Description |
---|---|
static <R extends Record> |
DSL.all(Select<R> select)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <R extends Record> |
DSL.any(Select<R> select)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys
|
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys
|
protected static <R extends Record,T> |
AbstractKeys.createIdentity(Table<R> table,
TableField<R,T> field)
Factory method for identities
|
protected static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Factory method for unique keys
|
static <R extends Record> |
DSL.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DefaultDSLContext.delete(Table<R> table) |
<R extends Record> |
DefaultDSLContext.deleteQuery(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetch(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetch(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetch(Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchAny(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchAny(Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchLazy(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchLazy(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchLazy(Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchMany(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchOne(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchOne(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchOne(Table<R> table,
Condition condition) |
static <R extends Record> |
DSL.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
DefaultDSLContext.insertInto(Table<R> into) |
static <R extends Record> |
DSL.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
DefaultDSLContext.insertInto(Table<R> into,
Collection<? extends Field<?>> fields) |
static <R extends Record> |
DSL.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record> |
DefaultDSLContext.insertInto(Table<R> into,
Field<?>... fields) |
static <R extends Record,T1> |
DSL.insertInto(Table<R> into,
Field<T1> field1)
Create a new DSL insert statement.
|
<R extends Record,T1> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1) |
static <R extends Record,T1,T2> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2)
Create a new DSL insert statement.
|
<R extends Record,T1,T2> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2) |
static <R extends Record,T1,T2,T3> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3) |
static <R extends Record,T1,T2,T3,T4> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4) |
static <R extends Record,T1,T2,T3,T4,T5> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5) |
static <R extends Record,T1,T2,T3,T4,T5,T6> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21) |
static <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> |
DSL.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new DSL insert statement.
|
<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> |
DefaultDSLContext.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22) |
<R extends Record> |
DefaultDSLContext.insertQuery(Table<R> into) |
static <R extends Record> |
DSL.lateral(TableLike<R> table)
Create a
LATERAL joined table. |
<R extends Record> |
DefaultDSLContext.map(Table<R> table) |
static <R extends Record> |
DSL.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
DefaultDSLContext.mergeInto(Table<R> table) |
static <R extends Record> |
DSL.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
DefaultDSLContext.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields) |
static <R extends Record> |
DSL.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<?>... fields) |
static <R extends Record,T1> |
DSL.mergeInto(Table<R> table,
Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1) |
static <R extends Record,T1,T2> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2) |
static <R extends Record,T1,T2,T3> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3) |
static <R extends Record,T1,T2,T3,T4> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4) |
static <R extends Record,T1,T2,T3,T4,T5> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5) |
static <R extends Record,T1,T2,T3,T4,T5,T6> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20) |
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21) |
static <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> |
DSL.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new DSL merge statement (H2-specific syntax).
|
<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> |
DefaultDSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22) |
<R extends Record> |
DefaultDSLContext.newRecord(Table<R> table) |
<R extends Record> |
DefaultDSLContext.newRecord(Table<R> table,
Object source) |
<R extends Record> |
DefaultDSLContext.newResult(Table<R> table) |
<R extends Record,E> |
DefaultRecordMapperProvider.provide(RecordType<R> rowType,
Class<? extends E> type) |
static <R extends Record> |
DSL.selectFrom(Table<R> table)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(Table<R> table) |
<R extends Record> |
DefaultDSLContext.selectQuery(TableLike<R> table) |
static <R extends Record> |
DSL.table(Result<R> result)
Use a previously obtained result as a new
Table that can be used
in SQL statements through DSL.values(RowN...) . |
static <R extends Record> |
DSL.table(Select<R> select)
A synonym for
TableLike.asTable() , which might look a bit more fluent
like this, to some users. |
static <R extends Record> |
DSL.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
DefaultDSLContext.truncate(Table<R> table) |
static <R extends Record> |
DSL.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
DefaultDSLContext.update(Table<R> table) |
<R extends Record> |
DefaultDSLContext.updateQuery(Table<R> table) |
Modifier and Type | Method and Description |
---|---|
Record |
DefaultDSLContext.fetchOne(ResultSet rs) |
Record |
DefaultDSLContext.fetchOne(ResultSet rs,
Class<?>... types) |
Record |
DefaultDSLContext.fetchOne(ResultSet rs,
DataType<?>... types) |
Record |
DefaultDSLContext.fetchOne(ResultSet rs,
Field<?>... fields) |
Record |
DefaultDSLContext.fetchOne(String sql) |
Record |
DefaultDSLContext.fetchOne(String sql,
Object... bindings) |
Record |
DefaultDSLContext.fetchOne(String sql,
QueryPart... parts) |
Record |
UpdatableRecordImpl.key() |
Record |
DefaultDSLContext.newRecord(Field<?>... fields) |
Modifier and Type | Method and Description |
---|---|
static Table<Record> |
DSL.dual()
The
DUAL table to be used for syntactic completeness. |
Result<Record> |
DefaultDSLContext.fetch(ResultSet rs) |
Result<Record> |
DefaultDSLContext.fetch(ResultSet rs,
Class<?>... types) |
Result<Record> |
DefaultDSLContext.fetch(ResultSet rs,
DataType<?>... types) |
Result<Record> |
DefaultDSLContext.fetch(ResultSet rs,
Field<?>... fields) |
Result<Record> |
DefaultDSLContext.fetch(String sql) |
Result<Record> |
DefaultDSLContext.fetch(String sql,
Object... bindings) |
Result<Record> |
DefaultDSLContext.fetch(String sql,
QueryPart... parts) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string,
char delimiter) |
Result<Record> |
DefaultDSLContext.fetchFromJSON(String string) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(List<String[]> data) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(String[]... data) |
Result<Record> |
DefaultDSLContext.fetchFromTXT(String string) |
Result<Record> |
DefaultDSLContext.fetchFromTXT(String string,
String nullLiteral) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(ResultSet rs) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(ResultSet rs,
Class<?>... types) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(ResultSet rs,
DataType<?>... types) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(ResultSet rs,
Field<?>... fields) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql,
Object... bindings) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql,
QueryPart... parts) |
<R extends Record> |
DefaultDSLContext.fetchMany(ResultQuery<R> query) |
List<Result<Record>> |
DefaultDSLContext.fetchMany(String sql) |
List<Result<Record>> |
DefaultDSLContext.fetchMany(String sql,
Object... bindings) |
List<Result<Record>> |
DefaultDSLContext.fetchMany(String sql,
QueryPart... parts) |
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql) |
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql,
Object... bindings) |
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql,
QueryPart... parts) |
static SelectSelectStep<Record> |
DSL.select(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(Collection<? extends Field<?>> fields) |
static SelectSelectStep<Record> |
DSL.select(Field<?>... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(Field<?>... fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(Collection<? extends Field<?>> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(Collection<? extends Field<?>> fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(Field<?>... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(Field<?>... fields) |
SelectQuery<Record> |
DefaultDSLContext.selectQuery() |
static Table<Record> |
DSL.table(String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
DSL.tableByName(String... qualifiedName)
Create a qualified table, given its table name.
|
static Table<Record> |
DSL.values(RowN... rows)
Create a
VALUES() expression of arbitrary degree. |
Modifier and Type | Field and Description |
---|---|
protected static DataType<Result<Record>> |
H2DataType.__RESULT |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
HSQLDBDataType.ROW |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
OracleDataType.REF_CURSOR |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
PostgresDataType.REFCURSOR |
Modifier and Type | Method and Description |
---|---|
static Table<Record> |
PostgresDSL.only(Table<?> table)
Get the PostgreSQL-specific
ONLY [table] clause for use with
table inheritance. |
Copyright © 2014. All Rights Reserved.