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 |
---|---|
void |
UpdateQuery.addValues(RowN row,
RowN value)
Specify a multi-column set clause for the
UPDATE statement. |
void |
UpdateQuery.addValues(RowN row,
Select<?> select)
Specify a multi-column set clause for the
UPDATE statement. |
Condition |
BetweenAndStepN.and(RowN maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStepN |
RowN.between(RowN minValue)
Check if this row value expression is within a range of two other row
value expressions.
|
Condition |
RowN.between(RowN minValue,
RowN maxValue)
Check if this row value expression is within a range of two other row
value expressions.
|
BetweenAndStepN |
RowN.betweenSymmetric(RowN minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
RowN.betweenSymmetric(RowN minValue,
RowN maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
RowN.compare(Comparator comparator,
RowN row)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
Condition |
RowN.eq(RowN row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
RowN.equal(RowN row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
RowN.ge(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.greaterOrEqual(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.greaterThan(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.gt(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.in(RowN... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
RowN.le(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.lessOrEqual(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.lessThan(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.lt(RowN row)
Compare this row value expression with another row value expression for
order.
|
Condition |
RowN.ne(RowN row)
Compare this row value expression with another row value expression for
non-equality.
|
BetweenAndStepN |
RowN.notBetween(RowN minValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
Condition |
RowN.notBetween(RowN minValue,
RowN maxValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
BetweenAndStepN |
RowN.notBetweenSymmetric(RowN minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
RowN.notBetweenSymmetric(RowN minValue,
RowN maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
RowN.notEqual(RowN row)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
RowN.notIn(RowN... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
UpdateFromStep<R> |
UpdateSetFirstStep.set(RowN row,
RowN value)
Specify a multi-column set clause for the
UPDATE statement. |
UpdateFromStep<R> |
UpdateSetFirstStep.set(RowN row,
Select<?> select)
Specify a multi-column set clause for the
UPDATE statement. |
Modifier and Type | Method and Description |
---|---|
Condition |
RowN.in(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
RowN.notIn(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Modifier and Type | Method and Description |
---|---|
static RowN |
DSL.row(Collection<?> values)
Create a row value expression of degree
N > 22 . |
static RowN |
DSL.row(Field<?>... values)
Create a row value expression of degree
N > 22 . |
static RowN |
DSL.row(Object... values)
Create a row value expression of degree
N > 22 . |
Modifier and Type | Method and Description |
---|---|
static Table<Record> |
DSL.values(RowN... rows)
Create a
VALUES() expression of arbitrary degree. |
Copyright © 2017. All Rights Reserved.