|
|||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Result | |
---|---|
org.jooq | |
org.jooq.impl | |
org.jooq.util.h2 | |
org.jooq.util.hsqldb | |
org.jooq.util.oracle | |
org.jooq.util.postgres |
Uses of Result in org.jooq |
---|
Methods in org.jooq that return Result | ||
---|---|---|
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)
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result . |
|
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. |
|
|
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. |
|
|
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. |
|
|
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom 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. |
|
|
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. |
|
|
Result.sortAsc(Field<T> field)
Sort this result by one of its contained fields. |
|
|
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. |
|
|
Result.sortDesc(Field<T> field)
Reverse-sort this result by one of its contained fields. |
|
|
Result.sortDesc(Field<T> field,
Comparator<? super T> comparator)
Reverse-sort this result by one of its contained fields using a comparator. |
Methods in org.jooq that return types with arguments of type Result | ||
---|---|---|
|
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. |
|
|
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. |
Methods in org.jooq with parameters of type Result | |
---|---|
void |
ExecuteContext.result(Result<?> result)
Calling this has no effect. |
Uses of Result in org.jooq.impl |
---|
Fields in org.jooq.impl with type parameters of type Result | |
---|---|
static SQLDataType<Result<Record>> |
SQLDataType.RESULT
The ResultSet type
This is not a SQL or JDBC standard. |
Methods in org.jooq.impl that return Result | ||
---|---|---|
Result<Record> |
FactoryProxy.fetch(ResultSet rs)
Deprecated. |
|
Result<Record> |
Factory.fetch(ResultSet rs)
Fetch all data from a JDBC ResultSet and transform it to a jOOQ
Result . |
|
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. |
|
|
FactoryProxy.fetch(Table<R> table)
Deprecated. |
|
|
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. |
|
|
FactoryProxy.fetch(Table<R> table,
Condition condition)
Deprecated. |
|
|
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. |
Methods in org.jooq.impl that return types with arguments of type Result | |
---|---|
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. |
Uses of Result in org.jooq.util.h2 |
---|
Fields in org.jooq.util.h2 with type parameters of type Result | |
---|---|
protected static H2DataType<Result<Record>> |
H2DataType.__RESULT
|
Uses of Result in org.jooq.util.hsqldb |
---|
Fields in org.jooq.util.hsqldb with type parameters of type Result | |
---|---|
static HSQLDBDataType<Result<Record>> |
HSQLDBDataType.ROW
|
Uses of Result in org.jooq.util.oracle |
---|
Fields in org.jooq.util.oracle with type parameters of type Result | |
---|---|
static OracleDataType<Result<Record>> |
OracleDataType.REF_CURSOR
|
Uses of Result in org.jooq.util.postgres |
---|
Fields in org.jooq.util.postgres with type parameters of type Result | |
---|---|
static PostgresDataType<Result<Record>> |
PostgresDataType.REFCURSOR
|
|
|||||||||
PREV NEXT | FRAMES NO FRAMES |