sql_query.jsp

JavaWeb高级特性书中源代码

<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=gb2312" %>
<sql:setDataSource dataSource="jdbc/testSQL" var=" myDataSource" />
按“birthday”字段倒序从users表中查询年龄大于23的记录，从第二条记录开始显示5
	条记录
<sql:query var="users" dataSource="${myDataSource}" maxRows="5" startRow="2">
	select * from users where datediff(yyyy,birthday,getdate()) > ? order by
 birthday desc
	<sql:param>23</sql:param>
</sql:query>
<table border="1">
	<tr><td>name</td><td>birthday</td><td>address</td></tr>
	<c:forEach var="row" items="${users.rows}">
		<tr>
			<td>${row.name}</td><td>${row.birthday}</td><td>${row.address}</td>
		</tr>
	</c:forEach>
</table>