将图片插入mysql数据库

  @PostMapping
  public R<Boolean> insert(@NotNull @RequestParam MultipartFile picture,String type) {
        try {
            QualityAnalysis qualityAnalysis=new QualityAnalysis();
            byte[] bytes = picture.getBytes();
            qualityAnalysis.setData(bytes);
            qualityAnalysis.setType(type);
            return success(this.qualityAnalysisService.save(qualityAnalysis));
        } catch (IOException e) {
            e.printStackTrace();
        }
        return success(null);
    }

浏览器展示图片

  @RequestMapping(value = "/picture",method = RequestMethod.GET,produces = MediaType.IMAGE_PNG_VALUE)
    public byte[] getPicture(Integer id){
        QualityAnalysis qualityAnalysis = this.qualityAnalysisService.getById(id);
        return qualityAnalysis.getData();
    }

浏览器下载图片

  @GetMapping("/write")
    public void writeBpa(Long planId, HttpServletResponse response) {
        try {
            BpaBo bpaBo = this.planService.writeBpa(planId);
            // 清空response
//            response.reset();
            // 设置response的Header
            response.setCharacterEncoding("UTF-8");
            //Content-Disposition的作用：告知浏览器以何种方式显示响应返回的文件，用浏览器打开还是以附件的形式下载到本地保存
            //attachment表示以附件方式下载   inline表示在线打开   "Content-Disposition: inline; filename=文件名.mp3"
            // filename表示文件的默认名称，因为网络传输只支持URL编码的相关支付，因此需要将文件名URL编码后进行传输,前端收到后需要反编码才能获取到真正的名称
            response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("bpa_out.dat", StandardCharsets.UTF_8));
            // 告知浏览器文件的大小
//            response.addHeader("Content-Length", Flux.just(bpaBo.getData().length()).toString());
            OutputStream outputStream = new BufferedOutputStream(response.getOutputStream());
            response.setContentType("application/octet-stream");
            outputStream.write(bpaBo.getData().getBytes(StandardCharsets.UTF_8));
            outputStream.flush();
        } catch (IOException ex) {
            ex.printStackTrace();
        }
    }

批量下载

    @PostMapping("/download")
    public void zipDownload(HttpServletResponse response, @RequestBody List<DeviceVo> deviceVoList) throws Exception {
        // zip压缩
        response.setContentType("application/zip");
        String percentEncodedFileName = URLEncoder.encode("config.zip", StandardCharsets.UTF_8.toString()).replaceAll("\\+", "%20");
        String contentDispositionValue = "attachment; filename=" + percentEncodedFileName;
        // 解决文件乱码
        response.setHeader("Content-disposition", contentDispositionValue);
        // 压缩多个文件到zip文件中，并且响应给客户端
        try (ZipOutputStream zipOutputStream = new ZipOutputStream(response.getOutputStream())) {
            deviceVoList.forEach(deviceVo -> {
                deviceVo.getConfigResultList().forEach(configResult -> {
                    try {
                        InputStream inputStream = IOUtils.toInputStream(configResult.getCmdResult(), StandardCharsets.UTF_8.name());
                        zipOutputStream.putNextEntry(new ZipEntry(deviceVo.getIp() + "/" + configResult.getCmd().split(",")[0] + "-" + configResult.getCreateTime() + ".txt"));
                        StreamUtils.copy(inputStream, zipOutputStream);
                        zipOutputStream.flush();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                });
            });

        }
    }