%
Dim Rs,Newrss
Class Rss
'*******************輸入?yún)?shù)********************
'***********************************************
'SetConn 必填 網(wǎng)站使用的Connection對象
'SetSql 必填 Sql查詢語句。強烈建議使用在Sql語句中使用Top關鍵字
' Sql語句中包含的字段[新聞Id,標題,內(nèi)容,時間,靜態(tài)頁名稱]
' 注:不要顛倒順序
' 如果新聞不是生成的靜態(tài)頁，則無最后一項，SetPageType的值則為1
'SetWebName 必填 網(wǎng)站名稱
'SetWebUrl 必填 網(wǎng)站的地址
'SetWebDes 非必填 網(wǎng)站的描述信息
'SetPageType 必填 信息顯示頁的鏈接類型 1 為動態(tài)頁面Id 0為靜態(tài)頁面
'SetMaxInfo 非必填 強制顯示信息的數(shù)目，若取數(shù)據(jù)>SetMaxInfo 則顯示SetMaxInfo條數(shù)據(jù)。強烈建議使用在Sql語句中使用Top關鍵字
'setContentShow 非必填 信息簡介設置。注意：該參數(shù)為數(shù)組（ShowContentType,ShowContentLen）
' ShowContentType [數(shù)字類型] 為內(nèi)容顯示方式[參數(shù)(0,1)0為按百分比就算顯示信息,1為按字數(shù)]
' ShowContentLen 內(nèi)容顯示的長度 由ShowContentType 決定實際長度
'*****************輸出參數(shù)********************
'ShowRss 顯示Rss
'======================================================
'例如
'Set NewRss=New Rss
' Set NewRss.SetConn=article_conn
' NewRss.SetSql="select top 30 newsid,title,content,dateandtime,N_fname from article where typeid=1 order by newsid Desc"
' NewRss.SetWebName="測試中"
' NewRss.SetWebUrl="https://www.jb51.net"
' NewRss.SetMaxInfo=10
' NewRss.SetInfourl="https://www.jb51.net"
' NewRss.SetPageType="0"
' NewRss.setContentShow="1,200"
' NewRss.ShowRss()
'Set NewRss=Nothing
'======================================================
Private Conn,Sql,WebName,WebUrl,WebDes,Er,MaxInfo,i,Infourl,PageType
Private ShowContentType,ShowContentLen
Private AllContent,AllContentLen
Private Sub Class_initialize()
MaxInfo=20
'PageType=1
ShowContentType=0
ShowContentLen=20
Er=false
End Sub
Private Sub Class_terminate()
If isObject(Rs) then Set Rs=Nothing
End Sub
Public Property Let Errmsg(msg)
If Er then
Response.Clear()
Response.Write(msg)
Response.End()
End If
End Property
Public Property Let SetWebName(WebName_)
WebName=WebName_
End Property
Public Property Let SetWebUrl(WebUrl_)
WebUrl=WebUrl_
End Property
Public Property Let SetWebDes(webDes_)
WebDes=WebDes_
End Property
Public Property Let SetInfoUrl(Infourl_)
Infourl=Infourl_
End Property
Public Property Let SetPageType(PageType_)
PageType=PageType_
End Property
Public Property Let SetMaxInfo(MaxInfo_)
MaxInfo=MaxInfo_
End Property
Public Property Let setContentShow(ContentShow_)
Dim ArrContentShow
ArrContentShow=Split(ContentShow_,",")
If Ubound(ArrContentShow)>1 Then Er=True:Errmsg="信息顯示參數(shù)設置有誤!!"
ShowContentType=ArrContentShow(0)
ShowContentLen=ArrContentShow(1)
If Not isnumeric(ShowContentType) or ShowContentType="" Then ShowContentType=0
If Not isnumeric(ShowContentLen) or ShowContentLen="" Then
If ShowContentType=0 Then ShowContentLen=20 Else ShowContentLen=200
Else
If ShowContentType=0 and (ShowContentLen>100 or ShowContentLen10) Then ShowContentLen=20
End If
End Property
Public Property Set SetConn(Conn_)
If TypeName(Conn_)="Connection" Then
Set Conn=Conn_
Else
Er=true
Errmsg="數(shù)據(jù)庫連接錯誤"
Exit property
End If
End Property
Public Property Let SetSql(sql_)
Sql=Sql_
End Property
Public Property Get RssHead()
RssHead="?xml version=""1.0"" encoding=""gb2312"" ?> "
RssHead=RssHead"rss>"
RssHead=RssHead"channel>"
RssHead=RssHead"title>"WebName"/title>"
RssHead=RssHead"link>"WebUrl"/link>"
RssHead=RssHead"description>"WebDes"/description>"
End Property
Private Property Get RssBottom()
RssBottom="/channel>"
RssBottom=RssBottom"/rss>"
End Property
Public Sub ShowRss()
On Error resume Next
Dim Rs
Dim ShowInfoUrl,ShowContent,Content
If TypeName(Conn)>"Connection" Then Er=True:Errmsg="Connection對象有誤"
If Sql="" or isnull(Sql)="" or isempty(Sql)="" Then Er=True:Errmsg="沒有可執(zhí)行的Sql語句"
If WebName="" or isnull(WebName)="" or isempty(WebName)="" Then Er=True:Errmsg="請設置RSS標題"
If WebUrl="" or isnull(WebUrl)="" or isempty(WebUrl)="" Then Er=True:Errmsg="請設置網(wǎng)站的鏈接"
If InfoUrl="" or isnull(InfoUrl)="" or isempty(InfoUrl)="" Then Er=True:Errmsg="請設置鏈接信息"
If PageType="" or isnull(PageType)="" or isempty(PageType)="" Then Er=True:Errmsg="請設置鏈接類型"
Set Rs=Server.CreateObject("ADODB.RecordSet")
Rs.Open Sql,Conn,1,1
If Err Then
Er=true
Errmsg="數(shù)據(jù)庫未能打開br />請檢查您的Sql語句是否正確"
Exit Sub
End If

