hql 时间段的查询

hql 时间段的查询

今天用hibernate做时间段的查询,但是查了很多资料给的代码都运行不出来 都是执行不了，后来才发现被误导了，现在把正确的查找方法记录一下

List allStockin = new ArrayList();

session = HibernateSessionFactory.getSession();

try{

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

Date startDate1 = sdf.parse(startDate);

Date endDate1 = sdf.parse(endDate);

String hql = "from Stockin where stockInDate between ? and ?";

Query query = session.createQuery(hql);

query.setDate(0, startDate1);

query.setDate(1, endDate1);

allStockin = query.list();

}catch(Exception e){}

return allStockin;