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

最新推荐文章于 2020-03-09 22:47:35 发布

揽峰moc

最新推荐文章于 2020-03-09 22:47:35 发布

阅读量431

点赞数

分类专栏： Hibernate 文章标签： java 数据库

本文链接：https://blog.csdn.net/big1989wmf/article/details/84495033

版权

Hibernate 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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