JSP JSTL < SQL: query > tag: query through SQL statement

Syntax:

The syntax format without query conditions is as follows:

actions

The syntax format of query criteria is as follows:

query optional

actions

Example 1:

<%@page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
      <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.sqlServerDriver"
                         url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=db_testJSTL"
                         user="sa" password=""/>
      <sql:query var="rs" sql="SELECT*FROM tb_user" maxRows="5" startRow="2"/>
      <table width="300" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF"
             bordercolordark="#999999" bordercolorlight="#FFFFFF">
        <tr>
          <td align="center">＆nbsp;${rs.columnNames[0]}</td>
          <td align="center">＆nbsp;${rs.columnNames[1]}</td>
          <td align="center">＆nbsp;${rs.columnNames[2]}</td>
        </tr>
        <c:forEach items="${rs.rowsByIndex}"var="row">
          <tr>
            <td>＆nbsp;${row[0]}</td>
            <td>＆nbsp;${row[1]}</td>
            <td>＆nbsp;${row[2]}</td>
          </tr>
        </c:forEach>
      </table>

Example 2

<%@page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
      连接 MysqL 数据库
      <sql:setDataSource driver="com.MysqL.jdbc.Driver"
                         url="jdbc:MysqL://localhost:3306/db_testjstl"user="root"
                         password="111"/>
      <sql:query var="rs" sql="SELECT*FROM tb_user"/>
      <table width="300" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF"
             bordercolordark="#999999"bordercolorlight="#FFFFFF">
        <tr>
          <td align="center">＆nbsp;${rs.columnNames[0]}</td>
          <td align="center">＆nbsp;${rs.columnNames[1]}</td>
          <td align="center">＆nbsp;${rs.columnNames[2]}</td>
        </tr>
        <c:forEach items="${rs.rowsByIndex}" var="row">
          <tr>
            <td>＆nbsp;${row[0]}</td>
            <td>＆nbsp;${row[1]}</td>
            <td>＆nbsp;${row[2]}</td>
          </tr>
        </c:forEach>
      </table>

Example 3

<%@page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
  <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.sqlServerDriver"
    url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=db_testJSTL"
    user="sa" password="" var="conn"/>
  <sql:transaction dataSource="${conn}">
  <sql:query var="rs" sql="SELECT*FROM tb_user"/>

Typical application

<%@page pageEncoding="gbk" contentType="text/html;charset=GBK"%>
  <%@taglib prefix="sql" uri="/WEB-INF/sql.tld"%>
    <%@taglib prefix="c" uri="/WEB-INF/c.tld"%>
      <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.sqlServerDriver"
                         url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=db_JSDQ26"
                         user="sa"password=""/>
      <sql:query var="result" sql="select*from tb_goods" maxRows="6" startRow="4"/>
      <table width="400" border="1" cellpadding="0" cellspacing="0"
             bordercolor="white" bordercolordark="white" bordercolorlight="black">
        <tr align="center" bgcolor="cyan">
          <td width="80">${result.columnNames[1]}</td>
          <td width="300">${result.columnNames[2]}</td>
          <td width="50">${result.columnNames[3]}</td>
          <td width="50">${result.columnNames[4]}</td>
        </tr>
        <c:forEach items="${result.rowsByIndex}" var="row">
          <tr>
            <td>${row[1]}</td>
            <td>${row[2]}</td>
            <td>${row[3]}</td>
            <td>${row[4]}</td>
          </tr>
        </c:forEach>
      </table>