如何显示blob类型的图片?

Question

ResultSet rs=stmt.executeQuery(sql);
            if(rs.next()){
                Blob blob = rs.getBlob("content");
                byte[] ab = blob.getBytes(1, (int)blob.length());
                response.setContentType("image/jpeg");
                ServletOutputStream op = response.getOutputStream();
                op.write(ab);
                op.flush();
                op.close();
            }

Answer 1

Note: sun.tools.javac.Main has been deprecated.
/char/mysearch/show_img1.jsp:9: Class _char._mysearch.Blob not found.
    Blob blob=rs.getBlob("bin_data");
    ^
1 error, 1 warning这是提示错误

Answer 2

我用oracle是这样处理的，供参考：
oracle.sql.BLOB blob = null;
if(rs.next()) {
        blob = (oracle.sql.BLOB)((oracle.jdbc.OracleResultSet)rs).getBLOB(rs_meta.getColumnName(1));
          if(!blob.equals("")){
          byte[] b = blob.getBytes(1, (int)blob.length());
          ByteArrayInputStream bis = new ByteArrayInputStream(b);
          ObjectInputStream ois = new ObjectInputStream(bis);
          ht = (Hashtable)ois.readObject();
           searchString = ht.toString();
           sb=new StringBuffer(searchString);
           sb.deleteCharAt(0);
           sb.deleteCharAt(sb.length()-1);
           searchString = sb.toString();
          System.out.println("sfsdf"+searchString);
          }
        }
希望能有帮助

Answer 3

    InputStream inin = rs.getBinaryStream("pic");    response.reset();
    response.setContentType("Image/bmp");
    byte[] b = new byte[1024*1024];
    int len;    while((len=inin.read(b)) >0)
       {
         response.getOutputStream().write(b,0,len);
       }    inin.close();
    response.getOutputStream().close();
    rs.close();