hql语句实现时间段查询

网上很多关于hql时间段查询的案例,稍微杂一点,实践成功了一种简单地方法,特记一下:

 

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//确定时间段上下限度
Date endDate = sdf.parse(lateDate);
Date minDate = Collections.min(list);
String hql2 = "from Tobecheckedlib where uploaddate between ? and ?";
query = tobecheckedlibDao.createQuery(hql2);
query.setDate(0, minDate);
query.setDate(1, endDate);
List<Tobecheckedlib> lisTobecheckedlibs = query.list(); 
for (Tobecheckedlib tobecheckedlib : lisTobecheckedlibs) {
	System.out.println(tobecheckedlib);
}

 

posted @ 2017-05-15 16:53  一介草民李八千  阅读(1668)  评论(0)    收藏  举报