Tutorialspoint

An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Spring JDBC Support

Course 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

Goals

  • What is JDBC - Java Database Connectivity
  • What is the difference between Java direct 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


Prerequisites

  • 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
Show More

Curriculum

Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
An introduction to JDBC, JNDI and Spring JDBC with Tomcat
This Course Includes
  • 3.5 hours
  • 27 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate