-
- All Superinterfaces:
QueryPart
,Serializable
- All Known Subinterfaces:
False
,JSONExistsOnStep
,LikeEscapeStep
,True
- All Known Implementing Classes:
CustomCondition
public interface Condition extends QueryPart
A condition or predicate.Conditions can be used in a variety of SQL clauses. They're mainly used in a
Select
statement'sWHERE
clause, but can also appear in (non-exhaustive list):SELECT .. WHERE
, e.g. viaSelectWhereStep.where(Condition)
SELECT .. HAVING
, e.g. viaSelectHavingStep.having(Condition)
- In a
CASE
expression, e.g. viaDSL.case_()
andCase.when(Condition, Field)
- As an ordinary column expression, e.g. via
DSL.field(Condition)
- In filtered aggregate functions, e.g. via
AggregateFilterStep.filterWhere(Condition)
- ... and many more
Example:
// Assuming import static org.jooq.impl.DSL.*; using(configuration) .select() .from(ACTOR) .where(ACTOR.ACTOR_ID.eq(1)) // The eq operator produces a Condition from two Fields .fetch();
Instances can be created using
DSL.condition(Field)
and overloads, or by calling a comparison operator method onField
, such asField.eq(Field)
.- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description @NotNull Condition
and(String sql)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
and(String sql, Object... bindings)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
and(String sql, QueryPart... parts)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
and(Condition other)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
and(Field<Boolean> other)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
and(SQL sql)
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
andExists(Select<?> select)
Combine this condition with an EXISTS clause using theOperator.AND
operator.@NotNull Condition
andNot(Condition other)
Combine this condition with a negated other one using theOperator.AND
operator.@NotNull Condition
andNot(Field<Boolean> other)
Combine this condition with a negated other one using theOperator.AND
operator.@NotNull Condition
andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.AND
operator.@NotNull Condition
not()
Invert this condition@NotNull Condition
or(String sql)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
or(String sql, Object... bindings)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
or(String sql, QueryPart... parts)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
or(Condition other)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
or(Field<Boolean> other)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
or(SQL sql)
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
orExists(Select<?> select)
Combine this condition with an EXISTS clause using theOperator.OR
operator.@NotNull Condition
orNot(Condition other)
Combine this condition with a negated other one using theOperator.OR
operator.@NotNull Condition
orNot(Field<Boolean> other)
Combine this condition with a negated other one using theOperator.OR
operator.@NotNull Condition
orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.OR
operator.
-
-
-
Method Detail
-
and
@NotNull @Support @NotNull Condition and(Condition other)
Combine this condition with another one using theOperator.AND
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
and
@NotNull @Support @NotNull Condition and(Field<Boolean> other)
Combine this condition with another one using theOperator.AND
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
and
@NotNull @Support @PlainSQL @NotNull Condition and(SQL sql)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(SQL)
,SQL
-
and
@NotNull @Support @PlainSQL @NotNull Condition and(String sql)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(String)
,SQL
-
and
@NotNull @Support @PlainSQL @NotNull Condition and(String sql, Object... bindings)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other conditionbindings
- The bindings- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, Object...)
,SQL
-
and
@NotNull @Support @PlainSQL @NotNull Condition and(String sql, QueryPart... parts)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The SQL clause, containing {numbered placeholders} where query parts can be injectedparts
- TheQueryPart
objects that are rendered at the {numbered placeholder} locations- Returns:
- The combined condition
- See Also:
DSL.condition(String, QueryPart...)
,DSL.sql(String, QueryPart...)
,SQL
-
andNot
@NotNull @Support @NotNull Condition andNot(Condition other)
Combine this condition with a negated other one using theOperator.AND
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
andNot
@NotNull @Support @NotNull Condition andNot(Field<Boolean> other)
Combine this condition with a negated other one using theOperator.AND
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
andExists
@NotNull @Support @NotNull Condition andExists(Select<?> select)
Combine this condition with an EXISTS clause using theOperator.AND
operator.- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
andNotExists
@NotNull @Support @NotNull Condition andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.AND
operator.- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
or
@NotNull @Support @NotNull Condition or(Condition other)
Combine this condition with another one using theOperator.OR
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
or
@NotNull @Support @NotNull Condition or(Field<Boolean> other)
Combine this condition with another one using theOperator.OR
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
or
@NotNull @Support @PlainSQL @NotNull Condition or(SQL sql)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(SQL)
,SQL
-
or
@NotNull @Support @PlainSQL @NotNull Condition or(String sql)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(String)
,SQL
-
or
@NotNull @Support @PlainSQL @NotNull Condition or(String sql, Object... bindings)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The other conditionbindings
- The bindings- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, Object...)
,SQL
-
or
@NotNull @Support @PlainSQL @NotNull Condition or(String sql, QueryPart... parts)
Combine this condition with another one using theOperator.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!
- Parameters:
sql
- The SQL clause, containing {numbered placeholders} where query parts can be injectedparts
- TheQueryPart
objects that are rendered at the {numbered placeholder} locations- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, QueryPart...)
,SQL
-
orNot
@NotNull @Support @NotNull Condition orNot(Condition other)
Combine this condition with a negated other one using theOperator.OR
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
orNot
@NotNull @Support @NotNull Condition orNot(Field<Boolean> other)
Combine this condition with a negated other one using theOperator.OR
operator.- Parameters:
other
- The other condition- Returns:
- The combined condition
-
orExists
@NotNull @Support @NotNull Condition orExists(Select<?> select)
Combine this condition with an EXISTS clause using theOperator.OR
operator.- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
orNotExists
@NotNull @Support @NotNull Condition orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.OR
operator.- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
not
@NotNull @Support @NotNull Condition not()
Invert this conditionThis is the same as calling
DSL.not(Condition)
- Returns:
- This condition, inverted
-
-