Neeke

public List<Plans> getPlanAll(Pager pager)
		throws Exception {
 
	List<Plans> list = this.getHibernateTemplate().executeFind(new HibernateCallback(){
 
		public Object doInHibernate(Session s)
				throws HibernateException, SQLException {
 
			Criteria cta = s.createCriteria(Plans.class);
			if(null != pager){
				cta.setMaxResults(pager.getLimit());
				cta.setFirstResult(pager.getStart());
				String dir = pager.getDir();
				String sort = pager.getSort();
				if(null != dir && !"".equals(dir)){
 
					if(dir.equals("ASC")){
 
						cta.addOrder(Order.asc(sort));
					}
					if(dir.equals("DESC")){
						cta.addOrder(Order.desc(sort));
					}
				}
			}
			return cta.list();
		}
 
 
	});
	return list;
}