update.java

来自「为交课程设计」· Java 代码 · 共 203 行

package com.infodeliver.hr.person.dao;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.infodeliver.hr.util.DBConnection;
import com.infodeliver.hr.util.DBUtil;
import com.infodeliver.hr.util.ResultHandler;
import java.sql.ResultSet;
import java.sql.*;
import com.infodeliver.hr.person.model.*;
import javax.servlet.ServletRequest;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import com.infodeliver.hr.person.form.PersonActionForm;
import com.infodeliver.hr.person.model.FamilyMember;
import java.util.StringTokenizer;

public class Update {
  DBConnection conn=new DBConnection(2);
  public List education(String person_id) throws
      Exception {
    String sqleducation = "select * from pr_educationinfo where person_id=" +person_id;
    final List edu = new ArrayList();
    //final Education education = new Education();
    DBUtil.ProccessSql(conn, sqleducation, new ResultHandler() {
      public void proccess(ResultSet rs) {
        try {
            Education education = new Education();
            education.setEducation_id(rs.getString("education_id"));
            education.setEducationdate_from(rs.getString("educationdate_from"));
            education.setEducationdate_to(rs.getString("educationdate_to"));
            education.setSchool(rs.getString("schoolname"));
            education.setMajor(rs.getString("major"));
            education.setDegree(rs.getString("degree"));
            education.setCertificate(rs.getBinaryStream("certificate"));
            edu.add(education);
        }
        catch (SQLException ex) {
          System.out.println(ex.toString());
        }
      }
    });
  return edu;
  }


public List person(String person_id)throws Exception{
String sqlperson="select * from pr_person where person_id="+person_id;
      final List per=new ArrayList();
      //final PersonActionForm1 personactionform=new PersonActionForm1();
       DBUtil.ProccessSql(conn,sqlperson,new ResultHandler(){
      public void proccess(ResultSet rs) {
        try {

             PersonActionForm personactionform=new PersonActionForm();
             personactionform.setPerson_id(Long.parseLong(rs.getString("person_id")));
             personactionform.setPerson_fname(rs.getString("person_fname"));
             personactionform.setPerson_sname(rs.getString("person_sname"));
             personactionform.setSex(rs.getString("sex"));
             personactionform.setAge(rs.getInt("age"));
             personactionform.setMajor(rs.getString("major"));
             personactionform.setEducation(rs.getString("degree"));
             personactionform.setBrithdate(rs.getString("birthdate"));
             personactionform.setMarital_status(rs.getString("marital_status"));
             personactionform.setRegistered_residence(rs.getString("registered_residence"));
             personactionform.setID_no(rs.getString("ID_no"));
             personactionform.setContact_phone_no(rs.getString("contact_phone_no"));
             personactionform.setE_mail(rs.getString("e_mail"));
             personactionform.setAddress_no(rs.getString("address_no"));
             personactionform.setPost_code(rs.getString("post_code"));
             int i=0;
             String[] sapply=new String[10];
             String apply=rs.getString("apply_for");
             StringTokenizer apply_for=new StringTokenizer(apply,",");
             while(apply_for.hasMoreElements()){
             sapply[i]=(String) apply_for.nextElement();
             i=i+1;
             }
             personactionform.setApply_forarray(sapply);
             //person.setApply_for(rs.getString("apply_for"));
             personactionform.setSalary_requirnet_net(Integer.parseInt(rs.getString("salary_requirnet_net")));
             personactionform.setTime(rs.getString("time"));
             personactionform.setInputer_by(rs.getString("inputer_by"));
             //personactionform.setPicture(rs.getString("picturepath"));
             //String English=rs.getString("language_en");
             //String Englishf=English.substring(0,English.lastIndexOf(","));
             //String Englishs=English.substring(English.lastIndexOf(",")+1);
             personactionform.setLanguage_en(rs.getString("language_en"));
//             personactionform.setLanguage_en_certificate(rs.getString("en_certificate_path"));
             //String Japanese=rs.getString("language_jp");
             //String Japanesef=Japanese.substring(0,Japanese.lastIndexOf(","));
             //String Japaneses=Japanese.substring(Japanese.lastIndexOf(",")+1);
             personactionform.setLanguage_jp(rs.getString("language_jp"));
//             personactionform.setLanguage_jp_certificate(rs.getString("jp_certificate_path"));
             //String computer=rs.getString("computer_level");
             //String computerf=computer.substring(0,computer.lastIndexOf(","));
             //String computers=computer.substring(computer.lastIndexOf(",")+1);
             personactionform.setComputer_level(rs.getString("computer_level"));
//             personactionform.setComputer_certificate(rs.getString("com_certificate_path"));
             personactionform.setOther1(rs.getString("other1"));
             personactionform.setOther2(rs.getString("other2"));
             per.add(personactionform);
             //request.setAttribute("personactionform",personactionform);

        }
        catch (SQLException ex) {
          System.out.println(ex.toString());
        }
      }
    });
    return per;
}

  public List family(String person_id)throws Exception
  {
    String sqlfamily="select * from pr_familymember where person_id="+person_id;

    final List fam=new ArrayList();
    DBUtil.ProccessSql(conn,sqlfamily,new ResultHandler(){
      public void proccess(ResultSet rs){
        try{
          FamilyMember familymember=new FamilyMember();


            familymember.setFamilymember_name(rs.getString("familymember_name"));
            System.out.println(rs.getString("familymember_name"));
            familymember.setFamilymember_relation(rs.getString("familymember_relation"));
            familymember.setFamilymember_age(rs.getString("familymember_age"));
            familymember.setFamilymember_job(rs.getString("familymember_job"));
            fam.add(familymember);

        }
        catch(SQLException ex){
          System.out.println(ex.toString());
        }
      }
    });
     return fam;
  }


public List workexperience(String person_id) throws Exception
{
        String sqlworkexperience="select * from pr_workexperience where person_id="+person_id;
        System.out.println(sqlworkexperience);
       // final WorkExperience workexperience=new WorkExperience();
        final List work=new ArrayList();
        DBUtil.ProccessSql(conn,sqlworkexperience,new ResultHandler(){
        public void proccess(ResultSet rs){
          try{
              WorkExperience workexperience=new WorkExperience();
              workexperience.setWork_from(rs.getString("work_from"));
              workexperience.setWork_to(rs.getString("work_to"));
              workexperience.setName_of_company(rs.getString("name_of_company"));
              workexperience.setPosition(rs.getString("position"));
              workexperience.setLastsalary(rs.getString("lastsalary"));
              workexperience.setWork_content(rs.getString("work_content"));
              workexperience.setReason_of_resignation(rs.getString("reason_of_resignation"));
              work.add(workexperience);

          }
          catch(SQLException ex){
            System.out.println(ex.toString());
          }
        }
        });
      return work;
}


//public List skill(String person_id)throws Exception
//{
//             String sqlskill="select * from pr_person where person_id="+person_id;
//             final
//             DBUtil.ProccessSql1(conn,sqlskill,new ResultHandler(){
//             public void proccess(ResultSet rs){
//               try{
//                 while(rs.next()){
//                   skill.add(rs.getString("language_en"));
//                   skill.add(rs.getString("language_jp"));
//                   skill.add(rs.getString("computer_level"));
//                   skill.add(rs.getString("other1"));
//                   skill.add(rs.getString("other2"));
//                 }
//               }
//               catch(SQLException ex){
//                 System.out.println(ex.toString());
//               }
//             }
//             });
//}

//public static void main(String args[]){
//Update update=new Update();
//try {
//   update.education("100020");
// }
//  catch (Exception ex) {
//  }
//}

}