Hibernate HQL查询中对日期的查询操作总结

来源：互联网发布：mac版优酷缓存视频编辑：程序博客网时间：2024/04/29 18:03

@Overridepublic int getCount(PlanSearchCriteria criteria) throws Exception {StringBuilder hql = new StringBuilder();hql.append("SELECT COUNT(*) FROM Plan plan ");Map<String,Object> parameters = new HashMap<String,Object>();         hql.append(" WHERE 1 = 1 ");if(StringUtils.isNotEmpty(criteria.getPlanStatus())) {hql.append(" AND plan.planStatus = :planStatus ");parameters.put("planStatus", PlanStatus.valueOf(criteria.getPlanStatus()));}if(StringUtils.isNotEmpty(criteria.getPlanType())) {hql.append(" AND plan.planType = :planType ");parameters.put("planType", PlanType.valueOf(criteria.getPlanType()));}if(StringUtils.isNotEmpty(criteria.getNoticeTime())) {hql.append(" AND to_char(plan.notice.noticeTime,'yyyy-MM-dd') = :noticeTime" );parameters.put("noticeTime", criteria.getNoticeTime());}Query query = getSession().createQuery(hql.toString());return ((Long) setParameter(query,parameters).uniqueResult()).intValue();}private Query setParameter(Query query,Map<String,Object> parameters) {if(parameters.get("planStatus") != null) {query.setParameter("planStatus", parameters.get("planStatus"));}if(parameters.get("planType") != null) {query.setParameter("planType", parameters.get("planType"));}if(parameters.get("noticeTime") != null) {query.setParameter("noticeTime", parameters.get("noticeTime"));}return query;}

1 0