分页查询

1,先从前台传page 和 rowsString curPage=httpRequest.getParameter("page");//页码String pageSize=httpRequest.getParameter("rows");//每页显示的记录数2,计算开始页数和结束页数int start =  (Integer.parseInt(curPage) - 1) * Integer.parseInt(pageSize) + 1;int end = start + Integer.parseInt(pageSize);3.写SQLSELECT *FROM (SELECT u.*, ROWNUM AS RN  FROM (SELECT t1.*    FROM (        SQL....      ) t1    WHERE rownum <= end    ) u  ) zWHERE RN >= start --排序放在最外面--ORDER BY z.zd DESC, to_number(z.px) ASC, z.cjsj DESC4.计算总记录数据和每页显示的条数int total = Integer.parseInt(total_String);//total_String只需要在分页查询外面count(id)即可获得int totalPage = total%Integer.parseInt(pageSize)==0 ? total/Integer.parseInt(pageSize) : total/Integer.parseInt(pageSize) + 1; //totalPage 每页显示的条数