JDBC9SpringJdbcDaoSupport.md

Using a DAO with Spring JdbcDaoSupport to insert a new Charity and retrieve the Charity from the database

(This is a build out of JDBC7RegularDao where we used JDBC Direct)

1 Using IntelliJ we create a new Java Maven Module (JDBC9JdbcDaoSupport)

File -> New Module -> Maven (No Archetype Selected)

ArtifactId : JDBC9JdbcDaoSupport

2 Create package com.nicordesigns

3 Update the generated Maven POM.XML files where required

We will use JDBC7RegularDao as a guide for setting up our Data Source

Add the mariadb-java-client to the POM

Add all the required Spring Framework dependencies for the Spring Context and DataSource bean

Update the Parent POM and global dependency version numbers

4 Create the Charity DAO Interface and Charity DAO Implementation class

First we create the Charity Model Object and its related Model Objects Category and Program For this run we won't be implementing the FK and relationships between the Models and in our Charity DB Table

Then we create the Charity DAO Interface and the Charity DAO Implementation

For the Implementation of the DAO we will extend from JdbcDaoSupport which allows us to use the SpringJDBC Template ( where we used JDBC Direct in JDBC7)

We will create a working insert Charity method and a working find Charity by TaxId method, which means all the DB Connection Handling will now be done by the SpringJDBCTemplate

Our methods will only work on the Charity Model Object for now and we won't be implementing the full object graph of the Charity

5 Create the Application with a Main Method that runs the insert and find methods

We define our Data Source in the Spring beans.xml file

We use the Spring ClassPathXmlApplicationContext to obtain the conext and the Spring Data Source bean

We create the DAO Implementation Object in the Main method

Then we first create a new Charity Object and insert it using the DAO and then we find the inserted Charity using the DAO

6 Run the App main method

First clear out the DB Charity Table in such a way that we do not have any FK relations and tables set up. Run the Main method.

1. We will demonstrate using JDBCTemplate Update method to insert the new Charity
2. We will demonstrate the use of a PreparedStatementCreator with the JDBCTemplate
3. We will demonstrate the use of an inline PreparedStatementCreator with the JDBCTemplate
4. We will demonstrate the use of an inline PreparedStatementCreator with PreparedStatementSetter in the JDBCTemplate

In IntelliJ -> Select Main -> Right Click -> Run Main:main -> Look at the Charity Table Entry --> Look at the Charity Object that was retrieved from the database Look at the Console Output and at the DB Charity Table