pd_maindispatchservlet.java

J2ee开发的 人事管理系统 使用oracle数据库 myeclips平台开发

/**
 * @(#)Prmis , Created on 2008-10-19
 *
 * Copyright (c) galaxy Teamwork
 *
 * MODIFY MEMO:
 * 
 */

package com.galaxy.controller;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
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.ChangeRecordDAO;
import com.galaxy.dao.DeptInfoDAO;
import com.galaxy.dao.UserInfoDAO;
import com.galaxy.util.PageHelp;
import com.galaxy.vo.ChangeRecordVO;
import com.galaxy.vo.DeptInfoVO;
import com.galaxy.vo.UserInfoVO;

public class PD_MainDispatchServlet extends HttpServlet {

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

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

	/**
	 * 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);
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		response.setCharacterEncoding("gb2312");
		String opflag="";
		opflag=request.getParameter("opflag");
		/**servlet对请求操作符opflag进行判断并根据不同的请求执行不同的方法
		 * 由上到下的方法顺序是增删改查*/	
		/** 操作符为空时的语句分支,登录人事管理界面*/		
		if("".equals(opflag)){
			loadItem(request,response);				
		}
		else if("userchoose".equals(opflag))
		{
			userChooseItem(request,response);
		}
		else if("choose".equals(opflag)){
			choosestaff(request,response);
		}
		else if("staffquery".equals(opflag)){
			staffqueryItem(request,response);
		}
		else if("list".equals(opflag)){
			listItem(request,response);
		}
		else if("userlist".equals(opflag)){
			userlistItem(request,response);
		}
		else if("add".equals(opflag)){
			addItem(request,response);
		}
		else if("delete".equals(opflag)){
			deleteItem(request,response);
		}
		else if("beforedit".equals(opflag)){
			editItem(request,response);
		}
		else if("afteredit".equals(opflag)){				
			updateItem(request,response);
		}
		else if("query".equals(opflag)){
			queryItem(request,response);
		}	
					
	}



