我是在vb中写的,如果转到asp中,把头上的两句定义改一下,改成:
Dim a
Set a= server.CreateObject("Microsoft.XMLDOM")
Dim element
a.loadXML "<ROOT/>" ''loadXML方法,load一个xml字符串
a.documentElement.setAttribute "id", "00001" ''填写根节点属性id='00001'
Set element = a.createElement("Record") ''定义一个element变量
element.setAttribute "name", "yourname" ''增加element的属性name='yourname'
element.Text = "context" ''增加element的内容context
a.documentElement.appendChild element ''把element加到a.documentElement(根节点)的下面
response.write a.xml ''用字符串形式输出a
Dim a As New MSXML2.DOMDocument
Dim element As IXMLDOMElement
a.loadXML "<ROOT/>"
a.documentElement.setAttribute "id", "00001"
Set element = a.createElement("Record")
element.setAttribute "name", "yourname"
element.Text = "context"
a.documentElement.appendChild element
MsgBox a.xml
Dim conn
Set conn = server.CreateObject("ADODB.Connection")
conn.open = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=shool;Data Source=Theseus"
Dim xmldoc
Set xmldoc = server.CreateObject("Microsoft.XMLDOM")
Dim version
Set version = xmldoc.createProcessingInstruction("xml"," version='1.0' encoding='GB2312'")
xmldoc.appendChild(version)
Dim root
Set root = xmldoc.CreateNode("element","root"," ")
xmldoc.appendChild(root)
Sql = "select id,class_id,number,name,uuid,password from student"
Set rs = conn.Execute(Sql)
rs.MoveFirst
while (Not rs.EOF)
Set childNode = xmldoc.CreateNode("element","CD","")
root.appendChild(childNode)
For Each f in rs.Fields
Set childnextNode = xmldoc.CreateNode("element",f.name,"")
childnextNode.Text = f.Value
childNode.appendChild(childnextNode)
Next
<%
Sub AddElementToParent (domBook, elemParent, sChild, sValue)
Dim elemSubelement
Dim textSubelement
Set elemSubelement = domBook.CreateElement(sChild)
Set textSubelement = domBook.CreateTextNode(sValue)
elemSubelement.appendChild(textSubelement)
elemParent.appendChild(elemSubelement)
Set elemSubelement = Nothing
Set textSubelement = Nothing
End Sub
Sub WriteNodeXML (nodeTarget)
Dim i
If nodeTarget.NodeType = 1 Then
' Element
Response.Write "<" & nodeTarget.tagName & ">"
For i = 0 to nodeTarget.childNodes.Length - 1
WriteNodeXML nodeTarget.childNodes.item(i)
Next
Response.Write "</" & nodeTarget.tagName & ">"
ElseIf nodeTarget.NodeType = 3 Then
' Text Node
Response.Write nodeTarget.data
End If
End Sub
%>
<XML id=docBook>
<%
Dim fileInvoice
Dim tsInvoice
Dim domInvoice
Dim elemInvoice
Dim elemLineItem
While Not tsBook.AtEndOfStream
sLine = tsBook.ReadLine
If Left(sLine, 1) = "A" Then
AddElementToParent domBook, elemAuthors, "Author", Mid(sLine, 2)
Else
AddElementToParent domBook, elemRecSubjCategories, "Category", _
Mid(sLine, 2)
End If
Wend
tsBook.Close
WriteNodeXML elemBook
' and clear our objects
Set fileBook = Nothing
Set tsBook = Nothing
Set domBook = Nothing
Set elemBook = Nothing
Set elemAuthor = Nothing
Set elemRecSubjCategories = Nothing
Set elemAuthors = Nothing
%>
</XML>