`
Franciswmf
  • 浏览: 778308 次
  • 性别: Icon_minigender_1
  • 来自: 上海
文章分类
社区版块
存档分类
最新评论

利用hibernate查询语句查询信息,默认当日,否则往前推

 
阅读更多
	
public List<AhemcQualityAir> selectcheckQualityAir(final String time) {
final String hql= "select air from AhemcQualityAir air where air.isDelete=0 and air.strtes1=1 and air.reportDate=? order by  air.cityname asc";
List<AhemcQualityAir> list = getHibernateTemplate().executeFind(
new HibernateCallback() {
public Object doInHibernate(Session session)throws HibernateException, SQLException {
List<AhemcQualityAir> list = null;
Query query = session.createQuery(hql);//
for (int i = 0; i >-10; i--) {			
String time1=DateUtil.calculateDateByNumber(i);
query.setDate(0, DateUtil.stringToUtilDate(time1));
list = query.list();
if (list != null && list.size() > 0) {
break;
}							
}
return list;
}
});
return list;
}
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics