求救，jsp 从Oracle 数据库中取图片

Question

<%@ page language="java" import="java.sql.*"%> 
<%@ page import="java.io.*"%> 
<%@ page contentType="text/html;charset=gb2312"%><% 
//数据库连接你自己写。ResultSet rs = sql.executeQuery(); 
rs.next(); 
InputStream in = rs.getBinaryStream("nImg"); 
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(); 
%>

Answer 1

java.sql.Connection conn; 
java.sql.Statement stmt; 
java.sql.ResultSet rs1;  
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","aa","aa");///数据源
stmt=conn.createStatement();rs1=stmt.executeQuery("SELECT * FROM uploads ");
if (rs1.next())
{
String name=rs1.getString("filename");
out.println(name);
byte [] blocco = rs1.getBytes("binaryfile");
response.setContentType("image/jpeg");
ServletOutputStream op = response.getOutputStream();
for(int i=0;i<blocco.length;i++)
{
op.write(blocco[i]);
}
}
rs1.close();

Answer 2

我的图片是用VB通过ado、ODBC 写入，为什么这样写JSP还不能显示，代码如下：<%@ page language="java" import="java.sql.*,java.util.*"%>
<%! ResultSet Rs;%>
<%! Connection conn;%>
<%! int introw0;%>
<%! String id;%>
<%! byte [] blocco;%>
<%
String sDBDriver= "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:wits_mod_oracle";
//String sConnStr = "jdbc:oracle:thin:@192.168.2.204:1521:yiyao,yiyao,yiyao";
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,"yiyao","yiyao");
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
Rs=stmt.executeQuery("SELECT images FROM images WHERE id = 4");
Rs.last();
introw0=Rs.getRow();
blocco = Rs.getBytes("images");
response.setContentType("image/jpeg");
ServletOutputStream op = response.getOutputStream();
op.write(blocco);
op.close();
Rs.close();
%>急急急！！！