emppowerservlet.java

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

package com.oa.lp.servlet;

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

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

import com.oa.lp.dao.EmpPowerDAO;
import com.oa.lp.dao.EmpRoleDAO;
import com.oa.lp.dao.EmployeeDAO;
import com.oa.lp.dao.MenuDAO;
import com.oa.lp.dao.PowerDAO;
import com.oa.lp.dao.RoleDAO;
import com.oa.lp.dao.RolePowerDAO;
import com.oa.lp.database.DataBase;

public class EmpPowerServlet extends TopServlet {

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

		
		String method = request.getParameter("method")==null?"":request.getParameter("method");
		String empIdStr = request.getParameter("empId")==null?"0":request.getParameter("empId");
		String []powerIds = request.getParameterValues("powerIds");
		int empId=0;
		if(empIdStr.length()>0){
			empId = Integer.parseInt(empIdStr);
		}
		Connection conn=null;
		try{
			conn = DataBase.getConnection();
			EmployeeDAO empDao = new EmployeeDAO();
			RoleDAO roleDao = new RoleDAO();
			MenuDAO menuDao = new MenuDAO();
			PowerDAO powerDao = new PowerDAO();
			EmpPowerDAO empPowerDao = new EmpPowerDAO();
			empDao.setConn(conn);
			roleDao.setConn(conn);
			menuDao.setConn(conn);
			powerDao.setConn(conn);
			empPowerDao.setConn(conn);
			
			
			 if(method.equals("addLoad")){
				 request.setAttribute("emp",empDao.getById(empId));
				 request.setAttribute("menus",menuDao.listAllMenu());
				 request.setAttribute("powers",powerDao.listAllPower(1));
				 request.setAttribute("empPowers",empPowerDao.getPowersByEmpId(empId));
				 request.setAttribute("rolePowers", empPowerDao.getRolePowersByEmpId(empId));
				 this.forward(request, response, "/system/employee/empPower.jsp");
			 }else if(method.equals("add")){
				//分配权限
					if(powerIds.length>1){
						//先删除后添加
						empPowerDao.delEmpPower(empId);
						empPowerDao.addEmpPower(empId, powerIds);
					}else{
						//删除所有
						empPowerDao.delEmpPower(empId);
					}
					this.sendRedirect(request, response,"/EmployeeServlet?method=list");
			 }
			//事务提交
			DataBase.commit();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}

		 
	}
}