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 |
---|---|
Row2<T1,T2> |
Record2.fieldsRow()
Get this record's fields as a
Row2 . |
Row2<T1,T2> |
Record2.valuesRow()
Get this record's values as a
Row2 . |
Modifier and Type | Method and Description |
---|---|
<T1,T2> void |
UpdateQuery.addValues(Row2<T1,T2> row,
Row2<T1,T2> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2> void |
UpdateQuery.addValues(Row2<T1,T2> row,
Row2<T1,T2> value)
Specify a multi-column set clause for the
UPDATE statement. |
<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 |
BetweenAndStep2.and(Row2<T1,T2> maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStep2<T1,T2> |
Row2.between(Row2<T1,T2> minValue)
Check if this row value expression is within a range of two other row
value expressions.
|
Condition |
Row2.between(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is within a range of two other row
value expressions.
|
Condition |
Row2.between(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is within a range of two other row
value expressions.
|
BetweenAndStep2<T1,T2> |
Row2.betweenSymmetric(Row2<T1,T2> minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
Row2.betweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
Row2.betweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
Row2.compare(Comparator comparator,
Row2<T1,T2> row)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
Condition |
Row2.eq(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
Row2.equal(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
Row2.ge(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.greaterOrEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.greaterThan(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.gt(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.in(Row2<T1,T2>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
Row2.isDistinctFrom(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
distinctness.
|
Condition |
Row2.isNotDistinctFrom(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
distinctness.
|
Condition |
Row2.le(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.lessOrEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.lessThan(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.lt(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
Row2.ne(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
non-equality.
|
BetweenAndStep2<T1,T2> |
Row2.notBetween(Row2<T1,T2> minValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
Condition |
Row2.notBetween(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
Condition |
Row2.notBetween(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
BetweenAndStep2<T1,T2> |
Row2.notBetweenSymmetric(Row2<T1,T2> minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
Row2.notBetweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
Row2.notBetweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
Row2.notEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
Row2.notIn(Row2<T1,T2>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
Row2.overlaps(Row2<T1,T2> row)
Check if this row value expression overlaps another row value expression.
|
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Row2<T1,T2> value)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Row2<T1,T2> value)
Specify a multi-column set clause for the
UPDATE statement. |
<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 |
---|---|
Condition |
Row2.in(Collection<? extends Row2<T1,T2>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
Row2.notIn(Collection<? extends Row2<T1,T2>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Modifier and Type | Method and Description |
---|---|
static <T1,T2> Row2<T1,T2> |
DSL.row(Field<T1> t1,
Field<T2> t2)
Create a row value expression of degree
2 . |
static <T1,T2> Row2<T1,T2> |
DSL.row(T1 t1,
T2 t2)
Create a row value expression of degree
2 . |
Modifier and Type | Method and Description |
---|---|
static <T1,T2> Field<Record2<T1,T2>> |
DSL.rowField(Row2<T1,T2> row)
EXPERIMENTAL: Turn a row value expression of degree
2 into a Field . |
static <T1,T2> Table<Record2<T1,T2>> |
DSL.values(Row2<T1,T2>... rows)
Create a
VALUES() expression of degree 2 . |
Copyright © 2019. All rights reserved.