hoton.jsp

来自「购物系统」· JSP 代码 · 共 35 行

<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>