java下载springboot项目目录内置的模板Excel文件（不是前后分离）

需求：用户在前台，点击下载按钮，后端将内置的模板文件以流的方式传到前端，实现下载功能

项目目录，模板文件所在位置

前端代码：

"<a οnclick='downloadAchievementTemplate()' >成果表文件下载</a>"
//只是一个a标签 点击执行downloadAchievementTemplate方法

function downloadAchievementTemplate() {
	//后台路径
    var url = baseURL +'achievements/downLoadFileTemplate';
    ajaxDownload(url);
}

function ajaxDownload(url){
 var xhr = new XMLHttpRequest();
    xhr.open('GET', url, true);
    xhr.responseType = 'blob';
    xhr.setRequestHeader("token",token);
    xhr.onload = function(e) {
        if (this.status == 200) {
            // get binary data as a response
            var blob = this.response;
            var reader = new FileReader();
            reader.readAsDataURL(blob);  // 转换为base64
            reader.onload = function (e) {
                // 转换完成，创建一个a标签用于下载
                var a = document.createElement('a');
                a.download = "成果表模板文件.xlsx";
                a.href = e.target.result;
                $("body").append(a);  // 修复firefox中无法触发click
                a.click();
                $(a).remove();
            };
        }
    };
    xhr.send();
}

后端代码

//controller层
@RequestMapping(value = "/downLoadFileTemplate",method = RequestMethod.GET)
    public Object downAchievementTemplate(HttpServletRequest request, HttpServletResponse response){
        try {
            uploadService.downAchievementTemplate(request,response);
        } catch (Exception e) {
            e.printStackTrace();
            return Result.failure(ResultCode.SYSTEM_ERROR);
        }
        return null;
    }
//service层
 @Override
    public void downAchievementTemplate(HttpServletRequest request, HttpServletResponse response) throws Exception {
        InputStream inputStream=null;
        ServletOutputStream servletOutputStream=null;
        try {
            Resource resource = new DefaultResourceLoader().getResource("classpath:files/projectAchievementTemplate.xlsx");
            response.setContentType("application/force-download");
            response.setHeader("Content-Disposition", "attachment;fileName=" + new String("成果表模板文件".getBytes(), StandardCharsets.ISO_8859_1)
                    + ".xlsx");
            inputStream = resource.getInputStream();
            servletOutputStream = response.getOutputStream();
            IOUtils.copy(inputStream, servletOutputStream);
            response.flushBuffer();
        }catch (Exception e){
            response.setContentType("");
            response.setHeader("","");
        }finally {
            if(servletOutputStream!=null){
                servletOutputStream.close();
            }
            if(inputStream!=null){
                inputStream.close();
            }
        }
    }

完成

欢迎大家评论，共同学习