@Nullable 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.
|
@NotNull Meta |
Meta.apply(String migration) |
Apply a migration to this meta to produce a new Meta. |
@NotNull Meta |
Meta.apply(Collection<? extends Query> migration) |
Apply a migration to this meta to produce a new Meta. |
@NotNull Meta |
Meta.apply(Queries migration) |
Apply a migration to this meta to produce a new Meta. |
@NotNull Meta |
Meta.apply(Query... migration) |
Apply a migration to this meta to produce a new Meta. |
void |
TransactionProvider.begin(TransactionContext ctx) |
Begin a new transaction.
|
@NotNull BindContext |
BindContext.bind(Collection<? extends QueryPart> parts) |
Deprecated.
|
@NotNull BindContext |
BindContext.bind(QueryPart part) |
Deprecated.
|
@NotNull BindContext |
BindContext.bind(QueryPart[] parts) |
Deprecated.
|
void |
QueryPartInternal.bind(BindContext ctx) |
Deprecated.
|
@NotNull BindContext |
BindContext.bindValue(Object value,
Class<?> type) |
Deprecated.
|
@NotNull BindContext |
Context.bindValue(Object value,
Field<?> field) |
Bind a value using a specific type.
|
@NotNull BindContext |
BindContext.bindValues(Object... values) |
Deprecated.
|
void |
Query.cancel() |
Cancel the underlying statement.
|
void |
CloseableDSLContext.close() |
Close the underlying resources, if any resources have been allocated when
constructing this DSLContext.
|
void |
Cursor.close() |
|
void |
Query.close() |
Close the underlying statement.
|
<X,A>
X |
Cursor.collect(Collector<? super R,A,X> collector) |
Reduce the execution results of this query using a Collector. |
<X,A>
X |
ResultQuery.collect(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.
|
@NotNull BigInteger |
DSLContext.currval(String sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
@NotNull BigInteger |
DSLContext.currval(Name sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends Number>
T |
DSLContext.currval(Sequence<T> sequence) |
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
@NotNull Queries |
Meta.ddl() |
Generate a creation script for the entire meta data.
|
@NotNull Queries |
Meta.ddl(DDLExportConfiguration configuration) |
Generate a creation script for the entire meta data.
|
void |
DAO.delete(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(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.
|
@org.jetbrains.annotations.NotNull int[] |
Batch.execute() |
Execute the batch operation.
|
int |
DSLContext.execute(String sql) |
Execute a query holding plain SQL.
|
int |
DSLContext.execute(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(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.
|
@NotNull Result<R> |
Cursor.fetch() |
Fetch all remaining records as a result.
|
@NotNull Result<R> |
Cursor.fetch(int number) |
Deprecated.
|
<E> @NotNull List<E> |
Cursor.fetch(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
<Z> @NotNull List<P> |
DAO.fetch(Field<Z> field,
Z... values) |
Find records by a given field and a set of values.
|
@NotNull Result<R> |
DeleteResultStep.fetch() |
|
@NotNull Result<Record> |
DSLContext.fetch(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(ResultSet rs) |
|
@NotNull Result<Record> |
DSLContext.fetch(ResultSet rs,
Class<?>... types) |
|
@NotNull Result<Record> |
DSLContext.fetch(ResultSet rs,
DataType<?>... types) |
|
@NotNull Result<Record> |
DSLContext.fetch(ResultSet rs,
Field<?>... fields) |
|
<R extends Record>
@NotNull Result<R> |
DSLContext.fetch(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
results. |
@NotNull Result<Record> |
DSLContext.fetch(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record>
@NotNull Result<R> |
DSLContext.fetch(Table<R> table) |
Execute and return all records for
|
<R extends Record>
@NotNull Result<R> |
DSLContext.fetch(Table<R> table,
Collection<? extends Condition> conditions) |
Execute and return all records for
|
<R extends Record>
@NotNull Result<R> |
DSLContext.fetch(Table<R> table,
Condition condition) |
Execute and return all records for
|
<R extends Record>
@NotNull Result<R> |
DSLContext.fetch(Table<R> table,
Condition... conditions) |
Execute and return all records for
|
@NotNull Result<R> |
InsertResultStep.fetch() |
|
@NotNull Result<R> |
ResultQuery.fetch() |
Execute the query and return the generated result.
|
@NotNull List<?> |
ResultQuery.fetch(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(int fieldIndex,
Class<? extends U> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull 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.
|
@NotNull List<?> |
ResultQuery.fetch(String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(String fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(Field<?> field,
Class<? extends U> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> @NotNull List<T> |
ResultQuery.fetch(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
@NotNull 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.
|
@NotNull List<?> |
ResultQuery.fetch(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull List<U> |
ResultQuery.fetch(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull 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> @NotNull List<E> |
ResultQuery.fetch(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
@NotNull 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,
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 on e record for
|
R |
ResultQuery.fetchAny() |
Execute the query and return at most one resulting record.
|
@Nullable Object |
ResultQuery.fetchAny(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchAny(int fieldIndex,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchAny(String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(String fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Field<?> field,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchAny(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Name fieldName,
Class<? extends U> 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.
|
@Nullable Object[] |
ResultQuery.fetchAnyArray() |
Execute the query and return at most one resulting record as an array
|
<E> E |
ResultQuery.fetchAnyInto(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.
|
@Nullable Map<String,Object> |
ResultQuery.fetchAnyMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
@NotNull R[] |
ResultQuery.fetchArray() |
Execute the query and return the generated result as an array of records.
|
@NotNull Object[] |
ResultQuery.fetchArray(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(int fieldIndex,
Class<? extends U> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(int fieldIndex,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field index from the
generated result.
|
@NotNull Object[] |
ResultQuery.fetchArray(String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(String fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(Field<?> field,
Class<? extends U> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> @NotNull T[] |
ResultQuery.fetchArray(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
@NotNull 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.
|
@NotNull Object[] |
ResultQuery.fetchArray(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull U[] |
ResultQuery.fetchArray(Name fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
@NotNull Object[][] |
ResultQuery.fetchArrays() |
Execute the query and return the generated result as an Object matrix.
|
<R extends TableRecord<R>>
@NotNull 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.
|
@NotNull Result<R> |
ForeignKey.fetchChildren(Collection<? extends O> records) |
Fetch child records of a given set of records through this foreign key
|
@NotNull Result<R> |
ForeignKey.fetchChildren(O record) |
Fetch child records of a given record through this foreign key
|
@NotNull Result<R> |
ForeignKey.fetchChildren(O... records) |
Fetch child records of a given set of records through this foreign key
|
<O extends TableRecord<O>>
@NotNull Result<O> |
Result.fetchChildren(ForeignKey<O,R> key) |
|
<O extends TableRecord<O>>
@NotNull 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,
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,
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.
|
@NotNull Result<Record> |
DSLContext.fetchFromCSV(String string) |
Fetch all data from a CSV string.
|
@NotNull Result<Record> |
DSLContext.fetchFromCSV(String string,
boolean header) |
Fetch all data from a CSV string.
|
@NotNull Result<Record> |
DSLContext.fetchFromCSV(String string,
boolean header,
char delimiter) |
Fetch all data from a CSV string.
|
@NotNull Result<Record> |
DSLContext.fetchFromCSV(String string,
char delimiter) |
Fetch all data from a CSV string.
|
@NotNull Result<Record> |
DSLContext.fetchFromHTML(String string) |
Convert an HTML table into a jOOQ Result. |
@NotNull Result<Record> |
DSLContext.fetchFromTXT(String string) |
Fetch all data from a formatted string.
|
@NotNull Result<Record> |
DSLContext.fetchFromTXT(String string,
String nullLiteral) |
Fetch all data from a formatted string.
|
@NotNull 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. |
@NotNull Map<Record,Result<R>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes) |
Execute the query and return a Map with the result grouped by the
given keys. |
@NotNull 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. |
@NotNull Map<?,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> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(int keyFieldIndex,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
<E> @NotNull Map<?,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. |
@NotNull Map<?,Result<R>> |
ResultQuery.fetchGroups(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. |
@NotNull Map<Record,Result<R>> |
ResultQuery.fetchGroups(String[] keyFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys. |
@NotNull Map<Record,Result<Record>> |
ResultQuery.fetchGroups(String[] keyFieldNames,
String[] valueFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys. |
<E> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(String keyFieldName,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
@NotNull Map<?,List<?>> |
ResultQuery.fetchGroups(String keyFieldName,
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> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(String keyFieldName,
RecordMapper<? super R,E> mapper) |
Return a Map with results grouped by the given key and mapped by
the given mapper. |
@NotNull Map<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys) |
Execute the query and return a Map with the result grouped by the
given keys. |
@NotNull 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> @NotNull 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>
@NotNull Map<K,List<E>> |
ResultQuery.fetchGroups(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>
@NotNull Map<K,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>
@NotNull Map<K,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. |
@NotNull 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. |
@NotNull Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames) |
Execute the query and return a Map with the result grouped by the
given keys. |
@NotNull 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> @NotNull Map<?,List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
Class<? extends E> type) |
Return a Map with results grouped by the given key and mapped
into the given entity type. |
@NotNull Map<?,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> @NotNull Map<?,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>
@NotNull 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>
@NotNull Map<S,List<E>> |
ResultQuery.fetchGroups(Table<S> table,
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>
@NotNull Map<S,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>
@NotNull 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> @NotNull List<E> |
Cursor.fetchInto(Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
@NotNull 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> @NotNull List<E> |
ResultQuery.fetchInto(Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
@NotNull Result<Z> |
ResultQuery.fetchInto(Table<Z> table) |
Map resulting records onto a custom record.
|
@NotNull FutureResult<R> |
ResultQuery.fetchLater() |
Deprecated.
|
@NotNull FutureResult<R> |
ResultQuery.fetchLater(ExecutorService executor) |
Deprecated.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql,
Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs) |
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Class<?>... types) |
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
DataType<?>... types) |
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Field<?>... fields) |
|
<R extends Record>
@NotNull Cursor<R> |
DSLContext.fetchLazy(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a cursor. |
@NotNull Cursor<Record> |
DSLContext.fetchLazy(SQL sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record>
@NotNull Cursor<R> |
DSLContext.fetchLazy(Table<R> table) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
Collection<? extends Condition> conditions) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
Condition condition) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Cursor<R> |
DSLContext.fetchLazy(Table<R> table,
Condition... conditions) |
Execute and return all records lazily for
|
@NotNull Cursor<R> |
ResultQuery.fetchLazy() |
Execute the query and "lazily" return the generated result.
|
@NotNull Cursor<R> |
ResultQuery.fetchLazy(int fetchSize) |
Deprecated.
|
@NotNull Results |
DSLContext.fetchMany(String sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
DSLContext.fetchMany(String sql,
Object... bindings) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
DSLContext.fetchMany(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
<R extends Record>
@NotNull Results |
DSLContext.fetchMany(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a cursor. |
@NotNull Results |
DSLContext.fetchMany(SQL sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
ResultQuery.fetchMany() |
Execute a query, possibly returning several result sets.
|
@NotNull 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. |
@NotNull 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. |
@NotNull 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> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(int[] keyFieldIndexes,
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> @NotNull Map<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. |
@NotNull 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> @NotNull Map<?,E> |
ResultQuery.fetchMap(int keyFieldIndex,
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> @NotNull 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> @NotNull 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>
@NotNull 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>
@NotNull 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. |
@NotNull Map<?,R> |
ResultQuery.fetchMap(String keyFieldName) |
Execute the query and return a Map with one of the result's
columns as key and the corresponding records as value. |
@NotNull Map<Record,R> |
ResultQuery.fetchMap(String[] keyFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(String[] keyFieldNames,
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. |
@NotNull Map<Record,Record> |
ResultQuery.fetchMap(String[] keyFieldNames,
String[] valueFieldNames) |
Execute the query and return a Map with keys as a map key and the
corresponding record as value. |
<E> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(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> @NotNull Map<?,E> |
ResultQuery.fetchMap(String keyFieldName,
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. |
@NotNull Map<?,?> |
ResultQuery.fetchMap(String keyFieldName,
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> @NotNull Map<?,E> |
ResultQuery.fetchMap(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. |
@NotNull 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> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(Field<?>[] keys,
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. |
@NotNull 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> @NotNull Map<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> @NotNull 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>
@NotNull Map<K,E> |
ResultQuery.fetchMap(Field<K> key,
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>
@NotNull 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>
@NotNull 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. |
@NotNull 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. |
@NotNull 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> @NotNull Map<List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
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. |
@NotNull 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> @NotNull Map<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> @NotNull Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
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. |
@NotNull 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> @NotNull 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> @NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull Map<S,E> |
ResultQuery.fetchMap(Table<S> table,
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>
@NotNull 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>
@NotNull 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. |
@NotNull List<Map<String,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.
|
@NotNull 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(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.
|
@NotNull Optional<R> |
Cursor.fetchNextOptional() |
Fetch the next record from the cursor.
|
<E> @NotNull Optional<E> |
Cursor.fetchNextOptional(RecordMapper<? super R,E> mapper) |
Fetch the next record into a custom mapper callback.
|
<E> @NotNull Optional<E> |
Cursor.fetchNextOptionalInto(Class<? extends E> type) |
Map the next resulting record onto a custom type.
|
<Z extends Record>
@NotNull 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() |
|
@Nullable Record |
DSLContext.fetchOne(String sql) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(ResultSet rs) |
|
@Nullable Record |
DSLContext.fetchOne(ResultSet rs,
Class<?>... types) |
|
@Nullable Record |
DSLContext.fetchOne(ResultSet rs,
DataType<?>... types) |
|
@Nullable Record |
DSLContext.fetchOne(ResultSet rs,
Field<?>... fields) |
|
<R extends Record>
R |
DSLContext.fetchOne(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a record. |
@Nullable 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,
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.
|
@Nullable Object |
ResultQuery.fetchOne(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchOne(int fieldIndex,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchOne(String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(String fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Field<?> field,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchOne(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Class<? extends U> 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() |
|
@Nullable 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(Class<? extends E> type) |
Deprecated.
|
<Z extends Record>
Z |
Cursor.fetchOneInto(Table<Z> table) |
Deprecated.
|
<E> E |
ResultQuery.fetchOneInto(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.
|
@Nullable Map<String,Object> |
ResultQuery.fetchOneMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
@NotNull Optional<R> |
Cursor.fetchOptional() |
Deprecated.
|
<E> @NotNull Optional<E> |
Cursor.fetchOptional(RecordMapper<? super R,E> mapper) |
Deprecated.
|
<Z> @NotNull Optional<P> |
DAO.fetchOptional(Field<Z> field,
Z value) |
Find a unique record by a given field and a value.
|
@NotNull Optional<R> |
DeleteResultStep.fetchOptional() |
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(ResultSet rs) |
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Class<?>... types) |
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
DataType<?>... types) |
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(ResultSet rs,
Field<?>... fields) |
|
<R extends Record>
@NotNull Optional<R> |
DSLContext.fetchOptional(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a record. |
@NotNull Optional<Record> |
DSLContext.fetchOptional(SQL sql) |
Execute a new query holding plain SQL.
|
<R extends Record>
@NotNull Optional<R> |
DSLContext.fetchOptional(Table<R> table) |
Execute and return zero or one record for
|
<R extends Record>
@NotNull Optional<R> |
DSLContext.fetchOptional(Table<R> table,
Collection<? extends Condition> conditions) |
Execute and return zero or one record for
|
<R extends Record>
@NotNull Optional<R> |
DSLContext.fetchOptional(Table<R> table,
Condition condition) |
Execute and return zero or one record for
|
<R extends Record>
@NotNull Optional<R> |
DSLContext.fetchOptional(Table<R> table,
Condition... conditions) |
Execute and return zero or one record for
|
@NotNull Optional<R> |
InsertResultStep.fetchOptional() |
|
@NotNull Optional<R> |
ResultQuery.fetchOptional() |
Execute the query and return at most one resulting record.
|
@NotNull Optional<?> |
ResultQuery.fetchOptional(int fieldIndex) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(int fieldIndex,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field index from the generated result.
|
<U> @NotNull 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.
|
@NotNull Optional<?> |
ResultQuery.fetchOptional(String fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(String fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(Field<?> field,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field from the generated result.
|
<T> @NotNull 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>
@NotNull 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.
|
@NotNull Optional<?> |
ResultQuery.fetchOptional(Name fieldName) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Class<? extends U> type) |
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> @NotNull 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> @NotNull Optional<E> |
ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper) |
Execute the query and return at most one resulting value into a
custom mapper callback.
|
@NotNull Optional<R> |
UpdateResultStep.fetchOptional() |
|
@NotNull Optional<Object[]> |
ResultQuery.fetchOptionalArray() |
Execute the query and return at most one resulting record as an array.
|
<E> @NotNull Optional<E> |
Cursor.fetchOptionalInto(Class<? extends E> type) |
Deprecated.
|
<Z extends Record>
@NotNull Optional<Z> |
Cursor.fetchOptionalInto(Table<Z> table) |
Deprecated.
|
<E> @NotNull Optional<E> |
ResultQuery.fetchOptionalInto(Class<? extends E> type) |
Map resulting records onto a custom type.
|
<Z extends Record>
@NotNull Optional<Z> |
ResultQuery.fetchOptionalInto(Table<Z> table) |
Map resulting records onto a custom record.
|
@NotNull Optional<Map<String,Object>> |
ResultQuery.fetchOptionalMap() |
Execute the query and return at most one resulting record as a name/value
map.
|
@NotNull Optional<?> |
DSLContext.fetchOptionalValue(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Optional<?> |
DSLContext.fetchOptionalValue(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Optional<?> |
DSLContext.fetchOptionalValue(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Optional<?> |
DSLContext.fetchOptionalValue(ResultSet rs) |
Fetch a record from a JDBC ResultSet and return the only
contained value. |
<T> @NotNull Optional<T> |
DSLContext.fetchOptionalValue(ResultSet rs,
Class<T> type) |
Fetch a record from a JDBC ResultSet and return the only
contained value. |
<T> @NotNull Optional<T> |
DSLContext.fetchOptionalValue(ResultSet rs,
DataType<T> type) |
Fetch a record from a JDBC ResultSet and return the only
contained value. |
<T> @NotNull 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>>
@NotNull Optional<T> |
DSLContext.fetchOptionalValue(ResultQuery<R> query) |
Execute a ResultQuery in the context of this
DSLContext and return a single value. |
@NotNull Optional<?> |
DSLContext.fetchOptionalValue(SQL sql) |
Execute a new query holding plain SQL.
|
<T> @NotNull 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.
|
@NotNull Result<O> |
ForeignKey.fetchParents(Collection<? extends R> records) |
Fetch parent records of a given set of record through this foreign key
|
@NotNull Result<O> |
ForeignKey.fetchParents(R... records) |
Fetch parent records of a given set of record through this foreign key
|
<O extends UpdatableRecord<O>>
@NotNull Result<O> |
Result.fetchParents(ForeignKey<R,O> key) |
|
<Z> @NotNull List<P> |
DAO.fetchRange(Field<Z> field,
Z lowerInclusive,
Z upperInclusive) |
Find records by a given field and a range of values.
|
@NotNull ResultSet |
ResultQuery.fetchResultSet() |
Execute the query and return the generated result as a JDBC
ResultSet. |
@NotNull Set<?> |
ResultQuery.fetchSet(int fieldIndex) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(int fieldIndex,
Class<? extends U> type) |
Execute the query and return all values for a field index from the
generated result.
|
<U> @NotNull 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.
|
@NotNull Set<?> |
ResultQuery.fetchSet(String fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(String fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(Field<?> field,
Class<? extends U> type) |
Execute the query and return all values for a field from the generated
result.
|
<T> @NotNull Set<T> |
ResultQuery.fetchSet(Field<T> field) |
Execute the query and return all values for a field from the generated
result.
|
<T,U>
@NotNull 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.
|
@NotNull Set<?> |
ResultQuery.fetchSet(Name fieldName) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull Set<U> |
ResultQuery.fetchSet(Name fieldName,
Class<? extends U> type) |
Execute the query and return all values for a field name from the
generated result.
|
<U> @NotNull 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> @NotNull Set<E> |
ResultQuery.fetchSet(RecordMapper<? super R,E> mapper) |
Fetch results into a custom mapper callback.
|
@NotNull Record |
DSLContext.fetchSingle(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Record |
DSLContext.fetchSingle(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Record |
DSLContext.fetchSingle(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Record |
DSLContext.fetchSingle(ResultSet rs) |
|
@NotNull Record |
DSLContext.fetchSingle(ResultSet rs,
Class<?>... types) |
|
@NotNull Record |
DSLContext.fetchSingle(ResultSet rs,
DataType<?>... types) |
|
@NotNull Record |
DSLContext.fetchSingle(ResultSet rs,
Field<?>... fields) |
|
@NotNull Record |
DSLContext.fetchSingle(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. |
@NotNull Record |
DSLContext.fetchSingle(SelectField<?>... fields) |
Execute and return exactly one record for
|
<T1> @NotNull Record1<T1> |
DSLContext.fetchSingle(SelectField<T1> field1) |
Execute and return exactly one record for
|
<T1,T2>
@NotNull Record2<T1,T2> |
DSLContext.fetchSingle(SelectField<T1> field1,
SelectField<T2> field2) |
Execute and return exactly one record for
|
<T1,T2,T3>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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
|
@NotNull 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,
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.
|
@Nullable Object |
ResultQuery.fetchSingle(int fieldIndex) |
Execute the query and return exactly one resulting value for a field
index from the generated result.
|
<U> U |
ResultQuery.fetchSingle(int fieldIndex,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchSingle(String fieldName) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(String fieldName,
Class<? extends U> type) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(String fieldName,
Converter<?,? extends U> converter) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(Field<?> field,
Class<? extends U> 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.
|
@Nullable Object |
ResultQuery.fetchSingle(Name fieldName) |
Execute the query and return exactly one resulting value for a field name
from the generated result.
|
<U> U |
ResultQuery.fetchSingle(Name fieldName,
Class<? extends U> 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.
|
@NotNull Object[] |
ResultQuery.fetchSingleArray() |
Execute the query and return exactly one resulting record as an array
|
<E> E |
ResultQuery.fetchSingleInto(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.
|
@NotNull Map<String,Object> |
ResultQuery.fetchSingleMap() |
Execute the query and return exactly one resulting record as a name/value
map.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql,
Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(ResultSet rs) |
|
@NotNull Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
Class<?>... types) |
|
@NotNull Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
DataType<?>... types) |
|
@NotNull Stream<Record> |
DSLContext.fetchStream(ResultSet rs,
Field<?>... fields) |
|
<R extends Record>
@NotNull Stream<R> |
DSLContext.fetchStream(ResultQuery<R> query) |
Execute a ResultQuery in the context of this DSLContext and return
a stream. |
@NotNull Stream<Record> |
DSLContext.fetchStream(SQL sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record>
@NotNull Stream<R> |
DSLContext.fetchStream(Table<R> table) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Stream<R> |
DSLContext.fetchStream(Table<R> table,
Collection<? extends Condition> conditions) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Stream<R> |
DSLContext.fetchStream(Table<R> table,
Condition condition) |
Execute and return all records lazily for
|
<R extends Record>
@NotNull Stream<R> |
DSLContext.fetchStream(Table<R> table,
Condition... conditions) |
Execute and return all records lazily for
|
@NotNull Stream<R> |
ResultQuery.fetchStream() |
Stream this query.
|
<E> @NotNull Stream<E> |
ResultQuery.fetchStreamInto(Class<? extends E> type) |
Stream this query, mapping records into a custom type.
|
<Z extends Record>
@NotNull Stream<Z> |
ResultQuery.fetchStreamInto(Table<Z> table) |
Stream this query, mapping records into a custom record.
|
@Nullable Object |
DSLContext.fetchValue(String sql) |
Execute a new query holding plain SQL.
|
@Nullable Object |
DSLContext.fetchValue(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@Nullable Object |
DSLContext.fetchValue(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@Nullable 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. |
<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. |
@Nullable 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. |
@NotNull List<?> |
DSLContext.fetchValues(String sql) |
Execute a new query holding plain SQL.
|
@NotNull List<?> |
DSLContext.fetchValues(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull List<?> |
DSLContext.fetchValues(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull List<?> |
DSLContext.fetchValues(ResultSet rs) |
Fetch a result from a JDBC ResultSet and return the only
contained column's values. |
<T> @NotNull 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> @NotNull 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> @NotNull List<T> |
DSLContext.fetchValues(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>>
@NotNull List<T> |
DSLContext.fetchValues(ResultQuery<R> query) |
Execute a ResultQuery in the context of this
DSLContext and return all values for the only column. |
@NotNull List<?> |
DSLContext.fetchValues(SQL sql) |
Execute a new query holding plain SQL.
|
<T> @NotNull List<T> |
DSLContext.fetchValues(Table<? extends Record1<T>> table) |
Fetch all values from a single column table.
|
<T> @NotNull List<T> |
DSLContext.fetchValues(TableField<?,T> field) |
|
@NotNull 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.
|
@NotNull Catalog |
Meta.getCatalog(String name) |
Get a catalog object by name from the underlying meta data source, or
null if no such object exists.
|
@NotNull Catalog |
Meta.getCatalog(Name name) |
Get a catalog object by name from the underlying meta data source, or
null if no such object exists.
|
@NotNull List<Catalog> |
Meta.getCatalogs() |
Get all catalog objects from the underlying meta data source.
|
@NotNull List<Domain<?>> |
Meta.getDomains() |
Get all domain objects from the underlying meta data source.
|
@NotNull List<Domain<?>> |
Meta.getDomains(String name) |
Get all domain objects by name from the underlying meta data source.
|
@NotNull List<Domain<?>> |
Meta.getDomains(Name name) |
Get all domain objects by name from the underlying meta data source.
|
@NotNull List<Index> |
Meta.getIndexes() |
Get all indexes from the underlying meta data sources.
|
@NotNull List<UniqueKey<?>> |
Meta.getPrimaryKeys() |
Get all primary keys from the underlying meta data source.
|
@NotNull List<Schema> |
Meta.getSchemas() |
Get all schema objects from the underlying meta data source.
|
@NotNull List<Schema> |
Meta.getSchemas(String name) |
Get all schema objects by name from the underlying meta data source.
|
@NotNull List<Schema> |
Meta.getSchemas(Name name) |
Get all schema objects by name from the underlying meta data source.
|
@NotNull List<Sequence<?>> |
Meta.getSequences() |
Get all sequence objects from the underlying meta data source.
|
@NotNull List<Sequence<?>> |
Meta.getSequences(String name) |
Get all sequence objects by name from the underlying meta data source.
|
@NotNull List<Sequence<?>> |
Meta.getSequences(Name name) |
Get all sequence objects by name from the underlying meta data source.
|
@NotNull List<Table<?>> |
Meta.getTables() |
Get all table objects from the underlying meta data source.
|
@NotNull List<Table<?>> |
Meta.getTables(String name) |
Get all table objects by name from the underlying meta data source.
|
@NotNull 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.
|
@NotNull InformationSchema |
Meta.informationSchema() |
|
void |
DAO.insert(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(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(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.
|
@NotNull Iterator<R> |
ResultQuery.iterator() |
|
@NotNull BigInteger |
DSLContext.lastID() |
Retrieve the last inserted ID.
|
void |
DAO.merge(Collection<P> objects) |
Performs a batch MERGE statement for a given set of POJOs.
|
void |
DAO.merge(P object) |
Performs an MERGE statement for a given POJO.
|
void |
DAO.merge(P... objects) |
Performs a batch MERGE statement for a given set of POJOs.
|
int |
UpdatableRecord.merge() |
Store this record back to the database using a MERGE
statement.
|
int |
UpdatableRecord.merge(Collection<? extends Field<?>> fields) |
Store parts of this record to the database using a MERGE
statement.
|
int |
UpdatableRecord.merge(Field<?>... fields) |
Store parts of this record to the database using a MERGE
statement.
|
@NotNull Queries |
Meta.migrateTo(Meta other) |
Generate a migration script to get from this meta data to another one.
|
@NotNull Queries |
Meta.migrateTo(Meta other,
MigrationConfiguration configuration) |
Generate a migration script to get from this meta data to another one.
|
@NotNull BigInteger |
DSLContext.nextval(String sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
@NotNull BigInteger |
DSLContext.nextval(Name sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends Number>
T |
DSLContext.nextval(Sequence<T> sequence) |
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends Number>
@NotNull List<T> |
DSLContext.nextvals(Sequence<T> sequence,
int size) |
Convenience method to fetch several NEXTVAL for a sequence directly from
this DSLContext's underlying JDBC Connection. |
@NotNull SelectJoinStep<R> |
SelectOnStep.onKey() |
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
@NotNull SelectJoinStep<R> |
SelectOnStep.onKey(TableField<?,?>... keyFields) |
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
@NotNull TableOnConditionStep<R> |
TableOnStep.onKey() |
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
@NotNull 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(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(Connection connection) |
Release a connection to the connection lifecycle handler.
|
void |
TransactionProvider.rollback(TransactionContext ctx) |
Rollback a transaction.
|
@NotNull Meta |
Meta.snapshot() |
Eager-create an in-memory copy of this Meta instance without any
connection to the original data source. |
int |
UpdatableRecord.store() |
Store this record back to the database.
|
int |
UpdatableRecord.store(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.
|
@NotNull Stream<R> |
Cursor.stream() |
Turn this Cursor into a Stream. |
@NotNull Stream<R> |
ResultQuery.stream() |
Stream this query.
|
void |
DAO.update(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(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.
|