| Package | Description | 
|---|---|
| org.jooq | 
 The  
org.jooq package contains jOOQ's public API. | 
| Modifier and Type | Method and Description | 
|---|---|
<O extends TableRecord<O>> | 
UpdatableRecord.fetchChild(ForeignKey<O,R> key)
Fetch a child record of this record, given a foreign key. 
 | 
R | 
ResultQuery.fetchOne()
Execute the query and return at most one resulting record. 
 | 
<T> T | 
ResultQuery.fetchOne(Field<?> field,
        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. 
 | 
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,
        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. 
 | 
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,
        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 extends Record> | 
DSLContext.fetchOne(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a record. | 
Record | 
DSLContext.fetchOne(ResultSet rs)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        Class<?>... types)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        DataType<?>... types)
 | 
Record | 
DSLContext.fetchOne(ResultSet rs,
        Field<?>... fields)
 | 
Record | 
DSLContext.fetchOne(SQL sql)
Execute a new query holding plain SQL. 
 | 
Object | 
ResultQuery.fetchOne(String fieldName)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
Record | 
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL. 
 | 
<T> T | 
ResultQuery.fetchOne(String fieldName,
        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(String fieldName,
        Converter<?,? extends U> converter)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
Record | 
DSLContext.fetchOne(String sql,
        Object... bindings)
Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(String sql,
        QueryPart... parts)
Execute a new query holding plain SQL. 
 | 
<R extends Record> | 
DSLContext.fetchOne(Table<R> table)
Execute and return zero or one record for
  
SELECT * FROM [table]. | 
<R extends Record> | 
DSLContext.fetchOne(Table<R> table,
        Condition condition)
Execute and return zero or one record for
  
SELECT * FROM [table] WHERE [condition] . | 
Object[] | 
ResultQuery.fetchOneArray()
Execute the query and return at most one resulting record as an array
 
 You can access data like this
  
query.fetchOneArray()[fieldIndex] | 
<E> E | 
ResultQuery.fetchOneInto(Class<? extends E> type)
Map resulting records onto a custom type. 
 | 
<Z extends Record> | 
ResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
Map<String,Object> | 
ResultQuery.fetchOneMap()
Execute the query and return at most one resulting record as a name/value
 map. 
 | 
Optional<R> | 
ResultQuery.fetchOptional()
Execute the query and return at most one resulting record. 
 | 
<T> Optional<T> | 
ResultQuery.fetchOptional(Field<?> field,
             Class<? extends T> type)
Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
<T> 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> 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. 
 | 
Optional<?> | 
ResultQuery.fetchOptional(int fieldIndex)
Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<T> Optional<T> | 
ResultQuery.fetchOptional(int fieldIndex,
             Class<? extends T> type)
Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<U> 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. 
 | 
Optional<?> | 
ResultQuery.fetchOptional(Name fieldName)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> Optional<T> | 
ResultQuery.fetchOptional(Name fieldName,
             Class<? extends T> type)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> 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> Optional<E> | 
ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper)
Execute the query and return at most one resulting value into a
 custom mapper callback. 
 | 
