存储blob

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();
    }