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 

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
This is the same as calling
between(minValue).and(maxValue)
The expression A BETWEEN B AND C is equivalent to the
expression A >= B AND A <= C for those SQL dialects that do
not properly support the BETWEEN predicate for 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
This is the same as calling
betweenSymmetric(minValue).and(maxValue)
The expression A BETWEEN SYMMETRIC B AND C is equivalent to
the expression (A >= B AND A <= C) OR (A >= C AND A <= B)
for those SQL dialects that do not properly support the
BETWEEN predicate for row value expressions 
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
Row equality comparison predicates can be simulated in those databases
that do not support such predicates natively:
(A, B) = (1, 2) is equivalent to
A = 1 AND B = 2 
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
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) >= (1, 2) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2) 
Condition 
RowN.greaterThan(RowN row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) > (1, 2, 3) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3) 
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
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <= (1, 2) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2) 
Condition 
RowN.lessThan(RowN row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) < (1, 2, 3) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3) 
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
nonequality

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
This is the same as calling
notBetween(minValue).and(maxValue)
The expression A NOT BETWEEN B AND C is equivalent to the
expression A < B OR A > C for those SQL dialects that do
not properly support the BETWEEN predicate for 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
This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
The expression A NOT BETWEEN SYMMETRIC B AND C is equivalent
to the expression (A < B OR A > C) AND (A < C OR A > B) for
those SQL dialects that do not properly support the BETWEEN
predicate for row value expressions 
Condition 
RowN.notEqual(RowN row)
Compare this row value expression with another row value expression for
nonequality
Row nonequality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2) 
Condition 
RowN.notIn(RowN... rows)
Compare this row value expression with a set of row value expressions for
equality

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
Row IN predicates can be simulated in those databases that do not support
such predicates natively:
(A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)) , which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4) 
Condition 
RowN.notIn(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))) , which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4)) 
Modifier and Type  Method and Description 

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 . 
Copyright © 2013. All Rights Reserved.