minipricebook.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"%>
<!------设置数据源------>
<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>
    <td width="160">
       <jsp:include page="DenLu.jsp"/>
    </td>
    <td>
      <table border="0" cellpadding="0" cellspacing="0" width="610">
        <tr>
        <c:set var="selectTop6" value=
			"select top 6 book_id,book_name,price_rebate
			 from book where price_rebate<=5 order by price desc"/>
		<sql:query dataSource="${sqlDS}" sql="${selectTop6}" var="top6Book"/>
        <c:forEach items="${top6Book.rowsByIndex}" var="book">
          <td><a href="viewBook.jsp?bookId=${book[0]}">
          <img border="0" src="testimageout.jsp?id=${book[0]}" height="130">
          </a><br><font size="2" color="#000080">
          <fmt:formatNumber value="${book[2]}"  maxFractionDigits="1"/>
           折</font></td>
        </c:forEach>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table width="777">
<c:set var="selectBook" value=
	"select book_id,book_name,price_rebate
	 from book where price_rebate<=5 order by add_time desc"/>
<sql:query dataSource="${sqlDS}" sql="${selectBook}" var="bookRS"/>
<c:set var="i" value="0"/>
<c:forEach items="${bookRS.rowsByIndex}" var="book">
	<c:if test="${i%3==0}">
		<tr>
	</c:if>
	<td><font size="2" color="#000080">
		<a href="viewBook.jsp?bookId=${book[0]}">
		<li>[${book[2]}折]
		<c:if test="${fn:length(book[1])>12}">
          	<c:out value="${fn:substring(book[1],0,12)}"/>...
        </c:if>
        <c:if test="${fn:length(book[1])<=12}">
          	<c:out value="${book[1]}"/>
        </c:if></a>
	</font></td> 
	<c:set var="i" value="${i+1}"/>
	<c:if test="${i%3==0}">
		</tr>
	</c:if>
</c:forEach>  
</table>
<jsp:include page="bottom.jsp"/>