Meeskond: Travo 2.0 XML - Revision history

https://wiki.itcollege.ee/index.php?action=history&feed=atom&title=Meeskond%3A_Travo_2.0_XML Meeskond: Travo 2.0 XML - Revision history 2026-06-16T17:14:24Z Revision history for this page on the wiki MediaWiki 1.45.1 https://wiki.itcollege.ee/index.php?title=Meeskond:_Travo_2.0_XML&diff=102269&oldid=prev Treinpal: Created page with "== XML/XSD/XSLT == === XML === <pre> <?xml version="1.0" encoding="utf-8" ?> <?xml-stylesheet type="text/xsl" href="XML.xslt" ?>  <School> <!-- Klas..." 2016-03-27T20:05:26Z

<p>Created page with "== XML/XSD/XSLT == === XML === <pre> <?xml version="1.0" encoding="utf-8" ?> <?xml-stylesheet type="text/xsl" href="XML.xslt" ?>  <School> <br /> <School><br /> <br /> <Groups><br /> <Group id="1"><br /> <Name><![CDATA[1]]></Name><br /> <br /> <Group id="2"><br /> <Name><![CDATA[1A]]></Name><br /> </Group><br /> <Group id="3"><br /> <Name><![CDATA[1B]]></Name><br /> </Group><br /> </Group><br /> <br /> <Group id="4"><br /> <Name><![CDATA[2]]></Name><br /> <br /> <Group id="5"><br /> <Name><![CDATA[2A]]></Name><br /> </Group><br /> <Group id="6"><br /> <Name><![CDATA[2B]]></Name><br /> </Group><br /> </Group><br /> </Groups><br /> <br /> <br /> <Students><br /> <Student id="1" birthDate="2008-03-09 16:05:07.123"><br /> <Name><![CDATA[Mait Käver]]></Name><br /> <GroupId>2</GroupId><br /> </Student><br /> <Student id="2" birthDate="2008-03-09 16:05:07.123"><br /> <Name><![CDATA[Poska-Käver Maitandres]]></Name><br /> <GroupId>2</GroupId><br /> </Student><br /> <Student id="3" birthDate="2008-03-09 16:05:07.123"><br /> <Name><![CDATA[Andres Poska]]></Name><br /> <GroupId>5</GroupId><br /> </Student><br /> </Students><br /> <br /> <br /> <Courses><br /> <Course id="1"><br /> <Name><![CDATA[Võrgurakendused 2: XML-i algkursus C# baasil]]></Name><br /> <Students><br /> <Student id="1"></Student><br /> <Student id="2"></Student><br /> </Students><br /> </Course><br /> <Course id="2"><br /> <Name><![CDATA[XML 3: C# baaskursus Java baasil]]></Name><br /> <Students><br /> <Student id="1"></Student><br /> <Student id="2"></Student><br /> <Student id="3"></Student><br /> </Students><br /> </Course><br /> </Courses><br /> </School><br /> </pre><br /> === XSD ===<br /> <pre><br /> <?xml version="1.0" encoding="utf-8"?><br /> <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"><br /> <xs:element name="School"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element name="Groups"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element maxOccurs="unbounded" name="Group"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element name="Name"><br /> <xs:simpleType><br /> <xs:restriction base="xs:string"><br /> <xs:minLength value="1"/><br /> <xs:maxLength value="32"/><br /> </xs:restriction><br /> </xs:simpleType><br /> </xs:element><br /> <xs:element maxOccurs="unbounded" name="Group"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element name="Name"><br /> <xs:simpleType><br /> <xs:restriction base="xs:string"><br /> <xs:minLength value="1"/><br /> <xs:maxLength value="32"/><br /> </xs:restriction><br /> </xs:simpleType><br /> </xs:element><br /> </xs:sequence><br /> <xs:attribute name="id" type="xs:unsignedByte" use="required" /><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> <xs:attribute name="id" type="xs:unsignedByte" use="required" /><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> </xs:complexType><br /> </xs:element><br /> <xs:element name="Students"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element maxOccurs="unbounded" name="Student"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element name="Name"><br /> <xs:simpleType><br /> <xs:restriction base="xs:string"><br /> <xs:minLength value="1"/><br /> <xs:maxLength value="32"/><br /> </xs:restriction><br /> </xs:simpleType><br /> </xs:element><br /> <xs:element name="GroupId" type="xs:unsignedByte" /><br /> </xs:sequence><br /> <xs:attribute name="id" type="xs:unsignedByte" use="required" /><br /> <xs:attribute name="birthDate" type="xs:string" use="required" /><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> </xs:complexType><br /> </xs:element><br /> <xs:element name="Courses"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element maxOccurs="unbounded" name="Course"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element name="Name"><br /> <xs:simpleType><br /> <xs:restriction base="xs:string"><br /> <xs:minLength value="1"/><br /> <xs:maxLength value="32"/><br /> </xs:restriction><br /> </xs:simpleType><br /> </xs:element><br /> <xs:element name="Students"><br /> <xs:complexType><br /> <xs:sequence><br /> <xs:element maxOccurs="unbounded" name="Student"><br /> <xs:complexType><br /> <xs:attribute name="id" type="xs:unsignedByte" use="required" /><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> <xs:attribute name="id" type="xs:unsignedByte" use="required" /><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> </xs:complexType><br /> </xs:element><br /> </xs:sequence><br /> </xs:complexType><br /> </xs:element><br /> </xs:schema><br /> </pre><br /> === XSLT ===<br /> <pre><br /> <?xml version="1.0" encoding="UTF-8"?><br /> <br /> <xsl:stylesheet version="1.0"<br /> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><br /> <xsl:output method="html" indent="yes"/><br /> <br /> <br /> <xsl:key name="group" match="Group" use="@id" /><br /> <xsl:key name="student" match="School/Students/Student" use="@id" /><br /> <br /> <xsl:template match="/"><br /> <html><br /> <body><br /> <h1>Kool</h1><br /> <br /> <br /> <h2>Klassid</h2><br /> <xsl:for-each select="School/Groups/Group"><br /> <h4><br /> Klassi grupp: <xsl:value-of select="Name"/><br /> </h4><br /> <br /> <table border="1"><br /> <tr bgcolor="#9acd32"><br /> <th>Id</th><br /> <th>Nimi</th><br /> </tr><br /> <xsl:for-each select="Group"><br /> <tr><br /> <td><br /> <xsl:value-of select="@id"/><br /> </td><br /> <td><br /> <xsl:value-of select="Name"/><br /> </td><br /> </tr><br /> </xsl:for-each><br /> </table><br /> </xsl:for-each><br /> <br /> <br /> <h2>Õpilased</h2><br /> <table border="1"><br /> <tr bgcolor="#9acd32"><br /> <th>Id</th><br /> <th>Nimi</th><br /> <th>Klass</th><br /> </tr><br /> <xsl:for-each select="School/Students/Student"><br /> <tr><br /> <td><br /> <xsl:value-of select="@id"/><br /> </td><br /> <td><br /> <xsl:value-of select="Name"/><br /> </td><br /> <td><br /> <xsl:for-each select="key('group', GroupId)"><br /> <xsl:value-of select="Name"/><br /> </xsl:for-each><br /> </td><br /> </tr><br /> </xsl:for-each><br /> </table><br /> <br /> <br /> <h2>Kursused</h2><br /> <table border="1"><br /> <tr bgcolor="#9acd32"><br /> <th>Id</th><br /> <th>Nimi</th><br /> <th>Tudengid</th><br /> </tr><br /> <xsl:for-each select="School/Courses/Course"><br /> <tr><br /> <td><br /> <xsl:value-of select="@id"/><br /> </td><br /> <td><br /> <xsl:value-of select="Name"/><br /> </td><br /> <td><br /> <xsl:for-each select="key('student', Students/Student/@id)"><br /> <xsl:value-of select="Name"/><br /> <br/><br /> </xsl:for-each><br /> </td><br /> </tr><br /> </xsl:for-each><br /> </table><br /> </body><br /> </html><br /> </xsl:template><br /> </xsl:stylesheet><br /> </pre></div>

Treinpal