下载表格文件
file.html
<!DOCTYPE html>
<!-- saved from url=(0043)https://demo.demohuo.top/modals/6/637/demo/ -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>文件管理</title>
<!--主要样式-->
<link rel="stylesheet" href="./layui/css/layui.css" media="all">
<style>
body {
margin: 10px;
}
.demo-carousel {
height: 200px;
line-height: 200px;
text-align: center;
}
</style>
</head>
<body>
<a href="file/download.do">下载</a>
<script src="./layui/layui.js"></script>
<script src="./js/file.js"></script>
</body>
</html>
file.js
layui.use(['laypage', 'layer', 'table','jquery','upload'], function(){
var laypage = layui.laypage //分页
,layer = layui.layer //弹层
,table = layui.table //表格
,$=layui.jquery //jquery
,upload=layui.upload
$("#download").click(function(){
$.ajax({
url: "file/download.do",
type: 'post',
success: function (data, status, xhr) {
console.log("Download file DONE!");
console.log(data); // ajax方式请求的数据只能存放在javascipt内存空间,可以通过javascript访问,但是无法保存到硬盘
console.log(status);
console.log(xhr);
console.log("=====================");
}
});
});
});
FileController.java
package com.whc.noteserver.controller;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.UUID;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import com.whc.noteserver.entity.NoteBook;
import com.whc.noteserver.param.NoteBookParam;
import com.whc.noteserver.result.LayPage;
import com.whc.noteserver.service.NoteBookService;
import com.whc.noteserver.util.JsonResult;
@Controller //注解,组件扫描加入到spring容器中
@RequestMapping("/file") //类controller的映射路径
public class FileController {
@RequestMapping("/download")
public void download(HttpServletRequest request,HttpServletResponse response) {
String filePath="E:\\images\\2020-06-17\\1.xls";
try {
InputStream bis= new BufferedInputStream(new FileInputStream(new File(filePath)));
String fileName="张三.xls";
fileName=URLEncoder.encode(fileName,"UTF-8");
response.addHeader("Content-Disposition", "attachment;filename="+fileName);
response.setContentType("multipart/form-data");
BufferedOutputStream out = new BufferedOutputStream(response.getOutputStream());
int len=0;
while((len=bis.read())!=-1) {
out.write(len);
out.flush();
}
out.close();
bis.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}