An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Data Access with Spring JDBC Support using JNDI in an embedded Tomcat Server .

Course Modules :

Course Introduction – JDBC History & Sample User Story

Our Spring JDBC Development Environment

Connecting to the Database

DAO with Traditional JDBC vs Spring JDBC

Full CRUD with Spring JDBC Template example

Why learn Spring JDBC ?

JDBC use is widespread in large companies worldwide

Actively maintained for 20+ years and counting

Spring JDBC gives you a “quick win” when dealing with legacy JDBC code

Spring JDBC – Sample User Story

As an expatriate living abroad I want access to an online database of all charities (non–profits) that operate in my “home country”.

I want to be able to find Charities by their Tax Id

I want to be able to search by Charity Category such as Environment or Education

I want to be able to search by Charity Program Types

Connecting to the MariaDB with JDBC

Establishing a Connection

Using the DriverManager Class

Specify the database Connection URLs

Connecting to the MariaDB with Spring:

Define Spring DataSource Bean to get a DB Connection

Specify the database properties in application.xml

Using the MariaDB DataSource Bean Class