yanservlet.java

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

package userservlet;

import java.io.IOException;
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.Starff;
import dbmgr.CsMgr;

public class YanServlet extends HttpServlet {
	public YanServlet() {
		super();
	}
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		 doPost(request, response);
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html");
		request.setCharacterEncoding("gb2312");
        response.setCharacterEncoding("gb2312");
		response.setContentType("text/html;charset=gb2312");
		String opraParam= request.getParameter("opraParam");
	    if(opraParam.equals("showall")){
		CsMgr qqdb=new CsMgr();
		Collection rst=qqdb.getAll();
		request.setAttribute("rss", rst);
		request.getRequestDispatcher("/mokuaifmgr/maofield.jsp").forward(request, response);
       }
	    if(opraParam.equals("show")){
	    	String name=request.getParameter("sqlCondition");
	    	CsMgr qqdb=new CsMgr();
	    	try{
			Collection rst=qqdb.search(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);
			request.getRequestDispatcher("/mokuaifmgr/maofield.jsp").forward(request, response);	
	    	}
	    	catch(Exception e)
	    	{
	    		e.printStackTrace();
	    		request.getRequestDispatcher("/mokuaifmgr/Err.jsp").forward(request, response);	
	    	}
	    }
	    
	    
	    if(opraParam.equals("add"))
	    {  
	    	String pxid=request.getParameter("pxid");
	    	String leibieid=request.getParameter("leibieid");
	    	String certiname=request.getParameter("certiname");
	    	String certinum=request.getParameter("certinum");
	    	String certidate=request.getParameter("certidate");
	    	
	    	    CsMgr qqdb=new CsMgr();
	    		Starff starff=new Starff();
	    		
	    		starff.setPxid(Integer.parseInt(pxid));
	    		starff.setLeibieid(Integer.parseInt(leibieid));
	    		starff.setCertiname(certiname);
	    		starff.setCertinum(certinum);
	    		starff.setCertidate(certidate);
	    	    int i=qqdb.insert(starff);
	    	    
	    	    request.setAttribute("starff", starff);
	    	    Collection rst=qqdb.getAll();
	    		request.setAttribute("rss", rst);
	    	    request.getRequestDispatcher("/mokuaifmgr/maofield.jsp").forward(request, response);	
	    }
	    
	    if(opraParam.equals("change"))
	    {  
	    	  // System.out.println("ggy");
	    	   String pxid=request.getParameter("pxid");
	    	  String leibieid=request.getParameter("leibieid");
	    	   String certiname=request.getParameter("certiname");
	    	   String certinum=request.getParameter("certinum");
	    	   String certidate=request.getParameter("certidate");
	    	
	    	   CsMgr qqdb=new CsMgr();
	    	   Starff starff=new Starff();
	    		
	    	   starff.setPxid(Integer.parseInt(pxid));
	    	   starff.setLeibieid(Integer.parseInt(leibieid));
	    	   starff.setCertiname(certiname);
	    	   starff.setCertinum(certinum);
	    	   starff.setCertidate(certidate);
	    	    int i=qqdb.chang(starff);
	    	   
    	    
    	    request.setAttribute("starff", starff);
    	    Collection rst=qqdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/mokuaifmgr/maofield.jsp").forward(request, response);	
	    }
	    
	    
	    if(opraParam.equals("delete"))
	    {
	    	 CsMgr qqdb=new  CsMgr();
    	    Starff starff=new Starff();
    		String s=request.getParameter("sqlCondition");
    	    //System.out.println(s);
	    	int pxid=Integer.parseInt(s);
	    	
	     	//System.out.println(pxid);
	    	int i=qqdb.delete(pxid);
	    		
	    	Collection rst=qqdb.getAll();
    		request.setAttribute("rss", rst);
    		//System.out.println("ssssss");
    		request.getRequestDispatcher("/mokuaifmgr/maofield.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);
	    	 CsMgr qqdb=new  CsMgr();
    	    Collection rst=qqdb.getPage(start, size);
    	   // System.out.println(st);
    	    request.setAttribute("rss", rst);
	           request.setAttribute("stat", st);
    		//int stat;
    	    request.getRequestDispatcher("/mokuaifmgr/maofield.jsp").forward(request, response);	
	    }
		
	}

	
	public void init() throws ServletException {
		// Put your code here
	}
}