/* 插入BLOB对象 */ public static String reqInfo(String qry,String cxfaid,String fwfid,String pf,String xtestflag){ Connection con=null; Statement stat=null; String send="qry="+qry+"&cxfaid="+cxfaid+"&fwfid="+fwfid+"&pf="+pf+"&xtestflag="+xtestflag; System.out.println("zwreq ReqDao.class send= "+send); String id=getGuid(); String sql="insert into mutual(id,Send,Receive) values ('"+id+"',EMPTY_BLOB(),EMPTY_BLOB())"; System.out.println("sql= "+sql); String result="false"; try { con=ConnManager.getConnection(); stat=con.createStatement(); int count = stat.executeUpdate(sql); if (count > 0) { blobModify(con, stat, send, "send", "mutual", id, "id"); } } catch (Exception e) { // TODO Auto-generated catch block result="ReqDao.reqInfo 错误:"+e.getMessage(); e.printStackTrace(); } finally { try { if (stat != null) { stat.close(); } if (con != null) { con.close(); con = null; } } catch (Exception e) { } } return result; } /* 修改BLOB对象(是在原CLOB对象基础上进行覆盖式的修改) */ public static void blobModify(Connection con, Statement stmt, String infile, String blobColumnName, String tabName, String id, String idColumName) throws SQLException { byte[] b=infile.getBytes(); /* 设定不自动提交 */ boolean defaultCommit = con.getAutoCommit(); con.setAutoCommit(false); try { /* 查询CLOB对象并锁定 */ String sql = "SELECT " + blobColumnName + " FROM " + tabName + " WHERE " + idColumName + "='" + id + "' FOR UPDATE"; // System.out.println("clobModify String sql= "+sql); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { /* 获取此CLOB对象 */ oracle.sql.BLOB blob = (oracle.sql.BLOB) rs .getBlob(blobColumnName); // System.out.println(clob); // System.out.println("infile= "+infile); OutputStream blobWriter = blob.getBinaryOutputStream(); blobWriter.write(b,0,b.length); blobWriter.flush(); blobWriter.close(); } /* 正式提交 */ con.commit(); } catch (Exception ex) { /* 出错回滚 */ con.rollback(); ex.printStackTrace(); } /* 恢复原提交状态 */ con.setAutoCommit(defaultCommit); }
java 插入oracle blob_java oracle blob字段的插入
最新推荐文章于 2023-08-08 12:27:11 发布