paihang2.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:1k
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <%
- sql="select top 11 * from hw order by hw_buys DESC";
- rs=mdb.executeQuery(sql);
- if(!rs.next())
- {
- out.print("本站目前没有成交任何商品");
- }else
- {
- rs.previous();
- i=0;
- int hw_id,daili;
- String hw_name;
- while(rs.next()&i<=10){
- hw_id=rs.getInt("hw_id");
- hw_name=rs.getString("hw_name");
- daili=rs.getInt("daili");
- %>
-
- <tr>
- <td width="70%" height="22" bgcolor="#F5EFE7">
- <a href="views.jsp?hw_id=<%=hw_id%>"><%=hw_name%></a></td>
- <td width="30%" bgcolor="#F5EFE7"><%=daili%></td>
- </tr>
-
- <%
- i=i+1;
-
- }
- }
- %> </table>