public List<Record> getRecordsOrderByCreateTime(Date startDate, Date endDate) {
DetachedCriteria criteria = DetachedCriteria.forClass(Record.class);
criteria.add(Expression.ge("createTime", startDate));
criteria.add(Expression.le("createTime", endDate));
criteria.addOrder(Order.desc("createTime"));
List<Record> listRecord = getHibernateTemplate().findByCriteria(criteria);
if(listRecord.size() == 0){
return null;
}
return listRecord;
}
public List<Record> getRecordsOrderByCreateTime(Date startDate, Date endDate) {
String hql = "from Record record order by record.createTime desc";
List<Record> listRecord = getHibernateTemplate().find(hql);
for(int i = 0; i < listRecord.size(); i++) {
if( !(listRecord.get(i).getCreateTime().after(startDate)
&& listRecord.get(i).getCreateTime().before(endDate)) ) {
listRecord.remove(i);
}
}
if(listRecord.size() == 0){
return null;
}
return listRecord;
}