<O extends TableRecord<O>> O |
UpdatableRecord.fetchChild(ForeignKey<O,R> key) |
Fetch a child record of this record, given a foreign key.
|
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
|
<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> |
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> |
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.
|
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 .
|
<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(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.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,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.
|