| 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.