Java读取数据库Blob对象返回到JSP页面和getOutputStream() has already been called for this response异常处理

最新推荐文章于 2022-12-09 15:41:09 发布

del1214

最新推荐文章于 2022-12-09 15:41:09 发布

阅读量2.3k

点赞数

分类专栏： Java 文章标签： java jsp 数据库 import file exception

本文链接：https://blog.csdn.net/del1214/article/details/6625261

版权

Java 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

<%@page import="java.sql.Blob"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.CallableStatement"%>
<%@page import="java.io.BufferedOutputStream"%>
<%@page import="java.io.FileInputStream"%>
<%@page import="java.io.OutputStream"%>
<%@page import="java.io.InputStream"%>
<%@page import="java.io.File"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
//CallableStatement cs = conn.prepareCall("call `xxx`.`xxxx`();");
//ResultSet rs = cs.executeQuery(); 
//if (rs.next()) { 
//Blob b = rs.getBlob("magazine"); 
//long size = b.length(); 
//byte[] bs = b.getBytes(1, (int)size); 
//} //后面差不多，主要是byte的来源变了


File file = new File("C:\\Begin Google Map.pdf");//也可以从文件读取
long length = file.length();
InputStream stream = new FileInputStream(file);
BufferedOutputStream os = new BufferedOutputStream(response.getOutputStream());//用Buffered包裹效率高
//OutputStream os = response.getOutputStream();
byte[] buf=new byte[(int)length];
response.setContentType("application/pdf");
try {
    int n;
    while ((n = stream.read(buf)) != -1)
    	os.write(buf, 0, n);//这里要这么写，表示读多少写多少
} catch (Exception e) {
	e.printStackTrace();
}
os.flush();
os.close();
out.clear();//这两句话一定要加上，否则报getOutputStream() has already been called for this response异常
out = pageContext.pushBody();


%>
</body>
</html>

del1214

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Java读取数据库Blob对象返回到JSP页面和getOutputStream() has already been called for this response异常处理

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>Insert title here<%//CallableStatement cs
复制链接

扫一扫