¶ÁxmlÎļþ
ÍøÉÏÌṩµÄһЩ·½·¨±È½Ï¼òµ¥£¬ÎÞ·¨ÊÊÓ¦XMLÎļþµÄ¶¯Ì¬±ä»¯ £¬Ã»°ì·¨Ö»ÄÜ×Ô¼º²éÎĵµÐ´£¬×ÜËãûÀË·Ñʱ¼ä£¬ÓõÄʱºò±ðÍüÁ˼Ó#import
"msxml4.dll"Õâ¸ö¶¯Ì¬Á´½Ó¿âÍøÉϺܺÃÕÒ£¬×Ô¼ºÕÒһϣ¬Ï£ÍûÄܰïÖúÐèÒªµÄÅóÓÑ£¬À§ÁË
::CoInitialize(NULL);
//³õʼ»¯COM
MSXML2::IXMLDOMDocumentPtr pDoc;
MSXML2::IXMLDOMElementPtr
xmlRoot;
HRESULT hr =
pDoc.CreateInstance(__uuidof(MSXML2::DOMDocument30));
if(!SUCCEEDED(hr))
{
return
;
}
pDoc->load(".\\PortControlStrategy.xml");
MSXML2::IXMLDOMElementPtr
childNode;
childNode =
(MSXML2::IXMLDOMElementPtr)(pDoc->selectSingleNode("//StrategyGroup"));
MSXML2::IXMLDOMNodePtr
nextNode = NULL;
MSXML2::IXMLDOMNodeListPtr childNodeList;
do{
if(nextNode)
childNode
= (MSXML2::IXMLDOMElementPtr)nextNode;
MSXML2::IXMLDOMNodePtr
NodeName;
CString strAttrValue;
childNode->get_childNodes(&childNodeList);//
µÃµ½ËùÓÐ×Ó½ÚµãÁбí
for (int i=2; i<11;++i)
{
childNodeList->get_item(i,&NodeName);
strAttrValue
= (char*)(_bstr_t)NodeName->nodeTypedValue;
}
childNodeList->get_item(15,&NodeName);
strAttrValue
= (char*)(_bstr_t)NodeName->nodeTypedValue;
childNodeList->get_item(16,&NodeName);
strAttrValue
= (char*)(_bstr_t)NodeName->nodeTypedValue;
childNodeList->get_item(17,&NodeName);
strAttrValue
= (char*)(_bstr_t)NodeName->nodeTypedValue;
}
while (0 ==
childNode->get_nextSibling(&nextNode));//»ñÈ¡ÏÂÒ»¸ö³ÉÔ±
::CoUninitialize();
//xml
Îļþ¸ñʽÈçÏÂ
<?xml version="1.0" encoding="gb2312"?>
<PortControlStrategy>
<StrategyGroup>
<StraGroupNO>9</S
Ïà¹ØÎĵµ£º
1. <?xml version="1.0" encoding="GB2312" standalone="yes" ?>
1.1 ÕâÊÇxmlµÄÎĵµÉùÃ÷£¬Ò»°ãλÓÚxmlÎļþµÄÊ×ÐС£
1.2 Êéд¹æ·¶£º<?xmlΪһÌå Ö®¼ä²»ÄÜÓпոñ¡£
1.3 encodingÊôÐÔ£¬Èç¹ ......
/*--´æÎªXML
½«±í/²éѯ´æ´¢Îª±ê×¼µÄXMLÎļþ
--*/
/*--µ÷ÓÃʾÀý
--ÓÃSQLÓÃwinowsÉí·ÝÑéÖ¤µÄÇé¿ö
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml'
--ÓÃÖ¸¶¨µÄÓû§
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml',@userid='sa'
--*/
if exists (select * from db ......
·½·¨Ò» £ºÊ¹ÓÃXML¿Ø¼þ
<% @ Page Language="C#"%>
<html>
<body>
<h3><font face="Verdana">¶ÁÈ¡XML·½·¨Ò»</font></h3>
<from runat=server>
<asp:Xml id="xml1" DocumentSource="grade.xml" runat="server" />
</from>
</body>
</ ......