!--#include file="conn.asp"-->
%
session("count")=0

strURL = "http://" request.servervariables("SERVER_NAME") _
left(request.servervariables("SCRIPT_NAME"),len(request.servervariables("SCRIPT_NAME"))-len("/sitemap.asp"))

dim foolcat
foolcat = foolcat + "?xml version=""1.0"" encoding=""UTF-8""?>"
foolcat = foolcat + "!--Google Site Map File Generated by http://www.xxx.com " return_RFC822_Date(now,"GMT") "-->"
foolcat = foolcat + "urlset xmlns=""http://www.google.com/schemas/sitemap/0.84"">"

foolcat = foolcat + "url>"
foolcat = foolcat + "loc>" strURL "http://loc> "
foolcat = foolcat + "/url>"

session("count")=session("count")+"1"

set all_fs = Server.CreateObject("Scripting.FileSystemObject")
set all_folder = all_fs.GetFolder(server.MapPath("/"))
set all_files = all_folder.files
for each file in all_files

foolcat = foolcat + "url>"
foolcat = foolcat + "loc>" strURL "/" File.Name "/loc> "
foolcat = foolcat + "/url>"

session("count")=session("count")+"1"

next

dim js,sql
set js = server.CreateObject("ADODB.RecordSet")
sql = "select * from [要生成的表名] order by id asc" //修改你要生成的數(shù)據(jù)表名
set js = conn.execute (sql)
do until js.eof

id=""js("id")"" //修改為你的id字段

foolcat = foolcat + "url>"
foolcat = foolcat + "loc>" strURL "/xxx.asp?Id=" id "/loc> " //修改為你的文件名稱和id
foolcat = foolcat + "/url>"

session("count")=session("count")+"1"

js.movenext
loop
js.close
set js = nothing

foolcat = foolcat + "/urlset>"

foolcat = "" + foolcat + ""
foolcat = "" foolcat ""
FolderPath = Server.MapPath("/")
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set fout = fso.CreateTextFile(FolderPath"\sitemap.xml")
fout.writeLine foolcat
fout.close
set fout = nothing
conn.close
set conn = nothing

Function return_RFC822_Date(byVal myDate, byVal TimeZone)
Dim myDay, myDays, myMonth, myYear
Dim myHours, myMinutes, mySeconds

myDate = CDate(myDate)
myDay = EnWeekDayName(myDate)
myDays = Right("00" Day(myDate),2)
myMonth = EnMonthName(myDate)
myYear = Year(myDate)
myHours = Right("00" Hour(myDate),2)
myMinutes = Right("00" Minute(myDate),2)
mySeconds = Right("00" Second(myDate),2)


return_RFC822_Date = myDay", " _
myDays" " _
myMonth" " _
myYear" " _
myHours":" _
myMinutes":" _
mySeconds" " _
" " TimeZone
End Function

Function EnWeekDayName(InputDate)
Dim Result
Select Case WeekDay(InputDate,1)
Case 1:Result="Sun"
Case 2:Result="Mon"
Case 3:Result="Tue"
Case 4:Result="Wed"
Case 5:Result="Thu"
Case 6:Result="Fri"
Case 7:Result="Sat"
End Select
EnWeekDayName = Result
End Function

Function EnMonthName(InputDate)
Dim Result
Select Case Month(InputDate)
Case 1:Result="Jan"
Case 2:Result="Feb"
Case 3:Result="Mar"
Case 4:Result="Apr"
Case 5:Result="May"
Case 6:Result="Jun"
Case 7:Result="Jul"
Case 8:Result="Aug"
Case 9:Result="Sep"
Case 10:Result="Oct"
Case 11:Result="Nov"
Case 12:Result="Dec"
End Select
EnMonthName = Result
End Function
%>