vieworderform.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"%>
<c:if test="${empty sessionScope.user_id}">
	<c:redirect url="index.jsp"/>
</c:if>
<!------设置数据源------>
<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 valign="top">
    <td width="170" valign="top">
       <jsp:include page="DenLu.jsp"/>
    </td>
    <td>
    <c:set var="userId" value="${sessionScope.user_id}"/>
    <c:set var="selectSQL" value="
    	select order_form_id,status from order_form 
    	 where user_id=${userId} order by add_time desc"/>
    <sql:query sql="${selectSQL}" var="orderForms" dataSource="${sqlDS}"/>
    <c:forEach items="${orderForms.rowsByIndex}" var="orderForm">
      <table border="1" cellpadding="0" cellspacing="0" width="607">
        <tr><td colspan="6" align="center"><font size="2" color="#000080">
      		订单号:${orderForm[0]}&nbsp;&nbsp;
      		订单状态:${orderForm[1]}（0--新订单&nbsp;1--客户已确认
      		&nbsp;2--正在配货&nbsp;3--已发货&nbsp;4--缺货）
      		</font></td></tr>
      	<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></tr>
      	<c:set var="book_no" value="${0}"/>
      	<c:set var="allbookcount" value="${0}"/>
      	<c:set var="allbookprice" value="${0}"/>
      	<c:set var="selectSQL" value="
      		select book.book_id,book.book_name,book.publisher,order_form_book.book_count,
      		book.price,book.price_rebate from book,order_form_book where 
      		order_form_book.order_form_id=${orderForm[0]} and 
      		order_form_book.book_id=book.book_id"/>
      	<sql:query sql="${selectSQL}" var="bookRS" dataSource="${sqlDS}"/>     	
        <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[3]}"/>
          <td><font size="2" color="#000080">${book[3]}</font></td>
          <td><font size="2" color="#000080">
           	<fmt:formatNumber value="${book[4]*book[5]/10}"  maxFractionDigits="2"/>
          </font></td>
          <td><font size="2" color="#000080">
          	<fmt:formatNumber value="${book[3]*book[4]*book[5]/10}"  maxFractionDigits="2"/>
          	<c:set var="allbookprice" value="${allbookprice+book[3]*book[4]*book[5]/10}"/>
          </font></td>
        </tr>
        </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></tr>
      <tr><td colspan="6" align="center"><font size="2" color="#000080">
      	    <c:if test="${orderForm[1]==0||orderForm[1]==4}"><!--状态为5表示取消订单-->
      			<c:url value="modiOrderStatus.jsp" var="redirectURL">
      				<c:param name="order_form_id" value="${orderForm[0]}"/>
      				<c:param name="status" value="5"/>
      				<c:param name="redirect_page" value="viewOrderForm.jsp"/>
      			</c:url>
      			<a href="${redirectURL}">取消订单</a>&nbsp;&nbsp;
      		</c:if>
      		<c:if test="${orderForm[1]==0}">
      			<c:url value="modiOrderStatus.jsp" var="redirectURL">
      				<c:param name="order_form_id" value="${orderForm[0]}"/>
      				<c:param name="status" value="1"/>
      				<c:param name="redirect_page" value="viewOrderForm.jsp"/>
      			</c:url>
      			<a href="${redirectURL}">确认订单</a></font>
      		</c:if></td></tr>
      </table><br>
      </c:forEach>
    </td>
  </tr>
</table>
<jsp:include page="bottom.jsp"/>