JSTL Query Tag provides capability to fetch the data from databased by executing query directly from JSP and it can be stored in a variable to use later with the help of scope attribute.
JSTL SQL Query Tag has following attributes.
JSTL SQL Query Tag has following attributes.
1. datasource Attribute: Specifies the datasource. Make sure that you already created datasource using serDataSource tag before writing query.
2. sql Attribute: Specifies the SQL statement to run on database.
3. var Attribute: Store the result of SQL statement.
Syntax-
<sql:query
var=”<string>”
scope=”<string>”
sql=”<string>”
dataSource=”<string>”
startRow=”<string>”
maxRows=”<string>”/>
JSP SQL <sql:query> tag Example:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/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=ISO-8859-1">
<title>JSTL SQL Tags - setDataSource Example</title>
</head>
<body>
<sql:setDataSource driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/database_name"
var="localSource"
user="database_user"
password="database_password"/>
<sql:query dataSource="${localSource}" var="result">
SELECT * from Employees;
</sql:query>
<table border="1" width="100%">
<tr>
<th>Emp ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
</tr>
<c:forEach var="row" items="${result.rows}">
<tr>
<td><c:out value="${row.id}"/></td>
<td><c:out value="${row.first}"/></td>
<td><c:out value="${row.last}"/></td>
<td><c:out value="${row.age}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
Now try to access above JSP, which should display the following result:
| Emp ID | First Name | Last Name | Age |
|---|---|---|---|
| 1111 | Dinesh | Rajput | 27 |
| 2222 | Sweety | Rajput | 24 |
