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 |
AlterSequenceFinalStep
A
Query that can alter sequences. |
interface |
AlterTableDropStep
The step in the
ALTER TABLE DSL used to DROP
columns. |
interface |
AlterTableFinalStep
The final step in the
ALTER TABLE DSL. |
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 |
Condition
A condition to be used in a query's where part
|
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 |
CreateIndexFinalStep
A
Query that can create indexes. |
interface |
CreateSequenceFinalStep
A
Query that can create sequences. |
interface |
CreateTableColumnStep
A
Query that can create tables. |
interface |
CreateTableConstraintStep
A
Query that can create tables. |
interface |
CreateTableFinalStep
A
Query that can create tables. |
interface |
CreateTableOnCommitStep
A
Query that can create tables. |
interface |
CreateViewFinalStep
A
Query that can create views. |
interface |
DDLQuery
A marker interface for all DDL queries.
|
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 |
DeleteResultStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
DeleteWhereStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
DerivedColumnList
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList1
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList10
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList11
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList12
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList13
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList14
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList15
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList16
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList17
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList18
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList19
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList2
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList20
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList21
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList22
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList3
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList4
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList5
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList6
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList7
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList8
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DerivedColumnList9
A
DerivedColumnList is a name of a table expression with
optional derived column list. |
interface |
DropIndexFinalStep
A
Query that can create indexes. |
interface |
DropIndexOnStep
A
Query that can create indexes. |
interface |
DropSequenceFinalStep
A
Query that can drop sequences. |
interface |
DropTableFinalStep
The final step in the
DROP TABLE DSL. |
interface |
DropTableStep
The step in the
DROP TABLE DSL used to specify DROP
behaviour. |
interface |
DropViewFinalStep
The final step in the
DROP VIEW DSL. |
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 |
FieldOrRow
|
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupField
A
QueryPart to be used exclusively in GROUP BY
clauses |
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 |
InsertReturningStep<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 |
InsertValuesStep1<R extends Record,T1>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep2<R extends Record,T1,T2>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep3<R extends Record,T1,T2,T3>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the
Insert 's DSL API. |
interface |
InsertValuesStepN<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
Keyword
A SQL keyword
QueryPart . |
interface |
Link
A database link reference.
|
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 . |
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 |
QuantifiedSelect<R extends Record>
A participant of a quantified comparison predicate
A
QuantifiedSelect models the right hand side of a quantified
comparison predicate. |
interface |
Query
Any query
|
interface |
QueryPartInternal
Base functionality declaration for all query objects
This interface is for JOOQ INTERNAL USE only.
|
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 . |
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 |
Schema
An object representing a database schema.
|
interface |
Select<R extends Record>
|
interface |
SelectConditionStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
interface |
SelectDistinctOnStep<R extends Record>
|
interface |
SelectField<T>
A
QueryPart to be used exclusively in SELECT
clauses |
interface |
SelectFinalStep<R extends Record>
|
interface |
SelectForUpdateOfStep<R extends Record>
|
interface |
SelectForUpdateStep<R extends Record>
|
interface |
SelectForUpdateWaitStep<R extends Record>
|
interface |
SelectFromStep<R extends Record>
|
interface |
SelectGroupByStep<R extends Record>
|
interface |
SelectHavingConditionStep<R extends Record>
|
interface |
SelectHavingStep<R extends Record>
|
interface |
SelectIntoStep<R extends Record>
|
interface |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitAfterOffsetStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
interface |
SelectOptionStep<R extends Record>
|
interface |
SelectOrderByStep<R extends Record>
|
interface |
SelectQuery<R extends Record>
A query for data selection
|
interface |
SelectSeekLimitStep<R extends Record>
|
interface |
SelectSeekStep1<R extends Record,T1>
|
interface |
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
|
interface |
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
|
interface |
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
|
interface |
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
|
interface |
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
|
interface |
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
|
interface |
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
|
interface |
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
|
interface |
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
|
interface |
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
|
interface |
SelectSeekStep2<R extends Record,T1,T2>
|
interface |
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
|
interface |
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
|
interface |
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
|
interface |
SelectSeekStep3<R extends Record,T1,T2,T3>
|
interface |
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
|
interface |
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
|
interface |
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
|
interface |
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
|
interface |
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
|
interface |
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
|
interface |
SelectSeekStepN<R extends Record>
|
interface |
SelectSelectStep<R extends Record>
|
interface |
SelectStartWithStep<R extends Record>
|
interface |
SelectUnionStep<R extends Record>
|
interface |
SelectWhereStep<R extends Record>
|
interface |
SelectWindowStep<R extends Record>
|
interface |
Sequence<T extends Number>
A type representing sequences in databases that support this.
|
interface |
SortField<T>
|
interface |
SQL
A plain SQL
QueryPart . |
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<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>
|
interface |
Truncate<R extends Record>
A
Query that can truncate a table in the database. |
interface |
TruncateCascadeStep<R extends Record>
A
Query that can truncate a table in the database. |
interface |
TruncateFinalStep<R extends Record>
A
Query that can truncate a table in the database. |
interface |
TruncateIdentityStep<R extends Record>
A
Query that can truncate a table in the database. |
interface |
UDT<R extends UDTRecord<R>>
UDT definition
|
interface |
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT
|
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 |
UpdateFromStep<R extends Record>
This type is used for the
Update 's DSL API. |
interface |
UpdateQuery<R extends Record>
A query for data updating
|
interface |
UpdateResultStep<R extends Record>
This type is used for the
Update 's DSL API. |
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 |
WindowDefinition
A window definition.
|
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.
|
interface |
WindowSpecification
A window specification.
|
interface |
WindowSpecificationFinalStep
An intermediate step in the construction of a
WindowSpecification . |
interface |
WindowSpecificationOrderByStep
An intermediate step in the construction of a
WindowSpecification . |
interface |
WindowSpecificationPartitionByStep
An intermediate step in the construction of a
WindowSpecification . |
interface |
WindowSpecificationRowsStep
An intermediate step in the construction of a
WindowSpecification . |
interface |
WithStep
|
Modifier and Type | Method and Description |
---|---|
QueryPart |
VisitContext.queryPart()
The most recent
QueryPart that was encountered through
Context.visit(QueryPart) . |
QueryPart[] |
VisitContext.queryParts()
A path of
QueryPart s going through the visiting tree. |
Modifier and Type | Method and Description |
---|---|
UpdateConditionStep<R> |
UpdateConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.and(String sql,
QueryPart... parts)
Combine this condition with another one using the
Operator.AND
operator. |
BindContext |
BindContext.bind(QueryPart part)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
BindContext |
BindContext.bind(QueryPart[] parts)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
int |
DSLContext.bind(QueryPart part,
PreparedStatement stmt)
Deprecated.
- [#2662] - 3.2.0 - Do not reuse this method. It will be
removed with jOOQ 4.0
|
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql,
QueryPart... parts)
Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql,
QueryPart... parts)
Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Table<Record> |
Table.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
QueryPart... parts)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, QueryPart...) |
int |
DSLContext.execute(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
List<Object> |
DSLContext.extractBindValues(QueryPart part)
Retrieve the bind values that will be bound by a given
QueryPart . |
Param<?> |
DSLContext.extractParam(QueryPart part,
String name)
Get a named parameter from a
QueryPart , provided its name. |
Map<String,Param<?>> |
DSLContext.extractParams(QueryPart part)
Get a
Map of named parameters. |
Result<Record> |
DSLContext.fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage . |
Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Results |
DSLContext.fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Record |
DSLContext.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Object |
DSLContext.fetchValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql,
QueryPart... parts)
Add a
FILTER clause to the aggregate function. |
UpdateWhereStep<R> |
UpdateFromStep.from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
TableOnStep<Record> |
Table.fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
QueryPart... parts)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, QueryPart...) |
SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql,
QueryPart... parts)
Add a
HAVING clause to the query. |
TableOnStep<Record> |
Table.innerJoin(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
TableOnStep<Record> |
Table.join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(String sql,
QueryPart... parts)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql,
QueryPart... parts)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql,
QueryPart... parts)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, QueryPart...) |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, QueryPart...) |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, QueryPart...) |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, QueryPart...) |
TableOnConditionStep<R> |
TableOnStep.on(String sql,
QueryPart... parts)
Add an
ON clause to the JOIN . |
SelectOnConditionStep<R> |
SelectOnStep.on(String sql,
QueryPart... parts)
Add an
ON clause to the previous JOIN . |
MergeOnConditionStep<R> |
MergeOnStep.on(String sql,
QueryPart... parts)
Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
DivideByOnConditionStep |
DivideByOnStep.on(String sql,
QueryPart... parts)
Add a division condition to the
DIVIDE BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
UpdateConditionStep<R> |
UpdateConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
TableOnConditionStep<R> |
TableOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Condition |
Condition.or(String sql,
QueryPart... parts)
Combine this condition with another one using the
Operator.OR
operator. |
Table<Record> |
Table.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Query |
DSLContext.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
void |
VisitContext.queryPart(QueryPart part)
Replace the most recent
QueryPart that was encountered through
Context.visit(QueryPart) . |
String |
RenderContext.render(QueryPart part)
Render a query part in a new context derived from this one.
|
String |
DSLContext.render(QueryPart part)
Render a QueryPart in the context of this
DSLContext . |
String |
Context.render(QueryPart part)
Render a query part in a new context derived from this one.
|
String |
DSLContext.renderInlined(QueryPart part)
Render a QueryPart in the context of this
DSLContext , inlining all bind
variables. |
String |
DSLContext.renderNamedOrInlinedParams(QueryPart part)
Render a QueryPart in the context of this
DSLContext , rendering bind
variables as named parameters, or inlined parameters if they have no name. |
String |
DSLContext.renderNamedParams(QueryPart part)
Render a QueryPart in the context of this
DSLContext , rendering bind
variables as named parameters. |
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
TablePartitionByStep<Record> |
Table.rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql,
QueryPart... parts)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, QueryPart...) . |
TablePartitionByStep<Record> |
Table.rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql,
QueryPart... parts)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, QueryPart...) |
RenderContext |
RenderContext.sql(QueryPart part)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql,
QueryPart... parts)
Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause. |
TableOnStep<Record> |
Table.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
C |
Context.visit(QueryPart part)
Visit a
QueryPart in the current Context . |
UpdateConditionStep<R> |
UpdateWhereStep.where(String sql,
QueryPart... parts)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
SelectConditionStep<R> |
SelectWhereStep.where(String sql,
QueryPart... parts)
Add a
WHERE clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.where(String sql,
QueryPart... parts)
Add conditions to the query.
|
Modifier and Type | Method and Description |
---|---|
BindContext |
BindContext.bind(Collection<? extends QueryPart> parts)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
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 |
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 |
CustomQueryPart
A base class for custom
QueryPart implementations in client code. |
class |
CustomTable<R extends TableRecord<R>>
A base class for custom
Table implementations in client code. |
class |
KeywordImpl
A default
Keyword implementation. |
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.
|
Modifier and Type | Method and Description |
---|---|
static QueryPart |
DSL.list(Collection<? extends QueryPart> parts)
Compose a list of
QueryParts into a new
QueryPart , with individual parts being comma-separated. |
static QueryPart |
DSL.list(QueryPart... parts)
Compose a list of
QueryParts into a new
QueryPart , with individual parts being comma-separated. |
static QueryPart |
DSL.queryPart(String sql)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String) instead |
static QueryPart |
DSL.queryPart(String sql,
Object... bindings)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, Object...) instead |
static QueryPart |
DSL.queryPart(String sql,
QueryPart... parts)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, QueryPart...) instead |
Modifier and Type | Method and Description |
---|---|
int |
DefaultDSLContext.bind(QueryPart part,
PreparedStatement stmt)
Deprecated.
|
static Condition |
DSL.condition(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
int |
DefaultDSLContext.execute(String sql,
QueryPart... parts) |
List<Object> |
DefaultDSLContext.extractBindValues(QueryPart part) |
Param<?> |
DefaultDSLContext.extractParam(QueryPart part,
String name) |
Map<String,Param<?>> |
DefaultDSLContext.extractParams(QueryPart part) |
Result<Record> |
DefaultDSLContext.fetch(String sql,
QueryPart... parts) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(Executor executor,
String sql,
QueryPart... parts) |
CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(String sql,
QueryPart... parts) |
Cursor<Record> |
DefaultDSLContext.fetchLazy(String sql,
QueryPart... parts) |
Results |
DefaultDSLContext.fetchMany(String sql,
QueryPart... parts) |
Record |
DefaultDSLContext.fetchOne(String sql,
QueryPart... parts) |
Optional<Record> |
DefaultDSLContext.fetchOptional(String sql,
QueryPart... parts) |
Optional<?> |
DefaultDSLContext.fetchOptionalValue(String sql,
QueryPart... parts) |
java.util.stream.Stream<Record> |
DefaultDSLContext.fetchStream(String sql,
QueryPart... parts) |
Object |
DefaultDSLContext.fetchValue(String sql,
QueryPart... parts) |
List<?> |
DefaultDSLContext.fetchValues(String sql,
QueryPart... parts) |
static <T> Field<T> |
DSL.field(String sql,
Class<T> type,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static <T> Field<T> |
DSL.field(String sql,
DataType<T> type,
QueryPart... parts)
Create a "plain SQL" field.
|
static Field<Object> |
DSL.field(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary SQL elements.
|
static QueryPart |
DSL.list(QueryPart... parts)
Compose a list of
QueryParts into a new
QueryPart , with individual parts being comma-separated. |
static Query |
DSL.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
Query |
DefaultDSLContext.query(String sql,
QueryPart... parts) |
static QueryPart |
DSL.queryPart(String sql,
QueryPart... parts)
Deprecated.
- 3.6.0 - [#3854] - Use
DSL.sql(String, QueryPart...) instead |
String |
DefaultDSLContext.render(QueryPart part) |
String |
DefaultDSLContext.renderInlined(QueryPart part) |
String |
DefaultDSLContext.renderNamedOrInlinedParams(QueryPart part) |
String |
DefaultDSLContext.renderNamedParams(QueryPart part) |
static ResultQuery<Record> |
DSL.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DefaultDSLContext.resultQuery(String sql,
QueryPart... parts) |
static SQL |
DSL.sql(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary expressions.
|
static Table<Record> |
DSL.table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
Modifier and Type | Method and Description |
---|---|
static QueryPart |
DSL.list(Collection<? extends QueryPart> parts)
Compose a list of
QueryParts into a new
QueryPart , with individual parts being comma-separated. |
Copyright © 2017. All Rights Reserved.