<R extends Record> | 
DSLContext.fetchOptional(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this DSLContext and return
 a record. | 
Optional<Record> | 
DSLContext.fetchOptional(ResultSet rs)
 | 
Optional<Record> | 
DSLContext.fetchOptional(ResultSet rs,
             Class<?>... types)
 | 
Optional<Record> | 
DSLContext.fetchOptional(ResultSet rs,
             DataType<?>... types)
 | 
Optional<Record> | 
DSLContext.fetchOptional(ResultSet rs,
             Field<?>... fields)
 | 
Optional<Record> | 
DSLContext.fetchOptional(SQL sql)
Execute a new query holding plain SQL. 
 | 
Optional<?> | 
ResultQuery.fetchOptional(String fieldName)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
Optional<Record> | 
DSLContext.fetchOptional(String sql)
Execute a new query holding plain SQL. 
 | 
<T> Optional<T> | 
ResultQuery.fetchOptional(String fieldName,
             Class<? extends T> type)
Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> 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. 
 | 
Optional<Record> | 
DSLContext.fetchOptional(String sql,
             Object... bindings)
Execute a new query holding plain SQL. 
 | 
Optional<Record> | 
DSLContext.fetchOptional(String sql,
             QueryPart... parts)
Execute a new query holding plain SQL. 
 | 
<R extends Record> | 
DSLContext.fetchOptional(Table<R> table)
Execute and return zero or one record for
  
SELECT * FROM [table]. | 
<R extends Record> | 
DSLContext.fetchOptional(Table<R> table,
             Condition condition)
Execute and return zero or one record for
  
SELECT * FROM [table] WHERE [condition] . | 
Optional<Object[]> | 
ResultQuery.fetchOptionalArray()
Execute the query and return at most one resulting record as an array. 
 | 
<E> Optional<E> | 
ResultQuery.fetchOptionalInto(Class<? extends E> type)
Map resulting records onto a custom type. 
 | 
<Z extends Record> | 
ResultQuery.fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record. 
 | 
Optional<Map<String,Object>> | 
ResultQuery.fetchOptionalMap()
Execute the query and return at most one resulting record as a name/value
 map. 
 | 
<T,R extends Record1<T>> | 
DSLContext.fetchOptionalValue(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this
 DSLContext and return a single value. | 
Optional<?> | 
DSLContext.fetchOptionalValue(ResultSet rs)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> Optional<T> | 
DSLContext.fetchOptionalValue(ResultSet rs,
                  Class<T> type)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> Optional<T> | 
DSLContext.fetchOptionalValue(ResultSet rs,
                  DataType<T> type)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> Optional<T> | 
DSLContext.fetchOptionalValue(ResultSet rs,
                  Field<T> field)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
Optional<?> | 
DSLContext.fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL. 
 | 
Optional<?> | 
DSLContext.fetchOptionalValue(String sql)
Execute a new query holding plain SQL. 
 | 
Optional<?> | 
DSLContext.fetchOptionalValue(String sql,
                  Object... bindings)
Execute a new query holding plain SQL. 
 | 
Optional<?> | 
DSLContext.fetchOptionalValue(String sql,
                  QueryPart... parts)
Execute a new query holding plain SQL. 
 | 
<T> Optional<T> | 
DSLContext.fetchOptionalValue(TableField<?,T> field)
Execute a  
ResultQuery in the context of this
 DSLContext and return a single value. | 
<T,R extends Record1<T>> | 
DSLContext.fetchValue(ResultQuery<R> query)
Execute a  
ResultQuery in the context of this
 DSLContext and return a single value. | 
Object | 
DSLContext.fetchValue(ResultSet rs)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> T | 
DSLContext.fetchValue(ResultSet rs,
          Class<T> type)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> T | 
DSLContext.fetchValue(ResultSet rs,
          DataType<T> type)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
<T> T | 
DSLContext.fetchValue(ResultSet rs,
          Field<T> field)
Fetch a record from a JDBC  
ResultSet and return the only
 contained value. | 
Object | 
DSLContext.fetchValue(SQL sql)
Execute a new query holding plain SQL. 
 | 
Object | 
DSLContext.fetchValue(String sql)
Execute a new query holding plain SQL. 
 | 
Object | 
DSLContext.fetchValue(String sql,
          Object... bindings)
Execute a new query holding plain SQL. 
 | 
Object | 
DSLContext.fetchValue(String sql,
          QueryPart... parts)
Execute a new query holding plain SQL. 
 | 
<T> T | 
DSLContext.fetchValue(TableField<?,T> field)
Execute a  
ResultQuery in the context of this
 DSLContext and return a single value. | 
Copyright © 2017. All Rights Reserved.