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

import com.oa.lp.dao.CommLinkManDAO;
import com.oa.lp.dao.CompanyDAO;
import com.oa.lp.dao.LogDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.CommLinkMan;
import com.oa.lp.model.Company;
import com.oa.lp.model.Employee;
import com.oa.lp.model.Log;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;




public class LogServlet 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 logId = request.getParameter("logId")==null?"0":request.getParameter("logId");
		  // String empId = request.getParameter("empId")==null?"0":request.getParameter("empId");
		   //String logTime = request.getParameter("logTime")==null?"":request.getParameter("logTime");
		   String logContent = request.getParameter("logContent")==null?"":request.getParameter("logContent");
		   Log log = new Log();
		   if(logId.length()>0){
			   log.setLogId(Integer.parseInt(logId));
		   }
		   /*
		   if(empId.length()>0){
			   log.setEmpId(Integer.parseInt(empId));
		   }
		   */
		   /*if(logTime.length()>0){
			   log.setLogTime(Date.valueOf(logTime));
		   }*/
		   log.setLogContent(logContent);
		   HttpSession session = request.getSession();
		   Connection conn=null;
		try {
			Employee emp = (Employee) session.getAttribute("emp");
			conn = DataBase.getConnection();
			LogDAO logDao = new LogDAO();
			logDao.setConn(conn);
			
			if(method.equals("list")){
				
				request.setAttribute("logs",logDao.listAllLogs(emp.getEmpId()));
				this.forward(request, response,"/system/log/list.jsp");
			}else if(method.equals("edit")){
				request.setAttribute("logs",logDao.getLogById(Integer.parseInt(logId)));
				this.forward(request, response,"/system/log/log.jsp");
			}else if(method.equals("update")){
				logDao.updateLog(log,emp.getEmpId());
				this.sendRedirect(request, response,"/LogServlet?method=list");
			}else if(method.equals("del")){
				logDao.delLog(Integer.parseInt(logId));
				this.sendRedirect(request, response,"/LogServlet?method=list");
			}else if(method.equals("add")){
				logDao.addLog(log,emp.getEmpId());
				this.sendRedirect(request, response,"/LogServlet?method=list");
			}else if(method.equals("addLoad")){
				this.forward(request, response,"/system/log/log.jsp");
			}
			//事务提交
			DataBase.commit();
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}	   
	}    
	}