sql.jsp

来自「介绍了j2ee开发常用的学习知识,如servlet,javamail,EJB等知」· JSP 代码 · 共 34 行

<%@  page  contentType="text/html;charset=GB2312"  %>
<%@  taglib  prefix="c"  uri="http://java.sun.com/jsp/jstl/core"  %>
<%@  taglib  prefix="sql"  uri="http://java.sun.com/jsp/jstl/sql"  %>

<sql:setDataSource var="dataSrc"
                   url="jdbc:mysql://localhost/sample" driver="org.gjt.mm.mysql.Driver"
                   user="root" password="javaee"/>
<sql:query var="queryResults" dataSource="${dataSrc}" maxRows="4">
    select * from book 
</sql:query>
<c:forEach
    items="${queryResults.rowsByIndex}"
    var="row"
    varStatus="s">
<c:if test="${s.first}">
    <table border="1">
    <tr>
        <c:forEach
            items="${queryResults.columnNames}"
            var="col">
            <th><c:out value="${col}"/></th>
        </c:forEach>
    </tr>
</c:if>
<tr>
    <c:forEach items="${row}" var="value">
        <td><c:out value="${value}"/></td>
    </c:forEach>
</tr>
<c:if test="${s.last}">
    </table>
</c:if>
</c:forEach>