下载表格文件

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();
		}
	}
}
Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