bookreceipt.jsp

jsp 应用开发技术光盘 是《jsp应用开发技术》这本书的源代码

<sql:setDataSource driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/bookstore?user=lyp&password=pwd&useUnicode=true&characterEncoding=gb2312"/>

<c:set var="sufficientInventory" value="true" />
<sql:transaction>

 	<c:forEach var="item" items="${sessionScope.cart.items}">
    	<c:set var="book" value="${item.item}" />
    	<c:set var="bookId" value="${book.bookId}" />

      	<sql:query var="books" sql="select * from books where id = ?" >
    		<sql:param value="${bookId}" />
  		</sql:query>
      
   		<c:forEach var="book" begin="0" items="${books.rows}">
        	<c:set var="inventory" value="${book.inventory}" />
        
        	<c:if test="${item.quantity > inventory}">
          		<c:set var="sufficientInventory" value="false" />
          		<h3><font color="red" size="+2">
					<fmt:message key="OrderError"/> <i>${bookRow[3]}</i>
				</font></h3>
        	</c:if>
 		</c:forEach>
  	</c:forEach>

  	<c:if test="${sufficientInventory == 'true'}" >
    	<c:forEach var="item" items="${sessionScope.cart.items}">
      		<c:set var="book" value="${item.item}" />
      		<c:set var="bookId" value="${book.bookId}" />

      		<sql:query var="books" sql="select * from books where id = ?" >
        		<sql:param value="${bookId}" />
      		</sql:query>

      		<c:forEach var="book" begin="0" items="${books.rows}">	          
        		<sql:update var="books" sql="update books set inventory = inventory - ? where id = ?" >
          			<sql:param value="${item.quantity}" />
          			<sql:param value="${bookId}" />
        		</sql:update>		  
      		</c:forEach>
    	</c:forEach>
  		<h3><fmt:message key="ThankYou"/> ${param.cardname}.</h3><br>  
    	<jsp:useBean id="now" class="java.util.Date" />
    	<jsp:setProperty name="now" property="time" value="${now.time + 432000000}" />
    	<fmt:message key="ShipDate"/> 
		<fmt:formatDate value="${now}" type="date" dateStyle="full"/>.
		<br>
		<br>
  </c:if>

</sql:transaction>

<c:remove var="cart" scope="session" />
<c:url var="url" value="/bookstore" />
<a href="${url}"><b><fmt:message key="ContinueShopping"/><b></a>