关于Mysql分页的两种方法

关于Mysql分页的两种方法，一种假分页，没有效率提高，另一种使用limit，对数据量小的情况下效率会高点：

下面，我只贴出Struts 中Action的代码，其他代码请下载完整工程查看。

package cn.xg.struts.action; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import cn.xg.dao.UserDao; import cn.xg.dao.impl.UserDaoImpl; public class UserListAction extends DispatchAction { public ActionForward UserList(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { System.out.println("__________________________________无分页显示___________--"); UserDao dao=new UserDaoImpl(); List list=dao.UserList(); request.setAttribute("list",list); return mapping.findForward("success"); } public ActionForward UserListPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { System.out.println("__________________________________假分页显示___________--"); UserDao dao=new UserDaoImpl(); List list=dao.UserList(); request.setAttribute("list",list); return mapping.findForward("successpage"); } public ActionForward UserListPage2(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { System.out.println("__________________________________物理分页显示___________--"); int curPageNum=request.getParameter("curPageNum")==null?0:Integer.parseInt(request.getParameter("curPageNum").toString()); //当前页数 int pageCount=request.getParameter("pageCount")==null?0:Integer.parseInt(request.getParameter("pageCount").toString()); //总页数 int pageSize=10; //每页显示记录数(自行修改) int listsize=0; //总记录数 int _num=0; //临时页数 List list=null; //返回数据 UserDao dao=new UserDaoImpl(); if(curPageNum==0) { curPageNum=1; System.out.println("__________________________________执行查询全部记录条数___________--"); listsize=dao.UserlistpageSize();//得到全部记录条数方法 pageCount = listsize % pageSize == 0 ? listsize / pageSize:listsize / pageSize + 1; list=dao.Userlistpage(curPageNum, pageSize);//实际业务方法 }else { list=dao.Userlistpage(curPageNum, pageSize); } request.setAttribute("_num", curPageNum); request.setAttribute("pageCount", pageCount); request.setAttribute("list",list); return mapping.findForward("successpage2"); } } 

 

工程下载地址:http://download.csdn.net/source/2188316