java中orcle分页列子,JDBC分页示例（Oracle数据库）

packagecom.sitinspring.action;importjava.util.logging.Logger;importjavax.servlet.RequestDispatcher;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.sitinspring.domain.User;importcom.sitinspring.service.AccountService;importcom.sitinspring.util.CommonUtil;/*** 用于查看Account的Servlet

*@authorsitinspring

*

* @date 2008-2-11*/publicclassViewAccountServletextendsHttpServlet {privatestaticfinallongserialVersionUID=8908908L;//日志记录器privatestaticLogger logger=Logger.getLogger(ViewAccountServlet.class.toString());/*** 根据输入的页面名称，取得需要的数据再进入对应页面*/publicvoiddoPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, java.io.IOException {

request.setCharacterEncoding("UTF-8");//查看用户是否存在User user=(User) request.getSession().getAttribute("User");if(user==null){//如果Session中没有执行修改操作的人,转到错误页面String pageName="login";

request.setAttribute("Msg","在Session中找不到操作用户,请重新登录");

gotoUrl(CommonUtil.combineUrl(pageName), request, response);return;

}finalintpageSize=CommonUtil.PageSize;

AccountService service=newAccountService();//取得頁起始記錄號intcurrPage;

String strCurrPage=(String)request.getParameter("currPage");if(strCurrPage==null){

currPage=0;

}else{

currPage=Integer.parseInt(strCurrPage);

}

request.setAttribute("currPage", String.valueOf(currPage));//查詢關鍵詞String leftLimit=(String)request.getParameter("leftLimit");if(leftLimit==null||leftLimit.trim().length()<1){

leftLimit="0";

}

request.setAttribute("leftLimit", leftLimit);

String rightLimit=(String)request.getParameter("rightLimit");if(rightLimit==null||rightLimit.trim().length()<1){

rightLimit="999999";

}

request.setAttribute("rightLimit", rightLimit);//總數intpageCount=0;intallCount=service.getCountByKeyWord(leftLimit,rightLimit,user.getId());if((allCount%pageSize)==0){

pageCount=allCount/pageSize;

}else{

pageCount=allCount/pageSize+1;

}

request.setAttribute("pageCount", String.valueOf(pageCount));

request.setAttribute("Accounts", service.fetchPageRecords(currPage*pageSize,(currPage+1)*pageSize,leftLimit,rightLimit,user.getId()));

request.setAttribute("Msg","欢迎进入开支逐项查看页面.");//設置page参数String pageName="viewAccount";

gotoUrl(CommonUtil.combineUrl(pageName), request, response);

}/*** 迁移到相应页面

*@paramurl

*@paramrequest

*@paramresponse

*@throwsServletException

*@throwsjava.io.IOException*/privatevoidgotoUrl(String url, HttpServletRequest request,

HttpServletResponse response)throwsServletException,

java.io.IOException {

logger.info("进入页面:"+url);

RequestDispatcher dispatcher=null;

dispatcher=request.getRequestDispatcher(url);

dispatcher.forward(request, response);

}publicvoiddoGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, java.io.IOException {

doPost(request, response);

}

}