最近在做的java项目后台需要下载服务器上的Excel模版,项目前台使用的是springMVC框架。下面是具体的代码
controller
/** * 下载Excel模版 * @param request * @param response * @throws Exception */ @RequestMapping("/downloadFile.do") public void downloadFile(HttpServletRequest request, HttpServletResponse response) throws Exception { String fileName = "模版.xls"; //下载的文件名(前提:下载的文件需要存放在服务器的位置上,这里是 WebRoot/uploadFile 中) download.downloadFile(request, response, fileName); }
download类
package com.tgb.weixin.tool; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.io.FileInputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.stereotype.Component; /** * 下载模版工具类 * * 项目名称:TGBWeixinNew * 类名称:downLoadExcel * 类描述: * 创建人:pangfan * 创建时间:2015-3-22 上午08:42:35 * 修改人:pangfan * 修改时间:2015-3-22 上午08:42:35 * 修改备注: * @version * */ @Component public class Download { //下载模版工具类 public void downloadFile(HttpServletRequest request, HttpServletResponse response,String fileName) throws Exception { response.setContentType("text/html;charset=UTF-8"); BufferedInputStream in = null; BufferedOutputStream out = null; request.setCharacterEncoding("UTF-8"); String rootpath = request.getSession().getServletContext().getRealPath("/"); try { File f = new File(rootpath + "uploadFile/" + fileName); response.setContentType("application/x-excel"); response.setCharacterEncoding("UTF-8"); response.setHeader("Content-Disposition", "attachment; filename="+new String(fileName.getBytes("gbk"),"iso-8859-1")); response.setHeader("Content-Length",String.valueOf(f.length())); in = new BufferedInputStream(new FileInputStream(f)); out = new BufferedOutputStream(response.getOutputStream()); byte[] data = new byte[1024]; int len = 0; while (-1 != (len=in.read(data, 0, data.length))) { out.write(data, 0, len); } } catch (Exception e) { e.printStackTrace(); } finally { if (in != null) { in.close(); } if (out != null) { out.close(); } } } }