sql1.jsp

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

<%@  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}">
  select * from book  limit   ?
  <sql:param value="${5}"/></sql:query>
<table border="1">
  <tr>
    <th>ID</th>
   
    <th>书名</th>
    <th>作者</th>
    <th>价格</th>
  </tr>
<c:forEach var="row" items="${queryResults.rows}">
  <tr>
    <td><c:out value="${row.id}"/></td>
    <td><c:out value="${row.title}"/></td>
    <td><c:out value="${row.author}"/></td>
    <td><c:out value="${row.price}"/></td>
  </tr>
</c:forEach>
</table>