tnoteservlet.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.Tnote;
import dbmgr.TnoteMgr;

public class TnoteServlet extends HttpServlet {
	public TnoteServlet() {
		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")){
		TnoteMgr userdb=new TnoteMgr();
		Collection rst=userdb.getAll();
		request.setAttribute("rss", rst);
		request.getRequestDispatcher("/mokuai3mgr/chaxun.jsp").forward(request, response);
       }
	    if(opraParam.equals("show")){
	    	String name1=request.getParameter("sqlCondition");
	        TnoteMgr userdb=new TnoteMgr();
	        try{
			Collection rst=userdb.query(name1);

			 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("/mokuai3mgr/modu3main.jsp").forward(request, response);	
	        }
	        catch(Exception e)
	        {
	        	e.printStackTrace();
	        	request.getRequestDispatcher("/mokuai3mgr/Err.jsp").forward(request, response);	
	        }
     }
	    
	    if(opraParam.equals("add"))
	    {
	    	String pxid=request.getParameter("pxid");
	    	String tname=request.getParameter("tname");
	    	String leibieid=request.getParameter("leibieid");
	    	String dept=request.getParameter("dept");
	    	String starttime=request.getParameter("starttime");
	    	String endtime=request.getParameter("endtime");
	    	String traincm=request.getParameter("traincm");
	    	String tgrade=request.getParameter("tgrade");
	    	String torgan=request.getParameter("torgan");
	    	String keshi=request.getParameter("keshi");
	    	String isover=request.getParameter("isover");
	    	String beizhu=request.getParameter("beizhu");
	    	System.out.println("333");
	    	
	    	   TnoteMgr userdb=new TnoteMgr();
	    		Tnote tnote=new Tnote();
	    		tnote.setPxid(Integer.parseInt(pxid));
				tnote.setTname(tname);
				tnote.setLeibieid(Integer.parseInt(leibieid));
				tnote.setDept(dept);
				tnote.setStarttime(starttime);
				tnote.setEndtime(endtime);
				tnote.setTraincm(traincm);
				tnote.setTgrade(Integer.parseInt(tgrade));
				tnote.setTorgan(torgan);
				tnote.setKeshi(Integer.parseInt(keshi));
				tnote.setIsover(isover);
				tnote.setBeizhu(beizhu);
	    	    int i=userdb.add(tnote);
	    	    
	    	    request.setAttribute("tnote", tnote);
	    	    Collection rst=userdb.getAll();
	    		request.setAttribute("rss", rst);
	    	    request.getRequestDispatcher("/mokuai3mgr/modu3main.jsp").forward(request, response);	
	    }
	    
	    if(opraParam.equals("change"))
	    {  
	    	String pxid=request.getParameter("pxid");
	    	String tname=request.getParameter("tname");
	    	String leibieid=request.getParameter("leibieid");
	    	String dept=request.getParameter("dept");
	    	String starttime=request.getParameter("starttime");
	    	String endtime=request.getParameter("endtime");
	    	String traincm=request.getParameter("traincm");
	    	String tgrade=request.getParameter("tgrade");
	    	String torgan=request.getParameter("torgan");
	    	String keshi=request.getParameter("keshi");
	    	String isover=request.getParameter("isover");
	    	String beizhu=request.getParameter("beizhu");
	    	 
	    	TnoteMgr userdb=new TnoteMgr();
    	    Tnote tnote=new Tnote();
    	    tnote.setPxid(Integer.parseInt(pxid));
			tnote.setTname(tname);
			tnote.setLeibieid(Integer.parseInt(leibieid));
			tnote.setDept(dept);
			tnote.setStarttime(starttime);
			tnote.setEndtime(endtime);
			tnote.setTraincm(traincm);
			tnote.setTgrade(Integer.parseInt(tgrade));
			tnote.setTorgan(torgan);
			tnote.setKeshi(Integer.parseInt(keshi));
			tnote.setIsover(isover);
			tnote.setBeizhu(beizhu);
    	    int i=userdb.chang(tnote);
      	  // System.out.println(i);
    	    
    	    request.setAttribute("tnote", tnote);
    	    Collection rst=userdb.getAll();
    		request.setAttribute("rss", rst);
    	    request.getRequestDispatcher("/mokuai3mgr/modu3main.jsp").forward(request, response);	
	    }
	    
	    
	    if(opraParam.equals("delete"))
	    {
	    	 TnoteMgr userdb=new  TnoteMgr();
    	    Tnote user=new Tnote();
    		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);
    		//System.out.println("ssssss");
    		request.getRequestDispatcher("/mokuai3mgr/modu3main.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);
	    	
	    	TnoteMgr userdb=new TnoteMgr();
    	    //Tnote tnote=new Tnote();
    	    Collection rst=userdb.getPage(start, size);
    	    System.out.println(st);
    		request.setAttribute("rss", rst);
    		request.setAttribute("stat", st);
    		//int stat;
    	    request.getRequestDispatcher("/mokuai3mgr/modu3main.jsp").forward(request, response);	
	    }
		
	}

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

}