agtmngstaffaction.java

培训考试系统代码

package com.huawei.icd30.agt.agtmng;

import javax.servlet.http.*;
import java.lang.*;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import com.huawei.icd30.agt.util.*;
import com.huawei.icd30.common.db.*;

/**
 * <p> 完成业务代表档案的新增修改删除功能</p>
 * <p> (这家伙很懒，什么都没有写)</p>
 * <p> </p>
 * <p> </p>
 * @author unascribed
 * @version 1.0
 */


public class AgtmngStaffAction extends Action
{
      public ActionForward perform(ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
  //       检查session是否超时
  //       ActionForward checkForword = Tools.checkSession(req,res);
 //        得到操作标识operatorflag

        String operatorflag = ((AgtmngStaffForm) form).getOperatorflag();
        /* 查询出员工基本信息表中存在的，
             但业务代表档案表中不存在的所有业务代表记录案操作 */
            //调用方法 staffListToBeAdd;
        if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_TOBEADD"))
        {
             return staffListTobeAdd(mapping, form, req, res);
        }
       //查询平台表中信息
        else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_INYW"))
        {
             return locateWorkNoInYW(mapping, form, req, res);
        }
       /*查询基本档案信息，成功后定位到基本档案信息
           列表页面AgtmngStaffList.jsp*/
        else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_STAFFLIST"))
        {
            return queryStaffList(mapping, form, req, res);
        }
        /*查询教育经历档案信息，成功后定位到教育经历
               列表页面AgtmngEduList.jsp*/
        else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_EDULIST"))
        {
             return queryEduList(mapping, form, req, res);
        }
           /*查询工作经历档案信息，成功后定位到工作经历
             列表页面AgtmngWorkList.jsp*/
        else if  (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_WORKLIST"))
        {
             return queryWorkList(mapping, form, req, res);
        }
          /*新增基本档案记录，成功后定位到基本档案修改页面AgtmngstaffMod.jsp
             或者教育经历修改页面AgtmngeduAdd.jsp*/
        else if  (operatorflag.equalsIgnoreCase("AGTMNG_ADD_BASE") ||
              operatorflag.equalsIgnoreCase("AGTMNG_ADD_BASE_NEXTEDU")||
              operatorflag.equalsIgnoreCase("AGTMNG_ADD_BASE_NEXTWORK"))
        {
               return newBaseArchive(mapping, form, req, res);
        }
            /*新增教育经历记录，成功后定位到教育经历新增页面Agtmngeduadd.jsp，
              或者工作经历新增页面Agtmngeduadd.jsp，
              或者基本档案修改页面AgtmngeduMod.jsp*/
        else if  (operatorflag.equalsIgnoreCase("AGTMNG_ADD_EDU")||
               operatorflag.equalsIgnoreCase("AGTMNG_ADD_EDU_NEXTEDU")||
               operatorflag.equalsIgnoreCase("AGTMNG_ADD_EDU_NEXTWORK")||
               operatorflag.equalsIgnoreCase("AGTMNG_ADD_EDU_NEXTBASE"))
       {
             return newEduArchive(mapping, form, req, res);
       }
           /*新增工作经历记录，成功后定位到工作经历新增页面AgtmngWorkMod.jsp，
              或者教育经历新增页面AgtmngEduMod.jsp，
              或者基本档案修改页面AgtmngEduMod.jsp*/
       else if (operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK")||
             operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK_NEXTWORK")||
             operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK_NEXTBASE")||
             operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK_NEXTEDU"))
       {
             return newWorkArchive(mapping, form, req, res);
       }
           /*修改档案基本信息记录，成功后定位到基本档案修改页面AgtmngEduMod.jsp，
             或教育经历列表页面AgtmngEduList.jsp ，
             或工作经历列表页面AgtmngWorkList.jsp */
       else if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE")||
               operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE_NEXTEDU")||
               operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE_NEXTWORK"))
       {
             return modBaseArchive(mapping,form,req,res);
       }
           /*修改教育经历记录，成功后定位到教育经历列表页面AgtmngEduList.jsp*/
       else if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_EDU"))
       {
            return modEduArchive(mapping, form, req, res);
       }
           /*修改工作经历记录，成功后定位到工作经历列表页面AgtmngWorkList.jsp*/
        else if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_WORK"))
        {
              return modWorkArchive(mapping, form, req, res);
        }
           /*删除基本档案，成功后定位到基本档案信息列表页面AgtmngStaffList.jsp*/
         else if (operatorflag.equalsIgnoreCase("AGTMNG_DEL_BASE"))
        {
              return delBaseArchive(mapping, form, req, res);
        }
           /*删除教育经历档案，成功后定位到教育经历列表页面AgtmngEduList.jsp*/
         else if (operatorflag.equalsIgnoreCase("AGTMNG_DEL_EDU"))
        {
              return delEduArchive(mapping, form, req, res);
        }
          /*删除工作经历档案，成功后定位到工作经历列表页面AgtmngWorkList.jsp*/
         else if (operatorflag.equalsIgnoreCase("AGTMNG_DEL_WORK"))
         {
              return delWorkArchive(mapping, form, req, res);
         }
         /*查询基本档案信息，
              成功后定位到基本档案信息修改页面AgtmngStaffMod.jsp，
              或者AgtmngStaffView.jsp*/
         else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_BASE_NEXTMOD")||
            operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE_NEXTVIEW"))
         {
             return queryBaseArchive(mapping, form, req, res);
         }
         /*查询教育经历档案信息，成功后定位到教育经历修改页面AgtmngEduMod.jsp
              或AgtmngEduView.jsp */
         else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_EDU_NEXTMOD")||
            operatorflag.equalsIgnoreCase("AGTMNG_QUERY_EDU_NEXTVIEW"))
          {
              return queryEduArchive(mapping, form, req, res);
          }
          /*查询工作经历档案信息，成功后定位到工作经历修改页面AgtmngWorkMod.jsp
                或者AgtmngWorkView.jsp*/
          else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_WORK_NEXTMOD")||
            operatorflag.equalsIgnoreCase("AGTMNG_QUERY_WORK_NEXTVIEW"))
          {
              return queryWorkArchive(mapping, form, req, res);
          }
          //查询档案操作日志
          else if (operatorflag.equalsIgnoreCase("AGTMNG_QUERY_LOG"))
          {
              return queryArchiveLog(mapping, form, req, res);
          }
          //转到错误页面，错误码 ErrorCode.unKnownError;
          else
          {
              req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
              return(mapping.findForward("error"));
          }
      }



