1. 精确到某一天
if(geReqMain.getInputDate()!=null){
list.add(cb.equal(root.<Date> get("inputDate"), geReqMain.getInputDate()));
}
2.时间段查询
传入一个开始时间(beginDate)以及结束时间(endDate)与某个时间(someTime)进行比较:
restrictions = criteriaBuilder.and(restrictions, criteriaBuilder.greaterThanOrEqualTo(root.<Date> get("someTime"), beginDate));
restrictions = criteriaBuilder.and(restrictions, criteriaBuilder.lessThanOrEqualTo(root.<Date> get("someTime"), endDate));
其实就是两个方法不一样:大于用greaterThanOrEqualTo(...)和小于用lessThanOrEqualTo(...)
if (invoiceCreateStart != null) {
predicateList.add(criteriaBuilder.greaterThanOrEqualTo(root.get("firstInsert").as(Date.class), invoiceCreateStart));
}
if (invoiceCreateEnd != null) {
predicateList.add(criteriaBuilder.lessThanOrEqualTo(root.get("firstInsert").as(Date.class), invoiceCreateEnd));
}
模糊查
springJpa关于Date查询
最新推荐文章于 2024-06-17 16:04:27 发布