org.nutz.dao.util.cri

类 SqlExpressionGroup

java.lang.Object

org.nutz.dao.impl.sql.pojo.AbstractPItem

org.nutz.dao.util.cri.SqlExpressionGroup

所有已实现的接口:

Serializable, PItem, SqlExpression

public class SqlExpressionGroup
extends AbstractPItem
implements SqlExpression

组合一组表达式，只能增加，不能减少

另请参阅:

序列化表格

字段概要

字段

限定符和类型	字段和说明
protected boolean	not

从类继承的字段 org.nutz.dao.impl.sql.pojo.AbstractPItem

pojo, top

构造器概要

构造器

构造器和说明
SqlExpressionGroup()

方法概要

限定符和类型	方法和说明
SqlExpressionGroup	and(SqlExpression exp)
SqlExpressionGroup	and(String name, String op, Object value)
SqlExpressionGroup	andBetween(String name, Object min, Object max)
SqlExpressionGroup	andEquals(String name, Object val)
SqlExpressionGroup	andGT(String name, long val)
SqlExpressionGroup	andGTE(String name, long val)
SqlExpressionGroup	andIn(String name, long... ids)
SqlExpressionGroup	andIn(String name, String... names)
SqlExpressionGroup	andInBySql(String name, String subSql, Object... args)
SqlExpressionGroup	andInIntArray(String name, int... ids)
SqlExpressionGroup	andIsNull(String name)
SqlExpressionGroup	andLike(String name, String value)
SqlExpressionGroup	andLike(String name, String value, boolean ignoreCase)
SqlExpressionGroup	andLike(String name, String value, String left, String right, boolean ignoreCase)
SqlExpressionGroup	andLikeL(String name, String value)
SqlExpressionGroup	andLikeR(String name, String value)
SqlExpressionGroup	andLT(String name, long val)
SqlExpressionGroup	andLTE(String name, long val)
SqlExpressionGroup	andNotEquals(String name, Object val)
SqlExpressionGroup	andNotIn(String name, int... ids)
SqlExpressionGroup	andNotIn(String name, long... ids)
SqlExpressionGroup	andNotIn(String name, String... names)
SqlExpressionGroup	andNotInBySql(String name, String subSql, Object... args)
SqlExpressionGroup	andNotIsNull(String name)
SqlExpressionGroup	andNotLike(String name, String value)
SqlExpressionGroup	andNotLike(String name, String value, boolean ignoreCase)
SqlExpressionGroup	andNotLike(String name, String value, String left, String right, boolean ignoreCase)
SqlExpressionGroup	andNotLikeL(String name, String value)
SqlExpressionGroup	andNotLikeR(String name, String value)
List<SqlExpression>	cloneExps()
List<SqlExpression>	getExps()
boolean	isEmpty()
int	joinAdaptor(Entity<?> en, ValueAdaptor[] adaptors, int off) 根据自身的元素内容，为适配器数组填充适配器
int	joinParams(Entity<?> en, Object obj, Object[] params, int off) 根据自身的元素内容，为参数数组填充参数
void	joinSql(Entity<?> en, StringBuilder sb) 将当前的语句组成元素输出，以便组成 PreparedStatement 语句
SqlExpressionGroup	or(SqlExpression exp)
SqlExpressionGroup	or(String name, String op, Object value)
SqlExpressionGroup	orBetween(String name, Object min, Object max)
SqlExpressionGroup	orEquals(String name, Object val)
SqlExpressionGroup	orGT(String name, long val)
SqlExpressionGroup	orGTE(String name, long val)
SqlExpressionGroup	orIn(String name, int... ids)
SqlExpressionGroup	orIn(String name, long... ids)
SqlExpressionGroup	orIn(String name, String... names)
SqlExpressionGroup	orInBySql(String name, String subSql, Object... args)
SqlExpressionGroup	orIsNull(String name)
SqlExpressionGroup	orLike(String name, String value)
SqlExpressionGroup	orLike(String name, String value, boolean ignoreCase)
SqlExpressionGroup	orLike(String name, String value, String left, String right, boolean ignoreCase)
SqlExpressionGroup	orLikeL(String name, String value)
SqlExpressionGroup	orLikeR(String name, String value)
SqlExpressionGroup	orLT(String name, long val)
SqlExpressionGroup	orLTE(String name, long val)
SqlExpressionGroup	orNotEquals(String name, Object val)
SqlExpressionGroup	orNotIn(String name, int... ids)
SqlExpressionGroup	orNotIn(String name, long... ids)
SqlExpressionGroup	orNotIn(String name, String... names)
SqlExpressionGroup	orNotInBySql(String name, String subSql, Object... args)
SqlExpressionGroup	orNotIsNull(String name)
SqlExpressionGroup	orNotLike(String name, String value)
SqlExpressionGroup	orNotLike(String name, String value, boolean ignoreCase)
SqlExpressionGroup	orNotLike(String name, String value, String left, String right, boolean ignoreCase)
SqlExpressionGroup	orNotLikeL(String name, String value)
SqlExpressionGroup	orNotLikeR(String name, String value)
int	paramCount(Entity<?> en)
SqlExpression	setNot(boolean not)
void	setPojo(Pojo pojo) 设置所属的 POJO 对象

