<%--
 
 * Copyright 2002 Sun Microsystems, Inc. All Rights Reserved.
 * 
 * Redistribution and use in source and binary forms, with or
 * without modification, are permitted provided that the following
 * conditions are met:
 * 
 * - Redistributions of source code must retain the above copyright
 *   notice, this list of conditions and the following disclaimer.
 * 
 * - Redistribution in binary form must reproduce the above
 *   copyright notice, this list of conditions and the following
 *   disclaimer in the documentation and/or other materials
 *   provided with the distribution.
 * 
 * Neither the name of Sun Microsystems, Inc. or the names of
 * contributors may be used to endorse or promote products derived
 * from this software without specific prior written permission.
 * 
 * This software is provided "AS IS," without a warranty of any
 * kind. ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND
 * WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE HEREBY
 * EXCLUDED. SUN AND ITS LICENSORS SHALL NOT BE LIABLE FOR ANY
 * DAMAGES OR LIABILITIES SUFFERED BY LICENSEE AS A RESULT OF OR
 * RELATING TO USE, MODIFICATION OR DISTRIBUTION OF THIS SOFTWARE OR
 * ITS DERIVATIVES. IN NO EVENT WILL SUN OR ITS LICENSORS BE LIABLE
 * FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT,
 * SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER
 * CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF
 * THE USE OF OR INABILITY TO USE THIS SOFTWARE, EVEN IF SUN HAS
 * BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
 * 
 * You acknowledge that this software is not designed, licensed or
 * intended for use in the design, construction, operation or
 * maintenance of any nuclear facility.
  
--%>


<%@ taglib uri="/jstl-c" prefix="c" %>
<%@ taglib uri="/jstl-fmt" prefix="fmt" %>
<%@ taglib uri="/jstl-sql" prefix="sql" %>
<%@ page import="java.util.*" %>
<%@ page errorPage="errorpage.jsp" %>

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

  <sql:query var="books" dataSource="jdbc/BookDB">
    select * from PUBLIC.books where id = ?
    <sql:param value="${bid}" />
  </sql:query>
   
  <c:forEach var="book" begin="0" items="${books.rows}">
      <h2><c:out value="${book.title}"/></h2>
      &nbsp;<fmt:message key="By"/> <em><c:out value="${book.firstname}"/> <c:out value="${book.surname}"/></em>&nbsp;&nbsp;
      (<c:out value="${book.year}"/>)<br> &nbsp; <br>
      <h4><fmt:message key="Critics"/></h4>
      <blockquote><c:out value="${book.description}"/>
      </blockquote>
      <h4><fmt:message key="ItemPrice"/>: <fmt:formatNumber value="${book.price}" type="currency"/> 
    </h4>
  </c:forEach>
    <c:url var="url" value="/catalog" >
      <c:param name="Add" value="${bid}" />
    </c:url> 
    <p><strong><a href="<c:out value='${url}'/>"><fmt:message key="CartAdd"/></a>&nbsp; &nbsp; &nbsp;
</c:if>

<c:url var="url" value="/catalog" >
  <c:param name="Add" value="" />
</c:url>
<a href="<c:out value='${url}'/>"><fmt:message key="ContinueShopping"/></a></p></strong>




