bookview.jsp

JavaWeb标签应用开发（随书光盘）为方便读者阅读本书和调试程序

<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ page isELIgnored="false"%>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<c:if test="${empty param.book_id}">
  <tr><td align="right"><font size="2" color="#000080">
     书名:</font></td><td>
     <input type="text" name="book_name" size="40">
     <font size="2" color="#000080">（*）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     所属种类:</font></td><td>
     <c:set var="selectSQL" value="select type_id,type_name from book_type"/>
     <sql:query sql="${selectSQL}" dataSource="${sqlDS}" var="bookTypeRS"/>
     <select name="book_type">
     <c:forEach items="${bookTypeRS.rowsByIndex}" var="bookType">
     	<option value="${bookType[0]}">${bookType[1]}</option>
     </c:forEach>
     </select>
     <font size="2" color="#000080">（*）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     作者:</font></td><td>
     <input type="text" name="author">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     出版社:</font></td><td>
     <input type="text" name="publisher">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     价格:</font></td><td>
     <input type="text" name="price">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     折扣:</font></td><td>
     <input type="text" name="price_rebate">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     出版日期:</font></td><td>
     <input type="text" name="publish_date">
     <font size="2" color="#000080">（日期格式为：年-月-日）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     页数:</font></td><td>
     <input type="text" name="pagecount">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     开本:</font></td><td>
     <input type="text" name="format">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     内容简介:</font></td><td>
     <textarea name="simple_content" rows="6" cols="40">
     </textarea>
   </td></tr>
</c:if>
<c:if test="${not empty param.book_id}">
  <c:set var="selectSQL" value="select book_name,author,
  	publisher,price,price_rebate,publish_date,pagecount,format,
  	simple_content,type_id from book where book_id=${param.book_id}"/>
  <sql:query sql="${selectSQL}" var="bookRS" dataSource="${sqlDS}"/>
  <c:forEach items="${bookRS.rowsByIndex}" var="book">
  <tr><td align="right"><font size="2" color="#000080">
     书名:</font></td><td>
     <input type="text" name="book_name" size="40" value="${book[0]}">
     <font size="2" color="#000080">（*）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     所属种类:</font></td><td>
     <c:set var="selectSQL" value="select type_id,type_name from book_type"/>
     <sql:query sql="${selectSQL}" dataSource="${sqlDS}" var="bookTypeRS"/>
     <select name="book_type">
     <c:forEach items="${bookTypeRS.rowsByIndex}" var="bookType">
     	<option value="${bookType[0]}"
     	<c:if test="${bookType[0]==book[9]}">selected</c:if>>
     	${bookType[1]}</option>
     </c:forEach>
     </select>
     <font size="2" color="#000080">（*）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     作者:</font></td><td>
     <input type="text" name="author" value="${book[1]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     出版社:</font></td><td>
     <input type="text" name="publisher" value="${book[2]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     价格:</font></td><td>
     <input type="text" name="price" value="${book[3]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     折扣:</font></td><td>
     <input type="text" name="price_rebate" value="${book[4]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     出版日期:</font></td><td>
     <input type="text" name="publish_date" value="${book[5]}">
     <font size="2" color="#000080">（日期格式为：年-月-日）</font>
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     页数:</font></td><td>
     <input type="text" name="pagecount" value="${book[6]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     开本:</font></td><td>
     <input type="text" name="format" value="${book[7]}">
   </td></tr>
   <tr><td align="right"><font size="2" color="#000080">
     内容简介:</font></td><td>
     <textarea name="simple_content" rows="6" cols="40">
     ${book[8]}
     </textarea>
   </td></tr>
   </c:forEach>
</c:if>