2016年12月8日 | Wizzer | 评论 Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(src)) { cnd.and("srcFrom", "=", src); } if (!Strings.isBlank(name)) { String[] n = StringUtils.split(name, " "); SqlExpressionGroup group = new SqlExpressionGroup(); for (String s : n) { SqlExpression sqlExpression = Cnd.exp("srcName", "like", "%" + s + "%"); group.or(sqlExpression); } cnd.and(group); } cnd.and(Cnd.exps("productSku", "=", "").or("productSku", "is", null)); 2,289 total views, 1 views today