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 |
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 |
---|---|
Table<R> |
Table.as(String alias)
Create an alias for this table
|
Table<R> |
TableLike.asTable()
The underlying table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ... |
Table<R> |
TableLike.asTable(String alias)
The underlying aliased table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') [alias] WHERE ... |
Table<Record> |
Table.crossJoin(String sql)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
Table<R> |
TableRecord.getTable()
The table from which this record was read
|
Table<R> |
TableField.getTable() |
Table<R> |
Key.getTable()
The
Key 's owner table |
Table<R> |
Identity.getTable()
The
IDENTITY 's owner table |
Table<R> |
DAO.getTable()
Get the underlying table
|
Table<?> |
Schema.getTable(String name)
Get a table by its name (case-sensitive) in this schema, or
null if no such table exists |
Table<Record> |
PivotInStep.in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(Field<?>... fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(T... values)
Specify the acceptable values for pivoting
|
Table<?> |
SchemaMapping.map(Table<?> table)
Deprecated.
Apply mapping to a given table
|
Table<Record> |
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
DivideByReturningStep.returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
TableOnStep.using(Collection<? extends Field<?>> fields)
Join the table with the
USING(column [, column...]) |
Table<Record> |
TableOnStep.using(Field<?>... fields)
Join the table with the
USING(column [, column...]) |
Modifier and Type | Method and Description |
---|---|
List<Table<?>> |
Schema.getTables()
List all tables contained in this schema
|
Modifier and Type | Method and Description |
---|---|
void |
SchemaMapping.add(Table<?> inputTable,
String outputTable)
Deprecated.
Add tables to this mapping
|
void |
SchemaMapping.add(Table<?> inputTable,
Table<?> outputTable)
Deprecated.
Add tables to this mapping
|
void |
SchemaMapping.add(Table<?> inputTable,
Table<?> outputTable)
Deprecated.
Add tables to this mapping
|
<R extends Record> |
FactoryOperations.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
FactoryOperations.deleteQuery(Table<R> table)
Create a new
DeleteQuery |
DivideByOnStep |
Table.divideBy(Table<?> divisor)
Create a new
TABLE reference from this table, applying
relational division. |
<R extends TableRecord<R>> |
FactoryOperations.executeDelete(Table<R> table)
Deprecated.
- 2.5.0 [#1692] - The semantics of
FactoryOperations.executeDelete(TableRecord, Condition) has changed.
This method here is no longer necessary. |
<R extends TableRecord<R>,T> |
FactoryOperations.executeDelete(Table<R> table,
Condition condition)
Deprecated.
- 2.5.0 [#1692] - The semantics of
FactoryOperations.executeDelete(TableRecord, Condition) has changed.
This method here is no longer necessary. |
<R extends TableRecord<R>> |
FactoryOperations.executeDeleteOne(Table<R> table)
Deprecated.
- 2.5.0 [#1692] - The semantics of
FactoryOperations.executeDelete(TableRecord, Condition) has changed.
This method here is no longer necessary. |
<R extends TableRecord<R>,T> |
FactoryOperations.executeDeleteOne(Table<R> table,
Condition condition)
Deprecated.
- 2.5.0 [#1692] - The semantics of
FactoryOperations.executeDelete(TableRecord, Condition) has changed.
This method here is no longer necessary. |
<R extends TableRecord<R>> |
FactoryOperations.executeInsert(Table<R> table,
R record)
Deprecated.
- 2.5.0 [#1692] - Use
FactoryOperations.executeInsert(TableRecord)
instead |
<R extends TableRecord<R>> |
FactoryOperations.executeUpdate(Table<R> table,
R record)
Deprecated.
- 2.5.0 [#1692] - This "mass" update is no longer supported
|
<R extends TableRecord<R>,T> |
FactoryOperations.executeUpdate(Table<R> table,
R record,
Condition condition)
Deprecated.
- 2.5.0 [#1692] - Use
FactoryOperations.executeUpdate(TableRecord, Condition) instead |
<R extends TableRecord<R>> |
FactoryOperations.executeUpdateOne(Table<R> table,
R record)
Deprecated.
- 2.5.0 [#1692] - This "mass" update is no longer supported
|
<R extends TableRecord<R>,T> |
FactoryOperations.executeUpdateOne(Table<R> table,
R record,
Condition condition)
Deprecated.
- 2.5.0 [#1692] - The semantics of
FactoryOperations.executeUpdate(TableRecord, Condition) has changed.
This method here is no longer necessary. |
<R extends Record> |
FactoryOperations.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryOperations.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryOperations.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this Configuration by
default. |
<Z extends Record> |
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
FactoryOperations.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryOperations.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this Configuration by
default. |
<Z extends Record> |
Cursor.fetchOneInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
<O extends Record> |
UpdatableTable.getReferencesFrom(Table<O> other)
Get a list of
FOREIGN KEY 's of a specific table, referencing
a this table. |
<O extends Record> |
Table.getReferencesTo(Table<O> other)
Get a list of
FOREIGN KEY 's of this table, referencing a
specific table. |
<R extends Record> |
FactoryOperations.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Select<?> select)
Deprecated.
- 2.0.3 - Use any of these methods instead:
|
<R extends Record> |
FactoryOperations.insertQuery(Table<R> into)
Create a new
InsertQuery |
<R extends Record> |
Record.into(Table<R> table)
Map resulting records onto a custom record type.
|
<Z extends Record> |
Result.into(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends TableRecord<R>> |
FactoryOperations.loadInto(Table<R> table)
Create a new
Loader object to load data from a CSV or XML
source |
Table<?> |
SchemaMapping.map(Table<?> table)
Deprecated.
Apply mapping to a given table
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax)
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax)
This statement is available from DSL syntax only.
|
<R extends TableRecord<R>> |
FactoryOperations.newRecord(Table<R> table)
Create a new
Record that can be inserted into the corresponding
table. |
<R extends TableRecord<R>> |
FactoryOperations.newRecord(Table<R> table,
Object source)
Create a new pre-filled
Record that can be inserted into the
corresponding table. |
SimpleSelectForUpdateWaitStep<R> |
SimpleSelectForUpdateOfStep.of(Table<?>... tables)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
SelectForUpdateWaitStep |
SelectForUpdateOfStep.of(Table<?>... tables)
Add an
OF clause to the FOR UPDATE clause at
the end of the query. |
<R extends Record> |
FactoryOperations.selectFrom(Table<R> table)
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
|
void |
SimpleSelectQuery.setForUpdateOf(Table<?>... tables)
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row. |
void |
SelectQuery.setForUpdateOf(Table<?>... tables)
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row. |
void |
LockProvider.setForUpdateOf(Table<?>... tables)
Deprecated.
Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row. |
<R extends Record> |
FactoryOperations.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
FactoryOperations.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
FactoryOperations.updateQuery(Table<R> table)
Create a new
UpdateQuery |
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 |
---|---|
Table<R> |
TableImpl.as(String as)
Subclasses may override this method to provide custom aliasing
implementations
Create an alias for this table
|
Table<R> |
TableRecordImpl.getTable() |
Table<R> |
DAOImpl.getTable() |
Table<R> |
CustomRecord.getTable() |
Table<?> |
SchemaImpl.getTable(String name) |
static Table<?> |
Factory.table(ArrayRecord<?> array)
A synonym for
Factory.unnest(ArrayRecord) |
static Table<?> |
Factory.table(Field<?> cursor)
A synonym for
Factory.unnest(Field) |
static Table<?> |
Factory.table(List<?> list)
A synonym for
Factory.unnest(List) |
static Table<?> |
Factory.table(Object[] array)
A synonym for
Factory.unnest(Object[]) |
static <R extends Record> |
Factory.table(Select<R> select)
A synonym for
TableLike.asTable() . |
static Table<Record> |
Factory.table(String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.table(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.tableByName(String... qualifiedName)
Create a qualified table, given its table name
This constructs a table reference given the table's qualified name. jOOQ
will render the table name according to your
Settings.getRenderNameStyle() settings. |
static Table<?> |
Factory.unnest(ArrayRecord<?> array)
Create a table from an array of values
This wraps the argument array in a
TABLE function for
Oracle. |
static Table<?> |
Factory.unnest(Field<?> cursor)
Create a table from a field.
|
static Table<?> |
Factory.unnest(List<?> list)
Create a table from a list of values
This is equivalent to the
TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries. |
static Table<?> |
Factory.unnest(Object[] array)
Create a table from an array of values
This is equivalent to the
TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries. |
Modifier and Type | Method and Description |
---|---|
List<Table<?>> |
SchemaImpl.getTables()
List all tables contained in this schema
|
Modifier and Type | Method and Description |
---|---|
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys
|
protected static <R extends Record,T> |
AbstractKeys.createIdentity(Table<R> table,
TableField<R,T> field)
Factory method for identities
|
protected static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Factory method for unique keys
|
<R extends Record> |
FactoryProxy.delete(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
FactoryProxy.deleteQuery(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.deleteQuery(Table<R> table)
Create a new
DeleteQuery |
<R extends TableRecord<R>> |
FactoryProxy.executeDelete(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.executeDelete(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>,T> |
FactoryProxy.executeDelete(Table<R> table,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>,T> |
Factory.executeDelete(Table<R> table,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>> |
FactoryProxy.executeDeleteOne(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.executeDeleteOne(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>,T> |
FactoryProxy.executeDeleteOne(Table<R> table,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>,T> |
Factory.executeDeleteOne(Table<R> table,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>> |
FactoryProxy.executeInsert(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.executeInsert(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>> |
FactoryProxy.executeUpdate(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.executeUpdate(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>,T> |
FactoryProxy.executeUpdate(Table<R> table,
R record,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>,T> |
Factory.executeUpdate(Table<R> table,
R record,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>> |
FactoryProxy.executeUpdateOne(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.executeUpdateOne(Table<R> table,
R record)
Deprecated.
|
<R extends TableRecord<R>,T> |
FactoryProxy.executeUpdateOne(Table<R> table,
R record,
Condition condition)
Deprecated.
|
<R extends TableRecord<R>,T> |
Factory.executeUpdateOne(Table<R> table,
R record,
Condition condition)
Deprecated.
|
<R extends Record> |
FactoryProxy.fetch(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryProxy.fetch(Table<R> table,
Condition condition)
Deprecated.
|
<R extends Record> |
Factory.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryProxy.fetchAny(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryProxy.fetchOne(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryProxy.fetchOne(Table<R> table,
Condition condition)
Deprecated.
|
<R extends Record> |
Factory.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this Configuration by
default. |
<O extends Record> |
UpdatableTableImpl.getReferencesFrom(Table<O> other) |
<R extends Record> |
FactoryProxy.insertInto(Table<R> into)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Field<?>... fields)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
<R extends Record> |
FactoryProxy.insertQuery(Table<R> into)
Deprecated.
|
<R extends Record> |
Factory.insertQuery(Table<R> into)
Create a new
InsertQuery |
<R extends TableRecord<R>> |
FactoryProxy.loadInto(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.loadInto(Table<R> table)
Create a new
Loader object to load data from a CSV or XML
source |
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax)
|
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table,
Field<?>... fields)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax)
This statement is available from DSL syntax only.
|
<R extends TableRecord<R>> |
FactoryProxy.newRecord(Table<R> table)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.newRecord(Table<R> table)
Create a new
Record that can be inserted into the corresponding
table. |
<R extends TableRecord<R>> |
FactoryProxy.newRecord(Table<R> table,
Object source)
Deprecated.
|
<R extends TableRecord<R>> |
Factory.newRecord(Table<R> table,
Object source)
Create a new pre-filled
Record that can be inserted into the
corresponding table. |
<R extends Record> |
FactoryProxy.selectFrom(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.selectFrom(Table<R> table)
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
|
<R extends Record> |
FactoryProxy.truncate(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
FactoryProxy.update(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
FactoryProxy.updateQuery(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.updateQuery(Table<R> table)
Create a new
UpdateQuery |
Constructor and Description |
---|
CustomRecord(Table<R> table) |
DAOImpl(Table<R> table,
Class<P> type) |
DAOImpl(Table<R> table,
Class<P> type,
Factory create) |
TableImpl(String name,
Schema schema,
Table<R> aliased) |
TableImpl(String name,
Table<R> aliased) |
TableRecordImpl(Table<R> table) |
UpdatableTableImpl(String name,
Schema schema,
Table<R> aliased) |
Copyright © 2013. All Rights Reserved.