sharefileservlet.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.EmployeeDAO;
import com.oa.lp.dao.FileDAO;
import com.oa.lp.dao.ShareFileDAO;
import com.oa.lp.database.DataBase;

public class ShareFileServlet extends TopServlet {

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

		
		String method = request.getParameter("method")==null?"":request.getParameter("method");
		String fileIdStr = request.getParameter("fileId")==null?"0":request.getParameter("fileId");
		String []empIds = request.getParameterValues("empIds");
		int fileId=0;
		if(fileIdStr.length()>0){
			fileId = Integer.parseInt(fileIdStr);
		}
		Connection conn=null;
		try{
			conn = DataBase.getConnection();
			EmployeeDAO empDao = new EmployeeDAO();
			FileDAO fileDao = new FileDAO();
			ShareFileDAO shareFileDao = new ShareFileDAO();

			empDao.setConn(conn);
			fileDao.setConn(conn);
			shareFileDao.setConn(conn);
		
			 if(method.equals("addLoad")){
				 //加载员工
				 request.setAttribute("emps", empDao.listAllEmployee());
				 request.setAttribute("file",fileDao.getFileById(fileId));
				 request.setAttribute("sharefiles", shareFileDao.getEmpByFileId(fileId));
				 this.forward(request, response, "/shareFile/shareFile.jsp");
			 }else if(method.equals("add")){
				 //分配员工
				if(empIds.length>1){
					//先删除后添加
					shareFileDao.delFileEmp(fileId);
					shareFileDao.addFileEmp(fileId, empIds);
					
				}else{
					//删除所有
					shareFileDao.delFileEmp(fileId);
				}
				this.sendRedirect(request, response,"/FolderServlet?method=addLoad");
			 }
			//事务提交
			DataBase.commit();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}

		 
	}
}