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. |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.newRecord(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 empty
Record . |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.select(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 select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.selectDistinct(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 select statement.
|
Modifier and Type | Method and Description |
---|---|
Condition |
BetweenAndStep13.and(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
Row13.between(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row13.between(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row13.between(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
Row13.betweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row13.betweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row13.betweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row13.compare(Comparator comparator,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record record
using a dynamic comparator.
|
Condition |
Row13.eq(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for equality.
|
Condition |
Row13.equal(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for equality.
|
Condition |
Row13.ge(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.greaterOrEqual(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.greaterThan(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.gt(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.in(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... record)
Compare this row value expression with a set of records for equality.
|
Condition |
Row13.le(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.lessOrEqual(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.lessThan(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.lt(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for order.
|
Condition |
Row13.ne(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for non-equality.
|
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
Row13.notBetween(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row13.notBetween(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row13.notBetween(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
Row13.notBetweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row13.notBetweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row13.notBetweenSymmetric(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> minValue,
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row13.notEqual(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> record)
Compare this row value expression with a record for non-equality
|
Condition |
Row13.notIn(Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... record)
Compare this row value expression with a set of records for non-equality.
|
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
UpdateQuery.addValues(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row,
Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Condition |
Row13.eq(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.equal(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.ge(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.greaterOrEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.greaterThan(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.gt(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.in(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.le(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lessOrEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lessThan(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lt(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.ne(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row13.notEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row13.notIn(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Merge<R> |
MergeValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
Insert<R> |
InsertValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
UpdateSetFirstStep.set(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row,
Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.newRecord(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) |
Modifier and Type | Method and Description |
---|---|
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.select(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 subselect statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.select(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 <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.selectDistinct(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 subselect statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.selectDistinct(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 <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSL.values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows)
Create a
VALUES() expression of degree 13 . |
Copyright © 2013. All Rights Reserved.