90c744f01989001d1010df62d4408256

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

package com.pure35.servlet;

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

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

import com.pure35.bean.PageDao;
import com.pure35.database.MessageDao;
import com.pure35.database.UserDao;
import com.pure35.vo.MessageVo;
import com.pure35.vo.PageVo;
import com.pure35.vo.UserVo;

public class ShowMessage extends HttpServlet {

	private static final long serialVersionUID = 1L;
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		this.doPost(request,response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//定义分页中用到的几个变量
		//页面总数pageCount，每页显示的留言数pageSize，当前显示的页号pageNow．
		//设置每页显示４条留言信息
		int pageCount=0;
		int pageSize=4;
		int pageNow=1;
		String s_pageNow="";
		String s_pageCount="";
		boolean isLogin=false;
		String userName=request.getParameter("userName");
		//创建所用到的几个对象
		MessageVo msVo=new MessageVo();
		MessageDao msDao=new MessageDao();
		PageVo pageVo=new PageVo();
		PageDao pageDao=new PageDao();
		UserDao userDao=new UserDao();
		//创建保存留言信息和用户信息的容器（List）
		List msList=new ArrayList();
		List userList=new ArrayList();
		//获取用户所要显示页号
		s_pageNow=(String) request.getParameter("pageNow");
		try{
				
			if(s_pageNow!=null)
			{
				pageNow=Integer.parseInt(s_pageNow);
			}
			else
			{
					//用户若没选择要显示的页面将默认显示第一页
				pageNow=1;
			}
			}catch(Exception e)
			{
				e.printStackTrace();
			}
			
		//查询所有留言信息的SQL字符串
		//调用bean包中处理分页(PageDao)的getPageCount方法得到总页数
		String sql1ms="select count(*) from message";
		pageCount=pageDao.getPageCount(sql1ms,pageSize);
		
		//分页处理每页显示留言数并将其保存在留言msList容器中
		String sqlpage ="select  *  from message order by id limit "+(pageNow-1)*pageSize+","+pageSize;	
		msList=msDao.queryMessage(sqlpage);	
		
		//查询所有用户的信息并将其保存在用户userList容器中
		String sqluser="select * from user";
		userList=userDao.queryUser(sqluser);
		
		//保存获取的当前页面和总页数
		pageVo.setPageNow(pageNow);
		pageVo.setPageCount(pageCount);
		
		//保存留言信息的msList容器和用户信息的userList容器
		request.setAttribute("msResult", msList);
		request.setAttribute("userResult", userList);
		request.setAttribute("pageResult", pageVo);
		//跳转到显示留言信息界面
		request.getRequestDispatcher("showmessage.jsp").forward(request, response);				
		}
}