% sql="select * from shuxing1_shuxing2 where class2id="&request.QueryString("class2id") set rs=server.CreateObject("adodb.recordset") rs.open sql,conn,1,1 majorName=Replace(rs("class2folder"),"/","") detailUrlPre=rs("class1folder")&Replace(rs("class2folder"),"/","_")&"_"&request.QueryString("class2id") set rss=conn.execute ("Select * from infclass1_Info where InfoID="&Request.QueryString("InfoID") ) Title=trim(rss("Title")) des=rss("Des") Set rs_pre=conn.execute ("Select top 1 infoid,title from infclass1_Info where InfoID<"&Request.QueryString("InfoID")&" and class1id="&rss("class1id")&" order by infoid desc") Set rs_sub=conn.execute ("Select top 1 infoid,title from infclass1_Info where InfoID>"&Request.QueryString("InfoID")&" and class1id="&rss("class1id")&" order by infoid asc") Set jianzhang=conn.execute("select banner,class2name,banner1,class1folder,class2folder,class2name from proclass1_proclass2 where class2id="&rss("xuexiao")) If Not jianzhang.bof And Not jianzhang.eof then class1folder=jianzhang("class1folder") class2folder=jianzhang("class2folder") class2name=jianzhang("class2name") End If Set jianzhang=Nothing SiteSN="ZZYEDU_ORG" cache_video="" rem 城市緩存 If Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST")="" then cache_video=getVideo() Application.lock Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST_Timestamp")=now() Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST")=cache_video Application.unlock ElseIf DateDiff("n",Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST_Timestamp"),now())>60 Then '正式運(yùn)行時(shí)60分鐘調(diào)用一次 cache_video=getVideo() Application.lock Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST_Timestamp")=now() Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST")=cache_video Application.unlock Else cache_video=Application(SiteSN&"_INFO_DETAIL_VIDEO_LIST") End If rem 獲取視頻代碼段 Function getVideo() getVideo="" set zy=conn.execute("select top 12 infoid,SmallPic,PicDes,beiyong,title,videopicurl from Info where cast(vedioUrl as varchar(100))!='' and videopicurl<>'' and tubiao<>1 order by oederid desc,InfoID desc") do while not zy.eof getVideo=getVideo&"