Java

Using the derby database and JFoenix UI library, create a project that manages students.

Requirements

1. Create a new Student database if it doesn't exist yet with the click of a button

2. Create a second button that populates the database with the appropriate Student table if it does not exist yet, and fill the table with at least 10 students.

3. Connect to the Student Database and display all current students in a List by default. You will have to create a Student Class. This class needs at a minimum the following attributes: Name, Id, Age, Major, GPA. Use appropriate data types. (use UUID for the Id property)

4. Next to the list displaying the students, create at least three ways to filter that list. For instance, you only want to display students over the age of 30. Or only students who have the Major Biology. Or only students with GPA below 2.0. Be creative in which filters would make real sense and use appropriate JFoeniX controls for them. Make sure the controls you use send the appropriate SQL Query to the database and display the results in the student list view