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

📄 复件 index.jsp

📁 JSP+ORACLE网站开发实例(下).rar
💻 JSP
📖 第 1 页 / 共 2 页
字号:
<%@ include file="conn.jsp"%>
<%! 
String replacenull(String a){ 
	if(a==null){
return "&nbsp;"; 
	}else{
return a; 
	}
} 
%> 
<HTML><HEAD><TITLE>在线宽带点播</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" href="images/style.css">
</HEAD>
<BODY>
<%@ include file="topMain.jsp"%>
<table width="752" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999966" >
  <tr> 
    <td width="24%" valign="top" bgcolor="#E8F0F8" > 
      <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999966">
        <tr> 
          <td bgcolor="#999966" height="9" colspan="2"> 
            <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999966" height="40">
              <form method="post" name="myform" action="search.jsp">
                <tr> 
                  <td bgcolor="#E8F0F8" valign="middle" align="center"> 搜索: 
                    <input type="text" name="keyword" class=textfield size=10  maxlength="50"  style="font-family: Arial">
                    <input type="submit" name="Submit22" value="搜索" style="height='21'" class="botton">
                  </td>
                </tr>
              </form>
            </table>
          </td>
        </tr>
        <tr> 
          <td bgcolor="#999966" height="20" colspan="2"> 
            <div align="center"><font color="#FFFFFF">站 内 公 告</font></div>
          </td>
        </tr>
        <tr> 
          <td height="20" bgcolor="#E8F0F8" colspan="2"> 
            <table border=0 cellpadding=0 width="100%" cellspacing="0">
           
              <tr> <td height="20" bgcolor="#E8F0F8" width="4%"></td>
                <td valign="top" width="96%"><img src="images/dot.gif" width="11" height="13">
                 感谢各地网友一直以来的支持和帮助,为此我们将提供更多更好的项目服务于大家,本站目前拥有电影下载区
                  
                  [2004-3-26] 
             
                </td>
              </tr>
            </table>
          </td>
        </tr>
    
 
        <tr> 
          <td height="20" bgcolor="#999966" colspan="2"> 
            <div align="center"><font color="#FFFFFF">累计下载TOP30</font></div>
          </td>
        </tr>
        <tr> 
          <td height="20" bgcolor="#E8F0F8" width="4%"></td>
          <td height="20" bgcolor="#E8F0F8" width="96%"> 
            <%     
			sql="select id,showname,bb from scott.download order by id desc"; 
rs=stmt.executeQuery(sql); 

int i=0;
		while(i<30 && rs.next()){
out.print("<li><A href=list.jsp?id="+rs.getString("id")+">"+rs.getString("showname")+"</A></li>");
		}                                    
	rs.close();                                     
%>
          </td>
        </tr>

      </table>
    </td>
	  
    <td width="76%" bgcolor="#FFFFFF" valign="top" rowspan="2" >
      <table width="560" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td background="images/bj4.gif" height="1"> <img src="images/spacer.gif" width="1" height="1"></td>
        </tr>
        <tr> 
          <td background="images/bg15.gif"> 
            <table width="560" border="0" cellspacing="0" cellpadding="0" height="27">
              <form method="post" action="Chkadmin1.jsp">
                <tr> 
                  <td bgcolor="#E8F0F8"> 
                    <div align="center"> 
                      <%if ((session.getValue("user")!=null)){   %>
                      <script language="JavaScript">
<!--
var enabled = 0; today = new Date();
var day; var date;
if(today.getDay()==0) day = "星期日"
if(today.getDay()==1) day = "星期一"
if(today.getDay()==2) day = "星期二"
if(today.getDay()==3) day = "星期三"
if(today.getDay()==4) day = "星期四"
if(today.getDay()==5) day = "星期五"
if(today.getDay()==6) day = "星期六"
date = "" + (today.getYear()) + "年" + (today.getMonth() + 1 ) + "月" + today.getDate() + "日  " + day +"";
document.write("" + date + "");
-->
                      </script>
                      &nbsp;&nbsp;&nbsp;欢迎&nbsp;<font color="#DC1515"><%=session.getValue("user")%></font>&nbsp;进入 
                      宽带影院,您现在可以完全浏览本站所有内容! 
                                        <%}else{%>
                      <img src="images/home1.gif" width="19" height="16"><img src="images/home2.gif" width="49" height="13">: 
                      <input type="text" name="user" size="12" class="textfield" style="font-family: Arial">
                      <img src="images/mm.gif" width="25" height="13">: 
                      <input type="password" name="password" size="12" class="textfield" style="font-family: Arial">
                      <input type="submit" value="确定" name="B3" class="botton">
                      <input type="button" name="reg" value="注册成会员" class="botton" onclick="javascript:document.location='reg1.jsp'">
                      <%}%>
                    </div>
                  </td>
                </tr>
              </form>
            </table>
          </td>
        </tr>
        <tr> 
          <td background="images/bj4.gif" height="1"> <img src="images/spacer.gif" width="1" height="1"></td>
        </tr>
      </table>
      <table width="98%" border="0" align="center">
        <tr> 
          <td width="62%" height="1" > 
            <table width="100%" border="0" cellpadding="0" cellspacing="0" height="1" background="images/bj4.gif">
              <tr> 
                <td><img src="images/spacer.gif" width="1" height="1"></td>
              </tr>
            </table>
          </td>
          <td width="8%" height="46" rowspan="2" valign="top"> 
            <div align="right"> </div>
          </td>
          <td width="30%" height="46" rowspan="2" valign="top"> 
            <table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#ECECDB">
              <tr> 
                <td height="19"  valign="top" background="images/bg1.jpg"> 
                  <p align="center"><font     
            color=#ff0000>推荐影片</font> 
                </td>
              </tr>
              <tr> 
                <td></td>
              </tr>
              <tr> 
                <td bgcolor="#0066ff"> 
                  <table border="0" width="100%" cellspacing="1" cellpadding="0">
                    <tr> 
                      <td width="100%" bgcolor="#FFFFFF" valign="top"> 
                        <table border="0" width="100%" cellpadding="0" cellspacing="1" height="250">
                          <%    
	sql="select ";    
	sql=sql+"download.id,download.showname,bb,download.dateandtime,download.hits,download.classid,download.Nclassid,Nclass.Nclass ";    
	sql=sql+" from scott.download,scott.Nclass where download.hots=1 and download.Nclassid=Nclass.Nclassid ";    
	sql=sql+" order by download.dateandtime desc" ;   
	rs=stmt.executeQuery(sql); 
 i=0;
		while(i<8 && rs.next()){  %>
                          <tr> 
                            <td width="100%" onMouseOver="this.bgColor='#F8F8F8';" onMouseOut="this.bgColor='#ffffff';" height="23" valign="top">&nbsp; 
                              <img src="images/RedArrow.gif" width="4" height="7">&nbsp;<a href='sort.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>'><%=rs.getString("Nclass")%></a>&nbsp;-&nbsp;<a href="list.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%>&nbsp;<%=replacenull(rs.getString("bb"))%></a><font color='#999999'></font></td>
                          </tr>
                          <%   i++;    
		}                 
	rs.close();                    
%>
                        </table>
                        <table border="0" width="100%" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td width="100%" height="20"> </td>
                          </tr>
                        </table>
                      </td>

⌨️ 快捷键说明

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