<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% String username=(String)session.getAttribute("username"); ResultSet rs=conn.executeQuery("select top 10 GoodsID,GoodsName, sum(number) as sumNum from V_order_detail group by GoodsName,GoodsID order by sumNum desc"); int goodsID=-1; String goodsName=""; %>

<%int m=1; while(rs.next()){ goodsID=rs.getInt(1); goodsName=rs.getString(2); %>       <%=goodsName%> <%if (username!=null && username!=""){%>  <%}else{out.println("登录后可购买");}%> <% m++; }%>

<%conn.close();%>