Java IV Spring JDBC Lab

Completing this lab demonstrates your ability to code interact with the database using the Spring Java Database Connectivity (JDBC) template.

Objective

Implement all methods in BookShopRepository so that all tests in BookShopRepositoryTests pass. As noted in the lecture videos, there are lots of ways to make it work but simple is better and less code is better

Getting Started:

1. Copy the starter code from here into a new, private repository in your personal GitHub account using these instructions substituting this repository URL https://github.com/jeff-anderson-cscc/java4-labs-spring-jdbc.git for the one referenced in that document
2. Create a new branch for your code changes as described in these instructions

Completing the Assignment

Important You may not change the code in any test cases. The only permissible difference between the base version of the JUnit test class and yours is yours will have no tests commented out and the file is otherwise identical.

1. Open BookShopRepositoryTests
2. For each test, add just enough code in BookShopRepository to make the test pass
3. Once all tests are passing, commit your changes

Hint: Notice the import statements in BookShopRepository. I left a few initially unused imports in there to guide your solution

Helpful Documentation

• 3.3.5. Running Queries
• 3.3.6. Updating the Database

Submitting Your Work

1. Create a pull request for your branch using these instructions
2. Submit the assignment in Blackboard as described in these instructions

NOTE: I will provide feedback via. comments in your pull request. If you need to amend your work after you issue your initial pull request:

1. Commit your updates
2. Push your changes to gitHub
3. Verify the new commits were automatically added to your open pull request