| 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 |
AggregateFunction<T>
An aggregate function is a special field that is usually used in a
GROUP BY context. |
interface |
AliasProvider<Z extends AliasProvider<Z>>
Deprecated.
- 2.6.0 [#1800] - This marker interface will be removed in future
versions of jOOQ
|
interface |
ArrayRecord<E>
A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally
providing some convenience methods
|
interface |
Attachable
An object in jOOQ that can have an underlying
Configuration attached
or detached. |
interface |
AttachableInternal
Base functionality declaration for all
Attachables
This interface is for JOOQ INTERNAL USE only. |
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 |
Condition
A condition to be used in a query's where part
|
interface |
Delete<R extends Record>
A
Query that can delete data in the database. |
interface |
DeleteConditionStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
DeleteFinalStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
DeleteQuery<R extends Record>
A query used for deletion of data
|
interface |
DeleteWhereStep<R extends Record>
This type is used for the
Delete's DSL API. |
interface |
Field<T>
A field used in tables and conditions
|
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
Insert<R extends Record>
A
Query that can insert data in the database. |
interface |
InsertFinalStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertOnDuplicateStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertQuery<R extends Record>
A query for data insertion
|
interface |
InsertResultStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
InsertSetMoreStep<R extends Record>
This type is used for the
Insert's alternative DSL API. |
interface |
InsertValuesStep<R extends Record>
This type is used for the
Insert's DSL API. |
interface |
Merge<R extends Record>
A
Query that can merge data in the database. |
interface |
MergeFinalStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeMatchedDeleteStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeMatchedSetMoreStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeMatchedStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeMatchedWhereStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeNotMatchedStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeNotMatchedWhereStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
MergeOnConditionStep<R extends Record>
This type is used for the
Merge's DSL API. |
interface |
Name
A SQL identifier
QueryPart
A Name is a QueryPart that renders a SQL identifier
according to the Settings.getRenderNameStyle(). |
interface |
NamedQueryPart
Deprecated.
- 2.6.0 [#1869] - This marker interface does not have enough
momentum to be exposed in the public API. It will be removed in
the future.
|
interface |
NamedTypeProviderQueryPart<T>
Deprecated.
- 2.6.0 [#1870] - This marker interface does not have enough
momentum to be exposed in the public API. It will be removed in
the future.
|
interface |
Package
A container for stored procedures and functions
This is only supported in the
SQLDialect.ORACLE dialect |
interface |
Param<T>
A named parameter and/or bind value.
|
interface |
Parameter<T>
A parameter to a stored procedure or function.
|
interface |
Query
Any query
|
interface |
QueryPart
The common base type for all objects that can be used for query composition.
|
interface |
QueryPartInternal
Base functionality declaration for all query objects
This interface is for JOOQ INTERNAL USE only.
|
interface |
Record
A wrapper for database result records returned by
|
interface |
Result<R extends Record>
A wrapper for database results returned by
|
interface |
ResultQuery<R extends Record>
A query that can return results.
|
interface |
Routine<T>
A routine is a callable object in your RDBMS.
|
interface |
Row
A model type for a row value expression.
|
interface |
Row1<T1>
A model type for a row value expression with degree
1
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases. |
interface |
Row2<T1,T2>
A model type for a row value expression with degree
2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases. |
interface |
Row3<T1,T2,T3>
A model type for a row value expression with degree
3
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
Row4<T1,T2,T3,T4>
A model type for a row value expression with degree
4
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
Row5<T1,T2,T3,T4,T5>
A model type for a row value expression with degree
5
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
Row6<T1,T2,T3,T4,T5,T6>
A model type for a row value expression with degree
6
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
Row7<T1,T2,T3,T4,T5,T6,T7>
A model type for a row value expression with degree
7
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
Row8<T1,T2,T3,T4,T5,T6,T7,T8>
A model type for a row value expression with degree
8
Note: Not all databases support row value expressions, but many row value expression operations can be
simulated on all databases. |
interface |
RowN
A model type for a row value expression with degree
N > 8
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases. |
interface |
Schema
An entity representing a database schema
|
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 |
SortField<T>
|
interface |
Store<E>
Deprecated.
- 2.6.0 [#1840] - This type provides no useful abstraction over
Record and ArrayRecord and will be removed in the
future. Do not reference it directly. |
interface |
StoreQuery<R extends Record>
A query storing objects to the database.
|
interface |
Table<R extends Record>
A table to be used in queries
|
interface |
TableField<R extends Record,T>
A field contained in a table
|
interface |
TableLike<R extends Record>
An object that can behave like a table (a table-like object)
|
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 |
TableRecord<R extends TableRecord<R>>
A record originating from a single table
|
interface |
Truncate<R extends Record>
A
Query that can truncate a table in the database. |
interface |
Type<R extends Record>
Deprecated.
|
interface |
UDT<R extends UDTRecord<R>>
UDT definition
|
interface |
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT
|
interface |
UDTRecord<R extends UDTRecord<R>>
An object holding data of a UDT
|
interface |
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again.
|
interface |
UpdatableTable<R extends Record>
A common interface for tables whose records can be stored back to the
database again.
|
interface |
Update<R extends Record>
A
Query that can update data in the database. |
interface |
UpdateConditionStep<R extends Record>
This type is used for the
Update's DSL API. |
interface |
UpdateFinalStep<R extends Record>
This type is used for the
Update's DSL API. |
interface |
UpdateQuery<R extends Record>
A query for data updating
|
interface |
UpdateSetMoreStep<R extends Record>
This type is used for the
Update's DSL API. |
interface |
UpdateWhereStep<R extends Record>
This type is used for the
Update's DSL API. |
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 | Class and Description |
|---|---|
class |
AbstractRoutine<T>
A common base class for stored procedures
This type is for JOOQ INTERNAL USE only.
|
class |
ArrayRecordImpl<T>
A common base class for Oracle ARRAY types
This type is for JOOQ INTERNAL USE only.
|
class |
CustomCondition
A base class for custom
Condition implementations in client code. |
class |
CustomField<T>
A base class for custom
Field implementations in client code. |
class |
CustomRecord<R extends TableRecord<R>>
A base class for custom
TableRecord implementations in client code. |
class |
CustomTable<R extends TableRecord<R>>
A base class for custom
Table implementations in client code. |
class |
PackageImpl
A default implementation for packages (containers of stored procedures and
functions)
Currently, this is only supported for the
SQLDialect.ORACLE dialect. |
class |
SchemaImpl
A common base class for database schemata
This type is for JOOQ INTERNAL USE only.
|
class |
TableImpl<R extends Record>
A common base type for tables
This type is for JOOQ INTERNAL USE only.
|
class |
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single table
This type is for JOOQ INTERNAL USE only.
|
class |
UDTImpl<R extends UDTRecord<R>>
A common base type for UDT's
This type is for JOOQ INTERNAL USE only.
|
class |
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDT
This type is for JOOQ INTERNAL USE only.
|
class |
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary key
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.
|
Copyright © 2013. All Rights Reserved.