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 |
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 |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
Param<T>
A named parameter and/or bind value.
|
interface |
Row
A model type for a row value expression.
|
interface |
Row1<T1>
A model type for a row value expression with degree
1 . |
interface |
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
A model type for a row value expression with degree
10 . |
interface |
Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
A model type for a row value expression with degree
11 . |
interface |
Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
A model type for a row value expression with degree
12 . |
interface |
Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
A model type for a row value expression with degree
13 . |
interface |
Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
A model type for a row value expression with degree
14 . |
interface |
Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
A model type for a row value expression with degree
15 . |
interface |
Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
A model type for a row value expression with degree
16 . |
interface |
Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
A model type for a row value expression with degree
17 . |
interface |
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
A model type for a row value expression with degree
18 . |
interface |
Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
A model type for a row value expression with degree
19 . |
interface |
Row2<T1,T2>
A model type for a row value expression with degree
2 . |
interface |
Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
A model type for a row value expression with degree
20 . |
interface |
Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
A model type for a row value expression with degree
21 . |
interface |
Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
A model type for a row value expression with degree
22 . |
interface |
Row3<T1,T2,T3>
A model type for a row value expression with degree
3 . |
interface |
Row4<T1,T2,T3,T4>
A model type for a row value expression with degree
4 . |
interface |
Row5<T1,T2,T3,T4,T5>
A model type for a row value expression with degree
5 . |
interface |
Row6<T1,T2,T3,T4,T5,T6>
A model type for a row value expression with degree
6 . |
interface |
Row7<T1,T2,T3,T4,T5,T6,T7>
A model type for a row value expression with degree
7 . |
interface |
Row8<T1,T2,T3,T4,T5,T6,T7,T8>
A model type for a row value expression with degree
8 . |
interface |
Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
A model type for a row value expression with degree
9 . |
interface |
RowN
A model type for a row value expression with degree
N > 22 . |
interface |
TableField<R extends Record,T>
A field contained in a table
|
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 |
CustomField<T>
A base class for custom
Field implementations in client code. |
class |
Iif<T> |
class |
NullIf<T> |
Modifier and Type | Method and Description |
---|---|
static GroupField |
DSL.cube(FieldOrRow... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.
|
static GroupField |
DSL.rollup(FieldOrRow... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
Copyright © 2019. All rights reserved.