getphotosservlet.java

jsp + servlete + jdbc开的管理系统

package hbu.david.cmc.servlet;

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

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

import hbu.david.cmc.bean.*;
import hbu.david.cmc.work.*;
import hbu.david.cmc.util.*;

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

	@Override
	public void doExecute(HttpServletRequest request,
			HttpServletResponse response) throws IOException, ServletException {
		// TODO Auto-generated method stub
		int currentPage=ParseRequest.parseInt(request, "currentPage",0);
		int categoryId=ParseRequest.parseInt(request, "categoryId",0);
		int userId=ParseRequest.parseInt(request, "userId",0);
		int num=10;
		int allNum=PhotoBean.getPhotoNum(categoryId,userId);
		int pageNum=(allNum-1)/num+1;	
		
		List<Photo> photoList=new ArrayList<Photo>();
		if(userId==0){
			if(categoryId==0){
				photoList=PhotoBean.getPhotos(currentPage*num, num);
			}else{
				photoList=PhotoBean.getPhotos(currentPage*num, num, categoryId,0);
			}
		}else{
			photoList=PhotoBean.getPhotos(currentPage*num, num, 0,userId);
		}
		int itemNum=photoList.size();
		request.setAttribute("photoList", photoList);
		request.setAttribute("currentPage", currentPage);
		request.setAttribute("categoryId", categoryId);
		request.setAttribute("num", num);
		request.setAttribute("allNum", allNum);
		request.setAttribute("pageNum", pageNum);
		request.setAttribute("itemNum", itemNum);
		
		RequestDispatcher requestDispatcher=request.getRequestDispatcher("photoList.jsp");
		requestDispatcher.forward(request, response);
	}

}