Tutorialspoint

An introduction to JDBC, JNDI and Spring JDBC with Tomcat

Spring JDBC Support

  Nicolaas C Kock

   Spring Framework, Java Technologies, Databases

  Language - English

   Published on 01/2022

0

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

What Will I Get ?

  • 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


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
0
Course Rating
0%
0%
0%
0%
0%

    Feedbacks (0)

  • No Feedbacks Yet..!
An introduction to JDBC, JNDI and Spring JDBC with Tomcat
This Course Includes :

3.5 hours

27 Lectures

Lifetime Access

30-Days Money Back Guarantee

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.