     /*************************************************************
      *查询需要增加档案的业务代表列表
      *************************************************************/
      private  ActionForward staffListTobeAdd (ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {

        SysDbConn aplcoms = null;
        try
        {
          //连接数据源
          aplcoms = SysConnPool.getInstance().getAplComs();
          aplcoms.preparedQuery("");
          //调用SQL_AGT_QueryUnArchiveList查询，得到结果集rs1
          SysResultSet rs1 = aplcoms.csCommonQuery("SQL_AGT_QueryUnArchive","1","-1").getResultSet();

          if (rs1 != null)
          {
             //按业务代表ID排序
            rs1.sort(0,true);
            //将结果集放到session中 AGTMNG-UNARCHIVELIST
            req.getSession().setAttribute("AGTMNG-UNARCHIVELIST",new ResUtil(rs1));
           }
          //定向到列表页面AgtmngStaffIDAdd.jsp
          return (mapping.findForward("idtobeadd"));
         }
      catch (SysDbException aple)
      {
        //捕获CommonService系统异常,定向到出错页面，错误码为ErrorCode.COMMONSERVICE_ERROR
          aple.printStackTrace();
          req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(java.sql.SQLException sqle)
      {
        //捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR
          sqle.printStackTrace();
          req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(Exception e)
      {
        //捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR
          e.printStackTrace();
          req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
          return (mapping.findForward("error"));
       }
      finally
        //关闭连接实例
        {
          if(aplcoms != null)
          {
             aplcoms.close();
          }
        }
    }


    /********************************************************
     *在平台表tAgentinfo中查询业务代表的姓名、技能、工作组、部门信息
     ********************************************************/
     private ActionForward locateWorkNoInYW (ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
        //得到业务代表ID
        String staffno = ((AgtmngStaffForm) form).getStaffno();
        SysDbConn aplcoms = null;
        try
        {
          //连接数据源
          aplcoms = SysConnPool.getInstance().getAplComs();

          aplcoms.preparedQuery("");

          //设置查询参数
           aplcoms.setString(1,staffno);

          //调用 SQL_AGT_QueryUnArchive 查询，得到数据集rs
          SysResultSet rs = new ResUtil(aplcoms.csCommonQuery("SQL_AGT_QueryInYW","1","-1").getResultSet());
          if (rs != null)
          {
              //定位到第一条记录
              rs.next();

           String stafforga = "";
           if ((rs.getString(2)!= null) && !(rs.getString(2).equals("")))
           {
           aplcoms.preparedQuery("");
           //获得输入参数staffno
           aplcoms.setString(1,rs.getString(2));
           //调用SQL_AGT_QueryOrga查询得到此业务代表的部门信息
           SysResultSet rs9 = aplcoms.csCommonQuery("SQL_AGT_QueryOrga","1","-1").getResultSet();
           rs9.next();
           stafforga = rs9.getString(0);
           }

              //将查询结果staffno,staffname,group,department,skill 传递给页面
              //查询业务代表所属组
              aplcoms.preparedQuery("");
              //获得输入参数staffno
              aplcoms.setString(1,staffno);
              //调用SQL_AGT_QueryAgentGroup查询，得到数据集rs3
              SysResultSet rs3 = new ResUtil(aplcoms.csCommonQuery("SQL_AGT_QueryAgentGroups","1","-1").getResultSet());
              String agentgroups = "";
              for (int i=0; i < rs3.getMetaData().getRecordCount();i++)
              {
                 rs3.setRecord(i);
                 if (i==0)
                 {
                     agentgroups = rs3.getString(0);
                 }
                 else
                 {
                     agentgroups = agentgroups + "," +rs3.getString(0);
                 }
              }

              req.setAttribute("staffno",rs.getString(0));
              req.setAttribute("staffname",rs.getString(1));
              req.setAttribute("department",stafforga);
              req.setAttribute("group",agentgroups);
              req.setAttribute("email",rs.getString(4));
              req.setAttribute("workphone",rs.getString(5));
              req.setAttribute("homephone",rs.getString(6));
              req.setAttribute("mobilephone",rs.getString(7));
              req.setAttribute("address",rs.getString(8));

               //定向到列表页面BaseArchiveAdd
              return (mapping.findForward("basearchiveadd"));
           }
           else
           {
             req.setAttribute("errorId",ErrorCode.AGTMNG_LOCATEINYW);
             return (mapping.findForward("error"));
           }
        }
      catch (SysDbException aple)
      {
        //捕获CommonService系统异常,定向到出错页面，错误码为ErrorCode.COMMONSERVICE_ERROR
          aple.printStackTrace();
          req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(java.sql.SQLException sqle)
      {
          sqle.printStackTrace();
        //捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR
          req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(Exception e)
      {
          e.printStackTrace();
        //捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR
          req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
          return (mapping.findForward("error"));
       }
      finally
        //关闭连接实例
        {
          if(aplcoms != null)
          {