bought.jsp

JSP图书管理系统 包括会员管理 图书管理 借阅管理 等等 是非常好的图书管理软件

<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%" borde="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=stmt.executeQuery(sql);
			while(rs.next())
			  {
			hw_cashs=rs.getString("hw_cash");
			 basket_count=rs.getString("basket_count");
String jiag=rs.getString("daili");
			
			hw_name=rs.getString("hw_name");
						
			   count=1;   
			  %>
              <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"> 
                    <%=jiag%>元</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"> 
                 <%=Cint(jiag)*Cint(basket_count)%>元 </div></td>
                <%
				totalcash=totalcash+Cint(jiag)*Cint(basket_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>