So this semester at Florida International University (FIU) I’m learning a lot about working with XML.
So far I’ve been able to use XSLT files to take the data from an XML file and display it as HTML. One thing I seem to be having trouble with is managing HTML tables when nesting XSL templates. Here’s a sample code:
<?xml version=”1.0″ encoding=”utf-8″?>
<xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform”
xmlns:msxsl=”urn:schemas-microsoft-com:xslt” exclude-result-prefixes=”msxsl”
>
<xsl:output method=”html” indent=”yes”/>
<xsl:template match=”/”>
<html>
<title>Investment Accounts</title>
<h1>Investment Account</h1>
<body>
<p></p>
<table border=”1″ width=”800″>
<tr align=”center” style =”font-weight=bold”>
<td>ID</td>
<td>Name</td>
</tr>
<tr align=”center”>
<td>
<xsl:value-of select=”/accounts/account/id”/>
</td>
<td>
<xsl:value-of select=”/accounts/account/name”/>
</td>
</tr>
<tr>
<xsl:apply-templates select=”/accounts/account/investment”/>
</tr>
</table>
</body>
</html>
</xsl:template>
<xsl:template match =”/accounts/account/investment”>
<table border=”1″ width=”800″>
<tr>
<td style =”font-weight=bold”>Transactions for investment <xsl:value-of select=”@ticker”/>:
</td>
</tr>
<tr align=”center” font-weight=”bold”>
<td>Date</td>
<td>Price</td>
<td>Shares</td>
<td>Values</td>
</tr>
<tr>
<xsl:apply-templates select=”transaction”/>
</tr>
<tr style =”font-weight=bold”>
<td></td>
<td>Total Shares Processed: </td>
<td>
<xsl:value-of select=”sum(transaction/numShares)”/>
</td>
</tr>
</table>
</xsl:template>
<xsl:template match=”/accounts/account/investment/transaction”>
<tr align=”center”>
<td>
<xsl:value-of select=”date”/>
</td>
<td>
<xsl:value-of select=”price”/>
</td>
<td>
<xsl:value-of select=”numShares”/>
</td>
<td>
<xsl:value-of select=”format-number(price * numShares, ‘00,000.00’)”/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
Now I’m learning about reading XML files from a URL and then using JAVA to manipulate the data and then write a new XML, this should be fun!
suarezmiguel 