Dinesh on Java

Categories: JSTL

JSTL SQL SetDataSource<sql:setDataSource> Example

JSTL setDataSource Tag provides capability to create a datasource directly from JSP and it can be stored in a variable to use later with the help of scope attribute.

Syntax-
<sql:setDataSource

var=”<string>”

scope=”<string>”

dataSource=”<string>”

driver=”<string>”

url=”<string>”

user=”<string>”

password=”<string>”/>

JSP <sql:setDataSource> Tag has following attributes.

1. driver Attribute: Specifies the driver to connect database. For each database there is a separate driver. In this example, we are connecting to MySQL database and hence driver is com.mysql.jdbc.Driver

2. url Attribute: Specifies the location of the database.

3. var Attribute: Specifies the variable which holds the dataSource once it is created.

4. user Attribute: Specifies the user you already created to access database.

5. password Attribute: Specifies the password for the user you already assigned to access database.

JSP setDataSource Example:

Consider the following information about your MySQL database setup:

We are using JDBC MySQL driver.
We are going to connect to TEST database on local machine.
We would use user_id and mypassword to access TEST database.

All the above parameters would vary based on your MySQL or any other database setup. Keeping above parameters in mind, following is a simple example to use setDataSource tag:

<%@ 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}" 
            sql="SELECT * FROM employee WHERE salary > 10000" 
            var="result" />
 
</body>
</html>

As shown above setDataSource Tag set data source in a variable localSource. Using this data source, you can do SQL operations directly from JSP.

<<Previous << || Index || >>Next >>

Dinesh Rajput

Dinesh Rajput is the chief editor of a website Dineshonjava, a technical blog dedicated to the Spring and Java technologies. It has a series of articles related to Java technologies. Dinesh has been a Spring enthusiast since 2008 and is a Pivotal Certified Spring Professional, an author of a book Spring 5 Design Pattern, and a blogger. He has more than 10 years of experience with different aspects of Spring and Java design and development. His core expertise lies in the latest version of Spring Framework, Spring Boot, Spring Security, creating REST APIs, Microservice Architecture, Reactive Pattern, Spring AOP, Design Patterns, Struts, Hibernate, Web Services, Spring Batch, Cassandra, MongoDB, and Web Application Design and Architecture. He is currently working as a technology manager at a leading product and web development company. He worked as a developer and tech lead at the Bennett, Coleman & Co. Ltd and was the first developer in his previous company, Paytm. Dinesh is passionate about the latest Java technologies and loves to write technical blogs related to it. He is a very active member of the Java and Spring community on different forums. When it comes to the Spring Framework and Java, Dinesh tops the list!