- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Which library can be used to interact with database in JSP?
The JSTL SQL tag library provides tags for interacting with relational databases (RDBMSs) such as Oracle, MySQL, or Microsoft SQL Server.
Following is the syntax to include JSTL SQL library in your JSP −
<%@ taglib prefix = "sql" uri = "http://java.sun.com/jsp/jstl/sql" %>
Following table lists out the SQL JSTL Tags −
S.No. | Tag & Description |
---|---|
1 | <sql:setDataSource>Creates a simple DataSource suitable only for prototyping |
2 | <sql:query>Executes the SQL query defined in its body or through the sql attribute. |
3 | <sql:update>Executes the SQL update defined in its body or through the sql attribute. |
4 | <sql:param>Sets a parameter in an SQL statement to the specified value. |
5 | <sql:dateParam>Sets a parameter in an SQL statement to the specified java.util.Date value. |
6 | <sql:transaction >Provides nested database action elements with a shared Connection, set up to execute all statements as one transaction. |
- Related Articles
- Which methods can be used to read HTTP header in your JSP program.
- How can Bokeh library be used to generate line graphs in Python?
- How can Bokeh library be used to visualize twin axes in Python?
- How can scikit-learn library be used to load data in Python?
- How can Seaborn library be used to visualize point plots in Python?
- How can FacetGrid be used to visualize data in Python Seaborn Library?
- How can scikit learn library be used to preprocess data in Python?
- How can bar plot be used in Seaborn library in Python?
- How can Bokeh library be used to visualize stacked bar charts in Python?
- How can Seaborn library be used to display kernel density estimations in Python?
- How can the countplot be used to visualize data in Python Seaborn Library?
- How can Seaborn library be used to display a hexbin plot in Python?
- How can Seaborn library be used to display categorical scatter plots in Python?
- How can Seaborn library be used to display a Scatter Plot in Python?
- Which function should be used to load a package in R, require or library?

Advertisements