An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Spring JDBC Support

What you'll learn
What is JDBC - Java Database Connectivity
What is the difference between regular Java JDBC and Spring JDBC
What is a JDBC Connection and an overview of the different types
How to set up a JDBC Datasource Connection
How to use the Spring JDBC Template to access a relational database
Understand JNDI and defining a DB Connection
Use Spring Boot to put together an Embedded Tomcat JDBC CRUD Application

Requirements
Be familiar with Java Software Development
Be familiar with modern Java IDE's such as IntelliJ
Be familiar with the concept of a Relational Database
A basic understanding of the Maven build tool
A basic understanding of Git source control and how to use Github

Description
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

Connecting to the MariaDB

Using JNDI DataSource Objects to Get a Connection

Registering DataSource Object with Naming Service That Uses JNDI API

Creating Instance of DataSource Class and Setting its Properties

Using Deployed DataSource Object

Connecting to the MariaDB

Using JNDI to Get a JDBC Connection in Embedded Tomcat

Java Main Method to launch Embedded Tomcat

Registering DataSource Object with JNDI API

Using the registered JNDI DataSource Object

Running the JAR with Maven Plugin

Connecting to the MariaDB

Using Spring App Context to Get a JDBC Connection Tomcat

Java Main Method to launch Embedded Tomcat

Defining the DataSource in Spring application.xml

Adding a context listener to web.xml

Retrieve the Spring Data Source bean in the Servlet

Connecting to the MariaDB

Using Spring Annotation Config in Embedded Tomcat

Java Main Method to launch Embedded Tomcat

Defining the DataSource in Spring Config Class

Retrieve the Spring DataSource bean in the Servlet

Who this course is for
Java Developers who have to write code to access a relational database
Java Developers who want to use Spring JDBC for streamlining database access to a relational database

Welcome to My Blog - Check it Every Days
If you have any troubles with downloading, PM me
Please Buy Premium Account from my links to get high download speed and support me
Happy Learning!!