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 | Interface and Description |
---|---|
interface |
AggregateFilterStep<T>
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
interface |
AggregateFunction<T>
An aggregate function is a special field that is usually used in a
GROUP BY context. |
interface |
ArrayAggOrderByStep<T>
The SQL standard
ARRAY_AGG() function. |
interface |
Asterisk
A
QueryPart to be used exclusively in SELECT
clauses. |
interface |
CaseConditionStep<T>
The final step in creating a case statement of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
interface |
CaseWhenStep<V,T>
The final step in creating a case statement of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
interface |
Field<T>
A field used in tables and conditions
Note that all fields qualify as
GroupField , i.e. they can always be
used in GROUP BY clauses |
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
Param<T>
A named parameter and/or bind value.
|
interface |
QualifiedAsterisk
A
QueryPart to be used exclusively in SELECT
clauses. |
interface |
SelectField<T>
A
QueryPart to be used exclusively in SELECT
clauses. |
interface |
TableField<R extends Record,T>
A field contained in a table
|
interface |
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT
|
interface |
WindowBeforeOverStep<T>
This type is used for the window function DSL API.
|
interface |
WindowFinalStep<T>
This type is used for the window function DSL API.
|
interface |
WindowOrderByStep<T>
This type is used for the window function DSL API.
|
interface |
WindowPartitionByStep<T>
This type is used for the window function DSL API.
|
interface |
WindowRowsStep<T>
This type is used for the window function DSL API.
|
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields)
Add a PostgreSQL-specific
DISTINCT ON (fields...) |
void |
SelectQuery.addSelect(SelectFieldOrAsterisk... fields)
Add a list of select fields.
|
SelectIntoStep<R> |
SelectDistinctOnStep.distinctOn(SelectFieldOrAsterisk... fields)
Add the PostgreSQL-specific
ON(...) |
SelectIntoStep<R> |
SelectDistinctOnStep.on(SelectFieldOrAsterisk... fields)
Add the PostgreSQL-specific
ON(...) |
UpdateResultStep<R> |
UpdateReturningStep.returning(SelectFieldOrAsterisk... fields)
Configure the
UPDATE statement to return a list of fields in
R . |
InsertResultStep<R> |
InsertReturningStep.returning(SelectFieldOrAsterisk... fields)
Configure the
INSERT statement to return a list of fields in
R . |
DeleteResultStep<R> |
DeleteReturningStep.returning(SelectFieldOrAsterisk... fields)
Configure the
DELETE statement to return a list of fields in
R . |
UpdateResultStep<Record> |
UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
UPDATE statement to return a list of fields in
R . |
InsertResultStep<Record> |
InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
INSERT statement to return a list of fields in
R . |
DeleteResultStep<Record> |
DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields)
Configure the
DELETE statement to return a list of fields in
R . |
SelectSelectStep<Record> |
WithStep.select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
SelectSelectStep.select(SelectFieldOrAsterisk... fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
WithStep.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
void |
UpdateQuery.setReturning(SelectFieldOrAsterisk... fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
StoreQuery.setReturning(SelectFieldOrAsterisk... fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
InsertQuery.setReturning(SelectFieldOrAsterisk... fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
DeleteQuery.setReturning(SelectFieldOrAsterisk... fields)
Configure the
DELETE statement to return a list of fields in
R . |
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)
Add a PostgreSQL-specific
DISTINCT ON (fields...) |
void |
SelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields)
Add a list of select fields.
|
SelectIntoStep<R> |
SelectDistinctOnStep.distinctOn(Collection<? extends SelectFieldOrAsterisk> fields)
Add the PostgreSQL-specific
ON(...) |
SelectIntoStep<R> |
SelectDistinctOnStep.on(Collection<? extends SelectFieldOrAsterisk> fields)
Add the PostgreSQL-specific
ON(...) |
UpdateResultStep<R> |
UpdateReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
UPDATE statement to return a list of fields in
R . |
InsertResultStep<R> |
InsertReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT statement to return a list of fields in
R . |
DeleteResultStep<R> |
DeleteReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
DELETE statement to return a list of fields in
R . |
UpdateResultStep<Record> |
UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
UPDATE statement to return a list of fields in
R . |
InsertResultStep<Record> |
InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT statement to return a list of fields in
R . |
DeleteResultStep<Record> |
DeleteReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
DELETE statement to return a list of fields in
R . |
SelectSelectStep<Record> |
WithStep.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
SelectSelectStep.select(Collection<? extends SelectFieldOrAsterisk> fields)
Add additional fields to the
SELECT clause of this query |
SelectSelectStep<Record> |
DSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
WithStep.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
DSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
void |
UpdateQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
StoreQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
InsertQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
INSERT or UPDATE statement to return a list of fields in
R . |
void |
DeleteQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure the
DELETE statement to return a list of fields in
R . |
Modifier and Type | Class and Description |
---|---|
class |
CustomField<T>
A base class for custom
Field implementations in client code. |
class |
Iif<T> |
class |
NullIf<T> |
Modifier and Type | Method and Description |
---|---|
static AggregateFunction<Integer> |
DSL.count(SelectFieldOrAsterisk field)
Get the count(field) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(SelectFieldOrAsterisk field)
Get the count(distinct field) function.
|
static SelectSelectStep<Record> |
DSL.select(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(SelectFieldOrAsterisk... fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(SelectFieldOrAsterisk... fields) |
Modifier and Type | Method and Description |
---|---|
static SelectSelectStep<Record> |
DSL.select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields) |
static SelectSelectStep<Record> |
DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.
|
SelectSelectStep<Record> |
DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) |
Copyright © 2019. All rights reserved.