更新时间:2023-11-24 21:01:52
我需要知道两件事:
1.所有课程
I need know two things: 1.all courses
使用:
/*/*/Courses/Course[not(Name = preceding::Course/Name)]
2。以及如何
2.And how many students studing in each course.
对于给定的课程使用:
count(/*/Student[Courses/Course/@Id = $vCourseId])
其中 $ vCourseId
必须用实际的课程ID代替。
where $vCourseId
must be substituted with the actual course Id.
基于XSLT的验证:
<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="/">
<xsl:copy-of select=
"/*/*/Courses/Course[not(Name = preceding::Course/Name)]"/>
===============
<xsl:for-each select=
"/*/*/Courses/Course[not(Name = preceding::Course/Name)]">
<xsl:variable name="vCourseId" select="@Id"/>
Course Id = <xsl:value-of select="@Id"/>, Students = <xsl:text/>
<xsl:value-of select="count(/*/Student[Courses/Course/@Id = $vCourseId])"/>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
当此转换应用于提供的XML文档时:
<Students> -
<Student Id="001">
<Name>Peter</Name>
<LastName>Kohen</LastName> -
<Courses> -
<Course Id="01">
<Name>C#</Name>
</Course> -
<Course Id="02">
<Name>Java</Name>
</Course>
</Courses>
</Student> -
<Student Id="002">
<Name>Nick</Name>
<LastName>Nikes</LastName> -
<Courses> -
<Course Id="02">
<Name>Java</Name>
</Course> -
<Course Id="03">
<Name>Oracle</Name>
</Course>
</Courses>
</Student> -
<Student Id="003">
<Name>Rafi</Name>
<LastName>rafifa</LastName> -
<Courses> -
<Course Id="02">
<Name>Java</Name>
</Course> -
<Course Id="03">
<Name>Oracle</Name>
</Course>
</Courses>
</Student> -
<Student Id="004">
<Name>Yosi</Name>
<LastName>Koen</LastName> -
<Courses> -
<Course Id="04">
<Name>SQL</Name>
</Course> -
<Course Id="03">
<Name>Oracle</Name>
</Course>
</Courses>
</Student>
</Students>
对两个XPath表达式(每个课程重复第二个)进行求值,并计算结果这些评估将复制到输出中:
<Course Id="01">
<Name>C#</Name>
</Course>
<Course Id="02">
<Name>Java</Name>
</Course>
<Course Id="03">
<Name>Oracle</Name>
</Course>
<Course Id="04">
<Name>SQL</Name>
</Course>
===============
Course Id = 01, Students = 1
Course Id = 02, Students = 3
Course Id = 03, Students = 3
Course Id = 04, Students = 1