| 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 |
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 |
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 |
ResultQuery<R extends Record>
A query that can return results.
|
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 |
StoreQuery<R extends Record>
A query storing objects to the database.
|
interface |
Truncate<R extends Record>
A
Query that can truncate a table in the database. |
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. |
| Modifier and Type | Method and Description |
|---|---|
Query[] |
ExecuteContext.batchQueries()
The jOOQ
Query objects that are being executed in batch mode, or
empty if the query is unknown or if there was no jOOQ Query
If a single Query is executed in non-batch mode, this will
return an array of length 1, containing that
Query |
Query |
Query.bind(int index,
Object value)
Bind a new value to an indexed parameter
[#1886] If the bind value at
index is inlined (
Param.isInline()) or if this query was created with
StatementType.STATIC_STATEMENT and there is an underlying
PreparedStatement kept open because of
keepStatement(boolean), the underlying
PreparedStatement will be closed automatically in order for
new bind values to have an effect. |
Query |
Query.bind(String param,
Object value)
Bind a new value to a named parameter
[#1886] If the bind value with name
param is inlined (
Param.isInline()) or if this query was created with
StatementType.STATIC_STATEMENT and there is an underlying
PreparedStatement kept open because of
keepStatement(boolean), the underlying
PreparedStatement will be closed automatically in order for
new bind values to have an effect. |
Query |
Query.keepStatement(boolean keepStatement)
Keep the query's underlying statement open after execution
This indicates to jOOQ that the query's underlying
Statement or
PreparedStatement should be kept open after execution. |
Query |
LoaderError.query()
The query whose execution failed
|
Query |
ExecuteContext.query()
The jOOQ
Query that is being executed or null if the
query is unknown, if it is a batch query, or if there was no jOOQ
Query |
Query |
FactoryOperations.query(String sql)
Create a new query holding plain SQL.
|
Query |
FactoryOperations.query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
Query |
FactoryOperations.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
Query |
Query.queryTimeout(int timeout)
Specify the query timeout for the underlying JDBC
Statement |
| Modifier and Type | Method and Description |
|---|---|
Batch |
FactoryOperations.batch(Query... queries)
Execute a set of queries in batch mode (without bind values).
|
BatchBindStep |
FactoryOperations.batch(Query query)
Execute a set of queries in batch mode (with bind values).
|
| Modifier and Type | Method and Description |
|---|---|
Batch |
FactoryOperations.batch(Collection<? extends Query> queries)
Execute a set of queries in batch mode (without bind values).
|
| Modifier and Type | Method and Description |
|---|---|
Query |
FactoryProxy.query(String sql)
Deprecated.
|
Query |
Factory.query(String sql)
Create a new query holding plain SQL.
|
Query |
FactoryProxy.query(String sql,
Object... bindings)
Deprecated.
|
Query |
Factory.query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
Query |
FactoryProxy.query(String sql,
QueryPart... parts)
Deprecated.
|
Query |
Factory.query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
| Modifier and Type | Method and Description |
|---|---|
Batch |
FactoryProxy.batch(Query... queries)
Deprecated.
|
Batch |
Factory.batch(Query... queries)
Execute a set of queries in batch mode (without bind values).
|
BatchBindStep |
FactoryProxy.batch(Query query)
Deprecated.
|
BatchBindStep |
Factory.batch(Query query)
Execute a set of queries in batch mode (with bind values).
|
| Modifier and Type | Method and Description |
|---|---|
Batch |
FactoryProxy.batch(Collection<? extends Query> queries)
Deprecated.
|
Batch |
Factory.batch(Collection<? extends Query> queries)
Execute a set of queries in batch mode (without bind values).
|
Copyright © 2013. All Rights Reserved.