jsp从服务器下载xls文件到客户端

最新推荐文章于 2021-02-26 03:17:11 发布

zi_jun

最新推荐文章于 2021-02-26 03:17:11 发布

阅读量4.5k

点赞数

分类专栏： jsp 文章标签： jsp 服务器 file stylesheet null exception

jsp 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

参考网上的代码写了一个下载xls文件到客户端的jsp页面，只要将服务器的文件地址传给这个jsp页面就可以实现下载文件到客户端了。

Html代码

<%@ page language="java"import="java.util.*"pageEncoding="utf-8"%>
<%@ taglib prefix="c"uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="styles/basic.css" rel="stylesheet" type="text/css" />
<title>download</title>
</head>
<%
response.setCharacterEncoding("gb2312");
request.setCharacterEncoding("gb2312");
if (request.getParameter("file") != null) {
OutputStream os = null;
FileInputStream fis = null;
try {
String file = request.getParameter("file");
if (!(new File(file)).exists()) {
System.out.println("没有文件");
return;
}
System.out.println("文件名为："+file);
os = response.getOutputStream();
response.setHeader("content-disposition", "attachment;filename=" + file);
response.setContentType("application/vnd.ms-excel");//此项内容随文件类型而异
byte temp[] = new byte[1000];
fis = new FileInputStream(file);
int n = 0;
while ((n = fis.read(temp)) != -1) {
os.write(temp, 0, n);
}
} catch (Exception e) {
out.print("出错");
} finally {
if (os != null)
os.close();
if (fis != null)
fis.close();
}
out.clear();
out = pageContext.pushBody();
}
%>
<form action="" method="post">
<select name="file">
<option value="D:\Program Files\apache-tomcat-6.0.18\webapps\StarAttendance\upload/temp.xls">
冷山sky_snow
</option>
</select>
<input type="submit"/>
</form>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<link href="styles/basic.css" rel="stylesheet" type="text/css" />
		<title>download</title>
</head>
<%    
     response.setCharacterEncoding("gb2312");    
     request.setCharacterEncoding("gb2312");    
   
    if (request.getParameter("file") != null) {    
         OutputStream os = null;    
         FileInputStream fis = null;    
        try {    
             String file = request.getParameter("file");    
            if (!(new File(file)).exists()) {    
                 System.out.println("没有文件");    
                return;    
             }    
             System.out.println("文件名为："+file);    
             os = response.getOutputStream();    
             response.setHeader("content-disposition", "attachment;filename=" + file);    
             response.setContentType("application/vnd.ms-excel");//此项内容随文件类型而异    
            byte temp[] = new byte[1000];    
             fis = new FileInputStream(file);    
            int n = 0;    
            while ((n = fis.read(temp)) != -1) {    
                 os.write(temp, 0, n);    
             }    
         } catch (Exception e) {    
             out.print("出错");    
         } finally {    
            if (os != null)    
                 os.close();    
            if (fis != null)    
                 fis.close();    
         }    
         out.clear();    
         out = pageContext.pushBody();    
   
     }    
%>    
   
<form action="" method="post">    
     <select name="file">    
         <option value="D:\Program Files\apache-tomcat-6.0.18\webapps\StarAttendance\upload/temp.xls">    
             冷山sky_snow    
         </option>    
     </select>    
     <input type="submit"/>    
</form> 
</html>

2.另外一个修改后的版本（下载文件名可包含中文）

Html代码

<%@ page language="java"import="java.util.*,java.net.*"pageEncoding="utf-8"%>
<%@ taglib prefix="c"uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="styles/basic.css" rel="stylesheet" type="text/css" />
<title>download</title>
</head>
<%
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
String filepath = new String(request.getParameter("file").getBytes("ISO-8859-1"),"UTF-8");
System.out.println("============================"+filepath);
if (filepath != null) {
OutputStream os = null;
FileInputStream fis = null;
try {
String file = filepath;
if (!(new File(file)).exists()) {
System.out.println("没有文件");
return;
}
String filefilename = file.substring(file.lastIndexOf("\\")+1);
System.out.println("文件名为："+filename);
os = response.getOutputStream();
response.setHeader("content-disposition", "attachment;filename=" + new String(filename.getBytes("GBK"), "ISO-8859-1"));
response.setContentType("application/octet-stream");//八进制流与文件类型无关
byte temp[] = new byte[1024];
fis = new FileInputStream(file);
int n = 0;
while ((n = fis.read(temp)) != -1) {
os.write(temp, 0, n);
}
} catch (Exception e) {
out.print("出错了");
} finally {
if (os != null)
os.close();
if (fis != null)
fis.close();
}
out.clear();
out = pageContext.pushBody();
}
%>
</html>

zi_jun

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
jsp从服务器下载xls文件到客户端

参考网上的代码写了一个下载xls文件到客户端的jsp页面，只要将服务器的文件地址传给这个jsp页面就可以实现下载文件到客户端了。Html代码 %@ page language="java"import="java.util.*"pageEncoding="utf-8"%>%@ taglib prefix="c"uri="http://java.sun.com/js
复制链接

扫一扫

专栏目录