getcategoriesservlet.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 sun.rmi.server.Dispatcher;

import hbu.david.cmc.bean.*;
import hbu.david.cmc.work.*;
import hbu.david.cmc.util.*;
/**
 * Servlet implementation class for Servlet: GetCategoriesServlet
 * 
 */
public class GetCategoriesServlet 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 GetCategoriesServlet() {
		super();
	}

	@Override
	public void doExecute(HttpServletRequest request,
			HttpServletResponse response) throws IOException, ServletException {
		// TODO Auto-generated method stub
		int userId=((UserInfo)request.getSession().getAttribute("userInfo")).getId();
		//获取当前页
		int currentPage=ParseRequest.parseInt(request, "currentPage",0);
		
		request.setAttribute("currentPage", currentPage);
		//int num=ParseRequest.parseInt(request, "num",10);
		//每页显示记录
		int num=5;
		List<Category> arrayList=CategoryBean.getCategory(currentPage*num, num, userId);
		request.setAttribute("categoryList", arrayList);
		
		int itemNum=arrayList.size();
		request.setAttribute("itemNum", itemNum);
		//总记录
		int allNum=CategoryBean.getCategoryNum(userId);
		request.setAttribute("allNum", allNum);
		request.setAttribute("num", num);
		int pageNum=(allNum-1)/num+1;
		request.setAttribute("pageNum", pageNum);
		RequestDispatcher requestDispatcher=request.getRequestDispatcher("categoryList.jsp");
		requestDispatcher.forward(request, response);
	}

}