コード例 #1
0
  public String cbry037Analyse2() {
    Map<String, Object> session = (Map<String, Object>) ActionContext.getContext().get("session");
    String userName = (String) session.get("userName");
    System.out.println("action userName" + userName);
    if (!userName.equals("admin")) district = userName;
    else {
      if (district == null) district = "";
    }
    if (year == null || year.equals("")) year = "";
    if (multiple == 0) multiple = 1;
    statisticList = cbry037Service.statistic(district, multiple);
    cbry037List = cbry037Service.analyse2(district, year);
    if (statisticList != null && statisticList.size() > 0) {
      state = statisticList.get(0).toString();
      String[] state1 = state.split("其中:2013年");
      String[] state2 = state1[1].split("其中:2014年");
      state =
          state1[0]
              + "</br>"
              + "&nbsp&nbsp&nbsp&nbsp&nbsp其中:2013年"
              + state2[0]
              + "</br>"
              + "&nbsp&nbsp&nbsp&nbsp&nbsp其中:2014年"
              + state2[1];
      System.out.println("说明语句:" + state);
    } else {
      state = "您可能出现以下问题:</br>1.输入的倍数范围过大,请修改参数后再试!</br>2.数据量太少,无法生成情况说明。";
    }
    districtList = cbry037Service.getDistrictList();

    return "analyse2";
  }
コード例 #2
0
  public String cbry037Analyse1() {
    Map<String, Object> session = (Map<String, Object>) ActionContext.getContext().get("session");
    String userName = (String) session.get("userName");
    System.out.println("action userName" + userName);
    if (userName.equals("admin")) district = "";
    else district = userName;
    cbry037List = cbry037Service.analyse1(district);
    districtList = cbry037Service.getDistrictList();

    return "analyse1";
  }
コード例 #3
0
 public String download() throws Exception {
   // 创建类以确定泛型类型
   ExportExcel<Cbry037> ex = new ExportExcel<Cbry037>(new Cbry037());
   // 创建excel
   SXSSFWorkbook workbook = new SXSSFWorkbook(100);
   // 获取记录总数
   int cbry037ListCount = (int) cbry037Service.analyse3(district, year) / 40000 + 1;
   // 获取需要下载的数据list
   for (int i = 0; i < cbry037ListCount; ++i) {
     cbry037List = cbry037Service.analyse3(district, year, i);
     workbook = ex.creatExcel(workbook, cbry037List);
   }
   excelFile = ex.downLoadExcel(workbook);
   return "excel";
 }