Ejemplo n.º 1
0
 private ActionForward searchSt(
     ActionMapping mapping,
     ActionForm form,
     HttpServletRequest request,
     HttpServletResponse response) {
   try {
     request.setCharacterEncoding("utf-8");
     response.setCharacterEncoding("utf-8");
     String path = request.getContextPath();
     HashMap mapPara = GetParam.GetParamValue(request, "ISO-8859-1", "utf-8");
     String SCORE_GRADE_S = mapPara.get("SCORE_GRADE").toString();
     String SCORE_CLASS_S = mapPara.get("SCORE_CLASS").toString();
     String STU_NAME_S = mapPara.get("STU_NAME").toString();
     String condition = "";
     condition += CommonFun.pinCondition("SCORE_GRADE", SCORE_GRADE_S, "", "varchardeng");
     condition += CommonFun.pinCondition("SCORE_CLASS", SCORE_CLASS_S, "", "varchardeng");
     condition += CommonFun.pinCondition("STU_NAME", STU_NAME_S, "", "varchardeng");
     if (!condition.equals("")) {
       condition = "WHERE " + condition.substring(0, condition.length() - 4);
     }
     ScoreManagementDAO dao = new ScoreManagementDAO();
     mapPara.put("condition", condition);
     List stList = dao.searchStList(mapPara);
     String json = "";
     if (stList != null && stList.size() > 0) {
       json = "[";
       for (int i = 0; i < stList.size(); i++) {
         json +=
             "{\"SCORE_NO\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_NO").toString())
                 + "\",";
         json +=
             "\"SCORE_GRADE\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_GRADE").toString())
                 + "\",";
         json +=
             "\"SCORE_CLASS\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_CLASS").toString())
                 + "\",";
         json +=
             "\"STU_SEX\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("STU_SEX").toString())
                 + "\",";
         json +=
             "\"STU_NAME\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("STU_NAME").toString())
                 + "\"},";
       }
       json = json.substring(0, json.length() - 1) + "]";
     } else {
       json = "[]";
     }
     response.getWriter().write(json);
     response.getWriter().close();
   } catch (Exception e) {
     e.printStackTrace();
   }
   return null;
 }
