JSTL SQL Tags

In JSTL, SQL tags are used to access and manipulate various operations of database. It is responsible to interact the JSP page with any type of Database such as MySQL, Oracle, SQLite, etc. The below syntax is used to include SQL library within JSP: -

<%@ taglib prefix = "sql" uri = "http://java.sun.com/jsp/jstl/sql" %>

SQL Tags

These are some important JSTL SQL tags: -

• : - This tag creates a DataSource to  communicate JSP with database server.
• : - This tag executes the SQL query that is specified with it.
• : - This tag performs various database action with single connection.
• : - This tag provides parameter to SQL statement.
• :  - This tag provides date in the form of parameter to SQL statement.
• : - This tag is used to update the value in database.

Example of JSTL SQL Tag

This is a simple example of JSTL SQL Tag that fetches data from MYSQL.

index.jsp

<%@ page import="java.io.*,java.util.*,java.sql.*"%> 
<%@ page import="javax.servlet.http.*,javax.servlet.*" %> 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> 
        SELECT * from admin;                                

Student ID	Password	U Id

Output: