📄 list.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ page import="java.util.*, java.text.*" %>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<% int i;
String showname="",bb="",classid="",Nclassid="",classname="",Nclassname="",lasthits="",sqlname="";
request.setCharacterEncoding("GB2312");
String id=request.getParameter("id");
if((id==null)|(id.equals(""))){
out.print("<SCRIPT language=JavaScript>alert('您没有选择相关影片，请返回');");
out.print("javascript:history.go(-1);</SCRIPT>");
}
String sqlname3="select class.class,Nclass.Nclass,download.showname,download.bb,download.classid,download.Nclassid,download.lasthits from scott.download,scott.class,scott.Nclass where download.classid=class.classid and download.Nclassid=Nclass.Nclassid and download.ID='"+id+"'";
ResultSet rs3=stmt.executeQuery(sqlname3);
if(!rs3.next()){
out.print("<SCRIPT language=JavaScript>alert('您没有选择相关影片，请返回');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{
showname=rs3.getString("showname");
bb=rs3.getString("bb");
classid=rs3.getString("classid");
Nclassid=rs3.getString("Nclassid");
classname=rs3.getString("class");
Nclassname=rs3.getString("Nclass");
lasthits=rs3.getString("lasthits");
}
rs3.close();
//更新每周每日数据
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd-M月- yyyy");
java.util.Date currentTime_1 = new java.util.Date();
stmt.executeUpdate("update scott.download set dayhits=dayhits+1,weekhits=weekhits+1 where lasthits>='"+formatter.format(currentTime_1)+"' and id='"+id+"'");
stmt.executeUpdate("update scott.download set hits=hits+1,lasthits='"+formatter.format(currentTime_1)+"' where id='"+id+"'");
%>
<HTML><HEAD>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<TITLE><%=classname%>：<%=Nclassname%>：<%=showname%> <%=bb%></TITLE>
<link rel="stylesheet" href="images/style.css">
<script language="JavaScript">
<!--
function Showvote(id)
{
var filename="vote.jsp?id="+id;
window.open(filename,"显示窗口","scrollbars=yes,width=350,height=300,status=yes,resizable=yes");
}
//-->
</SCRIPT>
</HEAD>
<%@ 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" 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>
<table border=0 cellpadding=0 cellspacing=0 width=100% align="center">
<tr>
<td height="20" bgcolor="#999966">
<div align="center"><font color=#ffffff>本类热门下载</font> </div>
</td>
</tr>
<tr align=middle>
<td bgcolor=#999999 valign="top">
<table border=0 cellpadding=0 cellspacing=0 width=100% height="150">
<tr><td height="20" bgcolor="#E8F0F8" width="4%"></td>
<td bgcolor=#E8F0F8 valign=top width="96%"><font style=line-height:150%>
<%if(Nclassid==null){
sqlname="select id,showname,bb from scott.download where classid ='"+classid+"' order by download.id desc";
}else{
sqlname="select id,showname,bb from scott.download where Nclassid ='"+Nclassid+"' order by download.id desc";
}
rs=stmt.executeQuery(sqlname);
i=0;
while(i<20 && rs.next()){
out.print("<li><A href=list.jsp?id="+rs.getString("id")+">"+rs.getString("showname")+" "+replacenull(rs.getString("bb"))+"</A></li>");
}
rs.close();
%>
</font> </td>
</tr>
</table>
</td>
</tr>
</table>
<table border=0 cellpadding=0 cellspacing=0 width=100% align="center">
<tr align=middle>
<td bgcolor=#999999 colspan=4 valign="top">
<table border=0 cellpadding=0 cellspacing=0 width=100% height="150">
<tr> <td height="20" bgcolor="#E8F0F8" width="4%"></td>
<td bgcolor=#E8F0F8 valign=top width="96%"><font style=line-height:150%>
</font> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="76%" valign="top" bgcolor="#FFFFFF">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="1" background="images/bj4.gif"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
</table>
<table width="98%" border="0" align="center">
<tr>
<td bgcolor="#efefef">您的位置：<A href="index.jsp">首页</A> >> <A href='sort.jsp?classid=<%=classid%>'><%=classname%></A>
>> <A href='sort.jsp?classid=<%=classid%>&Nclassid=<%=Nclassid%>'><%=Nclassname%></A>
>> <%=showname%> <%=bb%></td>
</tr>
</table>
<table border=0 cellpadding=0 cellspacing=0 width=98% align="center">
<tr>
<td align=middle valign=top width=568 height="160" bgcolor="#FFFFFF">
<% sqlname="select * from scott.download where ID='"+id+"'";
rs=stmt.executeQuery(sqlname);
if(rs.next()){
%>
<table width="98%" border="0" cellspacing="1" cellpadding="3" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td colspan="3"><b><%=rs.getString("showname")%></b></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">影片版本：</td>
<td width="231" bgcolor="#FFFFFF"><%=replacenull(rs.getString("bb"))%></td>
<td rowspan="8" align="center" width="215" bgcolor="#FFFFFF">
无图片 </td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">影片类型：</td>
<td width="231" bgcolor="#FFFFFF"><%=Nclassname%></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">运行环境：</td>
<td width="231" bgcolor="#FFFFFF"><%=rs.getString("system")%></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">授权方式：</td>
<td width="231" bgcolor="#FFFFFF"><%=rs.getString("orders")%></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">影片大小：</td>
<td width="231" bgcolor="#FFFFFF"><%=rs.getString("size1")%></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">影片评价：</td>
<td width="231" bgcolor="#FFFFFF"><img src="images/<%=rs.getString("hot")%>star.gif"></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">整理日期：</td>
<td width="231" bgcolor="#FFFFFF"><%=rs.getString("dateandtime")%></td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">相关链接：</td>
<td width="231" bgcolor="#FFFFFF">
<%if(rs.getString("fromurl")!=null){%>
<a href="<%=rs.getString("fromurl")%>">主页</a>
<%}%>
</td>
</tr>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">本日下载：</td>
<td colspan="2" bgcolor="#FFFFFF"><%=rs.getString("dayhits")%> 本周：<%=rs.getString("weekhits")%> 总计：<%=rs.getString("hits")%></td>
</tr>
<%String club="1";
if((session.getValue("user")==null)&&(club.equals(rs.getString("club")))){
//if session("user")="" and rs("club")="1" then
%>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">下载地址：</td>
<td colspan="2" bgcolor="#FFFFFF"><font color="#FF0000">此为会员影片，请注册成我们的会员</font></td>
</tr>
<%
}else{
if((rs.getString("filename")==null)&&(rs.getString("filename1")==null)&&(rs.getString("filename2")==null)){
%>
<tr>
<td width="80" height="19" align="right" nowrap bgcolor="#FFFFFF">下载地址：</td>
<td colspan="2" height="19" bgcolor="#FFFFFF">暂时没有下载</td>
</tr>
<%
}else{
String play="" ;
String pimg="" ;
if(rs.getString("movie")!=null){
String play22="win";
if(play22.equals(rs.getString("movie")))
{
play="playwin.jsp" ;
pimg="images/win.gif" ;
}else{
play="playrm.jsp" ;
pimg="images/rm.gif" ;
}
%>
<script language="JavaScript">
function windowOpen(loadpos)
{controlWindow=window.open(loadpos,"surveywin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,width=610,height=400,status=yes,resizable=yes");
}
</script>
<tr>
<td width="80" height="19" align="right" nowrap bgcolor="#FFFFFF">在线播放：</td>
<td colspan="2" height="19" bgcolor="#FFFFFF"><img src="<%=pimg%>">
<%if(rs.getString("filename")!=null){%>
<a href=# onClick=windowOpen('<%=play%>?id=<%=rs.getString("id")%>&downid=1')>[1]</a>
<%}%>
<%if(rs.getString("filename1")!=null){%>
<a href=# onClick=windowOpen('<%=play%>?id=<%=rs.getString("id")%>&downid=2')>[2]</a>
<%}%>
<%if(rs.getString("filename2")!=null){%>
<a href=# onClick=windowOpen('<%=play%>?id=<%=rs.getString("id")%>&downid=3')>[3]</a>
<%}%>
</td>
</tr>
<%}else{%>
<%if(rs.getString("filename")!=null){%>
<tr>
<td width="80" height="19" align="right" nowrap bgcolor="#FFFFFF">下载地址1：</td>
<td colspan="2" height="19" bgcolor="#FFFFFF"> <a href="download.jsp?downid=1&id=<%=rs.getString("id")%>" target="_blank">download.jsp?id=<%=rs.getString("id")%>&downid=1</a>
</td>
</tr>
<%}%>
<%if(rs.getString("filename1")!=null){%>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">下载地址2：</td>
<td colspan="2" bgcolor="#FFFFFF"> <a href="download.jsp?downid=2&id=<%=rs.getString("id")%>" target="_blank">download.jsp?id=<%=rs.getString("id")%>&downid=2</a>
</td>
</tr>
<%}%>
<%if(rs.getString("filename2")!=null){%>
<tr>
<td width="80" align="right" nowrap bgcolor="#FFFFFF">下载地址3：</td>
<td colspan="2" bgcolor="#FFFFFF"> <a href="download.jsp?downid=3&id=<%=rs.getString("id")%>" target="_blank">download.jsp?id=<%=rs.getString("id")%>&downid=3</a>
</td>
</tr>
<%}%>
<%}%>
<%}%>
<%}%>
<tr>
<td width="80" align="right" nowrap valign="top" bgcolor="#FFFFFF">影片简介：</td>
<td colspan="2" bgcolor="#FFFFFF"><%=rs.getString("note")%></td>
</tr>
<tr>
<td height="14" width="80" align="center" nowrap bgcolor="#FFFFFF">
<p> </p>
</td>
<td height="14" colspan="2" bgcolor="#FFFFFF">
</td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><font color=red>＊</font> 在线看电影需要这些工具：Windows
Media Player或RealPlayer。 </td>
</tr>
</table>
<%}%>
</td>
</tr>
<tbody> </tbody>
</table>
</td>
</tr>
</table>
<%@ include file="CopyRight.jsp"%>
</BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -