For this assignment, you will need to create a Netbeans project using spring initializer $($with the

appropriate dependencies$).$ For this database assignment, assume that I will$/$have created a mysql database. You will need to perform this work using Spring Boot and either JPA $($preferred$)$ or JBDC$.$Part I: GET endpoints

$(20\%)$ Get all products $($optional category path variable$)$

a$.$ If category is present, return all products with the given category

b$.$ If not, return all products

$(10\%)$ Get product with given SKU $($path variable$)$

a$.$ If the product with the given sku exists, return it

b$.$ Otherwise, return $404$

$(10\%)$ Get the number of products given a category $($path variable$)$

a$.$ If the category exists, return the number

b$.$ Otherwise, return $404$

$(10\%)$ Get the products in a given price range $($path variables$)$

a$.$ Return a list of the products using the upper and lower bounds of the price range given.

b$.$ Note: price range should be given using upper and lower bounds.

$(10\%)$ Get the products that match a given search string $($path variable$)$

a$.$ Return a list of the products that match a search string

b$.$ Note: You should look at name & description to determine if the search string is

contained within.

Part II: POST endpoints

$(10\%)$ Add a product

a$.$ No duplicates allowed

b$.$ Report with product if $OK,$ conflict otherwise

Part III: PUT endpoints

$(10\%)$ Update a product

a$.$ If the product exists, update it

b$.$ Else, add the product

Part IV: DELETE endpoints

$(5\%)$ Delete product with given sku $($path variable$)$

a$.$ Report with product if $OK,404$ otherwise

Part V: Error Handling

$(5\%)$ Include appropriate exception and error handling