[p]在一般情況下,asp都是寫把靜態(tài)頁面寫好,然后再在靜態(tài)頁面里添加asp代碼,即先頁面后程序.但是通過asp+xml文件的結(jié)合,把xml文擋數(shù)據(jù)與頁面綁定,即可以實現(xiàn)頁面設(shè)計與程序設(shè)計的分離.[/p]
[p]例子如下:[/p]
[p]以xml格式輸出的asp文件是根據(jù)當(dāng)初設(shè)計時,約定好的結(jié)構(gòu)輸出的,需要哪個字段,等等.[/p]
[p]set_xml.asp代碼如下:[/p]
[p]<%[br][color=#ff0000][color=#ff00ff]response.contenttype = "text/xml"[/color] [br]dim sql,rs,dd,conn[br]sql="select * from tb_book "[br]dd="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("xml.mdb")[br]set conn=server.createobject("adodb.connection")[br]conn.connectionstring=dd[br]conn.open [br]set rs=conn.execute(sql)[/color][br]%>[/p]
[p][br][br]<%[color=#ff0000]do while not rs.eof[/color]%>[br] [br] [br] <%=[color=#ff0000]rs("author")%[/color]>[br] [br] <%=[color=#ff0000]rs("publisher")%[/color]>[br] <%=[color=#ff0000]rs("isbn")%[/color]>[br] [br] <%=[color=#ff0000]rs("price")%[/color]>[br] [br]<%[br][color=#ff0000]rs.movenext[br]loop[br]set rs=nothing [br]conn.close[/color][br]%>[br][/p]
[p]數(shù)據(jù)庫表:[/p]

[p]靜態(tài)頁面代碼:[/p]
[p][br][br] [br] [color=#ff00ff][/color][br][br][br][/color][br][br][br][br][br][br][br]

新書推薦

[br][br][/p]
[p]效果如圖:[/p]