updateinfo.java

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

package updateServlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
import java.text.SimpleDateFormat;

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

import myLogger.MideaLogger;

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

public class updateInfo extends HttpServlet {
	
	private com.suntek.eap.jdbc.PreparedStatement pstmt_study, pstmt_work;
	
	
	public updateInfo() {
		super();
	}
	
//	初始化数据库连接
	private void initializejdbc(){
		//eap_jdbc.jar包
		try{
			
			QueryHelper inserter = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
			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());
		}
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
this.doPost(request, response);

}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		PrintWriter out = response.getWriter();
		
		initializejdbc();
		
//		获取form里的数据
	    String ygbh = request.getParameter("gh");
	    int i_ygbh = Integer.valueOf(ygbh).intValue();
		String vc_xm = request.getParameter("xm");
	    String xb = request.getParameter("xb");
	    String csrq = request.getParameter("csrq") ;
	    Date dt_csrq =  getSqlDate(csrq);
	    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 lines1cnt = request.getParameter("lines1cnt");
		int count1 = Integer.parseInt(lines1cnt);
		String lines2cnt = request.getParameter("lines2cnt");
		int count2 = Integer.parseInt(lines2cnt);
		String[] workExpcol1 = request.getParameterValues("Wqzny");
		String[] workExpcol2 = request.getParameterValues("Wdwjzw");
		String[] workExpcol3 = request.getParameterValues("Wzmr");
		String[] workExpcol4 = request.getParameterValues("Wzmrdh");
		
		String[] studyExpcol1 = request.getParameterValues("Sqzny");
		String[] studyExpcol2 = request.getParameterValues("Syx");
		String[] studyExpcol3 = request.getParameterValues("Szy");
		String[] studyExpcol4 = request.getParameterValues("Sby");
		String[] studyExpcol5 = request.getParameterValues("Szmr");
	
		try{
	  //修改员工基本信息
		updateEmpinfo(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);
		//修改员工工作经历
		//修改员工学习经历
		
		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]);

		out.println(workExpcol1[i]);
		out.println(workExpcol2[i]);
		out.println(workExpcol3[i]);
		out.println(workExpcol4[i]);
}
		}catch(Exception e){
			MideaLogger.logger.error(e.getMessage());
		}
		//转向显示页面
		response.sendRedirect("../upload.jsp");
	}

		//修改员工基本信息
	private void updateEmpinfo(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){
		try{
			QueryHelper updater = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
			String sql = "update RESUMEINFO"+
					" set vc_xm ='"+xm+"',c_xb = '"+ xb+"', dt_csrq = to_date('"+csrq+"','yyyy-mm-dd'), vc_mz ='"+mz+"', vc_jg = '"+hk+"', vc_hk= '"+hk+"',"+
					"vc_zy = '"+zy+"', vc_byyx = '"+byyx+"', dt_bysj = to_date('"+bysj+"','yyyy-mm-dd'), vc_sfzhm = '"+sfzhm+"',"+
					"vc_lxdh = '"+lxdh+"',vc_jtdh = '"+jtdh+"',vc_jtxxdz = '"+jtxxdz+"',t_hdry = '"+hdry+"',t_bz = '"+bz+
					"' where i_ygbh =" + ygbh;
			updater.execute(sql);
			
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}
	}
	

	
	
//	把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 ex) {

			MideaLogger.logger.error(ex.getStackTrace());
		}
		return d;
	}

}