sm_userinfoservlet.java

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

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.UserInfoDAO;
import com.galaxy.util.PageHelp;
import com.galaxy.vo.UserInfoVO;

public class SM_UserInfoServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public SM_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 {

		response.setContentType("text/html");
		response.setCharacterEncoding("gb2312");
		request.setCharacterEncoding("gb2312");
		String opflag = request.getParameter("opflag");
		if("init".equals(opflag)){
			showlist(request,response);
		}
		else if("qurey".equals(opflag)){
			qureyusers(request,response);
		}
		else if("noname".equals(opflag)){//查询没有登陆名和密码的员工
			noname(request,response);
		}
		else if("add".equals(opflag)){
			adduser(request,response);
		}
		else if("del".equals(opflag)){
			deluser(request,response);
		}
		else if("edit".equals(opflag)){
			edituser(request,response);
		}
		
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}
	
	private void showlist(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		int pageSize = 5;
		int currentPage=1;//当前显示的页面号
		if(request.getParameter("currentPage")!=null&&!"".equals(request.getParameter("currentPage"))){
			currentPage=Integer.parseInt(request.getParameter("currentPage"));
		}
		PageHelp pagehelp=new PageHelp();
		UserInfoDAO userinfodao = new UserInfoDAO();
		String cond = "and u.ui_loadname != 'null'";
		if(request.getParameter("cond")!=null && !"".equals(request.getParameter("cond")))
		{
			cond=request.getParameter("cond");	
		}
			String username = request.getParameter("username");
			String deptid = request.getParameter("depid");
			String roleid = request.getParameter("roleid");
			if(username != null &&  deptid != null && "0".equals(deptid) && roleid != null && !"0".equals(roleid)){
				cond = "and u.ui_loadname like '%" +username+"%'and ri_id="+roleid;
			}else if(username != null && deptid != null && !"0".equals(deptid) && roleid != null && "0".equals(roleid)){
				cond = "and u.ui_loadname like '%" +username+"%' and u.di_id="+deptid;
			}else if(username != null && deptid != null && "0".equals(deptid) && roleid != null && "0".equals(roleid)){
				cond = "and u.ui_loadname like '%" +username+"%' ";
			}else if(username != null && deptid != null && !"0".equals(deptid) && roleid != null && !"0".equals(roleid)){
				cond = "and u.ui_loadname like '%" +username+"%' and u.di_id="+deptid+" and ri_id="+roleid;
			}

			
		
		pagehelp=userinfodao.GetList2(cond, pageSize, currentPage);
		request.setAttribute("pagehelp",pagehelp);
		request.getRequestDispatcher("sys_manage\\sys_useradmin_delete.jsp").forward(request, response);
	}

	private void qureyusers(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		String username = request.getParameter("username");
		Long deptid = Long.parseLong(request.getParameter("depid"));
		Long roleid = Long.parseLong(request.getParameter("roleid"));

		String sql = "";
		if(deptid == 0 && roleid != 0){
		sql = "and ui_loadname like '%" +username+"%'and ri_id ="+roleid+"order by ui_id";
		}else if(deptid != 0 && roleid == 0){
			sql = "and ui_loadname like '%" +username+"%' and u.di_id ="+deptid+"order by ui_id";
		}else if(deptid == 0 && roleid == 0){
			sql = "and ui_loadname like '%" +username+"%' order by ui_id";
		}else if(deptid != 0 && roleid != 0){
			sql = "and ui_loadname like '%" +username+"%' and u.di_id ="+deptid+" and ri_id ="+roleid+"order by ui_id";
		}
		UserInfoDAO userinfodao = new UserInfoDAO();
		List users = new ArrayList();
		users = (ArrayList)userinfodao.queryByCondition(sql);
		
		request.setAttribute("users", users);
		request.getRequestDispatcher("sys_manage\\sys_useradmin_delete.jsp").forward(request, response);
	}
	
	private void noname(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		List users = new ArrayList();
		UserInfoDAO userinfodao = new UserInfoDAO();
		users = userinfodao.queryByCondition("and ui_loadname is null");
		request.setAttribute("users", users);
		request.getRequestDispatcher("sys_manage\\sys_useradmin_add.jsp").forward(request, response);
	}
	
	private void adduser(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
	{
		List users = new ArrayList();
		users = (ArrayList)request.getSession().getAttribute("users");
		UserInfoDAO userinfodao = new UserInfoDAO();
		int result = 0;
		for(int i = 0; i < users.size(); i++)
		{
			UserInfoVO userinfovo = new UserInfoVO();
			userinfovo = (UserInfoVO)users.get(i);
			if("".equals(request.getParameter(userinfovo.getUiRealname()+"loadname")) || "".equals(request.getParameter(userinfovo.getUiRealname()+"psw")))
					continue;
					
			userinfovo.setUiLoadname(request.getParameter(userinfovo.getUiRealname()+"loadname"));
			userinfovo.setUiPassword(request.getParameter(userinfovo.getUiRealname()+"psw"));
			userinfovo.getRoleInfo().setRiId(Long.parseLong(request.getParameter(userinfovo.getUiRealname()+"role")));
			result += userinfodao.updateObject(userinfovo);
		}
		
		if(result != 0)
			request.getRequestDispatcher("SM_UserInfoServlet?opflag=init").forward(request, response);
		else
			request.getRequestDispatcher("erropage.jsp").forward(request, response);
	}
	
	private void deluser(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
	{
		String users[] = request.getParameterValues("checkbox");
		UserInfoDAO userinfodao = new UserInfoDAO();
		UserInfoVO userinfovo = new UserInfoVO();
		String cond = "";
		for(int i = 0; i < users.length; i++)
		{
			userinfovo.setUiId(Long.parseLong(users[i]));
			userinfovo = (UserInfoVO)userinfodao.readObject(userinfovo);
			userinfovo.setUiLoadname("");
			userinfovo.setUiPassword("");
			userinfodao.updateObject(userinfovo);
		}	
		request.getRequestDispatcher("SM_UserInfoServlet?opflag=init").forward(request, response);
	}
	
	private void edituser(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
	{
		Long userid = Long.parseLong(request.getParameter("userid"));
		Long userroleid = Long.parseLong(request.getParameter("userrole"));
		UserInfoVO userinfovo = new UserInfoVO();
		UserInfoDAO userinfodao = new UserInfoDAO();
		userinfovo.setUiId(userid);
		userinfovo = (UserInfoVO)userinfodao.readObject(userinfovo);
		userinfovo.getRoleInfo().setRiId(userroleid);
		int i = 0;
		i = userinfodao.updateObject(userinfovo);
		if(i != 0)
			request.getRequestDispatcher("SM_UserInfoServlet?opflag=init").forward(request, response);
		else
			request.getRequestDispatcher("erropage.jsp").forward(request, response);
	}
}