menuoperateservlet.java

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

package servlet.article;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;

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

import Bean.MenuList;

/**
 * Servlet implementation class for Servlet: MenuOperateServlet
 *
 */
 public class MenuOperateServlet
 extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
	private static final long serialVersionUID = 1L;
		/* (non-Java-doc)
		 * @see javax.servlet.http.HttpServlet#HttpServlet()
		 */
		db.DB dt;//定义一个数据库操作对像
		RequestDispatcher rd=null;//跳转页面
		public MenuOperateServlet() {
			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
			response.setContentType("text/html;charset=gb2312");
			request.setCharacterEncoding("gb2312");
			String action=request.getParameter("action");
			String Id=request.getParameter("Id");
			dt=new db.DB();
			MenuList mst=new MenuList();
			try{
				if(action.trim().equals("delete")){
					dt.executeUpdate("delete from menu where Id="+String.valueOf(Id));
					dt.executeUpdate("delete from article where MenuID="+String.valueOf(Id));//同时删除文章
					DelChildMenu(Integer.valueOf(Id));//同时删除它的子栏目
				}else if(action.trim().equals("enable")){
					dt.executeUpdate("update menu set IsShow='1' where Id="+String.valueOf(Id));
				}
				else if(action.trim().equals("unenable")){
					dt.executeUpdate("update menu set IsShow='0' where Id="+String.valueOf(Id));
				}
				else if(action.trim().equals("orderup")){
					mst.MenuUpOneSort(Integer.valueOf(Id));
				}
				else if(action.trim().equals("orderdown")){
					mst.MenuDownOneSort(Integer.valueOf(Id));
				}
			}catch(Exception ex){
				System.out.println("MenuOperateServlet中出错：执行动作为"+action+ex);
			}
			finally	{
				dt.close();
				rd=request.getRequestDispatcher("/jsjadmin/Menu/MenuManager.jsp");
				rd.forward(request, response);
			}
		}  	  
		
		private void DelChildMenu(int ParentID){
			//PreparedStatement p_Stm=null;
			ResultSet r_rs=dt.getRs("select * from menu where ParentID="+ParentID+" order by OrderList");
			try{//p_Stm=DC.conn.prepareStatement(sql);r_rs=p_Stm.executeQuery();
					while(r_rs.next()){
						dt.executeUpdate("delete from menu where Id="+r_rs.getString("Id"));
						dt.executeUpdate("delete from article where MenuID="+r_rs.getString("Id"));
						DelChildMenu(r_rs.getInt("Id"));//使用递归的方法删除
					}
			}
			catch(SQLException ex){
				System.out.println("在删除子菜单的时候出错："+ex);
			}finally{
				try{
					r_rs.close();
				}catch(SQLException ex){
					System.out.println("在删除子菜单关闭记录集时出错："+ex);
				}
			}
		}
	}