从类继承的方法 org.nutz.dao.impl.sql.pojo.AbstractPItem

_en, _fmtcolnm, getFieldMatcher, getPojo, getSqlType, isTop, setTop, setupPojo

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

从接口继承的方法 org.nutz.dao.sql.PItem

getPojo, toString

字段详细资料

not

protected boolean not

构造器详细资料

SqlExpressionGroup

public SqlExpressionGroup()

方法详细资料

and

public SqlExpressionGroup and(String name,
                              String op,
                              Object value)

and

public SqlExpressionGroup and(SqlExpression exp)

andEquals

public SqlExpressionGroup andEquals(String name,
                                    Object val)

andNotEquals

public SqlExpressionGroup andNotEquals(String name,
                                       Object val)

andIsNull

public SqlExpressionGroup andIsNull(String name)

andNotIsNull

public SqlExpressionGroup andNotIsNull(String name)

andGT

public SqlExpressionGroup andGT(String name,
                                long val)

andGTE

public SqlExpressionGroup andGTE(String name,
                                 long val)

andLT

public SqlExpressionGroup andLT(String name,
                                long val)

andLTE

public SqlExpressionGroup andLTE(String name,
                                 long val)

andIn

public SqlExpressionGroup andIn(String name,
                                long... ids)

andInIntArray

public SqlExpressionGroup andInIntArray(String name,
                                        int... ids)

andIn

public SqlExpressionGroup andIn(String name,
                                String... names)

andInBySql

public SqlExpressionGroup andInBySql(String name,
                                     String subSql,
                                     Object... args)

andNotInBySql

public SqlExpressionGroup andNotInBySql(String name,
                                        String subSql,
                                        Object... args)

andNotIn

public SqlExpressionGroup andNotIn(String name,
                                   long... ids)

andNotIn

public SqlExpressionGroup andNotIn(String name,
                                   int... ids)

andNotIn

public SqlExpressionGroup andNotIn(String name,
                                   String... names)

andLike

public SqlExpressionGroup andLike(String name,
                                  String value)

andLikeL

public SqlExpressionGroup andLikeL(String name,
                                   String value)

andLikeR

public SqlExpressionGroup andLikeR(String name,
                                   String value)

andNotLike

public SqlExpressionGroup andNotLike(String name,
                                     String value)

andNotLikeL

public SqlExpressionGroup andNotLikeL(String name,
                                      String value)

andNotLikeR

public SqlExpressionGroup andNotLikeR(String name,
                                      String value)

andLike

public SqlExpressionGroup andLike(String name,
                                  String value,
                                  boolean ignoreCase)

andNotLike

public SqlExpressionGroup andNotLike(String name,
                                     String value,
                                     boolean ignoreCase)

andLike

public SqlExpressionGroup andLike(String name,
                                  String value,
                                  String left,
                                  String right,
                                  boolean ignoreCase)

andNotLike

public SqlExpressionGroup andNotLike(String name,
                                     String value,
                                     String left,
                                     String right,
                                     boolean ignoreCase)

or

public SqlExpressionGroup or(String name,
                             String op,
                             Object value)

or

public SqlExpressionGroup or(SqlExpression exp)

orEquals

public SqlExpressionGroup orEquals(String name,
                                   Object val)

orNotEquals

public SqlExpressionGroup orNotEquals(String name,
                                      Object val)

orIsNull

public SqlExpressionGroup orIsNull(String name)

orNotIsNull

public SqlExpressionGroup orNotIsNull(String name)

