| 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 | 
|---|---|
Row3<T1,T2,T3> | 
Record3.fieldsRow()
Get this record's fields as a  
Row3 | 
Row3<T1,T2,T3> | 
Record3.valuesRow()
Get this record's values as a  
Row3 | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3> void | 
UpdateQuery.addValues(Row3<T1,T2,T3> row,
         Row3<T1,T2,T3> value)
Specify a multi-column set clause for the  
UPDATE statement. | 
<T1,T2,T3> void | 
UpdateQuery.addValues(Row3<T1,T2,T3> row,
         Row3<T1,T2,T3> value)
Specify a multi-column set clause for the  
UPDATE statement. | 
<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. | 
Condition | 
BetweenAndStep3.and(Row3<T1,T2,T3> maxValue)
Create a condition to check this field against some bounds 
 | 
BetweenAndStep3<T1,T2,T3> | 
Row3.between(Row3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two other row
 value expressions 
 | 
Condition | 
Row3.between(Row3<T1,T2,T3> minValue,
       Row3<T1,T2,T3> 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 | 
Condition | 
Row3.between(Row3<T1,T2,T3> minValue,
       Row3<T1,T2,T3> 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 | 
BetweenAndStep3<T1,T2,T3> | 
Row3.betweenSymmetric(Row3<T1,T2,T3> minValue)
Check if this row value expression is within a symmetric range of two
 other row value expressions 
 | 
Condition | 
Row3.betweenSymmetric(Row3<T1,T2,T3> minValue,
                Row3<T1,T2,T3> 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 | 
Row3.betweenSymmetric(Row3<T1,T2,T3> minValue,
                Row3<T1,T2,T3> 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 | 
Row3.eq(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 equality 
 | 
Condition | 
Row3.equal(Row3<T1,T2,T3> 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 | 
Row3.ge(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order 
 | 
Condition | 
Row3.greaterOrEqual(Row3<T1,T2,T3> 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 | 
Row3.greaterThan(Row3<T1,T2,T3> 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 | 
Row3.gt(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order 
 | 
Condition | 
Row3.in(Row3<T1,T2,T3>... rows)
Compare this row value expression with a set of row value expressions for
 equality 
 | 
Condition | 
Row3.le(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order 
 | 
Condition | 
Row3.lessOrEqual(Row3<T1,T2,T3> 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 | 
Row3.lessThan(Row3<T1,T2,T3> 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 | 
Row3.lt(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order 
 | 
Condition | 
Row3.ne(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 non-equality 
 | 
BetweenAndStep3<T1,T2,T3> | 
Row3.notBetween(Row3<T1,T2,T3> minValue)
Check if this row value expression is not within a range of two other
 row value expressions 
 | 
Condition | 
Row3.notBetween(Row3<T1,T2,T3> minValue,
          Row3<T1,T2,T3> 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 | 
Condition | 
Row3.notBetween(Row3<T1,T2,T3> minValue,
          Row3<T1,T2,T3> 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 | 
BetweenAndStep3<T1,T2,T3> | 
Row3.notBetweenSymmetric(Row3<T1,T2,T3> minValue)
Check if this row value expression is not within a symmetric range of two
 other row value expressions 
 | 
Condition | 
Row3.notBetweenSymmetric(Row3<T1,T2,T3> minValue,
                   Row3<T1,T2,T3> 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 | 
Row3.notBetweenSymmetric(Row3<T1,T2,T3> minValue,
                   Row3<T1,T2,T3> 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 | 
Row3.notEqual(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 non-equality
 
 Row non-equality 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 | 
Row3.notIn(Row3<T1,T2,T3>... rows)
Compare this row value expression with a set of row value expressions for
 equality 
 | 
<T1,T2,T3> UpdateWhereStep<R> | 
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
   Row3<T1,T2,T3> value)
Specify a multi-column set clause for the  
UPDATE statement. | 
<T1,T2,T3> UpdateWhereStep<R> | 
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
   Row3<T1,T2,T3> value)
Specify a multi-column set clause for the  
UPDATE statement. | 
<T1,T2,T3> UpdateWhereStep<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 | 
|---|---|
Condition | 
Row3.in(Collection<? extends Row3<T1,T2,T3>> 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 | 
Row3.notIn(Collection<? extends Row3<T1,T2,T3>> 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 <T1,T2,T3> Row3<T1,T2,T3> | 
DSL.row(Field<T1> t1,
   Field<T2> t2,
   Field<T3> t3)
Create a row value expression of degree  
3. | 
static <T1,T2,T3> Row3<T1,T2,T3> | 
DSL.row(T1 t1,
   T2 t2,
   T3 t3)
Create a row value expression of degree  
3. | 
| Modifier and Type | Method and Description | 
|---|---|
static <T1,T2,T3> Table<Record3<T1,T2,T3>> | 
DSL.values(Row3<T1,T2,T3>... rows)
Create a  
VALUES() expression of degree 3. | 
Copyright © 2013. All Rights Reserved.