An introduction to JDBC, JNDI and Spring JDBC with Tomcat

An introduction to JDBC, JNDI and Spring JDBC with Tomcat free download

Spring JDBC Support

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