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);
}
专注搬砖,擅长搬砖砸自己的脚~~~
Email:
ltwbuaa@163.com

浙公网安备 33010602011771号