代码之家  ›  专栏  ›  技术社区  ›  Jamey McElveen

如何从Microsoft Access中的IXMLDOMNodeList获取原始xml?

  •  0
  • Jamey McElveen  · 技术社区  · 17 年前

    4 回复  |  直到 17 年前
        1
  •  1
  •   Wim Coenen    17 年前

    你可以使用 Xml property

        2
  •  1
  •   James Birkholz James Birkholz    17 年前

    (这个查询是通过代理为我发布的。)所需的确切知识是获取web服务api返回的MSXML2.IXMLDOMNodeList对象,并从节点提取数据。我有一段可用于XML版本的工作代码,但我不想成为MSXML专家只是为了让一个函数工作。这是使用XML输入的版本,如何将其更改为使用节点列表输入?(还可以将节点列表输出为XML吗?这将有助于完成其余步骤。

    (加:) 我刚刚尝试了节点的.xml属性,这实际上提供了整个xml。显然,api发送了一个带有单个节点的节点列表,并将.xml属性应用于该节点,生成了一个完整的XMLdocument(我不知道如何在这里显示,xml在预览中处理)。 (/新增)

    Private Sub ParseXML_Click()
    
    Dim thisXML As MSXML2.DOMDocument
    Dim fSuccess As Boolean
    Dim oRoot     As MSXML2.IXMLDOMNode
    Dim oBooking  As MSXML2.IXMLDOMNode
    Dim oChildren As MSXML2.IXMLDOMNodeList
    Dim oChild    As MSXML2.IXMLDOMNode
    Dim theDB As Database
    Dim theRST As Recordset
    
    Set theDB = CurrentDb
    Set theRST = theDB.OpenRecordset("XMLBookings", dbOpenDynaset)
    
    Set thisXML = New MSXML2.DOMDocument
    thisXML.async = False
    thisXML.validateOnParse = False
    fSuccess = thisXML.LoadXml(Bookings_fld)
     ' If anything went wrong, quit now.
    If NotfSuccess Then
      GoTo ExitHere
    End If
    
    Set oRoot = thisXML.documentElement
    For Each oBooking In oRoot.childNodes
        theRST.AddNew
        Set oChildren = oBooking.childNodes
        For Each oChild In oChildren
            Select Case oChild.nodeName
            Case "EventName"
    '            MsgBox "EventName = " & oChild.nodeTypedValue
                theRST!EventName = oChild.nodeTypedValue
            Case 
            (etc)
    
            End Select
        Next oChild
            theRST.Update                         ' Save changes.
    Next oBooking
    
    MsgBox "Done!"
    theRST.Close
    Set theDB = Nothing
    
    ExitHere:
            Exit Sub
    HandleErr:
            MsgBox "Error " & Err.Number & ": " & Err.Description
            Resume ExitHere
            Resume
    
    End Sub
    
        3
  •  0
  •   Philippe Grondier    17 年前

    您将使用VBA执行此操作。

    编写如下代码:

    Public Function getFromXML(x_fileXML as string) as string
    
    On Error GoTo ERREUR
    
          Dim doc_xml As MSXML2.DOMDocument, _
              list_xml As IXMLDOMNodeList, _ 
              i As Long, _
              m_getFromXML as string
    
    
    Set doc_xml = New MSXML2.DOMDocument
    
    doc_xml.Load x_fileXML
    
    'i am interested by the nodeLists having a "attributeType: tag"'
    Set list_xml = doc_xml.getElementsByTagName("s:AttributeType")
    For i = 0 To (list_xml.Length - 1)
         'extract the requested data here'
         'something like m_getFromXML = m_getFromXML & ";" & ...'
    Next i
    
    getFromXML = m_getFromXML
    

    这是即时写的。请在离开程序之前检查要关闭/设置为“无”的对象。

        4
  •  0
  •   Albert D. Kallal    17 年前

    因此,如果您有一个xml字符串,它是一个数据表,那么您可以接收数据,将数据写到磁盘,然后执行Application.ImportXML。与这里给出的其他答案相比,这种方法的代码要少得多。

    以下是此概念的代码剪贴:

    Dim intF       As Integer
    Dim strF       As String
    Dim objXML     As Object
    
    Set objXML = CreateObject("MSXML2.XMLHTTP")
    objXML.Open "GET", "URL string here", False
    objXML.Send
    
    strF = "c:\t.xml"
    intF = FreeFile
    Open strF For Output As intF
    Write #intF, objXML.responsetext
    Close
    
    Application.ImportXML "c:\t.xml", acAppendData
    

    上面假设XML在文本中有一个目录或表def

    如:

    <CATALOG>
    <tblContacts>
    <ID>1</ID>
    <Last_x0020_Name>Kallal</Last_x0020_Name>
    <First_x0020_Name>Albert</First_x0020_Name>
    </tblContacts>
    <tblContacts>
    <ID>2</ID>
    <Last_x0020_Name>Smo</Last_x0020_Name>
    <First_x0020_Name>Joe</First_x0020_Name>
    </tblContacts>
    </CATALOG>
    
    推荐文章