springboot数据库中blob类型文件下载

孟1999

已于 2023-11-15 09:47:22 修改

阅读量274

点赞数 1

文章标签：数据库 spring boot java

于 2023-11-15 09:23:56 首次发布

本文链接：https://blog.csdn.net/weixin_65730775/article/details/134412568

版权

@PostMapping("/attachment-download")
@ApiOperation(value = "附件下载")
public void download( Integer id,HttpServletResponse response) throws IOException {
    ledgerService.download(id,response);
}

void download(Integer id, HttpServletResponse response)throws IOException;

@Override
public void download(Integer id, HttpServletResponse response) throws IOException{
  
    Attachment attachment=attachmentMapper.selectByid(id);
    byte[] content=attachment.getFileContent();
    if (content==null){
        throw new RuntimeException("没有文件");
    }
    response.setContentType("application/octet-stream;charset=utf-8");
    response.setHeader("Content-Disposition", "attachment; filename=\"" + new String(attachment.getFileName().getBytes("UTF-8"), "ISO-8859-1") + "\"");
    OutputStream out =response.getOutputStream();
    out.write(content);
    out.flush();
}