java如何显示SQLSERVER里的IMAGE数据类型

Question

<%@   page   language="java"   import="java.sql.*,java.util.*"%>  
  <%  
  String   image_id   =   (String)   request.getParameter("ID");  
  if   (image_id   !=   null){  
                      try    
                      {  
                            Class.forName("oracle.jdbc.driver.OracleDriver");  
              Connection   con   =   DriverManager.getConnection("jdbc:oracle:thin:scott/[email protected]:1243:myInstance","java","java");  
                Statement   stmt   =   con.createStatement();  
          ResultSet   rs   =   stmt.executeQuery("SELECT   *   FROM   IMMAGINE   WHERE   IMMAGINE_ID   =   "   +   image_id);  
          if   (rs.next())  
                          {  
  String   dim_image   =   rs.getString("IMMAGINE_DIMENSIONE");  
  byte   []   blocco   =   rs.getBytes("IMMAGINE_IMMAGINE");  
  response.setContentType("image/jpeg");  
  ServletOutputStream   op   =   response.getOutputStream();  
  for(int   i=0;i<Integer.parseInt(dim_image);i++)  
  {  
  op.write(blocco[i]);  
  }  
            }    
        rs.close();  
        stmt.close();  
        con.close();  
    }   catch(Exception   e)   {  
  out.println("An   error   occurs   :   "   +   e.toString());  
                    }  
  }   
使用
<image src="a.jsp?id=100/>