ActorMovieJDBCGrigus

Bobocode exercise project.

Implement a persistence layer using JDBC API for a simple Actor-Movie application.

 

1. Create a new empty maven project
2. Add all required dependencies
3. Create class Actor (id, first name, last name, birthday)
4. Create class Movie (id, name, duration, release date)
5. Design a database, and implement a corresponding SQL script to create all required tables. Please note that database should be able to store the many to many relation between actors and movies
6. Create ActorDao and implement methods that allow to:
1. save new actor
2. find actor by id
3. link actor to some movie by actor and movie ids
7. Create MovieDao and implement methods that allow to:
1. save new movie
2. find all movies
3. search movie by name
4. search movies by actor first and last name
8. Push your project to github