ASP生成XML动态数据读取代码实例

ASP/XML文件生成与重定向

最新推荐文章于 2013-06-17 18:38:00 发布

原创最新推荐文章于 2013-06-17 18:38:00 发布 · 201 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#xml #asp #conn #username #sql

asp 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个使用ASP和ADO技术从数据库中获取数据并生成XML文件的过程。该过程包括连接数据库、查询特定用户的记录、创建XML文件并写入查询结果，最后通过浏览器重定向到另一个ASP页面。此外，还提供了一个示例，展示了如何直接创建包含固定数据的XML文件。

<%
username=request("username")
set rshot=server.CreateObject("adodb.recordset")
sql="select * from TZ_all where username='"&username&"' order by id desc"
rshot.open sql,conn,1,1
if not (rshot.eof and rshot.bof) then
i=0
do while not rshot.eof
line=line&" <value xid="""&i&""">"&rshot("rl_time")&"</value>"&vbcrlf&""
line2=line2&" <value xid="""&i&""">"&rshot("rl")&"</value>"&vbcrlf&""
i=i+1
rshot.movenext
loop
end if
rshot.close
set rshot=nothing

xmlfile=server.mappath("/party/amline/value_indicator/amline_rl_"&username&".xml")
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile = fso.CreateTextFile(xmlfile,True)
MyFile.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")
MyFile.WriteLine("<chart>")
MyFile.WriteLine(" <series>")
MyFile.WriteLine line
MyFile.WriteLine(" </series>")
MyFile.WriteLine(" <graphs>")
MyFile.WriteLine(" <graph gid=""1"">")
MyFile.WriteLine line2
MyFile.WriteLine(" </graph>")
MyFile.WriteLine(" </graphs>")
MyFile.WriteLine("</chart>")
MyFile.Close
response.Redirect("m_my_bar.asp?username="&username&"")
%>

<%
xmlfile=server.mappath("test1.xml")
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile = fso.CreateTextFile(xmlfile,True)
MyFile.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")
MyFile.WriteLine("<chart>")

MyFile.WriteLine(" <series>")
MyFile.WriteLine(" <value xid=""0"">1997</value>")
MyFile.WriteLine(" <value xid=""1"">1997</value>")
MyFile.WriteLine(" </series>")

MyFile.WriteLine(" <graphs>")
MyFile.WriteLine(" <graph gid=""1"">")
MyFile.WriteLine(" <value xid=""0"">50</value>")
MyFile.WriteLine(" <value xid=""1"">50</value>")
MyFile.WriteLine(" </graph>")
MyFile.WriteLine(" </graphs>")

MyFile.WriteLine("</chart>")
MyFile.Close
%>
<a href="test1.xml">查看XML文件内容</a>