getmessagesservlet2.java

一个简单的BBS系统 适用于初学者用JSP和连接池 开发系统

package webbook.guestbook;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import webbook.chapter18.OraclePagination;
import webbook.chapter18.Pagination;

public class GetMessagesServlet2 extends HttpServlet {
	private static final long serialVersionUID = 5964428201228635704L;

	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		int pageNumber = 1;
		try {
			pageNumber = Integer.parseInt(request.getParameter("p"));
		} catch (Exception e) {
		}
		Pagination pager = new OraclePagination("select id,name,title from guestbook order by id desc", 1, pageNumber);
		request.setAttribute("guestbook.pagesize", pager.getPageSize());
		request.setAttribute("guestbook.maxElements", pager.getMaxElements());
		request.setAttribute("results", pager.getList());

		request.getRequestDispatcher("/getMessages2.jsp").forward(request, response);
	}
}