classgetaction.java

培训考试系统代码

package com.huawei.icd30.agt.clsmng;

import java.util.Random;
import java.util.ArrayList;
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> 根据类别ID号获取该类别的子类别类。</p>
 * <p> </p>
 * <p> </p>
 * @author 龙燕茜
 * @version 1.0
 */


public class ClassGetAction extends Action
{

    public ActionForward perform(ActionMapping mapping,
           ActionForm form, HttpServletRequest req,
           HttpServletResponse res)
    {
        //判断session是否超时
/*        ActionForward checkForword = Tools.checkSession(req,res);
        if(checkForword != null)
        {
             return checkForword;
        }
*/
       //从ClsMngOperatorForm中获取class的ID号
       String classID = req.getParameter("classID");

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

           //根据试卷ID号，从数据库中获取试卷的详细信息
           aplcoms.preparedQuery("");
           aplcoms.setString(1 ,classID);

           SysResultSet rs1 = aplcoms.csCommonQuery("SQL_Agt_ClsMngGetList" ,"1" ,"-1").getResultSet();

           //以把结果集存放到传到页面去
           req.setAttribute("CLSMNG-GET-LIST",rs1);

           //取该类别的父类别
           ArrayList fClassIdArr = new ArrayList();
           ArrayList fClassNameArr = new ArrayList();
           aplcoms.preparedQuery("");
           SysResultSet rs2 = aplcoms.csCommonQuery("SQL_Agt_ClsMngGetAllList" ,"1" ,"-1").getResultSet();
           if(rs2 != null)
           {
               for(int i=0;i<classID.length()/2;i++)
               {
                  for(int j=0;rs2.setRecord(j)&&(j<rs2.getMetaData().getRecordCount());j++)
                  {
                     if((rs2.getString(0)).equalsIgnoreCase(classID.substring(0,2*(i+1))))
                     {
                        fClassIdArr.add(rs2.getString(0));
                        fClassNameArr.add(rs2.getString(1));
                        break;
                     }
                  }
               }
           }

           //以把父类别信息传到页面去
           req.setAttribute("F-CLASSID-ARR",fClassIdArr);
           req.setAttribute("F-CLASSNAME-ARR",fClassNameArr);

           //定向
           return (mapping.findForward("chooseclass"));

       }
       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();
           }
       }

    }
}