Package org.jooq

Interface Condition

    • Method Detail

      • and

        @Support
        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

        @Support
        Condition and​(Field<java.lang.Boolean> other)
        Combine this condition with another one using the Operator.AND operator.
        Parameters:
        other - The other condition
        Returns:
        The combined condition
      • and

        @Support
        @PlainSQL
        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

        @Support
        @PlainSQL
        Condition and​(java.lang.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

        @Support
        @PlainSQL
        Condition and​(java.lang.String sql,
                      java.lang.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

        @Support
        @PlainSQL
        Condition and​(java.lang.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

        @Support
        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

        @Support
        Condition andNot​(Field<java.lang.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

        @Support
        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

        @Support
        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

        @Support
        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

        @Support
        Condition or​(Field<java.lang.Boolean> other)
        Combine this condition with another one using the Operator.OR operator.
        Parameters:
        other - The other condition
        Returns:
        The combined condition
      • or

        @Support
        @PlainSQL
        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

        @Support
        @PlainSQL
        Condition or​(java.lang.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

        @Support
        @PlainSQL
        Condition or​(java.lang.String sql,
                     java.lang.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

        @Support
        @PlainSQL
        Condition or​(java.lang.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

        @Support
        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

        @Support
        Condition orNot​(Field<java.lang.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

        @Support
        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

        @Support
        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