67,513
社区成员
发帖
与我相关
我的任务
分享着急ing！！请大侠指教！！！Jsp显示blob图片的问题。多谢多谢
下面的程序总不能成功！！！请指点！！多谢
ShowPhoto.jsp：
<%@ page import="java.sql.* " %>
<%@ page import="java.io.* " %>
<%
String driver = "COM.ibm.db2.jdbc.net.DB2Driver";
String url = "jdbc:db2://" + host + "/" + DBName;
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, userID, passwd);
st = conn.createStatement();
String query = "select photo from info where id = 5";
ResultSet result = st.executeQuery(query);
result.next();
response.setContentType("image/jpeg");
Blob blob = (Blob)result.getBlob("photo");
int len = blob.length();
byte[] data = blob.getBytes(1,len);
ServletOutputStream sos = response.getOutputStream() ;
sos.write(data) ;
sos.close();
conn.close();
}catch(Exception e){ e.printStackTrace();}
%>
Test.jsp：
<html>
<h1>this is a test .</h1>
<img src="ShowPhoto.jsp">
</html>
ShowPhoto.jsp：
<%@ page import="java.sql.* " %>
<%@ page import="java.io.* " %>
<%
String driver = "COM.ibm.db2.jdbc.net.DB2Driver";
String url = "jdbc:db2://" + host + "/" + DBName;
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, userID, passwd);
st = conn.createStatement();
String query = "select photo from info where id = 5";
ResultSet result = st.executeQuery(query);
result.next();
response.setContentType("image/jpeg");
Blob blob = (Blob)result.getBlob("photo");
int len = blob.length();
byte[] data = blob.getBytes(1,len);
ServletOutputStream sos = response.getOutputStream() ;
sos.write(data) ;
sos.close();
conn.close();
}catch(Exception e){ e.printStackTrace();}
%>
Test.jsp：
<html>
<h1>this is a test .</h1>
<img src="ShowPhoto.jsp">
</html>
...全文
请发表友善的回复…
发表回复
gongqh21 2003-05-10
- 打赏
- 举报
up
wafd 2003-05-10
- 打赏
- 举报
好文
xywl 2003-05-10
- 打赏
- 举报
使得ie的缓存信息，及时更新
enhydra1234 2003-05-09
- 打赏
- 举报
不能直接这样sos.write(data) ;
要用bufferReader。
要用bufferReader。
zez 2003-05-09
- 打赏
- 举报
用楼上的方法,再加上这两句试试 .具体意义我也不太清楚
response.setHeader("Cache-Control","no-store");
response.setDateHeader("Expires",0);
response.setHeader("Cache-Control","no-store");
response.setDateHeader("Expires",0);
leshui 2003-05-09
- 打赏
- 举报
//取得数据库中的数据
Sql="select * from marklist order by markdate desc";
result=DbaObj.ExecuteQuery(Sql);
result.next();
//将数据库中的数据读到流中
InputStream in =result.getBinaryStream("markbody");
//设置输出的格式
response.reset();
response.setContentType("image/jpeg");
//循环去出流中的数据
byte[] b = new byte[1024];
int len;
while((len=in.read(b)) >0)
response.getOutputStream().write(b,0,len);
in.close();
Sql="select * from marklist order by markdate desc";
result=DbaObj.ExecuteQuery(Sql);
result.next();
//将数据库中的数据读到流中
InputStream in =result.getBinaryStream("markbody");
//设置输出的格式
response.reset();
response.setContentType("image/jpeg");
//循环去出流中的数据
byte[] b = new byte[1024];
int len;
while((len=in.read(b)) >0)
response.getOutputStream().write(b,0,len);
in.close();
