@@@关于图象存取的问题@@@ 急！！！

[wlaptech]

我在servlet中调用oracle里的blob字段（里面存的图片）
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
int photoids=0;
try
{
photoids=Integer.parseInt(request.getParameter("photoid"));
}
catch(Exception e)
{e.printStackTrace();}
byte []buf=null;
String photoname="gif";
int id=0;
int lengths=0;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:office","scott","tiger");
String sql="select * from images where imageid="+photoids;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
id=rs.getInt(1);
photoname=rs.getString(2);
buf=rs.getBytes(3);
lengths=rs.getInt(4);
}
else
{
buf=new byte[0];
}
}
catch(SQLException e)
{e.getMessage();}
catch(Exception e)
{
e.printStackTrace();
}
response.setContentType("image/gif");
OutputStream out=response.getOutputStream();
out.write(buf);
out.flush();
}
为何图象无法取出呢，空白的我在jsp里的取图片语句如下
<img border="0" src="/servlet/getphoto?photoid=1">
jsp放在webapps\ww\下面 getphoto.class放在ww\WEB-INF\classes 紧急求助！！

[wlaptech]

up

[javapopo]

import java.sql.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DownLoad extends HttpServlet{
public DownLoad() {
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("======DownLoad begin=====");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:aptech","scott","tiger");
Statement stmt=conn.createStatement();
int id=Integer.parseInt(request.getParameter("id"));
String sql="SELECT imageid, data FROM images where imageid="+id;
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
Blob blob = rs.getBlob("data");
byte[] ab = blob.getBytes(1, (int)blob.length());
response.setContentType("image/gif");
response.reset();
ServletOutputStream op = response.getOutputStream();
op.write(ab);
op.flush();
op.close();
}
}catch(Exception ex){
ex.printStackTrace();
}
System.out.println("======DownLoad end=====");
}
}

[抬头望天边一只雁]

楼主,能给你已经解决的答案吗?