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

最新推荐文章于 2024-05-19 02:40:30 发布

圣杰韩韦

最新推荐文章于 2024-05-19 02:40:30 发布

阅读量2.2w

点赞数 2

分类专栏： Hibernate框架文章标签： hibernate查询 date

本文链接：https://blog.csdn.net/lin062854/article/details/21529487

版权

Hibernate框架专栏收录该内容

5 篇文章 0 订阅

订阅专栏

@Override
	public 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;
	}