1- Repeat the idea of Class Task 3 using the Books Json file found here. However, run it as a standalone Java application only, not on a device. Note, you will have to create a Book class with the following instance variables: id, title, authors, price, to read and parse the books json file. Different to Class Task 3, display the books and the total cost of the books in Java Console. The id instance variable is required for the next part.
2- Create the class HibernateBookManager.java that can read, write and update books into a MySQL database named library. In addition, include behaviours that can retrieve a Book based on its title, a list of books that are less than a given price, and one that returns an int indicating the number of books in the database. Test your HibernateBookManager and Book classes using JUnit and a HibernateBookManagerTestCase class.
3- Submit your project in a zip file.