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 |
AggregateFilterStep<T>
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
interface |
AggregateFunction<T>
An aggregate function is a special field that is usually used in a
GROUP BY context. |
interface |
ArrayAggOrderByStep<T>
The SQL standard
ARRAY_AGG() function. |
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 |
Catalog
An object representing a database catalog.
|
interface |
CommonTableExpression<R extends Record>
A common table expression is a table that can be supplied to
WITH clauses. |
interface |
Constraint
A DDL constraint.
|
interface |
ConstraintFinalStep
The final step in the
Constraint construction DSL API. |
interface |
ConstraintForeignKeyOnStep
The step in the
Constraint construction DSL API that allows for
adding ON DELETE and ON UPDATE clauses. |
interface |
ConstraintTypeStep
The step in the
Constraint construction DSL API that allows for
specifying the constraint type. |
interface |
Field<T>
A field used in tables and conditions
Note that all fields qualify as
GroupField , i.e. they can always be
used in GROUP BY clauses |
interface |
FieldOrConstraint
A common base type for
Field and Constraint where DSL API accepts
both types alike. |
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
Index
A DDL index definition.
|
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 |
Routine<T>
A routine is a callable object in your RDBMS.
|
interface |
Schema
An object representing a database schema.
|
interface |
SelectField<T>
A
QueryPart to be used exclusively in SELECT
clauses. |
interface |
Sequence<T extends Number>
A type representing sequences in databases that support this.
|
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 |
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>
An intermediate type for the construction of a
JOIN clause,
where there may optionally be a join criteria added using an ON
clause (with a Condition ), or using a USING clause (with
a list of Field )
Referencing XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. |
interface |
UDT<R extends UDTRecord<R>>
UDT definition
|
interface |
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT
|
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 |
CatalogImpl
A common base class for database catalogs
This type is for JOOQ INTERNAL USE only.
|
class |
CustomField<T>
A base class for custom
Field implementations in client code. |
class |
CustomTable<R extends TableRecord<R>>
A base class for custom
Table implementations in client code. |
class |
Iif<T> |
class |
NullIf<T> |
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 |
SequenceImpl<T extends Number>
A common base class for sequences
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 |
UDTImpl<R extends UDTRecord<R>>
A common base type for UDT's
This type is for JOOQ INTERNAL USE only.
|
Copyright © 2019. All rights reserved.