java.sql.Connection |
ConnectionProvider.acquire() |
Acquire a connection from the connection lifecycle handler.
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type) |
Joins the existing table product to a new table using a foreign key.
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type,
TableField<?,?>... keyFields) |
Joins the existing table product to a new table using a foreign key.
|
void |
TransactionProvider.begin(TransactionContext ctx) |
Begin a new transaction.
|
BindContext |
BindContext.bind(java.util.Collection<? extends QueryPart> parts) |
Deprecated.
|
BindContext |
BindContext.bind(QueryPart part) |
Deprecated.
|
BindContext |
BindContext.bind(QueryPart[] parts) |
Deprecated.
|
void |
QueryPartInternal.bind(BindContext ctx) |
Deprecated.
|
BindContext |
BindContext.bindValue(java.lang.Object value,
java.lang.Class<?> type) |
Deprecated.
|
BindContext |
BindContext.bindValue(java.lang.Object value,
Field<?> field) |
Bind a value using a specific type.
|
BindContext |
Context.bindValue(java.lang.Object value,
Field<?> field) |
Bind a value using a specific type.
|
BindContext |
BindContext.bindValues(java.lang.Object... values) |
Deprecated.
|
void |
Query.cancel() |
Cancel the underlying statement.
|
void |
Cursor.close() |
Explicitly close the underlying PreparedStatement and
ResultSet.
|
void |
DSLContext.close() |
Close the underlying resources, if any resources have been allocated when
constructing this DSLContext.
|
void |
Query.close() |
Close the underlying statement.
|
<X,A>
X |
Cursor.collect(java.util.stream.Collector<? super R,A,X> collector) |
Reduce the execution results of this query using a Collector.
|
<X,A>
X |
ResultQuery.collect(java.util.stream.Collector<? super R,A,X> collector) |
Reduce the execution results of this query using a Collector.
|
void |
TransactionProvider.commit(TransactionContext ctx) |
Commit a transaction.
|
long |
DAO.count() |
Count all records of the underlying table.
|
java.math.BigInteger |
DSLContext.currval(java.lang.String sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
java.math.BigInteger |
DSLContext.currval(Name sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends java.lang.Number>
T |
DSLContext.currval(Sequence<T> sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
void |
DAO.delete(java.util.Collection<P> objects) |
Performs a DELETE statement for a given set of POJOs
|
void |
DAO.delete(P object) |
Performs a DELETE statement for a POJO
|
void |
DAO.delete(P... objects) |
Performs a DELETE statement for a given set of POJOs
|
int |
UpdatableRecord.delete() |
Deletes this record from the database, based on the value of the primary
key or main unique key.
|
void |
DAO.deleteById(java.util.Collection<T> ids) |
Performs a DELETE statement for a given set of IDs
|
void |
DAO.deleteById(T... ids) |
Performs a DELETE statement for a given set of IDs
|
int[] |
Batch.execute() |
Execute the batch operation.
|
int |
DSLContext.execute(java.lang.String sql) |
Execute a query holding plain SQL.
|
int |
DSLContext.execute(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(Query query) |
Execute a Query in the context of this DSLContext. |
int |
DSLContext.execute(SQL sql) |
Execute a query holding plain SQL.
|
int |
Query.execute() |
Execute the query, if it has been created with a proper configuration.
|
int |
Routine.execute() |
Execute the stored object on an underlying connection
|
int |
Routine.execute(Configuration configuration) |
|
int |
DSLContext.executeDelete(TableRecord<?> record,
Condition condition) |
Delete a record from a table.
|
int |
DSLContext.executeDelete(UpdatableRecord<?> record) |
Delete a record from a table.
|
int |
DSLContext.executeInsert(TableRecord<?> record) |
Insert one record.
|
int |
DSLContext.executeUpdate(TableRecord<?> record,
Condition condition) |
Update a table.
|
int |
DSLContext.executeUpdate(UpdatableRecord<?> record) |
Update a table.
|
boolean |
DAO.exists(P object) |
Checks if a given POJO exists
|
boolean |
DAO.existsById(T id) |
Checks if a given ID exists
|
Result<R> |
Cursor.fetch() |
Fetch all remaining records as a result.
|
Result<R> |
Cursor.fetch(int number) |
Deprecated.
|
<E> java.util.List<E> |
Cursor.fetch(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
<Z> java.util.List<P> |
DAO.fetch(Field<Z> field,
Z... values) |
Find records by a given field and a set of values.
|
Result<R> |
DeleteResultStep.fetch() |
|
Result<Record> |
DSLContext.fetch(java.lang.String sql) |
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs) |
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result. |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result. |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
DataType<?>... types) |
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result. |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
Field<?>... fields) |
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result. |
<R extends Record>
Result<R> |
DSLContext.fetch(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
results. |
Result<Record> |
DSLContext.fetch(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record>
Result<R> |
DSLContext.fetch(Table<R> table) |
Execute and return all records for
|
<R extends Record>
Result<R> |
DSLContext.fetch(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return all records for
|
<R extends Record>
Result<R> |
DSLContext.fetch(Table<R> table,
Condition condition) |
Execute and return all records for
|
<R extends Record>
Result<R> |
DSLContext.fetch(Table<R> table,
Condition... conditions) |
Execute and return all records for
|
Result<R> |
InsertResultStep.fetch() |
|
Result<R> |
ResultQuery.fetch() |
Execute the query and return the generated result.
|
java.util.List<?> |
ResultQuery.fetch(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<T> java.util.List<T> |
ResultQuery.fetch(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> java.util.List<U> |
ResultQuery.fetch(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field index from the
generated result.
|
java.util.List<?> |
ResultQuery.fetch(java.lang.String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.List<T> |
ResultQuery.fetch(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> java.util.List<U> |
ResultQuery.fetch(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.List<T> |
ResultQuery.fetch(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> java.util.List<T> |
ResultQuery.fetch(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
java.util.List<U> |
ResultQuery.fetch(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return all values for a field from the generated
result.
|
java.util.List<?> |
ResultQuery.fetch(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.List<T> |
ResultQuery.fetch(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> java.util.List<U> |
ResultQuery.fetch(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<E> java.util.List<E> |
ResultQuery.fetch(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
Result<R> |
UpdateResultStep.fetch() |
|
<R extends Record>
R |
DSLContext.fetchAny(Table<R> table) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchAny(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchAny(Table<R> table,
Condition condition) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchAny(Table<R> table,
Condition... conditions) |
Execute and return zero or one record for
|
R |
ResultQuery.fetchAny() |
Execute the query and return at most one resulting record.
|
java.lang.Object |
ResultQuery.fetchAny(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<T> T |
ResultQuery.fetchAny(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchAny(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
java.lang.Object |
ResultQuery.fetchAny(java.lang.String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchAny(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchAny(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> T |
ResultQuery.fetchAny(Field<T> field) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T,U>
U |
ResultQuery.fetchAny(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
java.lang.Object |
ResultQuery.fetchAny(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchAny(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<E> E |
ResultQuery.fetchAny(RecordMapper<? super R,E> mapper) |
Execute the query and return at most one resulting record.
|
java.lang.Object[] |
ResultQuery.fetchAnyArray() |
Execute the query and return at most one resulting record as an array
|
<E> E |
ResultQuery.fetchAnyInto(java.lang.Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
Z |
ResultQuery.fetchAnyInto(Table<Z> table) |
Map resulting records onto a custom record.
|
java.util.Map<java.lang.String,java.lang.Object> |
ResultQuery.fetchAnyMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
R[] |
ResultQuery.fetchArray() |
Execute the query and return the generated result as an array of records.
|
java.lang.Object[] |
ResultQuery.fetchArray(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field index from the
generated result.
|
java.lang.Object[] |
ResultQuery.fetchArray(java.lang.String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> T[] |
ResultQuery.fetchArray(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
U[] |
ResultQuery.fetchArray(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return all values for a field from the generated
result.
|
java.lang.Object[] |
ResultQuery.fetchArray(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
java.lang.Object[][] |
ResultQuery.fetchArrays() |
Execute the query and return the generated result as an Object matrix.
|
<R extends TableRecord<R>>
Result<R> |
DSLContext.fetchByExample(R example) |
Execute a "Query by Example" (QBE) based on an example record.
|
<O extends TableRecord<O>>
O |
UpdatableRecord.fetchChild(ForeignKey<O,R> key) |
Fetch a child record of this record, given a foreign key.
|
Result<R> |
ForeignKey.fetchChildren(java.util.Collection<? extends O> records) |
Fetch child records of a given set of records through this foreign key
|
Result<R> |
ForeignKey.fetchChildren(O record) |
Fetch child records of a given record through this foreign key
|
Result<R> |
ForeignKey.fetchChildren(O... records) |
Fetch child records of a given set of records through this foreign key
|
<O extends TableRecord<O>>
Result<O> |
Result.fetchChildren(ForeignKey<O,R> key) |
Fetch child records of this record, given a foreign key.
|
<O extends TableRecord<O>>
Result<O> |
UpdatableRecord.fetchChildren(ForeignKey<O,R> key) |
Fetch child records of this record, given a foreign key.
|
int |
DSLContext.fetchCount(Select<?> query) |
Execute a Select query in the context of this DSLContext and return
a COUNT(*) value. |
int |
DSLContext.fetchCount(Table<?> table) |
Count the number of records in a table.
|
int |
DSLContext.fetchCount(Table<?> table,
java.util.Collection<? extends Condition> conditions) |
Count the number of records in a table that satisfy a condition.
|
int |
DSLContext.fetchCount(Table<?> table,
Condition condition) |
Count the number of records in a table that satisfy a condition.
|
int |
DSLContext.fetchCount(Table<?> table,
Condition... conditions) |
Count the number of records in a table that satisfy a condition.
|
int |
Select.fetchCount() |
Deprecated.
|
boolean |
DSLContext.fetchExists(Select<?> query) |
Check if a Select would return any records, if it were executed. |
boolean |
DSLContext.fetchExists(Table<?> table) |
Check if a table has any records.
|
boolean |
DSLContext.fetchExists(Table<?> table,
java.util.Collection<? extends Condition> conditions) |
Check if a table has any records that satisfy a condition.
|
boolean |
DSLContext.fetchExists(Table<?> table,
Condition condition) |
Check if a table has any records that satisfy a condition.
|
boolean |
DSLContext.fetchExists(Table<?> table,
Condition... conditions) |
Check if a table has any records that satisfy a condition.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string) |
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
boolean header) |
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
boolean header,
char delimiter) |
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
char delimiter) |
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromHTML(java.lang.String string) |
Convert an HTML table into a jOOQ Result. |
Result<Record> |
DSLContext.fetchFromTXT(java.lang.String string) |
Fetch all data from a formatted string.
|
Result<Record> |
DSLContext.fetchFromTXT(java.lang.String string,
java.lang.String nullLiteral) |
Fetch all data from a formatted string.
|
java.util.Map<?,Result<R>> |
ResultQuery.fetchGroups(int keyFieldIndex) |
Execute the query and return a Map with one of the result's
columns as key and a list of corresponding records as value.
|
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes) |
Execute the query and return a Map with the result grouped by the
given keys.
|
java.util.Map<Record,Result<Record>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes) |
Execute the query and return a Map with the result grouped by the
given keys.
|
java.util.Map<?,java.util.List<?>> |
ResultQuery.fetchGroups(int keyFieldIndex,
int valueFieldIndex) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(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.
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(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<?,Result<R>> |
ResultQuery.fetchGroups(java.lang.String keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and a list of corresponding records as value.
|
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(java.lang.String[] keyFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys.
|
java.util.Map<Record,Result<Record>> |
ResultQuery.fetchGroups(java.lang.String[] keyFieldNames,
java.lang.String[] valueFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys.
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(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.
|
java.util.Map<?,java.util.List<?>> |
ResultQuery.fetchGroups(java.lang.String keyFieldName,
java.lang.String valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(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<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys) |
Execute the query and return a Map with the result grouped by the
given keys.
|
java.util.Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Field<?>[] keys,
Field<?>[] values) |
Execute the query and return a Map with the result grouped by the
given keys.
|
<K> java.util.Map<K,Result<R>> |
ResultQuery.fetchGroups(Field<K> key) |
Execute the query and return a Map with one of the result's
columns as key and a list of corresponding records as value.
|
<K,E>
java.util.Map<K,java.util.List<E>> |
ResultQuery.fetchGroups(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,java.util.List<V>> |
ResultQuery.fetchGroups(Field<K> key,
Field<V> value) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<K,E>
java.util.Map<K,java.util.List<E>> |
ResultQuery.fetchGroups(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<?,Result<R>> |
ResultQuery.fetchGroups(Name keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and a list of corresponding records as value.
|
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys.
|
java.util.Map<Record,Result<Record>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Name[] valueFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys.
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(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<?,java.util.List<?>> |
ResultQuery.fetchGroups(Name keyFieldName,
Name valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,java.util.List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given key and mapped by
the given mapper.
|
<S extends Record>
java.util.Map<S,Result<R>> |
ResultQuery.fetchGroups(Table<S> table) |
Execute the query and return a Map with the result grouped by the
given table.
|
<E,S extends Record>
java.util.Map<S,java.util.List<E>> |
ResultQuery.fetchGroups(Table<S> table,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given table and mapped into the given entity type.
|
<E,S extends Record>
java.util.Map<S,java.util.List<E>> |
ResultQuery.fetchGroups(Table<S> table,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given table and mapped by the given mapper.
|
<S extends Record,T extends Record>
java.util.Map<S,Result<T>> |
ResultQuery.fetchGroups(Table<S> keyTable,
Table<T> valueTable) |
Execute the query and return a Map with the result grouped by the
given table.
|
<H extends RecordHandler<? super R>>
H |
Cursor.fetchInto(H handler) |
Fetch results into a custom handler callback.
|
<E> java.util.List<E> |
Cursor.fetchInto(java.lang.Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
Result<Z> |
Cursor.fetchInto(Table<Z> table) |
Map resulting records onto a custom record.
|
<H extends RecordHandler<? super R>>
H |
ResultQuery.fetchInto(H handler) |
Fetch results into a custom handler callback.
|
<E> java.util.List<E> |
ResultQuery.fetchInto(java.lang.Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
Result<Z> |
ResultQuery.fetchInto(Table<Z> table) |
Map resulting records onto a custom record.
|
FutureResult<R> |
ResultQuery.fetchLater() |
Deprecated.
|
FutureResult<R> |
ResultQuery.fetchLater(java.util.concurrent.ExecutorService executor) |
Deprecated.
|
Cursor<Record> |
DSLContext.fetchLazy(java.lang.String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(java.sql.ResultSet rs) |
Wrap a JDBC ResultSet into a jOOQ Cursor. |
Cursor<Record> |
DSLContext.fetchLazy(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Wrap a JDBC ResultSet into a jOOQ Cursor. |
Cursor<Record> |
DSLContext.fetchLazy(java.sql.ResultSet rs,
DataType<?>... types) |
Wrap a JDBC ResultSet into a jOOQ Cursor. |
Cursor<Record> |
DSLContext.fetchLazy(java.sql.ResultSet rs,
Field<?>... fields) |
Wrap a JDBC ResultSet into a jOOQ Cursor. |
<R extends Record>
Cursor<R> |
DSLContext.fetchLazy(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a cursor. |
Cursor<Record> |
DSLContext.fetchLazy(SQL sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record>
Cursor<R> |
DSLContext.fetchLazy(Table<R> table) |
Execute and return all records lazily for
|
<R extends Record>
Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return all records lazily for
|
<R extends Record>
Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
Condition condition) |
Execute and return all records lazily for
|
<R extends Record>
Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
Condition... conditions) |
Execute and return all records lazily for
|
Cursor<R> |
ResultQuery.fetchLazy() |
Execute the query and "lazily" return the generated result.
|
Cursor<R> |
ResultQuery.fetchLazy(int fetchSize) |
Deprecated.
|
Results |
DSLContext.fetchMany(java.lang.String sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
DSLContext.fetchMany(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
<R extends Record>
Results |
DSLContext.fetchMany(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a cursor. |
Results |
DSLContext.fetchMany(SQL sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
ResultQuery.fetchMany() |
Execute a query, possibly returning several result sets.
|
java.util.Map<?,R> |
ResultQuery.fetchMap(int keyFieldIndex) |
Execute the query and return a Map with one of the result's
columns as key and the corresponding records as value.
|
java.util.Map<Record,R> |
ResultQuery.fetchMap(int[] keyFieldIndexes) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
java.util.Map<Record,Record> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
int[] valueFieldIndexes) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
java.lang.Class<? extends E> type) |
Execute the query and 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> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper.
|
java.util.Map<?,?> |
ResultQuery.fetchMap(int keyFieldIndex,
int valueFieldIndex) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(int keyFieldIndex,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given key and mapped into the given entity type.
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(int keyFieldIndex,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given key and mapped by the given mapper.
|
<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.
|
java.util.Map<?,R> |
ResultQuery.fetchMap(java.lang.String keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and the corresponding records as value.
|
java.util.Map<Record,R> |
ResultQuery.fetchMap(java.lang.String[] keyFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(java.lang.String[] keyFieldNames,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given keys and mapped into the given entity type.
|
java.util.Map<Record,Record> |
ResultQuery.fetchMap(java.lang.String[] keyFieldNames,
java.lang.String[] valueFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(java.lang.String[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper.
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(java.lang.String keyFieldName,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given key and mapped into the given entity type.
|
java.util.Map<?,?> |
ResultQuery.fetchMap(java.lang.String keyFieldName,
java.lang.String valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(java.lang.String keyFieldName,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given key and mapped by the given mapper.
|
java.util.Map<Record,R> |
ResultQuery.fetchMap(Field<?>[] keys) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(Field<?>[] keys,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given keys and mapped into the given entity type.
|
java.util.Map<Record,Record> |
ResultQuery.fetchMap(Field<?>[] keys,
Field<?>[] values) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(Field<?>[] keys,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper.
|
<K> java.util.Map<K,R> |
ResultQuery.fetchMap(Field<K> key) |
Execute the query and 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> |
ResultQuery.fetchMap(Field<K> key,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given key and mapped into the given entity type.
|
<K,V>
java.util.Map<K,V> |
ResultQuery.fetchMap(Field<K> key,
Field<V> value) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<K,E>
java.util.Map<K,E> |
ResultQuery.fetchMap(Field<K> key,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given key and mapped by the given mapper.
|
java.util.Map<?,R> |
ResultQuery.fetchMap(Name keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and the corresponding records as value.
|
java.util.Map<Record,R> |
ResultQuery.fetchMap(Name[] keyFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given keys and mapped into the given entity type.
|
java.util.Map<Record,Record> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Name[] valueFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value.
|
<E> java.util.Map<java.util.List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given keys and mapped by the given mapper.
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given key and mapped into the given entity type.
|
java.util.Map<?,?> |
ResultQuery.fetchMap(Name keyFieldName,
Name valueFieldName) |
Execute the query and return a Map with one of the result's
columns as key and another one of the result's columns as value
|
<E> java.util.Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given key and mapped by the given mapper.
|
<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.
|
<S extends Record>
java.util.Map<S,R> |
ResultQuery.fetchMap(Table<S> table) |
Execute the query and return a Map with table as a map key and
the corresponding record as value.
|
<E,S extends Record>
java.util.Map<S,E> |
ResultQuery.fetchMap(Table<S> table,
java.lang.Class<? extends E> type) |
Execute the query and return a Map with results grouped by the
given table and mapped into the given entity type.
|
<E,S extends Record>
java.util.Map<S,E> |
ResultQuery.fetchMap(Table<S> table,
RecordMapper<? super R,E> mapper) |
Execute the query and return a Map with results grouped by the
given table and mapped by the given mapper.
|
<S extends Record,T extends Record>
java.util.Map<S,T> |
ResultQuery.fetchMap(Table<S> keyTable,
Table<T> valueTable) |
Execute the query and return a Map with table as a map key and
the corresponding record as value.
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
ResultQuery.fetchMaps() |
Execute the query and return the generated result as a list of name/value
maps.
|
R |
Cursor.fetchNext() |
Fetch the next record from the cursor.
|
Result<R> |
Cursor.fetchNext(int number) |
Fetch the next couple of records from the cursor.
|
<E> E |
Cursor.fetchNext(RecordMapper<? super R,E> mapper) |
Fetch the next record into a custom mapper callback.
|
<H extends RecordHandler<? super R>>
H |
Cursor.fetchNextInto(H handler) |
Fetch the next record into a custom handler callback.
|
<E> E |
Cursor.fetchNextInto(java.lang.Class<? extends E> type) |
Map the next resulting record onto a custom type.
|
<Z extends Record>
Z |
Cursor.fetchNextInto(Table<Z> table) |
Map the next resulting record onto a custom record.
|
java.util.Optional<R> |
Cursor.fetchNextOptional() |
Fetch the next record from the cursor.
|
<E> java.util.Optional<E> |
Cursor.fetchNextOptional(RecordMapper<? super R,E> mapper) |
Fetch the next record into a custom mapper callback.
|
<E> java.util.Optional<E> |
Cursor.fetchNextOptionalInto(java.lang.Class<? extends E> type) |
Map the next resulting record onto a custom type.
|
<Z extends Record>
java.util.Optional<Z> |
Cursor.fetchNextOptionalInto(Table<Z> table) |
Map the next resulting record onto a custom record.
|
R |
Cursor.fetchOne() |
Deprecated.
|
<E> E |
Cursor.fetchOne(RecordMapper<? super R,E> mapper) |
Deprecated.
|
<Z> P |
DAO.fetchOne(Field<Z> field,
Z value) |
Find a unique record by a given field and a value.
|
R |
DeleteResultStep.fetchOne() |
|
Record |
DSLContext.fetchOne(java.lang.String sql) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(java.sql.ResultSet rs) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchOne(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchOne(java.sql.ResultSet rs,
DataType<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchOne(java.sql.ResultSet rs,
Field<?>... fields) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
<R extends Record>
R |
DSLContext.fetchOne(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a record. |
Record |
DSLContext.fetchOne(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record>
R |
DSLContext.fetchOne(Table<R> table) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchOne(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchOne(Table<R> table,
Condition condition) |
Execute and return zero or one record for
|
<R extends Record>
R |
DSLContext.fetchOne(Table<R> table,
Condition... conditions) |
Execute and return zero or one record for
|
R |
InsertResultStep.fetchOne() |
|
R |
ResultQuery.fetchOne() |
Execute the query and return at most one resulting record.
|
java.lang.Object |
ResultQuery.fetchOne(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<T> T |
ResultQuery.fetchOne(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchOne(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
java.lang.Object |
ResultQuery.fetchOne(java.lang.String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> T |
ResultQuery.fetchOne(Field<T> field) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T,U>
U |
ResultQuery.fetchOne(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
java.lang.Object |
ResultQuery.fetchOne(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<E> E |
ResultQuery.fetchOne(RecordMapper<? super R,E> mapper) |
Execute the query and return at most one resulting value into a
custom mapper callback.
|
R |
UpdateResultStep.fetchOne() |
|
java.lang.Object[] |
ResultQuery.fetchOneArray() |
Execute the query and return at most one resulting record as an array
|
<H extends RecordHandler<? super R>>
H |
Cursor.fetchOneInto(H handler) |
Deprecated.
|
<E> E |
Cursor.fetchOneInto(java.lang.Class<? extends E> type) |
Deprecated.
|
<Z extends Record>
Z |
Cursor.fetchOneInto(Table<Z> table) |
Deprecated.
|
<E> E |
ResultQuery.fetchOneInto(java.lang.Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
Z |
ResultQuery.fetchOneInto(Table<Z> table) |
Map resulting records onto a custom record.
|
java.util.Map<java.lang.String,java.lang.Object> |
ResultQuery.fetchOneMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
java.util.Optional<R> |
Cursor.fetchOptional() |
Deprecated.
|
<E> java.util.Optional<E> |
Cursor.fetchOptional(RecordMapper<? super R,E> mapper) |
Deprecated.
|
<Z> java.util.Optional<P> |
DAO.fetchOptional(Field<Z> field,
Z value) |
Find a unique record by a given field and a value.
|
java.util.Optional<R> |
DeleteResultStep.fetchOptional() |
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql) |
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
java.util.Optional<Record> |
DSLContext.fetchOptional(java.sql.ResultSet rs) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
java.util.Optional<Record> |
DSLContext.fetchOptional(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
java.util.Optional<Record> |
DSLContext.fetchOptional(java.sql.ResultSet rs,
DataType<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
java.util.Optional<Record> |
DSLContext.fetchOptional(java.sql.ResultSet rs,
Field<?>... fields) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
<R extends Record>
java.util.Optional<R> |
DSLContext.fetchOptional(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a record. |
java.util.Optional<Record> |
DSLContext.fetchOptional(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record>
java.util.Optional<R> |
DSLContext.fetchOptional(Table<R> table) |
Execute and return zero or one record for
|
<R extends Record>
java.util.Optional<R> |
DSLContext.fetchOptional(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return zero or one record for
|
<R extends Record>
java.util.Optional<R> |
DSLContext.fetchOptional(Table<R> table,
Condition condition) |
Execute and return zero or one record for
|
<R extends Record>
java.util.Optional<R> |
DSLContext.fetchOptional(Table<R> table,
Condition... conditions) |
Execute and return zero or one record for
|
java.util.Optional<R> |
InsertResultStep.fetchOptional() |
|
java.util.Optional<R> |
ResultQuery.fetchOptional() |
Execute the query and return at most one resulting record.
|
java.util.Optional<?> |
ResultQuery.fetchOptional(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<T> java.util.Optional<T> |
ResultQuery.fetchOptional(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> java.util.Optional<U> |
ResultQuery.fetchOptional(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
java.util.Optional<?> |
ResultQuery.fetchOptional(java.lang.String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> java.util.Optional<T> |
ResultQuery.fetchOptional(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> java.util.Optional<U> |
ResultQuery.fetchOptional(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> java.util.Optional<T> |
ResultQuery.fetchOptional(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> java.util.Optional<T> |
ResultQuery.fetchOptional(Field<T> field) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T,U>
java.util.Optional<U> |
ResultQuery.fetchOptional(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
java.util.Optional<?> |
ResultQuery.fetchOptional(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> java.util.Optional<T> |
ResultQuery.fetchOptional(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> java.util.Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<E> java.util.Optional<E> |
ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper) |
Execute the query and return at most one resulting value into a
custom mapper callback.
|
java.util.Optional<R> |
UpdateResultStep.fetchOptional() |
|
java.util.Optional<java.lang.Object[]> |
ResultQuery.fetchOptionalArray() |
Execute the query and return at most one resulting record as an array.
|
<E> java.util.Optional<E> |
Cursor.fetchOptionalInto(java.lang.Class<? extends E> type) |
Deprecated.
|
<Z extends Record>
java.util.Optional<Z> |
Cursor.fetchOptionalInto(Table<Z> table) |
Deprecated.
|
<E> java.util.Optional<E> |
ResultQuery.fetchOptionalInto(java.lang.Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
java.util.Optional<Z> |
ResultQuery.fetchOptionalInto(Table<Z> table) |
Map resulting records onto a custom record.
|
java.util.Optional<java.util.Map<java.lang.String,java.lang.Object>> |
ResultQuery.fetchOptionalMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
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.
|
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.
|
<T,R extends Record1<T>>
java.util.Optional<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(SQL sql) |
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. |
O |
ForeignKey.fetchParent(R record) |
Fetch a parent record of a given record through this foreign key
|
<O extends UpdatableRecord<O>>
O |
TableRecord.fetchParent(ForeignKey<R,O> key) |
Fetch a parent record of this record, given a foreign key.
|
Result<O> |
ForeignKey.fetchParents(java.util.Collection<? extends R> records) |
Fetch parent records of a given set of record through this foreign key
|
Result<O> |
ForeignKey.fetchParents(R... records) |
Fetch parent records of a given set of record through this foreign key
|
<O extends UpdatableRecord<O>>
Result<O> |
Result.fetchParents(ForeignKey<R,O> key) |
Fetch parent records of this record, given a foreign key.
|
<Z> java.util.List<P> |
DAO.fetchRange(Field<Z> field,
Z lowerInclusive,
Z upperInclusive) |
Find records by a given field and a range of values.
|
java.sql.ResultSet |
ResultQuery.fetchResultSet() |
Execute the query and return the generated result as a JDBC
ResultSet.
|
java.util.Set<?> |
ResultQuery.fetchSet(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<T> java.util.Set<T> |
ResultQuery.fetchSet(int fieldIndex,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> java.util.Set<U> |
ResultQuery.fetchSet(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field index from the
generated result.
|
java.util.Set<?> |
ResultQuery.fetchSet(java.lang.String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.Set<T> |
ResultQuery.fetchSet(java.lang.String fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> java.util.Set<U> |
ResultQuery.fetchSet(java.lang.String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.Set<T> |
ResultQuery.fetchSet(Field<?> field,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> java.util.Set<T> |
ResultQuery.fetchSet(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
java.util.Set<U> |
ResultQuery.fetchSet(Field<T> field,
Converter<? super T,? extends U> converter) |
Execute the query and return all values for a field from the generated
result.
|
java.util.Set<?> |
ResultQuery.fetchSet(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<T> java.util.Set<T> |
ResultQuery.fetchSet(Name fieldName,
java.lang.Class<? extends T> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> java.util.Set<U> |
ResultQuery.fetchSet(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<E> java.util.Set<E> |
ResultQuery.fetchSet(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
Record |
DSLContext.fetchSingle(java.lang.String sql) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
DataType<?>... types) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchSingle(java.sql.ResultSet rs,
Field<?>... fields) |
Fetch a record from a JDBC ResultSet and transform it to a jOOQ
Record. |
Record |
DSLContext.fetchSingle(java.util.Collection<? extends SelectField<?>> fields) |
Execute and return exactly one record for
|
<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(SelectField<?>... fields) |
Execute and return exactly one record for
|
<T1> Record1<T1> |
DSLContext.fetchSingle(SelectField<T1> field1) |
Execute and return exactly one record for
|
<T1,T2>
Record2<T1,T2> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2) |
Execute and return exactly one record for
|
<T1,T2,T3>
Record3<T1,T2,T3> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3) |
Execute and return exactly one record for
|
<T1,T2,T3,T4>
Record4<T1,T2,T3,T4> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5>
Record5<T1,T2,T3,T4,T5> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6>
Record6<T1,T2,T3,T4,T5,T6> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7>
Record7<T1,T2,T3,T4,T5,T6,T7> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8>
Record8<T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21) |
Execute and return exactly one record for
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21,
SelectField<T22> field22) |
Execute and return exactly one record for
|
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,
java.util.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.
|
java.lang.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,
java.lang.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.
|
java.lang.Object |
ResultQuery.fetchSingle(java.lang.String fieldName) |
Execute the query and return exactly one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchSingle(java.lang.String fieldName,
java.lang.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(java.lang.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,
java.lang.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.
|
java.lang.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,
java.lang.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.
|
java.lang.Object[] |
ResultQuery.fetchSingleArray() |
Execute the query and return exactly one resulting record as an array
|
<E> E |
ResultQuery.fetchSingleInto(java.lang.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.
|
java.util.Map<java.lang.String,java.lang.Object> |
ResultQuery.fetchSingleMap() |
Execute the query and return exactly one resulting record as a name/value
map.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.lang.String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.sql.ResultSet rs) |
Wrap a JDBC ResultSet into a jOOQ Stream.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Wrap a JDBC ResultSet into a jOOQ Stream.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.sql.ResultSet rs,
DataType<?>... types) |
Wrap a JDBC ResultSet into a jOOQ Stream.
|
java.util.stream.Stream<Record> |
DSLContext.fetchStream(java.sql.ResultSet rs,
Field<?>... fields) |
Wrap a JDBC ResultSet into a jOOQ Stream.
|
<R extends Record>
java.util.stream.Stream<R> |
DSLContext.fetchStream(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a stream. |
java.util.stream.Stream<Record> |
DSLContext.fetchStream(SQL sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record>
java.util.stream.Stream<R> |
DSLContext.fetchStream(Table<R> table) |
Execute and return all records lazily for
|
<R extends Record>
java.util.stream.Stream<R> |
DSLContext.fetchStream(Table<R> table,
java.util.Collection<? extends Condition> conditions) |
Execute and return all records lazily for
|
<R extends Record>
java.util.stream.Stream<R> |
DSLContext.fetchStream(Table<R> table,
Condition condition) |
Execute and return all records lazily for
|
<R extends Record>
java.util.stream.Stream<R> |
DSLContext.fetchStream(Table<R> table,
Condition... conditions) |
Execute and return all records lazily for
|
java.util.stream.Stream<R> |
ResultQuery.fetchStream() |
Stream this query.
|
<E> java.util.stream.Stream<E> |
ResultQuery.fetchStreamInto(java.lang.Class<? extends E> type) |
Stream this query, mapping records into a custom type.
|
<Z extends Record>
java.util.stream.Stream<Z> |
ResultQuery.fetchStreamInto(Table<Z> table) |
Stream this query, mapping records into a custom record.
|
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.
|
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.
|
<T> T |
DSLContext.fetchValue(Field<T> field) |
Execute a ResultQuery in the context of this
DSLContext and return a single value. |
<T,R extends Record1<T>>
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(SQL sql) |
Execute a new query holding plain SQL.
|
<T> T |
DSLContext.fetchValue(Table<? extends Record1<T>> table) |
Fetch a single value from a single column table.
|
<T> T |
DSLContext.fetchValue(TableField<?,T> field) |
Execute a ResultQuery in the context of this
DSLContext and return a single value. |
java.util.List<?> |
DSLContext.fetchValues(java.lang.String sql) |
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.lang.String sql,
java.lang.Object... bindings) |
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.lang.String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
java.util.List<?> |
DSLContext.fetchValues(java.sql.ResultSet rs) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> java.util.List<T> |
DSLContext.fetchValues(java.sql.ResultSet rs,
java.lang.Class<T> type) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> java.util.List<T> |
DSLContext.fetchValues(java.sql.ResultSet rs,
DataType<T> type) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T> java.util.List<T> |
DSLContext.fetchValues(java.sql.ResultSet rs,
Field<T> field) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values.
|
<T,R extends Record1<T>>
java.util.List<T> |
DSLContext.fetchValues(ResultQuery<R> query) |
Execute a ResultQuery in the context of this
DSLContext and return all values for the only column. |
java.util.List<?> |
DSLContext.fetchValues(SQL sql) |
Execute a new query holding plain SQL.
|
<T> java.util.List<T> |
DSLContext.fetchValues(Table<? extends Record1<T>> table) |
Fetch all values from a single column table.
|
<T> java.util.List<T> |
DSLContext.fetchValues(TableField<?,T> field) |
|
java.util.List<P> |
DAO.findAll() |
Find all records of the underlying table.
|
P |
DAO.findById(T id) |
Find a record of the underlying table by ID.
|
Catalog |
Meta.getCatalog(java.lang.String name) |
Get a catalog object by name from the underlying meta data source, or
null if no such object exists.
|
Catalog |
Meta.getCatalog(Name name) |
Get a catalog object by name from the underlying meta data source, or
null if no such object exists.
|
java.util.List<Catalog> |
Meta.getCatalogs() |
Get all catalog objects from the underlying meta data source.
|
java.util.List<UniqueKey<?>> |
Meta.getPrimaryKeys() |
Get all primary keys from the underlying meta data source.
|
java.util.List<Schema> |
Meta.getSchemas() |
Get all schema objects from the underlying meta data source.
|
java.util.List<Schema> |
Meta.getSchemas(java.lang.String name) |
Get all schema objects by name from the underlying meta data source.
|
java.util.List<Schema> |
Meta.getSchemas(Name name) |
Get all schema objects by name from the underlying meta data source.
|
java.util.List<Sequence<?>> |
Meta.getSequences() |
Get all sequence objects from the underlying meta data source.
|
java.util.List<Sequence<?>> |
Meta.getSequences(java.lang.String name) |
Get all sequence objects by name from the underlying meta data source.
|
java.util.List<Sequence<?>> |
Meta.getSequences(Name name) |
Get all sequence objects by name from the underlying meta data source.
|
java.util.List<Table<?>> |
Meta.getTables() |
Get all table objects from the underlying meta data source.
|
java.util.List<Table<?>> |
Meta.getTables(java.lang.String name) |
Get all table objects by name from the underlying meta data source.
|
java.util.List<Table<?>> |
Meta.getTables(Name name) |
Get all table objects by name from the underlying meta data source.
|
boolean |
Cursor.hasNext() |
Check whether this cursor has a next record.
|
void |
DAO.insert(java.util.Collection<P> objects) |
Performs a batch INSERT statement for a given set of POJOs
|
void |
DAO.insert(P object) |
Performs an INSERT statement for a given POJO
|
void |
DAO.insert(P... objects) |
Performs a batch INSERT statement for a given set of POJOs
|
int |
TableRecord.insert() |
Store this record to the database using an INSERT
statement.
|
int |
TableRecord.insert(java.util.Collection<? extends Field<?>> fields) |
Store parts of this record to the database using an INSERT
statement.
|
int |
TableRecord.insert(Field<?>... fields) |
Store parts of this record to the database using an INSERT
statement.
|
int |
UpdatableRecord.insert() |
Store this record back to the database using an INSERT
statement.
|
int |
UpdatableRecord.insert(java.util.Collection<? extends Field<?>> fields) |
Store parts of this record to the database using an INSERT
statement.
|
int |
UpdatableRecord.insert(Field<?>... fields) |
Store parts of this record to the database using an INSERT
statement.
|
java.util.Iterator<R> |
ResultQuery.iterator() |
|
java.math.BigInteger |
DSLContext.lastID() |
Retrieve the last inserted ID.
|
java.math.BigInteger |
DSLContext.nextval(java.lang.String sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
java.math.BigInteger |
DSLContext.nextval(Name sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends java.lang.Number>
T |
DSLContext.nextval(Sequence<T> sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
SelectJoinStep<R> |
SelectOnStep.onKey() |
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey(TableField<?,?>... keyFields) |
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
TableOnConditionStep<R> |
TableOnStep.onKey() |
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
TableOnConditionStep<R> |
TableOnStep.onKey(TableField<?,?>... keyFields) |
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
void |
UpdatableRecord.refresh() |
Refresh this record from the database.
|
void |
UpdatableRecord.refresh(java.util.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.
|
void |
ConnectionProvider.release(java.sql.Connection connection) |
Release a connection to the connection lifecycle handler.
|
void |
TransactionProvider.rollback(TransactionContext ctx) |
Rollback a transaction.
|
int |
UpdatableRecord.store() |
Store this record back to the database.
|
int |
UpdatableRecord.store(java.util.Collection<? extends Field<?>> fields) |
Store parts of this record to the database.
|
int |
UpdatableRecord.store(Field<?>... fields) |
Store parts of this record to the database.
|
java.util.stream.Stream<R> |
Cursor.stream() |
Turn this Cursor into a Stream.
|
java.util.stream.Stream<R> |
ResultQuery.stream() |
Stream this query.
|
void |
DAO.update(java.util.Collection<P> objects) |
Performs a batch UPDATE statement for a given set of POJOs
|
void |
DAO.update(P object) |
Performs an UPDATE statement for a given POJO
|
void |
DAO.update(P... objects) |
Performs a batch UPDATE statement for a given set of POJOs
|
int |
UpdatableRecord.update() |
Store this record back to the database using an UPDATE
statement.
|
int |
UpdatableRecord.update(java.util.Collection<? extends Field<?>> fields) |
Store parts of this record to the database using an UPDATE
statement.
|
int |
UpdatableRecord.update(Field<?>... fields) |
Store parts of this record to the database using an UPDATE
statement.
|
C |
Context.visit(QueryPart part) |
Visit a QueryPart in the current Context.
|