addmenuservlet.java

这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架

package servlet.article;

import java.io.IOException;

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

import Bean.MenuBean;

/**
 * Servlet implementation class for Servlet: AddMenuServlet
 *
 */
 public class AddMenuServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public AddMenuServlet() {
		super();
	}   	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}  	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		RequestDispatcher rd=null;//跳转页面
		
		response.setContentType("text/html;chaset=gb2312");
		request.setCharacterEncoding("gb2312");//解决中文显示问题
		
		String ParentID=request.getParameter("ParentID").trim();
		String MenuName=request.getParameter("MenuName").trim();
		String Introduce=request.getParameter("Introduce").trim();
		String IsShow=request.getParameter("IsShow").trim();
		
		if(IsShow!=null && IsShow.trim().equals("IsShow")) 
			IsShow="1";
		else
			IsShow="0";
		
		MenuBean menubean=new MenuBean();
		menubean.setParentid(Integer.valueOf(ParentID));
		menubean.setMenunaem(MenuName);
		menubean.setIntroduce(Introduce);
		if(IsShow.trim().equals("1"))			
			menubean.setIsshow("checked");
		else
			menubean.setIsshow("");
		request.setAttribute("menubean", menubean);
		
		if(!menubean.validata("add",-1)){//进行输入的数据验证
			rd=request.getRequestDispatcher("/jsjadmin/Menu/addMenu.jsp");
			rd.forward(request, response);
			return;
		}
		
		db.DB dt=new db.DB();
		int OrderList=dt.ReturnMaxField("menu", "ParentID", ParentID, "OrderList")+1;//返回同一级菜单的最大序号
		int Depth=1;
		if(ParentID!="0")
			Depth=dt.returnInt("select Depth from menu where Id="+ParentID)+1;//.ReturnFieldValue("menu", "Id", ParentID, "Depth")+1;//得到父菜的级数，本级为父级加1
		dt.prepareStatement("insert into menu (OrderList,MenuName,Introduce,ParentID,Depth,IsShow) values(?,?,?,?,?,?)");
		dt.setInt(1, OrderList);
		dt.setString(2, MenuName);
		dt.setString(3, Introduce);
		dt.setInt(4, Integer.valueOf(ParentID));
		dt.setInt(5, Depth);
		dt.setString(6, IsShow);
		dt.executeUpdate();
		rd=request.getRequestDispatcher("/jsjadmin/Menu/AddMenuSuccess.jsp?action=add");
		rd.forward(request, response);
		dt.close();
	}
}