JSP SQL Tag

JSTL?s database library supports database queries and transactions.

JSP SQL Tag

JSP SQL Tag

        

In this section you will learn how to use the jstl sql tag in jsp. 

JSTL?s database library supports database queries and transactions. JSP pages can import this library with the following directive:
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
You can see in the given example that in order to connect the jsp page to the database, we have used the jstl tag <sql:setDataSource> whose attributes are:
driver- Here you have to put the JDBC driver 
url- JDBC url for the database connection including database name
user-
the database username
password-
the database password

Understand with Example

The Tutorial illustrate an example from JSP SQL Tag. To understand the example we will show you to use jstl tag in jsp. The code consists of taglib directive that allow the jsp page to import  the library with the directive <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>. The example allow the jsp page to connect  to the database using <sql:setDataSource> specified with the given attribute. The attribute include name of the driver, url, user and password required to connect the database. The JSTL can read the data from the database using the tag <sql:query>. The code return the records from register table and print the corresponding values into your browser. 

c:out value="${}: The JSTL tag is used to print the fetched records from a table in the browser.

Here is the code of sql.jsp

<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
<sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://
   localhost:3306/register" user="root" password="root"/>
<html>
<body>
<sql:query var = "user" >
Select user_id,firstName,lastName,userName,email from registerTable
</sql:query>

<table border=1>
<c:forEach var="row" items="${user.rows}">
<tr>
<td><c:out value="${row.user_id}"/></td>
<td><c:out value="${row.firstName}"/></td>
<td><c:out value="${row.lastName}"/></td>
<td><c:out value="${row.userName}"/></td>
<td><c:out value="${row.email}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>

Output will be displayed as:

Download Source Code: