<%@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"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
user="sa"
password="Ro0t@345"
url="jdbc:sqlserver://192.168.0.198;DatabaseName=gd2h"
/>
<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>
3.jstl之SQL:setDataSource
最新推荐文章于 2021-01-27 20:28:55 发布