JakartaJEEWebDevelopment

Jakarta JEE8 Enterprise Web Development

View on GitHub

Using the Database Tag Library

The SQL library contains elements that provides transactional access to database.

The SQL library taglib directive:

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

Using the SQL database actions violates the Model View Controller pattern underlying most modern Java Web Applications and are also considered a high level security risk. Therefore we will not be presenting any examples but we will do an overview since the chances are good that you might run into it in old code that you need to maintain.

#SQL Actions: sql tag library

Data Source

Querying a Database

Updating a Database

SQL Statement Parameters

Database Access

SQL Query

SQL Update

SQL Transaction

SQL Param

SQL Date Param

Configuration Settings