getmessagesservlet.java

用java编写的程序

package webbook.guestbook;

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

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

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