最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
ADO Recordset 持久化 格式 XML 读取 保存
时间:2022-06-30 10:30:05 编辑:袖梨 来源:一聚教程网
<%
Class DataSet
Private Recordset
Public TableName, FieldCount
Public XmlString
Private TableMap
Private Sub Class_Initialize ' 设置 Initialize 事件。
Set Recordset = Server.CreateObject("ADODB.RecordSet")
Recordset.ActiveConnection = "Provider=MSDAOSP; Data Source=Msxml2.DSOControl;"
End Sub
Private Sub Class_Terminate ' 设置 Terminate 事件。
Set Recordset = Nothing
End Sub
Function ReadXml(Name, filespec)
TableName = Name
Recordset.Open(filespec)
End Function
Function GetXml()
Call GetTableMap()
Do While not Recordset.Eof
XmlString = XmlString + GetXmlRow(Recordset.Fields)
Recordset.MoveNext()
Loop
Recordset.Close
XmlString = XmlRow(TableName, XmlString)
GetXml = XmlString
End Function
Sub GetTableMap()
IF (not Recordset.Eof) Then
FieldCount = Recordset.Fields.Count - 2
Execute("ReDim TableMap("& FieldCount &")")
For i = 0 To FieldCount
TableMap(i) = Recordset.Fields.Item(i).Name
Next
End IF
End Sub
Function GetXmlRow(Item)
Dim XmlRowString
For i = 0 To FieldCount
XmlRowString = XmlRowString + XmlField(TableMap(i), Item(i).Value)
Next
GetXmlRow = XmlRow("Row", XmlRowString)
End Function
Function XMlEncode(XmlString)
XmlString = Replace(XmlString, "<", "<")
XmlString = Replace(XmlString, ">", ">")
XMlEnCode = XmlString
End Function
Function XmlField(NodeName, NodeValue)
XmlField = "<"+ NodeName +">"+ XMlEncode(NodeValue) +""+ NodeName +">"
相关文章
- 瞬间心动的温柔短句收集66句 11-06
- 燕云十六声好玩吗 燕云十六声游戏优缺点分析 11-06
- 燕云十六声最新可用的兑换码 2025年最新兑换码福利领取 11-06
- 燕云十六声云游戏入口 云燕云十六声网页版畅玩地址 11-06
- 莱莎的炼金工房3兑换码分享 终结之炼金术士与秘密钥匙DX兑换码 11-06
- 莱莎的炼金工房2兑换码是什么 失落传说与秘密妖精DX兑换码 11-06