Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Interface and Description |
---|---|
interface |
Select<R extends Record>
|
interface |
SelectConditionStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
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 |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
interface |
SelectOrderByStep<R extends Record>
|
interface |
SelectQuery<R extends Record>
A query for data selection
|
interface |
SelectSelectStep<R extends Record>
|
interface |
SelectStartWithStep<R extends Record>
|
interface |
SelectWhereStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
ResultQuery<R> |
ResultQuery.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
Query.keepStatement(boolean) , the underlying
PreparedStatement will be closed automatically in order for
new bind values to have an effect. |
ResultQuery<R> |
ResultQuery.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
Query.keepStatement(boolean) , the underlying
PreparedStatement will be closed automatically in order for
new bind values to have an effect. |
ResultQuery<R> |
ResultQuery.intern(Field<?>... fields)
Specify a set of fields whose values should be interned.
|
ResultQuery<R> |
ResultQuery.intern(int... fieldIndexes)
Specify a set of field indexes whose values should be interned.
|
ResultQuery<R> |
ResultQuery.intern(String... fieldNames)
Specify a set of field names whose values should be interned.
|
ResultQuery<R> |
ResultQuery.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. |
ResultQuery<R> |
ResultQuery.maxRows(int rows)
Specify the maximum number of rows returned by the underlying
Statement
This is not the same as setting a LIMIT .. |
ResultQuery<R> |
ResultQuery.queryTimeout(int timeout)
Specify the query timeout for the underlying JDBC
Statement |
ResultQuery<Record> |
DSLContext.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
DSLContext.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
Modifier and Type | Method and Description |
---|---|
<R extends Record> |
DSLContext.fetch(ResultQuery<R> query)
Execute a
ResultQuery in the context of this executor and return
results. |
<R extends Record> |
DSLContext.fetchLazy(ResultQuery<R> query)
Execute a
ResultQuery in the context of this executor and return
a cursor. |
<R extends Record> |
DSLContext.fetchMany(ResultQuery<R> query)
Execute a
ResultQuery in the context of this executor and return
a cursor. |
<R extends Record> |
DSLContext.fetchOne(ResultQuery<R> query)
Execute a
ResultQuery in the context of this executor and return
a record. |
Copyright © 2013. All Rights Reserved.