Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Method and Description |
---|---|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.sql.ResultSet rs)
Fetch a record from a JDBC
ResultSet and transform it to a jOOQ
Record . |
R |
ResultQuery.fetchSingle()
Execute the query and return exactly one resulting record.
|
<T> T |
ResultQuery.fetchSingle(Field<?> field,
java.lang.Class<? extends T> type)
Execute the query and return exactly one resulting value for a
field from the generated result.
|
<T> T |
ResultQuery.fetchSingle(Field<T> field)
Execute the query and return exactly one resulting value for a field from
the generated result.
|
<T,U> U |
ResultQuery.fetchSingle(Field<T> field,
Converter<? super T,? extends U> converter)
Execute the query and return exactly one resulting value for a
field from the generated result.
|
java.lang.Object |
ResultQuery.fetchSingle(int fieldIndex)
Execute the query and return exactly one resulting value for a
field index from the generated result.
|
<T> T |
ResultQuery.fetchSingle(int fieldIndex,
java.lang.Class<? extends T> type)
Execute the query and return exactly one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchSingle(int fieldIndex,
Converter<?,? extends U> converter)
Execute the query and return exactly one resulting value for a
field index from the generated result.
|
java.lang.Object |
ResultQuery.fetchSingle(Name fieldName)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchSingle(Name fieldName,
java.lang.Class<? extends T> type)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchSingle(Name fieldName,
Converter<?,? extends U> converter)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<E> E |
ResultQuery.fetchSingle(RecordMapper<? super R,E> mapper)
Execute the query and return exactly one resulting value into a
custom mapper callback.
|
<R extends Record> |
DSLContext.fetchSingle(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
java.lang.Class<?>... types)
Fetch a record from a JDBC
ResultSet and transform it to a jOOQ
Record . |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
DataType<?>... types)
Fetch a record from a JDBC
ResultSet and transform it to a jOOQ
Record . |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
Field<?>... fields)
Fetch a record from a JDBC
ResultSet and transform it to a jOOQ
Record . |
Record |
DSLContext.fetchSingle(SQL sql)
Execute a new query holding plain SQL.
|
java.lang.Object |
ResultQuery.fetchSingle(java.lang.String fieldName)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchSingle(java.lang.String sql)
Execute a new query holding plain SQL.
|
<T> T |
ResultQuery.fetchSingle(java.lang.String fieldName,
java.lang.Class<? extends T> type)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchSingle(java.lang.String fieldName,
Converter<?,? extends U> converter)
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchSingle(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
DSLContext.fetchSingle(Table<R> table)
Execute and return exactly one record for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchSingle(Table<R> table,
Condition condition)
Execute and return exactly one record for
SELECT * FROM [table] WHERE [condition] . |
java.lang.Object[] |
ResultQuery.fetchSingleArray()
Execute the query and return exactly one resulting record as an array
You can access data like this
query.fetchSingleArray()[fieldIndex] |
<E> E |
ResultQuery.fetchSingleInto(java.lang.Class<? extends E> type)
Map resulting records onto a custom type.
|
<Z extends Record> |
ResultQuery.fetchSingleInto(Table<Z> table)
Map resulting records onto a custom record.
|
java.util.Map<java.lang.String,java.lang.Object> |
ResultQuery.fetchSingleMap()
Execute the query and return exactly one resulting record as a name/value
map.
|
void |
UpdatableRecord.refresh(java.util.Collection<? extends Field<?>> fields)
Refresh parts of this record from the database.
|
void |
UpdatableRecord.refresh(Field<?>... fields)
Refresh parts of this record from the database.
|
Copyright © 2018. All Rights Reserved.