Hibernate 时间段查询

Hibernate 映射文件.hbm.xml中属性配置type属性不配置(这样获取值时能获取时分秒)

<property name="writeDate" column="MESSAGE_WRITE_DATETIME" />

 

 

代码中设置时间如下:

 

String hql = "FROM SendMessage s WHERE s.writeDate between :beginDate and  :endDate";

 

Query query = this.getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(hql);

//Oracle数据库用setTime,mysql用setDate

query.setTime("beginDate", beginDate);//用setTime

query.setTime("endDate", endDate);

这样取值时也能获取时分秒