909c69cf8887001d1ee980ae25fc6144

来自「一个相对比较简单的留言簿！功能还比较齐全！」· 代码 · 共 37 行

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;
	int pageNow=0;
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String s_pageNow=(String) request.getAttribute("pageNow");
		pageNow=Integer.parseInt(s_pageNow);
		pageCount=msDao.getPageCount();
		System.out.println(pageCount);
		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.setAttribute("pageNow","+pageNow+");
		request.getRequestDispatcher("showmessage.jsp").forward(request, response);	
		
	}

}