<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.
|
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.
|
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.
|
<T,R extends Record1<T>> Optional<T> |
DSLContext.fetchOptionalValue(ResultQuery<R> query) |
Execute a ResultQuery in the context of this
DSLContext and return a single value.
|
Optional<?> |
DSLContext.fetchOptionalValue(SQL sql) |
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.
|
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.
|
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.
|
List<?> |
DSLContext.fetchValues(String sql) |
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
List<?> |
DSLContext.fetchValues(ResultSet rs) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> List<T> |
DSLContext.fetchValues(ResultSet rs,
Class<T> type) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> List<T> |
DSLContext.fetchValues(ResultSet rs,
DataType<T> type) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> List<T> |
DSLContext.fetchValues(ResultSet rs,
Field<T> field) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
List<?> |
DSLContext.fetchValues(SQL sql) |
Execute a new query holding plain SQL.
|
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.
|
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> 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.
|
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
|
<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.
|
<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.
|
<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<?,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.
|
Map<Record,Record> |
Result.intoMap(String[] keyFieldNames,
String[] valueFieldNames) |
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,
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.
|
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
|
<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<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.
|
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> 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
|
<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(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.
|
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> 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
|
<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.
|
<S extends Record> Map<S,R> |
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> Map<S,E> |
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> Map<S,E> |
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> Map<S,T> |
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.
|