pa_employeefileservlet.java

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

package com.galaxy.controller;

import java.io.IOException;
import java.io.PrintWriter;
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.EmployeeFileDAO;
import com.galaxy.dao.UserInfoDAO;
import com.galaxy.util.PageHelp;
import com.galaxy.vo.EmployeeFileVO;
import com.galaxy.vo.UserInfoVO;

public class PA_EmployeeFileServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public PA_EmployeeFileServlet() {
		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");	
		response.setCharacterEncoding("gb2312");
		String opflag = "";		
		opflag = request.getParameter("opflag");		
				
		System.out.println(opflag);
		
		if("ajax".equals(opflag))
		{			
			CheckPersonID(request, response);
		}
		if("query".equals(opflag))
		{
			QueryFile(request, response);
		}
		else if("deletefile".equals(opflag))
		{
			DeleteFile(request, response);
		}
		else if("addfile".equals(opflag))
		{
			AddFile(request, response);
		}
		else if("beforeedit".equals(opflag))
		{
			BeforeEdit(request, response);
		}
		else if("afteredit".equals(opflag))
		{
			AfterEdit(request, response);
		}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}
	
	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();
		}
		
	}
	
	public void QueryFile(HttpServletRequest request, HttpServletResponse response)
	{
		int pagesize = 5;
		int currentpage = 1;
		String cond = "";
		EmployeeFileDAO filedao = new EmployeeFileDAO();		
		List userlist = new ArrayList();
		List deps = new ArrayList();
		DeptInfoDAO depdao = new DeptInfoDAO();
		deps = depdao.queryByCondition("and di_state='可用'"+cond);
		if(request.getParameter("currentPage")!=null&&!"".equals(request.getParameter("currentPage")))
		{
			currentpage=Integer.parseInt(request.getParameter("currentPage"));
		}
		PageHelp pagehelp = new PageHelp();
		
		if(request.getParameter("cond")!=null && !"".equals(request.getParameter("cond")))
		{
			cond=request.getParameter("cond");	
		}
		else
		{
			if(request.getParameter("realname")!= null && !"".equals(request.getParameter("realname")))
			{
				cond+=" and ui_realname like '%"+request.getParameter("realname")+"%'";
			}
			if(request.getParameter("depid")!=null && !"0".equals(request.getParameter("depid")))
			{
				cond += " and u.di_id=" + request.getParameter("depid")+ "";
			}
			if(request.getParameter("queryfileremark")!=null && !"".equals(request.getParameter("queryfileremark")))
			{
				cond += " and e.ef_remark like '%" + request.getParameter("queryfileremark")+ "%'";
			}
		}
		pagehelp = filedao.GetList(cond, pagesize, currentpage);
//		userlist = filedao.queryByCondition(cond);
		request.setAttribute("pagehelp", pagehelp);
		request.setAttribute("deps",deps);
		request.setAttribute("username",request.getParameter("realname"));
		request.setAttribute("fileremark",request.getParameter("queryfileremark"));
		request.setAttribute("departmentid",request.getParameter("depid"));
//		request.setAttribute("userlist",userlist);
		try {
			request.getRequestDispatcher("psl_archive\\staff_archive\\pa_archivessearch1.jsp").forward(request, response);
		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void DeleteFile(HttpServletRequest request, HttpServletResponse response)
	{
		String[] todelete = request.getParameterValues("checkbox");
		EmployeeFileDAO filedao = new EmployeeFileDAO();
		String cond = "";
		for(int i=0; i < todelete.length; i++)
		{
			cond +="," + todelete[i];
		}
		cond = cond.substring(1);		
		filedao.deleteObject(cond);
		try 
		{
			request.getRequestDispatcher("PA_EmployeeFileServlet?opflag=query").forward(request, response);
		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void AddFile(HttpServletRequest request, HttpServletResponse response)
	{
		UserInfoVO uservo = new UserInfoVO();
		UserInfoDAO userdao = new UserInfoDAO();
		String personid = request.getParameter("personid");
		String cond = " and ui_personid='" + personid + "'";
		List userlist = new ArrayList();
		userlist = userdao.queryByCondition(cond);
		if(userlist.size() == 1)
		{
			uservo = (UserInfoVO)userlist.get(0);
			EmployeeFileVO filevo = new EmployeeFileVO();
			EmployeeFileDAO filedao = new EmployeeFileDAO();
			
			filevo.setUserInfo(uservo);
			filevo.setEfName(request.getParameter("filename"));
			filevo.setEfContent(request.getParameter("filecontent"));
			filevo.setEfClass(request.getParameter("fileclass"));
			filevo.setEfExtend(request.getParameter("fileextend"));
			filevo.setEfRemark(request.getParameter("fileremark"));
			int i = 0;
			i = filedao.addObject(filevo);
			if(i != 0)
			{							
				try {
					request.getRequestDispatcher("PA_EmployeeFileServlet?opflag=query").forward(request, response);
				} catch (ServletException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			else
			{
				try {
					request.getRequestDispatcher("erropage.jsp").forward(request, response);
				} catch (ServletException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		else
		{
			try {
				request.getRequestDispatcher("psl_archive\\staff_archive\\pa_archivesadd.jsp").forward(request, response);
			} catch (ServletException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	public void BeforeEdit(HttpServletRequest request, HttpServletResponse response)
	{
		String[] editfile = request.getParameterValues("checkbox");
		EmployeeFileVO filevo = new EmployeeFileVO();
		EmployeeFileDAO filedao = new EmployeeFileDAO();
		filevo.setEfId(Long.valueOf(editfile[0]));		
		filevo = (EmployeeFileVO)filedao.readObject(filevo);
		request.setAttribute("filevo", filevo);		
		try {
			request.getRequestDispatcher("psl_archive\\staff_archive\\pa_change.jsp").forward(request, response);
		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void AfterEdit(HttpServletRequest request, HttpServletResponse response)
	{
		EmployeeFileVO filevo = new EmployeeFileVO();
		filevo.setEfId(Long.valueOf(request.getParameter("fileid")));
		EmployeeFileDAO filedao = new EmployeeFileDAO();
		filevo = (EmployeeFileVO)filedao.readObject(filevo);
		
		filevo.setEfName(request.getParameter("filename"));
		filevo.setEfRemark(request.getParameter("fileremark"));
		filevo.setEfClass(request.getParameter("fileclass"));
		filevo.setEfContent(request.getParameter("filecontent"));
		filevo.setEfExtend(request.getParameter("fileextend"));
		filedao.updateObject(filevo);
		
		try {
			request.getRequestDispatcher("PA_EmployeeFileServlet?opflag=query").forward(request, response);
		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}