Ejemplo n.º 2
0
  private ActionForward searchScore(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) {
    try {
      request.setCharacterEncoding("utf-8");
      response.setCharacterEncoding("utf-8");
      String path = request.getContextPath();
      HashMap mapPara = GetParam.GetParamValue(request, "ISO-8859-1", "utf-8");
      // System.out.println(mapPara);
      mapPara.put("rp", Integer.parseInt(mapPara.get("rp").toString()));
      mapPara.put(
          "page",
          (Integer.parseInt(mapPara.get("page").toString()) - 1)
              * Integer.parseInt(mapPara.get("rp").toString()));
      String condition = "";
      String SCORE_YEAR_S = mapPara.get("SCORE_YEAR_S").toString();
      String SEMESTER_S = mapPara.get("SEMESTER_S").toString();
      String KEMU_S = mapPara.get("KEMU_S").toString();
      String SCORE_CLASS_S = mapPara.get("SCORE_CLASS_S").toString();
      String STU_NAME_S = mapPara.get("STU_NAME_S").toString();
      condition += CommonFun.pinCondition("SCORE_YEAR", SCORE_YEAR_S, "", "varchardeng");
      condition += CommonFun.pinCondition("SEMESTER", SEMESTER_S, "", "varchardeng");
      condition += CommonFun.pinCondition("KEMU", KEMU_S, "", "varchardeng");
      condition += CommonFun.pinCondition("SCORE_CLASS", SCORE_CLASS_S, "", "varchardeng");
      condition += CommonFun.pinCondition("STU_NAME", STU_NAME_S, "", "varchar");
      if (!condition.equals("")) {
        condition = "WHERE " + condition.substring(0, condition.length() - 4);
      }
      mapPara.put("condition", condition);
      CommonFun fun = new CommonFun();
      ScoreManagementDAO dao = new ScoreManagementDAO();
      int total = fun.getTotalItem("SELECT COUNT(*) AS CON FROM score " + condition);
      String json = "";
      int a = Integer.parseInt(mapPara.get("page").toString()) + 1;
      int b = Integer.parseInt(mapPara.get("rp").toString());
      int page = a / b;
      page = page + 1;
      List list = dao.searchScoreList(mapPara);
      if (list != null && list.size() > 0) {
        json += "{\"page\":" + page + ",\"total\":" + total + ",\"rows\":[";
        for (int i = 0; i < list.size(); i++) {
          String ID = exchange.toHtml(((HashMap) list.get(i)).get("ID").toString());
          String SCORE_YEAR = exchange.toHtml(((HashMap) list.get(i)).get("SCORE_YEAR").toString());
          String SEMESTER = exchange.toHtml(((HashMap) list.get(i)).get("SEMESTER").toString());
          String SCORE_GRADE =
              exchange.toHtml(((HashMap) list.get(i)).get("SCORE_GRADE").toString());
          String SCORE_CLASS =
              exchange.toHtml(((HashMap) list.get(i)).get("SCORE_CLASS").toString());
          String SCORE_NO = exchange.toHtml(((HashMap) list.get(i)).get("SCORE_NO").toString());
          String STU_NAME = exchange.toHtml(((HashMap) list.get(i)).get("STU_NAME").toString());
          String STU_SEX = exchange.toHtml(((HashMap) list.get(i)).get("STU_SEX").toString());
          String AAS = exchange.toHtml(((HashMap) list.get(i)).get("AAS").toString());
          String KEMU = exchange.toHtml(((HashMap) list.get(i)).get("KEMU").toString());
          String CHINESE = exchange.toHtml(((HashMap) list.get(i)).get("CHINESE").toString());
          String KEMATCH = exchange.toHtml(((HashMap) list.get(i)).get("KEMATCH").toString());
          String ENGLISH = exchange.toHtml(((HashMap) list.get(i)).get("ENGLISH").toString());
          String PHYSICAL = exchange.toHtml(((HashMap) list.get(i)).get("PHYSICAL").toString());
          String CHEMISTRY = exchange.toHtml(((HashMap) list.get(i)).get("CHEMISTRY").toString());
          String BIOLOGICAL = exchange.toHtml(((HashMap) list.get(i)).get("BIOLOGICAL").toString());
          String HISTORY = exchange.toHtml(((HashMap) list.get(i)).get("HISTORY").toString());
          String POLITY = exchange.toHtml(((HashMap) list.get(i)).get("POLITY").toString());
          String GEOGRAPHY = exchange.toHtml(((HashMap) list.get(i)).get("GEOGRAPHY").toString());
          String TOTAL_SCORE =
              exchange.toHtml(((HashMap) list.get(i)).get("TOTAL_SCORE").toString());
          json += "{\"id\":\"" + ID + "\",";
          json +=
              "\"cell\":[\""
                  + (i + a)
                  + "\",\""
                  + SCORE_GRADE
                  + "\",\""
                  + SCORE_CLASS
                  + "\",\""
                  + SCORE_NO
                  + "\",\""
                  + STU_NAME
                  + "\",\""
                  + STU_SEX
                  + "\",\""
                  + AAS
                  + "\",\""
                  + KEMU
                  + "\",\""
                  + CHINESE
                  + "\",\""
                  + KEMATCH
                  + "\",\""
                  + ENGLISH
                  + "\",\""
                  + PHYSICAL
                  + "\",\""
                  + CHEMISTRY
                  + "\",\""
                  + BIOLOGICAL
                  + "\",\""
                  + HISTORY
                  + "\",\""
                  + POLITY
                  + "\",\""
                  + GEOGRAPHY
                  + "\",\""
                  + TOTAL_SCORE
                  + "\"]},";
        }
        json = json.substring(0, json.length() - 1);
        json += "]}";
      } else {
        json = "[]";
      }
      // System.out.println(json);
      response.getWriter().write(json);
      response.getWriter().close();

    } catch (Exception e) {
      e.printStackTrace();
    }
    return null;
  }
