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 |
---|---|
<R extends Record3<?,?,?>> |
DerivedColumnList3.as(Select<R> select)
Specify a subselect to refer to by the
DerivedColumnList to
form a common table expression. |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3> Record3<T1,T2,T3> |
Record.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Copy this record into a new record holding only a subset of the previous
fields.
|
<T1,T2,T3> Record3<T1,T2,T3> |
DSLContext.newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new empty
Record . |
Record3<T1,T2,T3> |
Record3.value1(T1 value)
Set the first value.
|
Record3<T1,T2,T3> |
Record3.value2(T2 value)
Set the second value.
|
Record3<T1,T2,T3> |
Record3.value3(T3 value)
Set the third value.
|
Record3<T1,T2,T3> |
Record3.values(T1 t1,
T2 t2,
T3 t3)
Set all values.
|
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new empty
Result . |
<T1,T2,T3> UpdateResultStep<Record3<T1,T2,T3>> |
UpdateReturningStep.returningResult(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Configure the
UPDATE statement to return a list of fields in
R . |
<T1,T2,T3> InsertResultStep<Record3<T1,T2,T3>> |
InsertReturningStep.returningResult(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Configure the
INSERT statement to return a list of fields in
R . |
<T1,T2,T3> DeleteResultStep<Record3<T1,T2,T3>> |
DeleteReturningStep.returningResult(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Configure the
DELETE statement to return a list of fields in
R . |
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
WithStep.select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSLContext.select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
WithStep.selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSLContext.selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
Modifier and Type | Method and Description |
---|---|
Condition |
BetweenAndStep3.and(Record3<T1,T2,T3> maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStep3<T1,T2,T3> |
Row3.between(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row3.between(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row3.between(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep3<T1,T2,T3> |
Row3.betweenSymmetric(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row3.betweenSymmetric(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row3.betweenSymmetric(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row3.compare(Comparator comparator,
Record3<T1,T2,T3> record)
Compare this row value expression with a record
using a dynamic comparator.
|
Condition |
Row3.eq(Record3<T1,T2,T3> record)
Compare this row value expression with a record for equality.
|
Condition |
Row3.equal(Record3<T1,T2,T3> record)
Compare this row value expression with a record for equality.
|
Condition |
Row3.ge(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.greaterOrEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.greaterThan(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.gt(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.in(Record3<T1,T2,T3>... record)
Compare this row value expression with a set of records for equality.
|
Condition |
Row3.isDistinctFrom(Record3<T1,T2,T3> record)
Compare this row value expression with another row value expression for
distinctness.
|
Condition |
Row3.isNotDistinctFrom(Record3<T1,T2,T3> record)
Compare this row value expression with another row value expression for
distinctness.
|
Condition |
Row3.le(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.lessOrEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.lessThan(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.lt(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order.
|
Condition |
Row3.ne(Record3<T1,T2,T3> record)
Compare this row value expression with a record for non-equality.
|
BetweenAndStep3<T1,T2,T3> |
Row3.notBetween(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row3.notBetween(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row3.notBetween(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep3<T1,T2,T3> |
Row3.notBetweenSymmetric(Record3<T1,T2,T3> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row3.notBetweenSymmetric(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row3.notBetweenSymmetric(Record3<T1,T2,T3> minValue,
Record3<T1,T2,T3> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row3.notEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for non-equality
|
Condition |
Row3.notIn(Record3<T1,T2,T3>... record)
Compare this row value expression with a set of records for non-equality.
|
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3> void |
UpdateQuery.addValues(Row3<T1,T2,T3> row,
Select<? extends Record3<T1,T2,T3>> select)
Specify a multi-column set clause for the
UPDATE statement. |
WithStep |
WithAsStep3.as(Select<? extends Record3<?,?,?>> select)
Associate a subselect with a common table expression's table and column names.
|
Condition |
Row3.compare(Comparator comparator,
QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row3.compare(Comparator comparator,
Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row3.eq(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.eq(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.equal(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.equal(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.ge(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.ge(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.gt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.gt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.in(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row3.in(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.le(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.le(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.ne(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.ne(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.notEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.notEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.notIn(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row3.notIn(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Merge<R> |
MergeValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
InsertOnDuplicateStep<R> |
InsertValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
<T1,T2,T3> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
Select<? extends Record3<T1,T2,T3>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3> Record3<T1,T2,T3> |
DefaultDSLContext.newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3) |
Modifier and Type | Method and Description |
---|---|
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3) |
static <T1,T2,T3> RecordType<Record3<T1,T2,T3>> |
DSL.recordType(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a
RecordType of degree 3 . |
static <T1,T2,T3> Field<Record3<T1,T2,T3>> |
DSL.rowField(Row3<T1,T2,T3> row)
EXPERIMENTAL: Turn a row value expression of degree
3 into a Field . |
static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSL.select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL subselect statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DefaultDSLContext.select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3) |
static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DSL.selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL subselect statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
DefaultDSLContext.selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3) |
static <T1,T2,T3> Table<Record3<T1,T2,T3>> |
DSL.values(Row3<T1,T2,T3>... rows)
Create a
VALUES() expression of degree 3 . |
Copyright © 2019. All rights reserved.