Your task is to create a Book entity class and BookDao repository interface, and it's implementation.

Here are the steps you need to do in this HW:

• Establish connection to your Database. Be sure you have installed DB and you are able to create a new schema for this task.
• Create init_db.sql file in src/main/resources folder. In this file, put the scripts for creating required table.
• Create Book model.
• Create DAO layer for Book model. Below you can see the list of required methods.
• You're already given an injector and @Dao annotation. Do not forget to use it for Dao implementations.
• Return Optional when you can return null in DAO. For example: public Optional<Book> findById(Long id);
• In the main method call all CRUD methods. It may look like:

public class Main {
    private static final Injector injector = Injector.getInstance("YOUR_PACKAGE");

    public static void main(String[] args) {
        BookDao bookDao = (BookDao) injector.getInstance(BookDao.class);
        Book book = new Book();
        // initialize field values using setters or constructor
        BookDao.create(book);
        // test other methods from BookDao
    }
}

WARNING!!! Path to your project must contain only english letters. Also, it mustn't contain spaces. In other case Injector won't work correctly.

• Your table should be named books and contain these columns: id, title, price.

• Book

import java.math.BigDecimal;

public class Book {
  private Long id;
  private String title;
  private BigDecimal price;
}

- Book create(Book book);
- Optional<Book> findById(Long id);
- List<Book> findAll();
- Book update(Book book);
- boolean deleteById(Long id);

e.printStackTrace() - is a bad practice! Let's create custom exception DataProcessingException and constructor with two parameters: String message and Throwable ex.
It should be extended from RuntimeException. You should rethrow this exception in catch block on dao layer.

If you can't connect to your db because of this error:
The server time zone value ‘EEST’ is unrecognized or represents more than one time zone.
Try to set timezone explicitly in your connection URL.
Example:
...localhost:3306/your_schema?serverTimezone=UTC
Or you can set a timezone in MySql directly by running command: SET GLOBAL time_zone = '+3:00';

You can check yourself using this checklist