⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 index.asp

📁 《Web数据库技术》-高晗-vod点播系统程序源代码
💻 ASP
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/style.css" rel="stylesheet" type="text/css">
<title>VOD点播系统</title>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" bgcolor="#ffffff">
<div align="center">
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="758">
    <tr>
      <td width="100%">
      <iframe marginwidth=0 marginheight=0  frameborder=0 bordercolor='#000000' scrolling=no src='head.asp' width=748 height=80></iframe></td>
    </tr>
  </table>
<table dir="ltr" border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td valign="top">
    <div align="center">
      <table border="0" width="763" height="830" cellspacing="0" cellpadding="0">
        <tr>
          <td height="500" width="763">
          <div align="center">
            <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table8" height="101%">
              <tr>
                <td width="187" align="center" valign="top">
                <table border="1" width="169" cellspacing="0" cellpadding="0" height="100" id="table10">
                  <tr>
                    <td height="23"  width="169">&nbsp;
                    <font color="#000000">===网站公告===</font></td>
                  </tr>
                  <tr>
                    <td align="center">
                    <marquee height="100" direction="up" onmouseout="this.start()" onmouseover="this.stop()" scrollAmount="2" scrollDelay="100" align="center" width="160"><img src=../img/new.gif>
                    <%set rs1=server.createobject("adodb.recordset")                                                                                     
sql="select * from bulletin " 
rs1.open sql,conn,1,3
info=rs1("info")
rs1.close
set rs1=nothing
                        %><%=info%></marquee></td>
                  </tr>
                  <tr>
                    <td width="169" height="23" >
                    <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table13" height="18">
                      <tr>
                        <td>&nbsp; <font color="#000000" style="font-size: 12px">===会员登陆===</font></td>
                        
                      </tr>
                    </table>
                    </td>
                  </tr>
                  <tr>
                    <td width="169" height="110" >
                    <table border="1" width="169" cellspacing="0" cellpadding="0" id="table17" height="99">
                      <tr>
                        <td width="169" valign="top">
                        <iframe frameBorder="yes" height="136" marginHeight="0" marginWidth="0" name="I1" scrolling="no" src="passok.asp" width="99%" align="center"></iframe>
                        </td>
                      </tr>
                    </table>
                    </td>
                  </tr>
                  <tr>
                    <td width="169" height="30"  align="right" valign="bottom">
                    <table border="0" width="166" id="table20" cellspacing="0" cellpadding="0" height="30">
                       <tr>
                        <td height="21" width="70" align="center">
                        <img align="absMiddle" height="5" hspace="6"  width="5"><a target="_blank" href="../user/meedit.asp">修改资料</a></td>
                        <td height="21" width="96" align="center">
                        <img align="absMiddle" height="5" hspace="6"  width="5"><a target="_blank" href="mylook.ASP">点播记录查询</a></td>
                      </tr>
                      </table>
                    </td>
                  </tr>
                  <tr>
                    <td width="169" height="23" >
                    <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table14" height="18">
                      <tr>
                        <td><font color="#FFFFFF"><span style="font-size: 12px">&nbsp;
                        </span></font>
                        <font color="#000000" style="font-size: 12px">===点播排行===</font></td>
                      </tr>
                    </table>
                    </td>
                  </tr>
                  <% set rs = server.createobject("adodb.recordset")
                    sql="select top 8 * from Playbill order by hits desc"
                     
                    rs.open sql,conn,1
                    
                  %>
                  <tr>
                    <td width="169"  height="20">
                    <div align="center">
                      <table border="0" width="164" cellspacing="0" cellpadding="0" id="table29" height="15" style="border-collapse: collapse" bordercolor="#111111">
                      
                      <tr>
                      <%   
                         i=1
                        do while not rs.eof
                        
                      %>
                      <td align=Center><b Style='Color:#FF6900'><%=i%></td>
                      <td width=70%><a href=../db.asp?title=<%=rs("title")%> class=mName><%=rs("title")%></td>
                      <td width=20% Align=Center><%=rs("hits")%></td>
                      </tr>
