?? submit.java
字號:
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();
}
//初始化數(shù)據(jù)庫連接
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());
}
}
//存儲員工學(xué)習(xí)經(jīng)歷到數(shù)據(jù)庫
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());
}
}
//存儲員工工作經(jīng)驗到數(shù)據(jù)庫
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());
}
}
//存儲員工基本信息到數(shù)據(jù)庫
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){
//轉(zhuǎn)向顯示頁面 會話失效
response.sendRedirect("error.jsp?type=2");
}
//獲取form里的數(shù)據(jù)
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(); //初始化數(shù)據(jù)庫連接
//獲取該員工存儲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!");
}
//轉(zhuǎn)向顯示頁面
response.sendRedirect("../upload.jsp");
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
//把String類型轉(zhuǎn)換為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;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -