managermodifycategoryservlet.java

java sql jsp javabean

package com.gc.biz;

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

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.SmallCategory;
import com.gc.dao.DCategory;
import com.gc.dao.DFormat;
import com.gc.dao.DSmallCategory;

public class ManagerModifyCategoryServlet extends HttpServlet {

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

		response.setContentType("text/html");
		response.setCharacterEncoding("gbk");
		request.setCharacterEncoding("gbk");
		
		DCategory dc = new DCategory();
		DFormat df = new DFormat();
		
		/*第一次显示所有的类别*/
		String category = request.getParameter("cid");
		String smallcategory = request.getParameter("scid");
		
		/*修改大类时表单提交的数据*/
		String categoryid = request.getParameter("categoryid");	
		String caname = request.getParameter("categoryname");
		
		/*修改小类时表单提交的数据*/
		String sid = request.getParameter("smallcid");
		String sname = request.getParameter("smallname");
		String cateid = request.getParameter("cateid");

		if(!"".equals(category) && category!=null)
		{
			int cid = Integer.parseInt(category);
			List<Category> list = dc.selectCategoryByCID(cid);
			request.setAttribute("category", list);
			request.getRequestDispatcher("/ManagerModifyCategory.jsp").forward(request, response);
			
		}else if(!"".equals(smallcategory) && smallcategory!=null)
		{
			int scid = Integer.parseInt(smallcategory);
			DSmallCategory ds = new DSmallCategory();
			List<SmallCategory> li = ds.selectSmallCategoryBySCID(scid);
			List<Category> list = dc.selectAllCategory();
			request.setAttribute("cate", list);
			request.setAttribute("smallcategory", li);
			request.getRequestDispatcher("/ManagerModifyCategory.jsp").forward(request, response);
		}else if(!"".equals(caname) && categoryid!=null && caname!=null && !"".equals(categoryid))
		{
			int id = Integer.parseInt(categoryid);
			if(dc.OperatorCategory("update Category set cname='"+df.format(caname)+"' where cid='"+id+"'"))
			{
				request.getRequestDispatcher("/servlet/ManagerSelectCategoryServlet?modify=true").forward(request, response);
			}

		}else if(!"".equals(sid) && !"".equals(sname) && sid!=null && sname!=null)
		{
			int scid = Integer.parseInt(sid);
			int cid = Integer.parseInt(cateid);
			DSmallCategory ds = new DSmallCategory();		
			if(ds.OperatorSmallCategory("update SmallCategory set sname='"+df.format(sname)+"',cid='"+cid+"' where scid='"+scid+"'"))
			{
				request.getRequestDispatcher("/servlet/ManagerSelectCategoryServlet?modify=true").forward(request, response);
			}
		}	
	}
}