Ejemplo n.º 3
0
 private ActionForward searchStScore(
     ActionMapping mapping,
     ActionForm form,
     HttpServletRequest request,
     HttpServletResponse response) {
   try {
     request.setCharacterEncoding("utf-8");
     response.setCharacterEncoding("utf-8");
     String path = request.getContextPath();
     HashMap mapPara = GetParam.GetParamValue(request, "ISO-8859-1", "utf-8");
     ScoreManagementDAO dao = new ScoreManagementDAO();
     List stList = dao.searchStScoreList(mapPara);
     String json = "";
     if (stList != null && stList.size() > 0) {
       json = "[";
       for (int i = 0; i < stList.size(); i++) {
         json +=
             "{\"ID\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("ID").toString())
                 + "\",";
         json +=
             "\"SCORE_YEAR\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_YEAR").toString())
                 + "\",";
         json +=
             "\"SEMESTER\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SEMESTER").toString())
                 + "\",";
         json +=
             "\"SCORE_GRADE\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_GRADE").toString())
                 + "\",";
         json +=
             "\"SCORE_CLASS\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_CLASS").toString())
                 + "\",";
         json +=
             "\"SCORE_NO\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("SCORE_NO").toString())
                 + "\",";
         json +=
             "\"STU_NAME\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("STU_NAME").toString())
                 + "\",";
         json +=
             "\"STU_SEX\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("STU_SEX").toString())
                 + "\",";
         json +=
             "\"AAS\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("AAS").toString())
                 + "\",";
         json +=
             "\"KEMU\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("KEMU").toString())
                 + "\",";
         json +=
             "\"CHINESE\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("CHINESE").toString())
                 + "\",";
         json +=
             "\"KEMATCH\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("KEMATCH").toString())
                 + "\",";
         json +=
             "\"ENGLISH\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("ENGLISH").toString())
                 + "\",";
         json +=
             "\"PHYSICAL\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("PHYSICAL").toString())
                 + "\",";
         json +=
             "\"CHEMISTRY\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("CHEMISTRY").toString())
                 + "\",";
         json +=
             "\"BIOLOGICAL\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("BIOLOGICAL").toString())
                 + "\",";
         json +=
             "\"HISTORY\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("HISTORY").toString())
                 + "\",";
         json +=
             "\"POLITY\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("POLITY").toString())
                 + "\",";
         json +=
             "\"GEOGRAPHY\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("GEOGRAPHY").toString())
                 + "\",";
         json +=
             "\"TOTAL_SCORE\":\""
                 + exchange.toHtml(((HashMap) stList.get(i)).get("TOTAL_SCORE").toString())
                 + "\"},";
       }
       json = json.substring(0, json.length() - 1) + "]";
     } else {
       json = "[]";
     }
     response.getWriter().write(json);
     response.getWriter().close();
   } catch (Exception e) {
     e.printStackTrace();
   }
   return null;
 }
