Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.exception |
The
org.jooq.exception package contains jOOQ's exceptions. |
Modifier and Type | Method and Description |
---|---|
<K> Map<K,R> |
ResultQuery.fetchMap(Class<? extends K> keyType)
Execute the query and return a
Map with results grouped by the
given key entity. |
<K,V> Map<K,V> |
ResultQuery.fetchMap(Class<? extends K> keyType,
Class<? extends V> valueType)
Execute the query and return a
Map with results grouped by the
given key entity and mapped into the given entity type. |
<K,V> Map<K,V> |
ResultQuery.fetchMap(Class<? extends K> keyType,
RecordMapper<? super R,V> valueMapper)
Execute the query and return a
Map with results grouped by the
given key entity and mapped into the given entity type. |
<K> Map<K,R> |
ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper)
Execute the query and return a
Map with results grouped by the
given key entity and mapped into the given entity type. |
<K,V> Map<K,V> |
ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper,
Class<V> valueType)
Execute the query and return a
Map with results grouped by the
given key entity and mapped into the given entity type. |
<K,V> Map<K,V> |
ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper,
RecordMapper<? super R,V> valueMapper)
Execute the query and return a
Map with results grouped by the
given key entity and mapped into the given entity type. |
<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. |
<K> Map<K,R> |
Result.intoMap(Class<? extends K> keyType)
Return a
Map with results grouped by the given key entity. |
<K,V> Map<K,V> |
Result.intoMap(Class<? extends K> keyType,
Class<? extends V> valueType)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
<K,V> Map<K,V> |
Result.intoMap(Class<? extends K> keyType,
RecordMapper<? super R,V> valueMapper)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
Map<Record,R> |
Result.intoMap(Field<?>[] keys)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
Result.intoMap(Field<?>[] keys,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<List<?>,E> |
Result.intoMap(Field<?>[] keys,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
<K> Map<K,R> |
Result.intoMap(Field<K> key)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
<K,E> Map<K,E> |
Result.intoMap(Field<K> key,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<K,V> Map<K,V> |
Result.intoMap(Field<K> key,
Field<V> value)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<K,E> Map<K,E> |
Result.intoMap(Field<K> key,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Map<?,R> |
Result.intoMap(int keyFieldIndex)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
Map<Record,R> |
Result.intoMap(int[] keyFieldIndexes)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
Result.intoMap(int[] keyFieldIndexes,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<List<?>,E> |
Result.intoMap(int[] keyFieldIndexes,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
<E> Map<?,E> |
Result.intoMap(int keyFieldIndex,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
Map<?,?> |
Result.intoMap(int keyFieldIndex,
int valueFieldIndex)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<E> Map<?,E> |
Result.intoMap(int keyFieldIndex,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Map<?,R> |
Result.intoMap(Name keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
Map<Record,R> |
Result.intoMap(Name[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
<E> Map<?,E> |
Result.intoMap(Name keyFieldName,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
Map<?,?> |
Result.intoMap(Name keyFieldName,
Name valueFieldName)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<E> Map<?,E> |
Result.intoMap(Name keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
<K> Map<K,R> |
Result.intoMap(RecordMapper<? super R,K> keyMapper)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
<K,V> Map<K,V> |
Result.intoMap(RecordMapper<? super R,K> keyMapper,
Class<V> valueType)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
<K,V> Map<K,V> |
Result.intoMap(RecordMapper<? super R,K> keyMapper,
RecordMapper<? super R,V> valueMapper)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
Map<?,R> |
Result.intoMap(String keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
Map<Record,R> |
Result.intoMap(String[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
Result.intoMap(String[] keyFieldNames,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<List<?>,E> |
Result.intoMap(String[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
<E> Map<?,E> |
Result.intoMap(String keyFieldName,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<E> Map<?,E> |
Result.intoMap(String keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Map<?,?> |
Result.intoMap(String keyFieldName,
String valueFieldName)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<S extends Record> |
Result.intoMap(Table<S> table)
Return a
Map with the given key table as a map key and the
corresponding record as value. |
<E,S extends Record> |
Result.intoMap(Table<S> table,
Class<? extends E> type)
Return a
Map with results grouped by the given key table and
mapped into the given entity type. |
<E,S extends Record> |
Result.intoMap(Table<S> table,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key table and
mapped by the given mapper. |
Modifier and Type | Class and Description |
---|---|
class |
NoDataFoundException
No rows were returned from a
ResultQuery , when exactly one row was
expected. |
class |
TooManyRowsException
Too many rows (more than 1) were returned from a
ResultQuery . |
Copyright © 2016. All Rights Reserved.