将CriteriaBuilder.between（Date）添加到谓词？ [英] Add CriteriaBuilder.between(Date) to Predicate?

问题描述

我是JPA的新手

我正在尝试查询一个表，其输入日期值应该在数据库记录的startDate和endDate之间

I am trying to query a table where my input date value should be between the startDate and endDate of the database record

我正在尝试：

List<Predicate> conditionsList = new ArrayList<Predicate>();
conditionsList.add(criteriaBuilder.between(inputDate, root.get("startDate"), root.get("endDate")));

我从使用JPA / Hibernate Criteria在日期之间拉动：

ParameterExpression<Date> d = criteriaBuilder.parameter(Date.class);
criteriaBuilder.between(d, root.<Date>get("startDate"), root.<Date>get("endDate")); 

但是如何在将CriteriaBuilder添加到Predicate之前将Parameterexpression值设置为inputDate变量值？

But how to set the Parameterexpression value to inputDate variable value before adding the CriteriaBuilder to the Predicate?

推荐答案

这样的事情应该有效......

Something like this should work...

List<Predicate> conditionsList = new ArrayList<Predicate>();
Predicate onStart = criteriaBuilder.greaterThanOrEqualTo(root.get("startDate"), inputDate);
Predicate onEnd = criteriaBuilder.lessThanOrEqualTo(root.get("endDate"), inputDate);
conditionsList.add(onStart);
conditionsList.add(onEnd);
criteriaQuery.select(root).where(conditionsList.toArray(new Predicate[]{}));

这篇关于将CriteriaBuilder.between（Date）添加到谓词？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！