public class Conditions extends Object
Modifier and Type | Method and Description |
---|---|
static ComboCondition |
and()
Convenience method for generating a ComboCondition for joining
conditions using AND.
|
static ComboCondition |
and(Condition... conditions)
Convenience method for generating a ComboCondition for joining
the given conditions using AND.
|
static ComboCondition |
and(Object... conditions)
Convenience method for generating a ComboCondition for joining
the given custom conditions using AND.
|
static BetweenCondition |
between(Object obj,
Object minObj,
Object maxObj)
Convenience method for generating a BETWEEN condition..
|
static CustomCondition |
customCond(Object condObj)
Convenience method for generating a custom condition.
|
static Condition |
emptyCond()
a Condition object which will always return
true for
NestableClause.isEmpty() . |
static BinaryCondition |
equalTo(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is equal to another column.
|
static UnaryCondition |
exists(Object query)
Convenience method for generating a Condition for testing whether a
subquery returns any rows.
|
static BinaryCondition |
greaterThan(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is strictly greater than a given value.
|
static BinaryCondition |
greaterThan(Object value1,
Object value2,
boolean inclusive)
Convenience method for generating a Condition for testing if a column
is greater than a given value (inclusive or exclusive).
|
static BinaryCondition |
greaterThanOrEq(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is greater than or equal to a given value.
|
static InCondition |
in(Object leftObj,
Collection<?> rightObjs)
Convenience method for generating a IN condition..
|
static InCondition |
in(Object leftObj,
Object... rightObjs)
Convenience method for generating a IN condition..
|
static UnaryCondition |
isNotNull(Object value)
Convenience method for generating a Condition for testing if a column
is not
NULL . |
static UnaryCondition |
isNull(Object value)
Convenience method for generating a Condition for testing if a column
is
NULL . |
static BinaryCondition |
lessThan(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is strictly less than another column.
|
static BinaryCondition |
lessThan(Object value1,
Object value2,
boolean inclusive)
Convenience method for generating a Condition for testing if a column
is less than another column (inclusive or exclusive).
|
static BinaryCondition |
lessThanOrEq(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is less than or equal to another column.
|
static BinaryCondition |
like(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is "like" a given value (sql pattern matching).
|
static NotCondition |
not(Object condition)
Convenience method for generating a NOT condition..
|
static BetweenCondition |
notBetween(Object obj,
Object minObj,
Object maxObj)
Convenience method for generating a NOT BETWEEN condition..
|
static BinaryCondition |
notEqualTo(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is not equal to another column.
|
static InCondition |
notIn(Object leftObj,
Collection<?> rightObjs)
Convenience method for generating a NOT IN condition..
|
static InCondition |
notIn(Object leftObj,
Object... rightObjs)
Convenience method for generating a NOT IN condition..
|
static BinaryCondition |
notLike(Object value1,
Object value2)
Convenience method for generating a Condition for testing if a column
is not "like" a given value (sql pattern matching).
|
static ComboCondition |
or()
Convenience method for generating a ComboCondition for joining
conditions using OR.
|
static ComboCondition |
or(Condition... conditions)
Convenience method for generating a ComboCondition for joining
the given conditions using OR.
|
static ComboCondition |
or(Object... conditions)
Convenience method for generating a ComboCondition for joining
the given custom conditions using OR.
|
static UnaryCondition |
unique(Object query)
Convenience method for generating a Condition for testing whether a
subquery returns exactly one row.
|
public static BinaryCondition lessThan(Object value1, Object value2, boolean inclusive)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition lessThan(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition lessThanOrEq(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition greaterThan(Object value1, Object value2, boolean inclusive)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition greaterThan(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition greaterThanOrEq(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition equalTo(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition notEqualTo(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition like(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static BinaryCondition notLike(Object value1, Object value2)
Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ComboCondition and()
public static ComboCondition and(Condition... conditions)
public static ComboCondition and(Object... conditions)
Object
-> Condition
conversions handled by
Converter.CUSTOM_TO_CONDITION
.
public static ComboCondition or()
public static ComboCondition or(Condition... conditions)
public static ComboCondition or(Object... conditions)
Object
-> Condition
conversions handled by
Converter.CUSTOM_TO_CONDITION
.
public static UnaryCondition isNull(Object value)
NULL
.
Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static UnaryCondition isNotNull(Object value)
NULL
.
Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static UnaryCondition exists(Object query)
Object
-> SqlObject
conversions handled by
Converter.CUSTOM_TO_SUBQUERY
.
public static UnaryCondition unique(Object query)
Object
-> SqlObject
conversions handled by
Converter.CUSTOM_TO_SUBQUERY
.
public static NotCondition not(Object condition)
Object
-> Condition
conversions handled by
Converter.toConditionObject(Object)
.
public static InCondition in(Object leftObj, Object... rightObjs)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
Value Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static InCondition in(Object leftObj, Collection<?> rightObjs)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
Value Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static InCondition notIn(Object leftObj, Object... rightObjs)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
Value Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static InCondition notIn(Object leftObj, Collection<?> rightObjs)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
Value Object
-> SqlObject
conversions handled by
Converter.COLUMN_VALUE_TO_OBJ
.
public static BetweenCondition between(Object obj, Object minObj, Object maxObj)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
public static BetweenCondition notBetween(Object obj, Object minObj, Object maxObj)
Column Object
-> SqlObject
conversions handled by
Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column)
.
public static CustomCondition customCond(Object condObj)
public static Condition emptyCond()
true
for
NestableClause.isEmpty()
. useful for selectively including condition
blocksCopyright © 2006–2021 OpenHMS. All rights reserved.