asp生成静态HTML(动态读取)
时间:2013-06-27 19:54:48
<!--#include file="admin_Checkuser.asp"-->
<%
call ConnectionDatabase()
dim str,str_new
str=""
str_new=""
sqlx="select id from Fl_Products order by id desc"
set rsx=conn.execute(sqlx)
do while not rsx.eof
str=str&rsx("id")&"|"
rsx.movenext :loop
rsx.close
sqlx="select id from Fl_News order by id desc"
set rsx=conn.execute(sqlx)
do while not rsx.eof
str_new=str_new&rsx("id")&"|"
rsx.movenext :loop
rsx.close
place=InStrRev(str,"|")
str=Left(str,place-1)
place=InStrRev(str_new,"|")
str_new=Left(str_new,place-1)
dim url,cwww,act
act=Trim(Request.QueryString("act"))
url =Request.ServerVariables("HTTP_HOST")
cwww="http://"+url
MakeHtm cwww&"/index.asp","../index.htm","首页写入成功!"
MakeHtm cwww&"/about.asp","../about.htm","企业简介写入成功!"
MakeHtm cwww&"/contact.asp","../contact.htm","联系我们写入成功!"
MakeHtm cwww&"/ry.asp","../ry.htm","资质荣誉写入成功!"
MakeHtm cwww&"/liuyan.asp","../liuyan.htm","联系我们写入成功!"
MakeHtm cwww&"/pro.asp","../pro.htm","产品展示写入成功!"
MakeHtm cwww&"/news.asp","../news.htm","生成车间写入成功!"
MakeHtm cwww&"/xinwen.asp","../xinwen.htm","新闻资讯写入成功!"
MakeHtm cwww&"/alliance.asp","../alliance.htm","销售网络写入成功!"
'生成产品
xstr=split(str,"|")
for i=0 to ubound(xstr)
MakeHtm cwww&"/uzProduct.asp?id="&xstr(i),"../uzProduct_"&xstr(i)&".htm","产品"&xstr(i)&"写入成功!"
next
xstr=split(str_new,"|")
for i=1 to ubound(xstr)/25+1
MakeHtm cwww&"/xinwen.asp?Page="&i,"../xinwen_"&i&".htm","新闻列表"&i&"写入成功!"
next
xstr=split(str_new,"|")
for i=0 to ubound(xstr)
MakeHtm cwww&"/uzNews.asp?id="&xstr(i),"../uzNews_"&xstr(i)&".htm","新闻"&xstr(i)&"写入成功!"
next
Function BytesToBstr(body,Cset)
dim objstream
set objstream = Server.CreateObject("adodb.stream")
objstream.Type = 1
objstream.Mode =3
objstream.Open
objstream.Write body
objstream.Position = 0
objstream.Type = 2
objstream.Charset = Cset
BytesToBstr = objstream.ReadText
objstream.Close
set objstream = nothing
End Function
Function MakeHtm(curl,turl,mess)
Set xml = Server.CreateObject("Microsoft.XMLHTTP")
'把下面的地址替换成你的首页的文件地址,一定要用http://开头的绝对路径,不能写相对路径
xml.Open "GET", curl, False
xml.Send
BodyText=xml.ResponseBody
BodyText=BytesToBstr(BodyText,"gb2312")
Set xml = Nothing
'替换
BodyText=RegReplace(BodyText,"uzProduct\.asp\?id=(\d*)", "uzProduct_$1.htm")
BodyText=RegReplace(BodyText,"uzNews\.asp\?id=(\d*)", "uzNews_$1.htm")
BodyText=RegReplace(BodyText,"xinwen\.asp\?Page=(\d*)", "xinwen_$1.htm")
BodyText=replace(BodyText,"index.asp","index.htm")
BodyText=replace(BodyText,"about.asp","about.htm")
BodyText=replace(BodyText,"pro.asp","pro.htm")
BodyText=replace(BodyText,"news.asp","news.htm")
BodyText=replace(BodyText,"liuyan.asp","liuyan.htm")
BodyText=replace(BodyText,"ry.asp","ry.htm")
BodyText=replace(BodyText,"xinwen.asp","xinwen.htm")
BodyText=replace(BodyText,"contact.asp","contact.htm")
Dim fso, MyFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile= fso.CreateTextFile(server.MapPath(turl), True)
MyFile.WriteLine(BodyText)
MyFile.Close
response.Write mess
response.Write "<br>"
End Function
Public Function RegReplace(sContent, sPatrn, sNewStr)
Dim oTempReg : Set oTempReg = New RegExp
With oTempReg
.IgnoreCase = True
.Global = True
.Pattern = sPatrn
RegReplace = .Replace(sContent, sNewStr)
End With
Set oTempReg = Nothing
End Function
call CloseDatabase()
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Untitled Document</title>
<style>
body,td{font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:10.5pt;}
</style>
</head>
<body>
</body>
</html>
来自 iisboy
标签:asp,生成静态HTML
0
投稿
猜你喜欢
教你轻松解决几种常见的SQL疑难问题
2009-01-07 14:25:00
在keras中对单一输入图像进行预测并返回预测结果操作
2023-03-10 10:07:04
js+css实现换肤效果
2024-04-17 09:53:54
php 备份数据库代码(生成word,excel,json,xml,sql)
2024-06-05 09:52:42
PHP实现异步定时多任务消息推送
2023-05-25 09:51:29
python安装scipy的步骤解析
2021-09-09 03:20:36
Python合并多个装饰器小技巧
2022-05-31 04:51:45
Python OpenCV实现传统图片格式与base64转换
2021-07-20 21:42:21
Go语言中Goroutine的设置方式
2024-05-13 10:40:43
OpenCV 读取图像imread的使用详解
2022-02-07 02:00:22
javascript 操作文件 实现方法小结
2024-04-22 12:48:27
安装pytorch报错torch.cuda.is_available()=false问题的解决过程
2022-05-09 20:32:07
Python+OpenCV实现图像融合的原理及代码
2022-08-01 00:03:52
解决pytorch 的state_dict()拷贝问题
2022-10-05 22:03:57
python 地图经纬度转换、纠偏的实例代码
2021-11-06 11:12:18
django为Form生成的label标签添加class方式
2022-08-13 12:01:44
sql server通过脚本进行数据库压缩全备份的方法【推荐】
2024-01-14 18:26:39
document.createElement()用法及注意事项
2008-04-21 15:16:00
在asp中使用存储过程
2008-02-26 12:17:00
python tkinter模块的简单使用
2021-11-20 16:52:33