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 | Interface and Description |
---|---|
interface |
Cursor<R extends Record>
Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet . |
interface |
Delete<R extends Record>
A
Query that can delete data in the database. |
interface |
DeleteConditionStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
DeleteFinalStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
DeleteQuery<R extends Record>
A query used for deletion of data
|
interface |
DeleteWhereStep<R extends Record>
This type is used for the
Delete 's DSL API. |
interface |
ForeignKey<R extends Record,U extends Record>
A
ForeignKey is an object referencing a UniqueKey . |
interface |
ForeignKey<R extends Record,U extends Record>
A
ForeignKey is an object referencing a UniqueKey . |
interface |
FutureResult<R extends Record>
Fetch results asynchronously.
|
interface |
Identity<R extends Record,T>
An
Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard. |
interface |
Insert<R extends Record>
A
Query that can insert data in the database. |
interface |
InsertFinalStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertOnDuplicateSetStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertOnDuplicateStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertQuery<R extends Record>
A query for data insertion
|
interface |
InsertResultStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertReturningStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
InsertSetMoreStep<R extends Record>
This type is used for the
Insert 's alternative DSL API. |
interface |
InsertSetStep<R extends Record>
This type is used for the
Insert 's alternative DSL API. |
interface |
InsertValuesStep<R extends Record>
This type is used for the
Insert 's DSL API. |
interface |
Key<R extends Record>
A
Key is an object representing a UNIQUE KEY , a
PRIMARY KEY , or a FOREIGN KEY . |
interface |
Merge<R extends Record>
A
Query that can merge data in the database. |
interface |
MergeFinalStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeKeyStep<R extends Record>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
MergeMatchedDeleteStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeMatchedSetMoreStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeMatchedSetStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeMatchedStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeMatchedWhereStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedSetStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedValuesStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeNotMatchedWhereStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeOnConditionStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeOnStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeUsingStep<R extends Record>
This type is used for the
Merge 's DSL API. |
interface |
MergeValuesStep<R extends Record>
This type is used for the H2-specific variant of the
Merge 's DSL API. |
interface |
RecordHandler<R extends Record>
A
RecordHandler is a handler that can receive Record
objects, when fetching data from the database. |
interface |
RecordMapper<R extends Record,E>
A
RecordMapper is a mapper that can receive Record
objects, when fetching data from the database, transforming them into a
custom type <E> |
interface |
Result<R extends Record>
A wrapper for database results returned by
|
interface |
ResultQuery<R extends Record>
A query that can return results.
|
interface |
Select<R extends Record>
|
interface |
SimpleSelectConditionStep<R extends Record>
|
interface |
SimpleSelectFinalStep<R extends Record>
|
interface |
SimpleSelectForUpdateOfStep<R extends Record>
|
interface |
SimpleSelectForUpdateStep<R extends Record>
|
interface |
SimpleSelectForUpdateWaitStep<R extends Record>
|
interface |
SimpleSelectLimitStep<R extends Record>
|
interface |
SimpleSelectOffsetStep<R extends Record>
|
interface |
SimpleSelectOrderByStep<R extends Record>
|
interface |
SimpleSelectQuery<R extends Record>
A simple select query that provides Records from a single table, with no
joins allowed.
|
interface |
SimpleSelectWhereStep<R extends Record>
|
interface |
StoreQuery<R extends Record>
A query storing objects to the database.
|
interface |
Table<R extends Record>
A table to be used in queries
|
interface |
TableField<R extends Record,T>
A field contained in a table
|
interface |
TableLike<R extends Record>
An object that can behave like a table (a table-like object)
|
interface |
Truncate<R extends Record>
A
Query that can truncate a table in the database. |
interface |
Type<R extends Record>
Deprecated.
|
interface |
UniqueKey<R extends Record>
A
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY . |
interface |
Updatable<R extends Record>
A common interface for objects (tables, records) that can be updated or
deleted using their primary keys.
|
interface |
UpdatableTable<R extends Record>
A common interface for tables whose records can be stored back to the
database again.
|
interface |
Update<R extends Record>
A
Query that can update data in the database. |
interface |
UpdateConditionStep<R extends Record>
This type is used for the
Update 's DSL API. |
interface |
UpdateFinalStep<R extends Record>
This type is used for the
Update 's DSL API. |
interface |
UpdateQuery<R extends Record>
A query for data updating
|
interface |
UpdateSetMoreStep<R extends Record>
This type is used for the
Update 's DSL API. |
interface |
UpdateSetStep<R extends Record>
This type is used for the
Update 's DSL API. |
interface |
UpdateWhereStep<R extends Record>
This type is used for the
Update 's DSL API. |
Modifier and Type | Interface and Description |
---|---|
interface |
TableRecord<R extends TableRecord<R>>
A record originating from a single table
|
interface |
UDTRecord<R extends UDTRecord<R>>
An object holding data of a UDT
|
interface |
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again.
|
Modifier and Type | Method and Description |
---|---|
<R extends Record> |
FactoryOperations.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
FactoryOperations.deleteQuery(Table<R> table)
Create a new
DeleteQuery |
<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. |
<R extends Record> |
FactoryOperations.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this Configuration by
default. |
<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.
|
<R extends Record> |
FactoryOperations.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryOperations.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this Configuration by
default. |
<Z extends Record> |
Cursor.fetchOneInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
<O extends Record> |
UpdatableTable.getReferencesFrom(Table<O> other)
Get a list of
FOREIGN KEY 's of a specific table, referencing
a this table. |
<O extends Record> |
Table.getReferencesTo(Table<O> other)
Get a list of
FOREIGN KEY 's of this table, referencing a
specific table. |
<R extends Record> |
FactoryOperations.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Select<?> select)
Deprecated.
- 2.0.3 - Use any of these methods instead:
|
<R extends Record> |
FactoryOperations.insertQuery(Table<R> into)
Create a new
InsertQuery |
<R extends Record> |
Record.into(Table<R> table)
Map resulting records onto a custom record type.
|
<Z extends Record> |
Result.into(Table<Z> table)
Map resulting records onto a custom record.
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax)
|
<R extends Record> |
FactoryOperations.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax)
This statement is available from DSL syntax only.
|
<R extends Record> |
FactoryOperations.selectFrom(Table<R> table)
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
|
<R extends Record> |
FactoryOperations.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
<R extends Record> |
FactoryOperations.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
FactoryOperations.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
FactoryOperations.updateQuery(Table<R> table)
Create a new
UpdateQuery |
Modifier and Type | Method and Description |
---|---|
Record |
FactoryOperations.fetchOne(String sql)
Execute a new query holding plain SQL.
|
Record |
FactoryOperations.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
FactoryOperations.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
Record |
Record.original()
Get this record containing the original values as fetched from the
database.
|
Record |
ExecuteContext.record()
The last record that was fetched from the result set, or
null if no record has been fetched. |
Modifier and Type | Method and Description |
---|---|
Table<Record> |
Table.crossJoin(String sql)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
Table<Record> |
Table.crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
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.
|
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.
|
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Field<?>[] keys)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Field<?>[] keys,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given keys and mapped into the given entity type. |
Cursor<Record> |
FactoryOperations.fetchLazy(ResultSet rs)
|
Cursor<Record> |
FactoryOperations.fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
FactoryOperations.fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
FactoryOperations.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
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,R> |
ResultQuery.fetchMap(Field<?>[] keys)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
Table<Record> |
PivotInStep.in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(Field<?>... fields)
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE . |
Table<Record> |
PivotInStep.in(T... values)
Specify the acceptable values for pivoting
|
Map<Record,Result<R>> |
Result.intoGroups(Field<?>[] keys)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(Field<?>[] keys,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
Map<Record,R> |
Result.intoMap(Field<?>[] keys)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
Table<Record> |
Table.naturalJoin(String sql)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
ResultQuery<Record> |
FactoryOperations.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
FactoryOperations.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
FactoryOperations.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
Table<Record> |
DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
DivideByReturningStep.returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend
|
Table<Record> |
TableOnStep.using(Collection<? extends Field<?>> fields)
Join the table with the
USING(column [, column...]) |
Table<Record> |
TableOnStep.using(Field<?>... fields)
Join the table with the
USING(column [, column...]) |
Modifier and Type | Method and Description |
---|---|
void |
ExecuteContext.record(Record record)
Calling this has no effect.
|
Modifier and Type | Method and Description |
---|---|
<E> E |
Record.map(RecordMapper<Record,E> mapper)
Map this record into a custom mapper callback
|
Modifier and Type | Class and Description |
---|---|
class |
TableImpl<R extends Record>
A common base type for tables
This type is for JOOQ INTERNAL USE only.
|
class |
UpdatableTableImpl<R extends Record>
A table implementation for a table holding a primary key
This type is for JOOQ INTERNAL USE only.
|
Modifier and Type | Class and Description |
---|---|
class |
CustomRecord<R extends TableRecord<R>>
A base class for custom
TableRecord implementations in client code. |
class |
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single table
This type is for JOOQ INTERNAL USE only.
|
class |
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDT
This type is for JOOQ INTERNAL USE only.
|
class |
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary key
This type is for JOOQ INTERNAL USE only.
|
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 |
---|---|
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys
|
protected static <R extends Record,U extends Record> |
AbstractKeys.createForeignKey(UniqueKey<U> key,
Table<R> table,
TableField<R,?>... fields)
Factory method for foreign keys
|
protected static <R extends Record,T> |
AbstractKeys.createIdentity(Table<R> table,
TableField<R,T> field)
Factory method for identities
|
protected static <R extends Record> |
AbstractKeys.createUniqueKey(Table<R> table,
TableField<R,?>... fields)
Factory method for unique keys
|
<R extends Record> |
FactoryProxy.delete(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
FactoryProxy.deleteQuery(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.deleteQuery(Table<R> table)
Create a new
DeleteQuery |
<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. |
<R extends Record> |
FactoryProxy.fetchAny(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryProxy.fetchOne(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]
The resulting record is attached to this Configuration by
default. |
<R extends Record> |
FactoryProxy.fetchOne(Table<R> table,
Condition condition)
Deprecated.
|
<R extends Record> |
Factory.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition]
The resulting record is attached to this Configuration by
default. |
<O extends Record> |
UpdatableTableImpl.getReferencesFrom(Table<O> other) |
<R extends Record> |
FactoryProxy.insertInto(Table<R> into)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Field<?>... fields)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
<R extends Record> |
FactoryProxy.insertQuery(Table<R> into)
Deprecated.
|
<R extends Record> |
Factory.insertQuery(Table<R> into)
Create a new
InsertQuery |
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax)
|
<R extends Record> |
FactoryProxy.mergeInto(Table<R> table,
Field<?>... fields)
Deprecated.
|
<R extends Record> |
Factory.mergeInto(Table<R> table,
Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax)
This statement is available from DSL syntax only.
|
<R extends Record> |
FactoryProxy.selectFrom(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.selectFrom(Table<R> table)
Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
|
<R extends Record> |
FactoryProxy.selectQuery(TableLike<R> table)
Deprecated.
|
<R extends Record> |
Factory.selectQuery(TableLike<R> table)
Create a new
SelectQuery |
static <R extends Record> |
Factory.table(Select<R> select)
A synonym for
TableLike.asTable() . |
<R extends Record> |
FactoryProxy.truncate(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
FactoryProxy.update(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
FactoryProxy.updateQuery(Table<R> table)
Deprecated.
|
<R extends Record> |
Factory.updateQuery(Table<R> table)
Create a new
UpdateQuery |
Modifier and Type | Method and Description |
---|---|
Record |
FactoryProxy.fetchOne(String sql)
Deprecated.
|
Record |
Factory.fetchOne(String sql)
Execute a new query holding plain SQL.
|
Record |
FactoryProxy.fetchOne(String sql,
Object... bindings)
Deprecated.
|
Record |
Factory.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
FactoryProxy.fetchOne(String sql,
QueryPart... parts)
Deprecated.
|
Record |
Factory.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
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.
|
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.
|
Cursor<Record> |
FactoryProxy.fetchLazy(ResultSet rs)
Deprecated.
|
Cursor<Record> |
Factory.fetchLazy(ResultSet rs)
|
Cursor<Record> |
FactoryProxy.fetchLazy(String sql)
Deprecated.
|
Cursor<Record> |
Factory.fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
FactoryProxy.fetchLazy(String sql,
Object... bindings)
Deprecated.
|
Cursor<Record> |
Factory.fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
FactoryProxy.fetchLazy(String sql,
QueryPart... parts)
Deprecated.
|
Cursor<Record> |
Factory.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
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.
|
ResultQuery<Record> |
FactoryProxy.resultQuery(String sql)
Deprecated.
|
ResultQuery<Record> |
Factory.resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
FactoryProxy.resultQuery(String sql,
Object... bindings)
Deprecated.
|
ResultQuery<Record> |
Factory.resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
FactoryProxy.resultQuery(String sql,
QueryPart... parts)
Deprecated.
|
ResultQuery<Record> |
Factory.resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
static Table<Record> |
Factory.table(String sql)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.table(String sql,
Object... bindings)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.table(String sql,
QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.
|
static Table<Record> |
Factory.tableByName(String... qualifiedName)
Create a qualified table, given its table name
This constructs a table reference given the table's qualified name. jOOQ
will render the table name according to your
Settings.getRenderNameStyle() settings. |
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.