/************************************************************************************/
	/**分别定义登录、增、删、改‘查等servlet要执行的私有方法与opflag对应*/
	/**
	 * PD_MainDispatchServlet的私有方法
	 * 操作符opflag为"load"时所调用的方法
	 * 直接调出所有的人事调动记录
	 * @throws IOException if an error occurred
	 * @throws ServletException if an error occurred
	 */
	private void loadItem(HttpServletRequest request, HttpServletResponse response){
		/**操作符为""时调出所有部门到下拉菜单*/
		List deptlist=new ArrayList();
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql=" and di_state='可用'";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);
		/**PageHelp类实现分页功能*/
		ChangeRecordDAO changedao=new ChangeRecordDAO();
		PageHelp pagehelp = new PageHelp();
		int pageSize = 5; 
		pagehelp = changedao.getUserList("", pageSize,1);
		request.setAttribute("pagehelp", pagehelp);
		/**页面跳转到人事调动管理主页面*/
		try {
			request.getRequestDispatcher("ResourceChangedManagement.jsp").
			forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
			}				
	}
	/**
	 * PD_MainDispatchServlet的私有方法
	 * 操作符opflag为"ajax"时所调用的方法
	 * 响应页面的AJAX控件，动态显示用户输入信息是否在数据库中存在和是否可用
	 * @throws IOException if an error occurred
	 * @throws ServletException if an error occurred
	 */
	private void userChooseItem(HttpServletRequest request, HttpServletResponse response) {
		/**操作符为""时调出所有部门到下拉菜单*/
		List deptlist=new ArrayList();
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql=" and di_state='可用'";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);
		
		ChangeRecordDAO changedao=new ChangeRecordDAO();
		PageHelp pagehelp = new PageHelp();
		int pageSize = 5; 
		String cond="";
		pagehelp = changedao.getList(cond, pageSize,1);
		request.setAttribute("pagehelp", pagehelp);
		
		try {
			request.getRequestDispatcher("ChooseStaff.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}
	private void choosestaff(HttpServletRequest request, HttpServletResponse response) {
		Long ui_id=Long.valueOf(request.getParameter("checkbox"));
		UserInfoDAO userdao=new UserInfoDAO();
		List userlist=new ArrayList();
		String cond=" and ui_id="+ui_id+"";
		userlist=(ArrayList)userdao.queryByCondition(cond);
		request.setAttribute("userlist", userlist);
		
		/**操作符为"addnew"时调出所有部门到下拉菜单*/	
		List deptlist=new ArrayList();	
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql=" and di_state='可用'";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);
		try {
			request.getRequestDispatcher("AddNewRecord.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	private void userlistItem(HttpServletRequest request, HttpServletResponse response) {
		/**操作符为"list"时调出所有部门到下拉菜单*/
		List deptlist=new ArrayList();
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql=" and di_state='可用'";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);

		ChangeRecordDAO changedao=new ChangeRecordDAO();
		PageHelp pagehelp = new PageHelp();
		int pageSize = 5; 
		String condition=request.getParameter("condition");
		int currentPage=Integer.parseInt(request.getParameter("currentPage"));
		pagehelp =changedao.getList(condition,pageSize,currentPage);
		request.setAttribute("currentPage", request.getParameter("currentPage"));
		request.setAttribute("pagehelp", pagehelp);
		/**跳转*/
		try {
			request.getRequestDispatcher("ChooseStaff.jsp").
			forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
			
	}
	private void staffqueryItem(HttpServletRequest request, HttpServletResponse response) {
		ChangeRecordDAO changedao=new ChangeRecordDAO();
		String ui_realname="%";
		String cond="";
		Long di_id=0l;
		if(request.getParameter("dept")!=null&&!"0".equals(request.getParameter("dept"))){
			di_id=Long.valueOf((request.getParameter("dept")));
			cond+=" and pcr_exdept='"+di_id+"'";
		}
		if(request.getParameter("username")!=null&&!"".equals(request.getParameter("username"))){
			ui_realname=request.getParameter("username");
			cond+=" and ui_realname like '%"+ui_realname+"%'";
			}
		PageHelp pagehelp=new PageHelp();
		int pageSize=5;
		pagehelp =changedao.getList(cond,pageSize,1);
		request.setAttribute("pagehelp", pagehelp);
		/**调出所有部门到下拉菜单*/	
		List deptlist=new ArrayList();
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql="";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);
		/**跳转页面*/
		try {
			request.getRequestDispatcher("ChooseStaff.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}				
	}

	/**
	 * PD_MainDispatchServlet的私有方法
	 * 操作符opflag为"list"时所调用的方法
	 * 响应下一页操作
	 * @throws IOException if an error occurred
	 * @throws ServletException if an error occurred
	 */
	private void listItem(HttpServletRequest request, HttpServletResponse response) {
		/**操作符为"list"时调出所有部门到下拉菜单*/
		List deptlist=new ArrayList();
		DeptInfoDAO deptdao=new DeptInfoDAO();
		String depSql=" and di_state='可用'";
		deptlist=deptdao.queryByCondition(depSql);
		request.setAttribute("deptlist", deptlist);
		/**分页*/
		ChangeRecordDAO changedao=new ChangeRecordDAO();
		PageHelp pagehelp = new PageHelp();
		int pageSize = 5; 
		String condition=request.getParameter("condition");
		int currentPage=Integer.parseInt(request.getParameter("currentPage"));
		pagehelp =changedao.getUserList(condition,pageSize,currentPage);
		request.setAttribute("currentPage", request.getParameter("currentPage"));
		request.setAttribute("pagehelp", pagehelp);
		/**跳转到人事调动管理页面*/
		try {
			request.getRequestDispatcher("ResourceChangedManagement.jsp").