Response.Charset = "gb2312"
Response.ContentType="text/xml"
Response.Write(RssHead)
For i =1 to MaxInfo
'*****************************
ShowInfoUrl=InfoUrl
If ShowInfoUrl="" or isnull(ShowInfoUrl) or isempty(ShowInfoUrl) Then
ShowInfoUrl="#"
Else
If PageType Then ShowInfoUrl=ShowInfoUrlRs(0) Else ShowInfoUrl=ShowInfoUrlRs(4)
End If
'*****************************
AllContent=LoseHtml(Rs(2))
AllContentLen=byteLen(AllContent)
ShowContent=int(ShowContentLen)
If ShowContentType=0 Then ShowContent=AllContentLen*ShowContent/100
Content=Server.HTMLEncode(titleb(AllContent,ShowContent))
Response.Write("item>")
Response.Write("title>")
Response.Write(Rs(1))
Response.Write("/title>")
Response.Write("link>")
Response.Write(ShowInfoUrl)
Response.Write("/link>")
Response.Write("description>")
Response.Write(Content)
Response.Write("/description>")
Response.Write("pubDate>")
Response.Write(return_RFC822_Date(Rs(3),"GMT"))
Response.Write("/pubDate>")
Response.Write("/item>")
If Rs.Eof or i>cint(MaxInfo) Then Exit For
Rs.MoveNext
Next
Response.Write(RssBottom)
End Sub
Function LoseHtml(ContentStr)
Dim ClsTempLoseStr,regEx
ClsTempLoseStr = Cstr(ContentStr)
Set regEx = New RegExp
regEx.Pattern = "\/*[^>]*>"
regEx.IgnoreCase = True
regEx.Global = True
ClsTempLoseStr = regEx.Replace(ClsTempLoseStr,"")
LoseHtml = ClsTempLoseStr
End function
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
function titleb(str,strlen)
Dim Bstrlen
bstrlen=strlen
If isempty(str) or isnull(str) or str="" Then
titleb=str
exit function
Else
dim l,t,c,i
l=len(str)
t=0

for i=1 to l
c=Abs(Asc(Mid(str,i,1)))
if c>255 then
t=t+2
else
t=t+1
end if

if t>=bstrlen then
titleb=left(str,i)
exit for
else
titleb=str""
end if
next
End If
end function
function byteLen(str)
dim lenStr,lenTemp,i
lenStr=0
lenTemp=len(str)
dim strTemp
for i=1 to lenTemp
strTemp=asc(mid(str,i,1))
if strTemp>255 or strTemp=0 then
lenStr=lenStr+2
else
lenStr=lenStr+1
end if
next
byteLen=lenStr
end function
End Class
%>