Hallo Alle
ich habe eine Datenbanktabelle "System" in der ich eine XML-Spalte "Configuration" habe, die die folgende XML-Struktur beinhaltet:
<system xmlns:xi="<a href="http://www.w3.org/2001/XInclude">http://www.w3.org/2001/XInclude</a>"
xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"
xsi:noNamespaceSchemaLocation="SystemConfiguration.xsd"
xsi:schemaLocation="<a href="http://www.w3.org/XML/1998/namespace">http://www.w3.org/XML/1998/namespace</a> ../xinclude/xml.xsd <a href="http://www.w3.org/2001/XInclude">XInclude</a> ../xinclude/xinclude.xsd ">
<components>
<component>
<name>FileNet</name>
<version>5.2.1.0</version>
<buildNumber>dap521.000.024</buildNumber>
</component>
<component>
<name>CSS</name>
<version>IQQD0055E The search server is stopped. It must be started for the tool to run.</version>
</component>
<component>
<name>CSS</name>
<version>2.1.0.0-1.1-4147.</version>
<fixpack>FP5</fixpack>
</component>
<component>
<name>TDS</name>
<version>6.3.1.0</version>
</component>
<component>
<name>ICN</name>
<version>2.0.2</version>
</component>
<component>
<name>CMIS</name>
<version>IBM Content Management Interoperability Services for FileNet Content Manager (IBM CMIS) Version 2.0.2.3</version>
</component>
<component>
<name>DB2</name>
<version>DB2 v10.1.0.2</version>
</component>
<component>
<name>WAS</name>
<version>8.5.5.1</version>
</component>
</components>
</system>
nun möchte ich in meiner JSP-Seite diesen nicht als native XML ausgeben, sondern in Form einer HTML-Tabelle. Hierbei ein Teil meines Codes
<table border="1">
<%
while (resultSet.next()){
DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();
Document doc = docBuilder.parse(resultSet.getSQLXML("Configuration").getBinaryStream());
doc.getDocumentElement().normalize();
Node node = doc.getDocumentElement();
Node componentsNode = null;
for (int i = 0; i < node.getChildNodes().getLength(); i++) {
if (node.getChildNodes().item(i).getNodeName().equalsIgnoreCase("components")) {
componentsNode = node.getChildNodes().item(i);
}
}
for (int i = 0; i < componentsNode.getChildNodes().getLength(); i++) {
Node childNode = componentsNode.getChildNodes().item(i);
if (childNode.getNodeName().equalsIgnoreCase("component")) {
%>
<tr>
<% if (childNode.hasChildNodes()) {
for (int k = 0; k < childNode.getChildNodes().getLength(); k++) {
Node cchildNode = componentsNode.getChildNodes().item(k);