booklist.jsp

beginJsp2.0外文书籍源代码

<%@page contentType="text/html"%>
<%@taglib prefix="c" uri="http://java.sun.com/jstl/core_rt"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jstl/sql_rt"%>
<%@taglib prefix="html" uri="http://jakarta.apache.org/struts/tags-html-1.0"%>
<%@taglib prefix="bean" uri="http://jakarta.apache.org/struts/tags-bean-1.0"%>
<%@taglib prefix="logic" uri="http://jakarta.apache.org/struts/tags-logic-1.0"%>

<sql:query var="books" 
           dataSource="${applicationScope['org.apache.struts.action.DATA_SOURCE']}">
    select * 
      from book 
     where status=?
  <sql:param value="${param.status}"/>
</sql:query>
<table width="100%">
  <c:forEach var="book" items="${books.rows}" end="10">
    <tr>
      <td class="title">
        <html:link page="/book/edit.do?id=${book.id}">
          ${book.title}
        </html:link>
        (${book.authors})
      </td>
    </tr>
  </c:forEach>
  <c:if test="${empty books.rows}">
    <tr>
      <td class="title"><bean:message key="booklist.nobooks"/></td>
    </tr>
  </c:if>
  <logic:present role="editor">
    <tr>
      <td align="right">
        <html:link page="/book/add.do?status=${param.status}">
          <bean:message key="booklist.add.link"/>
        </html:link>
      </td>
    </tr>
  </logic:present>
</table>