zjservlet.java

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

package userservlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Collection;

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

import userbean.Userbean;

import dbmgr.PxlbMgr;

public class ZjServlet extends HttpServlet {

	public ZjServlet() {
		super();
	}
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	
	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")){
		PxlbMgr userdb=new PxlbMgr();
		Collection rst=userdb.getAll();
		request.setAttribute("rss", rst);
		request.getRequestDispatcher("/xrhmudle1mgr/modulmain.jsp").forward(request, response);
       }
	    if(opraParam.equals("show")){
	    	//System.out.println("11111111");
	    	String name=request.getParameter("sqlCondition");
	    	PxlbMgr userdb=new PxlbMgr();
	    	try{
			Collection rst=userdb.query(name);
		
			 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);
				 System.out.println("sssss");
				 request.getRequestDispatcher("/xrhmudle1mgr/modulmain.jsp").forward(request, response);	
	    	}
	    	catch(Exception e)
	    	{
	    		e.printStackTrace();
	    		request.getRequestDispatcher("/xrhmudle1mgr/Err.jsp").forward(request, response);	
	    	}
	    }
	    
	    if(opraParam.equals("add"))
	    {//System.out.println("11111111");
	    	String leibieid=request.getParameter("leibieid");
	    	String pxming=request.getParameter("pxming");
	    	String pxtime=request.getParameter("pxtime");
	    	String lianxirentel=request.getParameter("lianxirentel");
	    	String extra=request.getParameter("extra");
	    	
	    	PxlbMgr userdb=new PxlbMgr();
	    	Userbean user=new Userbean();
	    
	    	user.setLeibieid(Integer.parseInt(leibieid));
	    	user.setPxming(pxming);
	    	user.setPxtime(pxtime);
	    	user.setLianxirentel(lianxirentel);
	    	user.setExtra(extra);
	    	//System.out.println("11111111");
	    	//System.out.println(extra);
	    	int i=userdb.insert(user);
	    	
    	    request.setAttribute("user", user);
    	    Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/xrhmudle1mgr/modulmain.jsp").forward(request, response);	
	    }
	    if(opraParam.equals("change"))
	    {
	    	String leibieid=request.getParameter("leibieid");
	    	String pxming=request.getParameter("pxming");
	    	String pxtime=request.getParameter("pxtime");
	    	String lianxirentel=request.getParameter("lianxirentel");
	    	String extra=request.getParameter("extra");
	    	
	    	PxlbMgr userdb=new PxlbMgr();
	    	Userbean user=new Userbean();
	    	
	    	user.setLeibieid(Integer.parseInt(leibieid));
	    	user.setPxming(pxming);
	    	user.setPxtime(pxtime);
	    	user.setLianxirentel(lianxirentel);
	    	user.setExtra(extra);
	    	int i=userdb.chang(user);
	    	
    	    request.setAttribute("user", user);
    	    Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/xrhmudle1mgr/modulmain.jsp").forward(request, response);	
	    }
	    if(opraParam.equals("delete"))
	    {
	    	PxlbMgr userdb=new PxlbMgr();
	    	Userbean user=new Userbean();
	    	String s=request.getParameter("sqlCondition");
             int leibieid=Integer.parseInt(s);
	    	
	    	//System.out.println(leibieid);
	    	int i=userdb.delete(leibieid);
	    		
	    	Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/xrhmudle1mgr/modulmain.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);
	    	PxlbMgr userdb=new PxlbMgr();
	    	Userbean user=new Userbean();
	    	Collection rst=userdb.getPage(start, size);
    	    System.out.println(st);
    		request.setAttribute("rss", rst);
    		request.setAttribute("stat", st);
    		//int stat;
    	    request.getRequestDispatcher("/xrhmudle1mgr/modulmain.jsp").forward(request, response);	
	    }
		
	}

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

}
	public void init() throws ServletException {
		
	}

}