org.jooq

Interface Condition

All Superinterfaces:

QueryPart, Serializable

All Known Implementing Classes:

CustomCondition

public interface Condition
extends QueryPart

A condition to be used in a query's where part

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
Condition	and(Boolean other) Deprecated. - 3.8.0 - [#4763] - Use and(Condition) or and(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
Condition	and(Condition other) Combine this condition with another one using the Operator.AND operator.
Condition	and(Field<Boolean> other) Combine this condition with another one using the Operator.AND operator.
Condition	and(SQL sql) Combine this condition with another one using the Operator.AND operator.
Condition	and(String sql) Combine this condition with another one using the Operator.AND operator.
Condition	and(String sql, Object... bindings) Combine this condition with another one using the Operator.AND operator.
Condition	and(String sql, QueryPart... parts) Combine this condition with another one using the Operator.AND operator.
Condition	andExists(Select<?> select) Combine this condition with an EXISTS clause using the Operator.AND operator.
Condition	andNot(Boolean other) Deprecated. - 3.8.0 - [#4763] - Use andNot(Condition) or andNot(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
Condition	andNot(Condition other) Combine this condition with a negated other one using the Operator.AND operator.
Condition	andNot(Field<Boolean> other) Combine this condition with a negated other one using the Operator.AND operator.
Condition	andNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using the Operator.AND operator.
Condition	not() Invert this condition This is the same as calling DSL.not(Condition)
Condition	or(Boolean other) Deprecated. - 3.8.0 - [#4763] - Use or(Condition) or or(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
Condition	or(Condition other) Combine this condition with another one using the Operator.OR operator.
Condition	or(Field<Boolean> other) Combine this condition with another one using the Operator.OR operator.
Condition	or(SQL sql) Combine this condition with another one using the Operator.OR operator.
Condition	or(String sql) Combine this condition with another one using the Operator.OR operator.
Condition	or(String sql, Object... bindings) Combine this condition with another one using the Operator.OR operator.
Condition	or(String sql, QueryPart... parts) Combine this condition with another one using the Operator.OR operator.
Condition	orExists(Select<?> select) Combine this condition with an EXISTS clause using the Operator.OR operator.
Condition	orNot(Boolean other) Deprecated. - 3.8.0 - [#4763] - Use orNot(Condition) or orNot(Boolean) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
Condition	orNot(Condition other) Combine this condition with a negated other one using the Operator.OR operator.
Condition	orNot(Field<Boolean> other) Combine this condition with a negated other one using the Operator.OR operator.
Condition	orNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using the Operator.OR operator.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

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<Boolean> other)

Combine this condition with another one using the Operator.AND operator.

Parameters:

other - The other condition

Returns:

The combined condition

and

@Deprecated
 @Support
Condition and(Boolean other)

Deprecated. - 3.8.0 - [#4763] - Use and(Condition) or and(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

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(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(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...), SQL

and

@Support
 @PlainSQL
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...), 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<Boolean> other)

Combine this condition with a negated other one using the Operator.AND operator.

Parameters:

other - The other condition

Returns:

The combined condition

andNot

@Deprecated
 @Support
Condition andNot(Boolean other)

Deprecated. - 3.8.0 - [#4763] - Use andNot(Condition) or andNot(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

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<Boolean> other)

Combine this condition with another one using the Operator.OR operator.

Parameters:

other - The other condition

Returns:

The combined condition

or

@Deprecated
 @Support
Condition or(Boolean other)

Deprecated. - 3.8.0 - [#4763] - Use or(Condition) or or(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

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(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(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...), SQL

or

@Support
 @PlainSQL
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...), 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<Boolean> other)

Combine this condition with a negated other one using the Operator.OR operator.

Parameters:

other - The other condition

Returns:

The combined condition

orNot

@Deprecated
 @Support
Condition orNot(Boolean other)

Deprecated. - 3.8.0 - [#4763] - Use orNot(Condition) or orNot(Boolean) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

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

not

@Support
Condition not()

Invert this condition

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

Returns:

This condition, inverted