lczservlet.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.Lcz_User;
import dbmgr.Lcz_UserMgr;
import java.util.*;

public class LczServlet extends HttpServlet {

	public LczServlet() {
		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")){
		Lcz_UserMgr userdb=new Lcz_UserMgr();
		Collection rst=userdb.getAll();
		request.setAttribute("rss", rst);
		request.getRequestDispatcher("/lcz_usermgr/list.jsp").forward(request, response);
		}
	if(opraParam.equals("show")){
			String sqlCondition=request.getParameter("sqlCondition");
			System.out.println(sqlCondition);
			Lcz_UserMgr userdb=new Lcz_UserMgr();
			try{
			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("/lcz_usermgr/list.jsp").forward(request, response);
			}
			catch(Exception e)
			{
				e.printStackTrace();
				request.getRequestDispatcher("/lcz_usermgr/Err.jsp").forward(request, response);
			}
	}

		if(opraParam.equals("add"))
		{
			String did=request.getParameter("did");
			String dname=request.getParameter("dname");
			String dmanager=request.getParameter("dmanager");
			String subjection=request.getParameter("subjection");
			String dphone=request.getParameter("dphone");
			int dsize=0;
				Lcz_UserMgr userdb=new Lcz_UserMgr();
			    Lcz_User user=new Lcz_User();
			    user.setDid(Integer.parseInt(did));
			    user.setDname(dname);
			    user.setDmanager(dmanager);
			    user.setSubjection(subjection);
			    user.setDsize(dsize);
			    user.setDphone(dphone);
			    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("/lcz_usermgr/list.jsp").forward(request, response);	
		}

		if(opraParam.equals("change"))
		{  
			String did=request.getParameter("did");
			String dname=request.getParameter("dname");
			String dmanager=request.getParameter("dmanager");
			String subjection=request.getParameter("subjection");
			String dsize=request.getParameter("dsize");
			String dphone=request.getParameter("dphone");
			
			System.out.println(did+","+dname+","+dmanager+","+subjection+","+dsize+","+dphone);
			
			Lcz_UserMgr userdb=new Lcz_UserMgr();
		    Lcz_User user=new Lcz_User();
		    user.setDid(Integer.parseInt(did));
		    user.setDname(dname);
		    user.setDmanager(dmanager);
		    user.setSubjection(subjection);
		    user.setDsize(Integer.parseInt(dsize));
		    user.setDphone(dphone);
		    int i=userdb.chang(user);
			   
		    request.setAttribute("user", user);
		    Collection rst=userdb.getAll();
			request.setAttribute("rss", rst);
		    request.getRequestDispatcher("/lcz_usermgr/list.jsp").forward(request, response);	
		}

		if(opraParam.equals("delete"))
		{
			Lcz_UserMgr userdb=new Lcz_UserMgr();
		    Lcz_User user=new Lcz_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("/lcz_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);
			
			Lcz_UserMgr userdb=new Lcz_UserMgr();
		    Lcz_User user=new Lcz_User();
		    Collection rst=userdb.getPage(start, size);
		    System.out.println(st);
			request.setAttribute("rss", rst);
			request.setAttribute("stat", st);
			//int stat;
		    request.getRequestDispatcher("/lcz_usermgr/list.jsp").forward(request, response);	
		}
		
	}

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

}

	public void init() throws ServletException {
		
	}

}