| 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.tools.jdbc |
The
org.jooq.tools.jdbc package contains compatibility classes
to bridge between JDBC 4.0 and JDBC 4.1. |
| org.jooq.util.aurorapostgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.AURORA_POSTGRES dialect. |
| 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. |
| org.jooq.util.redshift |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.REDSHIFT dialect. |
| org.jooq.util.vertica |
| Modifier and Type | Interface and Description |
|---|---|
interface |
CommonTableExpression<R extends Record>
A common table expression is a table that can be supplied to
WITH clauses. |
interface |
CreateTableAsStep<R extends Record>
A
Query that can create tables. |
interface |
CreateViewAsStep<R extends Record>
A
Query that can create views. |
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 |
DeleteResultStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
DeleteReturningStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
DeleteWhereStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
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 |
InsertOnConflictConditionStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertOnConflictDoUpdateStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertOnConflictWhereStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
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 |
Loader<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderCSVOptionsStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderCSVStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderJSONOptionsStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderJSONStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderListenerStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderLoadStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderOptionsStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderRowsStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderSourceStep<R extends Record>
The
Loader API is used for configuring data loads. |
interface |
LoaderXMLStep<R extends Record>
The
Loader API is used for configuring data loads. |
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 |
RecordUnmapper<E,R extends Record>
A
RecordUnmapper is a mapper that can receive user objects and
convert them back to 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 |
SelectConnectByAfterStartWithConditionStep<R extends Record>
|
interface |
SelectConnectByAfterStartWithStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
interface |
SelectDistinctOnStep<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 |
SelectIntoStep<R extends Record>
|
interface |
SelectJoinPartitionByStep<R extends Record>
|
interface |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitAfterOffsetStep<R extends Record>
|
interface |
SelectLimitPercentAfterOffsetStep<R extends Record>
|
interface |
SelectLimitPercentStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
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 |
SelectUnionStep<R extends Record>
|
interface |
SelectWhereStep<R extends Record>
|
interface |
SelectWindowStep<R extends Record>
|
interface |
SelectWithTiesAfterOffsetStep<R extends Record>
|
interface |
SelectWithTiesStep<R extends Record>
|
interface |
StoreQuery<R extends Record>
A query storing objects to the database.
|
interface |
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 |
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of a
JOIN
clause, where the join criteria is added using an ON clause
(with a Condition. |
interface |
TableOnStep<R extends Record>
|
interface |
TableOptionalOnStep<R extends Record>
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an ON
clause (with a Condition), or using a USING clause (with
a list of Field)
Referencing XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
interface |
TableOuterJoinStep<R extends Record>
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
interface |
TablePartitionByStep<R extends Record>
An intermediate type for the construction of a partitioned
SQLDialect.ORACLE OUTER JOIN clause. |
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> |
Name.as(Select<R> select)
Specify a subselect to refer to by the
Name to form a common
table expression. |
<R extends Record> |
DerivedColumnList.as(Select<R> select)
Specify a subselect to refer to by the
DerivedColumnList to
form a common table expression. |
<R extends Record> |
WithStep.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DSLContext.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DSLContext.deleteFrom(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.fetchAnyInto(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
DSLContext.fetchAsync(Executor executor,
ResultQuery<R> query)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
<R extends Record> |
DSLContext.fetchAsync(Executor executor,
Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table]. |
<R extends Record> |
DSLContext.fetchAsync(Executor executor,
Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
DSLContext.fetchAsync(ResultQuery<R> query)
Fetch results in a new
CompletionStage. |
<R extends Record> |
DSLContext.fetchAsync(Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table]. |
<R extends Record> |
DSLContext.fetchAsync(Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<S extends Record> |
ResultQuery.fetchGroups(Table<S> table)
Execute the query and return a
Map with the result grouped by the
given table. |
<E,S extends Record> |
ResultQuery.fetchGroups(Table<S> table,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given table and mapped into the given entity type. |
<E,S extends Record> |
ResultQuery.fetchGroups(Table<S> table,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given table and mapped by the given mapper. |
<S extends Record,T extends Record> |
ResultQuery.fetchGroups(Table<S> keyTable,
Table<T> valueTable)
Execute the query and return a
Map with the result grouped by the
given table. |
<S extends Record,T extends Record> |
ResultQuery.fetchGroups(Table<S> keyTable,
Table<T> valueTable)
Execute the query and return a
Map with the result grouped by the
given table. |
<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. |
<S extends Record> |
ResultQuery.fetchMap(Table<S> table)
Execute the query and return a
Map with table as a map key and
the corresponding record as value. |
<E,S extends Record> |
ResultQuery.fetchMap(Table<S> table,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given table and mapped into the given entity type. |
<E,S extends Record> |
ResultQuery.fetchMap(Table<S> table,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given table and mapped by the given mapper. |
<S extends Record,T extends Record> |
ResultQuery.fetchMap(Table<S> keyTable,
Table<T> valueTable)
Execute the query and return a
Map with table as a map key and
the corresponding record as value. |
<S extends Record,T extends Record> |
ResultQuery.fetchMap(Table<S> keyTable,
Table<T> valueTable)
Execute the query and return a
Map with table as a map key and
the corresponding record as value. |
<Z extends Record> |
Cursor.fetchNextInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
<Z extends Record> |
Cursor.fetchNextOptionalInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
<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)
Deprecated.
- 3.10 - [#6363] - Use
Cursor.fetchNextInto(Table) instead. |
<R extends Record> |
DSLContext.fetchOptional(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
<R extends Record> |
DSLContext.fetchOptional(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]. |
<R extends Record> |
DSLContext.fetchOptional(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
<Z extends Record> |
ResultQuery.fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchOptionalInto(Table<Z> table)
Deprecated.
- 3.10 - [#6363] - Use
Cursor.fetchNextOptionalInto(Table) instead. |
<R extends Record> |
DSLContext.fetchSingle(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
<R extends Record> |
DSLContext.fetchSingle(Table<R> table)
Execute and return exactly one record for
SELECT * FROM [table]. |
<R extends Record> |
DSLContext.fetchSingle(Table<R> table,
Condition condition)
Execute and return exactly one record for
SELECT * FROM [table] WHERE [condition] . |
<Z extends Record> |
ResultQuery.fetchSingleInto(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
DSLContext.fetchStream(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a stream. |
<R extends Record> |
DSLContext.fetchStream(Table<R> table)
Execute and return all records lazily for
SELECT * FROM [table]. |
<R extends Record> |
DSLContext.fetchStream(Table<R> table,
Condition condition)
Execute and return all records lazily for
SELECT * FROM [table] WHERE [condition] . |
<Z extends Record> |
ResultQuery.fetchStreamInto(Table<Z> table)
Stream this query, mapping records into 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> |
WithStep.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
DSLContext.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
WithStep.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
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> |
WithStep.insertInto(Table<R> into,
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> |
WithStep.insertInto(Table<R> into,
Field<T1> field1)
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> |
WithStep.insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2)
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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> |
WithStep.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> |
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.
|
<S extends Record> |
Result.intoGroups(Table<S> table)
Return a
Map with the result grouped by the given key table. |
<E,S extends Record> |
Result.intoGroups(Table<S> table,
Class<? extends E> type)
Return a
Map with results grouped by the given key table and
mapped into the given entity type. |
<E,S extends Record> |
Result.intoGroups(Table<S> table,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key table and
mapped into the given entity type. |
<S extends Record,T extends Record> |
Result.intoGroups(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the result grouped by the given key table. |
<S extends Record,T extends Record> |
Result.intoGroups(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the result grouped by the given key table. |
<S extends Record> |
Result.intoMap(Table<S> table)
Return a
Map with the given key table as a map key and the
corresponding record as value. |
<E,S extends Record> |
Result.intoMap(Table<S> table,
Class<? extends E> type)
Return a
Map with results grouped by the given key table and
mapped into the given entity type. |
<E,S extends Record> |
Result.intoMap(Table<S> table,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key table and
mapped by the given mapper. |
<S extends Record,T extends Record> |
Result.intoMap(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the given key table as a map key and the
corresponding record as value. |
<S extends Record,T extends Record> |
Result.intoMap(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the given key table as a map key and the
corresponding record as value. |
<R extends Record> |
DSLContext.loadInto(Table<R> table)
Create a new
Loader object to load data from a CSV or XML
source. |
<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> |
WithStep.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
WithStep.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,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
WithStep.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
DSLContext.mergeInto(Table<R> table,
Field<?>... fields)
|
<R extends Record,T1> |
WithStep.mergeInto(Table<R> table,
Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record,T1> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1)
|
<R extends Record,T1,T2> |
WithStep.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2)
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)
|
<R extends Record,T1,T2,T3> |
WithStep.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> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
|
<R extends Record,T1,T2,T3,T4> |
WithStep.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> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
|
<R extends Record,T1,T2,T3,T4,T5> |
WithStep.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> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
WithStep.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> |
DSLContext.mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
WithStep.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> |
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)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
WithStep.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> |
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)
|
<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> |
WithStep.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> |
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)
|
<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. |
<E,R extends Record> |
RecordUnmapperProvider.provide(Class<? extends E> type,
RecordType<R> recordType)
Provide a
RecordUnmapper instance. |
<R extends Record,E> |
RecordMapperProvider.provide(RecordType<R> recordType,
Class<? extends E> type)
Provide a
RecordMapper instance. |
<R extends Record> |
WithStep.selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
WithStep.selectFrom(SQL sql)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(SQL sql)
Create a new DSL select statement.
|
<R extends Record> |
WithStep.selectFrom(String sql)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(String sql)
Create a new DSL select statement.
|
<R extends Record> |
WithStep.selectFrom(String sql,
Object... bindings)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(String sql,
Object... bindings)
Create a new DSL select statement.
|
<R extends Record> |
WithStep.selectFrom(String sql,
QueryPart... parts)
Create a new DSL select statement.
|
<R extends Record> |
DSLContext.selectFrom(String sql,
QueryPart... parts)
Create a new DSL select statement.
|
<R extends Record> |
WithStep.selectFrom(Table<R> table)
Create a new DSL select statement.
|
<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> |
WithStep.update(Table<R> table)
Create a new DSL update 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. |
R[] |
ResultQuery.fetchArray()
Execute the query and return the generated result as an array of records.
|
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(SQL sql)
Execute a new query holding plain SQL.
|
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 |
DSLContext.fetchSingle(ResultSet rs)
|
Record |
DSLContext.fetchSingle(ResultSet rs,
Class<?>... types)
|
Record |
DSLContext.fetchSingle(ResultSet rs,
DataType<?>... types)
|
Record |
DSLContext.fetchSingle(ResultSet rs,
Field<?>... fields)
|
Record |
DSLContext.fetchSingle(SQL sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(String sql)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Record |
Record.into(Field<?>... fields)
Copy this record into a new record holding only a subset of the previous
fields.
|
Record |
UpdatableRecord.key()
A Record copy holding values for the
Table.getPrimaryKey(). |
Record |
DSLContext.newRecord(Collection<? extends Field<?>> fields)
Create a new empty
Record. |
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. |
<T> Record |
Record.with(Field<T> field,
T value)
Set a value into this record.
|
<T,U> Record |
Record.with(Field<T> field,
U value,
Converter<? extends T,? super U> converter)
Set a value into this record.
|
| Modifier and Type | Method and Description |
|---|---|
CreateTableAsStep<Record> |
DSLContext.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createGlobalTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createGlobalTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(String view,
String... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createOrReplaceView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateTableAsStep<Record> |
DSLContext.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTable(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTable(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTableIfNotExists(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTableIfNotExists(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTemporaryTable(Name table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTemporaryTable(String table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTemporaryTable(Table<?> table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(String view,
String... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(String view,
String... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
Table<Record> |
Table.crossApply(Name name)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossApply(SQL sql)
CROSS APPLY a table to this table. |
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(Name name)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(SQL sql)
CROSS JOIN 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(SQL sql)
Execute a new query holding plain SQL.
|
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.
|
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
ResultSet rs)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
ResultSet rs,
Class<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
SQL sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql,
Object... bindings)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(ResultSet rs)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(ResultSet rs,
Class<?>... types)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(SQL sql)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
Object... bindings)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage. |
Result<Record> |
DSLContext.fetchFromCSV(String string)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(String string,
boolean header)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(String string,
boolean header,
char delimiter)
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.fetchFromHTML(String string)
Convert an HTML table into a jOOQ
Result. |
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(List<String[]> data,
boolean header)
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. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Field<?>[] keys,
Field<?>[] values)
Execute the query and return a
Map with the result grouped by the
given keys. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Field<?>[] keys,
Field<?>[] values)
Execute the query and return a
Map with the result grouped by the
given keys. |
<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. |
Map<Record,Result<R>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes,
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. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Execute the query and return a
Map with the result grouped by the
given keys. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes,
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. |
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
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. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
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. |
Map<Record,Result<R>> |
ResultQuery.fetchGroups(String[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(String[] keyFieldNames,
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(String[] keyFieldNames,
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. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(String[] keyFieldNames,
String[] valueFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
Map<Record,Result<Record>> |
ResultQuery.fetchGroups(String[] keyFieldNames,
String[] valueFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
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(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
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.
|
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. |
Map<Record,Record> |
ResultQuery.fetchMap(Field<?>[] keys,
Field<?>[] values)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(Field<?>[] keys,
Field<?>[] values)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,R> |
ResultQuery.fetchMap(int[] keyFieldIndexes)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,R> |
ResultQuery.fetchMap(Name[] keyFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Name[] valueFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Name[] valueFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,R> |
ResultQuery.fetchMap(String[] keyFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(String[] keyFieldNames,
String[] valueFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
ResultQuery.fetchMap(String[] keyFieldNames,
String[] valueFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Class<?>... types)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
DataType<?>... types)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Field<?>... fields)
|
Optional<Record> |
DSLContext.fetchOptional(SQL sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Stream<Record> |
DSLContext.fetchStream(ResultSet rs)
|
Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
Class<?>... types)
|
Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
DataType<?>... types)
|
Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
Field<?>... fields)
|
Stream<Record> |
DSLContext.fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
DSLContext.fetchStream(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
DSLContext.fetchStream(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
DSLContext.fetchStream(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
TableOnStep<Record> |
Table.fullJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
Table.fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
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
|
TableOnStep<Record> |
Table.innerJoin(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.innerJoin(TableLike<?> table)
INNER JOIN a table to this table. |
Result<Record> |
Result.into(Field<?>... fields)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
SelectIntoStep<Record> |
SelectIntoStep.into(Table<?> table)
Add an
INTO clause to the SELECT statement. |
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. |
Map<Record,Result<Record>> |
Result.intoGroups(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the result grouped by the given keys. |
Map<Record,Result<Record>> |
Result.intoGroups(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the result grouped by the given keys. |
<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,Result<R>> |
Result.intoGroups(int[] keyFieldIndexes)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(int[] keyFieldIndexes,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,Result<Record>> |
Result.intoGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the result grouped by the given keys. |
Map<Record,Result<Record>> |
Result.intoGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(int[] keyFieldIndexes,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,Result<R>> |
Result.intoGroups(Name[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,Result<R>> |
Result.intoGroups(String[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(String[] keyFieldNames,
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(String[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,Result<Record>> |
Result.intoGroups(String[] keyFieldNames,
String[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
Map<Record,Result<Record>> |
Result.intoGroups(String[] keyFieldNames,
String[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
Map<Record,R> |
Result.intoMap(Field<?>[] keys)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,R> |
Result.intoMap(int[] keyFieldIndexes)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,R> |
Result.intoMap(Name[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,R> |
Result.intoMap(String[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(String[] keyFieldNames,
String[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Map<Record,Record> |
Result.intoMap(String[] keyFieldNames,
String[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
TableOnStep<Record> |
Table.join(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
Table.join(TableLike<?> table)
INNER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.join(TableLike<?> table,
JoinType type)
Join a table to this table using a
JoinType. |
TableOptionalOnStep<Record> |
Table.join(TableLike<?> table,
JoinType type)
Join a table to this table using a
JoinType
Depending on the JoinType, a subsequent
TableOnStep.on(Condition) or
TableOnStep.using(Field...) clause is required. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(Name name)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(SQL sql)
NATURAL JOIN a table to this table. |
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(Name name)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER 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(Name name)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(SQL sql)
NATURAL RIGHT 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. |
Result<Record> |
DSLContext.newResult(Collection<? extends Field<?>> fields)
Create a new empty
Record. |
Result<Record> |
DSLContext.newResult(Field<?>... fields)
Create a new empty
Record. |
Table<Record> |
Table.outerApply(Name name)
OUTER APPLY a table to this table. |
Table<Record> |
Table.outerApply(SQL sql)
OUTER APPLY 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. |
TableOuterJoinStep<Record> |
Table.partitionBy(Collection<? extends Field<?>> fields)
Add a
PARTITION BY clause to the left hand side of the
OUTER JOIN keywords |
TableOuterJoinStep<Record> |
Table.partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the left hand side of the
OUTER JOIN keywords |
Result<Record> |
ResultOrRows.result()
The result or
null if there was no result. |
ResultQuery<Record> |
DSLContext.resultQuery(SQL sql)
Create a new query holding plain SQL.
|
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
|
UpdateResultStep<Record> |
UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
UPDATE statement to return a list of fields in
R. |
InsertResultStep<Record> |
InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT statement to return a list of fields in
R. |
DeleteResultStep<Record> |
DeleteReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
DELETE statement to return a list of fields in
R. |
UpdateResultStep<Record> |
UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
UPDATE statement to return a list of fields in
R. |
InsertResultStep<Record> |
InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
INSERT statement to return a list of fields in
R. |
DeleteResultStep<Record> |
DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
DELETE statement to return a list of fields in
R. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TableOnStep<Record> |
TableOuterJoinStep.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
Table.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
SelectSelectStep<Record> |
WithStep.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
SelectSelectStep.select(Collection<? extends SelectFieldOrAsterisk> fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
WithStep.select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
SelectSelectStep.select(SelectFieldOrAsterisk... fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
WithStep.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
WithStep.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectQuery<Record> |
DSLContext.selectQuery()
Create a new
SelectQuery |
TableOnStep<Record> |
Table.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(SQL sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
TableOnStep<Record> |
Table.straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
TruncateIdentityStep<Record> |
DSLContext.truncate(Name table)
Create a new DSL truncate statement.
|
TruncateIdentityStep<Record> |
DSLContext.truncate(String table)
Create a new DSL truncate statement.
|
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.
|
boolean |
Field.changed(Record record)
The inverse operation of
changed(Field). |
Condition |
RowN.compare(Comparator comparator,
Record record)
Compare this row value expression with a 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.
|
Field<T> |
Field.field(Record record)
The inverse operation of
field(Field). |
R |
Table.from(Record record)
The inverse operation of
into(Table). |
Record1<T> |
Field.from(Record record)
The inverse operation of
into(Field). |
Condition |
RowN.ge(Record record)
Compare this row value expression with a record for order.
|
T |
Field.get(Record record)
The inverse operation of
get(Field). |
T |
Field.getValue(Record record)
The inverse operation of
getValue(Field). |
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.isDistinctFrom(Record record)
Compare this row value expression with another row value expression for
distinctness.
|
Condition |
RowN.isNotDistinctFrom(Record record)
Compare this row value expression with another row value expression for
distinctness.
|
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.
|
LoaderRowsStep<R> |
LoaderSourceStep.loadRecords(Record... records)
Load in-memory data.
|
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.
|
T |
Field.original(Record record)
The inverse operation of
original(Field). |
void |
ExecuteContext.record(Record record)
Calling this has no effect.
|
void |
Field.reset(Record record)
The inverse operation of
reset(Field). |
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. |
InsertSetMoreStep<R> |
InsertSetMoreStep.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.compare(Comparator comparator,
QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
RowN.compare(Comparator comparator,
Select<? extends Record> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
RowN.eq(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.equal(QuantifiedSelect<? 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(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.greaterOrEqual(QuantifiedSelect<? 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(QuantifiedSelect<? 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(QuantifiedSelect<? 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(Result<? extends Record> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
RowN.in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.le(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lessOrEqual(QuantifiedSelect<? 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(QuantifiedSelect<? 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.
|
LoaderRowsStep<R> |
LoaderSourceStep.loadRecords(Iterable<? extends Record> records)
Load in-memory data.
|
LoaderRowsStep<R> |
LoaderSourceStep.loadRecords(Iterator<? extends Record> records)
Load in-memory data.
|
LoaderRowsStep<R> |
LoaderSourceStep.loadRecords(Stream<? extends Record> records)
Load in-memory data.
|
Condition |
RowN.lt(QuantifiedSelect<? 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(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.notEqual(QuantifiedSelect<? 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(Result<? extends Record> result)
Compare this row value expression with a set of records for
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 |
DefaultRecordUnmapper<E,R extends Record>
A default implementation for unmapping a custom type to a
Record. |
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<Record> |
SQLDataType.RECORD
The
Types.STRUCT type. |
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. |
static <R extends Record,U extends Record> |
Internal.createForeignKey(UniqueKey<U> key,
Table<R> table,
String name,
TableField<R,?>... fields)
Factory method for foreign keys.
|
static <R extends Record,U extends Record> |
Internal.createForeignKey(UniqueKey<U> key,
Table<R> table,
String name,
TableField<R,?>... fields)
Factory method for foreign keys.
|
static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
String name,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
String name,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record,U extends Record> |
Internal.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys.
|
static <R extends Record,U extends Record> |
Internal.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys.
|
static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record,T> |
Internal.createIdentity(Table<R> table,
TableField<R,T> field)
Factory method for identities.
|
static <R extends Record,T> |
AbstractKeys.createIdentity(Table<R> table,
TableField<R,T> field)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record> |
Internal.createUniqueKey(Table<R> table,
String name,
TableField<R,?>... fields)
Factory method for unique keys.
|
static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
String name,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record> |
Internal.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Factory method for unique keys.
|
static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code
|
static <R extends Record> |
DSL.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DefaultDSLContext.delete(Table<R> table) |
static <R extends Record> |
DSL.deleteFrom(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
DefaultDSLContext.deleteFrom(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.fetchAsync(Executor executor,
ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchAsync(Executor executor,
Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchAsync(Executor executor,
Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchAsync(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchAsync(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchAsync(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) |
<R extends Record> |
DefaultDSLContext.fetchOptional(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchOptional(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchOptional(Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchSingle(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchSingle(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchSingle(Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchStream(ResultQuery<R> query) |
<R extends Record> |
DefaultDSLContext.fetchStream(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchStream(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.loadInto(Table<R> 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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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)
|
<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) |
<E,R extends Record> |
DefaultRecordUnmapperProvider.provide(Class<? extends E> type,
RecordType<R> rowType) |
<R extends Record,E> |
DefaultRecordMapperProvider.provide(RecordType<R> rowType,
Class<? extends E> type) |
static <R extends Record> |
DSL.selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(Name table) |
static <R extends Record> |
DSL.selectFrom(SQL sql)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(SQL sql) |
static <R extends Record> |
DSL.selectFrom(String sql)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(String sql) |
static <R extends Record> |
DSL.selectFrom(String sql,
Object... bindings)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(String sql,
Object... bindings) |
static <R extends Record> |
DSL.selectFrom(String sql,
QueryPart... parts)
Create a new DSL select statement.
|
<R extends Record> |
DefaultDSLContext.selectFrom(String sql,
QueryPart... parts) |
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(R... records)
Use a previously obtained set of records as a new Table
|
static <R extends Record> |
DSL.table(R record)
Use a previously obtained record as a new 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(SQL sql) |
Record |
DefaultDSLContext.fetchOne(String sql) |
Record |
DefaultDSLContext.fetchOne(String sql,
Object... bindings) |
Record |
DefaultDSLContext.fetchOne(String sql,
QueryPart... parts) |
Record |
DefaultDSLContext.fetchSingle(ResultSet rs) |
Record |
DefaultDSLContext.fetchSingle(ResultSet rs,
Class<?>... types) |
Record |
DefaultDSLContext.fetchSingle(ResultSet rs,
DataType<?>... types) |
Record |
DefaultDSLContext.fetchSingle(ResultSet rs,
Field<?>... fields) |
Record |
DefaultDSLContext.fetchSingle(SQL sql) |
Record |
DefaultDSLContext.fetchSingle(String sql) |
Record |
DefaultDSLContext.fetchSingle(String sql,
Object... bindings) |
Record |
DefaultDSLContext.fetchSingle(String sql,
QueryPart... parts) |
Record |
UpdatableRecordImpl.key() |
Record |
DefaultDSLContext.newRecord(Collection<? extends Field<?>> fields) |
Record |
DefaultDSLContext.newRecord(Field<?>... fields) |
| Modifier and Type | Method and Description |
|---|---|
static CreateTableAsStep<Record> |
DSL.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createGlobalTemporaryTable(Name table) |
static CreateTableAsStep<Record> |
DSL.createGlobalTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createGlobalTemporaryTable(String table) |
static CreateTableAsStep<Record> |
DSL.createGlobalTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createGlobalTemporaryTable(Table<?> table) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(String view,
String... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Table<?> view,
Field<?>... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createOrReplaceView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction) |
static CreateTableAsStep<Record> |
DSL.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTable(Name table) |
static CreateTableAsStep<Record> |
DSL.createTable(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTable(String table) |
static CreateTableAsStep<Record> |
DSL.createTable(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTable(Table<?> table) |
static CreateTableAsStep<Record> |
DSL.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTableIfNotExists(Name table) |
static CreateTableAsStep<Record> |
DSL.createTableIfNotExists(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTableIfNotExists(String table) |
static CreateTableAsStep<Record> |
DSL.createTableIfNotExists(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTableIfNotExists(Table<?> table) |
static CreateTableAsStep<Record> |
DSL.createTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTemporaryTable(Name table) |
static CreateTableAsStep<Record> |
DSL.createTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTemporaryTable(String table) |
static CreateTableAsStep<Record> |
DSL.createTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTemporaryTable(Table<?> table) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(String view,
String... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Table<?> view,
Field<?>... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(String view,
Function<? super Field<?>,? extends String> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(String view,
String... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Table<?> view,
Field<?>... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction) |
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(SQL sql) |
Result<Record> |
DefaultDSLContext.fetch(String sql) |
Result<Record> |
DefaultDSLContext.fetch(String sql,
Object... bindings) |
Result<Record> |
DefaultDSLContext.fetch(String sql,
QueryPart... parts) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
ResultSet rs) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
ResultSet rs,
Class<?>... types) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
ResultSet rs,
DataType<?>... types) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
ResultSet rs,
Field<?>... fields) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
SQL sql) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
String sql) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
String sql,
Object... bindings) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
String sql,
QueryPart... parts) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(ResultSet rs) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(ResultSet rs,
Class<?>... types) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(ResultSet rs,
DataType<?>... types) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(ResultSet rs,
Field<?>... fields) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(SQL sql) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(String sql) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(String sql,
Object... bindings) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(String sql,
QueryPart... parts) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string,
boolean header) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string,
boolean header,
char delimiter) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(String string,
char delimiter) |
Result<Record> |
DefaultDSLContext.fetchFromHTML(String string) |
Result<Record> |
DefaultDSLContext.fetchFromJSON(String string) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(List<String[]> strings) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(List<String[]> strings,
boolean header) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(String[]... strings) |
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(SQL sql) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql,
Object... bindings) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql,
QueryPart... parts) |
Optional<Record> |
DefaultDSLContext.fetchOptional(ResultSet rs) |
Optional<Record> |
DefaultDSLContext.fetchOptional(ResultSet rs,
Class<?>... types) |
Optional<Record> |
DefaultDSLContext.fetchOptional(ResultSet rs,
DataType<?>... types) |
Optional<Record> |
DefaultDSLContext.fetchOptional(ResultSet rs,
Field<?>... fields) |
Optional<Record> |
DefaultDSLContext.fetchOptional(SQL sql) |
Optional<Record> |
DefaultDSLContext.fetchOptional(String sql) |
Optional<Record> |
DefaultDSLContext.fetchOptional(String sql,
Object... bindings) |
Optional<Record> |
DefaultDSLContext.fetchOptional(String sql,
QueryPart... parts) |
Stream<Record> |
DefaultDSLContext.fetchStream(ResultSet rs) |
Stream<Record> |
DefaultDSLContext.fetchStream(ResultSet rs,
Class<?>... types) |
Stream<Record> |
DefaultDSLContext.fetchStream(ResultSet rs,
DataType<?>... types) |
Stream<Record> |
DefaultDSLContext.fetchStream(ResultSet rs,
Field<?>... fields) |
Stream<Record> |
DefaultDSLContext.fetchStream(SQL sql) |
Stream<Record> |
DefaultDSLContext.fetchStream(String sql) |
Stream<Record> |
DefaultDSLContext.fetchStream(String sql,
Object... bindings) |
Stream<Record> |
DefaultDSLContext.fetchStream(String sql,
QueryPart... parts) |
Result<Record> |
DefaultDSLContext.newResult(Collection<? extends Field<?>> fields) |
Result<Record> |
DefaultDSLContext.newResult(Field<?>... fields) |
static <T1> RecordType<Record> |
DSL.recordType(Collection<? extends Field<?>> fields)
Create a
RecordType of an arbitrary degree. |
static <T1> RecordType<Record> |
DSL.recordType(Field<?>[] fields)
Create a
RecordType of an arbitrary degree. |
static ResultQuery<Record> |
DSL.resultQuery(SQL sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DefaultDSLContext.resultQuery(SQL sql) |
static ResultQuery<Record> |
DSL.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql) |
static ResultQuery<Record> |
DSL.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql,
Object... bindings) |
static ResultQuery<Record> |
DSL.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql,
QueryPart... parts) |
static Table<Record> |
DSL.rowsFrom(Table<?>... tables)
Create a
ROWS FROM (tables...) |
static SelectSelectStep<Record> |
DSL.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields) |
static SelectSelectStep<Record> |
DSL.select(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(SelectFieldOrAsterisk... fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(SelectFieldOrAsterisk... fields) |
SelectQuery<Record> |
DefaultDSLContext.selectQuery() |
static Table<Record> |
DSL.table(Name name)
Create a qualified table, given its table name.
|
static Table<Record> |
DSL.table(Name name,
Comment comment)
Create a qualified table, given its table name.
|
static Table<Record> |
DSL.table(SQL sql)
A custom SQL clause that can render arbitrary table expressions.
|
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)
Deprecated.
- [#3843] - 3.6.0 - use
DSL.table(Name) instead |
static TruncateIdentityStep<Record> |
DSL.truncate(Name table)
Create a new DSL truncate statement.
|
TruncateIdentityStep<Record> |
DefaultDSLContext.truncate(Name table) |
TruncateIdentityStep<Record> |
DefaultDSLContext.truncate(String table) |
static Table<Record> |
DSL.values(RowN... rows)
Create a
VALUES() expression of arbitrary degree. |
| Modifier and Type | Method and Description |
|---|---|
static Condition |
DSL.condition(Record record)
|
static <R extends Record> |
DSL.table(R... records)
Use a previously obtained set of records as a new Table
|
| Modifier and Type | Method and Description |
|---|---|
static MockDataProvider |
Mock.of(Record record)
Create a new
MockDataProvider that always returns a single record
for all queries. |
| Constructor and Description |
|---|
MockResult(Record data)
Create a new
MockResult. |
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
AuroraPostgresDataType.REFCURSOR
Deprecated.
|
| Modifier and Type | Field and Description |
|---|---|
protected static DataType<Result<Record>> |
H2DataType.__RESULT
Deprecated.
|
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
HSQLDBDataType.ROW
Deprecated.
|
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
OracleDataType.REF_CURSOR
Deprecated.
|
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
PostgresDataType.REFCURSOR
Deprecated.
|
| 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. |
| Modifier and Type | Method and Description |
|---|---|
static String |
PostgresUtils.toPGString(Record r)
Create a PostgreSQL string representation of a record.
|
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
RedshiftDataType.REFCURSOR
Deprecated.
|
| Modifier and Type | Field and Description |
|---|---|
static DataType<Result<Record>> |
VerticaDataType.ROW
Deprecated.
|
Copyright © 2019. All rights reserved.