Module org.jooq
Package org.jooq

Interface Condition

    • Method Detail

      • 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