b033e2307f87001d1285a7659f9cbb35

一个相对比较简单的留言簿！功能还比较齐全！

package com.pure35.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.pure35.database.MessageDao;

public class ApartPage extends HttpServlet {
	
	MessageDao msDao=new MessageDao();
	int pageCount=0;
	int pageSize=4;
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		pageCount=msDao.getPageCount();
		String sql="select  *  from message order by id desc limit (pageCount-1)*pageSize,pageSize";
		List list=msDao.queryMessage(sql);
		request.setAttribute("msResult", list);
		request.setAttribute("pageCount", pageCount);
		request.getRequestDispatcher("showmessage.jsp").forward(request, response);	
		
	}

}