目前在使用XML文件的过程中,常常要用到动态的XML文件,比如RSS源就是一种动态的XML文件,在这里介绍一种通过ASP实现的输出动态XML格式文件最简单的方法:
在ASP文件的最首行,加条语句:Response.ContentType = "text/XML"即可.
例子如下:
数据库表图:
代码如下:
<%
Response.ContentType &#61; "text/XML"
Dim sql,rs,dd,conn
sql&#61;"select * from tb_book "
dd&#61;"Provider&#61;microsoft.jet.oledb.4.0;data source&#61;"&Server.MapPath("xml.mdb")
set conn&#61;Server.CreateObject("ADODB.Connection")
conn.connectionstring&#61;dd
conn.open
Set rs&#61;conn.execute(sql)
%>
<%Do While Not rs.eof%>
<%&#61;rs("author")%>
<%&#61;rs("publisher")%>
<%&#61;rs("ISBN")%>
<%&#61;rs("price")%>
<%
rs.movenext
Loop
Set rs&#61;Nothing
conn.close
%>
Response.ContentType &#61; "text/XML"
Dim sql,rs,dd,conn
sql&#61;"select * from tb_book "
dd&#61;"Provider&#61;microsoft.jet.oledb.4.0;data source&#61;"&Server.MapPath("xml.mdb")
set conn&#61;Server.CreateObject("ADODB.Connection")
conn.connectionstring&#61;dd
conn.open
Set rs&#61;conn.execute(sql)
%>
<%Do While Not rs.eof%>
<%
rs.movenext
Loop
Set rs&#61;Nothing
conn.close
%>
效果如图:
作者&#xff1a;mrlelong