viewbook.jsp

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

<%@ page contentType="text/html;charset=GB2312" %>
<%@ 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" %>
<!------设置数据源------>
<sql:setDataSource 
  	dataSource="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore,com.microsoft.jdbc.sqlserver.SQLServerDriver,sa,19871127"
	var="sqlDS"/>
<%@ page isELIgnored="false"%>
<jsp:include page="banner.jsp"/>
<c:set var="selectSQL" value=
	"select book_id,book_name,publisher,author,price,price_rebate
	,pagecount,format,simple_content
	 from book where book_id=${param.bookId}"/>
<sql:query dataSource="${sqlDS}" sql="${selectSQL}" var="bookRS"/>
<table width="777">
<c:forEach items="${bookRS.rowsByIndex}" var="book">
<tr>
	<td><img border="0" src="testimageout.jsp?id=${book[0]}" height="280"></td>
	<td><font size="2" color="#008000">
	<a href="addBookToCar.jsp?book_id=${book[0]}">放入购物车</a><br>
	书名:${book[1]}<br>
	出版社:${book[2]}<br>
	作者:${book[3]}<br>
	原价:<fmt:formatNumber value="${book[4]}" maxFractionDigits="2"/><br>
	折后价:<fmt:formatNumber value="${book[4]*book[5]/10}"  maxFractionDigits="2"/>
	(<fmt:formatNumber value="${book[5]}"  maxFractionDigits="1"/>折)<br>
	页数:${book[6]}<br>
	开本:${book[7]}<br>
	内容简介:<br>
	${book[8]}<br>
	</font></td>
</tr>
</c:forEach>
</table>
<jsp:include page="bottom.jsp"/>