hibernate时间查询

221 阅读 0 评论 146 点赞

我是靠谱客的博主老迟到小鸽子，这篇文章主要介绍hibernate时间查询，现在分享给大家，希望可以做个参考。


SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Calendar cal = Calendar.getInstance();
cal.add(Calendar.DATE, -5);
String beginTime = sdf.format(cal.getTime());
String endTime = sdf.format(new Date());
String hql ="select lic from Licrequest lic,TWorkitem t where t.processInsId = lic.processInsId "
+"and t.description = 'A011' and lic.waitStatus is null "
+"and lic.createtime >= " +"to_date('" + beginTime + "', 'yyyy-MM-dd HH24:mi:ss')"
+"and lic.createtime <= " +"to_date('" + endTime + "', 'yyyy-MM-dd HH24:mi:ss')";