页面分页处理 easy-UI

统计字段
int count = 0;
StringBuffer sb = new StringBuffer();

sb.append(" SELECT  count(*) from(  )");
sb.append(SQL语句);
sb.append(" )");


页面分页

action层

	@RequestMapping(value = "getListZc.action",method = RequestMethod.POST)
	public ModelAndView getListZc(@RequestParam(value = "page") int pageNum, 
        @RequestParam(value = "rows") int pageSize,HttpServletRequest request, 
          HttpServletResponse response){
	
		ModelAndView mv = new ModelAndView();
			//method = RequestMethod.POST  前台get改成post 可以解决汉字乱码问题
		int firstResult = (pageNum-1) * pageSize;
		int maxResults = pageNum * pageSize;
		int count = zcykjhdServ.jsCount();
		List<Zcykjhd> list = zcykjhdServ.getListZc(.........,firstResult,maxResults);
		mv.addObject("total", count);
		mv.addObject("success", true);
		mv.addObject("rows", list);
		return mv;
	}
	
dao层
public List<数据库实体类> getListKcWzZj(String ......,int firstResult,int maxResults){
		StringBuffer sb = new StringBuffer();
		sb.append("	select * from (select A.*, rownum rn from (        ");
		sb.append(SQL语句);
		sb.append("	 ) A where rownum<='"+maxResults+"' ) where rn> '"+firstResult+"'");
		
		List<Zcykjhd> list = this.jdbcTemplate.query(sb.toString(),	
                 new Object[] {}, new ZccxMapper());
		return list;
	}