orGT

public SqlExpressionGroup orGT(String name,
                               long val)

orGTE

public SqlExpressionGroup orGTE(String name,
                                long val)

orLT

public SqlExpressionGroup orLT(String name,
                               long val)

orLTE

public SqlExpressionGroup orLTE(String name,
                                long val)

orIn

public SqlExpressionGroup orIn(String name,
                               long... ids)

orIn

public SqlExpressionGroup orIn(String name,
                               int... ids)

orIn

public SqlExpressionGroup orIn(String name,
                               String... names)

orInBySql

public SqlExpressionGroup orInBySql(String name,
                                    String subSql,
                                    Object... args)

orNotInBySql

public SqlExpressionGroup orNotInBySql(String name,
                                       String subSql,
                                       Object... args)

orNotIn

public SqlExpressionGroup orNotIn(String name,
                                  long... ids)

orNotIn

public SqlExpressionGroup orNotIn(String name,
                                  int... ids)

orNotIn

public SqlExpressionGroup orNotIn(String name,
                                  String... names)

orLike

public SqlExpressionGroup orLike(String name,
                                 String value)

orLikeL

public SqlExpressionGroup orLikeL(String name,
                                  String value)

orLikeR

public SqlExpressionGroup orLikeR(String name,
                                  String value)

orNotLike

public SqlExpressionGroup orNotLike(String name,
                                    String value)

orNotLikeL

public SqlExpressionGroup orNotLikeL(String name,
                                     String value)

orNotLikeR

public SqlExpressionGroup orNotLikeR(String name,
                                     String value)

orLike

public SqlExpressionGroup orLike(String name,
                                 String value,
                                 boolean ignoreCase)

orNotLike

public SqlExpressionGroup orNotLike(String name,
                                    String value,
                                    boolean ignoreCase)

orLike

public SqlExpressionGroup orLike(String name,
                                 String value,
                                 String left,
                                 String right,
                                 boolean ignoreCase)

orNotLike

public SqlExpressionGroup orNotLike(String name,
                                    String value,
                                    String left,
                                    String right,
                                    boolean ignoreCase)

andBetween

public SqlExpressionGroup andBetween(String name,
                                     Object min,
                                     Object max)

orBetween

public SqlExpressionGroup orBetween(String name,
                                    Object min,
                                    Object max)

setPojo

public void setPojo(Pojo pojo)

从接口复制的说明: PItem

设置所属的 POJO 对象

指定者:

setPojo 在接口中 PItem

覆盖:

setPojo 在类中 AbstractPItem

参数:

pojo - 所属的 POJO 对象

joinSql

public void joinSql(Entity<?> en,
                    StringBuilder sb)

从接口复制的说明: PItem

将当前的语句组成元素输出，以便组成 PreparedStatement 语句

指定者:

joinSql 在接口中 PItem

参数:

en - 参考的实体，如果为 null，则取当前元素所在 POJO 的关联实体

sb - 文本缓冲

joinAdaptor

public int joinAdaptor(Entity<?> en,
                       ValueAdaptor[] adaptors,
                       int off)

从接口复制的说明: PItem

根据自身的元素内容，为适配器数组填充适配器

指定者:

joinAdaptor 在接口中 PItem

参数:

en - 参考的实体，如果为 null，则取当前元素所在 POJO 的关联实体

adaptors - 待填充的适配器数组

off - 开始下标

返回:

结束后，下一项开始的下标

joinParams

public int joinParams(Entity<?> en,
                      Object obj,
                      Object[] params,
                      int off)

从接口复制的说明: PItem

根据自身的元素内容，为参数数组填充参数

指定者:

joinParams 在接口中 PItem

参数:

en - 参考的实体，如果为 null，则取当前元素所在 POJO 的关联实体

obj - 当前操作对象

params - 待填充的参数数组

off - 开始下标

返回:

结束后，下一项开始的下标

paramCount

public int paramCount(Entity<?> en)

指定者:

paramCount 在接口中 PItem

参数:

en - 参考的实体，如果为 null，则取当前元素所在 POJO 的关联实体

返回:

本语句元素所包含的参数数目

setNot

public SqlExpression setNot(boolean not)

指定者:

setNot 在接口中 SqlExpression

isEmpty

public boolean isEmpty()

cloneExps

public List<SqlExpression> cloneExps()

getExps

public List<SqlExpression> getExps()