trnmngaction.java

培训考试系统代码

package com.huawei.icd30.agt.trnmng;

import javax.servlet.http.*;

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 TrnmngAction extends Action
{
      public ActionForward perform(ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
        // 检查session是否超时
  //       ActionForward checkForword = Tools.checkSession(req,res);
 //        得到操作标识operatorflag
        String operatorflag = ((TrnmngForm) form).getOperatorflag();
        /* 根据查询条件查询业务代表培训档案人员列表 */
        if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYLESSONSTAFF"))
        {
             return queryLessonStaffList(mapping, form, req, res);
        }
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYTESTSTAFF"))
        {
             return queryTestStaffList(mapping, form, req, res);
        }
       //查询登录业务代表的个人培训档案列表
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYLESSONDETAIL1"))
        {
             ((TrnmngForm)form).setStaffno(req.getSession().getAttribute("staffno").toString());
             return queryLessonArchive(mapping,form,req,res);
        }
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYTESTDETAIL1"))
        {
             ((TrnmngForm)form).setStaffno(req.getSession().getAttribute("staffno").toString());
             return queryTestArchive(mapping,form,req,res);
        }
       //查询培训档案个人列表
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYLESSONDETAIL"))
        {
             return queryLessonArchive(mapping,form,req,res);
        }
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYTESTDETAIL"))
        {
             return queryTestArchive(mapping,form,req,res);
        }
        //查询培训档案详细信息
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYALESSON")||
                 operatorflag.equalsIgnoreCase("TRNMNG_QUERYALESSON_VIEW"))
        {
             return queryALesson(mapping,form,req,res);
        }
        else if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYATEST")||
                 operatorflag.equalsIgnoreCase("TRNMNG_QUERYATEST_VIEW"))
        {
             return queryATest(mapping,form,req,res);
        }

        //新增培训档案
        else if (operatorflag.equalsIgnoreCase("TRN_TRNADD_LESSON"))
        {
             return newLessonArchive(mapping, form, req, res);
        }
        else if (operatorflag.equalsIgnoreCase("TRN_TRNADD_TEST"))
        {
             return newTestArchive(mapping, form, req, res);
        }

        //修改培训档案
         else if (operatorflag.equalsIgnoreCase("TRN_TRNMOD_LESSON"))
        {
             return modLessonArchive(mapping, form, req, res);
        }
          else if (operatorflag.equalsIgnoreCase("TRN_TRNMOD_TEST"))
        {
             return modTestArchive(mapping, form, req, res);
        }

        //根据业务代表ID删除培训档案
        else if (operatorflag.equalsIgnoreCase("TRN_TRNDELBYLESSONID"))
        {
             return delByLessonID(mapping, form, req, res);
        }
        else if (operatorflag.equalsIgnoreCase("TRN_TRNDELBYTESTID"))
        {
             return delByTestID(mapping, form, req, res);
        }
        //根据培训档案ID删除培训档案
        else if (operatorflag.equalsIgnoreCase("TRN_LESSONDELBYSTAFFNO"))
        {
             return delLessonByStaff(mapping, form, req, res);
        }

        else if (operatorflag.equalsIgnoreCase("TRN_TESTDELBYSTAFFNO"))
        {
             return delTestByStaff(mapping, form, req, res);
        }
        //转到错误页面，错误码 ErrorCode.unKnownError;
          else
          {
             req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
             return(mapping.findForward("error"));
          }

    }
        /****************************************************
         *根据查询条件查询课程档案人员列表
         ****************************************************/
       private ActionForward queryLessonStaffList (ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
       //得到业务代表ID、姓名、组别、部门
       String staffno = ((TrnmngForm) form).getStaffno();
       String staffname = ((TrnmngForm) form).getStaffname();
       String group = ((TrnmngForm) form).getGroup();
       String department = ((TrnmngForm) form).getDepartment();
       String skill = ((TrnmngForm) form).getSkill();
       SysDbConn aplcoms = null ;
       try
       {
           //连接数据源
           aplcoms = SysConnPool.getInstance().getAplComs();
           aplcoms.preparedSP();

           //获得输入参数staffno、staffname、group、department、skill
           aplcoms.setString(1,staffno);
           aplcoms.setString(2,staffname);
           aplcoms.setString(3,group);
           aplcoms.setString(4,department);
           aplcoms.setString(5,skill);

           //调用P_Agt_TrnStaffSearch查询，得到数据集rs1
           SysResultSet rs1 = aplcoms.csCommonSP("P_Agt_LessonStaffSearch").getResultSet();
           rs1.next();
           aplcoms.preparedQuery(rs1.getString(1));
           SysResultSet rs2 = aplcoms.csCommonQuery("SELFSQL","1","-1").getResultSet();
           //if (rs 不为空)
           if (rs2 != null)
           {
            //按业务代表ID排序
            rs2.sort(0,true);
            //将结果集放到session中 AGTMNG-STAFFLIST
            req.getSession().setAttribute("TRNMNG-LESSONSTAFFLIST",new ResUtil(rs2));

           //将输入的查询条件传递给页面
            req.setAttribute("staffno",staffno);
            req.setAttribute("staffname",staffname);
            req.setAttribute("group",group);
            req.setAttribute("department",department);
            req.setAttribute("skill",skill);
           //定向到列表页面TrnStaffList
            return (mapping.findForward("lessonstafflist"));
           }
           else
           {
             req.setAttribute("errorId",ErrorCode.TRNMNG_SEARCHSTAFF);
             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)
      {
        //捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR

          req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(Exception e)
      {
        //捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR

          req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
          return (mapping.findForward("error"));
       }
      finally
        //关闭连接实例
        {
          if(aplcoms != null)
          {
             aplcoms.close();
          }
        }
    }
        /****************************************************
         *根据查询条件查询考试培训档案人员列表
         ****************************************************/
       private ActionForward queryTestStaffList (ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
       //得到业务代表ID、姓名、组别、部门
       String staffno = ((TrnmngForm) form).getStaffno();
       String staffname = ((TrnmngForm) form).getStaffname();
       String group = ((TrnmngForm) form).getGroup();
       String department = ((TrnmngForm) form).getDepartment();
       String skill = ((TrnmngForm) form).getSkill();
       SysDbConn aplcoms = null ;
       try
       {
           //连接数据源
           aplcoms = SysConnPool.getInstance().getAplComs();
           aplcoms.preparedSP();

           //获得输入参数staffno、staffname、group、department、skill
           aplcoms.setString(1,staffno);
           aplcoms.setString(2,staffname);
           aplcoms.setString(3,group);
           aplcoms.setString(4,department);
           aplcoms.setString(5,skill);

           //调用P_Agt_TrnStaffSearch查询，得到数据集rs1
           SysResultSet rs1 = aplcoms.csCommonSP("P_Agt_TestStaffSearch").getResultSet();
           rs1.next();
           aplcoms.preparedQuery(rs1.getString(1));
           SysResultSet rs2 = aplcoms.csCommonQuery("SELFSQL","1","-1").getResultSet();
           //if (rs 不为空)
           if (rs2 != null)
           {
            //按业务代表ID排序
            rs2.sort(0,true);
            //将结果集放到session中 AGTMNG-STAFFLIST
            req.getSession().setAttribute("TRNMNG-TESTSTAFFLIST",new ResUtil(rs2));

           //将输入的查询条件传递给页面
            req.setAttribute("staffno",staffno);
            req.setAttribute("staffname",staffname);
            req.setAttribute("group",group);
            req.setAttribute("department",department);
            req.setAttribute("skill",skill);
           //定向到列表页面TrnStaffList
            return (mapping.findForward("teststafflist"));
           }
           else
           {
             req.setAttribute("errorId",ErrorCode.TRNMNG_SEARCHSTAFF);
             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)
      {
        //捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR

          req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
          return (mapping.findForward("error"));
       }
      catch(Exception e)
      {
        //捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR

          req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
          return (mapping.findForward("error"));
       }
      finally
        //关闭连接实例
        {
          if(aplcoms != null)
          {
             aplcoms.close();
          }
        }
    }
        /****************************************************
         *根据业务代表ID查询个人课程培训档案列表
         ****************************************************/
       private ActionForward queryLessonArchive (ActionMapping mapping,
       ActionForm form, HttpServletRequest req,
        HttpServletResponse res)
    {
      String staffno = ((TrnmngForm) form).getStaffno();
      String operatorflag = ((TrnmngForm) form).getOperatorflag();
      SysDbConn aplcoms = null ;
       try
       {
           //连接数据源
           aplcoms = SysConnPool.getInstance().getAplComs();
           aplcoms.preparedQuery("");
           //设置查询参数
           aplcoms.setString(1,staffno);

          //调用 SQL_AGT_QueryUnArchive 查询，得到数据集rs
          SysResultSet rs1 = new ResUtil(aplcoms.csCommonQuery("SQL_AGT_QueryInYW","1","-1").getResultSet());
         //定位到第一条记录
           if (rs1 != null&& rs1.getMetaData().getRecordCount()!=0)
           {
           rs1.next();
           String stafforga = "";
           if ((rs1.getString(2)!= null) && !(rs1.getString(2).equals("")))
           {
           aplcoms.preparedQuery("");
           //获得输入参数staffno
           aplcoms.setString(1,rs1.getString(2));
           //调用SQL_AGT_QueryOrga查询得到此业务代表的部门信息
           SysResultSet rs9 = aplcoms.csCommonQuery("SQL_AGT_QueryOrga","1","-1").getResultSet();
           rs9.next();
           stafforga = rs9.getString(0);
           }

           //查询业务代表技能
           aplcoms.preparedQuery("");
           //获得输入参数staffno
           aplcoms.setString(1,staffno);
           //调用SQL_AGT_QueryTRNArchive查询得到此业务代表的培训档案列表
           SysResultSet rs3 = aplcoms.csCommonQuery("SQL_AGT_QueryAgentSkill","1","-1").getResultSet();
           //查询业务代表班组
           aplcoms.preparedQuery("");
           //获得输入参数staffno
           aplcoms.setString(1,staffno);
           //调用SQL_AGT_QueryAgentGroup查询，得到数据集rs3
           SysResultSet rs4 = new ResUtil(aplcoms.csCommonQuery("SQL_AGT_QueryAgentGroups","1","-1").getResultSet());

           aplcoms.preparedQuery("");
           //获得输入参数staffno
           aplcoms.setString(1,staffno);
           //调用SQL_AGT_QueryTRNArchive查询得到此业务代表的培训档案列表
           SysResultSet rs2 = aplcoms.csCommonQuery("SQL_AGT_QueryLessonArchive","1","-1").getResultSet();
          //if (rs 不为空)
           //if (rs2 != null&& rs2.getMetaData().getRecordCount()!=0)
           if (rs2 != null)
           {
            //按培训档案ID排序
           // rs2.sort(3,true);
            //将结果集放到session中 TRNMNG-TRNLIST
            req.getSession().setAttribute("TRNMNG-LESSONLIST",new ResUtil(rs2));

            req.setAttribute("staffno",rs1.getString(0));
            req.setAttribute("staffname",rs1.getString(1));
            req.setAttribute("department",stafforga);
              //业务代表所属组
             String agentgroups = "";
             if ( rs4 != null && rs4.getMetaData().getRecordCount()!=0)
              {
               for (int i=0; i < rs4.getMetaData().getRecordCount();i++)
              {
                 rs4.setRecord(i);
                 if (i==0)
                 {
                     agentgroups = rs4.getString(0);
                 }
                 else
                 {
                     agentgroups = agentgroups + "," +rs4.getString(0);
                 }
              }
              }
              req.setAttribute("group",agentgroups);
              String rsSkill = "";
              if ( rs3 != null && rs3.getMetaData().getRecordCount()!=0)
              {

                 for(int i = 0; i < rs3.getMetaData().getRecordCount(); i++)
                 {
                     rs3.setRecord(i);
                     if (rsSkill == "")
                     {
                          rsSkill = rs3.getString(0);
                     }
                     else
                     {
                          rsSkill = rsSkill + "," + rs3.getString(0);
                     }
                 }
              }
              req.setAttribute("skill",rsSkill);

              //定向到列表页面
              if (operatorflag.equalsIgnoreCase("TRNMNG_QUERYLESSONDETAIL1"))
              {