CLOB等大字段操作 证书操作

public void iaaaaa(Connection con, String certNo, String country, String data,String status,String addition) { String uuid = MyUUID.randomUUID().getUUID32(); insertSql ="INSERT INTO ccs_in_interface_xml(UUID,CERT_NO,DATA_XML,COUNTRY,STATUS,ADDITION) VALUES(?,?,empty_clob(),?,?,?)"; PreparedStatement stmt = null; try { con.setAutoCommit(false); stmt = con.prepareStatement(insertSql); log.info("flush data into database.record uuid="+uuid); stmt.setString(1, uuid); stmt.setString(2, certNo); //stmt.setClob(3, oracle.sql.CLOB.empty_lob()); stmt.setString(3, country); stmt.setString(4, status); stmt.setString(5, addition); stmt.execute(); if(stmt!=null){ stmt.close(); } // con.commit(); String sql = "select DATA_XML from ccs_in_interface_xml where UUID='"+uuid+"'"; stmt = con.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); oracle.sql.CLOB clob = null; if (rs.next()) { clob = (CLOB) rs.getClob("DATA_XML"); Writer writer = clob.getCharacterOutputStream(); writer.write(data); writer.flush(); writer.close(); rs.close(); con.commit(); } if(rs!=null){ rs.close(); } if (stmt != null) { stmt.close(); } } catch (SQLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { stmt = null; } } CLOB字段操作。 String strr = this.getClass().getResource("/cacerts").getPath(); log.info("证书库文件："+strr); System.setProperty("javax.net.ssl.keyStore", strr); System.setProperty("javax.net.ssl.keyStorePassword", "changeit"); log.info("指定证书库完成。"); System.setProperty("javax.net.ssl.trustStore", strr); System.setProperty("javax.net.ssl.trustStorePassword", "changeit"); log.info("指定信任证书库完成。");