clsmngoperatoraction.java

培训考试系统代码

package com.huawei.icd30.agt.clsmng;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import com.huawei.icd30.agt.util.OperatorFlagCode;
import com.huawei.icd30.common.db.*;
import com.huawei.icd30.agt.util.ErrorCode;
import com.huawei.icd30.agt.util.SuccessCode;
import com.huawei.icd30.agt.util.ClassInfo;

/**
 * <p> 本类的功能描述信息</p>
 * <p> (这家伙很懒，什么都没有写)</p>
 * <p> </p>
 * <p> </p>
 * @author 外包-高阳
 * @version 1.0
 */

public final class ClsMngOperatorAction extends Action
{
    /**
     *
     * @param mapping
     * @param form
     * @param request
     * @param response
     * @return
     */
    public ActionForward perform(ActionMapping mapping,
                                 ActionForm    form1,
                                 HttpServletRequest request,
                                 HttpServletResponse response)
    {
       //判断session是否超时
/*        ActionForward checkForword = Tools.checkSession(req,res);
       if(checkForword != null)
       {
            return checkForword;
       }
*/

        ClsMngOperatorForm form        = (ClsMngOperatorForm)form1;
        String operatorFlag            =  form.getOperatorFlag();
        operatorFlag  = operatorFlag==null?request.getParameter("operatorFlag")
                        :operatorFlag;
        //
        if( operatorFlag.equals(OperatorFlagCode.CLSMNG_SELECT))
        {
            return select(mapping ,form,request);
        }
        //
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_OPERATOR) ||
        operatorFlag.equals(OperatorFlagCode.CLSMNG_CHOOSE))
        {
            //此处判断不是null主要是为了改方法也北别的方法调用
            if(form.getSelect()!=null)
            request.getSession().setAttribute("clsmngselect",form.getSelect()[0]);
            return getAllClass(mapping ,form,request);
        }
        //
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_DETAIL))
        {
            return getDetail(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_BACK))
        {
            return select(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_MOD))
        {
            return modClass(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_ADD))
        {
            return add(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_REMOVE))
        {
            return remove(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.CLSMNG_SAVE))
        {
            return save(mapping ,form,request);
        }
        else
        {
            request.setAttribute("errorid","");
            return mapping.findForward("nomenuerror");
        }
    }

    /**
     *
     * @param mapping
     * @param form1
     * @param request
     * @return
     */
    private ActionForward add(ActionMapping mapping,
                              ClsMngOperatorForm    form,
                              HttpServletRequest request
                              )
    {
       request.setAttribute("classid",form.getClassid());
       request.setAttribute("title",form.getTitle());
       return mapping.findForward("add");
    }

    /**
        *
        * @param mapping
        * @param form1
        * @param request
        * @return
        */
       private ActionForward save(ActionMapping mapping,
                                 ClsMngOperatorForm    form,
                                 HttpServletRequest request
                                 )
       {
           SysConnPool cspool = null;
           SysDbConn con = null;
           try
           {
               cspool = SysConnPool.getInstance();
               con = cspool.getAplComs();
               con.preparedSP();
               con.setString(1,form.getFatherid());
               con.setString(2,form.getTitle());
               con.setString(3,form.getDescrible());
              SysRecord record= con.csCommonSP("P_Agt_ClsmngInSert").getParamSet();
              if(record.getInt(0)==1)
              {
                  request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
                  return mapping.findForward("nomenuerror");
              }
           }
           catch(SysDbException e)
           {
               e.printStackTrace();
               request.setAttribute("errorId",ErrorCode.CLSMNG_INSERT);
               return mapping.findForward("nomenuerror");
           }
           catch(java.sql.SQLException e)
           {
               e.printStackTrace();
               request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
               return mapping.findForward("nomenuerror");
           }
           finally
           {
               con.close();
           }
           ClassInfo.updateInfo();
           getAllClass(mapping,form,request);
           request.setAttribute("successId",SuccessCode.CLSMNG_ADD);
           return mapping.findForward("success");
    }
    /**
     *
     * @param mapping
     * @param form1
     * @param request
     * @return
     */
    private ActionForward remove(ActionMapping mapping,
                                 ClsMngOperatorForm    form,
                                 HttpServletRequest request )
    {

        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");  con.preparedQuery("");
            con.setString(1,form.getClassid());
            con.csCommonQuery("SQL_AGT_CLSMNGREMOVE","1","-1");
            request.setAttribute("successId",SuccessCode.CLSMNG_REMOVE);
            ClassInfo.updateInfo();
            getAllClass(mapping,form,request);
            return mapping.findForward("success");
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        finally
        {
            con.close();
        }
    }

    /**
     *
     * @param mapping
     * @param form1
     * @param request
     * @return
     */
    private ActionForward getDetail(ActionMapping mapping,
                                    ClsMngOperatorForm    form,
                                    HttpServletRequest request
                                    )
    {
        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");
            con.setString(1,form.getClassid());
            SysResultSet res = con.csCommonQuery("SQL_AGT_CLSMNGGETDETAIL","1","-1").getResultSet();
            while(res.next())
            {
               request.setAttribute("classid",res.getString("CLASSID"));
               request.setAttribute("fclassid",res.getString("FCLASSID"));
               request.setAttribute("title",res.getString("CLASSTITLE"));
               request.setAttribute("content",res.getString("CLASSCONTENT"));
            }
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        finally
        {
            con.close();
        }
        //request.setAttribute("successId",);
        return mapping.findForward("detail");
    }

    /**
     *
     * @param mapping
     * @param form1
     * @param request
     * @return
     */
    private ActionForward modClass( ActionMapping mapping,
                                    ClsMngOperatorForm form,
                                    HttpServletRequest request)
    {
        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");
            con.setString(1,form.getTitle());
            con.setString(2,form.getDescrible());
            con.setString(3,form.getClassid());
            con.csCommonQuery("SQL_AGT_CLSMNGMOD","1","-1");
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        finally
        {
            con.close();
        }
        request.setAttribute("successId",SuccessCode.CLSMNG_MODIFY);
        ClassInfo.updateInfo();
        getAllClass(mapping,form,request);
        return mapping.findForward("success");
    }

    /**
     *
     * @param mapping
     * @param form1
     * @param request
     * @return
     */
    private ActionForward getAllClass( ActionMapping mapping,
                                       ClsMngOperatorForm form,
                                       HttpServletRequest request)
    {

        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");
            con.setString(1,(String)request.getSession().getAttribute("clsmngselect"));
            SysResultSet res =con.csCommonQuery("SQL_AGT_CLSMNGGETALL","1","-1").getResultSet();
            request.getSession().setAttribute("CLSMNG_SELECTTYPE",res);
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        finally
        {
            con.close();
        }
         String operatorFlag            =  form.getOperatorFlag();
         if(operatorFlag.equals(OperatorFlagCode.CLSMNG_OPERATOR))
         {
            return mapping.findForward("operator");
         }
         else
         {
             return mapping.findForward("publicsclass");
         }

    }

    /**
     *
     * @param mapping
     * @param form
     * @param request
     * @return
     */
    private ActionForward select( ActionMapping mapping,
                                  ClsMngOperatorForm form,
                                  HttpServletRequest request)
    {
        SysConnPool cspool = null;
        SysDbConn con      = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con    = cspool.getAplComs();
            con.preparedQuery("");
            SysResultSet res = con.csCommonQuery("SQL_AGT_CLSMNSELECT","1","-1").getResultSet();
            request.getSession().setAttribute("CLSMNG_SESECTRES",res);
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            request.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return mapping.findForward("nomenuerror");
        }
        catch(Exception e)
        {
            //捕获未知异常,定向到出错页面
            e.printStackTrace(System.err);
            request.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
            return mapping.findForward("nomenuerror");
        }



        finally
        {
            con.close();
        }
        return mapping.findForward("select");
    }

    private void log(String mes)
    {
        System.out.println(mes);
    }
}