powerservlet.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.servlet;

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

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

import com.oa.lp.dao.MenuDAO;
import com.oa.lp.dao.PowerDAO;
import com.oa.lp.dao.RoleDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Menu;
import com.oa.lp.model.Power;
import com.oa.lp.model.Role;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;


public class PowerServlet extends TopServlet{
   static final long serialVersionUID = 1L;

   
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	
	   //接参
	   String method = request.getParameter("method")==null?"":request.getParameter("method");
	   String menuId = request.getParameter("menuId")==null?"0":request.getParameter("menuId");
	   String powerId = request.getParameter("powerId")==null?"0":request.getParameter("powerId");
	   String powerName = request.getParameter("powerName");
	   String powerDescr = request.getParameter("powerDescr");
	   String powerState = request.getParameter("powerState")==null?"0":request.getParameter("powerState");
	   String powerUrl = request.getParameter("powerUrl");
	   //封装对象
	  Power power = new Power();
	   if(menuId.length()>0){
		   power.setMenuId(Integer.parseInt(menuId));
	   }
	 if(powerId.length()>0){
		 power.setPowerId(Integer.parseInt(powerId));
	 }
	 power.setPowerName(powerName);
	 power.setPowerDescr(powerDescr);
	 power.setPowerUrl(powerUrl);
	 Connection conn=null;
	try {
		conn = DataBase.getConnection();
		MenuDAO menuDao = new MenuDAO();
		PowerDAO powerDao = new PowerDAO();
		menuDao.setConn(conn);
		powerDao.setConn(conn);
		
		if(method.equals("menuList")){
			//加载菜单
			request.setAttribute("menus",menuDao.listAllMenu());
			this.forward(request, response,"/system/power/menuList.jsp");
		}else if(method.equals("add")){
			//添加
			power.setPowerState(1);
			powerDao.addPower(power);
			this.sendRedirect(request, response,"/PowerServlet?method=list");
			}else if(method.equals("list")){
				//列表
				//power.setPowerState(1);
				request.setAttribute("menus",menuDao.listAllMenu());
				request.setAttribute("powers",powerDao.listAllPower());
				this.forward(request, response,"/system/power/list.jsp");
			}else if(method.equals("edit")){
				//通过ID查找
				Power p = powerDao.getPowerById(power.getPowerId());
				Menu m = menuDao.getById(p.getMenuId());
				request.setAttribute("power",p);
				request.setAttribute("menu",m);
				this.forward(request, response, "/system/power/power.jsp");
			}else if(method.equals("update")){
				//更新权限
				powerDao.updatePower(power);
				this.sendRedirect(request, response,"/PowerServlet?method=list");
			}else if(method.equals("update_state")){
				//状态更新
				powerDao.updatePowerState(Integer.parseInt(powerId),Integer.parseInt(powerState));
				this.sendRedirect(request, response,"/PowerServlet?method=list");
			}else if(method.equals("del")){
				//Power p = powerDao.getPowerById(power.getPowerId());
				if(powerDao.delPower(power.getPowerId())){
					//删除成功
					
				}else{
					//删除失败
				}
				this.sendRedirect(request, response, "/PowerServlet?method=list");
			}else if(method.equals("addLoad")){
				//新增前的加载
				this.forward(request, response, "/system/power/power.jsp");
			}
		//事务提交
		DataBase.commit();
		
	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		if(conn!=null){
			//关闭连接
			DataBase.releaseConnection(conn);
		}
	}
	   
}
   
   
}