tsseverlet.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.Pxjh;
import dbmgr.TsMgr;
	public class TsSeverlet extends HttpServlet {

		public TsSeverlet() {
			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")){
           TsMgr pxjhdb=new TsMgr();
           Collection rst=pxjhdb.getAll();
           request.setAttribute("rss", rst);
           request.getRequestDispatcher("/mokuai2mgr/show.jsp").forward(request, response);
             }
        if(opraParam.equals("show")){
	          String name=request.getParameter("sqlCondition");
	           TsMgr pxjhdb=new TsMgr();
	           Collection rst=pxjhdb.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("/mokuai2mgr/modulmain.jsp").forward(request, response);	
        }

      if(opraParam.equals("add"))
        { System.out.println("322");
	      String leibieid=request.getParameter("leibieid");
	      String psort=request.getParameter("psort");
	      String tcharge=request.getParameter("tcharge");
	      String traincm=request.getParameter("traincm");
	      String tdate=request.getParameter("tdate");
	      String tadress=request.getParameter("tadress");
	      String torgan=request.getParameter("torgan");
	      String fulu=request.getParameter("fulu");
	      

  		TsMgr pxjhdb=new TsMgr();
  	    Pxjh pxjh=new Pxjh();
  	       pxjh.setLeibieid(Integer.parseInt(leibieid));
	       pxjh.setPsort(psort);
	       pxjh.setTraincm(traincm);
	       pxjh.setTcharge(tcharge);
	       pxjh.setTdate(tdate);
	       pxjh.setTadress(tadress);
	       pxjh.setTorgan(torgan);
	       pxjh.setFulu(fulu);
	      int i=pxjhdb.insert(pxjh);
	      
	      request.setAttribute("user",pxjh);
	      Collection rst=pxjhdb.getAll();
		  request.setAttribute("rss", rst);
	      request.getRequestDispatcher("mokuai2mgr/modulmain.jsp").forward(request, response);	
        }

         if(opraParam.equals("change"))
          { 
          String leibieid=request.getParameter("leibieid");
   	      String psort=request.getParameter("psort");
   	      String tcharge=request.getParameter("tcharge");
   	      String tdate=request.getParameter("tdate");
   	      String tadress=request.getParameter("tadress");
   	      String traincm=request.getParameter("traincm");
   	      String torgan=request.getParameter("torgan");
   	      String fulu=request.getParameter("fulu");
   	      
   	       TsMgr pxjhdb=new TsMgr();
   	       Pxjh pxjh=new Pxjh();
   	       pxjh.setLeibieid(Integer.parseInt(leibieid));
   	       pxjh.setPsort(psort);
   	       pxjh.setTcharge(tcharge);
   	       pxjh.setTdate(tdate);
   	       pxjh.setTadress(tadress);
   	       pxjh.setTraincm(traincm);
   	       pxjh.setTorgan(torgan);
   	       pxjh.setFulu(fulu);
           int i=pxjhdb.chang(pxjh);
	   
           request.setAttribute("pxjh", pxjh);
           Collection rst=pxjhdb.getAll();
	       request.setAttribute("rss", rst);
           request.getRequestDispatcher("/mokuai2mgr/modulmain.jsp").forward(request, response);	
             }

          if(opraParam.equals("delete"))
            {
	           TsMgr pxjhdb=new TsMgr();
	         
			Pxjh pxjh=new Pxjh();
			String s=request.getParameter("sqlCondition");;
               //System.out.println(s);
			int leibieid=Integer.parseInt(s);
	
	            System.out.println(leibieid);
	           int i=pxjhdb.delete(leibieid);
		
           	Collection rst=pxjhdb.getAll();
	        request.setAttribute("rss", rst);
            request.getRequestDispatcher("/mokuai2mgr/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);
	            TsMgr pxjhdb=new TsMgr();
               Pxjh pxjh=new Pxjh();
               Collection rst=pxjhdb.getPage(start, size);
               System.out.println(st);
	           request.setAttribute("rss", rst);
	           request.setAttribute("stat", st);
	         //int stat;
              request.getRequestDispatcher("/mokuai2mgr/modulmain.jsp").forward(request, response);	
               }
         }

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

}