首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

怎么读这个XML

2012-03-09 
如何读这个XMLxmlxmlns:s uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882xmlns:dt uuid:C2F41010-65B3-11d

如何读这个XML
<xml   xmlns:s= 'uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882 '
xmlns:dt= 'uuid:C2F41010-65B3-11d1-A29F-00AA00C14882 '
xmlns:rs= 'urn:schemas-microsoft-com:rowset '
xmlns:z= '#RowsetSchema '>
<s:Schema   id= 'RowsetSchema '>
<s:ElementType   name= 'row '   content= 'eltOnly '   rs:updatable= 'true '>
<s:AttributeType   name= 'id '   rs:number= '1 '   rs:maydefer= 'true '   rs:writeunknown= 'true '   rs:basetable= 'Relation '
  rs:basecolumn= 'id '   rs:keycolumn= 'true '   rs:autoincrement= 'true '>
<s:datatype   dt:type= 'int '   dt:maxLength= '4 '   rs:precision= '10 '   rs:fixedlength= 'true '/>
</s:AttributeType>
<s:AttributeType   name= 'EmployeeNo '   rs:number= '2 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'EmployeeNo '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:AttributeType   name= 'Relation '   rs:number= '3 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'Relation '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:AttributeType   name= 'RelationPeopleName '   rs:number= '4 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'RelationPeopleName '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:AttributeType   name= 'RelationPeopleAge '   rs:number= '5 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'RelationPeopleAge '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:AttributeType   name= 'RelationPeopleFactory '   rs:number= '6 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'RelationPeopleFactory '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:AttributeType   name= 'RelationPeopleSalaryDute '   rs:number= '7 '   rs:nullable= 'true '   rs:maydefer= 'true '   rs:writeunknown= 'true '
  rs:basetable= 'Relation '   rs:basecolumn= 'RelationPeopleSalaryDute '>
<s:datatype   dt:type= 'string '   dt:maxLength= '50 '/>
</s:AttributeType>
<s:extends   type= 'rs:rowbase '/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row   id= '49 '   EmployeeNo= '1000 '   Relation= '1 '   RelationPeopleName= '1 '   RelationPeopleAge= '1 '   RelationPeopleFactory= '1 '


  RelationPeopleSalaryDute= '1 '/>
<z:row   id= '50 '   EmployeeNo= '1000 '   Relation= '2 '   RelationPeopleName= '2 '   RelationPeopleAge= '2 '   RelationPeopleFactory= '2 '
  RelationPeopleSalaryDute= '2 '/>
<z:row   id= '51 '   EmployeeNo= '1000 '   Relation= '3 '   RelationPeopleName= '3 '   RelationPeopleAge= '3 '   RelationPeopleFactory= '3 '
  RelationPeopleSalaryDute= '3 '/>
<z:row   id= '52 '   EmployeeNo= '1000 '   Relation= '4 '   RelationPeopleName= '4 '   RelationPeopleAge= '4 '   RelationPeopleFactory= '4 '
  RelationPeopleSalaryDute= '4 '/>
</rs:data>
</xml>


想要读出   z:row   里的数据

[解决办法]
sFile = "row.xml "
Set oDoc= CreateObject( "Msxml2.DOMDocument ")
With oDoc
.async= False
.Load sFile
If .parseError.errorCode <> 0 Then
Response.Write .parseError.reason
Set oDoc = Nothing
End If
End With
Set oNodes = oDoc.selectNodes( "//z:row ")

For i=0 To oNodes.length-1
Response.Write oNodes(i).getAttribute( "EmployeeNo ") & " <br> "
Response.Write oNodes(i).getAttribute( "Relation ") & " <br> "
Response.Write oNodes(i).getAttribute( "RelationPeopleName ") & " <br> "
Response.Write oNodes(i).getAttribute( "RelationPeopleAge ") & " <br> "
Response.Write oNodes(i).getAttribute( "RelationPeopleFactory ") & " <br> "

Next
Set oNodes = Nothing
Set oDoc = Nothing

热点排行