employeemanager.java

struct框架示例

package com.inherit.trust.employee;
import javax.servlet.http.*;
import java.sql.ResultSet;
import java.util.*;
import java.text.*;
import java.io.*;
import java.lang.*;
import com.inherit.trust.db.*;

public class employeemanager {

  public employeemanager() {
  }

  public boolean insert(
    String ep_name,
    String ep_depid,
    String ep_sex,
    String ep_birthday,
    String ep_diploma,
    String ep_partydate,
    String ep_wage,
    String ep_job,
    String ep_joindate,
    String ep_enterdate,
    String ep_workdate,
    String ep_idnum,
    String ep_phone,
    String ep_addr,
    String ep_colleage_major,
    String ep_duty,
    String ep_dutydate,
    String ep_parttime,
    String ep_workstory,
    String ep_educate,
    String ep_train,
    String ep_dutyhis){
    try {
      System.out.println("进入Bean!");
      String sqlstr = "";
      sqlstr =
          "INSERT INTO EMPLOYEE(ep_epid, ep_name,ep_sex,ep_depid,ep_birth,ep_diploma, ep_partydate, ep_wage,ep_job, ep_joindate, ep_enterdate,"+
          "ep_workdate, ep_idnum, ep_phone,ep_addr, ep_colleage_major, ep_duty,ep_dutydate, ep_parttime, ep_workstory,"+
          "ep_educate, ep_train, ep_dutyhis)";
      sqlstr = sqlstr + " VALUES(EMPLOYEE_ID.NEXTVAL,'"+
      ep_name+"','"+ep_sex+"','"+ep_depid+"',to_date('"+ep_birthday+"','yyyy-mm-dd'),'"+ep_diploma+"',to_date('"+ep_partydate+"','yyyy-mm-dd'),"+ep_wage+",'"+ep_job+"',to_date('"+
      ep_joindate+"','yyyy-mm-dd'),to_date('"+ep_enterdate+"','yyyy-mm-dd'),"+ep_workdate+",'"+ep_idnum+"','"+ep_phone+"','"+ep_addr+"','"+
      ep_colleage_major+"','"+ep_duty+"',to_date('"+ep_dutydate+"','yyyy-mm-dd'),'"+ep_parttime+"','"+ep_workstory+"','"+
      ep_educate+"','"+ep_train+"','"+ep_dutyhis+"')";
      OraConnect oraContemp = new OraConnect();
      System.out.println(sqlstr);
      oraContemp.executeUpdate(sqlstr);
   }
  catch (Exception e) {
    System.out.println("error " + e.toString());
    return false;
  }
  return true;
 }

 public boolean update(
   String ep_epid,
   String ep_name,
   String ep_depid,
   String ep_diploma,
   String ep_partydate,
   String ep_wage,
   String ep_job,
   String ep_joindate,
   String ep_enterdate,
   String ep_workdate,
   String ep_idnum,
   String ep_phone,
   String ep_addr,
   String ep_colleage_major,
   String ep_duty,
   String ep_dutydate,
   String ep_parttime,
   String ep_workstory,
   String ep_educate,
   String ep_train,
   String ep_dutyhis){
   try {
     System.out.println("进入Bean!");
     String sqlstr =
         "UPDATE EMPLOYEE SET ep_name='"+ep_name+"',"+
         "ep_depid='"+ep_depid+"',"+
         "ep_diploma='"+ep_diploma+"',"+
         "ep_partydate='"+ep_partydate+"',"+
         "ep_wage='"+ep_wage+"',"+
         "ep_job='"+ ep_job+"',"+
         "ep_joindate='"+ep_joindate+"',"+
         "ep_enterdate='"+ep_enterdate+"',"+
         "ep_workdate='"+ep_workdate+"',"+
         "ep_idnum='"+ep_idnum+"',"+
         "ep_phone='"+ep_phone+"',"+
         "ep_addr='"+ep_addr+"',"+
         "ep_colleage_major='"+ep_colleage_major+"',"+
         "ep_duty='"+ep_duty+"',"+
         "ep_dutydate='"+ep_dutydate+"',"+
         "ep_parttime='"+ep_parttime+"',"+
         "ep_workstory='"+ep_workstory+"',"+
         "ep_educate='"+ep_educate+"',"+
         "ep_train='"+ep_train+"',"+
         "ep_dutyhis='"+ ep_dutyhis+"' "+
         "WHERE ep_epid="+ep_epid ;
     OraConnect oraContemp = new OraConnect();
     System.out.println(sqlstr);
     oraContemp.executeUpdate(sqlstr);
  }
 catch (Exception e) {
   System.out.println("error " + e.toString());
   return false;
 }
 return true;
 }

 public boolean del(String ep_epid){
   try {
    System.out.println(ep_epid);
    String sqlstr =
      "UPDATE EMPLOYEE SET ep_status='2' WHERE ep_epid="+ep_epid;
    OraConnect oraContemp = new OraConnect();
    System.out.println(sqlstr);
    oraContemp.executeUpdate(sqlstr);
   }
   catch (Exception e) {
   System.out.println("error " + e.toString());
   return false;
   }
   return true;
 }

