b0ac77c8a687001d1d7ab3f7b384a38a

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

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.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=4;
		int pageNow=0;
		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();
			MessageDao msDao=new MessageDao();
			List list=new ArrayList();
			String s_pageNow=(String) request.getAttribute("pageNow");
			try{
				if(s_pageNow!=null)
				{
				pageNow=Integer.parseInt(s_pageNow);
				}
			}catch(Exception e)
			{
				e.printStackTrace();
			}		
			pageCount=msDao.getPageCount(pageSize);			
			sql ="select  *  from message order by id limit "+(pageNow-1)*pageSize+","+pageSize;	
			list=msDao.queryMessage(sql);
			request.setAttribute("msResult", list);
			request.setAttribute("pageCount", "+pageCount+");
			request.setAttribute("pageNow","+pageNow+");
			request.setAttribute("userName", userName);	
			request.getRequestDispatcher("showmessage.jsp").forward(request, response);				
		}
//		else{
//			
//			request.getRequestDispatcher("login.jsp").forward(request, response);
//		}	
//	}

}