Hibernate和Spring整合中数据查询hql与Criteria Query

来源：互联网发布：能备案几个域名编辑：程序博客网时间：2024/05/16 13:06

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;                }

0 0