This project employs Spring Boot and Spring Data JPA to demonstrate how to successfully read and execute a SQL statement by key from a properties file.

• Java JDK 1.8u141
• Gradle 4.1

gradle test

The build.gradle file includes the maven-publish plugin which allows you to execute

gradle publishToMavenLocal

This will publish the artifact and a POM file to your .m2/repository directory in a {groupId}/{artifactId}/{version} sub-directory.

This project employs Lombok so we can annotate instead of writing what amounts to boilerplate code.

We annotate CourseQueries with ConfigurationProperties to encapsulate a namespace of sql.course queries found in application.yml

We define CourseRepository and have it extend the CrudRepository interface. We also define an additional query method using conventions.

We implement CourseService to demonstrate how to employ a JdbcTemplate to execute a query

Finally we author a unit test for the aformentioned service. (Spring Boot Test is helpful).

An in-memory database is initialized on startup.

• Sayem Ahmed for AttributeConverter used to convert LocalDateTime