在index.jsp中(假设你的页面是叫这个名字)增加一行要显示的图片
<img src="listphoto.jsp?id=123">在listphoto.jsp中
<%@ page contentType="image/jpeg"%><%
OutputStream os = response.getOutputStream();
然后从数据库中读取这个字段的值,全部write到os里面
%>
<img src="listphoto.jsp?id=123">在listphoto.jsp中
<%@ page contentType="image/jpeg"%><%
OutputStream os = response.getOutputStream();
然后从数据库中读取这个字段的值,全部write到os里面
%>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
try { String id="2";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;DatabaseName=Northwind","sa","");
String cmd="select Photo from Employees WHERE employeeid ="+id;
out.print(cmd);PreparedStatement sql=con.prepareStatement(cmd);
ResultSet rs = sql.executeQuery();
rs.next();
InputStream in = rs.getBinaryStream("Photo");
response.reset();
response.setContentType("image/jpeg");
byte[] b = new byte[500*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);}
%>
谢谢啦,
————————————————————————————
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page language="java" import="java.sql.*"%> <%
String id="1";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;DatabaseName=Northwind","sa","");
String cmd="select Photo from Employees WHERE employeeid ="+id;
PreparedStatement sql=con.prepareStatement(cmd);
ResultSet rs = sql.executeQuery();
rs.next();
InputStream in = rs.getBinaryStream("Photo");
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();
%>
test2.jsp如下:
——————————————————————
<%@ page contentType="text/html;charset=gb2312"%>
<table>
<tr>
<td><img src="<%@ include file="test1.jsp"%>" width=100 height=100 ></td>
</tr>
<tr>
<td>这里的汉字无法显示</td>
</tr>
</table>
我的程序环境是 resin + win2k +sql-server