Home    Tutorials    Database Design & Development    An introduction to JDBC, JNDI and Spring JDBC with Tomcat

An introduction to JDBC, JNDI and Spring JDBC with Tomcat

 Admin0,

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.

An introduction to JDBC, JNDI and Spring JDBC with Tomcat

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

 

 

Get Tutorial