2.jstl之SQL:setDataSource

来源：互联网发布：郑州造价软件培训班编辑：程序博客网时间：2024/05/18 15:24

<%@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>