commlinkmanservlet.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.CommLinkManDAO;
import com.oa.lp.dao.CompanyDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.CommLinkMan;
import com.oa.lp.model.Company;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;




public class CommLinkManServlet 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 commLinkManId = request.getParameter("commLinkManId")==null?"0":request.getParameter("commLinkManId");
		   String companyId = request.getParameter("companyId")==null?"0":request.getParameter("companyId");
		   String linkManName = request.getParameter("linkManName")==null?"":request.getParameter("linkManName");
		   String linkManEmail = request.getParameter("linkManEmail")==null?"":request.getParameter("linkManEmail");
		   String linkManQq = request.getParameter("linkManQq")==null?"":request.getParameter("linkManQq");
		   String linkManMobile = request.getParameter("linkManMobile")==null?"":request.getParameter("linkManMobile");
		   String linkManTel = request.getParameter("linkManTel")==null?"":request.getParameter("linkManTel");
		   String linkManBirthday = request.getParameter("linkManBirthday")==null?"":request.getParameter("linkManBirthday");
		   String homeAddress = request.getParameter("homeAddress")==null?"":request.getParameter("homeAddress");
		   String comName = request.getParameter("comName")==null?"":request.getParameter("comName");
		   String comAddress = request.getParameter("comAddress")==null?"":request.getParameter("comAddress");
		   String linkManState = request.getParameter("linkManState")==null?"0":request.getParameter("linkManState");
		   
		   CommLinkMan comLinkMan = new CommLinkMan();
		   if(commLinkManId.length()>0){
			   comLinkMan.setCommLinkManId(Integer.parseInt(commLinkManId));
		   }
		   if(companyId.length()>0){
			   comLinkMan.setCompanyId(Integer.parseInt(companyId));
		   }
		   comLinkMan.setLinkManName(linkManName);
		   comLinkMan.setLinkManEmail(linkManEmail);
		   comLinkMan.setLinkManQq(linkManQq);
		   comLinkMan.setLinkManMobile(linkManMobile);
		   comLinkMan.setLinkManTel(linkManTel);
		   comLinkMan.setLinkManBirthday(linkManBirthday);
		  
		   comLinkMan.setHomeAddress(homeAddress);
		   comLinkMan.setComName(comName);
		   comLinkMan.setComAddress(comAddress);
		   if(linkManState.length()>0){
			   comLinkMan.setLinkManState(Integer.parseInt(linkManState));
		   }
		   
		   Connection conn=null;
		try {
			conn = DataBase.getConnection();
			CommLinkManDAO commLinkManDao = new CommLinkManDAO();
			commLinkManDao.setConn(conn);
			
			if(method.equals("list")){
				request.setAttribute("commLinkMans",commLinkManDao.listAllComms());
				this.forward(request, response,"/system/commLinkMan/list.jsp");
			}else if(method.equals("edit")){
				request.setAttribute("comms",commLinkManDao.getCommLinkManById(Integer.parseInt(commLinkManId)));
				this.forward(request, response,"/system/commLinkMan/comLinkMan.jsp");
			}else if(method.equals("update")){
				commLinkManDao.updatecommLinkMan(comLinkMan);
				this.sendRedirect(request, response,"/CommLinkManServlet?method=list");
			}else if(method.equals("del")){
				commLinkManDao.delComms(comLinkMan.getCommLinkManId());
				this.sendRedirect(request, response,"/CommLinkManServlet?method=list");
			}else if(method.equals("add")){
				commLinkManDao.addComms(comLinkMan);
				this.sendRedirect(request, response,"/CommLinkManServlet?method=list");
			}else if(method.equals("addLoad")){
				this.forward(request, response,"/system/commLinkMan/comLinkMan.jsp");
			}
			//事务提交
			DataBase.commit();
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}	   
	}    
	}