employeeinfosave.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.servlet;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;
import com.logistic.business.EmployeeManager;


public class EmployeeInfoSave extends HttpServlet {

	private static final long serialVersionUID = -2305260907601477327L; 
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	int flag=0;
	int employeeid;
	String id=null;
	String name=null;
	String sex=null;
	int    age=0;
	String idencard=null;
	String birthdate=null;
	String diploma=null;
	String joindate=null;
	String address=null;
	String phone=null;
	String mobile=null;
	String department=null;
	String job=null;
	RequestDispatcher requestdispatcher;
	


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
	
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
		//得到最后一条记录的EmployeeId，并生成下条记录d的EmployeeId
		String sql="select * from employeeinfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
		 
			rs=stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
					employeeid=Integer.valueOf(rs.getString("EmployeeId"));
					}
			if(employeeid>0){
					employeeid+=1;
				}else{employeeid=10000+1;}
		 
		 }catch(Exception ex){
			 ex.printStackTrace();
		 	}finally{dc.close();}
		 	
/*--------------从页面employeeinfosave.jsp获取员工信息，并判断是否合法。如果合法插入员工信息-----------*/
		 id=String.valueOf(employeeid);								//把生成的员工编号employeeid转换成字符串类型
		 name=(String)request.getParameter("employeename");			//员工姓名
		 sex=(String)request.getParameter("employeesex");			//员工性别
		 age=Integer.valueOf(request.getParameter("employeeage"));  //员工年龄
		 idencard=(String)request.getParameter("employeeidcard");   //员工身份证号码
		 birthdate=(String)request.getParameter("birthdate");		//员工出生日期
		 diploma=(String)request.getParameter("diploma");			//员工的学历
		 joindate=(String)request.getParameter("joindate");			//员工加入公司时间
		 address=(String)request.getParameter("homeaddress");		//员工的家庭住址
		 phone=(String)request.getParameter("fixphone");			//员工家中电话号码	
		 mobile=(String)request.getParameter("mobile");				//员工移动电话号码	
		 department=(String)request.getParameter("department");     //员工所属部门
		 job=(String)request.getParameter("jobs");					//员工所从事的职务
		
       if(id==null||name==null||sex==null||(age<18)||(idencard.length()<18)||(mobile.length()!=11)){
    	  
    	  session.setAttribute("errors","员工信息填写有误，请确认!");
    	  requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		  requestdispatcher.forward(request, response);   	  
        }else{
		
		 try{
				EmployeeManager em=new EmployeeManager();
				flag=-10;
				flag=em.AddEmployee(id, name, sex, age, idencard, birthdate, diploma, joindate, address, phone, mobile, department, job);
				if(flag>0){
						session.setAttribute("success","职员信息添加成功!");
						requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/employeeinfolist.jsp");
						requestdispatcher.forward(request, response);
				}else{
						session.setAttribute("errors", "职员信息添加失败!");
						requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
						requestdispatcher.forward(request, response);
				}
			}catch(Exception ex){
				    flag=-1;
					ex.printStackTrace();
		   }finally{dc.close();}
        }
}
	
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

                 doPost(request,response);

		}
}