org.jooq
Interface Condition

All Superinterfaces:

Adapter, Attachable, 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

Condition	and(Condition other) 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(Condition 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 Factory.not(Condition)
Condition	or(Condition other) 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(Condition 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

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

and

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

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:

Factory.condition(String)

and

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:

Factory.condition(String, Object...)

and

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:

Factory.condition(String, QueryPart...)

andNot

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

andExists

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

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

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

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:

Factory.condition(String)

or

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:

Factory.condition(String, Object...)

or

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:

Factory.condition(String, Object...)

orNot

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

orExists

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

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

Condition not()

Invert this condition

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

Returns:

This condition, inverted