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:
