bought.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:3k
源码类别:

百货/超市行业

开发平台:

Java

  1. <tr> 
  2.     <td valign="top"><table border="0" width="100%" cellspacing="0" height="34" cellpadding="0">
  3.         <tr> 
  4.           <td width="398" bgcolor="#F5EFE7">
  5.     <div align="center">
  6.               <center> 
  7. <!-----------------------------one showing unit--------------------------------------------->
  8.             <table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  9.               <tr background="img/pics/tile_bg.gif"> 
  10.                 <td width="155" height="25"> <div align="center">商品名称</div></td>
  11.                 <td width="80"> <div align="center">商品单价</div></td>
  12.                 <td width="80"> <div align="center">订购数量</div></td>
  13.                 <td width="80"> <div align="center">订购时间</div></td>
  14.                 <td width="80"> <div align="center">合计</div></td>
  15.               </tr>
  16.               <%
  17.   sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
  18.                rs=mdb.executeQuery(sql);
  19.             while(rs.next())
  20.   {
  21.      hw_cashs=rs.getString("hw_cash");
  22.      hw_cash=Cint(hw_cashs);
  23.      basket_count=rs.getString("basket_count");
  24.       count=Cint(basket_count);
  25.  hw_name=rs.getString("hw_name");
  26.      jiage=hw_cash;
  27.       
  28.   %>
  29.               <tr> 
  30.                 <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>
  31.                 <td width="65" height="25"> <div align="center"> 
  32.                     <%=jiage%> 元</div></td>
  33.                 <td width="65" height="25"> <div align="center"><%=basket_count%> 
  34.                   </div></td>
  35.                 <td width="65" height="25"> <div align="center"><%=rs.getDate("basket_date")%> 
  36.                   </div></td>
  37.                 
  38.                 <td width="65" height="25"> <div align="center"> 
  39.                     <%=jiage*count%> 元 </div></td>
  40.                 <%
  41. totalcash=totalcash+jiage*count;%>
  42.               </tr>
  43.               <%
  44.               }
  45.              
  46.               %>
  47.               <tr> 
  48.                 <td width="321" height="25" colspan="4"><div align="center">总计:</div></td>
  49.                 <td width="65" height="25"><div align="center"><%=totalcash%>
  50.                   元</div></td>
  51.             </table>
  52. <!--------------------------showing unit end---------------------------------------->
  53.               </center>
  54.           </div>
  55.             <table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
  56.               <tr> 
  57.                 <td valign="middle"><div align="center"><img src="img/pics/seperator.gif" width="359" height="1"></div></td>
  58.               </tr>
  59.             </table></td>
  60.           <td width="14" valign="top" bgcolor="#F5EFE7"><div align="right"></div></td>
  61.         </tr>
  62.       </table></td>
  63.   </tr>