按父节点parentValue汇总elementvalue，求修正代码实现预期结果

Got it, let's solve this problem where we need to calculate the total of elementvalue for each parent node, returning 0 if there are no associated elements. First, let's start with a complete example XML based on your snippet to work with:

<root>
  <parent>
    <parentValue>Val1</parentValue>
    <element>
      <elementname>A</elementname>
      <elementvalue>10</elementvalue>
    </element>
    <element>
      <elementname>B</elementname>
      <elementvalue>20</elementvalue>
    </element>
  </parent>
  <parent>
    <parentValue>Val2</parentValue>
    <element>
      <elementname>C</elementname>
      <elementvalue>50</elementvalue>
    </element>
  </parent>
  <parent>
    <parentValue>Val3</parentValue>
    <!-- No element nodes here -->
  </parent>
</root>

Solution 1: XSLT (Native XML Transformation) #

If you're working with XML directly, XSLT is a perfect fit for this kind of aggregation. Here's a stylesheet that will output the parent value and its summed total:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" indent="yes"/>
  
  <xsl:template match="/root">
    <xsl:for-each select="parent">
      <!-- Print the parent value -->
      <xsl:value-of select="parentValue"/>
      <xsl:text>: </xsl:text>
      <!-- Sum all elementvalue nodes; returns 0 if no elements exist -->
      <xsl:value-of select="sum(element/elementvalue)"/>
      <xsl:text>&#10;</xsl:text> <!-- Add a new line between entries -->
    </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

How it works: #

• sum(element/elementvalue) calculates the total of all elementvalue child nodes under the current parent. In XSLT 1.0+, this function returns 0 automatically if there are no matching element nodes, which handles your "no elements = 0" requirement perfectly.
• The output will be plain text with each parent and its total, like:

  Val1: 30
  Val2: 50
  Val3: 0
  

Solution 2: Python (Using ElementTree) #

If you prefer a programming language approach, Python's built-in xml.etree.ElementTree makes this straightforward:

import xml.etree.ElementTree as ET

# Parse the XML file (replace 'input.xml' with your file path or use ET.fromstring() for a string)
tree = ET.parse('input.xml')
root = tree.getroot()

# Iterate over each parent node
for parent in root.findall('parent'):
    parent_value = parent.find('parentValue').text
    # Calculate the sum of elementvalues
    total = sum(int(elem.find('elementvalue').text) for elem in parent.findall('element'))
    # Print or store the result
    print(f"{parent_value}: {total}")

How it works: #

• We use a generator expression to loop through all element nodes under each parent, convert their elementvalue text to integers, and sum them up.
• If there are no element nodes, the sum defaults to 0 exactly as you need.

Fixing Your Existing Code #

You mentioned you have existing code that needs correction—if you can share it (including the language/library you're using), I can help adjust it to meet this requirement. For example, if you were using XPath in C#, or XQuery in a database, the approach would vary slightly but the core logic (sum per parent, handle empty case) remains the same.

内容的提问来源于stack exchange，提问作者user1503496