e080a0d6bb87001d1fdac4aa832ca1f0

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

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.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 {

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		UserDao userDao=new UserDao();
		String sql="";
		int pageCount=0;
		int pageSize=2;
		int pageNow=0;
		String s_pageNow="";
		String s_pageCount="";
		boolean isLogin=false;
		String userName=request.getParameter("userName");
		//String password=request.getParameter("password");
//		sql="select count(*) as mycount from user where username='"+userName+"'  and password='"+password+"' ";
//		//可以通过这语句System.out.println(sql);去检查数据库的操作ＳＱＬ语句！
//		isLogin=userDao.login(sql);
//		if(isLogin)
//		{	
			MessageVo msVo=new MessageVo();
			PageVo pageVo=new PageVo();
			MessageDao msDao=new MessageDao();
			List msList=new ArrayList();
			s_pageNow=(String) request.getParameter("pageNow");
			try{
				if(s_pageNow!=null)
				{
				pageNow=Integer.parseInt(s_pageNow);
				}
			}catch(Exception e)
			{
				e.printStackTrace();
			}		
			pageCount=msDao.getPageCount(pageSize);			
			System.out.println("pageNow="+pageNow);
			System.out.println("pageSize="+pageSize);
			int i= 0;
			if ((pageNow-1)*pageSize>0){
				i=(pageNow-1)*pageSize;
			}
			sql ="select  *  from message order by id limit "+i+","+pageSize;	
			System.out.println("i="+i);
			System.out.println("i="+(pageNow-1)*pageSize);
			msList=msDao.queryMessage(sql);
			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("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);
	}

}