examclassaction.java

培训考试系统代码

package com.huawei.icd30.agt.configmng;

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>
 * @author 龙燕茜
 * @version 1.0
 */

public class ExamClassAction extends Action
{

    public ActionForward perform(ActionMapping mapping,
           ActionForm form, HttpServletRequest req,
           HttpServletResponse res)
    {
         //获取操作类型

        String opeType = ((ExamClassForm)form).getOpeType();//从form中获取

        if(opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_ADD))
        {
             return addExamClass(mapping,form,req,res);
        }
        else if(opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_MOD))
        {
             return modExamClass(mapping,form,req,res);
        }
        else if(opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_DEL))
        {
             return delExamClass(mapping,form,req,res);
        }
        else if(opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_QUERY))
        {
             return queryExamClass(mapping,form,req,res);
        }
        else if(opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_QUERY_DETAIL)
          || opeType.equalsIgnoreCase(OperatorFlagCode.EXAMCLASS_MOD_SHOW)
        )
        {
             return queryDetailExamClass(mapping,form,req,res);
        }
        else
        {//操作类型错误,定向到错误页面,
             req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
             return (mapping.findForward("error"));
        }

    }

     /**
     * 增加操作
     */
    private ActionForward addExamClass(ActionMapping mapping,
           ActionForm form, HttpServletRequest req,
           HttpServletResponse res)
    {

       //从PolicyFrom中获取数据
       String title = ((ExamClassForm)form).getTitle();

       //IP集合，之间以"#"号分割
       String[] ipaddress1 = ((ExamClassForm)form).getIpaddress1();
       String ipaddress1Set = Tools.getStringSet(ipaddress1);

       String[] ipaddress2 = ((ExamClassForm)form).getIpaddress2();
       String ipaddress2Set = Tools.getStringSet(ipaddress2);

       String[] ipaddress3 = ((ExamClassForm)form).getIpaddress3();
       String ipaddress3Set = Tools.getStringSet(ipaddress3);

       String[] ipaddress4 = ((ExamClassForm)form).getIpaddress4();
       String ipaddress4Set = Tools.getStringSet(ipaddress4);

       //定义连接的实例
       SysDbConn aplcoms = null;
       try
       {
           //得到一个连接的实例
           aplcoms = SysConnPool.getInstance().getAplComs();

           //调用存储过程P_Agt_ExamClassAdd完成添加
           aplcoms.preparedSP();
           aplcoms.setString(1 ,title);
           aplcoms.setString(2 ,ipaddress1Set);
           aplcoms.setString(3 ,ipaddress2Set);
           aplcoms.setString(4 ,ipaddress3Set);
           aplcoms.setString(5 ,ipaddress4Set);

           SysDataSet ds = aplcoms.csCommonSP("P_Agt_ExamClassAdd");
           SysRecord rc = ds.getParamSet() ;
           if(rc!=null && rc.getInt(0) == OperatorFlagCode.OPERATOR_SUCCESS)
           {//添加成功
                //定向到成功页面，
                req.setAttribute("successId",SuccessCode.EXAMCLASS_ADD_SUCCESS);
                return (mapping.findForward("success"));
           }
           else
           {//添加失败
               //定向到错误页面
               req.setAttribute("errorId",ErrorCode.EXAMCLASS_ADD_ERROR);
               return (mapping.findForward("error"));
           }
       }
       catch (SysDbException aple)
       {//捕获CommonService系统异常,定向到出错页面
           //输出异常信息
           aple.printStackTrace();
           req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
           return (mapping.findForward("error"));
       }
       catch(java.sql.SQLException sqle)
       {//捕获调用aplcoms异常,定向到出错页面
           // 输出异常信息
           sqle.printStackTrace();
           req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
           return (mapping.findForward("error"));
       }
       catch(Exception e)
       {//捕获未知异常,定向到出错页面
           //输出异常信息
           e.printStackTrace();
           req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
           return (mapping.findForward("error"));
       }
       finally
       {//关闭连接实例
           if(aplcoms != null)
           {
              aplcoms.close();
           }
       }
    }

 /**
     * 修改策略操作
     */
    private ActionForward modExamClass(ActionMapping mapping,
           ActionForm form, HttpServletRequest req,
           HttpServletResponse res)
    {

        //IP集合，之间以"#"号分割
       String[] ipaddress1 = ((ExamClassForm)form).getIpaddress1();
       String ipaddress1Set = Tools.getStringSet(ipaddress1);

       String[] ipaddress2 = ((ExamClassForm)form).getIpaddress2();
       String ipaddress2Set = Tools.getStringSet(ipaddress2);

       String[] ipaddress3 = ((ExamClassForm)form).getIpaddress3();
       String ipaddress3Set = Tools.getStringSet(ipaddress3);

       String[] ipaddress4 = ((ExamClassForm)form).getIpaddress4();
       String ipaddress4Set = Tools.getStringSet(ipaddress4);

       String examClassId = ((ExamClassForm)form).getExamClassId();
       String title = ((ExamClassForm)form).getTitle();
       //定义连接的实例
       SysDbConn aplcoms = null;
       try
       {

           //得到一个连接的实例
           aplcoms = SysConnPool.getInstance().getAplComs();

           //调用存储过程
           aplcoms.preparedSP();
           aplcoms.setString(1 ,examClassId);
           aplcoms.setString(2 ,title);
           aplcoms.setString(3 ,ipaddress1Set);
           aplcoms.setString(4 ,ipaddress2Set);
           aplcoms.setString(5 ,ipaddress3Set);
           aplcoms.setString(6 ,ipaddress4Set);


           SysDataSet ds = aplcoms.csCommonSP("P_Agt_ExamClassMod");
           SysRecord rc = ds.getParamSet() ;
           if(rc ==null || rc.getInt(0) == OperatorFlagCode.OPERATOR_EORROR)
           {//修改失败
               //定向到错误页面
               req.setAttribute("errorId",ErrorCode.EXAMCLASS_MOD_ERROR);
               return (mapping.findForward("error"));
           }
           //调用queryPolicy函数进行重新查询后返回到列表页面
           return queryExamClass(mapping,form,req,res);
       }
       catch (SysDbException aple)
       {//捕获CommonService系统异常,定向到出错页面
           //输出异常信息
           aple.printStackTrace();
           req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
           return (mapping.findForward("error"));
       }
       catch(java.sql.SQLException sqle)
       {//捕获调用aplcoms异常,定向到出错页面
           // 输出异常信息
           sqle.printStackTrace();
           req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
           return (mapping.findForward("error"));
       }
       catch(Exception e)
       {//捕获未知异常,定向到出错页面
           //输出异常信息
           e.printStackTrace();
           req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
           return (mapping.findForward("error"));
       }
       finally
       {//关闭连接实例
           if(aplcoms != null)
           {
              aplcoms.close();
           }
       }
    }

  /**
     * 删除操作
     */
    private ActionForward delExamClass(ActionMapping mapping,
           ActionForm form, HttpServletRequest req,
           HttpServletResponse res)
    {

       //从From中获取ID号