submit.java

本系统基于jsp+servlet+javabean三层模式开发

package SubmitServlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Enumeration;
import java.sql.Date;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.suntek.eap.jdbc.QueryHelper;
import com.suntek.eap.jdbc.RowModel;
import com.suntek.eap.core.app.*;

import myLogger.MideaLogger;

public class Submit extends HttpServlet {


	private com.suntek.eap.jdbc.PreparedStatement pstmt_info, pstmt_study, pstmt_work;
	
	public Submit() {
		super();
	}

	public void init() throws ServletException {
	
	}
	
	public void destroy() {
		super.destroy(); 
	}

	//初始化数据库连接
	private void initializejdbc(){
		//eap_jdbc.jar包
		try{
			QueryHelper inserter = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());

			//增加员工基本信息，插入EmployerInfo
			pstmt_info = inserter.preparedStatement("insert into RESUMEINFO"+
					"(i_ygbh,vc_xm,c_xb, dt_csrq, vc_mz, vc_jg, vc_hk,"+
					"vc_zy, vc_byyx, dt_bysj,vc_sfzhm,"+
					"vc_lxdh,vc_jtdh,vc_jtxxdz,t_hdry,t_bz,vc_xl)"+
					"values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
			pstmt_study = inserter.preparedStatement("insert into StudyExp2"+
					"(i_ygbh,vc_qzny, vc_yx, vc_zy, vc_by, vc_zmr)"+
							" values(?,?,?,?,?,?)");
			pstmt_work = inserter.preparedStatement("insert into WorkExp2(i_ygbh,vc_qzny,vc_dwjzw,vc_zmr,vc_zmrdh)"+
					"values(?,?,?,?,?)");
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
	}
	
	//存储员工学习经历到数据库
	private void storeStudyExp(int ygbh, String qzny, String yx, String zy, String by, String zmr){
		try{
			pstmt_study.setInt(1, ygbh);
			pstmt_study.setString(2, qzny);
			pstmt_study.setString(3, yx);
			pstmt_study.setString(4, zy);
			pstmt_study.setString(5, by);
			pstmt_study.setString(6, zmr);
			pstmt_study.executeUpdate();
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
	}
	
	//存储员工工作经验到数据库
	private void storeWorkExp(int ygbh, String qzny, String dwjzw,String zmr, String zmrdh){
		try{
			pstmt_work.setInt(1, ygbh);
			pstmt_work.setString(2, qzny);
			pstmt_work.setString(3, dwjzw);
			pstmt_work.setString(4, zmr);
			pstmt_work.setString(5, zmrdh);
			pstmt_work.executeUpdate();
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
	}
	
	//存储员工基本信息到数据库
	private void storeEmpinfo(int ygbh, String xm, String xb, Date csrq, String mz, String jg, String hk,
			String zy, String byyx, Date bysj, String sfzhm,
			String lxdh, String jtdh, String jtxxdz, String hdry, String bz, String xl){
		try{
			pstmt_info.setInt(1, ygbh);
			pstmt_info.setString(2, xm);
			pstmt_info.setString(3, xb);
			pstmt_info.setDate(4, csrq);
			pstmt_info.setString(5, mz);
			pstmt_info.setString(6, jg);
			pstmt_info.setString(7, hk);
			pstmt_info.setString(8, zy);
			pstmt_info.setString(9, byyx);
			pstmt_info.setDate(10, bysj);
			pstmt_info.setString(11, sfzhm);
			pstmt_info.setString(12, lxdh);
			pstmt_info.setString(13, jtdh);
			pstmt_info.setString(14, jtxxdz);
			pstmt_info.setString(15, hdry);
			pstmt_info.setString(16, bz);
			pstmt_info.setString(17, xl);
			pstmt_info.executeUpdate();
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		PrintWriter out = response.getWriter();
		
		HttpSession session = request.getSession();
		String yhm = (String)session.getAttribute("yhm");   
        if (yhm==null){   
            //转向显示页面   会话失效
			response.sendRedirect("error.jsp?type=2");                   
      }   
		
		//获取form里的数据
		String vc_xm = request.getParameter("xm");
	    String xb = request.getParameter("xb");
	    String birthday = request.getParameter("birthday");
	    Date dt_csrq =  getSqlDate(birthday);
	    String vc_mz =request.getParameter("mz");
		String vc_jg = request.getParameter("jg");
		String vc_hk = request.getParameter("hkszd");
		String vc_zy = request.getParameter("zy");
	    String vc_byyx = request.getParameter("byyx");
	    String bysj = request.getParameter("bysj");
	    Date dt_bysj = getSqlDate(bysj);
	    String vc_sfzhm = request.getParameter("sfzhm");
	    String vc_lxdh = request.getParameter("lxdh");
	    String vc_jtdh = request.getParameter("jtdh");
	    String vc_jtxxdz = request.getParameter("jtxxdz");
	    String t_hdry = request.getParameter("hdry");
	    String t_bz = request.getParameter("bz");
	    String vc_xl = request.getParameter("xl");
	    
			String[] workExpcol1 = request.getParameterValues("workExpcol1");
			String[] workExpcol2 = request.getParameterValues("workExpcol2");
			String[] workExpcol3 = request.getParameterValues("workExpcol3");
			String[] workExpcol4 = request.getParameterValues("workExpcol4");
			
			String[] studyExpcol1 = request.getParameterValues("studyExpcol1");
			String[] studyExpcol2 = request.getParameterValues("studyExpcol2");
			String[] studyExpcol3 = request.getParameterValues("studyExpcol3");
			String[] studyExpcol4 = request.getParameterValues("studyExpcol4");
			String[] studyExpcol5 = request.getParameterValues("studyExpcol5");



		
		initializejdbc();             //初始化数据库连接
		//获取该员工存储id
		QueryHelper queryer = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
		String sql = "select S_ID.nextval as nextId from dual";
		ArrayList arrRow = null;
		try{
		arrRow = queryer.executeQuery(sql);
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
		RowModel row = (RowModel)arrRow.get(0);
		String ygbh = row.getColumnValue("nextId");
		int i_ygbh = Integer.parseInt(ygbh);
		
		HttpSession session1 = request.getSession();
		session1.setAttribute("ygbh", ygbh);
		try{
		//存储员工基本信息
		storeEmpinfo(i_ygbh, vc_xm, xb,  dt_csrq, vc_mz,vc_jg, vc_hk, vc_zy, vc_byyx, dt_bysj, vc_sfzhm, 
				vc_lxdh, vc_jtdh,vc_jtxxdz, t_hdry, t_bz, vc_xl); 
		
		for ( int i = 0; i < studyExpcol1.length; i++){
			storeStudyExp(i_ygbh, studyExpcol1[i],studyExpcol2[i],studyExpcol3[i],studyExpcol4[i],studyExpcol5[i]);
			out.println(studyExpcol1[i]);
			out.println(studyExpcol2[i]);
			out.println(studyExpcol3[i]);
			out.println(studyExpcol4[i]);
			out.println(studyExpcol5[i]);	
		}
		for ( int i = 0; i<workExpcol1.length; i++){
		storeWorkExp(i_ygbh, workExpcol1[i],workExpcol2[i],workExpcol3[i],workExpcol4[i]);
		}
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
			out.print("store worng!");
		}
		
		String updatesql = "Update USERINFO SET I_YGBH = "+ygbh+",I_JL = "+1+" WHERE VC_ID='"+yhm+"'";
		try{
			QueryHelper updater = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
			updater.execute(updatesql);
		}
		catch(Exception ex)
		{
			MideaLogger.logger.error(ex.getMessage());
			out.print("update wrong!");
		}
	
	//转向显示页面
	response.sendRedirect("../upload.jsp");
	}
	
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doPost(request, response);
		
	}

	//把String类型转换为java.sql.date
	public static java.sql.Date getSqlDate(String s) {
		java.sql.Date d = null;
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		try {
			java.util.Date date = new java.util.Date();
			if (s!=null && !s.equals("null")&&!s.equals("") ) {
				date = sdf.parse(s);
			}
			d = new java.sql.Date(date.getTime());
		} catch (Exception e) {
			
		}
		return d;
	}


}