JDBC11SpringJdbcDaoSupportTrx.md

Updating the database with a more rigorous relationship entity model part 2.

Using a DAO with Spring JdbcDaoSupport to be able to do full range of CRUD with transactions that can be rolled back.

(This is a build out of JDBC10SpringJdbcDaoSupportTransactions)

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

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

ArtifactId : JDBC11JdbcDaoSupportTrx

2 Create package com.nicordesigns

3 Update the generated Maven POM.XML files where required

We will use JDBC10SpringJdbcDaoSupportTransactions 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 will introduce a one to one mapping between Charity and Category.

Add a one to many relationship between Charity and Program

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

For the Implementation of the DAO we will use the Spring JDBC Template for Charities and use the 
Spring Transaction Manager tom manage updating the relationship tables in the database

We will create a working Create, Read, Update and Delete functionality accross the full object graph
of the Charity Table and Object Model

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

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

We use the Spring  ClassPathXmlApplicationContext to obtain the conext and the Spring Data Source bean
We will also now get the DAO bean from the bean.xml file

We test the DAO Implementation Object in the Main method

Here we will test the full CRUD capability

6 Run the App main method

First clear out the DB Charity Table in such a way that we do have FK relations and tables set up.
Run the Main method.
Demo Step 1 : Update and retrieve a Charity from the DB with one to one Category relationship
              (Here we start implementing Foreign Keys in the Category_Charity Relationship Table

Demo Step 2 : Update the Charity with a different list of Programs following the logic in Step 1
              (Clear out the DB Tables first and then add foreign keys to charity_category and charity_program relationship tables)

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