bought.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:3k
- <tr>
- <td valign="top"><table border="0" width="100%" cellspacing="0" height="34" cellpadding="0">
- <tr>
- <td width="398" bgcolor="#F5EFE7">
- <div align="center">
- <center>
- <!-----------------------------one showing unit--------------------------------------------->
- <table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
- <tr background="img/pics/tile_bg.gif">
- <td width="155" height="25"> <div align="center">商品名称</div></td>
- <td width="80"> <div align="center">商品单价</div></td>
- <td width="80"> <div align="center">订购数量</div></td>
- <td width="80"> <div align="center">订购时间</div></td>
- <td width="80"> <div align="center">合计</div></td>
- </tr>
- <%
- sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
- rs=mdb.executeQuery(sql);
- while(rs.next())
- {
- hw_cashs=rs.getString("hw_cash");
- hw_cash=Cint(hw_cashs);
- basket_count=rs.getString("basket_count");
- count=Cint(basket_count);
- hw_name=rs.getString("hw_name");
- jiage=hw_cash;
-
- %>
- <tr>
- <td width="155" height="25"> <div align="center"><a href="clear.jsp?basket_id=<%=rs.getInt("basket_id")%>"><font color="#FF0000"><%=hw_name%></font></a></div></td>
- <td width="65" height="25"> <div align="center">
- <%=jiage%> 元</div></td>
- <td width="65" height="25"> <div align="center"><%=basket_count%>
- </div></td>
- <td width="65" height="25"> <div align="center"><%=rs.getDate("basket_date")%>
- </div></td>
-
- <td width="65" height="25"> <div align="center">
- <%=jiage*count%> 元 </div></td>
- <%
- totalcash=totalcash+jiage*count;%>
- </tr>
- <%
- }
-
- %>
- <tr>
- <td width="321" height="25" colspan="4"><div align="center">总计:</div></td>
- <td width="65" height="25"><div align="center"><%=totalcash%>
- 元</div></td>
- </table>
- <!--------------------------showing unit end---------------------------------------->
- </center>
- </div>
- <table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
- <tr>
- <td valign="middle"><div align="center"><img src="img/pics/seperator.gif" width="359" height="1"></div></td>
- </tr>
- </table></td>
- <td width="14" valign="top" bgcolor="#F5EFE7"><div align="right"></div></td>
- </tr>
- </table></td>
- </tr>