hr.rar_hr_公司员工系统

package com.infodeliver.hr.person.dao; import java.util.*; import com.infodeliver.hr.person.form.PersonActionForm; import com.infodeliver.hr.person.PersonManager; import com.infodeliver.hr.util.DBConnection; import com.infodeliver.hr.util.RecordList; import java.sql.ResultSet; import com.infodeliver.hr.util.DBUtil; import com.infodeliver.hr.util.ResultHandler; import com.infodeliver.hr.person.model.Person; import com.infodeliver.hr.util.PreparedStmtementHandler; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.StringTokenizer; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import com.infodeliver.hr.person.form.CheckActionForm; import com.infodeliver.hr.person.model.PersonAtt; import com.infodeliver.hr.person.model.Education; import org.apache.struts.upload.FormFile; import java.io.UnsupportedEncodingException; import java.text.SimpleDateFormat; public class PersonManagerImpl implements PersonManager { private DBConnection conn = null; public boolean newPerson(PersonActionForm personactionform, String person_id) throws Exception { DBConnection conn = null; String sqleducation = ""; String sqleducation1 = ""; String sqleducation2 = ""; String sqlperson = ""; String sqlfamily = ""; String sqlfamily1 = ""; String sqlfamily2 = ""; // String sqlskill = ""; // String sqlskill1 = ""; // String sqlskill2 = ""; String sqlexperience = ""; String sqlexperience1 = ""; String sqlexperience2 = ""; conn = new DBConnection(2); List sql = new ArrayList(); List person = new ArrayList(); List education = new ArrayList(); List education1 = new ArrayList(); List education2 = new ArrayList(); List family = new ArrayList(); List family1 = new ArrayList(); List family2 = new ArrayList(); // List skill = new ArrayList(); // List skill1 = new ArrayList(); // List skill2 = new ArrayList(); List experience = new ArrayList(); List experience1 = new ArrayList(); List experience2 = new ArrayList(); //添加到pr_person部分 String sql1 = "insert into pr_person values("; person.add(person_id); //人员编号 person.add(personactionform.getPerson_fname()); //人员性 person.add(personactionform.getPerson_sname()); //人员名 person.add(personactionform.getSex()); //性别 person.add(String.valueOf(personactionform.getAge())); //年龄 person.add(personactionform.getMajor()); //专业 person.add(personactionform.getEducation()); //学历 person.add(personactionform.getBrithdate()); //出生日期 person.add(personactionform.getMarital_status()); //婚否 person.add(personactionform.getRegistered_residence()); //户籍 person.add(personactionform.getID_no()); //身份证号码 person.add(personactionform.getContact_phone_no()); //联系电话 person.add(personactionform.getE_mail()); //e_mail person.add(personactionform.getAddress_no()); //地址 person.add(personactionform.getPost_code()); //邮编 String[] apply_forarray; String apply = ""; apply_forarray = personactionform.getApply_forarray(); for (int i = 0; i < apply_forarray.length-1; i++) { apply = apply + apply_forarray[i] + ","; } apply=apply+apply_forarray[apply_forarray.length-1]; person.add(apply); //希望岗位 person.add(Integer.toString(personactionform.getSalary_requirnet_net())); //税后工资要求 person.add(personactionform.getTime()); //填表日期 person.add(personactionform.getInputer_by()); //填表人 person.add(personactionform.getPicture()); //照片 person.add(personactionform.getPicture()); //照片路径 person.add(String.valueOf(personactionform.getCustomerchecked_times())); //客户公司已经面试次数 person.add(String.valueOf(personactionform.getInnerchecked_times())); //内部已经面试次数 person.add(personactionform.getOrder_id()); //订单ID person.add("1002"); //人员状态初始值 //String Englishlevel=personactionform.getLanguage_en()+","+personactionform.getLanguage_en_certificate(); //person.add(Englishlevel); person.add(personactionform.getLanguage_en()); //英语水平 person.add(personactionform.getLanguage_en_certificate()); //英语证书 person.add(personactionform.getLanguage_en_certificate()); //英语证书路径 //String Japaneselevel=personactionform.getLanguage_jp()+","+personactionform.getLanguage_jp_certificate(); //person.add(Japaneselevel); person.add(personactionform.getLanguage_jp()); //日语水平 person.add(personactionform.getLanguage_jp_certificate()); //日语证书 person.add(personactionform.getLanguage_jp_certificate()); //日语证书路径 //String computerlevel=personactionform.getComputer_level()+","+personactionform.getComputer_certificate(); //person.add(computerlevel); person.add(personactionform.getComputer_level()); //电脑水平 person.add(personactionform.getComputer_certificate()); //电脑证书 person.add(personactionform.getComputer_certificate()); //电脑证书路径 String other1level = personactionform.getOther1(); //+","+personactionform.getOther1_certificate(); person.add(other1level); //其他水平1 String other2level = personactionform.getOther2(); //+","+personactionform.getOther2_certificate(); person.add(other2level); //其他水平2 person.add(personactionform.getBelongto()); //附属人 for (int i = 0; i < person.size() - 1; i = i + 1) { sqlperson += "'" + new String(person.get(i).toString().getBytes("gb2312"),"ISO-8859-1") + "',"; System.out.println(sqlperson); } sql1 = sql1 + sqlperson + "'" + personactionform.getBelongto() + "')"; person.clear(); System.out.println(sql1); sql.add(sql1); //添加到pr_educationinfo部分 //sql.clear(); String sql2 = "insert into pr_educationinfo(educationdate_from,educationdate_to,schoolname,major,degree,certificate,certificate_path,person_id) values("; if (!personactionform.getE_educationdate_from().equals("")) { education.add(personactionform.getE_educationdate_from()); //教育开始日期 education.add(personactionform.getE_educationdate_to()); //教育结束日期 education.add(personactionform.getE_schoolname()); //学校名称 education.add(personactionform.getE_major()); //专业 education.add(personactionform.getE_degree()); //学历 education.add(personactionform.getE_certificate()); //证书 education.add(personactionform.getE_certificate()); //证书路径 //System.out.println(education.size()); for (int i = 0; i < education.size(); i = i + 1) { sqleducation += "'" + new String(education.get(i).toString().getBytes("gb2312"),"ISO-8859-1") + "',"; } sql2 = sql2 + sqleducation + "'" + person_id + "')"; System.out.println(sql2); sql.add(sql2); } else{ education.add(""); //教育开始日期 education.add(""); //教育结束日期 education.add(""); //学校名称 education.add(""); //专业 education.add(""); //学历 education.add(""); //证书 education.add(""); //证书路径 for (int i = 0; i < education.size(); i = i + 1) { sqleducation += "'" + new String(education.get(i).toString().getBytes("gb2312"),"ISO-8859-1") + "',"; } sql2 = sql2 + sqleducation + "'" + person_id + "')"; System.out.println(sql2); sql.add(sql2); } sql2 = "insert into pr_educationinfo(educationdate_from,educationdate_to,schoolname,major,degree,certificate,certificate_path,person_id) values("; if (!personactionform.getE_educationdate_from1().equals("")) { education1.add(personactionform.getE_educationdate_from1()); //教育开始日期1 education1.add(personactionform.getE_educationdate_to1()); //教育结束日期1 education1.add(personactionform.getE_schoolname1()); //学校名称1 education1.add(personactionform.getE_major1()); //专业1 education1.add(personactionform.getE_degree1()); //学历1 education