topsort.jsp

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

<table width="100%" border="1" cellspacing="0" cellpadding="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#D5A384">
                <tr> 
                  <td height="18"> <table width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
                      <tr> 
                        <td height="4" align="center" bgcolor="#D5A384"> </td>
                      </tr>
                      <tr> 
                        <td align="center" height="19" bgcolor="#D5A384"> <b>商品分类</b></td>
                      </tr>
                    </table></td>
                </tr>
                <tr> 
                  <td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#D5A384" height="16">
                            <tr> 
                              <td height="16" valign="top" bgcolor="#F1E0D6"> 
                                <%
	sql="select * from sort";
	rs=faqBeanid.executeQuery(sql);
	//if(!rs.next()){
		//out.print("??????!"); 
		//}
	//else 
	{
		//rs.previous();
	  while(rs.next()) 
	   {
%>
                                <table cellspacing=0 cellpadding=0 width=95% background="" 
                  border=0>
                                  <tbody>
                                    <tr height=22> 
                                      <td width=34 align="center"><img 
                      src="img/dot.gif" width="15" height="15"></td>
                                      <td width="124"><a href="sort.jsp?sort_id=<%=rs.getInt("sort_id")%>"><u><%=rs.getString("sort_name")%></u></a></td>
                                    </tr>
                                  </tbody>
                                </table>
                              <% 
	   }
	
	rs.close();
	}
	 
	
	
%>                              </td>
                            </tr>
                          </table></td>
                      </tr>
                    </table></td>
                </tr>
</table>