org.jooq

Interface Condition

All Superinterfaces:

QueryPart, java.io.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(Condition other) Combine this condition with another one using the Operator.AND operator.
Condition	and(Field<java.lang.Boolean> other) Combine this condition with another one using the Operator.AND operator.
Condition	and(java.lang.String sql) Combine this condition with another one using the Operator.AND operator.
Condition	and(java.lang.String sql, java.lang.Object... bindings) Combine this condition with another one using the Operator.AND operator.
Condition	and(java.lang.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	andNot(Field<java.lang.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(Condition other) Combine this condition with another one using the Operator.OR operator.
Condition	or(Field<java.lang.Boolean> other) Combine this condition with another one using the Operator.OR operator.
Condition	or(java.lang.String sql) Combine this condition with another one using the Operator.OR operator.
Condition	or(java.lang.String sql, java.lang.Object... bindings) Combine this condition with another one using the Operator.OR operator.
Condition	or(java.lang.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	orNot(Field<java.lang.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<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(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)

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...)

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...)

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(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)

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...)

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...)

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

not

@Support
Condition not()

Invert this condition

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

Returns:

This condition, inverted