Ejemplo n.º 4
0
  private ActionForward impScore(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) {
    try {
      request.setCharacterEncoding("utf-8");
      response.setCharacterEncoding("utf-8");
      String path = request.getContextPath();
      String rootPath = request.getSession().getServletContext().getRealPath("/");
      // 先建文件夹
      String folderPath = rootPath + "export/";
      String str_Path = folderPath.toString().replace("\\", "/");
      // 上传文件
      SmartUpload mySmartUpload = new SmartUpload();
      // 设置允许上传的文件类型
      // mySmartUpload.setAllowedFilesList("xls");
      ServletConfig config = this.getServlet().getServletConfig();
      mySmartUpload.initialize(config, request, response);
      mySmartUpload.upload();

      String CURDATE = GetRecentDate.getRecentDate("yyyyMMddHHmmssS");
      String FILE_PATH = "";
      for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
        com.jspsmart.upload.File file = mySmartUpload.getFiles().getFile(i);
        if (!file.getFileName().equals("")) {
          FILE_PATH = str_Path + CURDATE + "_" + i + "." + file.getFileExt();
          file.saveAs(FILE_PATH);
        }
      }

      ScoreManagementDAO dao = new ScoreManagementDAO();
      InputStream stream = new FileInputStream(FILE_PATH);
      Workbook rwb = Workbook.getWorkbook(stream);
      Sheet sheet = rwb.getSheet(0);
      for (int i = 1; i < sheet.getRows(); i++) {
        String SCORE_YEAR = sheet.getCell(0, i).getContents(); // 年份
        if (SCORE_YEAR.equals("")) break;
        String SEMESTER = sheet.getCell(1, i).getContents(); // 学期
        String SCORE_GRADE = sheet.getCell(2, i).getContents(); // 班级
        String SCORE_CLASS = sheet.getCell(3, i).getContents(); // 班级
        String SCORE_NO = sheet.getCell(4, i).getContents(); // 学号
        String STU_NAME = sheet.getCell(5, i).getContents(); // 姓名
        String STU_SEX = sheet.getCell(6, i).getContents(); // 性别
        String AAS = sheet.getCell(7, i).getContents(); // 文理科
        String KEMU = sheet.getCell(8, i).getContents(); // 考试名称
        String CHINESE = sheet.getCell(9, i).getContents(); // 语文
        if (CHINESE.equals("")) CHINESE = "0";
        String MATCH = sheet.getCell(10, i).getContents(); // 数学
        if (MATCH.equals("")) MATCH = "0";
        String ENGLISH = sheet.getCell(12, i).getContents(); // 英语
        if (ENGLISH.equals("")) ENGLISH = "0";
        String PHYSICAL = sheet.getCell(13, i).getContents(); // 物理
        if (PHYSICAL.equals("")) PHYSICAL = "0";
        String CHEMISTRY = sheet.getCell(14, i).getContents(); // 化学
        if (CHEMISTRY.equals("")) CHEMISTRY = "0";
        String BIOLOGICAL = sheet.getCell(15, i).getContents(); // 生物
        if (BIOLOGICAL.equals("")) BIOLOGICAL = "0";
        String HISTORY = sheet.getCell(16, i).getContents(); // 历史
        if (HISTORY.equals("")) HISTORY = "0";
        String POLITY = sheet.getCell(17, i).getContents(); // 政治
        if (POLITY.equals("")) POLITY = "0";
        String GEOGRAPHY = sheet.getCell(18, i).getContents(); // 地理
        if (GEOGRAPHY.equals("")) GEOGRAPHY = "0";
        float total =
            Float.valueOf(CHINESE)
                + Float.valueOf(MATCH)
                + Float.valueOf(ENGLISH)
                + Float.valueOf(PHYSICAL)
                + Float.valueOf(CHEMISTRY)
                + Float.valueOf(BIOLOGICAL)
                + Float.valueOf(HISTORY)
                + Float.valueOf(POLITY)
                + Float.valueOf(GEOGRAPHY);

        HashMap map = new HashMap();
        map.put("SCORE_YEAR", SCORE_YEAR);
        map.put("SEMESTER", SEMESTER);
        map.put("SCORE_GRADE", SCORE_GRADE);
        map.put("SCORE_CLASS", SCORE_CLASS);
        map.put("SCORE_NO", SCORE_NO);
        map.put("STU_NAME", STU_NAME);
        map.put("STU_SEX", STU_SEX);
        map.put("AAS", AAS);
        map.put("KEMU", KEMU);
        map.put("CHINESE", CHINESE);
        map.put("MATCH", MATCH);
        map.put("ENGLISH", ENGLISH);
        map.put("PHYSICAL", PHYSICAL);
        map.put("CHEMISTRY", CHEMISTRY);
        map.put("BIOLOGICAL", BIOLOGICAL);
        map.put("HISTORY", HISTORY);
        map.put("POLITY", POLITY);
        map.put("GEOGRAPHY", GEOGRAPHY);
        map.put("TOTAL_SCORE", total);
        dao.insertScore(map);
      }
      rwb.close();
      stream.close();
      response.getWriter().write("1");
      response.getWriter().close();
    } catch (Exception e) {
      e.printStackTrace();
    }
    return null;
  }