companyservlet.java

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

package com.oa.lp.servlet;

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

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

import com.oa.lp.dao.CompanyDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Company;




public class CompanyServlet 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 companyId = request.getParameter("companyId")==null?"0":request.getParameter("companyId");
		   String companyName = request.getParameter("companyName")==null?"":request.getParameter("companyName");
		   String companyHomePage = request.getParameter("companyHomePage")==null?"":request.getParameter("companyHomePage");
		   String companyCopyRight = request.getParameter("companyCopyRight")==null?"":request.getParameter("companyCopyRight");
		   Company company = new Company();
		   if(companyId.length()>0){
			   company.setCompanyId(1);
		   }
		   company.setCompanyName(companyName);
		   company.setCompanyHomePage(companyHomePage);
		   company.setCompanyCopyRight(companyCopyRight);
		
		   Connection conn=null;
		try {
			conn = DataBase.getConnection();
			CompanyDAO companyDao = new CompanyDAO();
			companyDao.setConn(conn);
			if(method.equals("addLoad")){
		
				this.forward(request, response,"/system/company/list.jsp");
			}else if(method.equals("edit")){
				this.forward(request, response,"/system/company/company.jsp");
			}else if(method.equals("update")){
				companyDao.updateCompany(company);
				this.sendRedirect(request, response,"/CompanyServlet?method=list");
			}else if(method.equals("list")){
				
				this.forward(request, response,"/system/company/list.jsp");
			}
			//事务提交
			DataBase.commit();
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}	   
	}    
	}