Asp Access 创建静态文件/HTML
程序员文章站
2022-06-21 22:56:13
作用说明: 本代码实现从 access 提取数据以创建 html 文件, 不建文件夹. 如果文件名与要创建的文...
作用说明:
本代码实现从 access 提取数据以创建 html 文件, 不建文件夹.
如果文件名与要创建的文件名相同, 则覆盖, 跟 sql 的更新一样的原理.
待加功能: 删除与查找.
<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' subject : asp 创建静态文件/html by stabx
'
' writer : stabx<shawl.qiu@gmail.com>
'
' blog : http://btbtd.exblog.jp/ ;
'
' blog/site : phoenix.gi - p.gi / \ 绿色学院 - green institute
'
' date : 2006-5-22
'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
set rs = server.createobject("adodb.recordset")
sql = "select top 10 * from (select top 3500 * from ctarticle order by articleid asc) order by articleid desc" '子查询, 目前被认为比恐龙还恐龙
rs.open sql, mm_conn_string,1
while not rs.eof '循环创建查询的全部记录为 html 文件
cid_=rs("classid")
ncid_=rs("nclassid")
aid_=rs("articleid")
adt_=rs("dateandtime")
tt_=rs("title")
ct_=rs("content")
'em_=htmltotext(rs("email"))
'ht_=rs("hits")
'url_=rs("url")
'src_=rs("www")
'au_=htmltotext(rs("writer"))
response.write "<a href=""" & cid_ & "_"&ncid_&"_"&aid_&".htm"" target=""_blank"">"&cid_ & "_"&ncid_&"_"&aid_& ".htm</a> created at " & now() & "<br>" '链接创建好的文件
cfilename= cid_& "_"&ncid_&"_"&aid_& ".htm" '命名要创建的文件名
set dfso = createobject("scripting.filesystemobject")
set chtml = dfso.createtextfile(server.mappath(cfilename), true)'存在即覆盖
chtml.writeline("<html><head>")
chtml.writeline("<link rel='stylesheet' type='text/css' href='../css/css_first/ctarticle.css'>")
chtml.writeline("<title>"&sitename_&" "&tt_&"</title>")
chtml.writeline("</head><body>")
chtml.writeline("title: " & tt_& "<p/>" )
chtml.writeline("content: " & ct_& "<p/>" )
chtml.writeline("created by cid:"&cid_&" ncid:"&ncid_&" aid:"&aid_&"
")
aid_=clng(aid_)
chtml.writeline("page created on: " & now ())
chtml.writeline("</body></html>")
chtml.close
rs.movenext
wend
rs.close
set rs=nothing %>
本代码实现从 access 提取数据以创建 html 文件, 不建文件夹.
如果文件名与要创建的文件名相同, 则覆盖, 跟 sql 的更新一样的原理.
待加功能: 删除与查找.
复制代码 代码如下:
<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' subject : asp 创建静态文件/html by stabx
'
' writer : stabx<shawl.qiu@gmail.com>
'
' blog : http://btbtd.exblog.jp/ ;
'
' blog/site : phoenix.gi - p.gi / \ 绿色学院 - green institute
'
' date : 2006-5-22
'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
set rs = server.createobject("adodb.recordset")
sql = "select top 10 * from (select top 3500 * from ctarticle order by articleid asc) order by articleid desc" '子查询, 目前被认为比恐龙还恐龙
rs.open sql, mm_conn_string,1
while not rs.eof '循环创建查询的全部记录为 html 文件
cid_=rs("classid")
ncid_=rs("nclassid")
aid_=rs("articleid")
adt_=rs("dateandtime")
tt_=rs("title")
ct_=rs("content")
'em_=htmltotext(rs("email"))
'ht_=rs("hits")
'url_=rs("url")
'src_=rs("www")
'au_=htmltotext(rs("writer"))
response.write "<a href=""" & cid_ & "_"&ncid_&"_"&aid_&".htm"" target=""_blank"">"&cid_ & "_"&ncid_&"_"&aid_& ".htm</a> created at " & now() & "<br>" '链接创建好的文件
cfilename= cid_& "_"&ncid_&"_"&aid_& ".htm" '命名要创建的文件名
set dfso = createobject("scripting.filesystemobject")
set chtml = dfso.createtextfile(server.mappath(cfilename), true)'存在即覆盖
chtml.writeline("<html><head>")
chtml.writeline("<link rel='stylesheet' type='text/css' href='../css/css_first/ctarticle.css'>")
chtml.writeline("<title>"&sitename_&" "&tt_&"</title>")
chtml.writeline("</head><body>")
chtml.writeline("title: " & tt_& "<p/>" )
chtml.writeline("content: " & ct_& "<p/>" )
chtml.writeline("created by cid:"&cid_&" ncid:"&ncid_&" aid:"&aid_&"
")
aid_=clng(aid_)
chtml.writeline("page created on: " & now ())
chtml.writeline("</body></html>")
chtml.close
rs.movenext
wend
rs.close
set rs=nothing %>