xpath函数:实例简析XPath串函数和XSLT



=t18> XPath(XML Path language)是种处理XML文档段语言XSLT(Extensible Stylesheet Language Transformations,可扩展样式表语言转换)使用XPath描述表达式和地址路径控制节点选取XSLT可以将XML转换为各种格式如HTML或其他格式
下面用个邮件合并来简要介绍说明XPath下面XML文件中包含数据XSLT文件中包含对邮件格式定义MSXML4.0对XML文档应用样式表产生个合并邮件文本文档
XML文件 Letter.xml
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<Letter>

<Date>July 17, 2002</Date>

<To>
<FirstName>Vicky</FirstName>
<LastName>P</LastName>
<Sex>Male</Sex>
</To>

<Address>
<Line1>900 National Pkwy</Line1>
<Line2>Suite 105</Line2>
<City>Bellevue</City>
<State>WA</State>
<Zip>98007</Zip>
<Country>USA</Country>
</Address>

<Subject>ESTATE OF JOHN DOE / FILE NO. 12345.6789</Subject>

<Text>
Please pay the property taxes as soon as possible.
</Text>

<Sender>
<FirstName>John</FirstName>
<LastName>M</LastName>
<Title>Sr. Tax Consultant</Title>
</Sender>

</Letter>

XSLT样式表文档 Letter.xsl
<?xml version=\'1.0\' encoding=\"utf-8\"?>
<xsl:stylesheet version=\"1.0\"
xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\">

<xsl:output method=\"text\" indent=\"yes\"/>

<xsl:variable name=\"NL\" select=\"\'&#xA;\'\" />
<xsl:variable name=\"Para\" select=\"concat($NL, $NL)\" />

<xsl:template match=\"/\">

<xsl:value-of select=\"//Date\" />
<xsl:value-of select=\"$Para\" />

To,
<xsl:value-of select=\"concat(//To/FirstName, \' \', //To/LastName)\" />
<xsl:value-of select=\"$NL\" />

<xsl:value-of select=\"//Address/Line1\" />
<xsl:value-of select=\"$NL\" />

<xsl:value-of select=\"//Address/Line2\" />
<xsl:value-of select=\"$NL\" />

<xsl:value-of select=\"concat(//Address/City, \' \', //Address/State, \' \', //Address/Zip)\" />
<xsl:value-of select=\"$NL\" />

<xsl:value-of select=\"//Address/Country\" />
<xsl:value-of select=\"$Para\" />

Regarding: <xsl:value-of select=\"//Subject\" />
<xsl:value-of select=\"$NL\" />

Dear <xsl: test=\"starts-with(//Sex, \'M\')\">Mr. </xsl:><xsl: test=\"starts-with(//Sex, \'F\')\">Miss </xsl:>
<xsl:value-of select=\"concat(//To/FirstName, \' \', //To/LastName)\" />,
<xsl:value-of select=\"$Para\" />

<xsl:value-of select=\"//Text\" />
<xsl:value-of select=\"$Para\" />
Sincerely,
<xsl:value-of select=\"$Para\" />
<xsl:value-of select=\"concat(//Sender/FirstName, \' \', //Sender/LastName)\" />
<xsl:value-of select=\"$NL\" />
<xsl:value-of select=\"//Sender/Title\" />
</xsl:template>

</xsl:stylesheet>

上面样式表举例介绍说明了concat和starts-with XPath串和怎样在输出文本中增加新行还有定义和使用变量
下面是执行结果



1.VC6建立Win32控制台应用
2.在stdafx.h中添加下面代码:
# <TCHAR.H>
# <stdio.h>
# <time.h>
#import \"msxml4.dll\"
// If this import statement fails, you need to MSXML 4.0 SP1 from:
//http://msdn.microsoft.com/downloads/sample.asp?url=/MSDN-FILES/027/001/766/msdncompositedoc.xml

# <msxml2.h>
// If this statement fails, you need to MSXML 4.0 SP1 SDK from:
//http://msdn.microsoft.com/downloads/sample.asp?url=/MSDN-FILES/027/001/766/msdncompositedoc.xml
// You also need to add the file and library search path
// to Visual C\'s list of directories (Tools > Options... > Directories).

using MSXML2;

inline void EVAL_HR( HRESULT _hr )
{ FAILED(_hr) throw(_hr); }
# TEMP_SIZE _MAX_PATH // size of buffer
_TCHAR szTemp[TEMP_SIZE]; // multipurpose buffer _disibledevent=>


4.:
( argc, char* argv)
{
try
{
EVAL_HR(CoInitialize(NULL));

// Make sure that MSXML 4.0 is ed
(!isMSXMLInstalled)
-1;

// Make sure that XML and XSL file names are passed
// as command line parameters
(argc < 3)
// Show proper message here
-1;

IXMLDOMDocument2Ptr pXMLDoc = NULL;
IXMLDOMDocument2Ptr pXSLDoc = NULL;

// Load the XML document
(loadDocument(pXMLDoc, argv[1], true))
{
// Load the stylesheet
(loadDocument(pXSLDoc, argv[2], false))
{
_ftprf(stdout, pXMLDoc->transformNode(pXSLDoc));
}

{
prMSXMLError(pXSLDoc);
}
}

{
prMSXMLError(pXMLDoc);
}

}
catch(...)
{//exception handling
}

_ftprf(stdout, \"\\n\\nPress Enter to continue...\");
getchar;
CoUninitialize;
0;
}

5.XML文件和XSLT样式表文件名作为命令行参数传递给应用通过isMSXMLInstalled验证 MSXML4.0是否安装接下来两次loadDocument;先是加载XML文档,然后是加载XSLT样式表 最后transformNode进行转换
6.本例代码下载:http://www.perfectxml.com/CPPMSXML/downloads/20020716MailMerge.zip

译自PerfectXML

Tags:  excel函数实用实例 excel函数实例 xslt函数 xpath函数

延伸阅读

最新评论

发表评论