list-------.jsp

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

              <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")%>&nbsp;&nbsp;本周：<%=rs.getString("weekhits")%>&nbsp;&nbsp;总计：<%=rs.getString("hits")%></td>
              </tr>
              <%if(session.getValue("user_id")==null){
//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{ 
				   if(rs.getString("movie")!=null){
				    String  play22="win";
				       if(play22.equals(rs.getString("movie")))
                               {
                             String  play="playwin.asp" ;    
                  String  pimg="images/win.gif"  ;   
                              }else{     
                             String   play="playrm.asp" ;    
                             String    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%>">&nbsp; 
                  <%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"><%=tmp%>/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("id")%>" target="_blank"><%=tmp%>/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"><%=tmp%>/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"> 
                  <p align="right"> 【<a href="javascript:Showvote('<%=rs.getString("id")%>')">评论投票</a>】</p>
                </td>
              </tr>
              <tr> 
                <td colspan="3" bgcolor="#FFFFFF"><font color=red>＊</font> 在线看电影需要这些工具：<a class="date" href="search.jsp?action=title&keyword=Windows Media Player" title="点击查看详细介绍" target="_blank">Windows 
                  Media Player</a>或<a class="date" href="search.jsp?action=title&keyword=RealPlayer" title="点击查看详细介绍" target="_blank">RealPlayer</a>。 
                </td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF" width="80" nowrap valign="top"> 
                  <p align="right">相关评论： 
                </td>
                <td colspan="2" bgcolor="#FFFFFF"> 
                  <table border="0" width="100%" cellspacing="0" cellpadding="0">
                    <center>
                      <tr> 
                        <td width="100%"> 
                          <% }
					  sqlname="select * from scott.Dvote where downid='"+id+"' order by id desc";
   rs_pl=stmt.executeQuery(sqlname); 
			 if(!rs_pl.next()){                      
out.print("暂时未有对此影片的评论!");                                      
			 }else{                                      
while(rs_pl.next()){                                     
out.print("<li>[打分："&rs_pl.getString("grade")&"]&nbsp;<font color=green>"&rs_pl.getString("content")&"</font></li>");                                      
i++;                                         
}    
			 }
rs_pl.close();                                      
%>
                        </td>
                      </tr>
                    </center>
                    <tr> 
                      <td width="100%"> 
                        <p align="right"><a href="javascript:Showvote('<%=id%>')">发表你的评论 
                          / 更多评论&gt;&gt;</a> 
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
        <tbody> </tbody> 
      </table>
    </td>
  </tr>
</table>
<%@ include file="CopyRight.jsp"%>
                                            
                                                                      
</BODY></HTML>