Date date=Calendar.getInstance().getTime();
hql.append("From Userwhere and s.time != null and and s.time <=:date ");
Session session=MemberDao.getSession();
Query query=session.createQuery(hql.toString());
query.setTimestamp("date", date);//注意这里,用setTimestamp e,不要用setDate
List<Member> list=query.list();
注意:比较的时间直接= > <即可,时间类型用TimeStamp