1.用hibernate根据实体自动生成的建表语句,Date类型的变量,oracle的话都是用timestamp(6)类型
2.使用Hql比较时间,用参数方式
Date date=Calendar.getInstance().getTime();
hql.append("From Member where and s.time != null and and s.time <=:date ");
Session session=MemberDao.getSession();
Query query=session.createQuery(hql.toString());
query.setTimestamp("date", date);//注意这里,用setTimestampe,不要用setDate
List<Member> list=query.list();