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. |
Modifier and Type | Method and Description |
---|---|
<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> SelectSelectStep<Record1<T1>> |
DSLContext.select(Field<T1> field1)
Create a new DSL select statement.
|
SelectSelectStep<Record1<Integer>> |
DSLContext.selectCount()
Create a new DSL select statement for
COUNT(*) . |
<T1> SelectSelectStep<Record1<T1>> |
DSLContext.selectDistinct(Field<T1> field1)
Create a new DSL select statement.
|
SelectSelectStep<Record1<Integer>> |
DSLContext.selectOne()
Create a new DSL select statement for a constant
1 literal. |
SelectSelectStep<Record1<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 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 |
Field.compare(Comparator comparator,
Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.
|
Condition |
Field.eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select |
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 |
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 |
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 |
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 |
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 |
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(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 |
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 |
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 |
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 |
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 |
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 |
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(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.
|
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> 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. |
Modifier and Type | Method and Description |
---|---|
<T,R extends Record1<T>> |
DefaultDSLContext.fetchValue(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<Integer>> |
DSL.generateSeries(Field<Integer> from,
Field<Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
DSL.generateSeries(Field<Integer> from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
DSL.generateSeries(int from,
Field<Integer> to)
A table function generating a series of values from
from to
to (inclusive). |
static Table<Record1<Integer>> |
DSL.generateSeries(int from,
int to)
A table function generating a series of values from
from to
to (inclusive). |
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<Integer>> |
DSL.selectCount()
Create a new DSL subselect statement for
COUNT(*) . |
SelectSelectStep<Record1<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<Integer>> |
DSL.selectOne()
Create a new DSL subselect statement for a constant
1
literal. |
SelectSelectStep<Record1<Integer>> |
DefaultDSLContext.selectOne() |
static SelectSelectStep<Record1<Integer>> |
DSL.selectZero()
Create a new DSL subselect statement for a constant
0
literal. |
SelectSelectStep<Record1<Integer>> |
DefaultDSLContext.selectZero() |
static <T1> Table<Record1<T1>> |
DSL.values(Row1<T1>... rows)
Create a
VALUES() expression of degree 1 . |
Copyright © 2014. All Rights Reserved.