开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 百货/超市行业 > 查看源码
topnews.jsp
资源名称：JspShop网络购物系统.rar　[点击查看]
上传用户：helenhuo66
上传日期：2007-06-01
资源大小：865k
文件大小：2k
源码类别：

百货/超市行业

开发平台：

Java

topnews.jsp：源码内容
  1. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  2.                                 <!--DWLayoutTable-->
  3.                                 <tr> 
  4.                                   <td width="107" height="74">&nbsp;</td>
  5.                                   <td width="165" align="center" valign="top"> 
  6.                                     <table width="165" border="0" cellspacing="0" cellpadding="0">
  7.                                       <!--DWLayoutTable-->
  8.                                       <tr> 
  9.                                         <td valign="top" align="center" bgcolor="#FFFFFF"> 
  10.                                           　</td>
  11.                                       </tr>
  12.                                       <tr> 
  13.                                         <td valign="top" align="center"> <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  14.                                       </tr>
  15.                                       <tr> 
  16.                                         <td valign="top" align="center" bgcolor="#DBC2B0">最新新闻</td>
  17.                                       </tr>
  18.                                       <tr> 
  19.                                         <td valign="top"> 
  20.                                           <%              
  21. sql="select top 10 * from news order by news_id DESC" ;
  22. rs=mdb.executeQuery(sql);
  23. if(!rs.next())
  24. {
  25.   out.print("暂且没有新闻");         
  26. }else
  27. { rs.previous();      
  28.    while(rs.next()){
  29.    %>
  30.                                           <img src="img/dot.gif" width="15" height="15"> 
  31.                                           <a href="news.jsp?news_id=<%=rs.getInt("news_id")%>" target="_blank"><%=rs.getString("news_title")%></a> 
  32.                                           <br> 
  33.                                           <%           
  34.    }        
  35. }       
  36.          
  37.   
  38.                 %>
  39.                                         </td>
  40.                                       </tr>
  41.                                       <tr> 
  42.                                         <td valign="top" align="right"> <a href="allnews.jsp" target="_blank"><img src="img/pics/more.gif" width="45" height="10" border="0"></a></td>
  43.                                       </tr>
  44.                                     </table></td>
  45.                                   <td width="107">&nbsp;</td>
  46.                                 </tr>
  47.                               </table>