ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

 src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java

@@ -338,14 +338,19 @@
      if (list.size()<=7){
         HSSFRow row = sheet.createRow(0);
         row.setHeight((short) 1980);

         HSSFRow row1 = sheet.createRow(1);
         row1.setHeight((short) 300);

         for (int i = 0; i < list.size(); i++) {
            ExportSecurityPaperExcelVO checkWorkVo = list.get(i);
            row1.createCell(i).setCellValue(checkWorkVo.getName());
            //如果头像有
            if (null != list.get(i).getAvatar() && list.get(i).getAvatar() != "") {
               if (list.get(i).getAvatar().contains("http:")) {
                  //获取图片格式
                  int lastIndexOf = list.get(i).getAvatar().lastIndexOf(".");
                  String pictureType = list.get(i).getAvatar().substring(lastIndexOf + 1);
                  //画图的顶级管理器，一个sheet只能获取一个（一定要注意这点）
                  BufferedImage bufferImg = null;
                  //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
@@ -356,7 +361,7 @@
                     e.printStackTrace();
                  }
                  try {
                     ImageIO.write(bufferImg, "jpg", byteArrayOut);
                     ImageIO.write(bufferImg, pictureType, byteArrayOut);
                  } catch (IOException e) {
                     e.printStackTrace();
                  }
@@ -367,9 +372,9 @@
                           0, // y缩放
                           1023, //最大1023
                           255, //最大255
                           (short) i,  //宽度占几格 0开始
                           (short) i,  //宽度 0开始
                           0, //在第几行
                           (short) i, //宽度占几格 0开始
                           (short) i, //宽度 0开始
                           0 //第几列
                        );
                  //插入图片
@@ -397,14 +402,16 @@
         }
         //判断余下的
         if (excelList.size()>0){
            rowNum++;
            rowNum = rowNum + 2;
            //写入表格
            writeBookForEach(excelList,rowNum,workBook,sheet,patriarch);
         }
      }
      //导出数据
      response.setContentType("application/vnd.ms-excel; charset=UTF-8");
      response.setHeader("Content-Disposition", "attachment;filename=" + "证书打印信息导出"+DateUtil.time() + ".xlsx");
      response.setContentType("application/vnd.ms-excel");
      response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name());
      String fileName = URLEncoder.encode("证书打印信息导出"+ DateUtil.time(), Charsets.UTF_8.name());
      response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");
      workBook.write(response.getOutputStream());
   }

@@ -427,6 +434,9 @@
         //如果头像有
         if (null != list.get(i).getAvatar() && list.get(i).getAvatar() != "") {
            if (list.get(i).getAvatar().contains("http:")) {
               //获取图片格式
               int lastIndexOf = list.get(i).getAvatar().lastIndexOf(".");
               String pictureType = list.get(i).getAvatar().substring(lastIndexOf + 1);
               //画图的顶级管理器，一个sheet只能获取一个（一定要注意这点）
               BufferedImage bufferImg = null;
               //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
@@ -437,7 +447,7 @@
                  e.printStackTrace();
               }
               try {
                  ImageIO.write(bufferImg, "jpg", byteArrayOut);
                  ImageIO.write(bufferImg, pictureType, byteArrayOut);
               } catch (IOException e) {
                  e.printStackTrace();
               }