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> Record2<T1,T2> |
Record.into(Field<T1> field1,
Field<T2> field2)
Copy this record into a new record holding only a subset of the previous
fields.
|
<T1,T2> Record2<T1,T2> |
DSLContext.newRecord(Field<T1> field1,
Field<T2> field2)
Create a new empty
Record . |
Record2<T1,T2> |
Record2.value1(T1 value)
Set the first value.
|
Record2<T1,T2> |
Record2.value2(T2 value)
Set the second value.
|
Record2<T1,T2> |
Record2.values(T1 t1,
T2 t2)
Set all values.
|
Modifier and Type | Method and Description |
---|---|
<T1,T2> Result<Record2<T1,T2>> |
Result.into(Field<T1> field1,
Field<T2> field2)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2> Result<Record2<T1,T2>> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2)
Create a new empty
Result . |
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
WithStep.select(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSLContext.select(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
WithStep.selectDistinct(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2)
Create a new DSL select statement.
|
Modifier and Type | Method and Description |
---|---|
Condition |
BetweenAndStep2.and(Record2<T1,T2> maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStep2<T1,T2> |
Row2.between(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row2.between(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row2.between(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep2<T1,T2> |
Row2.betweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row2.betweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row2.betweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row2.compare(Comparator comparator,
Record2<T1,T2> record)
Compare this row value expression with a record
using a dynamic comparator.
|
Condition |
Row2.eq(Record2<T1,T2> record)
Compare this row value expression with a record for equality.
|
Condition |
Row2.equal(Record2<T1,T2> record)
Compare this row value expression with a record for equality.
|
Condition |
Row2.ge(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.greaterOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.greaterThan(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.gt(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.in(Record2<T1,T2>... record)
Compare this row value expression with a set of records for equality.
|
Condition |
Row2.le(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.lessOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.lessThan(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.lt(Record2<T1,T2> record)
Compare this row value expression with a record for order.
|
Condition |
Row2.ne(Record2<T1,T2> record)
Compare this row value expression with a record for non-equality.
|
BetweenAndStep2<T1,T2> |
Row2.notBetween(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row2.notBetween(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row2.notBetween(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep2<T1,T2> |
Row2.notBetweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row2.notBetweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row2.notBetweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row2.notEqual(Record2<T1,T2> record)
Compare this row value expression with a record for non-equality
|
Condition |
Row2.notIn(Record2<T1,T2>... record)
Compare this row value expression with a set of records for non-equality.
|
Modifier and Type | Method and Description |
---|---|
<T1,T2> void |
UpdateQuery.addValues(Row2<T1,T2> row,
Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Condition |
Row2.compare(Comparator comparator,
QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row2.compare(Comparator comparator,
Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row2.eq(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.eq(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.equal(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.equal(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.ge(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.ge(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterThan(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.gt(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.gt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.in(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row2.in(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.le(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.le(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessThan(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lt(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.ne(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.ne(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.notEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.notEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.notIn(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row2.notIn(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Merge<R> |
MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
Insert<R> |
InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Modifier and Type | Method and Description |
---|---|
<T1,T2> Record2<T1,T2> |
DefaultDSLContext.newRecord(Field<T1> field1,
Field<T2> field2) |
Modifier and Type | Method and Description |
---|---|
<T1,T2> Result<Record2<T1,T2>> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2) |
static <T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSL.select(Field<T1> field1,
Field<T2> field2)
Create a new DSL subselect statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DefaultDSLContext.select(Field<T1> field1,
Field<T2> field2) |
static <T1,T2> SelectSelectStep<Record2<T1,T2>> |
DSL.selectDistinct(Field<T1> field1,
Field<T2> field2)
Create a new DSL subselect statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
DefaultDSLContext.selectDistinct(Field<T1> field1,
Field<T2> field2) |
static <T1,T2> Table<Record2<T1,T2>> |
DSL.values(Row2<T1,T2>... rows)
Create a
VALUES() expression of degree 2 . |
Copyright © 2014. All Rights Reserved.