Posted on 2006-07-18 13:18
duyouyou.com 阅读(311)
评论(0) 编辑 收藏 所属分类:
web技术
//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>
<!-- add the table column headings -->
<c:forEach var=
"columnName"
items=
"${addresses.columnNames}"
>
<th> <c:out value=
"${columnName}"
/> </th>
</c:forEach>
</tr>
<!-- add the table rows from the result set -->
<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
>