Posted on 2006-07-18 13:18
duyouyou.com 閱讀(332)
評論(0) 編輯 收藏 所屬分類:
web技術(shù)
//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
>