java data jpa_java中Spring data jpa通过Predicate查询时间段

如下，想搜索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;

}

展开