jsp获取Oracle数据库中Blob类型的图片
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"
import="java.sql.*" import="testP.DBUtil"
import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%
Connection conn=DBUtil.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
OutputStream os=response.getOutputStream();
try {
pstmt=conn.prepareStatement("select tiimg from testImg where tiId=102");
rs=pstmt.executeQuery();
byte[] b=new byte[1024];
if(rs.next())
{
InputStream is=rs.getBinaryStream("tiimg");
int i=0;
response.reset();
response.setContentType("image/jpeg");
while((i=is.read())!=-1){
os.write(b);
}
os.flush();
os.close();
is.close();
}
} catch (SQLException e) {
e.printStackTrace();
}catch(IOException e){
e.printStackTrace();
}finally{
DBUtil.clear(conn, pstmt, rs);
}
%>
eee</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"
import="java.sql.*" import="testP.DBUtil"
import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%
Connection conn=DBUtil.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
OutputStream os=response.getOutputStream();
try {
pstmt=conn.prepareStatement("select tiimg from testImg where tiId=102");
rs=pstmt.executeQuery();
byte[] b=new byte[1024];
if(rs.next())
{
InputStream is=rs.getBinaryStream("tiimg");
int i=0;
response.reset();
response.setContentType("image/jpeg");
while((i=is.read())!=-1){
os.write(b);
}
os.flush();
os.close();
is.close();
}
} catch (SQLException e) {
e.printStackTrace();
}catch(IOException e){
e.printStackTrace();
}finally{
DBUtil.clear(conn, pstmt, rs);
}
%>
eee</body>
</html>
解决方案 »
- Spring配置RequestMapping配置好控制器了,为何不能通过浏览器访问这个连接呢呢?
- jsp中页面跳转问题
- org.apache.catalina.core.StandardWrapperValve invoke
- 请教关于lucene多字段多关键字查询的问题!!~
- 关于在struts2中使用urlrewrite的问题
- 找不到类符号,怎么解决?
- 急急!!关于批量成绩录入问题 请高手指点 谢谢
- 去404画面,如何保留之前的url
- 如何获得来源页面?
- 从login.html到login.jsp不成功,看以下代码!请指教!
- netbeans不能编译运行jsp
- 关于基于B/S的中小学生信息跟踪管理系统的一些问题。
严重: Servlet.service() for servlet jsp threw exception
java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:756)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:448)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:363)
at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:780)
at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126)
at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:593)
at org.apache.coyote.Response.doWrite(Response.java:560)
at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:364)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:448)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:363)
at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:392)
at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381)
at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:89)
at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:83)
at org.apache.jsp.NewFile_jsp._jspService(NewFile_jsp.java:88)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)