public interface UpdateWhereStep<R extends Record> extends UpdateReturningStep<R>
Update
's DSL API.
Example:
DSLContext create = DSL.using(configuration);
create.update(table)
.set(field1, value1)
.set(field2, value2)
.where(field1.greaterThan(100))
.execute();
XYZ*Step
types directly from client code
It is usually not recommended to reference any XYZ*Step
types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step
types directly:
Modifier and Type | Method and Description |
---|---|
UpdateConditionStep<R> |
where(Boolean condition)
Deprecated.
- 3.8.0 - [#4763] - Use
where(Condition) or
where(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
UpdateConditionStep<R> |
where(Collection<? extends Condition> conditions)
Add conditions to the query, connecting them with each other with
Operator.AND . |
UpdateConditionStep<R> |
where(Condition... conditions)
Add conditions to the query, connecting them with each other with
Operator.AND . |
UpdateConditionStep<R> |
where(Condition condition)
Add conditions to the query, connecting them with each other with
Operator.AND . |
UpdateConditionStep<R> |
where(Field<Boolean> condition)
Add conditions to the query
|
UpdateConditionStep<R> |
where(SQL sql)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
UpdateConditionStep<R> |
where(String sql)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
UpdateConditionStep<R> |
where(String sql,
Object... bindings)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
UpdateConditionStep<R> |
where(String sql,
QueryPart... parts)
Add conditions to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
|
UpdateConditionStep<R> |
whereExists(Select<?> select)
Add an EXISTS clause to the query
|
UpdateConditionStep<R> |
whereNotExists(Select<?> select)
Add a NOT EXISTS clause to the query
|
returning, returning, returning, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult, returningResult
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, configuration, detach
@Support UpdateConditionStep<R> where(Condition condition)
Operator.AND
.@Support UpdateConditionStep<R> where(Condition... conditions)
Operator.AND
.@Support UpdateConditionStep<R> where(Collection<? extends Condition> conditions)
Operator.AND
.@Support UpdateConditionStep<R> where(Field<Boolean> condition)
@Deprecated @Support UpdateConditionStep<R> where(Boolean condition)
where(Condition)
or
where(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.@Support @PlainSQL UpdateConditionStep<R> where(SQL sql)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.condition(SQL)
,
SQL
@Support @PlainSQL UpdateConditionStep<R> where(String sql)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.condition(String)
,
SQL
@Support @PlainSQL UpdateConditionStep<R> where(String sql, Object... bindings)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
@Support @PlainSQL UpdateConditionStep<R> where(String sql, QueryPart... parts)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
@Support UpdateConditionStep<R> whereExists(Select<?> select)
@Support UpdateConditionStep<R> whereNotExists(Select<?> select)
Copyright © 2019. All rights reserved.