emailservlet.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 javax.servlet.http.HttpSession;

import com.oa.lp.dao.DraftBoxDAO;
import com.oa.lp.dao.EmployeeDAO;
import com.oa.lp.dao.InboxDAO;
import com.oa.lp.dao.OutboxDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Employee;

public class EmailServlet extends TopServlet {

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String method = request.getParameter("method")==null?"":request.getParameter("method");
		String draftId = request.getParameter("draftId")==null?"0":request.getParameter("draftId");
		String inboxId = request.getParameter("inboxId")==null?"0":request.getParameter("inboxId");
		String outId = request.getParameter("outId")==null?"0":request.getParameter("outId");
		HttpSession session = request.getSession();
		Connection conn = null;
		try {
			
			Employee emp = (Employee) session.getAttribute("emp");
			conn = DataBase.getConnection();
			EmployeeDAO empDao = new EmployeeDAO();
			DraftBoxDAO draftDao = new DraftBoxDAO();
			InboxDAO inboxDao = new InboxDAO();
			OutboxDAO outboxDao = new OutboxDAO();
			empDao.setConn(conn);
			draftDao.setConn(conn);
			inboxDao.setConn(conn);
			outboxDao.setConn(conn);
			
			if(method.equals("addLoad")){
				//写邮件
				this.forward(request, response,"/email/addEmail.jsp");
			}else if(method.equals("empList")){
				//员工列表
				request.setAttribute("emps",empDao.getEmps());
				this.forward(request, response,"/email/empList.jsp");
			}else if(method.equals("draftBox")){
				request.setAttribute("draftBoxs", draftDao.listAllDraft(emp.getEmpId()));
				this.forward(request, response,"/email/draftList.jsp");
			}else if(method.equals("del")){
				draftDao.delDraft(Integer.parseInt(draftId));
				this.sendRedirect(request, response,"/EmailServlet?method=draftBox");
			}else if(method.equals("outBox")){
				request.setAttribute("outBoxs",outboxDao.listAllOutBox(emp.getEmpId()));
				this.forward(request, response,"/email/outBox.jsp");
			}else if(method.equals("inBox")){
				request.setAttribute("inBoxs",inboxDao.listAllInBox(emp.getEmpId()));
				this.forward(request, response,"/email/inBox.jsp");
			}else if(method.equals("editDraft")){
				request.setAttribute("draftAnnex", draftDao.getAnnexByDraftId(Integer.parseInt(draftId)));
				request.setAttribute("draftBoxs",draftDao.getById(Integer.parseInt(draftId)));
				this.forward(request, response,"/email/draftBox.jsp");
			}else if(method.equals("lookinbox")){
				request.setAttribute("inboxannex",inboxDao.getAnnexById(Integer.parseInt(inboxId)));
				request.setAttribute("inbox",inboxDao.getById(Integer.parseInt(inboxId)));
				this.forward(request, response,"/email/lookInbox.jsp");
			}else if(method.equals("lookoutbox")){
				request.setAttribute("outbox",inboxDao.getById(Integer.parseInt(outId)));
				this.forward(request, response,"/email/lookOutbox.jsp");
			}else if(method.equals("delInBox")){
				inboxDao.delInBox(Integer.parseInt(inboxId));
				this.sendRedirect(request, response,"/EmailServlet?method=inBox");
			}else if(method.equals("delOutBox")){
				outboxDao.delOutBox(Integer.parseInt(outId));
				this.sendRedirect(request, response,"/EmailServlet?method=outBox");
			}else if(method.equals("reply")){
				request.setAttribute("inbox",inboxDao.getById(Integer.parseInt(inboxId)));
				this.forward(request, response,"/email/reply.jsp");
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				// 关闭连接
				DataBase.releaseConnection(conn);
			}
		}
	}
}