展示数据库内容-优快云博客

//web.xml
<?xml version= "1.0" encoding= "UTF-8" ?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
   "http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
   <resource-ref>
     <res-ref-name>jdbc/address</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
   </resource-ref>
</web-app>

<%@ taglib prefix= "sql" uri= "http://java.sun.com/jstl/sql" %>
<%@ taglib prefix= "c" uri= "http://java.sun.com/jstl/core" %>
< html >
<head>
<title>Presenting database content using tags</title>
<sql:setDataSource
   dataSource= "jdbc/address"
   var= "conn"
/>
</head>
< body >

<h1>Address List</h1>
<sql:query dataSource= "${conn}" var= "addresses" >
     SELECT * FROM AddressList
</sql:query>
<table width= "90%" border= "1" >
<tr>

<c:forEach var= "columnName" items= "${addresses.columnNames}" >
   <th> <c:out value= "${columnName}" /> </th>
</c:forEach>
</tr>

<c:forEach var= "row" items= "${addresses.rowsByIndex}" >
   <tr>
     <c:forEach var= "column" items= "${row}" >
       <td><c:out value= "${column}" /></td>
     </c:forEach>
   </tr>
</c:forEach>
</table>
</ body >
</ html >