University of Bahrain

University of Bahrain

Information Technology College

Computer Science Department

Semester 1, Year 2006/2007

ITCS 373: Class Lab Work

XML2

Instructor: Dr. Eshaa M. Alkhalifa

You should have completed your first XML and XSL scripts by now and know how to write a basic XML file.

Start a new document with HTML Kit. You can look back into your notes to know what initial statements to write to define your XML file.
Copy the following into your file;

<CD>

<TITLE>Empire Burlesque</TITLE>

<ARTIST>Bob Dylan</ARTIST>

<COMPANY>Columbia</COMPANY>

</CD>

<CD>

<TITLE>Hide your heart</TITLE>

<ARTIST>Bonnie Tylor</ARTIST>

<COMPANY>CBS Records</COMPANY>

</CD>

<CD>

<TITLE>Greatest Hits</TITLE>

<ARTIST>Dolly Parton</ARTIST>

</CD>

<CD>

<TITLE>Still got the blues</TITLE>

<COMPANY>Virgin redords</COMPANY>

</CD>

<CD>

<ARTIST>Eros Ramazzotti</ARTIST>

</CD>

<CD>

<TITLE>One night only</TITLE>

<COMPANY>Polydor</COMPANY>

</CD>

<CD>

<TITLE>Sylvias Mother</TITLE>

</CD>

<CD>

<TITLE>Maggie May</TITLE>

<ARTIST>Rod Stewart</ARTIST>

<COMPANY>Pickwick</COMPANY>

</CD>

<CD>

<TITLE>Romanza</TITLE>

<ARTIST>Andrea Bocelli</ARTIST>

<COMPANY>Polydor</COMPANY>

</CD>

<CD>

<TITLE>When a man loves a woman</TITLE>

<ARTIST>Percy Sledge</ARTIST>

<COMPANY>Atlantic</COMPANY>

</CD>

<CD>

<TITLE>Black angel</TITLE>

<ARTIST>Savage Rose</ARTIST>

</CD>

<CD>

<TITLE>1999 Grammy Nominees</TITLE>

<COMPANY>Grammy</COMPANY>

</CD>

<CD>

<TITLE>For the good times</TITLE>

<ARTIST>Kenny Rogers</ARTIST>

<COMPANY>Mucik Master</COMPANY>

</CD>

<CD>

<TITLE>Big Willie style</TITLE>

<ARTIST>Will Smith</ARTIST>

<COMPANY>Columbia</COMPANY>

</CD>

<CD>

<TITLE>Tupelo Honey</TITLE>

<ARTIST>Van Morrison</ARTIST>

<COMPANY>Polydor</COMPANY>

</CD>

<CD>

<TITLE>Soulsville</TITLE>

<COUNTRY>Norway</COUNTRY>

</CD>

<CD>

<ARTIST>Cat Stevens</ARTIST>

<COMPANY>Island</COMPANY>

</CD>

<CD>

<ARTIST>Sam Brown</ARTIST>

</CD>

<CD>

<TITLE>Bridge of Spies</TITLE>

<COMPANY>Siren</COMPANY>

</CD>

<CD>

<TITLE>Private Dancer</TITLE>

<ARTIST>Tina Turner</ARTIST>

<COMPANY>Capitol</COMPANY>

</CD>

<CD>

<TITLE>Midt om natten</TITLE>

<ARTIST>Kim Larsen</ARTIST>

<COMPANY>Medley</COMPANY>

</CD>

<CD>

<TITLE>Pavarotti Gala Concert</TITLE>

<ARTIST>Luciano Pavarotti</ARTIST>

<COMPANY>DECCA</COMPANY>

</CD>

<CD>

<ARTIST>Otis Redding</ARTIST>

<COMPANY>Atlantic</COMPANY>

</CD>

<CD>

<TITLE>Picture book</TITLE>

<ARTIST>Simply Red</ARTIST>

<COMPANY>Elektra</COMPANY>

</CD>

<CD>

<ARTIST>The Communards</ARTIST>

<COMPANY>London</COMPANY>

</CD>

<CD>

<TITLE>Unchain my heart</TITLE>

<ARTIST>Joe Cocker</ARTIST>

</CD>

</CATALOG>

Now write an XSL file to display this list with the following format.

The values you need to know are as follows; border=2, bgcolor=#ffe4c4 and you have five columns in a table and the first row is composed of <th> table header tags.
You should know by now, how to complete what is required. If you do not remember, look at the first exercise you did in XML.
Once you get the output shown above, you can start to alter it by using the various functions possible.
Hiding some of the information: Go to your XSL file and delete the line that displays the YEAR and look at your output. Rewrite the line that displays the year to display it again.
Using Sort: Go to your XSL file and replace the line <xsl:for-each select="CATALOG/CD"> with the line <xsl:for-each select="CATALOG/CD" order-by="+ YEAR"> Save your file and check if the output of the XML file is sorted according to increasing years.
Using Filter: A filter allows only content that belongs to a particular group appear in the data. We can implement a filter by altering the "CATALOG/CD" part of the for-each line to make it "CATALOG/CD[COUNTRY='UK']" This means that only the records that conform to that the country is UK will appear in the data. Save you file and check your XML file to make sure your filter works.
Using IF: We want to write the line with the information about Rod Stewart in bold while all others appear normally. Go to your XSL file and add the lines

<xsl:if match=".[ARTIST='Rod Stewart']">

<tr>

</tr>

</xsl:if>

Save your work and check the preview of the xml file to see that the record with Rod Stewart appears in bold but it appear twice. Do you know why? Do not change it, let it appear twice to show that you did this part correctly.
Using CHOOSE: Choose allows you to display a group of items in one way and other groups other ways. In our example we will have only two groups.
Use the command structure as follows:

<xsl:choose>

<xsl:when test="PRICE[. $le$ 9]">

<tr>

{Give this group the background color number #cccc66 and display all fields here}

</tr>

</xsl:when>

<xsl:otherwise>

<tr>

{display all fields without any change in the background from the original specified above this line of code}

</tr>

</xsl:otherwise>

</xsl:choose>

Your output page must look like this;

Notice that Rod Stewart must appear twice to show that you did the coding correctly.
You are done!!