Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes
This package provides implementations for the jOOQ API from
org.jooq , whose interfaces are constructed mostly through the
Factory class, which hides implementation facts from
the public API |
org.jooq.util.h2 |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.H2 dialect |
org.jooq.util.hsqldb |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.HSQLDB dialect |
org.jooq.util.oracle |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.MYSQL dialect |
org.jooq.util.postgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.POSTGRES dialect |
Modifier and Type | Method and Description |
---|---|
Result<R> |
ResultQuery.fetch()
Execute the query and return the generated result
This is the same as calling
Query.execute() and then
ResultQuery.getResult()
The result and its contained records are attached to the original
Configuration by default. |
Result<R> |
InsertResultStep.fetch()
The result holding returned values as specified by the
InsertReturningStep
This currently only works well for DB2, HSQLDB, MySQL, and Postgres |
Result<R> |
Cursor.fetch()
Fetch all remaining records as a result.
|
Result<R> |
Cursor.fetch(int number)
Fetch the next couple of records from the cursor.
|
Result<Record> |
FactoryOperations.fetch(ResultSet rs)
|
Result<Record> |
FactoryOperations.fetch(String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
FactoryOperations.fetch(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
FactoryOperations.fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
FactoryOperations.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryOperations.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration by default. |
Result<Record> |
FactoryOperations.fetchFromCSV(String string)
Fetch all data from a CSV string.
|
Result<Record> |
FactoryOperations.fetchFromCSV(String string,
char delimiter)
Fetch all data from a CSV string.
|
<Z extends Record> |
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
Result<R> |
ResultQuery.getResult()
Return the result generated by a previous call to execute();
|
Result<R> |
InsertQuery.getReturnedRecords()
The records holding returned values as specified by any of the
InsertQuery.setReturning() methods. |
<Z extends Record> |
Result.into(Table<Z> table)
Map resulting records onto a custom record.
|
Result<?> |
ExecuteContext.result()
The last result that was fetched from the result set, or
null if no result has been fetched. |
Result<R> |
Result.sortAsc(Comparator<? super R> comparator)
Sort this result using a comparator that can compare records.
|
<T extends Comparable<? super T>> |
Result.sortAsc(Field<T> field)
Sort this result by one of its contained fields.
|
<T> Result<R> |
Result.sortAsc(Field<T> field,
Comparator<? super T> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortDesc(Comparator<? super R> comparator)
Reverse-sort this result using a comparator that can compare records.
|
<T extends Comparable<? super T>> |
Result.sortDesc(Field<T> field)
Reverse-sort this result by one of its contained fields.
|
<T> Result<R> |
Result.sortDesc(Field<T> field,
Comparator<? super T> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
Modifier and Type | Method and Description |
---|---|
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys)
Execute the query and return a
Map with the result grouped by the
given keys. |
<K> 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. |
List<Result<Record>> |
ResultQuery.fetchMany()
Execute a query, possibly returning several result sets.
|
List<Result<Record>> |
FactoryOperations.fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
sets
Example (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
List<Result<Record>> |
FactoryOperations.fetchMany(String sql,
Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
List<Result<Record>> |
FactoryOperations.fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Map<Record,Result<R>> |
Result.intoGroups(Field<?>[] keys)
Return a
Map with the result grouped by the given keys. |
<K> Map<K,Result<R>> |
Result.intoGroups(Field<K> key)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
Modifier and Type | Method and Description |
---|---|
void |
ExecuteContext.result(Result<?> result)
Calling this has no effect.
|
Modifier and Type | Field and Description |
---|---|
static SQLDataType<Result<Record>> |
SQLDataType.RESULT
The
ResultSet type
This is not a SQL or JDBC standard. |
Modifier and Type | Method and Description |
---|---|
Result<Record> |
FactoryProxy.fetch(ResultSet rs)
Deprecated.
|
Result<Record> |
Factory.fetch(ResultSet rs)
|
Result<Record> |
FactoryProxy.fetch(String sql)
Deprecated.
|
Result<Record> |
Factory.fetch(String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
FactoryProxy.fetch(String sql,
Object... bindings)
Deprecated.
|
Result<Record> |
Factory.fetch(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
FactoryProxy.fetch(String sql,
QueryPart... parts)
Deprecated.
|
Result<Record> |
Factory.fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
FactoryProxy.fetch(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table]
The result and its contained records are attached to this
Configuration by default. |
<R extends Record> |
FactoryProxy.fetch(Table<R> table,
Condition condition)
Deprecated.
|
<R extends Record> |
Factory.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition]
The result and its contained records are attached to this
Configuration by default. |
Result<Record> |
FactoryProxy.fetchFromCSV(String string)
Deprecated.
|
Result<Record> |
Factory.fetchFromCSV(String string)
Fetch all data from a CSV string.
|
Result<Record> |
FactoryProxy.fetchFromCSV(String string,
char delimiter)
Deprecated.
|
Result<Record> |
Factory.fetchFromCSV(String string,
char delimiter)
Fetch all data from a CSV string.
|
Modifier and Type | Method and Description |
---|---|
List<Result<Record>> |
FactoryProxy.fetchMany(String sql)
Deprecated.
|
List<Result<Record>> |
Factory.fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
sets
Example (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
List<Result<Record>> |
FactoryProxy.fetchMany(String sql,
Object... bindings)
Deprecated.
|
List<Result<Record>> |
Factory.fetchMany(String sql,
Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
List<Result<Record>> |
FactoryProxy.fetchMany(String sql,
QueryPart... parts)
Deprecated.
|
List<Result<Record>> |
Factory.fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Modifier and Type | Field and Description |
---|---|
protected static H2DataType<Result<Record>> |
H2DataType.__RESULT |
Modifier and Type | Field and Description |
---|---|
static HSQLDBDataType<Result<Record>> |
HSQLDBDataType.ROW |
Modifier and Type | Field and Description |
---|---|
static OracleDataType<Result<Record>> |
OracleDataType.REF_CURSOR |
Modifier and Type | Field and Description |
---|---|
static PostgresDataType<Result<Record>> |
PostgresDataType.REFCURSOR |
Copyright © 2013. All Rights Reserved.