wx.xql.Q.GenericCriteria,wx.xql.Q.Token

使用方法一:
GenericCriteria c=new GenericCriteria();
String sql=request.getParameter("sql");
if(StringUtils.isNoneBlank(sql)) {
 sql = sql.trim();
 if(sql.indexOf("order")==0)
  c.add(new Token("1=1 "+sql));
 else
  c.add(new Token(sql));
}

使用方法二:
GenericCriteria c=new GenericCriteria();
GenericCriteria c2=new GenericCriteria();
GenericCriteria c3=new GenericCriteria();
String search=servletRequest.getParameter("search");
if(StringUtils.isNotBlank(search)) {
c.add(new Token("code like"),new ValueToken("%"+search+"%"));
c2.add(new Token("name like"),new ValueToken("%"+search+"%"));
c3.add(new Token("fname like"),new ValueToken("%"+search+"%"));

UserCriteria criteria = new UserCriteria ();
criteria.idEq(1);
criteria.Q().and(c.orQ()).or(c2.orQ()).or(c3.orQ());
意思就是:select * from user where id=1 and (code like '' or name like '' or fname like '')
正在加载评论...