manageraddcategoryservlet.java

一个小型的JSP购物网站

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

public class ManagerAddCategoryServlet extends HttpServlet {

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

		response.setContentType("text/html");
		DCategory dc = new DCategory();
		DFormat dformat = new DFormat();
		String catename = request.getParameter("category");
		String smallname = request.getParameter("smallcategory");

		if (!"".equals(catename) && catename != null) {
			int count = dc.selectCountOfCategory();
			if (dc.OperatorCategory("insert into Category values('" + count
					+ "','" + dformat.format(catename) + "')")) {
				request.getRequestDispatcher(
						"/servlet/ManagerSelectCategoryServlet?modify=true")
						.forward(request, response);
			} else {

			}
		} else if (!"".equals(smallname) && smallname != null) {
			int cid = Integer.parseInt(request.getParameter("cid"));
			DSmallCategory ds = new DSmallCategory();
			int count = ds.selectCountOfSmallCategory();
			if (ds.OperatorSmallCategory("insert into SmallCategory values("
					+ count + ",'" + dformat.format(smallname) + "'," + cid
					+ ")")) {
				request.getRequestDispatcher(
						"/servlet/ManagerSelectCategoryServlet?modify=true")
						.forward(request, response);
			} else {

			}
		} else {
			List<Category> cate = dc.selectAllCategory();
			request.setAttribute("category", cate);
			request.getRequestDispatcher("/ManagerAddCategory.jsp").forward(
					request, response);
		}
	}
}