Create a new service JDBC implementation for your Library application. Modify your Factory so that it’s decoupled from the services it creates. Create a unit test for the JDBC impl using JUnit.
Library Application JDBC:
Task Description: Create a new service JDBC implementation for your Library application. Modify your Factory so that it’s decoupled from the services it creates.
You need add only one book to the database and it has an isbn and one author (optionally multiple authors).
You need to add IService marker interface.
Only a store method is required (and tested).
In BookSvcJDBCImpl connString name your library yournamelibrary. This means that student, Jane Doe, would name her library: doelibrary.
Below is supplemental information for doing these tasks for this week:
Code JDBC application.
Create and save a properties file.
Download and install (and possibly run a tutorial) for MySQL or MySQL Workbench.
Download and add the Connector/J.
Use two command line interfaces: DOS/MAC command line and MySQL Command Line Client.
Create MySQL database and table and possibly view its schema.
Run the BookSvcJDBCImplTest/JUnit test.
Dump your data to an sql file.
Deliver your application and the sql file.