-
- All Superinterfaces:
QueryPart
,Serializable
- All Known Subinterfaces:
False
,JSONExistsOnStep
,LikeEscapeStep
,QOM.And
,QOM.CombinedCondition
,QOM.CompareCondition<T>
,QOM.Contains<T>
,QOM.ContainsIgnoreCase<T>
,QOM.EndsWith<T>
,QOM.EndsWithIgnoreCase<T>
,QOM.Eq<T>
,QOM.Exists
,QOM.FieldCondition
,QOM.Ge<T>
,QOM.Gt<T>
,QOM.In<T>
,QOM.InList<T>
,QOM.IsDistinctFrom<T>
,QOM.IsDocument
,QOM.IsJson
,QOM.IsNotDistinctFrom<T>
,QOM.IsNotDocument
,QOM.IsNotJson
,QOM.IsNotNull
,QOM.IsNull
,QOM.Le<T>
,QOM.Like
,QOM.LikeIgnoreCase
,QOM.Lt<T>
,QOM.Ne<T>
,QOM.Not
,QOM.NotIn<T>
,QOM.NotInList<T>
,QOM.NotLike
,QOM.NotLikeIgnoreCase
,QOM.NotSimilarTo
,QOM.Or
,QOM.RegexpLike
,QOM.RowIsNotNull
,QOM.RowIsNull
,QOM.RowOverlaps
,QOM.SelectIsNotNull
,QOM.SelectIsNull
,QOM.SimilarTo
,QOM.StartsWith<T>
,QOM.StartsWithIgnoreCase<T>
,QOM.TableEq<R>
,QOM.TableNe<R>
,QOM.Unique
,QOM.XMLExists
,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 arg2)
TheAND
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()
TheNOT
operator.@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 arg2)
TheOR
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(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(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
-
-