public List getCountAssessmentIdByAreaCode(Map map)
throws Exception {
StringBuffer sbf = new StringBuffer();
sbf.append("SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1"); String areaCode = (String)map.get("areaCode");
if("2".equals((String)map.get("userLevel"))){
if("110000".equals(areaCode) || "310000".equals(areaCode) || "120000".equals(areaCode) || "500000".equals(areaCode)){
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.countyCode is not null");
}else{
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.cityCode is not null");
}
}else if("3".equals((String)map.get("userLevel"))){
sbf.append(" AND org.cityCode = '"+areaCode+"' AND org.countyCode is not null");
}
return assessmentDao.getCountAssessmentIdByAreaCode(sbf.toString());
} @Override
public List getCountAssessmentIdByAreaCode(String sql)
throws Exception {
List assessIdList = (List)this.getHibernateTemplate().find(sql);
return assessIdList;
}这是我service实现类和dao实现类中的两个方法,执行后报错了,错误如下:
org.springframework.orm.hibernate3.HibernateQueryException: aggregate function expected before ( in SELECT [SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1 AND org.cityCode = '340500' AND org.countyCode is not null]; nested exception is org.hibernate.QueryException: aggregate function expected before ( in SELECT [SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1 AND org.cityCode = '340500' AND org.countyCode is not null]
throws Exception {
StringBuffer sbf = new StringBuffer();
sbf.append("SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1"); String areaCode = (String)map.get("areaCode");
if("2".equals((String)map.get("userLevel"))){
if("110000".equals(areaCode) || "310000".equals(areaCode) || "120000".equals(areaCode) || "500000".equals(areaCode)){
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.countyCode is not null");
}else{
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.cityCode is not null");
}
}else if("3".equals((String)map.get("userLevel"))){
sbf.append(" AND org.cityCode = '"+areaCode+"' AND org.countyCode is not null");
}
return assessmentDao.getCountAssessmentIdByAreaCode(sbf.toString());
} @Override
public List getCountAssessmentIdByAreaCode(String sql)
throws Exception {
List assessIdList = (List)this.getHibernateTemplate().find(sql);
return assessIdList;
}这是我service实现类和dao实现类中的两个方法,执行后报错了,错误如下:
org.springframework.orm.hibernate3.HibernateQueryException: aggregate function expected before ( in SELECT [SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1 AND org.cityCode = '340500' AND org.countyCode is not null]; nested exception is org.hibernate.QueryException: aggregate function expected before ( in SELECT [SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1 AND org.cityCode = '340500' AND org.countyCode is not null]
解决方案 »
- hibernate sqlquery执行结果和直接在数据库中不一致
- Hibernate 注解bean关联 启动tomcat异常错误 求解决
- Java中List排序实体,帮忙看看呀
- 求助一个正则表达式
- spring2.05 父子类的ioc注入问题
- hibernate中如果使用uuid.hex主键生成策略,是不是主键类型一定要是string的
- 高手帮忙呀 客户端调用问题
- Struts遇到java.lang.NullPointerException错误了!救命
- 谁知道哪里有下j2ee的jar包的地方?
- struts2 datetimepicker 不显示问题
- hibernate 修改问题
- 询问技术贴!如何实现安卓手机与手机之间的语音通信!
@Override
public List getCountAssessmentIdByAreaCode(Map map)
throws Exception {
StringBuffer sbf = new StringBuffer();
sbf.append("SELECT DISTINCT(org.assessId) FROM com.mtm.nhis.hiir.performance.survey.po.AssessmentOrg org WHERE 1=1"); String areaCode = (String)map.get("areaCode");
if("2".equals((String)map.get("userLevel"))){
if("110000".equals(areaCode) || "310000".equals(areaCode) || "120000".equals(areaCode) || "500000".equals(areaCode)){
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.countyCode is not null");
}else{
sbf.append(" AND org.provinceCode = '"+areaCode+"' AND org.cityCode is not null");
}
}else if("3".equals((String)map.get("userLevel"))){
sbf.append(" AND org.cityCode = '"+areaCode+"' AND org.countyCode is not null");
}
return assessmentDao.getCountAssessmentIdByAreaCode(sbf.toString());
} @Override
public List getCountAssessmentIdByAreaCode(String sql)
throws Exception {
List assessIdList = (List)this.getHibernateTemplate().find(sql);
return assessIdList;
}