viewbuycar.jsp

一个简单的购物网站,包括购物车的实现

<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ page isELIgnored="false"%>
<!------设置数据源------>
<sql:setDataSource 
  	dataSource="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore,com.microsoft.jdbc.sqlserver.SQLServerDriver,sa,19871127"
	var="sqlDS"/>
<jsp:include page="banner.jsp"/>
<table border="0" cellpadding="0" cellspacing="0" width="777">
  <tr>
    <td width="170">
       <jsp:include page="DenLu.jsp"/>
    </td>
    <td>
      <table border="1" cellpadding="0" cellspacing="0" width="607">
      	<tr><td align="center"><font size="2" color="#000080">序号</font></td>
      		<td align="center"><font size="2" color="#000080">书名</font></td>
      		<td align="center"><font size="2" color="#000080">出版社</font></td>
      		<td align="center"><font size="2" color="#000080">数量</font></td>
      		<td align="center"><font size="2" color="#000080">单价</font></td>
      		<td align="center"><font size="2" color="#000080">总价</font></td>
      		<td align="center"><font size="2" color="#000080">拿出一本?</font></td></tr>
      	<c:set var="book_no" value="${0}"/>
      	<c:set var="allbookcount" value="${0}"/>
      	<c:set var="allbookprice" value="${0}"/>
      	<!--显示购物车中的书藉信息-->
        <c:forEach items="${sessionScope.car.myGoods}" var="carbook">
         	<c:set var="book_id" value="${fn:substringBefore(carbook,'=')}"/>
         	<c:set var="book_count" value="${fn:substringAfter(carbook,'=')}"/>
         	<c:set var="selectSQL" value=
				"select book_id,book_name,publisher,author,price,price_rebate,
				pagecount,format,simple_content
	 			from book where book_id=${book_id}"/>
		 	<sql:query dataSource="${sqlDS}" sql="${selectSQL}" var="bookRS"/>
		 	<c:forEach items="${bookRS.rowsByIndex}" var="book">
        <tr><c:set var="book_no" value="${book_no+1}"/>
          <td><font size="2" color="#000080">${book_no}</font></td>
          <td><font size="2" color="#000080">
          	<a href="../viewBook.jsp?bookId=${book[0]}">${book[1]}</a></font></td>
          <td><font size="2" color="#000080">${book[2]}</font></td>
          <c:set var="allbookcount" value="${allbookcount+book_count}"/>
          <td><font size="2" color="#000080">${book_count}</font></td>
          <c:set var="book_price" value="${book[4]*book[5]/10}"/>
          <td><font size="2" color="#000080">
          <fmt:formatNumber value="${book_price}"  maxFractionDigits="2"/>
          </font></td>
          <c:set var="allbookprice" value="${allbookprice+book[4]*book[5]*book_count/10}"/>
          <c:set var="bookcount_price" value="${book[4]*book[5]*book_count/10}"/>
          <td><font size="2" color="#000080">
          <fmt:formatNumber value="${bookcount_price}"  maxFractionDigits="2"/>
          </font></td>
          <td><font size="2" color="#000080">
            <a href="deleteBookFromCar.jsp?book_id=${book[0]}">拿出一本</a></font></td>
        </tr>
        	</c:forEach>
        </c:forEach>
        <tr><td><font size="2" color="#000080">总计</font></td>
        	<td><font size="2" color="#000080">&nbsp;</font></td>
        	<td><font size="2" color="#000080">&nbsp;</font></td>
      		<td><font size="2" color="#000080">${allbookcount}</font></td>
      		<td><font size="2" color="#000080">&nbsp;</font></td>
      		<td><font size="2" color="#000080">
      		<fmt:formatNumber value="${allbookprice}"  maxFractionDigits="2"/>
      		</font></td>
      		<td><font size="2" color="#000080">&nbsp;</font></td></tr>
      <c:if test="${book_no!=0}">
      <tr><td colspan="7" align="center"><font size="2" color="#000080">
      		<a href="makeOrderForm.jsp">生成订单</a></font>
      		</td></tr>
      </c:if>
      </table>
    </td>
  </tr>
</table>
<jsp:include page="bottom.jsp"/>