pa_employeerecordservlet.java

来自「J2ee开发的 人事管理系统 使用oracle数据库 myeclips平台开」· Java 代码 · 共 405 行

package com.galaxy.controller;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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

import com.galaxy.dao.DeptInfoDAO;
import com.galaxy.dao.EmployeeRecordDAO;
import com.galaxy.dao.RewardPunishDAO;
import com.galaxy.vo.EmployeeRecordVO;
import com.galaxy.vo.RewardPunishVO;
import com.galaxy.vo.UserInfoVO;
import com.galaxy.dao.UserInfoDAO;
import com.galaxy.util.PageHelp;



public class PA_EmployeeRecordServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public PA_EmployeeRecordServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		
		request.setCharacterEncoding("gb2312");
		String opflag="";
		opflag=request.getParameter("opflag");
		if("CVSave".equals(opflag)){	 
		   
		}
		else if("query".equals(opflag)){
			try{
			DoMyQuery(request,response);
			}
			catch(SQLException e){
				e.printStackTrace();
			}
		

		}
		else if("eradd".equals(opflag))
		{
			try{
				DoAddER(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		else if("deler".equals(opflag))
		{
			try{
				DoDelER(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		else if("deler1".equals(opflag))
		{
			try{
				DoDelER1(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		else if("ERchange".equals(opflag))
		{
			try{
				DoChangeER(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		
		else if("ERimplementchange".equals(opflag))
		{
			try{
				DoImplementChange(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		else if("particularrp".equals(opflag))
		{
			try{
				DoParticularRP(request,response);
				}
				catch(SQLException e){
					e.printStackTrace();
				}
			
		}
		else if("ajax".equals(opflag))
		{			
			CheckPersonID(request, response);
		}
			else{}
	
		
		
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}
	public void DoMyQuery(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		int pageSize=5;//设置单页显示条数
		int currentPage=1;//当前显示的页面号
		
		String errmessage="";
		
		if(request.getParameter("errmessage")!=null&&!"".equals(request.getParameter("errmessage"))){
			currentPage=Integer.parseInt(request.getParameter("errmessage"));
		}
		
		DeptInfoDAO depdao=new DeptInfoDAO();
		
		ArrayList deplist=(ArrayList)depdao.queryByCondition("");
		String cond="";
		if(request.getParameter("currentPage")!=null&&!"".equals(request.getParameter("currentPage"))){
			currentPage=Integer.parseInt(request.getParameter("currentPage"));
		}
		PageHelp pagehelp=new PageHelp();//实例化PageHelp对象pageHelp
		EmployeeRecordDAO recorddao=new EmployeeRecordDAO();
		if(request.getParameter("selectdep")!=null&&!"".equals(request.getParameter("selectdep"))){
			cond+=" and di_id="+request.getParameter("selectdep");	
		}else{
		}
			if(request.getParameter("ui_name")!=null&&!"".equals(request.getParameter("ui_name"))){
				cond+=" and ui_realname like '%"+request.getParameter("ui_name")+"%'";
			
	
		}
		pagehelp=recorddao.getList(cond, pageSize, currentPage);
		request.setAttribute("errmessage", errmessage);
		request.setAttribute("deplist", deplist);
		request.setAttribute("pagehelp",pagehelp);
		request.getRequestDispatcher("./psl_archive/staff_CV/pa_recordsearch1.jsp").forward(request,response);
	}
	public void DoAddER(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();
		EmployeeRecordVO ervo=new EmployeeRecordVO();
		UserInfoVO uservo=new UserInfoVO();
		uservo.setUiPersonid(Long.valueOf(request.getParameter("userid")));
		String sql="select ui_id from user_info where ui_personid="+uservo.getUiPersonid();
		uservo.setUiId(erdao.GetUIID(sql));
	    ervo.setUserInfo(uservo);
	    ervo.setEndTime(Date.valueOf(request.getParameter("endtime")));
	    ervo.setErContent(request.getParameter("content"));
	    ervo.setErDepartment(request.getParameter("department"));
	    ervo.setErFactory(request.getParameter("company"));
	    ervo.setErGrade(request.getParameter("grade"));
	    ervo.setErPosition(request.getParameter("addposition"));
	    ervo.setStartTime(Date.valueOf(request.getParameter("starttime")));
		int i=0;
		 i=erdao.addObject(ervo);
		if(i!=0){
			int pageSize=5;//设置单页显示条数
			int currentPage=1;//当前显示的页面号
			String cond="";
			PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
			request.setAttribute("pagehelp",pagehelp);
			request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query").forward(request,response);
		}else{
			int pageSize=5;//设置单页显示条数
			int currentPage=1;//当前显示的页面号
			String cond="";
			PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
			request.setAttribute("pagehelp",pagehelp);
			request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query&errmessage=1").forward(request,response);
		}
	}
	
	public void DoDelER(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();
		String pitch[]=request.getParameterValues("ercheckbox");
		String cond="";
		if(pitch.length!=0)
		{
			for(int i=0;i<pitch.length;i++)
			{
				cond+=","+pitch[i];
			}
		}
		cond = cond.substring(1);
		System.out.println(cond);
		int i=0;
		i=erdao.deleteObject(cond);
		if(i==0){
		int pageSize=5;//设置单页显示条数
		int currentPage=1;//当前显示的页面号
		cond="";
		PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
		request.setAttribute("pagehelp",pagehelp);
		request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query").forward(request,response);
		}
		else{
			int pageSize=5;//设置单页显示条数
			int currentPage=1;//当前显示的页面号
			cond="";
			PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
			request.setAttribute("pagehelp",pagehelp);
			request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query&errmessage=3").forward(request,response);
		}
	}
	public void DoDelER1(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();				
		String pitch[]=request.getParameterValues("ercheckbox");
		String cond="";
		if(pitch.length!=0)
		{
			for(int i=0;i<pitch.length;i++)
			{
				cond+=","+pitch[i];
			}
		}
		cond = cond.substring(1);	
		int i=0;
		i=erdao.deleteObject(cond);
		int pageSize=5;//设置单页显示条数
		int currentPage=1;//当前显示的页面号
		cond="";
		PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
		UserInfoVO  uservo = new UserInfoVO();
		UserInfoDAO userdao = new UserInfoDAO();
		uservo.setUiId(Long.valueOf(request.getParameter("userid")));
		uservo = (UserInfoVO)userdao.readObject(uservo);
		request.setAttribute("uservo", uservo);
		request.setAttribute("pagehelp",pagehelp);
		request.getRequestDispatcher("./psl_archive/staff_CV/pa_recordsingle.jsp").forward(request,response);
	}
	
		public void DoChangeER(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();
		EmployeeRecordVO ervo=new EmployeeRecordVO();
		String erid=request.getParameter("changeid");
		String sql="select * from user_info u join  employee_record c on u.ui_id=c.ui_id where er_id="+erid;
		
		ervo=(EmployeeRecordVO)erdao.readObject(sql);
		ervo.setErId(Long.valueOf(erid));
		request.setAttribute("ervo",ervo);
		request.getRequestDispatcher("./psl_archive/staff_CV/pa_recordchange.jsp").forward(request,response);
	}
	
		public void DoImplementChange(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();
		EmployeeRecordVO ervo=new EmployeeRecordVO();
		String erid=request.getParameter("erid");
		ervo.setStartTime(Date.valueOf(request.getParameter("startdate")));
		ervo.setEndTime(Date.valueOf(request.getParameter("enddate")));
		ervo.setErDepartment(request.getParameter("erdepartment"));
		ervo.setErFactory(request.getParameter("ercompany"));
		ervo.setErPosition(request.getParameter("erposition"));
		ervo.setErContent(request.getParameter("ercontent"));
		ervo.setErGrade(request.getParameter("ergrade"));
		ervo.setErId(Long.valueOf(request.getParameter("erid")));
		String sql="update employee_record set er_department='"+ervo.getErDepartment()+
		"',er_factory='"+ervo.getErFactory()+"',start_time=to_date('"+request.getParameter("startdate")+
		"','yyyy-mm-dd'),end_time=to_date('"+request.getParameter("enddate")+
				"','yyyy-mm-dd')"+", er_grade='"+ervo.getErGrade()+"',er_position='"+ervo.getErPosition()+
				"',er_content='"+ervo.getErContent()+
		"' where er_id="+erid;
		
		int i=erdao.updateObject(sql);
		
		if(i!=0){
		int pageSize=5;//设置单页显示条数
		int currentPage=1;//当前显示的页面号
		String cond="";
		PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
		request.setAttribute("pagehelp",pagehelp);
		request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query").forward(request,response);
		}
		else
		{
			int pageSize=5;//设置单页显示条数
			int currentPage=1;//当前显示的页面号
			String cond="";
			PageHelp pagehelp=erdao.getList(cond, pageSize, currentPage);
			request.setAttribute("pagehelp",pagehelp);
			request.getRequestDispatcher("PA_EmployeeRecordServlet?opflag=query&errmessage=2").forward(request,response);
		}
	}

	public void DoParticularRP(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException, SQLException{
		int pageSize=5;//设置单页显示条数
		int currentPage=1;//当前显示的页面号
		UserInfoVO uservo = new UserInfoVO();
		UserInfoDAO userdao = new UserInfoDAO();
		
		String cond=" and u.ui_id="+request.getParameter("puiid");
		PageHelp pagehelp=new PageHelp();//实例化PageHelp对象pageHelp
		EmployeeRecordDAO erdao=new EmployeeRecordDAO();
		
		uservo.setUiId(Long.valueOf(request.getParameter("puiid")));
		uservo = (UserInfoVO)userdao.readObject(uservo);
		pagehelp=erdao.getList(cond, pageSize, currentPage);
		request.setAttribute("uservo", uservo);
		request.setAttribute("pagehelp",pagehelp);			
		request.getRequestDispatcher("./psl_archive/staff_CV/pa_recordsingle.jsp").forward(request,response);
		
		
	}
	
	public void CheckPersonID(HttpServletRequest request, HttpServletResponse response)
	{
		String rspResult = "0";
		
		String personID = request.getParameter("personID");
		UserInfoDAO userdao = new UserInfoDAO();
		
		if(personID != null && !personID.equals("") )
		{
			String cond = " and ui_personid='" + personID + "'";
			List userlist = new ArrayList();
			userlist = userdao.queryByCondition(cond);
			if(userlist != null && userlist.size() != 0)
			{
				rspResult = "1";
			}
		}
		
		try {
			PrintWriter out = response.getWriter();
			out.write(rspResult);
			out.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}

}