splist.jsp

网上服装店 能让用户在该网站上对物品进行上传购买等操作。该设计为原版

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="com.bwm.db.Condb"%>

<table border="0" cellpadding="0" cellspacing="0" width="625" height="" align="center"   >
      <tr>
        <td><img name="cplist_01_01" src="image/cplist_01.gif" width="625" height="69" border="0" alt="" /></td>
      </tr>
      <tr>
        <td width="625" background="image/usercenter_02.gif">
		<table width="100%"  border="0" cellpadding="0" cellspacing="0" background=""> 
      
	    <%
		
		String sql="select * from tb_Ware order by Dattime";
		ResultSet rs=con.executeQuery(sql);
		int num=0;
		int count=0;
		int i=1;
		while(rs!=null && rs.next()){
		count++;
		if(count==7){
			break;
		}
		String warename=rs.getString(2);
		String wareprice=rs.getString(3);
		String waretype=rs.getString(4);
		String wareintro=rs.getString(5);
		String img=rs.getString(6);
		if(i%2!=0){
					%> 
        <tr> 
          <td width="145" height="184" valign="top"><img src="<%=img%>" width="145" height="184" border="0"></td> 
          <td width="167" align="center" valign="top"> <table width="100%" height="184" border="0" cellpadding="0" cellspacing="0" > 
       <tr> 
          <td width="49" height="30" align="left">&nbsp;名称:</td> 
          <td width="95" align="left"><%=warename%></td>
        </tr> 
		<tr> 
          <td height="30">&nbsp;类别:</td>
          <td height="30"><%=waretype%></td>
        </tr>
		<tr> 
          <td height="30">&nbsp;原价:</td>
          <td height="30"><%=wareprice%></td>
        </tr>
        <tr> 
          <td height="30">&nbsp;现价:</td>
          <td height="30"><%=wareprice%></td>
        </tr> 
		 <tr> 
           <td height="30"> &nbsp;介绍: </td>
		   <td height="30"><%=wareintro%></td>
		 </tr>
		 <tr> 
          <td height="30" colspan="2"><center> 
              <a href="user/look.jsp?buy1=<%=warename%>"><img src="images/buy.GIF" width="45" height="20" class="btn_grey"></a>
          </center></td> 
        </tr>  
      </table>	 	</td>
          <%
		}else{
		%>     
          <td width="145" height="184" valign="top"><img src="<%=img%>" width="145" height="184" border="0"></td> 
          <td width="167" align="center" valign="top"> <table width="100%" height="184" border="0" cellpadding="0" cellspacing="0" > 
       <tr> 
          <td width="49" height="30" align="left">&nbsp;名称:</td> 
          <td width="95" align="left"><%=warename%></td>
        </tr> 
		<tr> 
          <td height="30">&nbsp;类别:</td>
          <td height="30"><%=waretype%></td>
        </tr>
		<tr> 
          <td height="30">&nbsp;原价:</td>
          <td height="30"><%=wareprice%></td>
        </tr>
        <tr> 
          <td height="30">&nbsp;现价:</td>
          <td height="30"><%=wareprice%></td>
        </tr> 
		 <tr> 
           <td height="30"> &nbsp;介绍: </td>
		   <td height="30"><%=wareintro%></td>
		 </tr>
		 <tr> 
          <td height="30" colspan="2"><center> 
              <a href="user/look.jsp?buy1=<%=warename%>"><img src="images/buy.GIF" width="45" height="20" class="btn_grey"></a>
          </center></td> 
        </tr>  
      </table>	 	</td> 
  </tr>
   <%
		}
		i++;
		}con.close();
%> 
	<tr align="right">
      <td colspan="4"><a href="middle.jsp">更多....</a></td>
   </tr> 
</table>
		</td>
      </tr>
      <tr>
        <td><img name="usercenter_03" src="image/usercenter_03.gif" width="625" height="4" border="0" alt=""></td>
      </tr>
</table>