储存blob

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