informservlet.java

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

package com.oa.lp.servlet;

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

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

import com.oa.lp.dao.CompanyDAO;
import com.oa.lp.dao.InformDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Inform;




public class InformServlet 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 informId = request.getParameter("informId")==null?"0":request.getParameter("informId");
		   String companyId = request.getParameter("companyId")==null?"0":request.getParameter("companyId");
		   String informTitle = request.getParameter("informTitle")==null?"":request.getParameter("informTitle");
		   String informcontent = request.getParameter("informcontent")==null?"":request.getParameter("informcontent");
		   String informSendTime = request.getParameter("informSendTime")==null?"":request.getParameter("informSendTime");
		   String sendPerson = request.getParameter("sendPerson")==null?"":request.getParameter("sendPerson");
		   String informState = request.getParameter("informState")==null?"0":request.getParameter("informState");
		   
		   Inform inform = new Inform();
		   if(informId.length()>0){
			   inform.setInformId(Integer.parseInt(informId));
		   }
		   if(companyId.length()>0){
			   inform.setCompanyId(Integer.parseInt(companyId));
		   }
		   inform.setInformTitle(informTitle);
		   inform.setInformcontent(informcontent);
		   if(informSendTime.length()>0){
			   inform.setInformSendTime(Date.valueOf(informSendTime));
		   }
		   inform.setSendPerson(sendPerson);
		   if(informState.length()>0){
			   inform.setInformState(Integer.parseInt(informState));
		   }
		   
		
		   Connection conn=null;
		try {
			conn = DataBase.getConnection();
			InformDAO informDao = new InformDAO();
			informDao.setConn(conn);
			if(method.equals("list")){
				request.setAttribute("informs",informDao.listAllInforms());
				this.forward(request, response,"/system/inform/list.jsp");
			}else if(method.equals("edit")){
				request.setAttribute("informs",informDao.getInformById(inform.getInformId()));
				this.forward(request, response,"/system/inform/inform.jsp");
			}else if(method.equals("update")){
				informDao.updateInform(inform);
				this.sendRedirect(request, response,"/InformServlet?method=list");
			}else if(method.equals("add")){
				informDao.addInforms(inform);
				this.sendRedirect(request, response,"/InformServlet?method=list");
			}else if(method.equals("addLoad")){
				this.forward(request, response,"/system/inform/inform.jsp");
			}
			//事务提交
			DataBase.commit();
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}	   
	}    
	}