//定义查询的字段 Path path = root.get("id"); CriteriaBuilder.In in = criteriaBuilder.in(path); //in.value(1,2); for (int i = 0; i <5 ; i++) { in.value(i);//存入值 } predicate=criteriaBuilder.and(predicate,in); CriteriaBuilder.In ins = criteriaBuilder.in(root.get("id")); for (int i=0, n=ids.split(",").length;i<n;i++){ ins.value(Integer.parseInt(ids.split(",")[i])); } predicate=criteriaBuilder.and(predicate,ins); //or 最好放在最前面 channel_ids=[1,2,3,4] Predicate predicate = cb.conjunction(); List predicateList = new ArrayList(); for (Object str :channel_ids) { //predicateList.add(criteriaBuilder.like(root.get("orgIds"),"%" + dataPermission)); //predicateList.add(cb.equal(fieldContentInfo.get("channelId"),76)); predicateList.add(cb.equal(fieldContentInfo.get("channelId"),str)); } Predicate [] p = new Predicate[channel_ids.size()]; predicateList.toArray(p); //重点 predicate=(cb.or(p));
关注"都市百货" 了解南陵
微信咨询wanglf2r(不拉群 发广告者勿加)
热门评论