public class SqlExpressionGroup extends AbstractPItem implements SqlExpression
限定符和类型 | 字段和说明 |
---|---|
protected boolean |
not |
pojo
构造器和说明 |
---|
SqlExpressionGroup() |
限定符和类型 | 方法和说明 |
---|---|
SqlExpressionGroup |
and(SqlExpression exp) |
SqlExpressionGroup |
and(java.lang.String name,
java.lang.String op,
java.lang.Object value) |
SqlExpressionGroup |
andBetween(java.lang.String name,
java.lang.Object min,
java.lang.Object max) |
SqlExpressionGroup |
andEquals(java.lang.String name,
java.lang.Object val) |
SqlExpressionGroup |
andGT(java.lang.String name,
long val) |
SqlExpressionGroup |
andGTE(java.lang.String name,
long val) |
SqlExpressionGroup |
andIn(java.lang.String name,
long... ids) |
SqlExpressionGroup |
andIn(java.lang.String name,
java.lang.String... names) |
SqlExpressionGroup |
andInBySql(java.lang.String name,
java.lang.String subSql,
java.lang.Object... args) |
SqlExpressionGroup |
andInIntArray(java.lang.String name,
int... ids) |
SqlExpressionGroup |
andIsNull(java.lang.String name) |
SqlExpressionGroup |
andLike(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
andLike(java.lang.String name,
java.lang.String value,
boolean ignoreCase) |
SqlExpressionGroup |
andLike(java.lang.String name,
java.lang.String value,
java.lang.String left,
java.lang.String right,
boolean ignoreCase) |
SqlExpressionGroup |
andLikeL(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
andLikeR(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
andLT(java.lang.String name,
long val) |
SqlExpressionGroup |
andLTE(java.lang.String name,
long val) |
SqlExpressionGroup |
andNotEquals(java.lang.String name,
java.lang.Object val) |
SqlExpressionGroup |
andNotIn(java.lang.String name,
int... ids) |
SqlExpressionGroup |
andNotIn(java.lang.String name,
long... ids) |
SqlExpressionGroup |
andNotIn(java.lang.String name,
java.lang.String... names) |
SqlExpressionGroup |
andNotInBySql(java.lang.String name,
java.lang.String subSql,
java.lang.Object... args) |
SqlExpressionGroup |
andNotIsNull(java.lang.String name) |
SqlExpressionGroup |
andNotLike(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
andNotLike(java.lang.String name,
java.lang.String value,
boolean ignoreCase) |
SqlExpressionGroup |
andNotLike(java.lang.String name,
java.lang.String value,
java.lang.String left,
java.lang.String right,
boolean ignoreCase) |
SqlExpressionGroup |
andNotLikeL(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
andNotLikeR(java.lang.String name,
java.lang.String value) |
java.util.List<SqlExpression> |
cloneExps() |
java.util.List<SqlExpression> |
getExps() |
boolean |
isEmpty() |
int |
joinAdaptor(Entity<?> en,
ValueAdaptor[] adaptors,
int off)
根据自身的元素内容,为适配器数组填充适配器
|
int |
joinParams(Entity<?> en,
java.lang.Object obj,
java.lang.Object[] params,
int off)
根据自身的元素内容,为参数数组填充参数
|
void |
joinSql(Entity<?> en,
java.lang.StringBuilder sb)
将当前的语句组成元素输出,以便组成 PreparedStatement 语句
|
SqlExpressionGroup |
or(SqlExpression exp) |
SqlExpressionGroup |
or(java.lang.String name,
java.lang.String op,
java.lang.Object value) |
SqlExpressionGroup |
orBetween(java.lang.String name,
java.lang.Object min,
java.lang.Object max) |
SqlExpressionGroup |
orEquals(java.lang.String name,
java.lang.Object val) |
SqlExpressionGroup |
orGT(java.lang.String name,
long val) |
SqlExpressionGroup |
orGTE(java.lang.String name,
long val) |
SqlExpressionGroup |
orIn(java.lang.String name,
int... ids) |
SqlExpressionGroup |
orIn(java.lang.String name,
long... ids) |
SqlExpressionGroup |
orIn(java.lang.String name,
java.lang.String... names) |
SqlExpressionGroup |
orInBySql(java.lang.String name,
java.lang.String subSql,
java.lang.Object... args) |
SqlExpressionGroup |
orIsNull(java.lang.String name) |
SqlExpressionGroup |
orLike(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
orLike(java.lang.String name,
java.lang.String value,
boolean ignoreCase) |
SqlExpressionGroup |
orLike(java.lang.String name,
java.lang.String value,
java.lang.String left,
java.lang.String right,
boolean ignoreCase) |
SqlExpressionGroup |
orLikeL(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
orLikeR(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
orLT(java.lang.String name,
long val) |
SqlExpressionGroup |
orLTE(java.lang.String name,
long val) |
SqlExpressionGroup |
orNotEquals(java.lang.String name,
java.lang.Object val) |
SqlExpressionGroup |
orNotIn(java.lang.String name,
int... ids) |
SqlExpressionGroup |
orNotIn(java.lang.String name,
long... ids) |
SqlExpressionGroup |
orNotIn(java.lang.String name,
java.lang.String... names) |
SqlExpressionGroup |
orNotInBySql(java.lang.String name,
java.lang.String subSql,
java.lang.Object... args) |
SqlExpressionGroup |
orNotIsNull(java.lang.String name) |
SqlExpressionGroup |
orNotLike(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
orNotLike(java.lang.String name,
java.lang.String value,
boolean ignoreCase) |
SqlExpressionGroup |
orNotLike(java.lang.String name,
java.lang.String value,
java.lang.String left,
java.lang.String right,
boolean ignoreCase) |
SqlExpressionGroup |
orNotLikeL(java.lang.String name,
java.lang.String value) |
SqlExpressionGroup |
orNotLikeR(java.lang.String name,
java.lang.String value) |
int |
paramCount(Entity<?> en) |
SqlExpression |
setNot(boolean not) |
void |
setPojo(Pojo pojo)
设置所属的 POJO 对象
|
void |
setTop(boolean top) |
_en, _fmtcolnm, getFieldMatcher, getPojo, getSqlType, setupPojo
public SqlExpressionGroup and(java.lang.String name, java.lang.String op, java.lang.Object value)
public SqlExpressionGroup and(SqlExpression exp)
public SqlExpressionGroup andEquals(java.lang.String name, java.lang.Object val)
public SqlExpressionGroup andNotEquals(java.lang.String name, java.lang.Object val)
public SqlExpressionGroup andIsNull(java.lang.String name)
public SqlExpressionGroup andNotIsNull(java.lang.String name)
public SqlExpressionGroup andGT(java.lang.String name, long val)
public SqlExpressionGroup andGTE(java.lang.String name, long val)
public SqlExpressionGroup andLT(java.lang.String name, long val)
public SqlExpressionGroup andLTE(java.lang.String name, long val)
public SqlExpressionGroup andIn(java.lang.String name, long... ids)
public SqlExpressionGroup andInIntArray(java.lang.String name, int... ids)
public SqlExpressionGroup andIn(java.lang.String name, java.lang.String... names)
public SqlExpressionGroup andInBySql(java.lang.String name, java.lang.String subSql, java.lang.Object... args)
public SqlExpressionGroup andNotInBySql(java.lang.String name, java.lang.String subSql, java.lang.Object... args)
public SqlExpressionGroup andNotIn(java.lang.String name, long... ids)
public SqlExpressionGroup andNotIn(java.lang.String name, int... ids)
public SqlExpressionGroup andNotIn(java.lang.String name, java.lang.String... names)
public SqlExpressionGroup andLike(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andLikeL(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andLikeR(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andNotLike(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andNotLikeL(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andNotLikeR(java.lang.String name, java.lang.String value)
public SqlExpressionGroup andLike(java.lang.String name, java.lang.String value, boolean ignoreCase)
public SqlExpressionGroup andNotLike(java.lang.String name, java.lang.String value, boolean ignoreCase)
public SqlExpressionGroup andLike(java.lang.String name, java.lang.String value, java.lang.String left, java.lang.String right, boolean ignoreCase)
public SqlExpressionGroup andNotLike(java.lang.String name, java.lang.String value, java.lang.String left, java.lang.String right, boolean ignoreCase)
public SqlExpressionGroup or(java.lang.String name, java.lang.String op, java.lang.Object value)
public SqlExpressionGroup or(SqlExpression exp)
public SqlExpressionGroup orEquals(java.lang.String name, java.lang.Object val)
public SqlExpressionGroup orNotEquals(java.lang.String name, java.lang.Object val)
public SqlExpressionGroup orIsNull(java.lang.String name)
public SqlExpressionGroup orNotIsNull(java.lang.String name)
public SqlExpressionGroup orGT(java.lang.String name, long val)
public SqlExpressionGroup orGTE(java.lang.String name, long val)
public SqlExpressionGroup orLT(java.lang.String name, long val)
public SqlExpressionGroup orLTE(java.lang.String name, long val)
public SqlExpressionGroup orIn(java.lang.String name, long... ids)
public SqlExpressionGroup orIn(java.lang.String name, int... ids)
public SqlExpressionGroup orIn(java.lang.String name, java.lang.String... names)
public SqlExpressionGroup orInBySql(java.lang.String name, java.lang.String subSql, java.lang.Object... args)
public SqlExpressionGroup orNotInBySql(java.lang.String name, java.lang.String subSql, java.lang.Object... args)
public SqlExpressionGroup orNotIn(java.lang.String name, long... ids)
public SqlExpressionGroup orNotIn(java.lang.String name, int... ids)
public SqlExpressionGroup orNotIn(java.lang.String name, java.lang.String... names)
public SqlExpressionGroup orLike(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orLikeL(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orLikeR(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orNotLike(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orNotLikeL(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orNotLikeR(java.lang.String name, java.lang.String value)
public SqlExpressionGroup orLike(java.lang.String name, java.lang.String value, boolean ignoreCase)
public SqlExpressionGroup orNotLike(java.lang.String name, java.lang.String value, boolean ignoreCase)
public SqlExpressionGroup orLike(java.lang.String name, java.lang.String value, java.lang.String left, java.lang.String right, boolean ignoreCase)
public SqlExpressionGroup orNotLike(java.lang.String name, java.lang.String value, java.lang.String left, java.lang.String right, boolean ignoreCase)
public SqlExpressionGroup andBetween(java.lang.String name, java.lang.Object min, java.lang.Object max)
public SqlExpressionGroup orBetween(java.lang.String name, java.lang.Object min, java.lang.Object max)
public void setPojo(Pojo pojo)
PItem
setPojo
在接口中 PItem
setPojo
在类中 AbstractPItem
pojo
- 所属的 POJO 对象public void joinSql(Entity<?> en, java.lang.StringBuilder sb)
PItem
public int joinAdaptor(Entity<?> en, ValueAdaptor[] adaptors, int off)
PItem
joinAdaptor
在接口中 PItem
en
- 参考的实体,如果为 null,则取当前元素所在 POJO 的关联实体adaptors
- 待填充的适配器数组off
- 开始下标public int joinParams(Entity<?> en, java.lang.Object obj, java.lang.Object[] params, int off)
PItem
joinParams
在接口中 PItem
en
- 参考的实体,如果为 null,则取当前元素所在 POJO 的关联实体obj
- 当前操作对象params
- 待填充的参数数组off
- 开始下标public int paramCount(Entity<?> en)
paramCount
在接口中 PItem
en
- 参考的实体,如果为 null,则取当前元素所在 POJO 的关联实体public SqlExpression setNot(boolean not)
setNot
在接口中 SqlExpression
public boolean isEmpty()
public java.util.List<SqlExpression> cloneExps()
public void setTop(boolean top)
public java.util.List<SqlExpression> getExps()