利用XSL对XML中的数据进行数据显示之一

来源：互联网发布：淘宝一元秒杀网址编辑：程序博客网时间：2024/04/30 22:46

XML文件的内容（文件名Records.xml）如下：

<?xml version="1.0"?><?xml-stylesheet type="text/xsl" href ="RecordsColor.xslt"?><ArrayOfRecord xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">  <Record>    <SpentTime>2011-07-14T13:28:21</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,李琦,刘漱琰,万永刚</Share>    <Money>8.5</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-14T13:28:21</SpentTime>    <Provider>李琦</Provider>    <Share>王文赛,李琦,刘漱琰,万永刚</Share>    <Money>231.38</Money>    <Description>电费</Description>  </Record>  <Record>    <SpentTime>2011-07-14T13:28:21</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,李琦,刘漱琰,万永刚</Share>    <Money>50</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-14T13:28:21</SpentTime>    <Provider>刘漱琰</Provider>    <Share>王文赛,李琦,刘漱琰,万永刚</Share>    <Money>15</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-17T13:28:21</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,李琦,刘漱琰,万永刚</Share>    <Money>9</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-19T13:37:56</SpentTime>    <Provider>刘漱琰</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>34.5</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-19T13:37:56</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>29.6</Money>    <Description>面条</Description>  </Record>  <Record>    <SpentTime>2011-07-19T13:37:56</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>6</Money>    <Description>面条</Description>  </Record>  <Record>    <SpentTime>2011-07-19T13:37:56</SpentTime>    <Provider>李琦</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>58.8</Money>    <Description>水费</Description>  </Record>  <Record>    <SpentTime>2011-07-20T13:37:56</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>6</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-21T13:37:56</SpentTime>    <Provider>李琦</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>46.7</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-21T13:37:56</SpentTime>    <Provider>刘漱琰</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>5</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-23T13:37:56</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>52.5</Money>    <Description>买菜</Description>  </Record>  <Record>    <SpentTime>2011-07-23T13:37:56</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>5</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-24T13:37:56</SpentTime>    <Provider>李琦</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>6</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-24T13:37:56</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>5</Money>    <Description>馒头</Description>  </Record>  <Record>    <SpentTime>2011-07-25T13:37:56</SpentTime>    <Provider>王文赛</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>110</Money>    <Description>杂物</Description>  </Record>  <Record>    <SpentTime>2011-07-25T13:37:56</SpentTime>    <Provider>刘漱琰</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>61</Money>    <Description>杂物</Description>  </Record>  <Record>    <SpentTime>2011-07-27T17:54:18</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>28.5</Money>    <Description>杂物</Description>  </Record>  <Record>    <SpentTime>2011-07-27T18:29:38</SpentTime>    <Provider>刘漱琰</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>21</Money>    <Description>买鸡蛋</Description>  </Record>  <Record>    <SpentTime>2011-07-28T08:17:49</SpentTime>    <Provider>万永刚</Provider>    <Share>王文赛,万永刚,刘漱琰,李琦</Share>    <Money>15.8</Money>    <Description>面条</Description>  </Record></ArrayOfRecord>

XSLT文件如下：

<?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:template match="/ArrayOfRecord">    <html>      <body>        <style type="text/css">          table,tr,td,th {          background-position: center;          border-width: 1px;          border-style: solid;          border-collapse: collapse;          border-color: blue;          text-align: center;          font-size: 20px;          }          table {          width: 800px;          margin-bottom: 20px;          }          tr {          height: 40px;          }        </style>        <h2 align ="center">消费记录详情</h2>          <table border ="1" align ="center">          <tr>            <th>序号</th>            <th>消费日期</th>            <th>支付人</th>            <th>参与人员</th>            <th>消费金额</th>            <th>消费描述</th>          </tr>          <xsl:apply-templates/>        </table>      </body>    </html>   </xsl:template>     <xsl:template match="Record">      <tr>        <td>          <xsl:number value ="position()" format="1"/>        </td>        <td>          <xsl:value-of select="SpentTime"/>        </td>        <td>          <xsl:value-of select="Provider"/>        </td>        <td>          <xsl:value-of select="Share"/>        </td>        <td>          <xsl:value-of select="Money"/>        </td>        <td>          <xsl:value-of select="Description"/>        </td>      </tr>    </xsl:template> </xsl:stylesheet>

显示效果（目前还未实现分页的效果，会在以后的文章中进行补充）：