Example Maven JDBC Project

Task:

Create a Java Maven Project that uses JDBC to store and retrieve data from a database. Example data is provided in the data.json. Implement an integration test for the data retrieval.

Result:

• Created a mysql database iosb_db with the schema depicted below.
• Stored data in the database using jackson-databind and mysql-connector-java.
• Implemented data retrieval with user input.
• Implemented integration tests for data retrieval using junit-jupiter.