viewtypebook.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" %>
<!------设置数据源------>
<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"/>
<table border="0" cellpadding="0" cellspacing="0" width="777">
  <tr>
    <td width="170">
      <jsp:include page="DenLu.jsp"/>
    </td>
    <td>
      <table border="0" cellpadding="0" cellspacing="0" width="607">
        <tr>
        <c:set var="selectTop6" value=
			"select top 6 book_id,book_name from book where type_id=${param.bookTypeId}"/>
        <sql:query dataSource="${sqlDS}" sql="${selectTop6}" var="bookRS"/>
        <c:forEach items="${bookRS.rowsByIndex}" var="book">
          <td><a href="viewBook.jsp?bookId=${book[0]}">
          <img border="0" src="testimageout.jsp?id=${book[0]}" height="130">
          </a></td>
        </c:forEach>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table width="777">
<c:set var="selectSQL" value=
	"select book_id,book_name from book where type_id=${param.bookTypeId}"/>
<sql:query dataSource="${sqlDS}" sql="${selectSQL}" var="bookRS"/>
<c:set var="i" value="0"/>
<c:forEach items="${bookRS.rowsByIndex}" var="book">
	<c:if test="${i%4==0}">
		<tr>
	</c:if>
	<td><font size="2" color="#000080">
		<a href="viewBook.jsp?bookId=${book[0]}">
		<c:if test="${fn:length(book[1])>12}">
          	<li><c:out value="${fn:substring(book[1],0,12)}"/>...
        </c:if>
        <c:if test="${fn:length(book[1])<=12}">
          	<li><c:out value="${book[1]}"/>
        </c:if></a>
	</font></td> 
	<c:set var="i" value="${i+1}"/>
	<c:if test="${i==4}">
		</tr>
	</c:if>
</c:forEach>  
</table>
<jsp:include page="bottom.jsp"/>