如何在休眠标准中使用 CURRENT_DATE 函数？

Question

我想将以下 HQL 转换为 Criteria 表示法：

from Deal
where CURRENT_DATE between startDate and endDate

我尝试使用 Restrictions. Between 但它无法识别 current_date

Criteria c = session().createCriteria(Deal.class)
   .add(Restrictions.between("CURRENT_DATE", "startDate", "endDate");

Answer 1

只需使用 UGLY java 日历即可！

Calendar c = new GregorianCalendar();
c.set(Calendar.HOUR_OF_DAY, 0);
c.set(Calendar.MINUTE, 0);
c.set(Calendar.SECOND, 0);
c.set(Calendar.MILLISECOND, 0);

Date currentDate = c.getTime();

Criteria criteria = session.createCriteria(Deal.class)
.add(Restrictions.gt("startDate", currentDate))     
.add(Restrictions.lt("endDate", currentDate));