Spring JDBC Support
Data Access with Spring JDBC Support using JNDI in an embedded Tomcat Server .
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.
Course Content
- Introduction –> 3 lectures • 8min.
- Our JDBC Development Environment –> 12 lectures • 45min.
- Connecting to the Database –> 6 lectures • 1hr 2min.
- Comparing traditional JDBC with Spring JDBC –> 6 lectures • 1hr 35min.
- Closing Section –> 1 lecture • 1min.
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.
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