getcommentadminservlet.java

jsp + servlete + jdbc开的管理系统

package hbu.david.cmc.servlet;

import hbu.david.cmc.bean.Comment;
import hbu.david.cmc.util.ParseRequest;
import hbu.david.cmc.work.CommentBean;
import hbu.david.cmc.bean.*;

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

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

/**
 * Servlet implementation class for Servlet: GetCommentAdminServlet
 * 
 */
public class GetCommentAdminServlet extends hbu.david.cmc.http.MyHttpServlet
		implements javax.servlet.Servlet {
	static final long serialVersionUID = 1L;

	/*
	 * (non-Java-doc)
	 * 
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public GetCommentAdminServlet() {
		super();
	}

	@Override
	public void doExecute(HttpServletRequest request,
			HttpServletResponse response) throws IOException, ServletException {
		// TODO Auto-generated method stub
		/*
		int photoId=ParseRequest.parseInt(request, "photoId", 0);
		int currentPage=ParseRequest.parseInt(request, "currentPage", 0);
		//int userId=ParseRequest.parseInt(request, "userId",0);
		//每页显示10行
		int num=10;
		//总记录
		int allNum=CommentBean.getCommentNumByPhotoId(photoId);
		//总页数
		int pageNum=(allNum-1)/num+1;		
		
		List<Comment> commentList=new ArrayList<Comment>();
		
		
		//if(photoId<=0){
			//获取userId对应的评论
		commentList=CommentBean.getComments(currentPage*num, num, 0, ((UserInfo)request.getSession().getAttribute("userInfo")).getId());
		//}else{
		//	commentList=CommentBean.getComments(currentPage*num, num, photoId, 0);
		//}
		int itemNum=commentList.size();
		request.setAttribute("pageNum", pageNum);
		request.setAttribute("num", num);
		request.setAttribute("commentList", commentList);
		request.setAttribute("allNum", allNum);
		request.setAttribute("currentPage", currentPage);
		request.setAttribute("photoId", photoId);
		request.setAttribute("itemNum", itemNum);
		//request.setAttribute("userId", userId);
		//request.setAttribute(arg0, arg1);
		 * *
		 */
		//int photoId=ParseRequest.parseInt(request, "photoId", 0);
		int currentPage=ParseRequest.parseInt(request, "currentPage", 0);
		//每页显示10行
		int num=10;
		//总记录
		//int allNum=CommentBean.getCommentNumByPhotoId(photoId);
		//总页数
		int userId=((UserInfo)request.getSession().getAttribute("userInfo")).getId();
		int allNum=CommentBean.getCommentNumByUserId(userId);
		int pageNum=(allNum-1)/num+1;
		//List<Comment> commentList=new ArrayList<Comment>();
		List<Comment> commentList=CommentBean.getComments(currentPage*num, num, 0, userId);
		int itemNum=commentList.size();
		request.setAttribute("pageNum", pageNum);
		request.setAttribute("num", num);
		request.setAttribute("commentList", commentList);
		request.setAttribute("allNum", allNum);
		request.setAttribute("currentPage", currentPage);
		//request.setAttribute("photoId", photoId);
		request.setAttribute("itemNum", itemNum);
		request.getRequestDispatcher("commentAdminList.jsp").forward(request, response);
	}
}