 public List queryemployeebyname(String ep_name){
   OraConnect oraContemp = new OraConnect();
   try {
     System.out.println("查询 queryemployeebyname !");
      ResultSet rs = null;
      List list=new ArrayList();
      String sqlstr="";
      if(!ep_name.equals(""))
      { sqlstr = "select * from employee where ep_name like '%" + ep_name+ "%' and status='1' ";
        }
      else
      {
        sqlstr = "select * from custom where status='1'";
      }

      System.out.println("sql语句为"+sqlstr);
      rs=oraContemp.executeQuery(sqlstr);
      System.out.println("恭喜："+sqlstr+"语句执行成功！");
      while(rs.next()){
        employee employeeinfo=new employee();
        employeeinfo.ep_epid=rs.getString("ep_epid");
        System.out.println("员工标示"+employeeinfo.ep_epid);
        employeeinfo.ep_name=rs.getString("ep_name");
        employeeinfo.ep_addr=rs.getString("ep_addr");
        employeeinfo.ep_birth=rs.getString("ep_birth");
        employeeinfo.ep_colleage_major=rs.getString("ep_colleage_major");
        employeeinfo.ep_dutydate=rs.getString("ep_dutydate");
        employeeinfo.ep_dutyhis =rs.getString("ep_dutyhis");
        employeeinfo.ep_educate =rs.getString("ep_educate");
        employeeinfo.ep_enterdate=rs.getString("ep_enterdate");
        employeeinfo.ep_epid=rs.getString("ep_epid");
        employeeinfo.ep_idnum =rs.getString("ep_idnum");
        employeeinfo.ep_job =rs.getString("ep_job");
        employeeinfo.ep_joindate =rs.getString("ep_joindate");
        employeeinfo.ep_sex =rs.getString("ep_sex");
        employeeinfo.ep_name=rs.getString("ep_name");
        employeeinfo.ep_partydate =rs.getString("ep_partydate");
        employeeinfo.ep_phone =rs.getString("ep_phone");
        employeeinfo.ep_sex =rs.getString("ep_sex");
        employeeinfo.ep_train =rs.getString("ep_train");
        employeeinfo.ep_wage =rs.getString("ep_wage");
        employeeinfo.ep_workdate =rs.getString("ep_workdate");
        employeeinfo.ep_workstory  = rs.getString("ep_workstory");
        list.add(employeeinfo);
      }
      oraContemp.oraClose();
      return list;
    }
    catch (Exception e) {
      System.out.println("error " + e.toString());
      oraContemp.oraClose();
      return null;
    }
  }


  public List queryemployeebywherestr(String wherestr){
   OraConnect oraContemp = new OraConnect();
   try {
      System.out.println("查询 queryemployeebyname !");
      ResultSet rs = null;
      List list=new ArrayList();
      String sqlstr="";
      if(!wherestr.equals(""))
      { sqlstr = "select * from employee "+wherestr;
        }
      else
      {
        sqlstr = "select * from custom where status='1'";
      }

      System.out.println("sql语句为"+sqlstr);
      rs=oraContemp.executeQuery(sqlstr);
      System.out.println("恭喜："+sqlstr+"语句执行成功！");
      while(rs.next()){
        employee employeeinfo=new employee();
        employeeinfo.ep_epid=rs.getString("ep_epid");
        System.out.println("员工标示"+employeeinfo.ep_epid);
        employeeinfo.ep_name=rs.getString("ep_name");
        employeeinfo.ep_addr=rs.getString("ep_addr");
        employeeinfo.ep_birth=rs.getString("ep_birth");
        employeeinfo.ep_colleage_major=rs.getString("ep_colleage_major");
        employeeinfo.ep_dutydate=rs.getString("ep_dutydate");
        employeeinfo.ep_dutyhis =rs.getString("ep_dutyhis");
        employeeinfo.ep_educate =rs.getString("ep_educate");
        employeeinfo.ep_enterdate=rs.getString("ep_enterdate");
        employeeinfo.ep_epid=rs.getString("ep_epid");
        employeeinfo.ep_idnum =rs.getString("ep_idnum");
        employeeinfo.ep_job =rs.getString("ep_job");
        employeeinfo.ep_joindate =rs.getString("ep_joindate");
        employeeinfo.ep_sex =rs.getString("ep_sex");
        employeeinfo.ep_name=rs.getString("ep_name");
        employeeinfo.ep_partydate =rs.getString("ep_partydate");
        employeeinfo.ep_phone =rs.getString("ep_phone");
        employeeinfo.ep_sex =rs.getString("ep_sex");
        employeeinfo.ep_train =rs.getString("ep_train");
        employeeinfo.ep_wage =rs.getString("ep_wage");
        employeeinfo.ep_workdate =rs.getString("ep_workdate");
        employeeinfo.ep_workstory  = rs.getString("ep_workstory");
        list.add(employeeinfo);
      }
      oraContemp.oraClose();
      return list;
    }
    catch (Exception e) {
      System.out.println("error " + e.toString());
      oraContemp.oraClose();
      return null;
    }
  }

}