<%@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" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<sql:setDataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=test"
user="sa" var="ds" />
<sql:query var="result" dataSource="${ds}" >
select * from student
</sql:query>
<table>
<tr>
<td>学号</td><td>姓名</td><td>性别</td><td>年龄</td><td>系部</td>
</tr>
<c:forEach var="row" items="${result.rowsByIndex}">
<tr>
<td><c:out value="${row[0]}" /></td>
<td><c:out value="${row[1]}" /></td>
<td><c:out value="${row[2]}" /></td>
<td><c:out value="${row[3]}" /></td>
<td><c:out value="${row[4]}" /></td>
</tr>
</c:forEach>
</table>
</body>
</html>