使用JSTL标签库的SQL标签访问数据库
<%@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>