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> java.util.Map<K,R> |
ResultQuery.fetchMap(java.lang.Class<? extends K> keyType)
Execute the query and return a
Map with results grouped by the
given key entity. |
<K,V> java.util.Map<K,V> |
ResultQuery.fetchMap(java.lang.Class<? extends K> keyType,
java.lang.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> java.util.Map<K,V> |
ResultQuery.fetchMap(java.lang.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> java.util.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> java.util.Map<K,V> |
ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper,
java.lang.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> java.util.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. |
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.sql.ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> java.util.Optional<T> |
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
java.lang.Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> java.util.Optional<T> |
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> java.util.Optional<T> |
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
java.util.Optional<?> |
DSLContext.fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.util.Optional<?> |
DSLContext.fetchOptionalValue(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> java.util.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. |
java.lang.Object |
DSLContext.fetchValue(java.sql.ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(java.sql.ResultSet rs,
java.lang.Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(java.sql.ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(java.sql.ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
java.lang.Object |
DSLContext.fetchValue(SQL sql)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.String sql)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
java.lang.Object |
DSLContext.fetchValue(java.lang.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> java.util.Map<K,R> |
Result.intoMap(java.lang.Class<? extends K> keyType)
Return a
Map with results grouped by the given key entity. |
<K,V> java.util.Map<K,V> |
Result.intoMap(java.lang.Class<? extends K> keyType,
java.lang.Class<? extends V> valueType)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
<K,V> java.util.Map<K,V> |
Result.intoMap(java.lang.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. |
java.util.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> java.util.Map<java.util.List<?>,E> |
Result.intoMap(Field<?>[] keys,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
java.util.Map<Record,Record> |
Result.intoMap(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> java.util.Map<java.util.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> java.util.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> java.util.Map<K,E> |
Result.intoMap(Field<K> key,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<K,V> java.util.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> java.util.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. |
java.util.Map<?,R> |
Result.intoMap(int keyFieldIndex)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
java.util.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> java.util.Map<java.util.List<?>,E> |
Result.intoMap(int[] keyFieldIndexes,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
java.util.Map<Record,Record> |
Result.intoMap(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> java.util.Map<java.util.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> java.util.Map<?,E> |
Result.intoMap(int keyFieldIndex,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
java.util.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> java.util.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. |
java.util.Map<?,R> |
Result.intoMap(Name keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
java.util.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> java.util.Map<java.util.List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
java.util.Map<Record,Record> |
Result.intoMap(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> java.util.Map<java.util.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> java.util.Map<?,E> |
Result.intoMap(Name keyFieldName,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
java.util.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> java.util.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> java.util.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> java.util.Map<K,V> |
Result.intoMap(RecordMapper<? super R,K> keyMapper,
java.lang.Class<V> valueType)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
<K,V> java.util.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. |
java.util.Map<?,R> |
Result.intoMap(java.lang.String keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
java.util.Map<Record,R> |
Result.intoMap(java.lang.String[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> java.util.Map<java.util.List<?>,E> |
Result.intoMap(java.lang.String[] keyFieldNames,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> java.util.Map<java.util.List<?>,E> |
Result.intoMap(java.lang.String[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
java.util.Map<Record,Record> |
Result.intoMap(java.lang.String[] keyFieldNames,
java.lang.String[] valueFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> java.util.Map<?,E> |
Result.intoMap(java.lang.String keyFieldName,
java.lang.Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<E> java.util.Map<?,E> |
Result.intoMap(java.lang.String keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
java.util.Map<?,?> |
Result.intoMap(java.lang.String keyFieldName,
java.lang.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,
java.lang.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. |
<S extends Record,T extends Record> |
Result.intoMap(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the given key table as a map key and the
corresponding record as value. |
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 © 2018. All Rights Reserved.