productscategoryservlet.java

java sql jsp javabean

package com.gc.biz;

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

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

import com.gc.action.Category;
import com.gc.action.Products;
import com.gc.action.SmallCategory;
import com.gc.dao.DCategory;
import com.gc.dao.DProducts;
import com.gc.dao.DSmallCategory;

public class ProductsCategoryServlet extends HttpServlet {

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

		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		DCategory dcate = new DCategory();
		DSmallCategory dsmall = new DSmallCategory();
		List<Category> list = dcate.selectAllCategory();
		request.setAttribute("ca", list);
		if(request.getParameter("cid")!=null)
		{
			int cid = Integer.parseInt(request.getParameter("cid"));
			List<SmallCategory> sm = dsmall.selectSmallCategoryByCID(cid);
			List<Category> cate = dcate.selectCategoryByCID(cid);
			request.setAttribute("smll", sm);
			request.getRequestDispatcher("/DisplayCategory.jsp?cid="+cate.get(0).getCname()+"").forward(request, response);
		}else if(request.getParameter("scid")!=null)
		{
			int scid = Integer.parseInt(request.getParameter("scid"));
			DProducts dp = new DProducts();
			List<Products> pro = dp.selectProductsBySCID(scid);
			List<SmallCategory> sm = dsmall.selectSmallCategoryBySCID(scid);
			request.setAttribute("pro", pro);
			request.getRequestDispatcher("/DisplayCategory.jsp?sname="+sm.get(0).getSname()+"").forward(request, response);
		}else
		{
			request.getRequestDispatcher("/ProductsCategory.jsp").forward(request, response);
		}
	}
}