mysql分页 的俩种方法,关于Mysql分页的两种方法

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");

}

}