wzhservlet.java

采用Jsp,Javabean,Servlet等做的人力资源管理系统,后台管理用户及密码均是:admin

package userservlet;

import java.io.IOException;
import java.io.PrintWriter;

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

import userbean.Wzh_User;
import dbmgr.Wzh_UserMgr;
import java.util.*;

public class WzhServlet extends HttpServlet {

	public WzhServlet() {
		super();
	}

	public void destroy() {
		super.destroy(); 
	}

	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		response.setCharacterEncoding("gb2312");
		response.setContentType("text/html;charset=gb2312");
		String opraParam= request.getParameter("opraParam");
		
	if(opraParam.equals("showall")){
		Wzh_UserMgr userdb=new Wzh_UserMgr();
		Collection rst=userdb.getAll();
		request.setAttribute("rss", rst);
		request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);
		}
	if(opraParam.equals("show")){
			String sqlCondition=request.getParameter("sqlCondition");
			System.out.println(sqlCondition);
			Wzh_UserMgr userdb=new Wzh_UserMgr();
			Collection rst=userdb.search(sqlCondition);

			  if(rst.isEmpty())
					request.setAttribute("sch", "1");
					//request.getRequestDispatcher("/lcz_usermgr/error.jsp?styl=search").forward(request, response);		
				else
					{
					request.setAttribute("sch", "2");
					 }
				 request.setAttribute("rss", rst);
				 request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);
		}

		if(opraParam.equals("add"))
		{
			String userid=request.getParameter("userid");
			String loadname=request.getParameter("loadname");
			String password=request.getParameter("password");
			String username=request.getParameter("username");
			String phone=request.getParameter("phone");
			String role=request.getParameter("role");
			int dsize=0;
				Wzh_UserMgr userdb=new Wzh_UserMgr();
			    Wzh_User user=new Wzh_User();
			    user.setUserid(Integer.parseInt(userid));
			    user.setLoadname(loadname);
			    user.setPassword(password);
			    user.setUsername(username);
			    user.setPhone(phone);
			    user.setRole(role);
			    int i=userdb.add(user);
			    //System.out.println("1111111111");
			    //System.out.println(i);
			    request.setAttribute("user", user);
			    Collection rst=userdb.getAll();
				request.setAttribute("rss", rst);
			    request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);	
		}

		if(opraParam.equals("change"))
		{  System.out.println("33333333");
			String userid=request.getParameter("userid");
			String loadname=request.getParameter("loadname");
			String password=request.getParameter("password");
			String username=request.getParameter("username");
			String phone=request.getParameter("phone");
			String role=request.getParameter("role");
			
			System.out.println(userid+","+loadname+","+password+","+username+","+phone+","+role);
			
			Wzh_UserMgr userdb=new Wzh_UserMgr();
		    Wzh_User user=new Wzh_User();
		    user.setUserid(Integer.parseInt(userid));
		    user.setLoadname(loadname);
		    user.setPassword(password);
		    user.setUsername(username);
		    user.setPhone(phone);
		    user.setRole(role);
		    int i=userdb.chang(user);
			   
		    request.setAttribute("user", user);
		    Collection rst=userdb.getAll();
			request.setAttribute("rss", rst);
		    request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);	
		}

		if(opraParam.equals("delete"))
		{
			Wzh_UserMgr userdb=new Wzh_UserMgr();
		    Wzh_User user=new Wzh_User();
			String s=request.getParameter("sqlCondition");
		    //System.out.println(s);
			int did=Integer.parseInt(s);
			
			System.out.println(did);
			int i=userdb.delete(did);
				
			Collection rst=userdb.getAll();
			request.setAttribute("rss", rst);
		    request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);	
		}  

		if(opraParam.equals("page"))
		{
			String st=request.getParameter("chpage");
			int size=Integer.parseInt(request.getParameter("size"));
			
			int start=Integer.parseInt(st);
			
			Wzh_UserMgr userdb=new Wzh_UserMgr();
		    Wzh_User user=new Wzh_User();
		    Collection rst=userdb.getPage(start, size);
		    System.out.println(st);
			request.setAttribute("rss", rst);
			request.setAttribute("stat", st);
			//int stat;
		    request.getRequestDispatcher("/wzh_usermgr/list.jsp").forward(request, response);	
		}
		
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		doPost(request, response);

}

	public void init() throws ServletException {
		
	}

}