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 |
---|---|
TableField<R,T> |
Identity.getField()
The
IDENTITY column. |
TableField<R,?>[] |
Key.getFieldsArray()
The fields that make up the
KEY |
TableField<R,? extends Date> |
Table.getRecordTimestamp()
A "timestamp" field holding record timestamp information used for
optimistic locking
jOOQ supports optimistic locking in
UpdatableRecord.store() and
UpdatableRecord.delete() if
Settings.isExecuteWithOptimisticLocking() is enabled. |
TableField<R,? extends Number> |
Table.getRecordVersion()
A "version" field holding record version information used for optimistic
locking
jOOQ supports optimistic locking in
UpdatableRecord.store() and
UpdatableRecord.delete() if
Settings.isExecuteWithOptimisticLocking() is enabled. |
Modifier and Type | Method and Description |
---|---|
List<TableField<R,?>> |
Key.getFields()
The fields that make up the
KEY |
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type,
TableField<?,?>... keyFields)
Joins the existing table product to a new table using a foreign key.
|
<T> Optional<T> |
DSLContext.fetchOptionalValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T> T |
DSLContext.fetchValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T> List<T> |
DSLContext.fetchValues(TableField<?,T> field)
Fetch all values in a given
Table 's TableField |
TableOnConditionStep<R> |
TableOnStep.onKey(TableField<?,?>... keyFields)
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey(TableField<?,?>... keyFields)
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
Modifier and Type | Method and Description |
---|---|
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
String name,
TableField<R,?>... fields)
Factory method for foreign keys
|
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,
String name,
TableField<R,?>... fields)
Factory method for unique keys
|
protected static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Factory method for unique keys
|
<T> Optional<T> |
DefaultDSLContext.fetchOptionalValue(TableField<?,T> field) |
<T> T |
DefaultDSLContext.fetchValue(TableField<?,T> field) |
<T> List<T> |
DefaultDSLContext.fetchValues(TableField<?,T> field) |
Copyright © 2017. All Rights Reserved.