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