catalogtable.tag

beginJsp2.0外文书籍源代码

<%@ taglib uri="http://java.sun.com/jstl/fmt_rt" prefix="fmt" %>
<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql_rt" prefix="sql" %>
<sql:setDataSource  url="jdbc:mysql://localhost/catalog"
                 driver="org.gjt.mm.mysql.Driver"
                   user="catalogDBA" password="wrox"/> 

        <sql:query var="catalog">
            <jsp:doBody/>
        </sql:query>

        <table width="100%">
            <tr>
                <th>
                    Item
                </th>
                <th>
                    Description
                </th>
                <th>
                    Price
                </th>
            </tr>
            <c:forEach varStatus="status" var="row"
                       items="${catalog.rows}">
                <tr>
                    <td>
                        ${row.name}
                    </td>
                    <td>
                        ${row.description}
                    </td>
                    <td class="price">
                        <fmt:formatNumber value="${row.price / 100}"
                                          type="currency"/>
                    </td>
                </tr>
            </c:forEach>
        </table>