hql语句里日期比较
- Date date=Calendar.getInstance().getTime();
- Date date1=Calendar.getInstance().getTime();
- String hql ="From Student s where 1=1 "
- +" and s.time != null "
- +" and s.time >:date "
- +" and s.time <=:date1 ";
- Query query=sessionFactory.createQuery(hql);
- query.setTimestamp("date", date);//注意这里,用setTimestampe,不要用setDate
- query.setTimestamp("date1", date1);
- List<Student> list=query.list();