topsort.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:2k
源码类别:

百货/超市行业

开发平台:

Java

  1. <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111">
  2.                 <tr> 
  3.                   <td height="18"> <table width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
  4.                       <tr> 
  5.                         <td align="center" height="4"> <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  6.                       </tr>
  7.                       <tr> 
  8.                         <td align="center" height="19" bgcolor="#DBC2B0"> <b>商品分类</b></td>
  9.                       </tr>
  10.                     </table></td>
  11.                 </tr>
  12.                 <tr> 
  13.                   <td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  14.                       <tr> 
  15.                         <td> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" height="16">
  16.                             <tr> 
  17.                               <td height="16" valign="top"> 
  18.                                 <%
  19. sql="select * from sort";
  20. rs=mdb.executeQuery(sql);
  21. if(!rs.next()){
  22. out.print("没有任何分类"); 
  23. }
  24. else 
  25. {
  26. rs.previous();
  27.   while(rs.next()) 
  28.    {
  29. %>
  30.                                 <table cellspacing=0 cellpadding=0 width=95% background="" 
  31.                   border=0>
  32.                                   <tbody>
  33.                                     <tr height=22> 
  34.                                       <td width=34 align="center"><img 
  35.                       src="img/dot.gif" width="15" height="15"></td>
  36.                                       <td width="124"><a href="sort.jsp?sort_id=<%=rs.getInt("sort_id")%>"><u><%=rs.getString("sort_name")%></u></a></td>
  37.                                     </tr>
  38.                                   </tbody>
  39.                                 </table>
  40.                                 <% 
  41.    }
  42. }
  43.  
  44. %>
  45.                               </td>
  46.                             </tr>
  47.                           </table></td>
  48.                       </tr>
  49.                     </table></td>
  50.                 </tr>
  51.               </table>