Interface ColumnConditions<T>
- Type Parameters:
T- the attribute value type
- All Known Subinterfaces:
Column<T>
Creates
ColumnConditions.
An 'in' or 'notIn' condition requires at least one value, an empty collection is refused with an
IllegalArgumentException. Where the values may be empty the caller decides what none means,
typically no rows for 'in', without a query, and no condition for 'notIn'.
-
Method Summary
Modifier and TypeMethodDescriptionReturns a 'between'ColumnCondition.betweenExclusive(T lower, T upper) Returns a 'betweenExclusive'ColumnCondition.static <T> ColumnConditions<T> conditions(Column<T> column) Instantiates a newColumnConditionsinstanceReturns an 'equalTo'ColumnConditionor 'isNull' in casevalueis null.equalToIgnoreCase(@Nullable Character value) Returns a case-insensitive 'equalTo'ColumnConditionor 'isNull' in casevalueis null.equalToIgnoreCase(@Nullable String value) Returns a case-insensitive 'equalTo'ColumnConditionor 'isNull' in casevalueis null.greaterThan(T lower) Returns a 'greaterThan'ColumnCondition.greaterThanOrEqualTo(T lower) Returns a 'greaterThanOrEqualTo'ColumnCondition.in(Collection<? extends T> values) Returns an 'in'ColumnCondition.Returns an 'in'ColumnCondition.inIgnoreCase(String... values) Returns a case-insensitive 'in'ColumnCondition.inIgnoreCase(Collection<String> values) Returns a case-insensitive 'in'ColumnCondition.Returns an 'isNotNull'ColumnCondition.isNull()Returns an 'isNull'ColumnCondition.Returns a 'lessThan'ColumnCondition.lessThanOrEqualTo(T upper) Returns a 'lessThanOrEqualTo'ColumnCondition.Returns a 'like'ColumnConditionor 'isNull' in casevalueis null.likeIgnoreCase(@Nullable String value) Returns a case-insensitive 'like'ColumnConditionor 'isNull' in casevalueis null.notBetween(T lower, T upper) Returns a 'notBetween'ColumnCondition.notBetweenExclusive(T lower, T upper) Returns a 'notBetweenExclusive'ColumnCondition.notEqualTo(@Nullable T value) Returns a 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.Returns a case-insensitive 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.notEqualToIgnoreCase(@Nullable String value) Returns a case-insensitive 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.notIn(Collection<? extends T> values) Returns a 'notIn'ColumnCondition.Returns a 'notIn'ColumnCondition.notInIgnoreCase(String... values) Returns a case-insensitive 'notIn'ColumnCondition.notInIgnoreCase(Collection<String> values) Returns a case-insensitive 'notIn'ColumnCondition.Returns a 'notLike'ColumnConditionor 'isNotNull' in casevalueis null.notLikeIgnoreCase(@Nullable String value) Returns a case-insensitive 'notLike'ColumnConditionor 'isNotNull' in casevalueis null.
-
Method Details
-
equalTo
Returns an 'equalTo'ColumnConditionor 'isNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
notEqualTo
Returns a 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
equalToIgnoreCase
Returns a case-insensitive 'equalTo'ColumnConditionor 'isNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
equalToIgnoreCase
Returns a case-insensitive 'equalTo'ColumnConditionor 'isNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
notEqualToIgnoreCase
Returns a case-insensitive 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
notEqualToIgnoreCase
Returns a case-insensitive 'notEqualTo'ColumnConditionor 'isNotNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
like
Returns a 'like'ColumnConditionor 'isNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
notLike
Returns a 'notLike'ColumnConditionor 'isNotNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
likeIgnoreCase
Returns a case-insensitive 'like'ColumnConditionor 'isNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
notLikeIgnoreCase
Returns a case-insensitive 'notLike'ColumnConditionor 'isNotNull' in casevalueis null.- Parameters:
value- the value to use in the condition- Returns:
- a
ColumnCondition
-
in
Returns an 'in'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
notIn
Returns a 'notIn'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
in
Returns an 'in'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
notIn
Returns a 'notIn'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
inIgnoreCase
Returns a case-insensitive 'in'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
notInIgnoreCase
Returns a case-insensitive 'notIn'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
inIgnoreCase
Returns a case-insensitive 'in'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
notInIgnoreCase
Returns a case-insensitive 'notIn'ColumnCondition.- Parameters:
values- the values to use in the condition- Returns:
- a
ColumnCondition - Throws:
NullPointerException- in casevaluesis null or contains a null valueIllegalArgumentException- in casevaluesis empty
-
lessThan
Returns a 'lessThan'ColumnCondition.- Parameters:
upper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in caseupperis null
-
lessThanOrEqualTo
Returns a 'lessThanOrEqualTo'ColumnCondition.- Parameters:
upper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in caseupperis null
-
greaterThan
Returns a 'greaterThan'ColumnCondition.- Parameters:
lower- the lower bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in caseloweris null
-
greaterThanOrEqualTo
Returns a 'greaterThanOrEqualTo'ColumnCondition.- Parameters:
lower- the lower bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in caseloweris null
-
betweenExclusive
Returns a 'betweenExclusive'ColumnCondition.- Parameters:
lower- the lower boundupper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in case eitherlowerorupperis null
-
between
Returns a 'between'ColumnCondition.- Parameters:
lower- the lower boundupper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in case eitherlowerorupperis null
-
notBetweenExclusive
Returns a 'notBetweenExclusive'ColumnCondition.- Parameters:
lower- the lower boundupper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in case eitherlowerorupperis null
-
notBetween
Returns a 'notBetween'ColumnCondition.- Parameters:
lower- the lower boundupper- the upper bound- Returns:
- a
ColumnCondition - Throws:
IllegalArgumentException- in case eitherlowerorupperis null
-
isNull
-
isNotNull
-
conditions
Instantiates a newColumnConditionsinstanceUsed by
Column, which provides these conditions itself, applications create them from the column.- Type Parameters:
T- the column type- Parameters:
column- the column- Returns:
- a new
ColumnConditionsinstance
-