hibernate 使用date条件

SERVICE层：

String period = (String)queryCondition.get("period");

Calendar calendar = Calendar.getInstance();
  int day = calendar.get(Calendar.DATE);
  Date periodFormat = DateUtil.formDate(Integer.parseInt(period.substring(0, 4)), Integer.parseInt(period.substring(4, 6)) , day); // 传入当前的年月日
  queryCondition.put("date", periodFormat);

DAO层：

String hql = "from CpmOrg a where a.orgG = :orgg and a.porg = :porg  and a.frdate<= :date and (a.todate>= :date or a.todate is null) and a.fscard = 'Y' order by a.preorg";