hibernate中的query.uniqueResult()统计返回一个整型数据
public int selectAll(final String time1,final String time2, final int cityname, final String airstatus) {final StringBuffer hql = new StringBuffer("select count(air) from TableName air where air.cityname="+ cityname + " and air.isDelete=0 and air.strtes1=1 and air.airstatus='" + airstatus + "'");if (time1 != null && !time1.equals("")) {hql.append(" and air.reportDate >=:time1");} if (time2 != null && !time2.equals("")) {hql.append(" and air.reportDate <=:time2");}hql.append(" order by air.cityname asc ");Number list = this.getHibernateTemplate().execute(new HibernateCallback() {public Object doInHibernate(Session session)throws HibernateException, SQLException {Query query = session.createQuery(hql.toString());SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");try {if (time1 != null && !time1.equals("")) {query.setDate("time1", df.parse(time1));}if (time2 != null && !time2.equals("")) {query.setDate("time2", df.parse(time2));}} catch (ParseException e) {e.printStackTrace();}return query.uniqueResult();}});return list.intValue();}