cuserservlet.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.Cuser;
import dbmgr.CuserMgr;
import java.sql.ResultSet;
import java.util.*;


public class CuserServlet extends HttpServlet {

	public CuserServlet() {
		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");
       	 System.out.println("222222222"+opraParam);
         if(opraParam.equals("show")){
        
			String pxid=request.getParameter("sqlCondition");
	    	CuserMgr userdb=new CuserMgr();
			try{
	    	Collection rst=userdb.search(pxid);
		    		   
			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("/cusermgr/list.jsp").forward(request, response);	
			}
			catch(Exception e)
			{
				e.printStackTrace();
				request.getRequestDispatcher("/cusermgr/Err.jsp").forward(request, response);	
			}
	  }
	    
	    if(opraParam.equals("add"))
	    {
	    	String pxid=request.getParameter("pxid");
	    	String xyname=request.getParameter("xyname");
	    	String cxypx=request.getParameter("cxypx");
	    	String wysj=request.getParameter("wysj");
	    	String cad=request.getParameter("cad");
	    	String english=request.getParameter("english");
	    	String cjj=request.getParameter("cjj");
	    	String ruanshe=request.getParameter("ruanshe");
	    	
	    		CuserMgr userdb=new CuserMgr();
	    	    Cuser user=new Cuser();
	    	    user.setPxid(Integer.parseInt(pxid));
	    	    user.setXyname(xyname);
	    	    user.setCxypx(Integer.parseInt(cxypx));
	    	    user.setWysj(Integer.parseInt(wysj));
	    	    user.setCad(Integer.parseInt(cad));
	    	    user.setEnglish(Integer.parseInt(english));
	    	    user.setCjj(Integer.parseInt(cjj));
	    	    user.setRuanshe(Integer.parseInt(ruanshe));
	    	 	
	    	    int i=userdb.add(user);
	    	    request.setAttribute("user", user);
	    	    Collection rst=userdb.getAll();
	    		request.setAttribute("rss", rst);
	    	    request.getRequestDispatcher("/cusermgr/list.jsp").forward(request, response);	
	    }
	    
	    if(opraParam.equals("change"))
	    {  
	    	String pxid=request.getParameter("pxid");
	    	String xyname=request.getParameter("xyname");
	    	String cxypx=request.getParameter("cxypx");
	    	String wysj=request.getParameter("wysj");
	    	String cad=request.getParameter("cad");
	    	String english=request.getParameter("english");
	    	String cjj=request.getParameter("cjj");
	    	String ruanshe=request.getParameter("ruanshe");
	    	 
	    	CuserMgr userdb=new CuserMgr();
    	    Cuser user=new Cuser();
    	    user.setPxid(Integer.parseInt(pxid));
    	    user.setXyname(xyname);
    	    user.setCxypx(Integer.parseInt(cxypx));
    	    user.setWysj(Integer.parseInt(wysj));
    	    user.setCad(Integer.parseInt(cad));
    	    user.setEnglish(Integer.parseInt(english));
    	    user.setCjj(Integer.parseInt(cjj));
    	    user.setRuanshe(Integer.parseInt(ruanshe));
    	    
    	    int i=userdb.chang(user);
        	request.setAttribute("user", user);
    	    Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/cusermgr/list.jsp").forward(request, response);	
	    }
	    
	    if(opraParam.equals("delete"))
	    {
	    	CuserMgr userdb=new CuserMgr();
    	    Cuser user=new Cuser();
    		String s=request.getParameter("sqlCondition");
    	    //System.out.println(s);
	    	int pxid=Integer.parseInt(s);
	    	
	    	System.out.println(pxid);
	    	int i=userdb.delete(pxid);
	    		
	    	Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/cusermgr/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);
	    	
	    	CuserMgr userdb=new CuserMgr();
    	    Cuser user=new Cuser();
    	    Collection rst=userdb.getPage(start, size);
    	    System.out.println(st);
    		request.setAttribute("rss", rst);
    		request.setAttribute("stat", st);
    		//int stat;
    	    request.getRequestDispatcher("/cusermgr/list.jsp").forward(request, response);	
	    }
}

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

}