更新数据的时候,写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();
如何用java更新oracle的blob字段
最新推荐文章于 2023-09-13 00:41:14 发布