Module org.jooq
Package org.jooq

Interface Condition

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's WHERE clause, but can also appear in (non-exhaustive list):

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 on Field, such as Field.eq(Field).

Author:
Lukas Eder

  • Method Details

    • and

      @NotNull @Support @NotNull Condition and​(Condition other)
      Combine this condition with another one using the Operator.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 the Operator.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 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!

      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 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!

      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 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!

      Parameters:
      sql - The other condition
      bindings - 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 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!

      Parameters:
      sql - The SQL clause, containing {numbered placeholders} where query parts can be injected
      parts - The QueryPart 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 the Operator.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 the Operator.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 the Operator.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 the Operator.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 the Operator.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 the Operator.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 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!

      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 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!

      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 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!

      Parameters:
      sql - The other condition
      bindings - 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 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!

      Parameters:
      sql - The SQL clause, containing {numbered placeholders} where query parts can be injected
      parts - The QueryPart 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 the Operator.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 the Operator.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 the Operator.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 the Operator.OR operator.
      Parameters:
      select - The EXISTS's subquery
      Returns:
      The combined condition

    • not

      @NotNull @Support @NotNull Condition not()
      Invert this condition

      This is the same as calling DSL.not(Condition)

      Returns:
      This condition, inverted