org.jooq

Interface UpdateConditionStep<R extends Record>

All Superinterfaces:

Attachable, Query, QueryPart, Serializable, Update<R>, UpdateFinalStep<R>, UpdateReturningStep<R>

public interface UpdateConditionStep<R extends Record>
extends UpdateFinalStep<R>, UpdateReturningStep<R>

This type is used for the Update's DSL API.

Example:

 DSLContext create = DSL.using(configuration);

 create.update(table)
       .set(field1, value1)
       .set(field2, value2)
       .where(field1.greaterThan(100))
       .execute();
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
UpdateConditionStep<R>	and(Condition condition) Combine the currently assembled conditions with another one using the Operator.AND operator
UpdateConditionStep<R>	and(Field<Boolean> condition) Combine the currently assembled conditions with another one using the Operator.AND operator
UpdateConditionStep<R>	and(String sql) Combine the currently assembled conditions with another one using the Operator.AND operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	and(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.AND operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	and(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.AND operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
UpdateConditionStep<R>	andNot(Condition condition) Combine the currently assembled conditions with a negated other one using the Operator.AND operator
UpdateConditionStep<R>	andNot(Field<Boolean> condition) Combine the currently assembled conditions with a negated other one using the Operator.AND operator
UpdateConditionStep<R>	andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
UpdateConditionStep<R>	or(Condition condition) Combine the currently assembled conditions with another one using the Operator.OR operator
UpdateConditionStep<R>	or(Field<Boolean> condition) Combine the currently assembled conditions with another one using the Operator.OR operator
UpdateConditionStep<R>	or(String sql) Combine the currently assembled conditions with another one using the Operator.OR operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	or(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.OR operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	or(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.OR operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
UpdateConditionStep<R>	orNot(Condition condition) Combine the currently assembled conditions with a negated other one using the Operator.OR operator
UpdateConditionStep<R>	orNot(Field<Boolean> condition) Combine the currently assembled conditions with a negated other one using the Operator.OR operator
UpdateConditionStep<R>	orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, detach

Methods inherited from interface org.jooq.UpdateReturningStep

returning, returning, returning

Method Detail

and

@Support
UpdateConditionStep<R> and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

and

@Support
UpdateConditionStep<R> and(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

and

@Support
UpdateConditionStep<R> and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

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!

See Also:

DSL.condition(String)

and

@Support
UpdateConditionStep<R> and(String sql,
                                     Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

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!

See Also:

DSL.condition(String, Object...)

and

@Support
UpdateConditionStep<R> and(String sql,
                                     QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.AND operator

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!

See Also:

DSL.condition(String, QueryPart...)

andNot

@Support
UpdateConditionStep<R> andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

andNot

@Support
UpdateConditionStep<R> andNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

andExists

@Support
UpdateConditionStep<R> andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

andNotExists

@Support
UpdateConditionStep<R> andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

or

@Support
UpdateConditionStep<R> or(Condition condition)

Combine the currently assembled conditions with another one using the Operator.OR operator

or

@Support
UpdateConditionStep<R> or(Field<Boolean> condition)

Combine the currently assembled conditions with another one using the Operator.OR operator

or

@Support
UpdateConditionStep<R> or(String sql)

Combine the currently assembled conditions with another one using the Operator.OR operator

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!

See Also:

DSL.condition(String)

or

@Support
UpdateConditionStep<R> or(String sql,
                                    Object... bindings)

Combine the currently assembled conditions with another one using the Operator.OR operator

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!

See Also:

DSL.condition(String, Object...)

or

@Support
UpdateConditionStep<R> or(String sql,
                                    QueryPart... parts)

Combine the currently assembled conditions with another one using the Operator.OR operator

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!

See Also:

DSL.condition(String, QueryPart...)

orNot

@Support
UpdateConditionStep<R> orNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.OR operator

orNot

@Support
UpdateConditionStep<R> orNot(Field<Boolean> condition)

Combine the currently assembled conditions with a negated other one using the Operator.OR operator

orExists

@Support
UpdateConditionStep<R> orExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator

orNotExists

@Support
UpdateConditionStep<R> orNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator