R
- The record type of the table being deleted frompublic interface DeleteQuery<R extends Record> extends ConditionProvider, Delete<R>
Modifier and Type | Method and Description |
---|---|
void |
addConditions(Collection<? extends Condition> conditions)
Adds new conditions to the query, connecting them to existing
conditions with
Operator.AND |
void |
addConditions(Condition... conditions)
Adds new conditions to the query, connecting them to existing
conditions with
Operator.AND |
void |
addConditions(Operator operator,
Collection<? extends Condition> conditions)
Adds new conditions to the query, connecting them to existing
conditions with the provided operator
|
void |
addConditions(Operator operator,
Condition... conditions)
Adds new conditions to the query, connecting them to existing
conditions with the provided operator
|
R |
getReturnedRecord()
The record holding returned values as specified by any of the
setReturning() methods. |
Result<R> |
getReturnedRecords()
The records holding returned values as specified by any of the
setReturning() methods. |
void |
setReturning()
Configure the
DELETE statement to return all fields in
R . |
void |
setReturning(Collection<? extends Field<?>> fields)
Configure the
DELETE statement to return a list of fields in
R . |
void |
setReturning(Field<?>... fields)
Configure the
DELETE statement to return a list of fields in
R . |
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
@Support void addConditions(Condition... conditions)
Operator.AND
addConditions
in interface ConditionProvider
conditions
- The condition@Support void addConditions(Collection<? extends Condition> conditions)
Operator.AND
addConditions
in interface ConditionProvider
conditions
- The condition@Support void addConditions(Operator operator, Condition... conditions)
addConditions
in interface ConditionProvider
conditions
- The condition@Support void addConditions(Operator operator, Collection<? extends Condition> conditions)
addConditions
in interface ConditionProvider
conditions
- The condition@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES}) void setReturning()
DELETE
statement to return all fields in
R
.getReturnedRecords()
@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES}) void setReturning(Field<?>... fields)
DELETE
statement to return a list of fields in
R
.fields
- Fields to be returnedgetReturnedRecords()
@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES}) void setReturning(Collection<? extends Field<?>> fields)
DELETE
statement to return a list of fields in
R
.fields
- Fields to be returnedgetReturnedRecords()
@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES}) R getReturnedRecord()
setReturning()
methods.
If the DELETE
statement returns several records, this is the
same as calling getReturnedRecords().get(0)
This implemented differently for every dialect:
DELETE .. RETURNING
clausessetReturning()
methods. This may return
null
in case jOOQ could not retrieve any generated
keys from the JDBC driver.getReturnedRecords()
@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES}) Result<R> getReturnedRecords()
setReturning()
methods.
If the DELETE
statement returns several records, this is the
same as calling getReturnedRecords().get(0)
This implemented differently for every dialect:
DELETE .. RETURNING
clausessetReturning()
methods. Note:
Result
in case jOOQ could not retrieve any generated
keys from the JDBC driver.Copyright © 2017. All Rights Reserved.