folderservlet.java

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

package com.oa.lp.servlet;

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

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.FolderDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Employee;
import com.oa.lp.model.Folder;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;

public class FolderServlet extends TopServlet {

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

		// 接参
		String method = request.getParameter("method") == null?"":request.getParameter("method");
		String folderIdStr = request.getParameter("folderId");
		String parentFolderIdStr = request.getParameter("parentFolderId");
		String folderName = request.getParameter("folderName");
		int folderId=0;
		int parentFolderId=0;
		if(folderIdStr!=null&&folderIdStr.length()>0){
			folderId = Integer.parseInt(folderIdStr);
		}
		if(parentFolderIdStr!=null&&parentFolderIdStr.length()>0){
			parentFolderId = Integer.parseInt(parentFolderIdStr);
		}
		//获得EMPID
		Employee emp = (Employee)request.getSession().getAttribute("emp");
		int empId = emp.getEmpId();
		//封装对象
		Folder folder = new Folder();
		folder.setFolderName(folderName);
		folder.setParentfolderId(parentFolderId);
		folder.setEmpId(empId);
		Connection conn = null;
		try {
			conn = DataBase.getConnection();
			FolderDAO folderDao = new FolderDAO();
			FileDAO fileDao = new FileDAO();
			folderDao.setConn(conn);
			fileDao.setConn(conn);
			if (method.equals("list")) {
				request.setAttribute("folderId",folderIdStr);
				request.setAttribute("folders",folderDao.listAllFolder(folderId));
				request.setAttribute("files",fileDao.listAllFile(folderId));
				String fileName = request.getContextPath()+"/FolderServlet?method=list";
				request.setAttribute("path",folderDao.getPathByFolderId(folderId,fileName));
				this.forward(request, response, "/folder/list.jsp");
			}else if(method.equals("addLoad")){
				request.setAttribute("sharefiles", folderDao.listAllFiles(empId));
				request.setAttribute("folderId",folderIdStr);
				request.setAttribute("folders",folderDao.listAllFolders(empId));
				request.setAttribute("files",fileDao.listAllFile(folderId));
				String fileName = request.getContextPath()+"/FolderServlet?method=list";
				request.setAttribute("path",folderDao.getPathByFolderId(folderId,fileName));
				this.forward(request, response, "/folder/list.jsp");
			}else if(method.equals("add")){
				folderDao.addFolder(folder);
				this.sendRedirect(request, response,"/FolderServlet?method=list&folderId="+folderIdStr);
			}else if(method.equals("del")){
				if(folderDao.delFolder(folderId)){
					//成功
	
				}else{
					//失败
				}
				this.sendRedirect(request, response,"/FolderServlet?method=list&folderId="+parentFolderIdStr);
			}
			// 事务提交
			DataBase.commit();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				// 关闭连接
				DataBase.releaseConnection(conn);
			}
		}

	}

}