采用HQL方式:
Date begin = java.sql.Date.valueOf("2009-03-24");
Date end = java.sql.Date.valueOf("2009-03-26");
List<A> result =
session.createQuery("from A a where a.date > :beginTime and a.date <= :endTime")
.setTimestamp("beginTime", begin)
.setTimestamp("endTime", end)
.list();
(注:beginTime,endTime为字段名)
采用QBC方式:
Date begin = java.sql.Date.valueOf("2009-3-24");
Date end = java.sql.Date.valueOf("2009-3-26");
Criteria criteria = session.createCriteria (AbstractA.class);
Criterion creterion = Expression.between("date", begin, end);
List<A> result = criteria.add(creterion).list();
(注:date 为字段名)