Task For Backend Developer – Java

Make a page that displays a list of movies.  The page should have the following features

• Create a list view of movies with pagination after 10 movies. For pagination follow this approach. AJAX / Page Refresh  – your choice. The arrows need to be on both sides like in the image below

• Filter by language
• Filter by Genre
• Sort by Length
• Sort by release date
• Filter and sort need to work together. 
• Also, sort, filter, and pagination need to be server side. No client-side scripting.  
• Filter and sort should continue to work when I change page. For example, refer http://www.shortfilmwindow.com/movies/

Task to be done in JAVA and MySQL. It will be nice to see the following in the task 

• Servlet
• JSP
• JDBC with MySQL
• JavaBean
• DAOs

Below is the database/table structure to be used. Populate it with dummy data

Table structures:

• Movies
  • id
  • Title
  • Description
  • Featured image
  • Movie length (in minutes)
  • Movie release date

Example:
1 | Jurassic World | A movie about dinosaurs | 90 minutes | June 14 2015
2 | Kick | Salman Khan movie | 120 minutes | April 2014

———————————————————————————————————-

• Category
  • id
  • Type
  • Value

Example:
1 | Language | English
2 | Genre | Action
3 | Language | Hindi
4 | Genre | Comedy

———————————————————————————————————-

• Relationship
  • id
  • Category id
  • Movie id

Example:
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 2 | 4

———————————————————————————————————-

Share the code as a link to a GitHub repository. Please complete this task before 22nd August 2021.