Basic Core Java JDBC Programs Assignment

Assignment Task

Problem Statement

Implement a standalone product search program in Java using JDBC that lists matching products for a user who is looking for T-shirts. You are given 3 CSV files, each containing the T-shirts data for Nike, Puma, and Adidas respectively. Sample CSV files links are attached here for reference. You can add more data in existing files or can add more CSV files for another company.

The program should accept 4 input parameters

a. Color: String which holds the color of T-shirt.

b. Size: String which can have five possible values like S, M, L, XL, XXL.

c. Gender: String which has two possible values like ‘M’ and ‘F’. M=Male and F=Female

d. Output Preference: String which suggests whether the results should be sorted only by Price or by Rating or by both Price and Rating

Expected Behavior and Output

• After getting the inputs, the program should search for the T-shirts in the database.
• When the program starts, read all the CSV files, and insert records to database. If the record exists in database, then update it else insert a new record. (For this point, consider the server is started).
• Program should display the list of available T-shirts with details(a complete record) sorted as per Output Preference.
• Program should be written considering that there could be more csv files and at runtime program should load the files. Please make use of Thread which will look for any new file at a particular configurable location after some configurable time and load the provided files. (For this point, new files are added, or existing files are updated while the server is up).
• If the suitable T-shirt is not present, then program should return a user-friendly error.
• Use available 3rd party dependencies to read and parse CSV files.
• Use the new features of Java wherever possible.

This IT and Computer Science has been solved by our PHD Experts at My Uni Paper.