bookcatalog.jsp

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

<jsp:useBean id="cart" class="cart.ShoppingCart" scope="session"/>

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


<c:if test="${!empty param.Add}">
  <c:set var="bid" value="${param.Add}"/>

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

  <c:forEach var="bookRow" begin="0" items="${books.rowsByIndex}"> 
    <jsp:useBean id="bid"  type="java.lang.String" />
    <jsp:useBean id="bookRow"  type="java.lang.Object[]" />
    <jsp:useBean id="addedBook" class="database.BookDetails" scope="page" >
      <jsp:setProperty name="addedBook" property="bookId" value="${bookRow[0]}" />
      <jsp:setProperty name="addedBook" property="name" value="${bookRow[1]}" />      
      <jsp:setProperty name="addedBook" property="title" value="${bookRow[2]}" />
      <jsp:setProperty name="addedBook" property="price" value="${bookRow[3]}" />
      <jsp:setProperty name="addedBook" property="year" value="${bookRow[5]}" />
      <jsp:setProperty name="addedBook" property="description" value="${bookRow[6]}" />
      <jsp:setProperty name="addedBook" property="inventory" value="${bookRow[7]}" />
    </jsp:useBean>
    <% cart.add(bid, addedBook); %>
	
    <h3> 
    	<fmt:message key="CartAdded1"/> 
    	<font color="red" size="+2"><em>${bookRow[2]}</em> </font>
		<fmt:message key="CartAdded2"/>
	</h3>
  </c:forEach>
</c:if>

<c:if test="${sessionScope.cart.numberOfItems > 0}"> 
    
	<c:url var="url" value="/bookshowcart" >
    	<c:param name="Clear" value="0" />
    	<c:param name="Remove" value="0" />
  	</c:url>
	<a href="${url}"><b><fmt:message key="CartCheck"/>&nbsp;&nbsp;&nbsp;</b></a>
    
	<c:url var="url" value="/bookcashier" />
    <a href="${url}"><b><fmt:message key="Buy"/></b></a>
</c:if>

<br>
<center>
<h3><fmt:message key="Choose"/></h3>
<table>

	<sql:query var="books">
  		select * from books
	</sql:query> 

	<c:forEach var="book" begin="0" items="${books.rows}">
    	<tr>
    		<c:set var="bookId" value="${book.id}" />
    		<td bgcolor="#ffffaa"> 
        		<c:url var="url" value="/bookdetails" >
          			<c:param name="bookId" value="${bookId}" />
        		</c:url>
        		<a href="${url}"><b>${book.title}&nbsp;</b></a>
        	</td> 
    		<td bgcolor="#ffffaa" rowspan=2> 
    			<fmt:formatNumber value="${book.price}" type="currency"/> 
    		</td> 

    		<td bgcolor="#ffffaa" rowspan=2> 
    			<c:url var="url" value="/bookcatalog" >
      				<c:param name="Add" value="${bookId}" />
    			</c:url> 
    			<a href="${url}"><b>&nbsp;<fmt:message key="CartAdd"/>&nbsp;</b></a>
    		</td>
    	</tr> 

    	<tr> 
    		<td bgcolor="#ffffff"> 
    			<fmt:message key="By"/> <em>&nbsp;&nbsp;${book.name}&nbsp;</em>
    		</td>
    	</tr>
	</c:forEach>

</table>
</center>