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("指定信任证书库完成。");
