首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > Web前端 >

hibernate中的query.uniqueResult()统计回到一个整型数据

2013-11-16 
hibernate中的query.uniqueResult()统计返回一个整型数据public int selectAll(final String time1,final

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();}

热点排行