Question

如何把inputstream转化成blob存入数据库中

Answer 1

private byte[] toByteArray(Blob fromBlob) throws SQLException, IOException {
ByteArrayOutputStream baos = new ByteArrayOutputStream();

return toByteArrayImpl(fromBlob, baos);

}

private byte[] toByteArrayImpl(Blob fromBlob, ByteArrayOutputStream baos) throws SQLException, IOException{
byte[] buf = new byte[10*1024*1024];
InputStream is = fromBlob.getBinaryStream();
try {
for (;;) {
int dataSize = is.read(buf);
if (dataSize == -1)
break;
baos.write(buf, 0, dataSize);
}
}
finally { if (is != null) {
try { is.close(); }
catch (IOException ex) { }
}
}
return baos.toByteArray();
}