hoton.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:1k
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td height="20" align="center" bgcolor="#DBC2B0"><b>热卖型号</b></td>
- </tr>
- <tr>
- <td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td bgcolor="#F5EFE7">
- <%
-
-
- sql="select top 10 * from hw where sort_id="+sort_id+" order by hw_buys desc" ;
- rs=mdb.executeQuery(sql);
- int count=0;
- if(rs!=null){
- while(rs.next())
- {
- count++;
- if(count>8){break;}
- out.print("<li><A href=views.jsp?hw_id="+rs.getInt("hw_id")+">"+rs.getString("hw_name")+" "+rs.getInt("hw_buys")+"</A></li>");
-
- }
- }
- else{
- out.print("目前没有该类商品的热销产品"+sort_id);
- }
-
-
- %>
- </td>
- </tr>
- </table></td>
- </tr>
- </table>