XSLT 将多个节点组合成单个节点 [英] XSLT combine multiple nodes into single node

查看：32
本文介绍了XSLT 将多个节点组合成单个节点的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

<RowSet>
 <Row>
  <Location_Long_Desc>Sydney Office</Location_Long_Desc>
  <Location_Code>SYDNEY</Location_Code>
  <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
  <Daypart_Code>PEANIG</Daypart_Code>
  <W_20050703_Dlr>30849.3</W_20050703_Dlr>
  <W_20050703_Spots>9</W_20050703_Spots>
  <W_20050710_Dlr>16.35</W_20050710_Dlr>
  <W_20050710_Spots>19</W_20050710_Spots>
 </Row>
</RowSet>

所以，我现在有了这个 XML，我需要将 W_ 节点转换为新的单个节点.使用这个 XSL

So, I have this XML now what I need to convert the W_ nodes into a new single node. Using this XSL

<?xml version="1.0"?>
  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" indent="yes"/>
  <xsl:template match="node()">
    <xsl:copy>
      <xsl:apply-templates select="node()"/>
    </xsl:copy>
  </xsl:template>
  <xsl:template match="*">
    <xsl:variable name="tmp" select="local-name()"/>
    <xsl:choose>
      <xsl:when test="starts-with($tmp, 'W_') and ends-with($tmp, '_Dlr')">
    <xsl:if test="text() != ''">
          <xsl:element name="Expenditure">
            <xsl:element name="Period">
              <xsl:value-of select="substring($tmp,3,8)"/>
            </xsl:element>
            <xsl:element name="Value">
              <xsl:apply-templates select="node()"/>
            </xsl:element>
            <xsl:element name="Spots">
              <xsl:apply-templates select="//RowSet/Row/W_20050703_Spots/text()"/>
            </xsl:element>
          </xsl:element>
    </xsl:if>
    </xsl:when>
    <xsl:otherwise>
        <xsl:element name="{$tmp}">
          <xsl:apply-templates select="node()"/>
        </xsl:element>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>
</xsl:stylesheet>

我几乎可以到达那里，但我有几个问题.

I can almost get there but I have a couple of issues.

  1. 我需要将 W_????????Dlr 和 W??????????_Spots 组合成一个单独的节点，但
  2. 我不知道如何在 xpath 语句中使用变量，或者我可能离我应该去的地方很远.
  1. I need to combine the W_????????Dlr and W????????_Spots into a individual nodes but
  2. I can't work out how to use a variable in an xpath statement, or maybe I'm miles off where I should be.

再说一次，我还在掌握这一切，所以请保持温柔;-)

Again, I'm still getting to grips with it all, so please be gentle ;-)

TIA

02/12/2010 12:00

02/12/2010 12:00

好的，

再问一个问题，根据数据库级别的切换(我完全忘记了)，Spots 节点可能存在也可能不存在.

Just a little further question, depending on a database level switch (which I forgot all about), the Spots node may or may not exist.

所以我仍然需要输出，尽管它不应该输出到后续兄弟节点不是有效的 _spots 节点的后续兄弟节点调用.

So I still need to output though it shouldn't to the following-sibling call where the following-sibling isn't a valid _spots node.

示例:

<RowSet>
 <Row>
  <Location_Long_Desc>Sydney Office</Location_Long_Desc>
  <Location_Code>SYDNEY</Location_Code>
  <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
  <Daypart_Code>PEANIG</Daypart_Code>
  <W_20050703_Dlr>30849.3</W_20050703_Dlr>
  <W_20050710_Dlr>16.35</W_20050710_Dlr>
 </Row>
</RowSet>

请注意，我通过 Oracle 包调用所有这些

Just so you know, I'm calling all this via an Oracle package

-- get the query context;
v_qryctx := dbms_xmlgen.newcontext(in_sql_query);

dbms_xmlgen.setnullhandling(v_qryctx, 2);
dbms_xmlgen.setrowsettag(v_qryctx, 'RowSet');
dbms_xmlgen.setrowtag(v_qryctx, 'Row');

IF in_export_type = cnst_export_booking
THEN
    dbms_xmlgen.setxslt(v_qryctx, v_booking_export_xsl);

ELSIF in_export_type = cnst_export_expenditure
THEN
    dbms_xmlgen.setxslt(v_qryctx, v_expenditure_export_xsl);

END IF;

推荐答案

这种转变:

