Hql语句

冒号后紧跟变量  :hdsj1 

字段 匹配很多，放在集合中，in (:searchId)

                List searchIds=new ArrayList(); 
		searchIds.add("0");
		String bmbh=getLoginuser().getSysUsers().getJgid();
		Map map = new HashMap();
		String hql="";
		String hql_count="";
		List<Department> depts=departmentService.getAllXjbm(bmbh);
		for(Department dept1:depts){
			String xjbmid=dept1.getAid();
			searchIds.add(xjbmid);
		}
		hql = "from Xlgzgl t where cjzssbmid in (:searchId) ";
		hql_count = "select count(t.aid) from Xlgzgl t where cjzssbmid in (:searchId) ";
		map.put("searchId",  searchIds);
		}

时间匹配

if (StringUtils.isNotBlank(hdsj1)&&StringUtils.isNotBlank(hdsj2)) {
			hql = hql + " and t.hdsj >=:hdsj1 and t.hdsj<=:hdsj2 ";
			hql_count = hql_count + " and t.hdsj >=:hdsj1 and t.hdsj<=:hdsj2 ";
			map.put("hdsj1", DateUtil.convertStringToTime(hdsj1+" 00:00:00"));
			map.put("hdsj2", DateUtil.convertStringToTime(hdsj2+" 23:59:59"));
		}