bought.jsp
上传用户:szlmxq
上传日期:2014-01-31
资源大小:740k
文件大小:3k
源码类别:

Applet

开发平台:

Java

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