qsqlquery查询到的数据个数_获取sequence的当前值

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