复件 index.jsp

JSP+ORACLE网站开发实例（下）.rar

                    </tr>
                  </table>
                </td>
              </tr>
              <tr> 
                <td height="5"></td>
              </tr>
            </table>
            <div align="center"> </div>
          </td>
        </tr>
        <tr> 
          <td width="62%" height="22"  valign="top"> 
            <table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#ECECDB">
              <tr> 
                <td height="20"  valign="top" background="images/bg1.jpg"> 
                  <p align="center">&nbsp; <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">
                          <%    
	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.Nclassid=Nclass.Nclassid ";    
	sql=sql+" order by download.dateandtime desc";    
	rs=stmt.executeQuery(sql); 
 i=0;
		while(i<10 && rs.next()){  %>
                          <tr> 
                            <td width="100%" onMouseOver="this.bgColor='#F8F8F8';" onMouseOut="this.bgColor='#ffffff';" height="23">&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></font></td>
                            <%   i++;    
		}                  
	rs.close();                     
%>
                          </tr>
                        </table>
                        <table border="0" width="100%" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td width="100%" height="20">　</td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
              <tr> 
                <td height="5"></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <table width="98%" border="0" align="center" height="234">
        <tr> 
          <td width="50%" 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>
                    </tr>
                  </table>
                </td>
              </tr>
              <tr> 
                <td height="5"></td>
              </tr>
            </table>
          </td>
          <td width="50%" 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>
                    </tr>
                  </table>
                </td>
              </tr>
              <tr> 
                <td height="5"></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td background="images/bj4.gif" height="1"><img src="images/spacer.gif" width="1" height="1"></td>
        </tr>
      </table>
      <br>
    </td>
  </tr>
  <tr> 
    <td valign="top" bgcolor="#999966" >　</td>
  </tr>
</table>
<%@ include file="CopyRight.jsp"%>