public class SqlCondition
extends java.lang.Object
implements java.io.Serializable
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
EQUAL |
static java.lang.String |
GREATER |
static java.lang.String |
NOT_EQUAL |
static java.lang.String |
SMALLER |
Constructor and Description |
---|
SqlCondition() |
SqlCondition(SqlCondition cond) |
SqlCondition(java.lang.String cond) |
Modifier and Type | Method and Description |
---|---|
void |
add(SqlCondition condition)
Same as
and(SqlCondition) |
void |
add(java.lang.String condition)
Same as
and(String) |
void |
addEqual(DBColumnKey field,
int value)
ANDs an equals condition (using the '=' operator)
|
void |
addEqual(DBColumnKey field,
java.lang.String value)
ANDs an equals condition (using the '=' operator)
|
void |
addEqual(java.lang.String field,
int value)
ANDs an equals condition (using the '=' operator)
|
void |
addEqual(java.lang.String field,
java.lang.String value)
ANDs an equals condition (using the '=' operator)
|
void |
addLike(DBColumnKey field,
java.lang.String sqlPattern)
ANDs a match condition (using the 'like' operator)
|
void |
addLike(java.lang.String field,
java.lang.String sqlPattern)
ANDs a match condition (using the 'like' operator)
|
void |
and(SqlCondition condition)
Adds a nested condition that will be ANDed.
|
void |
and(java.lang.String condition)
Adds a condition that will be ANDed.
|
void |
and(java.lang.String field,
java.lang.String operator,
int value) |
void |
and(java.lang.String field,
java.lang.String operator,
java.lang.String value) |
void |
andEqual(java.lang.String field,
int value)
ANDs an equals condition (using the '=' operator)
|
void |
andEqual(java.lang.String field,
java.lang.String value)
ANDs an equals condition (using the '=' operator)
|
void |
andIsNotNull(DBColumnKey colKey)
ANDs a 'is not NULL' constraint for the given column
|
void |
andIsNotNull(java.lang.String field)
ANDs a 'is not NULL' constraint for the given column
|
void |
andIsNull(DBColumnKey colKey)
ANDs a 'is NULL' constraint for the given column
|
void |
andIsNull(java.lang.String field)
ANDs a 'is NULL' constraint for the given column
|
java.lang.String |
getConditionClause()
Returns the fully expanded SQL condition clause not including the WHERE keyord.
|
java.lang.String |
getWhereCondition()
Returns the fully expanded condition string including the WHERE clause keyord.
|
boolean |
isEmpty() |
void |
or(SqlCondition condition)
Adds a nested condition that will be ORed.
|
void |
or(java.lang.String condition)
Adds a condition that will be ORed.
|
void |
or(java.lang.String field,
java.lang.String operator,
int value) |
void |
or(java.lang.String field,
java.lang.String operator,
java.lang.String value) |
java.lang.String |
toString()
Same as getCondition().
|
public static final java.lang.String NOT_EQUAL
public static final java.lang.String EQUAL
public static final java.lang.String GREATER
public static final java.lang.String SMALLER
public SqlCondition()
public SqlCondition(java.lang.String cond)
public SqlCondition(SqlCondition cond)
public void add(SqlCondition condition)
and(SqlCondition)
public void add(java.lang.String condition)
and(String)
public void and(java.lang.String field, java.lang.String operator, java.lang.String value)
public void and(java.lang.String field, java.lang.String operator, int value)
public void or(java.lang.String field, java.lang.String operator, java.lang.String value)
public void or(java.lang.String field, java.lang.String operator, int value)
public void addEqual(java.lang.String field, java.lang.String value)
public void addEqual(DBColumnKey field, java.lang.String value)
public void addEqual(java.lang.String field, int value)
public void addEqual(DBColumnKey field, int value)
public void andEqual(java.lang.String field, java.lang.String value)
public void andEqual(java.lang.String field, int value)
public void addLike(java.lang.String field, java.lang.String sqlPattern)
sqlPattern
- any SQL pattern string like 'A%'public void addLike(DBColumnKey field, java.lang.String sqlPattern)
sqlPattern
- any SQL pattern string like 'A%'public void and(SqlCondition condition)
public void and(java.lang.String condition)
public void or(SqlCondition condition)
public void or(java.lang.String condition)
public void andIsNull(DBColumnKey colKey)
public void andIsNull(java.lang.String field)
public void andIsNotNull(DBColumnKey colKey)
public void andIsNotNull(java.lang.String field)
public boolean isEmpty()
public java.lang.String toString()
toString
in class java.lang.Object
getConditionClause()
public java.lang.String getWhereCondition()
getConditionClause()
public java.lang.String getConditionClause()
Copyright © 2014 EsprIT-Systems. All Rights Reserved.