<%i=i+1
rs.movenext
loop
set rs=nothing%>
                    
                        <center>
                         </td>
                        </tr>
                      </table>
                    </div>
                    </td>
                  </tr>
                  
                
                 
                </table>
                </td>
                <td valign="top">
                <table border="1" width="583" cellspacing="0" cellpadding="0" id="table9" height="30">
                  <tr>
                     <td width="146" >
                     <font color="#000000"><span style="font-size: 12px">&nbsp;影 片 搜 索</span></font>
                     </td>
                     <td width="133"  valign="bottom">
                    <form action="search.asp" method="post" name="form1" style="MARGIN: 0px">
                      <table border="0" cellPadding="0" cellSpacing="0" width="300">
                        <tr>
                          <td width="144" valign="top"><span lang="zh-cn">
                          <select class="smallSel" name="typeid" size="1">
                          <option selected name="typeid" value="片名">=按影片名称=
                          </option>
                          <option name="typeid" value="演员">=按主要演员=</option>
                          </select></span>
                          </td>
                          <td width="40" valign="top">
                          <input id="key" name="keyword" onfocus="this.value=''" size="10" value="关键字搜索">
                          </td>
                          <td width="77">
                          <div align="center">
                            <input border="0" name="imageField" src="images/search.gif" type="image"></div>
                          </td>
                        </tr>
                      </table>
                    </form>
                    </td>
                  </td>
                  </tr>
                </table>
                <table border="1" width="568" cellspacing="0" cellpadding="0" id="table15" height="150">
                  <tr>
                    <td width="146" height="23" align="center>
                      <font color="#FF0000" style="font-size: 12px">&nbsp;新 片 列 表</font></td>
                  </td>
                   </tr>
                  
                  <tr>
                    <td width="568" colspan="2"  align="center">
                    <table border="1" width="557" cellspacing="0" cellpadding="0" id="table28" height="162">
                      <tr>
                       
                        <td width="545" height="141" valign="top">
                        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="465" id="AutoNumber1">
                         
                           <% 
                            set rs = server.createobject("adodb.recordset")
                            sql="select top 10 * from Playbill order by dateandtime desc"
                            rs.open sql,conn,1
                  
                           %>
                      <% 
                         i=1
                        do while not rs.eof
                        if i mod 2<>0 then
                      %>
                       <tr>
                            <td width="135" height="16">
                            <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="276" id="AutoNumber2">
                                <tr>
                                <td width="2%"></td>
                                <td width="57%" height="20">
                                <a href="../db.asp?title=<%=rs("title")%>" target="_blank"><%=rs("title")%></a></td>
                                <td width="15%"><%=rs("typeid")%></td>
                                <td width="23%"><%=rs("dateandtime")%></td>
                              </tr>
                            </table>
                            </td>
                       <% else %>
                            <td width="135" height="16">
                            <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="276" id="AutoNumber2">
                              <tr>
                                <td width="2%"></td>
                                <td width="57%" height="20">
                                 <a href="../db.asp?title=<%=rs("title")%>" target="_blank"><%=rs("title")%></a></td>
                                <td width="15%"><%=rs("typeid")%></a></td>
                                <td width="23%"><%=rs("dateandtime")%></td>
                              </tr>
                            </table>
                            </td>
                            
                          </tr>
                          <%
                          end if
                          i=i+1
rs.movenext
loop
set rs=nothing%>     
                           
                 
                </table>
                <table border="1" width="100%" cellspacing="0" cellpadding="0" id="table24" height="1">
                  <tr>
                    <td height="107">
                    <table border="1" width="97%" cellspacing="0" cellpadding="0" id="table30" height="1">
                      <tr>
                          <td width="146" height="23" align="center><font color="#FF0000" style="font-size: 12px">&nbsp;影 片 分 类</font></td>
                      </tr>
                      <tr>
                        <td height="64" valign="top">
                        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="568" id="AutoNumber1" height="26">
                          
    <td>
    
    
    
  <table border="1" cellPadding="2" cellSpacing="0" width="568" height="30" style="border-collapse: collapse" bordercolor="#111111">
                     <% 
                            set rs = server.createobject("adodb.recordset")
                            sql="select * from type "
                            rs.open sql,conn,1
                            
                           %>
                      <% 
                         
                        do while not rs.eof
                        
                      %>
  <tr>
    <td width="112" height="30" valign="middle" bordercolorlight="#000000" bordercolordark="#D2D2D2">
    <p align="center"><%=rs("type")%></td>
    <td width="465"  valign="center" >
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="465" id="AutoNumber1">
      <%                   
                          
                           set rsjm = server.createobject("adodb.recordset")
                            sqljm="select top 3 * from Playbill where typeid='"&rs("type")&"'"
                            rsjm.open sqljm,conn,1
                           %>
      <tr>
       <% 
                         i=1
                        do while not rsjm.eof
                        if i mod 3=1 then
                      %>
        <td width="130" height="15" align="center">
        <a href="db.asp?title=<%=rsjm("title")%>" target="_blank">
        <%=rsjm("title")%></a></td>
        <%elseif i mod 3=2 then%>
        <td width="130" height="15" align="center">
        <a href="db.asp?title=<%=rsjm("title")%>" target="_blank">
        <%=rsjm("title")%></a></td>
        <%else%>
        <td width="130" height="15" align="center">
        <a href="db.asp?title=<%=rs("title")%>" target="_blank" >
        <%=rsjm("title")%></a></td>
        <td width="15" height="15" align="center" ><strong>......</strong></td>
      </tr>
         <%end if%>
        <%
                          
      i=i+1
     rsjm.movenext
     loop
    set rsjm=nothing
    %>    
         </table>
    </td>
  </tr>
   <%
                          
     
     rs.movenext
     loop
    set rs=nothing
    %>     
  
  
  
</table>
</td>
</tr>
</table></td>
  </tr>
</table></td>
                  </tr>
                          
                         
                          </tr>
                  </table>
                        </td>
                      </tr>
          </table>
                    </td>
        </tr>
                  <tr>
                  
                  </tr>
      </table>
                </td>
    </tr>
  </table>
</div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</div>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -