Optional<Record> |
DSLContext.fetchOptional(ResultSet rs) |
|
Record |
DSLContext.fetchSingle(String sql) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(ResultSet rs,
Class<?>... types) |
|
Record |
DSLContext.fetchSingle(ResultSet rs,
DataType<?>... types) |
|
Record |
DSLContext.fetchSingle(ResultSet rs,
Field<?>... fields) |
|
<R extends Record> R |
DSLContext.fetchSingle(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a record.
|
Record |
DSLContext.fetchSingle(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record> R |
DSLContext.fetchSingle(Table<R> table) |
Execute and return exactly one record for
|
<R extends Record> R |
DSLContext.fetchSingle(Table<R> table,
Collection<? extends Condition> conditions) |
Execute and return exactly one record for
|
<R extends Record> R |
DSLContext.fetchSingle(Table<R> table,
Condition condition) |
Execute and return exactly one record for
|
<R extends Record> R |
DSLContext.fetchSingle(Table<R> table,
Condition... conditions) |
Execute and return exactly one record for
|
R |
ResultQuery.fetchSingle() |
Execute the query and return exactly one resulting record.
|
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,
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.
|
Object |
ResultQuery.fetchSingle(String fieldName) |
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchSingle(String fieldName,
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(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchSingle(Field<?> field,
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.
|
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,
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.
|
Object[] |
ResultQuery.fetchSingleArray() |
Execute the query and return exactly one resulting record as an array
|
<E> E |
ResultQuery.fetchSingleInto(Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record> Z |
ResultQuery.fetchSingleInto(Table<Z> table) |
Map resulting records onto a custom record.
|
Map<String,Object> |
ResultQuery.fetchSingleMap() |
Execute the query and return exactly one resulting record as a name/value
map.
|
void |
UpdatableRecord.refresh(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.
|