统计字段
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;
}
页面分页处理 easy-UI
最新推荐文章于 2024-09-07 17:00:00 发布