What You Will 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
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 Should Attend!
- 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
