5.jstl之SQL:query

来源：互联网发布：迅龙数据注册机编辑：程序博客网时间：2024/05/17 08:13
<%@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 border="1" >      <tr>          <c:forEach items="${accountsRS.columnNames}" var="cucN">              <td><c:out value="${cucN}"/></td>          </c:forEach>      </tr>      <c:forEach items="${accountsRS.rows}" var="cuRe">          <tr>   <td>${cuRe.mainid} </td><td>${cuRe.id} </td><td>${cuRe.Id_Employees} </td><td>${cuRe.Code} </td><td>${cuRe.Name} </td><td>${cuRe.Sex} </td><td>${cuRe.Birthday} </td><td>${cuRe.doctorclass} </td><td>${cuRe.position} </td> </tr>      </c:forEach>  </table>  </body></html>