paihang.jsp
上传用户:szlmxq
上传日期:2014-01-31
资源大小:740k
文件大小:4k
源码类别:

Applet

开发平台:

Java

  1. <%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
  2. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  3.                           <tr> 
  4.                             <td valign="top" align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  5.                                 <tr> 
  6.                                   <td height="3"></td>
  7.                                 </tr>
  8.                               </table>
  9.                               <table width="165" border="0" cellspacing="0" cellpadding="0">
  10.                                 <tr> 
  11.                                   <td align="center"> <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  12.                                 </tr>
  13.                                 <tr> 
  14.                                   <td align="center" bgcolor="#DBC2B0">销售排行</td>
  15.                                 </tr>
  16.                                 <tr> 
  17.                                   <td  align="center">
  18.    <%@include file="paihang2.jsp"%>
  19.                                   </td>
  20.                                 </tr>
  21.                                 <tr> 
  22.                                   <td> </td>
  23.                                 </tr>
  24.                               </table>
  25.                               <table width="100%" border="0" cellspacing="0" cellpadding="0">
  26.                                 <tr> 
  27.                                   <td> </td>
  28.                                 </tr>
  29.                               </table>
  30.                               
  31.                               <!-- --------------------------友情链接----------------------------------------------->
  32.                               <table width="165" border="0" cellspacing="0" cellpadding="0" height="18" style="border-collapse: collapse" bordercolor="#111111">
  33.                                 <tr> 
  34.                                   <td align="center" bgcolor="#FFFFFF">
  35.   <!----------------------------------------最新新闻----------------------------------------------->
  36.         <%@ include file="topnews.jsp"%> 
  37.   <!-----------------------------最新新闻结束------------------------------------>
  38. </td>
  39.                                 </tr>
  40.                                 <tr> 
  41.                                   <td align="center"><img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  42.                                 </tr>
  43.                                 <tr> 
  44.                                   <td align="center" height="20" bgcolor="#DBC2B0"> 
  45.                                     <b>友情链接</b></td>
  46.                                 </tr>
  47.                                 <tr> 
  48.                                   <td bgcolor="#F5EFE7"> <p style="line-height:150%" align=center> 
  49.                                       <%      
  50. sql="select * from ad order by bs";
  51. rs=mdb.executeQuery(sql);
  52. String url;
  53. String wordlink;
  54.       while (rs.next())
  55.   {
  56.   
  57.      out.print("<a href="+rs.getString("url").trim()+" target=_blank>"+rs.getString("wordlink").trim()+"</a><br>");
  58.       }
  59.       
  60.      
  61.       %>
  62.                                     </p></td>
  63.                                 </tr>
  64.                               </table>
  65.                               <!---------------------------------友情链接结束----------------------------------------------->
  66.                             </td>
  67.                           </tr>
  68.                         </table>