oracle中图片查询转换成Blob
String sql = " select img1 from tbl_image where wzid='" + tblXywz.getWid() + "' and img1 is not null ";
List list = entityManager.createNativeQuery(sql).getResultList();
//主要解决(cannot be cast to java.sql.blob)异常
SerializableBlobProxy proxy = (SerializableBlobProxy )Proxy.getInvocationHandler(list.get(0));
Blob blob = proxy.getWrappedBlob();
//
BufferedInputStream is = new BufferedInputStream(blob.getBinaryStream());
byte[] autographBytes = new byte[(int) blob.length()];
int len = autographBytes.length;
int offset = 0;
int read = 0;
while(offset < len && (read = is.read(autographBytes,offset,len - offset)) >= 0){
offset += read;
}
is.close();