gistfile1.txt

List<Orders> res = hibernateTemplate.executeFind(new HibernateCallback<List<Orders>>() {
  		public List<Orders> doInHibernate(Session session) throws HibernateException, SQLException {
                return session.createQuery(sql.toString()).setInteger(0, status)
                .setFirstResult(pageNum)
                .setMaxResults(pageSize)
                .list();
		    } 
		});