如下,想搜索time1和time2之间的数据,但是查不到cb是重写了方法中的参数CriteriaBuilder,root是参数Rootpredicates.add(cb.between(root.get("createTime"),time1,time2));方...
如下,想搜索time1和time2之间的数据,但是查不到
cb是重写了方法中的参数CriteriaBuilder,root是参数Root
predicates.add(cb.between(root.get("createTime"),time1,time2));
方法代码:
public Page pageList(final GridReq req) {
Page page = userPointsOrderDao.findAll(new Specification() {
@Override
public Predicate toPredicate(Root root, CriteriaQuery> query, CriteriaBuilder cb) {
List predicates = new ArrayList<>();
query.orderBy(cb.desc(root. get("guid")));
long userId = StringUtils.isEmpty(req.getKeys()) ? 0 : NumberUtils.toLong(req.getKeys().trim());
if (userId > 0)
predicates.add(cb.equal(root. get("userId"), userId));
if ((req.getOther() != null && req.getOther().has("startTime"))&&
(req.getOther() != null && req.getOther().has("endTime"))) {
String startTime = req.getOther().get("startTime").toString();
Date time1 = TimeUtil.parseDate(startTime,"yyyy-MM-dd HH:mm:ss");
String endTime = req.getOther().get("endTime").toString();
Date time2 = TimeUtil.parseDate(endTime,"yyyy-MM-dd HH:mm:ss");
predicates.add(cb.between(root.get("createTime"),time1,time2));
}
return cb.and(predicates.toArray(new Predicate[predicates.size()]));
}
}, new PageRequest(req.getPage() - 1, req.getRows()));
return page;
}
展开