Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
org.jooq.tools.jdbc |
The
org.jooq.tools.jdbc package contains compatibility classes
to bridge between JDBC 4.0 and JDBC 4.1. |
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.ORACLE dialect. |
org.jooq.util.postgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.POSTGRES dialect. |
org.jooq.util.redshift |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.REDSHIFT dialect. |
org.jooq.util.vertica |
Modifier and Type | Method and Description |
---|---|
Result<R> |
UpdateResultStep.fetch()
The result holding returned values as specified by the
UpdateReturningStep . |
Result<R> |
ResultQuery.fetch()
Execute the query and return the generated result.
|
Result<R> |
InsertResultStep.fetch()
The result holding returned values as specified by the
InsertReturningStep . |
Result<R> |
DeleteResultStep.fetch()
The result holding returned values as specified by the
DeleteReturningStep . |
Result<R> |
Cursor.fetch()
Fetch all remaining records as a result.
|
Result<R> |
Cursor.fetch(int number)
Deprecated.
- 3.10 - [#6363] - Use
Cursor.fetchNext(int) instead. |
<R extends Record> |
DSLContext.fetch(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
results. |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs)
Fetch all data from a JDBC
ResultSet and transform it to a jOOQ
Result . |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
java.lang.Class<?>... types)
Fetch all data from a JDBC
ResultSet and transform it to a jOOQ
Result . |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
DataType<?>... types)
Fetch all data from a JDBC
ResultSet and transform it to a jOOQ
Result . |
Result<Record> |
DSLContext.fetch(java.sql.ResultSet rs,
Field<?>... fields)
Fetch all data from a JDBC
ResultSet and transform it to a jOOQ
Result . |
Result<Record> |
DSLContext.fetch(SQL sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
java.lang.Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
DSLContext.fetch(java.lang.String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
DSLContext.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition] . |
<R extends TableRecord<R>> |
DSLContext.fetchByExample(R example)
Execute a "Query by Example" (QBE) based on an example record.
|
Result<R> |
ForeignKey.fetchChildren(java.util.Collection<? extends O> records)
Fetch child records of a given set of records through this foreign key
This returns childs record referencing any record in a given set of
records through this foreign key
|
<O extends TableRecord<O>> |
UpdatableRecord.fetchChildren(ForeignKey<O,R> key)
Fetch child records of this record, given a foreign key.
|
<O extends TableRecord<O>> |
Result.fetchChildren(ForeignKey<O,R> key)
Fetch child records of this record, given a foreign key.
|
Result<R> |
ForeignKey.fetchChildren(O... records)
Fetch child records of a given set of records through this foreign key
This returns childs record referencing any record in a given set of
records through this foreign key
|
Result<R> |
ForeignKey.fetchChildren(O record)
Fetch child records of a given record through this foreign key
This returns childs record referencing a given record through this
foreign key
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
boolean header)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
boolean header,
char delimiter)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromCSV(java.lang.String string,
char delimiter)
Fetch all data from a CSV string.
|
Result<Record> |
DSLContext.fetchFromHTML(java.lang.String string)
Convert an HTML table into a jOOQ
Result . |
Result<Record> |
DSLContext.fetchFromJSON(java.lang.String string)
Fetch all data from a JSON string.
|
Result<Record> |
DSLContext.fetchFromStringData(java.util.List<java.lang.String[]> data)
Fetch all data from a list of strings.
|
Result<Record> |
DSLContext.fetchFromStringData(java.util.List<java.lang.String[]> data,
boolean header)
Fetch all data from a list of strings.
|
Result<Record> |
DSLContext.fetchFromStringData(java.lang.String[]... data)
Fetch all data from a list of strings.
|
Result<Record> |
DSLContext.fetchFromTXT(java.lang.String string)
Fetch all data from a formatted string.
|
Result<Record> |
DSLContext.fetchFromTXT(java.lang.String string,
java.lang.String nullLiteral)
Fetch all data from a formatted 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> |
Cursor.fetchNext(int number)
Fetch the next couple of records from the cursor.
|
Result<O> |
ForeignKey.fetchParents(java.util.Collection<? extends R> records)
Fetch parent records of a given set of record through this foreign key
This returns parent records referenced by any record in a given set of
records through this foreign key.
|
<O extends UpdatableRecord<O>> |
Result.fetchParents(ForeignKey<R,O> key)
Fetch parent records of this record, given a foreign key.
|
Result<O> |
ForeignKey.fetchParents(R... records)
Fetch parent records of a given set of record through this foreign key
This returns parent records referenced by any record in a given set of
records through this foreign key.
|
Result<R> |
ResultQuery.getResult()
Return the result generated by a previous call to execute().
|
Result<R> |
UpdateQuery.getReturnedRecords()
The records holding returned values as specified by any of the
StoreQuery.setReturning() methods. |
Result<R> |
StoreQuery.getReturnedRecords()
The records holding returned values as specified by any of the
StoreQuery.setReturning() methods. |
Result<R> |
InsertQuery.getReturnedRecords()
The records holding returned values as specified by any of the
StoreQuery.setReturning() methods. |
Result<R> |
DeleteQuery.getReturnedRecords()
The records holding returned values as specified by any of the
DeleteQuery.setReturning() methods. |
Result<R> |
Result.intern(Field<?>... fields)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Result<R> |
Result.intern(int... fieldIndexes)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Result<R> |
Result.intern(Name... fieldNames)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Result<R> |
Result.intern(java.lang.String... fieldNames)
Deprecated.
- 3.10 - [#6254] - This functionality is no longer supported
and will be removed in 4.0
|
Result<Record> |
Result.into(Field<?>... fields)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1> Result<Record1<T1>> |
Result.into(Field<T1> field1)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2> Result<Record2<T1,T2>> |
Result.into(Field<T1> field1,
Field<T2> field2)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
Result.into(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Copy all records from this result into a new result with new records
holding only a subset of the previous fields.
|
<Z extends Record> |
Result.into(Table<Z> table)
Map resulting records onto a custom record.
|
Result<Record> |
DSLContext.newResult(Field<?>... fields)
Create a new empty
Record . |
<T1> Result<Record1<T1>> |
DSLContext.newResult(Field<T1> field1)
Create a new empty
Result . |
<T1,T2> Result<Record2<T1,T2>> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2)
Create a new empty
Result . |
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new empty
Result . |
<T1,T2,T3,T4> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new empty
Result . |
<T1,T2,T3,T4,T5> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new empty
Result . |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
DSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new empty
Result . |
<R extends Record> |
DSLContext.newResult(Table<R> table)
Create a new empty
Result . |
Result<Record> |
ResultOrRows.result()
The result or
null if there was no result. |
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(java.util.Comparator<? super R> comparator)
Sort this result using a comparator that can compare records.
|
<T extends java.lang.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,
java.util.Comparator<? super T> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortAsc(int fieldIndex)
Sort this result by one of its contained fields.
|
Result<R> |
Result.sortAsc(int fieldIndex,
java.util.Comparator<?> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortAsc(Name fieldName)
Sort this result by one of its contained fields.
|
Result<R> |
Result.sortAsc(Name fieldName,
java.util.Comparator<?> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortAsc(java.lang.String fieldName)
Sort this result by one of its contained fields.
|
Result<R> |
Result.sortAsc(java.lang.String fieldName,
java.util.Comparator<?> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortDesc(java.util.Comparator<? super R> comparator)
Reverse-sort this result using a comparator that can compare records.
|
<T extends java.lang.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,
java.util.Comparator<? super T> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
Result<R> |
Result.sortDesc(int fieldIndex)
Reverse-sort this result by one of its contained fields.
|
Result<R> |
Result.sortDesc(int fieldIndex,
java.util.Comparator<?> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
Result<R> |
Result.sortDesc(Name fieldName)
Reverse-sort this result by one of its contained fields.
|
Result<R> |
Result.sortDesc(Name fieldName,
java.util.Comparator<?> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
Result<R> |
Result.sortDesc(java.lang.String fieldName)
Reverse-sort this result by one of its contained fields.
|
Result<R> |
Result.sortDesc(java.lang.String fieldName,
java.util.Comparator<?> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
Modifier and Type | Method and Description |
---|---|
java.util.concurrent.CompletionStage<Result<R>> |
ResultQuery.fetchAsync()
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<R>> |
ResultQuery.fetchAsync(java.util.concurrent.Executor executor)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
<R extends Record> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
ResultQuery<R> query)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
java.lang.Class<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
SQL sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
java.lang.Object... bindings)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
<R extends Record> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchAsync(java.util.concurrent.Executor executor,
Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
DSLContext.fetchAsync(ResultQuery<R> query)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.sql.ResultSet rs)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.sql.ResultSet rs,
java.lang.Class<?>... types)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.sql.ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.sql.ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(SQL sql)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.String sql)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.String sql,
java.lang.Object... bindings)
Fetch results in a new
CompletionStage . |
java.util.concurrent.CompletionStage<Result<Record>> |
DSLContext.fetchAsync(java.lang.String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage . |
<R extends Record> |
DSLContext.fetchAsync(Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchAsync(Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<K> java.util.Map<K,Result<R>> |
ResultQuery.fetchGroups(java.lang.Class<? extends K> keyType)
Execute the query and return a
Map with results grouped by the
given key entity. |
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys)
Execute the query and return a
Map with the result grouped by the
given keys. |
java.util.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> java.util.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. |
java.util.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. |
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(int[] keyFieldIndexes)
Execute the query and return a
Map with the result grouped by the
given keys. |
java.util.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. |
java.util.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. |
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
java.util.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. |
<K> java.util.Map<K,Result<R>> |
ResultQuery.fetchGroups(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. |
java.util.Map<?,Result<R>> |
ResultQuery.fetchGroups(java.lang.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. |
java.util.Map<Record,Result<R>> |
ResultQuery.fetchGroups(java.lang.String[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
java.util.Map<Record,Result<Record>> |
ResultQuery.fetchGroups(java.lang.String[] keyFieldNames,
java.lang.String[] valueFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<S extends Record> |
ResultQuery.fetchGroups(Table<S> table)
Execute the query and return a
Map with the result grouped by the
given table. |
<S extends Record,T extends Record> |
ResultQuery.fetchGroups(Table<S> keyTable,
Table<T> valueTable)
Execute the query and return a
Map with the result grouped by the
given table. |
<K> java.util.Map<K,Result<R>> |
Result.intoGroups(java.lang.Class<? extends K> keyType)
Return a
Map with results grouped by the given key entity. |
java.util.Map<Record,Result<R>> |
Result.intoGroups(Field<?>[] keys)
Return a
Map with the result grouped by the given keys. |
java.util.Map<Record,Result<Record>> |
Result.intoGroups(Field<?>[] keys,
Field<?>[] values)
Return a
Map with the result grouped by the given keys. |
<K> java.util.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. |
java.util.Map<?,Result<R>> |
Result.intoGroups(int keyFieldIndex)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
java.util.Map<Record,Result<R>> |
Result.intoGroups(int[] keyFieldIndexes)
Return a
Map with the result grouped by the given keys. |
java.util.Map<Record,Result<Record>> |
Result.intoGroups(int[] keyFieldIndexes,
int[] valueFieldIndexes)
Return a
Map with the result grouped by the given keys. |
java.util.Map<?,Result<R>> |
Result.intoGroups(Name keyFieldName)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
java.util.Map<Record,Result<R>> |
Result.intoGroups(Name[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
java.util.Map<Record,Result<Record>> |
Result.intoGroups(Name[] keyFieldNames,
Name[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
<K> java.util.Map<K,Result<R>> |
Result.intoGroups(RecordMapper<? super R,K> keyMapper)
Return a
Map with results grouped by the given key entity and
mapped into the given entity type. |
java.util.Map<?,Result<R>> |
Result.intoGroups(java.lang.String keyFieldName)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
java.util.Map<Record,Result<R>> |
Result.intoGroups(java.lang.String[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
java.util.Map<Record,Result<Record>> |
Result.intoGroups(java.lang.String[] keyFieldNames,
java.lang.String[] valueFieldNames)
Return a
Map with the result grouped by the given keys. |
<S extends Record> |
Result.intoGroups(Table<S> table)
Return a
Map with the result grouped by the given key table. |
<S extends Record,T extends Record> |
Result.intoGroups(Table<S> keyTable,
Table<T> valueTable)
Return a
Map with the result grouped by the given key table. |
Modifier and Type | Method and Description |
---|---|
Condition |
RowN.in(Result<? extends Record> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Field.in(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a
previous query.
|
Condition |
Row1.in(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row10.in(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row11.in(Result<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row12.in(Result<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row13.in(Result<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row14.in(Result<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row15.in(Result<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row16.in(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row17.in(Result<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row18.in(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row19.in(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row2.in(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row20.in(Result<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row21.in(Result<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row22.in(Result<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row3.in(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row4.in(Result<? extends Record4<T1,T2,T3,T4>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row5.in(Result<? extends Record5<T1,T2,T3,T4,T5>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row6.in(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row7.in(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row8.in(Result<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row9.in(Result<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
RowN.notIn(Result<? extends Record> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Field.notIn(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a
previous query.
|
Condition |
Row1.notIn(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row10.notIn(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row11.notIn(Result<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row12.notIn(Result<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row13.notIn(Result<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row14.notIn(Result<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row15.notIn(Result<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row16.notIn(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row17.notIn(Result<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row18.notIn(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row19.notIn(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row2.notIn(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row20.notIn(Result<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row21.notIn(Result<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row22.notIn(Result<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row3.notIn(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row4.notIn(Result<? extends Record4<T1,T2,T3,T4>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row5.notIn(Result<? extends Record5<T1,T2,T3,T4,T5>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row6.notIn(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row7.notIn(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row8.notIn(Result<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
Row9.notIn(Result<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> result)
Compare this row value expression with a set of records for
equality.
|
void |
ExecuteContext.result(Result<?> result)
Calling this has no effect.
|
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
SQLDataType.RESULT
The
ResultSet type. |
Modifier and Type | Method and Description |
---|---|
<R extends Record> |
DefaultDSLContext.fetch(ResultQuery<R> query) |
Result<Record> |
DefaultDSLContext.fetch(java.sql.ResultSet rs) |
Result<Record> |
DefaultDSLContext.fetch(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
Result<Record> |
DefaultDSLContext.fetch(java.sql.ResultSet rs,
DataType<?>... types) |
Result<Record> |
DefaultDSLContext.fetch(java.sql.ResultSet rs,
Field<?>... fields) |
Result<Record> |
DefaultDSLContext.fetch(SQL sql) |
Result<Record> |
DefaultDSLContext.fetch(java.lang.String sql) |
Result<Record> |
DefaultDSLContext.fetch(java.lang.String sql,
java.lang.Object... bindings) |
Result<Record> |
DefaultDSLContext.fetch(java.lang.String sql,
QueryPart... parts) |
<R extends Record> |
DefaultDSLContext.fetch(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetch(Table<R> table,
Condition condition) |
<R extends TableRecord<R>> |
DefaultDSLContext.fetchByExample(R example) |
<O extends TableRecord<O>> |
UpdatableRecordImpl.fetchChildren(ForeignKey<O,R> key) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(java.lang.String string) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(java.lang.String string,
boolean header) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(java.lang.String string,
boolean header,
char delimiter) |
Result<Record> |
DefaultDSLContext.fetchFromCSV(java.lang.String string,
char delimiter) |
Result<Record> |
DefaultDSLContext.fetchFromHTML(java.lang.String string) |
Result<Record> |
DefaultDSLContext.fetchFromJSON(java.lang.String string) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(java.util.List<java.lang.String[]> strings) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(java.util.List<java.lang.String[]> strings,
boolean header) |
Result<Record> |
DefaultDSLContext.fetchFromStringData(java.lang.String[]... strings) |
Result<Record> |
DefaultDSLContext.fetchFromTXT(java.lang.String string) |
Result<Record> |
DefaultDSLContext.fetchFromTXT(java.lang.String string,
java.lang.String nullLiteral) |
Result<Record> |
DefaultDSLContext.newResult(Field<?>... fields) |
<T1> Result<Record1<T1>> |
DefaultDSLContext.newResult(Field<T1> field1) |
<T1,T2> Result<Record2<T1,T2>> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2) |
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3) |
<T1,T2,T3,T4> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4) |
<T1,T2,T3,T4,T5> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5) |
<T1,T2,T3,T4,T5,T6> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6) |
<T1,T2,T3,T4,T5,T6,T7> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7) |
<T1,T2,T3,T4,T5,T6,T7,T8> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21) |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
DefaultDSLContext.newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22) |
<R extends Record> |
DefaultDSLContext.newResult(Table<R> table) |
Modifier and Type | Method and Description |
---|---|
<R extends Record> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
ResultQuery<R> query) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
java.lang.Class<?>... types) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
DataType<?>... types) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.sql.ResultSet rs,
Field<?>... fields) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
SQL sql) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
java.lang.Object... bindings) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
java.lang.String sql,
QueryPart... parts) |
<R extends Record> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchAsync(java.util.concurrent.Executor executor,
Table<R> table,
Condition condition) |
<R extends Record> |
DefaultDSLContext.fetchAsync(ResultQuery<R> query) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.sql.ResultSet rs) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.sql.ResultSet rs,
java.lang.Class<?>... types) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.sql.ResultSet rs,
DataType<?>... types) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.sql.ResultSet rs,
Field<?>... fields) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(SQL sql) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.lang.String sql) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.lang.String sql,
java.lang.Object... bindings) |
java.util.concurrent.CompletionStage<Result<Record>> |
DefaultDSLContext.fetchAsync(java.lang.String sql,
QueryPart... parts) |
<R extends Record> |
DefaultDSLContext.fetchAsync(Table<R> table) |
<R extends Record> |
DefaultDSLContext.fetchAsync(Table<R> table,
Condition condition) |
Modifier and Type | Method and Description |
---|---|
static <R extends Record> |
DSL.table(Result<R> result)
Use a previously obtained result as a new
Table that can be used
in SQL statements through DSL.values(RowN...) . |
Modifier and Type | Field and Description |
---|---|
Result<?> |
MockResult.data
The result data associated with this execution result.
|
Modifier and Type | Method and Description |
---|---|
static MockDataProvider |
Mock.of(Result<?> result)
Create a new
MockDataProvider that always returns the same result
for all queries. |
Constructor and Description |
---|
MockResult(int rows,
Result<?> data)
Create a new
MockResult . |
MockResultSet(Result<?> result) |
MockResultSet(Result<?> result,
int maxRows) |
Modifier and Type | Field and Description |
---|---|
protected static DataType<Result<Record>> |
H2DataType.__RESULT |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
HSQLDBDataType.ROW |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
OracleDataType.REF_CURSOR |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
PostgresDataType.REFCURSOR |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
RedshiftDataType.REFCURSOR |
Modifier and Type | Field and Description |
---|---|
static DataType<Result<Record>> |
VerticaDataType.ROW |
Copyright © 2018. All Rights Reserved.