w1userservlet.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.w1User;
import dbmgr.w1UserMgr;
import java.sql.ResultSet;
import java.util.*;

public class w1UserServlet extends HttpServlet {


	public w1UserServlet() {
		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")){
w1UserMgr userdb=new w1UserMgr();
Collection rst=userdb.getAll();
request.setAttribute("rss", rst);
request.getRequestDispatcher("/w1usermgr/show.jsp").forward(request, response);
}
if(opraParam.equals("show")){
	String name=request.getParameter("sqlCondition");
	w1UserMgr userdb=new w1UserMgr();
	Collection rst=userdb.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("/w1usermgr/list.jsp").forward(request, response);
}

if(opraParam.equals("add"))
{
	String userid=request.getParameter("userid");
	String empname=request.getParameter("empname");
	String department=request.getParameter("department");
	String duty=request.getParameter("duty");
	String schoolage=request.getParameter("schoolage");
	String sex=request.getParameter("sex");
	String remark=request.getParameter("remark");
	String degree=request.getParameter("degree");
	String nation=request.getParameter("nation");
	String marriage=request.getParameter("marriage");
	String incumbency=request.getParameter("incumbency");
	String speciality=request.getParameter("speciality");
	String gratime=request.getParameter("gratime");
	String graschool=request.getParameter("graschool");
	String idcard=request.getParameter("idcard");
	String natinveplace=request.getParameter("natinveplace");
	String mobile=request.getParameter("mobile");
	String hometel=request.getParameter("hometel");
	String emptime=request.getParameter("emptime");
	String empplace=request.getParameter("empplace");
	String payaccount=request.getParameter("payaccount");
	String homeaddress=request.getParameter("homeaddress");

	    w1UserMgr userdb=new w1UserMgr();
	    w1User user=new w1User();
	    user.setUserid(Integer.parseInt(userid));
	    user.setEmpname(empname);
	    user.setDepartment(department);
		user.setDuty(duty);
		user.setSchoolage(schoolage);
		user.setSex(sex);
		user.setNation(nation);
		user.setDegree(degree);
		user.setMarriage(marriage);
		user.setIncumbency(incumbency);
		user.setSpeciality(speciality);
	    user.setGratime(gratime);
		user.setGraschool(graschool);
		user.setIdcard(idcard);
		user.setNatinveplace(natinveplace);
		user.setMobile(Integer.parseInt(mobile));
		user.setHometel(Integer.parseInt(hometel));
		user.setEmptime(emptime);
		user.setEmpplace(empplace);
		user.setPayaccount(Integer.parseInt(payaccount));
		user.setHomeaddress(homeaddress);
		user.setRemark(remark);

	    int i=userdb.add(user);
	    request.setAttribute("user", user);
	    Collection rst=userdb.getAll();
		request.setAttribute("rss", rst);
	    request.getRequestDispatcher("/w1usermgr/list.jsp").forward(request, response);	
}

if(opraParam.equals("change"))
{  
	String userid=request.getParameter("userid");
	String empname=request.getParameter("empname");
	String department=request.getParameter("department");
	String duty=request.getParameter("duty");
	String schoolage=request.getParameter("schoolage");
	String sex=request.getParameter("sex");
	String remark=request.getParameter("remark");
	String degree=request.getParameter("degree");
	String nation=request.getParameter("nation");
	String marriage=request.getParameter("marriage");
	String incumbency=request.getParameter("incumbency");
	String speciality=request.getParameter("speciality");
	String gratime=request.getParameter("gratime");
	String graschool=request.getParameter("graschool");
	String idcard=request.getParameter("idcard");
	String natinveplace=request.getParameter("natinveplace");
	String mobile=request.getParameter("mobile");
	String hometel=request.getParameter("hometel");
	String emptime=request.getParameter("emptime");
	String empplace=request.getParameter("empplace");
	String payaccount=request.getParameter("payaccount");
	String homeaddress=request.getParameter("homeaddress");

	 
	 w1UserMgr userdb=new w1UserMgr();
	    w1User user=new w1User();
	    user.setUserid(Integer.parseInt(userid));
	    user.setEmpname(empname);
	    user.setDepartment(department);
		user.setDuty(duty);
		user.setSchoolage(schoolage);
		user.setSex(sex);
		user.setNation(nation);
		user.setDegree(degree);
		user.setMarriage(marriage);
		user.setIncumbency(incumbency);
		user.setSpeciality(speciality);
	    user.setGratime(gratime);
		user.setGraschool(graschool);
		user.setIdcard(idcard);
		user.setNatinveplace(natinveplace);
		user.setMobile(Integer.parseInt(mobile));
		user.setHometel(Integer.parseInt(hometel));
		user.setEmptime(emptime);
		user.setEmpplace(empplace);
		user.setPayaccount(Integer.parseInt(payaccount));
		user.setHomeaddress(homeaddress);
		user.setRemark(remark);

    
    int i=userdb.chang(user);
	   
    request.setAttribute("user", user);
    Collection rst=userdb.getAll();
	request.setAttribute("rss", rst);
    request.getRequestDispatcher("/w1usermgr/list.jsp").forward(request, response);	
}

if(opraParam.equals("delete"))
{
	w1UserMgr userdb=new w1UserMgr();
    w1User w1User=new w1User();
	String s=request.getParameter("sqlCondition");
    //System.out.println(s);
	int userid=Integer.parseInt(s);
	
	System.out.println(userid);
	int i=userdb.delete(userid);
		
	Collection rst=userdb.getAll();
	request.setAttribute("rss", rst);
    request.getRequestDispatcher("/w1usermgr/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);
	
	w1UserMgr userdb=new w1UserMgr();
    w1User user=new w1User();
    Collection rst=userdb.getPage(start, size);
    System.out.println(st);
	request.setAttribute("rss", rst);
	request.setAttribute("stat", st);
	//int stat;
    request.getRequestDispatcher("/w1usermgr/list.jsp").forward(request, response);	
}
}

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

}