showImage.jsp
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
try {
String id=request.getParameter("id");
..//此处联数据库
String cmd="select image from news WHERE id ="+id;
PreparedStatement sql=con.prepareStatement(cmd);
ResultSet rs = sql.executeQuery();
rs.next();
InputStream in = rs.getBinaryStream("image");
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();
rs.close();
}
catch(Exception e)
{ out.println(e);}
%>
使用:
页面显示图片<img src="showImage.jsp?id=<%=id%>">
如何用jsp读取数据库中的二进制图象
最新推荐文章于 2021-02-08 00:30:04 发布