datagrid后端分页

int pagenum=Integer.parseInt(request.getParameter("page"));
int rows=Integer.parseInt(request.getParameter("rows"));

获取前端datagrid传过来的页码和每页行数。

数据库操作分为两个：

①选取所有记录res(List类型)



select * from
(select a.*,rownum as rn from a) b where b.rn between (pagenum-1)*rows+1 and pagenum*rows;

②选取总数resCount

select count(*) from
(select a.*,rownum as rn from a) b

ACTION里面的处理方式为：

response.getWriter().write("{\"total\":"+resCount+",\"rows\":"+JSONArray.fromObject(res).toString()+"}");

JSON使用了fastjson.jar。

EASYUI官网DEMO截图：