<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.naming.Context"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<!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>测试JSTL</title>
</head>
<body>
<c:out value="测试JSTL"></c:out>
<sql:setDataSource var="datasource" dataSource="jdbc/sqlserver2008"/>
<sql:query sql="select top 10 * from tab_employees"
var="accountsRS" dataSource="${datasource}"/>
共查询出<c:out value="${accountsRS.rowCount}"/>条记录<br>
<table>
<tr>
<td>ID</td>
<td>Name</td>
</tr>
<c:forEach var="row" items="${accountsRS.rows}">
<tr>
<td>${row.id }</td>
<td>${row.name }</td>
</tr>
</c:forEach>
</table>
</body>
</html>
2.jstl之SQL:setDataSource
最新推荐文章于 2023-02-25 22:46:59 发布