Create Product entity in model and prepare REST controller to display all products from DB

[caroo7]

As a result of this task we want to give possibility to get all products from DB and show them in browser as a JSON file.

Steps:

• PostgreSQL database should be installed and setup -> https://www.postgresql.org/download/windows/
• connect DB with Spring Boot, here are some tips (Configuration section in this link) -> https://dzone.com/articles/spring-boot-and-postgresql,
• create Product entity and prepare sql file with table definition and some inserts. It should automatically populate DB during application startup -> https://www.baeldung.com/spring-boot-data-sql-and-schema-sql (first 4 steps),
• create proper Repository and REST Controller -> https://dzone.com/articles/spring-boot-and-postgresql,
• test if results will be shown when you hit http://localhost:8080/products in the browser

[caroo7]

In order to be able to provide solution please read about:

• REST protocol (get, put, post, delete methods),
• Spring REST controllers,
• JPA/CRUD repository from SpringData and how it generates method which can operate on DB,
• Spring Autowire annotation - what it does in Spring?