Spring 5.0 Projects

Defining the data access layer – Spring JDBC Template

We have the model classes that reflect the structure of the data in the database that we obtained from the World Bank API. Now we need to develop a data access layer that interacts with our MySQL and populates the data stored in the database into instances of the model classes. We will use the Spring JDBC Template to achieve the required interaction with the database.

First, we need the JDBC driver to connect any Java application with MySQL. This can be obtained by adding the following dependency and version property to our pom.xml:

    <properties>        <java.version>1.8</java.version>        <lombok.version>1.16.18</lombok.version> <hibernate.validator.version>6.0.2.Final</hibernate.validator.version> ...