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;
	}

}