使用xml结构获取Oracle CLOB的xml属性对

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Clob;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NamedNodeMap;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

public class OracleClobXMLParser {
    public static void main(String[] args) {
        try {
            // 连接到Oracle数据库
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password");
            
            // 执行查询
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT xml_clob FROM table_name");
            
            // 遍历查询结果
            while (rs.next()) {
                // 获取CLOB字段的值
                Clob clob = rs.getClob("xml_clob");
                String xmlString = clob.getSubString(1, (int) clob.length());
                
                // 使用DOM解析器解析XML文档
                DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
                DocumentBuilder builder = factory.newDocumentBuilder();
                Document doc = builder.parse(new InputSource(new StringReader(xmlString)));
                
                // 获取包含属性对的元素
                NodeList elements = doc.getElementsByTagName("element_name");
                for (int i = 0; i < elements.getLength(); i++) {
                    Element element = (Element) elements.item(i);
                    
                    // 获取元素的属性列表
                    NamedNodeMap attributes = element.getAttributes();
                    for (int j = 0; j < attributes.getLength(); j++) {
                        Node attribute = attributes.item(j);
                        String attributeName = attribute.getNodeName();
                        String attributeValue = attribute.getNodeValue();
                        
                        // 处理属性名和属性值
                        System.out.println("属性名：" + attributeName);
                        System.out.println("属性值：" + attributeValue);
                    }
                }
            }
            
            // 关闭连接
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}