java更新blob字段的值_如何用java更新oracle的blob字段

更新数据的时候，写insert语句的时候，不更新blob字段，blob字段对应的数据用 empty_blob() 代替就行。

(注意：在执行上面那个 sql 之前，一定要把 connection 设置成不自动提交： conn.setAutoCommit(false); )

最后单独出来blob字段：

//把 blob 字段取出来

String sql = "select ANNEX from market_info_collect_t where info_id='"

+ infoId + "' for update ";

Statement stt=null;

stt = conn.createStatement();

rs = stt.executeQuery(sql);

if (rs.next()) {

blob = (oracle.sql.BLOB) rs.getBlob("ANNEX");

outStream = blob.getBinaryOutputStream();

instream = myFile.getContentStream();

byte[] data = new byte[instream.available()];

instream.read(data);

outStream.write(data, 0, data.length);

}

instream.close();

outStream.flush();

outStream.close();