DetachedCriteria查詢

1，最簡單簡單的查詢，分页：

public List<ValueObject> readPage(ValueObject vo,Class c) { DetachedCriteria criteria=DetachedCriteria.forClass(c); return template.findByCriteria(criteria,vo.getCurIndex(),Constants.perPage); }

方法說明： findByCriteria(criteria, firstResult, maxResults);最后两个参数就可以决定你取哪些结果集

 

2，查询两个时间之间的数据集：

public List<ValueObject> searchNeedsBetween(ValueObject vo) { Calendar cal=Calendar.getInstance(); cal.setTime(CalendarUtil.parseDate(vo.getStr())); CalendarUtil.setMinTime(cal); Calendar cal2=Calendar.getInstance(); cal2.setTime(CalendarUtil.parseDate(vo.getStr2())); CalendarUtil.setMaxTime(cal2); DetachedCriteria criteria=DetachedCriteria.forClass(ProjectNeedsBean.class); criteria.add(Restrictions.between(vo.getSqlKey(), cal,cal2)); return template.findByCriteria(criteria); }