來原:www
<%
function Transform(xmlPath,xsltPath) Dim result, xsltDocument,xmlDocument Set xmlDocument=CreateObject("MSXML2.DOMDocument") xmlDocument.load(Server.MapPath(xmlPath)) Set xsltDocument = CreateObject("MSXML2.DOMDocument") xsltDocument.load(Server.MapPath(xsltPath)) result = xmlDocument.transformNode(xsltDocument) Set objXMLDOM = Nothing Set objXMLDOM_XSLT = Nothing Transform=result end function
%>
參數(shù)xmlPath指定將被轉(zhuǎn)換的XML的文件名。
參數(shù)xsltPath指定xls的文件名。
下面是將XML轉(zhuǎn)換成HTML的一個實例:
1、 XML存儲的數(shù)據(jù)文件(table.xml):
<?xml version="1.0" encoding="utf-8" ?>
<Items>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
<Item>
<Url>http://blog.163.com/lxd_201/</Url>
<Title>☆聊ゾ聊☆</Title>
</Item>
</Items>
2、 XSLT文件(table.xsl):
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:copyRight="http://xml.sz.luohuedu.net/">
<xsl:template match="/">
<!-- 定義常量 -->
<xsl:variable name="strTrLeft" select="'<tr>'"/>
<xsl:variable name="strTrRight" select="'</tr>'"/>
<!-- 計算總記錄數(shù) -->
<xsl:variable name="nTotal" select="count(/Items/Item)"/>
<!-- 定義列數(shù) -->
<xsl:variable name="nCols" select="4"/>
<!-- 當(dāng)最后一行輸出的單元格小于實際的列數(shù)的時候,用空內(nèi)容補(bǔ)齊所缺的單元格。計算需要的補(bǔ)齊的列數(shù) -->
<xsl:variable name="nLefted" select="$nCols - ($nTotal mod $nCols)"/>
<!-- 計算不需要補(bǔ)齊的行數(shù) -->
<xsl:variable name="nNotProcessedRow" select="$nTotal - ($nTotal mod $nCols)"/>
<table bgcolor="snow" border="1" cellpadding="5" cellspacing="2" borderColor="blue"
style="font-size:9pt">
<!-- 對于不需要補(bǔ)齊的行數(shù),直接輸出 -->
<xsl:for-each select="/Items/Item[position() < $nNotProcessedRow +1]">
<xsl:if test="position() mod $nCols = 1">
<xsl:value-of select="$strTrLeft" disable-output-escaping="yes"/>
</xsl:if>
<td>
<a target="_blank">
<xsl:attribute name="href">
<xsl:if test="contains(Url,'@')">mailto:</xsl:if>
<xsl:value-of select="Url"/>
</xsl:attribute>
<xsl:value-of select="Title"/>
</a>
</td>
<xsl:if test="position() mod $nCols = 0">
<xsl:value-of select="$strTrRight" disable-output-escaping="yes"/>
</xsl:if>
</xsl:for-each>
<!-- 轉(zhuǎn)換除去不需要補(bǔ)齊的記錄的剩余記錄 -->
<xsl:if test="$nLefted != 0 and $nLefted != $nCols">
<xsl:value-of select="$strTrLeft" disable-output-escaping="yes"/>
<xsl:for-each select="/Items/Item[position() >$nNotProcessedRow]">
<td>
<a target="_blank">
<xsl:attribute name="href">
<xsl:if test="contains(Url,'@')">mailto:</xsl:if>
<xsl:value-of select="Url"/>
</xsl:attribute>
<xsl:value-of select="Title"/>
</a>
</td>
</xsl:for-each>
<!--
如果nLefted不等于0和列數(shù),則需要進(jìn)行補(bǔ)齊,這里進(jìn)行遞歸調(diào)用,需要傳遞的參數(shù)有兩個:
nLefted:要補(bǔ)齊的列數(shù);
nCols:表格的列數(shù)。
-->
<xsl:call-template name="MyFun">
<xsl:with-param name="nLefted" select="$nLefted"/>
<xsl:with-param name="nCols" select="$nCols"/>
</xsl:call-template>
<xsl:value-of select="$strTrRight" disable-output-escaping="yes"/>
</xsl:if>
</table>
<p>
<xsl:value-of select="$nTotal"/>
</p>
</xsl:template>
<xsl:template name="MyFun">
<xsl:param name="nLefted"/>
<xsl:param name="nCols"/>
<xsl:if test=" $nLefted != 0 and $nLefted != $nCols">
<td>
<xsl:text disable-output-escaping="yes">&nbsp;</xsl:text>
</td>
<xsl:call-template name="MyFun">
<xsl:with-param name="nLefted" select="$nLefted - 1"/>
<xsl:with-param name="nCols" select="$nCols"/>
</xsl:call-template>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
3、 ASP代碼(index.asp):
<%
function Transform(xmlPath,xsltPath)
Dim result, xsltDocument,xmlDocument
Set xmlDocument=CreateObject("MSXML2.DOMDocument")
xmlDocument.load(Server.MapPath(xmlPath))
Set xsltDocument = CreateObject("MSXML2.DOMDocument")
xsltDocument.load(Server.MapPath(xsltPath))
result = xmlDocument.transformNode(xsltDocument)
Set objXMLDOM = Nothing
Set objXMLDOM_XSLT = Nothing
Transform=result
end function
%>
<%
htmlResult=Transform("table.xml","table.xsl")
response.Write(htmlResult)
%>
| 歡迎光臨 電子科大論壇-非清水河畔 (http://www.hallmarkedu.com/) | Powered by Discuz! X3.4 |