Example #1
0
  // 导出excel表
  @RequestMapping(
      value = "/downPlan.action",
      produces = {"application/json;charset=UTF-8"})
  @ResponseBody
  public String gridToExcel(HttpServletRequest request, HttpServletResponse response) {
    List<CardPiece> datas = cps.showCard();
    // 第一步,创建一个webbook,对应一个Excel文件
    HSSFWorkbook wb = new HSSFWorkbook();
    // 第二步,在webbook中添加一个sheet,对应Excel文件中的sheet
    HSSFSheet sheet = wb.createSheet("可参与复垦农户表");
    // 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
    HSSFRow row = sheet.createRow((int) 0);
    // 第四步,创建单元格,并设置值表头 设置表头居中
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式

    HSSFCell cell = row.createCell((short) 0);
    cell.setCellValue("宅基地所在地");
    cell.setCellStyle(style);
    cell = row.createCell((short) 1);
    cell.setCellValue("户主姓名");
    cell.setCellStyle(style);
    cell = row.createCell((short) 2);
    cell.setCellValue("户主身份证号");
    cell.setCellStyle(style);
    cell = row.createCell((short) 3);
    cell.setCellValue("房屋结构");
    cell = row.createCell((short) 4);
    cell.setCellValue("房屋使用时间");
    cell.setCellStyle(style);
    cell = row.createCell((short) 5);
    cell.setCellValue("所属地类");
    cell.setCellStyle(style);
    cell = row.createCell((short) 6);
    cell.setCellValue("现状地类");
    cell.setCellStyle(style);
    cell = row.createCell((short) 7);
    cell.setCellValue("项目编号");
    cell.setCellStyle(style);

    // 第五步,写入实体数据 实际应用中这些数据从数据库得到,
    for (int i = 0; i < datas.size(); i++) {
      row = sheet.createRow((int) i + 1);
      CardPiece cp = (CardPiece) datas.get(i);
      // 第四步,创建单元格,并设置值
      row.createCell((short) 0).setCellValue(cp.getQSDWMC());
      row.createCell((short) 1).setCellValue(cp.getDYNHXM());
      row.createCell((short) 2).setCellValue(cp.getDYNHSFZ());
      row.createCell((short) 3).setCellValue(cp.getFWJG());
      row.createCell((short) 4).setCellValue(cp.getFWSYSJ());
      row.createCell((short) 5).setCellValue(cp.getDLMC());
      row.createCell((short) 6).setCellValue(cp.getSFDYXZSJ());
      row.createCell((short) 7).setCellValue(cp.getProjectID());
    }

    // 第六步,将文件存到指定位置
    try {
      path = request.getSession().getServletContext().getRealPath("excel") + "/" + "guihua.xls";

      OutputStream os = null;
      response.reset();
      response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
      response.setContentType("application/octet-stream; charset=utf-8");
      try {
        os = response.getOutputStream();
        os.write(FileUtils.readFileToByteArray(new File(path)));
        os.flush();
      } catch (IOException e) {
        e.printStackTrace();
      } finally {
        if (os != null) {
          try {
            os.close();
          } catch (IOException e) {
            e.printStackTrace();
          }
        }
      }

    } catch (Exception e) {
      e.printStackTrace();
    }

    return "{\"success\": true}";
  }
Example #2
0
  @RequestMapping(value = "/saveCard.action")
  @ResponseBody
  public Map<String, Object> addCardPiece(
      @RequestParam("houseNumber") String houseNumber,
      @RequestParam("DLMC") String DLMC,
      @RequestParam("DYNHSFZ") String DYNHSFZ,
      @RequestParam("DYNHXM") String DYNHXM,
      @RequestParam("FWJG") String FWJG,
      @RequestParam("FWSYSJ") String FWSYSJ,
      @RequestParam("FWZP") String FWZP,
      @RequestParam("QSDWMC") String QSDWMC,
      @RequestParam("SFDYXZSJ") String SFDYXZSJ,
      @RequestParam("Shape_Area") String Shape_Area,
      @RequestParam("projectID") String projectID) {

    String[] houseNumberNew = houseNumber.split(",");
    String[] DLMCNew = DLMC.split(",");
    String[] DYNHSFZNew = DYNHSFZ.split(",");
    String[] DYNHXMNew = DYNHXM.split(",");
    String[] FWJGNew = FWJG.split(",");
    String[] FWSYSJNew = FWSYSJ.split(",");
    String[] FWZPNew = FWZP.split(",");
    String[] QSDWMCNew = QSDWMC.split(",");
    String[] SFDYXZSJNew = SFDYXZSJ.split(",");
    String[] Shape_AreaNew = Shape_Area.split(",");

    for (int i = 0; i < houseNumberNew.length; i++) {
      CardPiece cp = new CardPiece();

      cp.setHouseNumber(houseNumberNew[i]);
      cp.setDLMC(DLMCNew[i]);
      cp.setDYNHSFZ(DYNHSFZNew[i]);
      cp.setDYNHXM(DYNHXMNew[i]);
      cp.setFWJG(FWJGNew[i]);
      cp.setFWSYSJ(FWSYSJNew[i]);
      cp.setFWZP(FWZPNew[i]);
      cp.setJoinFlag("未参与");
      cp.setQSDWMC(QSDWMCNew[i]);
      cp.setSFDYXZSJ(SFDYXZSJNew[i]);
      cp.setDemolitionFlag("未拆迁");
      cp.setProjectID(projectID);
      cp.setShape_Area(Double.parseDouble(Shape_AreaNew[i]));

      cps.addCard(cp);
    }

    Map<String, Object> results = new HashMap<String, Object>();
    results.put("success", true);
    results.put("msg", "1" + ",successfully saved");
    return (results);
  }