querysaying.java

具备留言的功能

package j2ee.pj.servlet;

import j2ee.pj.dao.ReplyDao;
import j2ee.pj.dao.SayingDao;
import j2ee.pj.javabean.SayingBean;

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

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

public class QuerySaying extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doPost(request, response);
	}
	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html;charset=utf-8");
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		SayingDao sd=new SayingDao();
		int pagesize=4;//页面大小
		int currpage=1;
		int zonggong=sd.getSayingSize();
		String currpage1=request.getParameter("currpage");
		if(currpage1!=null&&currpage1!=""){
			
			currpage=Integer.parseInt(currpage1);
			if(currpage<1)currpage=1;
			if(currpage>zonggong)currpage=zonggong;
			
		}
		String gopage1=request.getParameter("gopage");
		if(gopage1!=null&&gopage1!=""){
			currpage=Integer.parseInt(gopage1);
			if(currpage<1)currpage=1;
			if(currpage>zonggong)currpage=zonggong;
			
		}	
		int page=sd.getPageSize(zonggong, pagesize);
		List li=sd.getPageSaying(pagesize, currpage);
		ReplyDao rd=new ReplyDao();
		Map allrep=new HashMap();
		for(int i=0;i<li.size();i++){
			SayingBean sb=(SayingBean)li.get(i);
			List rep=rd.queryReply(sb.getSid());
			allrep.put(sb.getSid(), rep);
		}
		request.setAttribute("rep", allrep);
		request.setAttribute("currpage", currpage);
		request.setAttribute("page", page);
		request.setAttribute("zonggong", zonggong);
		request.setAttribute("li", li);
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}
	
	
}