1.jdbc读取blob字段
FileUtils fu = new FileUtils();
String []array = fu.toByteArray(rs.getBlob("PICTURE"));
Blob blob = rs.getBlob("PICTURE");
2.更新blob
OracleResultSet oracleResultSet = (OracleResultSet) stmt.executeQuery("SELECT xmldata FROM table ");
if (oracleResultSet.next()) {
OracleThinBlob blob = (OracleThinBlob) oracleResultSet
.getBlob(1);
blob.putBytes(1, "需要存储的内容");
pstmt = (OraclePreparedStatement) conn
.prepareStatement("UPDATE table SET xmldata = ? WHERE recordid = '"
+ recordId + "'");
pstmt.setBlob(1, (Blob) blob);
pstmt.executeUpdate();
}