How to set the data source in a JSP?

JSP Java 8 Object Oriented Programming Programming

The <sql:setDataSource> tag sets the data source configuration variable or saves the data-source information in a scoped variable that can be used as input to the other JSTL database actions.

Attribute

The <sql:setDataSource> tag has the following attributes −

Attribute	Description	Required	Default
driver	Name of the JDBC driver class to be registered	No	None
url	JDBC URL for the database connection	No	None
user	Database username	No	None
password	Database password	No	None
password	Database password	No	None
dataSource	Database prepared in advance	No	None
var	Name of the variable to represent the database	No	Set default
scope	Scope of the variable to represent the database	No	Page

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 my password to access TEST database.

All the above parameters will vary based on your MySQL or any other database setup. Considering the above parameters, the following example uses the setDataSource tag −

<%@ taglib uri = "http://java.sun.com/jsp/jstl/core" prefix = "c" %>
<%@ taglib uri = "http://java.sun.com/jsp/jstl/sql" prefix = "sql"%>
<html>
   <head>
      <title>JSTL sql:setDataSource Tag</title>
   </head>
   <body>
      <sql:setDataSource var = "snapshot" driver = "com.mysql.jdbc.Driver" url = "jdbc:mysql://localhost/TEST" user = "user_id" password = "mypassword"/>
      <sql:query dataSource = "${snapshot}" sql = "..." var = "result" />
   </body>
</html>

We will use <sql:setDataSource> in subsequent SQL tags.