| Package | Description |
|---|---|
| org.jooq |
The
org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. |
| org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes
This package provides implementations for the jOOQ API from
org.jooq, whose interfaces are constructed mostly through the
Factory class, which hides implementation facts from
the public API |
| Modifier and Type | Interface and Description |
|---|---|
interface |
Select<R extends Record>
|
interface |
SelectConditionStep
|
interface |
SelectConnectByConditionStep
|
interface |
SelectConnectByStep
|
interface |
SelectFinalStep
|
interface |
SelectForUpdateOfStep
|
interface |
SelectForUpdateStep
|
interface |
SelectForUpdateWaitStep
|
interface |
SelectFromStep
|
interface |
SelectGroupByStep
|
interface |
SelectHavingConditionStep
|
interface |
SelectHavingStep
|
interface |
SelectJoinStep
|
interface |
SelectLimitStep
|
interface |
SelectOffsetStep
|
interface |
SelectOnConditionStep
|
interface |
SelectOptionalOnStep
|
interface |
SelectOrderByStep
|
interface |
SelectQuery
A query for data selection
|
interface |
SelectSelectStep
|
interface |
SelectStartWithStep
|
interface |
SelectWhereStep
|
interface |
SimpleSelectConditionStep<R extends Record>
|
interface |
SimpleSelectFinalStep<R extends Record>
|
interface |
SimpleSelectForUpdateOfStep<R extends Record>
|
interface |
SimpleSelectForUpdateStep<R extends Record>
|
interface |
SimpleSelectForUpdateWaitStep<R extends Record>
|
interface |
SimpleSelectLimitStep<R extends Record>
|
interface |
SimpleSelectOffsetStep<R extends Record>
|
interface |
SimpleSelectOrderByStep<R extends Record>
|
interface |
SimpleSelectQuery<R extends Record>
A simple select query that provides Records from a single table, with no
joins allowed.
|
interface |
SimpleSelectWhereStep<R extends Record>
|
interface |
Table<R extends Record>
A table to be used in queries
|
interface |
TableOnConditionStep
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
|
interface |
UpdatableTable<R extends Record>
A common interface for tables whose records can be stored back to the
database again.
|
| Modifier and Type | Method and Description |
|---|---|
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
|
void |
SelectQuery.addJoin(TableLike<?> table,
JoinType type,
Condition... conditions)
Joins the existing table product to a new table using a condition
|
void |
SelectQuery.addJoin(TableLike<?> table,
JoinType type,
Condition[] conditions,
Field<?>[] partitionBy)
Joins the existing table product to a new table using a condition
This adds a
PARTITION BY clause to the right hand side of a
OUTER JOIN expression. |
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
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query. |
void |
SelectQuery.addJoinUsing(TableLike<?> table,
JoinType type,
Collection<? extends Field<?>> fields)
Joins the existing table product to a new table with a
USING
clause
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
SelectJoinStep |
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 simulated with a regular
INNER JOIN. |
SelectJoinStep |
SelectFromStep.from(TableLike<?>... table)
Add a
FROM clause to the query |
TableOnStep |
Table.fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
SelectOnStep |
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 |
Table.join(TableLike<?> table)
INNER JOIN a table to this table. |
SelectOnStep |
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 |
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 |
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. |
TablePartitionByStep |
Table.leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep |
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) |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
SelectJoinStep |
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 |
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 |
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. |
TablePartitionByStep |
Table.rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep |
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> |
FactoryOperations.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
MergeOnStep<R> |
MergeUsingStep.using(TableLike<?> table)
Add the
USING clause to the SQL standard MERGE
statement |
| Modifier and Type | Method and Description |
|---|---|
void |
SelectQuery.addFrom(Collection<? extends TableLike<?>> from)
Add tables to the table product
|
SelectJoinStep |
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.
|
class |
UpdatableTableImpl<R extends Record>
A table implementation for a table holding a primary key
This type is for JOOQ INTERNAL USE only.
|
| Modifier and Type | Method and Description |
|---|---|
<R extends Record> |
FactoryProxy.selectQuery(TableLike<R> table)
Deprecated.
|
<R extends Record> |
Factory.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
Copyright © 2013. All Rights Reserved.