–
<%@LANGUAGE=”VBSCRIPT” CODEPAGE=”65001″%>
<%
Response.Charset=”UTF-8″
Session.CodePage=65001
Dim db,Conn,Rs
Set Conn=Server.CreateObject(“Adodb.Connection”)
db=”db1.mdb”
Conn.Open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”&Server.MapPath(db)
‘Conn.Open “Driver={Microsoft Access Driver (*.mdb)};DBQ=”&Server.MapPath(db)
‘//轉(zhuǎn)換時間為GMT(RFC822)格式
Function DateTimeToGMT(sDate)
Dim dWeek,dMonth
Dim strZero,strZone
strZero=”00″
strZone=”+0800″
dWeek=Array(“Sun”,”Mon”,”Tue”,”Wes”,”Thu”,”Fri”,”Sat”)
dMonth=Array(“Jan”,”Feb”,”Mar”,”Apr”,”May”,”Jun”,”Jul”,”Aug”,”Sep”,”Oct”,”Nov”,”Dec”)
DateTimeToGMT = dWeek(WeekDay(sDate)-1)&”, “&Right(strZero&Day(sDate),2)&” “&dMonth(Month(sDate)-1)&” “&Year(sDate)&” “&Right(strZero&Hour(sDate),2)&”:”&Right(strZero&Minute(sDate),2)&”:”&Right(strZero&Second(sDate),2)&” “&strZone
End Function
‘//截取標(biāo)題長度
Public Function Cut(Str, StrLen)
Dim l, t, c, I
l = Len(Str)
t = 0
For I = 1 To l
c = AscW(Mid(Str, I, 1))
If c < 0 Or c > 255 Then t = t + 2 Else t = t + 1
If t >= StrLen Then
Cut = Left(Str, I) & “…”
Exit For
Else
Cut = Str
End If
Next
End Function
%>
<%
Dim sRssHead,sRssBody,sRssEnd,sSql
Response.ContentType = “text/xml”
sRssHead = “<rss version=””2.0″”>” & vbNewLine
sRssHead = sRssHead &”<channel>”& vbNewLine
‘頻道(channel)名稱
sRssHead = sRssHead &”<title>Rss頻道標(biāo)題</title>”& vbNewLine
‘頻道所用語言
sRssHead = sRssHead & “<language>zh-cn</language>” & vbNewLine
‘響應(yīng)該頻道的網(wǎng)站的URL
sRssHead = sRssHead &”<link>http://www.QQView.com/WebRss.Asp</link>”& vbNewLine
‘與頻道一起顯示的圖片地址
sRssHead = sRssHead &”<image>”& vbNewLine
‘是GIF、JPEG或PNG圖像文件的URL地址,該圖像代表整個頻道
sRssHead = sRssHead &”<url>/XrssFile/2007-12/8/2007128112855344.png</url>”& vbNewLine
‘響應(yīng)該頻道的網(wǎng)站的URL
sRssHead = sRssHead &”<link>http://www.QQView.com/WebRss.Asp</link>”& vbNewLine
‘頻道(channel)名稱
sRssHead = sRssHead &”<title>Rss頻道標(biāo)題</title>”& vbNewLine
‘圖片結(jié)束
sRssHead = sRssHead &”</image>”& vbNewLine
‘內(nèi)容的發(fā)布時間
sRssHead = sRssHead &”<pubDate>”&DateTimeToGMT(Now())&”</pubDate>”& vbNewLine
‘指向rss格式文檔的url地址?
sRssHead = sRssHead &”<docs>http://www.QQView.com/WebRss.Asp</docs>”& vbNewLine
‘技術(shù)人員的Email
sRssHead = sRssHead &”<webMaster>Xbell@163.com</webMaster> “& vbNewLine
‘關(guān)于該頻道的描述
sRssHead = sRssHead &”<description>頻道描述</description>” & vbNewLine
‘生成該頻道的程序的名稱
sRssHead = sRssHead & “<generator>Rss Generator By 網(wǎng)絡(luò)大本營</generator>” & vbNewLine
sSql = “Select Top 10 ID,Title,Content,Time,Url From [Article] Order By ID Desc”
Set Rs=Conn.Execute(sSql)
Do While Not Rs.Eof
sRssBody = sRssBody & “<item>” & vbNewLine
‘item(節(jié)點)的標(biāo)題
sRssBody = sRssBody & “<title><![CDATA[“&Rs(“title”)&”]]></title>” & vbNewLine
‘item(節(jié)點)的概要
sRssBody = sRssBody & “<description><![CDATA[“&Cut(Rs(“content”),150)&”]]></description>” & vbNewLine
‘item(節(jié)點)的URL
sRssBody = sRssBody & “<link>”&Rs(“Url”)&”</link>” & vbNewLine
‘item(節(jié)點)作者的Email
sRssBody = sRssBody & “<author>Xbell@163.com</author>” & vbNewLine
‘內(nèi)容的發(fā)布時間
sRssBody = sRssBody &”<pubDate>”&Rs(“Time”)&”</pubDate>”& vbNewLine
‘item(節(jié)點)結(jié)束
sRssBody = sRssBody &”</item>”
Rs.MoveNext
Loop
Rs.Close
Set Rs=Nothing
sRssEnd = “</channel></rss>”
Response.Write(sRssHead)
Response.Write(sRssBody)
Response.Write(sRssEnd)
Conn.Close
Set Conn=Nothing
%