paihang2.jsp

来自「叮当购物系统(ACCESS版): 主要功能: 客户在线购物, 管理员可发送」· JSP 代码 · 共 34 行

 <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#D5A384">
                                    <%
//sql="select * from hw order by hw_buys DESC limit 0,11";
sql="select * from hw ";
rs=faqBeanid.executeQuery(sql);
if(!rs.next()){
out.print("本站目前没有成交任何商品");
 }else
{
//rs.previous();
i=0;
int hw_id,daili;
String hw_name;
rs=faqBeanid.executeQuery(sql);
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="#F1E0D6">&nbsp; 
                                          <a href="views.jsp?hw_id=<%=hw_id%>"><%=hw_name%></a></td>
                                        <td width="30%" bgcolor="#F1E0D6"><%=daili%></td>
                                      </tr>
                                    
                                    <%
    i=i+1;                                                   
     
      }
}


 %>                                 </table>