c0ceabf21489001d1b9795c3f0ce58e6

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

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 doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		int pageCount=1;
		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字符串
			String sql1ms="select count(*) from message";
			//调用bean包中处理分页(PageDao)的getPageCount方法得到总页数
			pageCount=pageDao.getPageCount(sql1ms,pageSize);
			System.out.println(s_pageNow);
			System.out.println(pageNow);
			
//			int i= 0;
//			if ((pageNow-1)*pageSize>0){
//				i=(pageNow-1)*pageSize;
//			}
			String sqlpage ="select  *  from message order by id limit "+(pageNow-1)*pageSize+","+pageSize;	
			msList=msDao.queryMessage(sqlpage);	
			
			String sqluser="select * from user";
			userList=userDao.queryUser(sqluser);
			
			pageVo.setPageNow(pageNow);
			pageVo.setPageCount(pageCount);			
//			s_pageNow=Integer.toString(pageNow);
//			s_pageCount=Integer.toString(pageCount);
//			request.setAttribute("pageNow",s_pageNow);
//			request.setAttribute("pageCount", s_pageCount);
			request.setAttribute("msResult", msList);
			request.setAttribute("userResult", userList);
			request.setAttribute("pageResult", pageVo);
			//request.setAttribute("userName", userName);	
			request.getRequestDispatcher("showmessage.jsp").forward(request, response);				
		}
//		else{
//			
//			request.getRequestDispatcher("login.jsp").forward(request, response);
//		}	
//	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
this.doPost(request,response);
	}

}