PageServlet代码如下:
package servlet.user;
import java.io.IOException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import dao.DBOperation;
import util.PageUtil;
public class PageServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
DBOperation dbo=new DBOperation();
ArrayList<?> arrayList = null;
int recordCount = 0;
int currentPage = 1;
String sqlCount="select count(*) from books";
recordCount = dbo.getCount(sqlCount);
String pageStr = request.getParameter("page");
if(pageStr!=null)
currentPage = Integer.parseInt(pageStr);
PageUtil pageUtil = new PageUtil(5, recordCount);
pageUtil.setCurrentPage(currentPage);
String pagenatedSql = "SELECT TOP "+pageUtil.getPageSize()+" * FROM
books WHERE id NOT IN"+"( SELECT TOP "+pageUtil.getPageSize()*
(pageUtil.getCurrentPage()-1)+"id FROM books"+" ORDER BY id)
ORDER BY id";
arrayList = dbo.queryReturnList(pagenatedSql);
request.setAttribute("search", arrayList);
request.setAttribute("currentPage", pageUtil.getCurrentPage());
request.setAttribute("pageCount", pageUtil.getPageCount());
String str = "/user/bookList.jsp";
RequestDispatcher rd = request.getRequestDispatcher(str);
rd.forward(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
jsp学习笔记(22)
最新推荐文章于 2023-05-22 11:37:15 发布