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 |
CommonTableExpression<R extends Record>
A common table expression is a table that can be supplied to
WITH clauses. |
interface |
Select<R extends Record>
|
interface |
SelectConditionStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
interface |
SelectDistinctOnStep<R extends Record>
|
interface |
SelectFinalStep<R extends Record>
|
interface |
SelectForUpdateOfStep<R extends Record>
|
interface |
SelectForUpdateStep<R extends Record>
|
interface |
SelectForUpdateWaitStep<R extends Record>
|
interface |
SelectFromStep<R extends Record>
|
interface |
SelectGroupByStep<R extends Record>
|
interface |
SelectHavingConditionStep<R extends Record>
|
interface |
SelectHavingStep<R extends Record>
|
interface |
SelectIntoStep<R extends Record>
|
interface |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitAfterOffsetStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
interface |
SelectOptionStep<R extends Record>
|
interface |
SelectOrderByStep<R extends Record>
|
interface |
SelectQuery<R extends Record>
A query for data selection
|
interface |
SelectSeekLimitStep<R extends Record>
|
interface |
SelectSeekStep1<R extends Record,T1>
|
interface |
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
|
interface |
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
|
interface |
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
|
interface |
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
|
interface |
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
|
interface |
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
|
interface |
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
|
interface |
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
|
interface |
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
|
interface |
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
|
interface |
SelectSeekStep2<R extends Record,T1,T2>
|
interface |
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
|
interface |
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
|
interface |
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
|
interface |
SelectSeekStep3<R extends Record,T1,T2,T3>
|
interface |
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
|
interface |
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
|
interface |
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
|
interface |
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
|
interface |
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
|
interface |
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
|
interface |
SelectSeekStepN<R extends Record>
|
interface |
SelectSelectStep<R extends Record>
|
interface |
SelectStartWithStep<R extends Record>
|
interface |
SelectUnionStep<R extends Record>
|
interface |
SelectWhereStep<R extends Record>
|
interface |
SelectWindowStep<R extends Record>
|
interface |
Table<R extends Record>
A table to be used in queries
|
interface |
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of a
JOIN
clause, where the join criteria is added using an ON clause
(with a Condition . |
interface |
TableOptionalOnStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
void |
UpdateQuery.addFrom(TableLike<?>... from)
Add tables to the table product.
|
void |
SelectQuery.addFrom(TableLike<?>... from)
Add tables to the table product.
|
void |
UpdateQuery.addFrom(TableLike<?> from)
Add tables to the table product.
|
void |
SelectQuery.addFrom(TableLike<?> from)
Add tables to the table product.
|
void |
SelectQuery.addJoin(TableLike<?> table,
Condition... conditions)
Joins the existing table product to a new table using a condition,
connecting them with each other with
Operator.AND . |
void |
SelectQuery.addJoin(TableLike<?> table,
JoinType type,
Condition... conditions)
Joins the existing table product to a new table using a condition,
connecting them with each other with
Operator.AND . |
void |
SelectQuery.addJoin(TableLike<?> table,
JoinType type,
Condition[] conditions,
Field<?>[] partitionBy)
Joins the existing table product to a new table using conditions,
connecting them with each other with
Operator.AND . |
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type)
Joins the existing table product to a new table using a foreign key.
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type,
ForeignKey<?,?> key)
Joins the existing table product to a new table using a foreign key.
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type,
TableField<?,?>... keyFields)
Joins the existing table product to a new table using a foreign key.
|
void |
SelectQuery.addJoinUsing(TableLike<?> table,
Collection<? extends Field<?>> fields)
Joins the existing table product to a new table with a
USING
clause. |
void |
SelectQuery.addJoinUsing(TableLike<?> table,
JoinType type,
Collection<? extends Field<?>> fields)
Joins the existing table product to a new table with a
USING
clause. |
Table<Record> |
Table.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(TableLike<?> table)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(TableLike)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
UpdateWhereStep<R> |
UpdateFromStep.from(TableLike<?>... table)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(TableLike<?>... tables)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
UpdateFromStep.from(TableLike<?> table)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(TableLike<?> table)
Add a
FROM clause to the query. |
TableOnStep<Record> |
Table.fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(TableLike<?> table)
Convenience method to
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it |
TableOnStep<Record> |
Table.innerJoin(TableLike<?> table)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(TableLike<?> table)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(TableLike) . |
TableOnStep<Record> |
Table.join(TableLike<?> table)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(TableLike<?> table)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using Table.join(TableLike) . |
TableOptionalOnStep<Record> |
Table.join(TableLike<?> table,
JoinType type)
Join a table to this table using a
JoinType
Depending on the JoinType , a subsequent
TableOnStep.on(Condition...) or
TableOnStep.using(Field...) clause is required. |
SelectOptionalOnStep<R> |
SelectJoinStep.join(TableLike<?> table,
JoinType type)
Convenience method to join a table to the last table added to the
FROM clause using Table.join(TableLike, JoinType)
Depending on the JoinType , a subsequent
SelectOnStep.on(Condition...) or
SelectOnStep.using(Field...) clause is required. |
TableOnStep<R> |
Table.leftAntiJoin(TableLike<?> table)
A synthetic
LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate. |
SelectOnStep<R> |
SelectJoinStep.leftAntiJoin(TableLike<?> table)
A synthetic
LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate. |
TablePartitionByStep<Record> |
Table.leftJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(TableLike<?> table)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(TableLike) . |
TablePartitionByStep<Record> |
Table.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(TableLike<?> table)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(TableLike) |
TableOnStep<R> |
Table.leftSemiJoin(TableLike<?> table)
A synthetic
LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate. |
SelectOnStep<R> |
SelectJoinStep.leftSemiJoin(TableLike<?> table)
A synthetic
LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate. |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(TableLike<?> table)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(TableLike)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(TableLike<?> table)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(TableLike<?> table)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
TablePartitionByStep<Record> |
Table.rightJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(TableLike<?> table)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(TableLike) . |
TablePartitionByStep<Record> |
Table.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(TableLike<?> table)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it |
<R extends Record> |
DSLContext.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
TableOnStep<Record> |
Table.straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
MergeOnStep<R> |
MergeUsingStep.using(TableLike<?> table)
Add the
USING clause to the SQL standard MERGE
statement |
Modifier and Type | Method and Description |
---|---|
void |
UpdateQuery.addFrom(Collection<? extends TableLike<?>> from)
Add tables to the table product.
|
void |
SelectQuery.addFrom(Collection<? extends TableLike<?>> from)
Add tables to the table product.
|
UpdateWhereStep<R> |
UpdateFromStep.from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
Modifier and Type | Class and Description |
---|---|
class |
CustomTable<R extends TableRecord<R>>
A base class for custom
Table implementations in client code. |
class |
TableImpl<R extends Record>
A common base type for tables
This type is for JOOQ INTERNAL USE only.
|
Modifier and Type | Method and Description |
---|---|
static <R extends Record> |
DSL.lateral(TableLike<R> table)
Create a
LATERAL joined table. |
<R extends Record> |
DefaultDSLContext.selectQuery(TableLike<R> table) |
Copyright © 2017. All Rights Reserved.