?? index.jsp
字號:
</td>
</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"> <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">
<img src="images/RedArrow.gif" width="4" height="7"> <a href='sort.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>'><%=rs.getString("Nclass")%></a> - <a href="list.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%> <%=replacenull(rs.getString("bb"))%></a><font color='#999999'>(
<%=rs.getString("dateandtime")%></font>,<font color=green><%=rs.getString("hits")%></font>)</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">
<img src="images/RedArrow.gif" width="4" height="7"> <a href='sort.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>'><%=rs.getString("Nclass")%></a> - <a href="list.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%> <%=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">
<img src="images/RedArrow.gif" width="4" height="7"> <a href='sort.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>'><%=rs.getString("Nclass")%></a> - <a href="list.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%> <%=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="#004C90" > </td>
</tr>
</table>
<%@ include file="CopyRight.jsp"%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -