Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Method and Description |
---|---|
<O extends TableRecord<O>> |
UpdatableRecord.fetchChild(ForeignKey<O,R> key)
Fetch a child record of this record, given a foreign key.
|
R |
ResultQuery.fetchOne()
Execute the query and return at most one resulting record.
|
<T> T |
ResultQuery.fetchOne(Field<?> field,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> T |
ResultQuery.fetchOne(Field<T> field)
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T,U> U |
ResultQuery.fetchOne(Field<T> field,
Converter<? super T,? extends U> converter)
Execute the query and return at most one resulting value for a
field from the generated result.
|
Object |
ResultQuery.fetchOne(int fieldIndex)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<T> T |
ResultQuery.fetchOne(int fieldIndex,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchOne(int fieldIndex,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
Object |
ResultQuery.fetchOne(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<E> E |
ResultQuery.fetchOne(RecordMapper<? super R,E> mapper)
Execute the query and return at most one resulting value into a
custom mapper callback.
|
<R extends Record> |
DSLContext.fetchOne(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Record |
DSLContext.fetchOne(ResultSet rs)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Class<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
DataType<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Field<?>... fields)
|
Record |
DSLContext.fetchOne(SQL sql)
Execute a new query holding plain SQL.
|
Object |
ResultQuery.fetchOne(String fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL.
|
<T> T |
ResultQuery.fetchOne(String fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(String fieldName,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
DSLContext.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
Object[] |
ResultQuery.fetchOneArray()
Execute the query and return at most one resulting record as an array
You can access data like this
query.fetchOneArray()[fieldIndex] |
<E> E |
ResultQuery.fetchOneInto(Class<? extends E> type)
Map resulting records onto a custom type.
|
<Z extends Record> |
ResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.
|
Map<String,Object> |
ResultQuery.fetchOneMap()
Execute the query and return at most one resulting record as a name/value
map.
|
Optional<R> |
ResultQuery.fetchOptional()
Execute the query and return at most one resulting record.
|
<T> Optional<T> |
ResultQuery.fetchOptional(Field<?> field,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> Optional<T> |
ResultQuery.fetchOptional(Field<T> field)
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T,U> Optional<U> |
ResultQuery.fetchOptional(Field<T> field,
Converter<? super T,? extends U> converter)
Execute the query and return at most one resulting value for a
field from the generated result.
|
Optional<?> |
ResultQuery.fetchOptional(int fieldIndex)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<T> Optional<T> |
ResultQuery.fetchOptional(int fieldIndex,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> Optional<U> |
ResultQuery.fetchOptional(int fieldIndex,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field index from the generated result.
|
Optional<?> |
ResultQuery.fetchOptional(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> Optional<T> |
ResultQuery.fetchOptional(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<E> Optional<E> |
ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper)
Execute the query and return at most one resulting value into a
custom mapper callback.
|
<R extends Record> |
DSLContext.fetchOptional(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Class<?>... types)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
DataType<?>... types)
|
Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Field<?>... fields)
|
Optional<Record> |
DSLContext.fetchOptional(SQL sql)
Execute a new query holding plain SQL.
|
Optional<?> |
ResultQuery.fetchOptional(String fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Optional<Record> |
DSLContext.fetchOptional(String sql)
Execute a new query holding plain SQL.
|
<T> Optional<T> |
ResultQuery.fetchOptional(String fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> Optional<U> |
ResultQuery.fetchOptional(String fieldName,
Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
DSLContext.fetchOptional(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchOptional(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
Optional<Object[]> |
ResultQuery.fetchOptionalArray()
Execute the query and return at most one resulting record as an array.
|
<E> Optional<E> |
ResultQuery.fetchOptionalInto(Class<? extends E> type)
Map resulting records onto a custom type.
|
<Z extends Record> |
ResultQuery.fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record.
|
Optional<Map<String,Object>> |
ResultQuery.fetchOptionalMap()
Execute the query and return at most one resulting record as a name/value
map.
|
<T,R extends Record1<T>> |
DSLContext.fetchOptionalValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Optional<?> |
DSLContext.fetchOptionalValue(ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
DSLContext.fetchOptionalValue(ResultSet rs,
Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
DSLContext.fetchOptionalValue(ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
DSLContext.fetchOptionalValue(ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
Optional<?> |
DSLContext.fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<?> |
DSLContext.fetchOptionalValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> Optional<T> |
DSLContext.fetchOptionalValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T,R extends Record1<T>> |
DSLContext.fetchValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Object |
DSLContext.fetchValue(ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
Object |
DSLContext.fetchValue(SQL sql)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> T |
DSLContext.fetchValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Copyright © 2017. All Rights Reserved.