pa_userinfoservlet.java

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

package com.galaxy.controller;

import java.io.IOException;
import java.io.PrintWriter;
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.base.DaoInterface;
import com.galaxy.dao.DeptInfoDAO;
import com.galaxy.dao.RoleInfoDAO;
import com.galaxy.dao.UserInfoDAO;
import com.galaxy.util.PageHelp;
import com.galaxy.vo.DeptInfoVO;
import com.galaxy.vo.RoleInfoVO;
import com.galaxy.vo.UserInfoVO;
import com.galaxy.upload.*;

public class PA_UserInfoServlet extends HttpServlet 
{

	/**
	 * Constructor of the object.
	 */
	public PA_UserInfoServlet() 
	{
		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");
		
//		SmartUpload su = new SmartUpload();
//		su.initialize(this.getServletConfig(), request, response);
//		if(opflag == null || opflag.equals("") )
//		{
//			opflag = su.getRequest().getParameter("opflag");
//		}
		if(opflag == null)
		{
			opflag = "";
		}
		
		if("query".equals(opflag))
		{			
			Query(request, response);			
		}
		else if("addnew".equals(opflag))
		{
			Addnew(request, response);
		}
		else if("deleteuser".equals(opflag))
		{
			Deleteuser(request, response);
		}
		else if("beforeedit".equals(opflag))
		{
			Beforeedit(request, response);
		}
		else if("afteredit".equals(opflag))
		{
			Afteredit(request, response);
		}		
		else if("creatidcardajax".equals(opflag))
		{
			CheckIdcard(request, response);
		}
		else if("creatpersonajax".equals(opflag))
		{
			CheckPersonID(request, response);
		}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}
	public void Query(HttpServletRequest request, HttpServletResponse response)
	{	
		int pagesize = 5;
		int currentpage = 1;
		UserInfoDAO userdao = new UserInfoDAO();
		String cond=" and u.ui_retirestate is null ";	
		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("sex")!=null && !"".equals(request.getParameter("sex")))
			{
				cond += " and ui_sex like '" + request.getParameter("sex")+ "'";
			}
			if(request.getParameter("duty")!=null && !"".equals(request.getParameter("duty")))
			{
				cond += " and ui_duty like '" + request.getParameter("duty")+ "'";
			}
		}
		pagehelp = userdao.GetList(cond, pagesize, currentpage);
		request.setAttribute("pagehelp", pagehelp);
		request.setAttribute("username",request.getParameter("realname"));
		request.setAttribute("usersex", request.getParameter("sex"));
		request.setAttribute("userduty", request.getParameter("duty"));
		request.setAttribute("departmentid",request.getParameter("depid"));
		try 
		{
			request.getRequestDispatcher("psl_archive\\basical_info\\pa_baseinfo.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 Addnew(HttpServletRequest request, HttpServletResponse response)
	{
		String photofilepath = "";
		
		SmartUpload su = new SmartUpload();
		try {
			su.initialize(this.getServletConfig(), request, response);
			su.setMaxFileSize(10000000L);
			su.setTotalMaxFileSize(100000000L);
			su.setAllowedFilesList("png,PNG,jpg,JPG,bmp,BMP,gif,GIF");
			su.setDeniedFilesList("exe,bat,com,dll,jar,rar,zip,iso");
			
			su.upload();
			su.save("/uploadphotoes/", su.SAVE_VIRTUAL);
			
			SmartFile sf = su.getFiles().getFile(0);
			photofilepath = "uploadphotoes/" + sf.getFileName();
		} catch (ServletException e1) {			
			e1.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
				
		SmartRequest smartRequest = su.getRequest();
		
		DeptInfoVO depvo = new DeptInfoVO();		
		depvo.setDiId(Long.valueOf(smartRequest.getParameter("createdepartment")));
		RoleInfoVO rolevo = new RoleInfoVO();		
		rolevo.setRiId(Long.valueOf(smartRequest.getParameter("createrole")));
		UserInfoVO uservo = new UserInfoVO();
		
		uservo.setDeptInfo(depvo);
		uservo.setRoleInfo(rolevo);
		uservo.setUiRealname(smartRequest.getParameter("createusername"));
		uservo.setUiAge(Long.valueOf(smartRequest.getParameter("createage")));
		uservo.setUiSex(smartRequest.getParameter("createsex"));
		uservo.setUiDuty(smartRequest.getParameter("createduty"));
		uservo.setUiZhiwu(smartRequest.getParameter("createzhiwu"));
		uservo.setIDCardNum(smartRequest.getParameter("createidcard"));		
		uservo.setUiPersonid(Long.valueOf(smartRequest.getParameter("createpersonid")));
		uservo.setUiXueli(smartRequest.getParameter("createxueli"));
		uservo.setUiState(smartRequest.getParameter("createstate"));
		uservo.setUiDegree(smartRequest.getParameter("createdegree"));
		uservo.setUiPhoto(photofilepath);
		uservo.setUiExtend(smartRequest.getParameter("createextend"));
		
		UserInfoDAO userdao = new UserInfoDAO();
		int i = 0;
		i = userdao.addObject(uservo);
		if(i != 0)
		{	
			String cond="";
			List userlist = userdao.queryByCondition(cond);
			request.setAttribute("userlist", userlist);			
			try {
				request.getRequestDispatcher("PA_UserInfoServlet?opflag=query").forward(request, response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		else
		{
			try 
			{
				request.getRequestDispatcher("erropage.jsp").forward(request, response);
			} 
			catch (ServletException e) 
			{				
				e.printStackTrace();
			} 
			catch (IOException e) 
			{
				e.printStackTrace();
			}
		}	
	}
	public void Deleteuser(HttpServletRequest request, HttpServletResponse response)
	{
		String[] todelete = request.getParameterValues("checkbox");
		UserInfoDAO userdao = new UserInfoDAO();
		String cond = "";
		for(int i=0; i < todelete.length; i++)
		{
			cond +="," + todelete[i];
		}
		cond = cond.substring(1);
		userdao.deleteObject(cond);
		try 
		{
			request.getRequestDispatcher("PA_UserInfoServlet?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 Beforeedit(HttpServletRequest request, HttpServletResponse response)
	{
		String[] edituser = request.getParameterValues("checkbox");
		UserInfoVO uservo = new UserInfoVO();
		UserInfoDAO userdao = new UserInfoDAO();
		uservo.setUiId(Long.valueOf(edituser[0]));		
		uservo = (UserInfoVO)userdao.readObject(uservo);
		request.setAttribute("uservo", uservo);		
		try {
			request.getRequestDispatcher("psl_archive\\basical_info\\pa_changeinfo.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)
	{
		String photofilepath = "";
		
		SmartUpload su = new SmartUpload();
		try {
			su.initialize(this.getServletConfig(), request, response);
			su.setMaxFileSize(10000000L);
			su.setTotalMaxFileSize(100000000L);
			su.setAllowedFilesList("png,PNG,jpg,JPG,bmp,BMP,gif,GIF");
			su.setDeniedFilesList("exe,bat,com,dll,jar,rar,zip,iso");
			
			su.upload();
			su.save("/uploadphotoes/", su.SAVE_VIRTUAL);
			
			SmartFile sf = su.getFiles().getFile(0);
			photofilepath = "uploadphotoes/" + sf.getFileName();
			
		} catch (ServletException e1) {			
			e1.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
				
		SmartRequest smartRequest = su.getRequest();
		
		
		DeptInfoVO depvo = new DeptInfoVO();		
		depvo.setDiId(Long.valueOf(smartRequest.getParameter("editdepartment")));
		RoleInfoVO rolevo = new RoleInfoVO();		
		rolevo.setRiId(Long.valueOf(smartRequest.getParameter("editrole")));
		UserInfoVO uservo = new UserInfoVO();
		uservo.setUiId(Long.valueOf(smartRequest.getParameter("userid")));
		UserInfoDAO userdao = new UserInfoDAO();
		uservo = (UserInfoVO)userdao.readObject(uservo);
		uservo.setDeptInfo(depvo);
		uservo.setRoleInfo(rolevo);
		uservo.setUiRealname(smartRequest.getParameter("editusername"));
		uservo.setUiAge(Long.valueOf(smartRequest.getParameter("editage")));
		uservo.setUiSex(smartRequest.getParameter("editsex"));
		uservo.setUiDuty(smartRequest.getParameter("editduty"));
		uservo.setUiZhiwu(smartRequest.getParameter("editzhiwu"));		
		uservo.setIDCardNum(smartRequest.getParameter("editidcard"));		
		uservo.setUiPersonid(Long.valueOf(smartRequest.getParameter("editpersonid")));
		uservo.setUiXueli(smartRequest.getParameter("editxueli"));
		uservo.setUiState(smartRequest.getParameter("editstate"));
		uservo.setUiDegree(smartRequest.getParameter("editdegree"));
		String photoname = photofilepath.substring(14);
		if(photoname != null && !"".equals(photoname))
		{
			uservo.setUiPhoto(photofilepath);
		}
		uservo.setUiExtend(smartRequest.getParameter("editextend"));
		
		userdao.updateObject(uservo);
		try {
			request.getRequestDispatcher("PA_UserInfoServlet?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 CheckIdcard(HttpServletRequest request, HttpServletResponse response)
	{
		String rspResult = "0";
		
		String idcardNum = request.getParameter("idcardNum");
		UserInfoDAO userdao = new UserInfoDAO();
		
		if(idcardNum != null && !idcardNum.equals("") )
		{
			String cond = " and u.ui_idcardnum='" + idcardNum + "'";
			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 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=" + Long.valueOf(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();
		}
	}
}