| 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 |
|---|---|
<T,R extends Record1<T>> |
DSLContext.fetchValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T,R extends Record1<T>> |
DSLContext.fetchValues(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return all values for the only column. |
| Modifier and Type | Method and Description |
|---|---|
<T1> Record1<T1> |
Record.into(Field<T1> field1)
Copy this record into a new record holding only a subset of the previous
fields.
|
<T1> Record1<T1> |
DSLContext.newRecord(Field<T1> field1)
Create a new empty
Record. |
Record1<T1> |
Record1.value1(T1 value)
Set the first value.
|
Record1<T1> |
Record1.values(T1 t1)
Set all values.
|
| Modifier and Type | Method and Description |
|---|---|
<T1> Result<Record1<T1>> |
Result.into(Field<T1> field1)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1> Result<Record1<T1>> |
DSLContext.newResult(Field<T1> field1)
Create a new empty
Result. |
<T1> SelectSelectStep<Record1<T1>> |
WithStep.select(Field<T1> field1)
Create a new DSL select statement.
|
<T1> SelectSelectStep<Record1<T1>> |
DSLContext.select(Field<T1> field1)
Create a new DSL select statement.
|
SelectSelectStep<Record1<java.lang.Integer>> |
WithStep.selectCount()
Create a new DSL select statement for
COUNT(*). |
SelectSelectStep<Record1<java.lang.Integer>> |
DSLContext.selectCount()
Create a new DSL select statement for
COUNT(*). |
<T1> SelectSelectStep<Record1<T1>> |
WithStep.selectDistinct(Field<T1> field1)
Create a new DSL select statement.
|
<T1> SelectSelectStep<Record1<T1>> |
DSLContext.selectDistinct(Field<T1> field1)
Create a new DSL select statement.
|
SelectSelectStep<Record1<java.lang.Integer>> |
WithStep.selectOne()
Create a new DSL select statement for a constant
1 literal. |
SelectSelectStep<Record1<java.lang.Integer>> |
DSLContext.selectOne()
Create a new DSL select statement for a constant
1 literal. |
SelectSelectStep<Record1<java.lang.Integer>> |
WithStep.selectZero()
Create a new DSL select statement for a constant
0 literal. |
SelectSelectStep<Record1<java.lang.Integer>> |
DSLContext.selectZero()
Create a new DSL select statement for a constant
0 literal. |
| Modifier and Type | Method and Description |
|---|---|
Condition |
BetweenAndStep1.and(Record1<T1> maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStep1<T1> |
Row1.between(Record1<T1> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row1.between(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row1.between(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep1<T1> |
Row1.betweenSymmetric(Record1<T1> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row1.betweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row1.betweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
Row1.compare(Comparator comparator,
Record1<T1> record)
Compare this row value expression with a record
using a dynamic comparator.
|
Condition |
Row1.eq(Record1<T1> record)
Compare this row value expression with a record for equality.
|
Condition |
Row1.equal(Record1<T1> record)
Compare this row value expression with a record for equality.
|
Condition |
Row1.ge(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.greaterOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.greaterThan(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.gt(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.in(Record1<T1>... record)
Compare this row value expression with a set of records for equality.
|
Condition |
Row1.le(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.lessOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.lessThan(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.lt(Record1<T1> record)
Compare this row value expression with a record for order.
|
Condition |
Row1.ne(Record1<T1> record)
Compare this row value expression with a record for non-equality.
|
BetweenAndStep1<T1> |
Row1.notBetween(Record1<T1> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row1.notBetween(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.
|
Condition |
Row1.notBetween(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep1<T1> |
Row1.notBetweenSymmetric(Record1<T1> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row1.notBetweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row1.notBetweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
Row1.notEqual(Record1<T1> record)
Compare this row value expression with a record for non-equality
|
Condition |
Row1.notIn(Record1<T1>... record)
Compare this row value expression with a set of records for non-equality.
|
| Modifier and Type | Method and Description |
|---|---|
<T1> void |
UpdateQuery.addValues(Row1<T1> row,
Select<? extends Record1<T1>> select)
Specify a multi-column set clause for the
UPDATE statement. |
Condition |
Field.compare(Comparator comparator,
QuantifiedSelect<? extends Record1<T>> query)
Compare this field with a quantified subselect using a dynamic
comparator.
|
Condition |
Row1.compare(Comparator comparator,
QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Field.compare(Comparator comparator,
Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.
|
Condition |
Row1.compare(Comparator comparator,
Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Field.eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select
|
Condition |
Row1.eq(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.eq(Select<? extends Record1<T>> query)
this = (Select
|
Condition |
Row1.eq(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.equal(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select
|
Condition |
Row1.equal(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.equal(Select<? extends Record1<T>> query)
this = (Select
|
Condition |
Row1.equal(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.ge(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select
|
Condition |
Row1.ge(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.ge(Select<? extends Record1<T>> query)
this >= (Select
|
Condition |
Row1.ge(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select
|
Condition |
Row1.greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select
|
Condition |
Row1.greaterOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterThan(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select
|
Condition |
Row1.greaterThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterThan(Select<? extends Record1<T>> query)
this > (Select
|
Condition |
Row1.greaterThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.gt(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select
|
Condition |
Row1.gt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.gt(Select<? extends Record1<T>> query)
this > (Select
|
Condition |
Row1.gt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.in(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a
previous query.
|
Condition |
Row1.in(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Field.in(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Row1.in(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.le(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select
|
Condition |
Row1.le(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.le(Select<? extends Record1<T>> query)
this <= (Select
|
Condition |
Row1.le(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select
|
Condition |
Row1.lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select
|
Condition |
Row1.lessOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessThan(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select
|
Condition |
Row1.lessThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessThan(Select<? extends Record1<T>> query)
this < (Select
|
Condition |
Row1.lessThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lt(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select
|
Condition |
Row1.lt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lt(Select<? extends Record1<T>> query)
this < (Select
|
Condition |
Row1.lt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.ne(QuantifiedSelect<? extends Record1<T>> query)
this ! |
Condition |
Row1.ne(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.ne(Select<? extends Record1<T>> query)
this ! |
Condition |
Row1.ne(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.notEqual(QuantifiedSelect<? extends Record1<T>> query)
this ! |
Condition |
Row1.notEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.notEqual(Select<? extends Record1<T>> query)
this ! |
Condition |
Row1.notEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.notIn(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a
previous query.
|
Condition |
Row1.notIn(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Field.notIn(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Row1.notIn(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Field<T> |
CaseConditionStep.otherwise(Select<? extends Record1<T>> result)
Add an else clause to the already constructed case statement
|
Merge<R> |
MergeValuesStep1.select(Select<? extends Record1<T1>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
Insert<R> |
InsertValuesStep1.select(Select<? extends Record1<T1>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
<T> UpdateSetMoreStep<R> |
UpdateSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
UPDATE statement. |
<T> MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause. |
<T> MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause. |
<T> InsertSetMoreStep<R> |
InsertSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
INSERT statement. |
<T> InsertSetMoreStep<R> |
InsertSetMoreStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
INSERT statement. |
<T> InsertOnDuplicateSetMoreStep<R> |
InsertOnDuplicateSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause. |
<T1> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row1<T1> row,
Select<? extends Record1<T1>> select)
Specify a multi-column set clause for the
UPDATE statement. |
CaseConditionStep<T> |
CaseConditionStep.when(Condition condition,
Select<? extends Record1<T>> result)
Compare a condition to the already constructed case statement, return
result if the condition holds true
|
<T> CaseConditionStep<T> |
Case.when(Condition condition,
Select<? extends Record1<T>> result)
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the |
<T> CaseWhenStep<V,T> |
CaseValueStep.when(Field<V> compareValue,
Select<? extends Record1<T>> result)
Compare a value to the already constructed case statement, return result
if values are equal.
|
<T> CaseWhenStep<V,T> |
CaseValueStep.when(V compareValue,
Select<? extends Record1<T>> result)
Compare a value to the already constructed case statement, return result
if values are equal.
|
| Modifier and Type | Method and Description |
|---|---|
<T,R extends Record1<T>> |
DefaultDSLContext.fetchValue(ResultQuery<R> query) |
<T,R extends Record1<T>> |
DefaultDSLContext.fetchValues(ResultQuery<R> query) |
| Modifier and Type | Method and Description |
|---|---|
<T1> Record1<T1> |
DefaultDSLContext.newRecord(Field<T1> field1) |
| Modifier and Type | Method and Description |
|---|---|
static <T> QuantifiedSelect<Record1<T>> |
DSL.all(Field<T[]> array)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.all(T... array)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.any(Field<T[]> array)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static <T> QuantifiedSelect<Record1<T>> |
DSL.any(T... array)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static Table<Record1<java.lang.Integer>> |
DSL.generateSeries(Field<java.lang.Integer> from,
Field<java.lang.Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<java.lang.Integer>> |
DSL.generateSeries(Field<java.lang.Integer> from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<java.lang.Integer>> |
DSL.generateSeries(int from,
Field<java.lang.Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<java.lang.Integer>> |
DSL.generateSeries(int from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
<T1> Result<Record1<T1>> |
DefaultDSLContext.newResult(Field<T1> field1) |
static <T1> SelectSelectStep<Record1<T1>> |
DSL.select(Field<T1> field1)
Create a new DSL subselect statement.
|
<T1> SelectSelectStep<Record1<T1>> |
DefaultDSLContext.select(Field<T1> field1) |
static SelectSelectStep<Record1<java.lang.Integer>> |
DSL.selectCount()
Create a new DSL subselect statement for
COUNT(*). |
SelectSelectStep<Record1<java.lang.Integer>> |
DefaultDSLContext.selectCount() |
static <T1> SelectSelectStep<Record1<T1>> |
DSL.selectDistinct(Field<T1> field1)
Create a new DSL subselect statement.
|
<T1> SelectSelectStep<Record1<T1>> |
DefaultDSLContext.selectDistinct(Field<T1> field1) |
static SelectSelectStep<Record1<java.lang.Integer>> |
DSL.selectOne()
Create a new DSL subselect statement for a constant
1
literal. |
SelectSelectStep<Record1<java.lang.Integer>> |
DefaultDSLContext.selectOne() |
static SelectSelectStep<Record1<java.lang.Integer>> |
DSL.selectZero()
Create a new DSL subselect statement for a constant
0
literal. |
SelectSelectStep<Record1<java.lang.Integer>> |
DefaultDSLContext.selectZero() |
static <T1> Table<Record1<T1>> |
DSL.values(Row1<T1>... rows)
Create a
VALUES() expression of degree 1. |
| Modifier and Type | Method and Description |
|---|---|
static <T> Field<T> |
DSL.field(Select<? extends Record1<T>> select)
Transform a subquery into a correlated subquery.
|
Copyright © 2014. All Rights Reserved.