在XML里如何根据属性ID读取它的节点值
在XML里怎么根据属性ID读取它的节点值
<ball>
<team id= "1 ">
<age> 42 </age>
<name> QQ </name>
<publisher> 科技出版社 </publisher>
</book>
<team id= "2 ">
<age> 61 </age>
<name> AA </name>
</team>
</ball>
假如知道id= "2 "那么怎么把
<age> 61 </age>
<name> AA </name>
节点里的值读取出来呢?
------解决方案--------------------
用XPATH即可 "/ball/team[@id=2]/age "
Set oDoc= CreateObject( "Msxml2.DOMDocument ")
oDoc.async= False
oDoc.Load "xx.xml "
Set oNode = oDoc.selectSingleNode( "/ball/team[@id=2]/age ")
sAge = oNode.text
Set oNode = oDoc.selectSingleNode( "/ball/team[@id=2]/name ")
sName = oNode.text
Set oNodes= Nothing
Set oDoc= Nothing
<ball>
<team id= "1 ">
<age> 42 </age>
<name> QQ </name>
<publisher> 科技出版社 </publisher>
</book>
<team id= "2 ">
<age> 61 </age>
<name> AA </name>
</team>
</ball>
假如知道id= "2 "那么怎么把
<age> 61 </age>
<name> AA </name>
节点里的值读取出来呢?
------解决方案--------------------
用XPATH即可 "/ball/team[@id=2]/age "
Set oDoc= CreateObject( "Msxml2.DOMDocument ")
oDoc.async= False
oDoc.Load "xx.xml "
Set oNode = oDoc.selectSingleNode( "/ball/team[@id=2]/age ")
sAge = oNode.text
Set oNode = oDoc.selectSingleNode( "/ball/team[@id=2]/name ")
sName = oNode.text
Set oNodes= Nothing
Set oDoc= Nothing