<xsl:stylesheet version="1.0"
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output omit-xml-declaration="yes" indent="yes"/>
 <xsl:strip-space elements="*"/>

 <xsl:template match="node()|@*">
     <xsl:copy>
       <xsl:apply-templates select="node()|@*"/>
     </xsl:copy>
 </xsl:template>

 <xsl:template match=
 "*[starts-with(name(),'W_')
  and
   substring-after(substring-after(name(),'_'),'_')='Dlr'
  and
   text()
   ]">
  <Expenditure>
    <Period>
      <xsl:value-of select="substring(name(),3,8)"/>
    </Period>
    <Value>
      <xsl:apply-templates/>
    </Value>
      <xsl:apply-templates mode="extract" select=
      "following-sibling::*[1]
        [starts-with(name(),'W_')
       and
        substring-after(substring-after(name(),'_'),'_')='Spots'
         ]
       "/>
  </Expenditure>
 </xsl:template>

 <xsl:template mode="extract" match=
  "*[starts-with(name(),'W_')
  and
   substring-after(substring-after(name(),'_'),'_')='Spots'
    ]
  ">
   <Spots><xsl:value-of select="."/></Spots>
  </xsl:template>


 <xsl:template match=
  "*[starts-with(name(),'W_')
  and
   substring-after(substring-after(name(),'_'),'_')='Spots'
    ]
  "/>
</xsl:stylesheet>

应用于提供的源 XML 文档时:

<RowSet>
 <Row>
  <Location_Long_Desc>Sydney Office</Location_Long_Desc>
  <Location_Code>SYDNEY</Location_Code>
  <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
  <Daypart_Code>PEANIG</Daypart_Code>
  <W_20050703_Dlr>30849.3</W_20050703_Dlr>
  <W_20050703_Spots>9</W_20050703_Spots>
  <W_20050710_Dlr>16.35</W_20050710_Dlr>
  <W_20050710_Spots>19</W_20050710_Spots>
 </Row>
</RowSet>

产生想要的、正确的结果:

<RowSet>
   <Row>
      <Location_Long_Desc>Sydney Office</Location_Long_Desc>
      <Location_Code>SYDNEY</Location_Code>
      <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
      <Daypart_Code>PEANIG</Daypart_Code>
      <Expenditure>
         <Period>20050703</Period>
         <Value>30849.3</Value>
         <Spots>9</Spots>
      </Expenditure>
      <Expenditure>
         <Period>20050710</Period>
         <Value>16.35</Value>
         <Spots>19</Spots>
      </Expenditure>
   </Row>
</RowSet>

当应用于第二个提供的 XML 文档时，OP 在更新中请求:

when applied on the second provided XML document, requested in an Update by the OP:

<RowSet>
 <Row>
  <Location_Long_Desc>Sydney Office</Location_Long_Desc>
  <Location_Code>SYDNEY</Location_Code>
  <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
  <Daypart_Code>PEANIG</Daypart_Code>
  <W_20050703_Dlr>30849.3</W_20050703_Dlr>
  <W_20050710_Dlr>16.35</W_20050710_Dlr>
  <W_20050710_Spots>19</W_20050710_Spots>
 </Row>
</RowSet>

又是想要的正确结果(如果直接兄弟不是 W_nnnnnnnn_Spots，则不会生成 元素)是制作:

again the wanted, correct result (No <Spot> element is generated if the immediate sibling isn't a W_nnnnnnnn_Spots) is produced:

<RowSet>
   <Row>
      <Location_Long_Desc>Sydney Office</Location_Long_Desc>
      <Location_Code>SYDNEY</Location_Code>
      <Daypart_Long_Desc>Peak Night</Daypart_Long_Desc>
      <Daypart_Code>PEANIG</Daypart_Code>
      <Expenditure>
         <Period>20050703</Period>
         <Value>30849.3</Value>
      </Expenditure>
      <Expenditure>
         <Period>20050710</Period>
         <Value>16.35</Value>
         <Spots>19</Spots>
      </Expenditure>
   </Row>
</RowSet>

请注意:

  1. 使用身份规则按原样"复制任何节点.

  1. The use of the identity rule to copy any node "as-is".

覆盖标识模板仅适用于 W_nnnnnnnn_Dlr 元素.

使用空模板覆盖身份模板 匹配 W_nnnnnnnn_Spots 元素.

标准 XPath 函数的使用:name(), starts-with() 和 substring-after()

函数ends-with() 仅在 XPath 2.0 (XSLT 2.0) 中可用，在此 XSLT 1.0 解决方案中未使用.

The function ends-with() is only available in XPath 2.0 (XSLT 2.0) and isn't used in this XSLT 1.0 solution.

这篇关于XSLT 将多个节点组合成单个节点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