mertmngoperatoraction.java

培训考试系统代码

package com.huawei.icd30.agt.mertmng;

import org.apache.struts.action.Action;
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.*;
import org.apache.struts.upload.FormFile;
import java.io.*;
import com.huawei.icd30.common.systemconfig.*;
import java.util.*;

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

public class MertMngOperatorAction
    extends Action {

  /**
   *
   * @param mapping
   * @param form1
   * @param request
   * @param response
   * @return
   */
  public ActionForward perform(ActionMapping mapping,
                               ActionForm form1,
                               HttpServletRequest request,
                               HttpServletResponse response) {
    log("begin clsmngaction now .......");
    MertMngOperatorForm form = (MertMngOperatorForm) form1;
    String operatorFlag = form.getOperatorFlag();
    log(operatorFlag + "operatorFlag");

    operatorFlag = operatorFlag == null ? request.getParameter("operatorFlag")
        : operatorFlag;
    //System.out.println("operatorFlag is ::" + operatorFlag);

    if (operatorFlag.equals(OperatorFlagCode.MERT_UP)) {
      return up(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_AUTH) ||
             operatorFlag.equals(OperatorFlagCode.MERT_AUTHMOD)) {
      return auth(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_SEARCH)
          || operatorFlag.equals(OperatorFlagCode.MERT_SEARCH_FORLESSON) ) {
      return search(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_MOD) ||
             operatorFlag.equals(OperatorFlagCode.MERT_VIEW)) {
      return modify(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_SAVE)) {
      return save(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_DELET)) {
      return remove(mapping, form, request);
    }
    else if (operatorFlag.equals(OperatorFlagCode.MERT_TYPELIST) ||
        operatorFlag.equals(OperatorFlagCode.MERT_TYPELIST_STUDY)) {
      return typelist(mapping, form, request);
    }
    ///:huangyuyuan add 2004-06-15
    else if (operatorFlag.equals(OperatorFlagCode.MERT_SELECTED) ||
        operatorFlag.equals(OperatorFlagCode.MERT_SELECTED_SUBMIT))
    {//选择不同页面的资料
        return mertSelected(mapping, form, request,response,operatorFlag);
    }
    ///:~

    return null;
  }

  /**
   * 资料上传功能
   * @param mapping
   * @param form
   * @param req
   * @return
   */
  private ActionForward up(ActionMapping mapping,
                           MertMngOperatorForm form,
                           HttpServletRequest req) {
/*    log("up now ....");
    SysConnPool cspool = null;
    SysDbConn con = null;
    HttpSession session = req.getSession();
    //顶\uFFFD\uFFFD目录应该可以配置,此处有问题,要求保证目录的层次结构,必须
    //两位做一个目录,目的是文件按照目录检索的时候
    String path = "resource" + File.separator + form.getClassId();
    path = servlet.getServletContext().getRealPath(path);
    try
    {
      cspool = SysConnPool.getInstance();
      con = cspool.getAplComs();
      con.preparedSP();
      con.setString(1, form.getTitle());
      con.setString(2, form.getKeyWord());
      con.setString(3, form.getAbstracts());
      con.setString(4, form.getClassType());
      con.setString(5, path + File.separator + form.getTheFile().getFileName());
      con.setString(6, form.getClassId());
      con.setString(7, form.getAuthInfo());
      con.setString(8, form.getStaffNoInfo());

      log(form.getTitle() + ":1");
      log(form.getKeyWord() + ":2");
      log(form.getAbstracts() + ":3");
      log(form.getClassType() + ":4");
      log(path + File.separator + form.getTheFile().getFileName() + ":5");
      log(form.getClassId() + ":6");
      log(form.getAuthInfo() + ":7");
      log(form.getStaffNoInfo() + ":8");

      SysRecord res = con.csCommonSP("P_Agt_MaterUp").getParamSet();
      if (res.getInt(0) != 0)
      {
        req.setAttribute("errorId", ErrorCode.MERT_UP);
        return servlet.findForward("error");
      }
    }
    catch (SysDbException e)
    {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.COMMONSERVICE_ERROR);
      return servlet.findForward("error");
    }
    catch (java.sql.SQLException e)
    {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.DATABASE_ERROR);
      return servlet.findForward("error");
    }
    finally
    {
      con.close();
    }
    try
    {
      upfile(form.getTheFile(), path);
    }
    catch (FileNotFoundException fn)
    {
      fn.printStackTrace();
      req.setAttribute("errorId", ErrorCode.FILE_NOTFOUND_EORROR);
      return servlet.findForward("error");
    }
    catch (IOException io)
    {
      io.printStackTrace();
      req.setAttribute("errorId", ErrorCode.FILE_EORROR);
      return servlet.findForward("error");
    }

    try
    {
       if (form.getisKbs().equals("1"))
       {
          String name = form.getTheFile().getFileName();
          String cityId = "00";

          FtpDown ftp = new FtpDown(cityId);

          String kbsIp = Initor.systemConfig.get("agt/kbsIp","100.100.100.100");
          String kbsUser = Initor.systemConfig.get("agt/kbsUser","guest");
          String kbsPasswd = Initor.systemConfig.get("agt/kbsPasswd","0");
          if(!(ftp.isLogon(kbsIp, kbsUser,kbsPasswd)))
          {
                req.setAttribute("errorId", ErrorCode.MERT_LOGIN_KBS);
                return servlet.findForward("error");
          }

          String localFile = path + "/" + name;
          String remoteFile = " /export/home0/long/icdagt/" + name;
          String pa = "00/0/业务代表/" + name;

          ftp.upload(localFile, remoteFile);

          try
          {
             cspool = SysConnPool.getInstance();
             con = cspool.getAplComs();
             con.preparedSP();
             con.setString(1, cityId);
             con.setString(2, "0");
             con.setString(3, name);
             con.setString(4, "1");
             con.setString(5, "/");
             SysRecord re = con.csCommonSP("p_agt_kbsinsert").getParamSet();
             if (re.getInt(0) != 0)
             {
                req.setAttribute("errorId", ErrorCode.MERT_INSERT_KBS);
                return servlet.findForward("error");
             }
           }
           catch (SysDbException e)
           {
                e.printStackTrace();
                req.setAttribute("errorId", ErrorCode.COMMONSERVICE_ERROR);
                return servlet.findForward("error");
           }
           catch (java.sql.SQLException e)
           {
                e.printStackTrace();
                req.setAttribute("errorId", ErrorCode.DATABASE_ERROR);
                return servlet.findForward("error");
           }
           catch (Exception e)
           {
               e.printStackTrace();
           }
           finally
           {
               con.close();
           }
         }
        }
        catch (Exception e)
        {
           e.printStackTrace();
           req.setAttribute("errorId", ErrorCode.MERT_UPTO_KBS);
           return servlet.findForward("error");
        }
*/      System.out.println("资料上："+SuccessCode.MERTMNG_UP);
        req.setAttribute("successId", SuccessCode.MERTMNG_UP);
        return mapping.findForward("up");
  }

  /**
   * 资料查找功能
   * @param mapping
   * @param form
   * @param req
   * @return
   */
  private ActionForward search(ActionMapping mapping,
                               MertMngOperatorForm form,
                               HttpServletRequest req) {
    log("search now ....");

    String opeFlag = form.getOperatorFlag();
    SysConnPool cspool = null;
    SysDbConn con = null;
    //顶\uFFFD\uFFFD目录应该可以配置
    try {

      cspool = SysConnPool.getInstance();
      con = cspool.getAplComs();
      String searchSQL = form.getSearchSQL();

      String staffno = (String)req.getSession().getAttribute("staffno");
      if("1".equalsIgnoreCase(req.getParameter("studyType")))
      {//课程学习根据权限进行显示
         searchSQL += "and matid in (select matid from t_agt_matrailauth where (auth='0' and staffno='0') or (staffno='" + staffno + "'))";
      }


      log(searchSQL);
      con.preparedQuery(searchSQL);
      SysResultSet res = con.csCommonQuery("SELF_SQL_MaterUp", "1", "-1").getResultSet();
      //System.out.println("seach ok");
      req.setAttribute("searchSQL", searchSQL);
      if(opeFlag.equalsIgnoreCase(OperatorFlagCode.MERT_SEARCH_FORLESSON))
      {

          req.getSession().setAttribute("MERT_SEARCHFORLESSON_RES", new ResUtil(res));
          return mapping.findForward("selectmertlist");
      }
      else
      {
          req.getSession().setAttribute("MERT_SEARCH_RES", new ResUtil(res));
          return mapping.findForward("result");
      }
    }
    catch (SysDbException e) {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.COMMONSERVICE_ERROR);
      return servlet.findForward("error");
    }
    catch (java.sql.SQLException e) {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.DATABASE_ERROR);
      return servlet.findForward("error");
    }
    finally {
      con.close();
    }

  }

  /**
   * 按照类别查询
   * @param mapping
   * @param form
   * @param req
   * @return
   */
  private ActionForward typelist(ActionMapping mapping,
                                 MertMngOperatorForm form1,
                                 HttpServletRequest req) {
    MertMngOperatorForm form = (MertMngOperatorForm) form1;
    String operatorFlag = form.getOperatorFlag();
    log("typeList now ....");
    SysConnPool cspool = null;
    SysDbConn con = null;
    String classid = req.getParameter("classIdTerm");
    //顶\uFFFD\uFFFD目录应该可以配置
    try {
      cspool = SysConnPool.getInstance();
      con = cspool.getAplComs();
      SysResultSet res = null;
      if(operatorFlag.equalsIgnoreCase(OperatorFlagCode.MERT_TYPELIST_STUDY))
      {
        con.preparedQuery("");
        con.setString(1, classid);
        con.setString(2 ,(String)req.getSession().getAttribute("staffno"));
        res = con.csCommonQuery("SQL_AGT_MertmngTypeStudy" ,"1" ,"-1").getResultSet();
      }
      else
      {
         con.preparedSP();
         con.setString(1, classid);
         res = con.csCommonSP("p_agt_mertmngtype").getResultSet();
      }
      req.getSession().setAttribute("MERT_TYPELIST_RES", new ResUtil(res));
    }
    catch (SysDbException e) {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.COMMONSERVICE_ERROR);
      return servlet.findForward("error");
    }
    catch (java.sql.SQLException e) {
      e.printStackTrace();
      req.setAttribute("errorId", ErrorCode.DATABASE_ERROR);
      return servlet.findForward("error");
    }
    finally {
      con.close();
    }
    req.setAttribute("successId", SuccessCode.CLSMNG_ADD);
    return mapping.findForward("typelist");

  }

  /**
   * 资料文件上传功能
   * @param file
   * @param path
   * @throws FileNotFoundException