Java：Oracle XMLType + JDBC

使用Java中的Oracle XMLType和JDBC可以实现对XML数据的处理和操作。XMLType是Oracle数据库中的一种特殊数据类型，可用于存储和操作XML文档。JDBC是Java数据库连接技术的标准API，可以用于连接和操作各种数据库。

java
import java.sql.*;
public class OracleXMLTypeExample {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:xe";
        String username = "your_username";
        String password = "your_password";
        try {
            Connection connection = DriverManager.getConnection(jdbcUrl, username, password);
            System.out.println("Connected to Oracle database");
            // TODO: 在这里添加对XML数据的处理和操作
            connection.close();
            System.out.println("Disconnected from Oracle database");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

java
String xmlData = "John Doe30";
String insertQuery = "INSERT INTO xml_table (xml_data) VALUES (XMLType(?))";
PreparedStatement statement = connection.prepareStatement(insertQuery);
statement.setString(1, xmlData);
statement.executeUpdate();

java
String selectQuery = "SELECT xml_data FROM xml_table WHERE XMLExists('$p/age[text() > 25]' PASSING xml_data AS \"p\")";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(selectQuery);
while (resultSet.next()) {
    SQLXML xmlData = resultSet.getSQLXML("xml_data");
    // TODO: 对查询结果进行处理
    xmlData.free();
}

java
String updateQuery = "UPDATE xml_table SET xml_data = XMLQuery('replace value of $p/name with \"Jane Doe\"' PASSING xml_data AS \"p\") WHERE XMLExists('$p/name[text() = \"John Doe\"]' PASSING xml_data AS \"p\")";
Statement statement = connection.createStatement();
int rowCount = statement.executeUpdate(updateQuery);