You are assigned the task of developing a program to help lectures to add students into the system. Create a Java

program that takes three fields as input from the user through a Graphical User Interface $($GUI$).$ The program

should allow the user to add the id$,$ name, and phone number of the student. Implement the GUI using Java Swing

or JavaFX. Below are the detailed requirements:

Design a GUI with three text fields for user input $($ID$,$ Name, Mobile$),$ each accompanied by a label.

Include four buttons below the input fields for the functionalities: Add, View, Search, and Delete records.

Ensure the GUI is user$-$friendly, with clear instructions, appropriate labels, and a coherent layout. After You have successfully completed setting up your GUI! Now, it's time to integrate it with a MySQL database. Write a

program to establish a connection between your Java GUI and a MySQL database.

Deliverables:

Establish a successful DB connection.

Close the database connection after executing database operations.

Implement exception handling to address database$-$related errors, such as connectioNow that you've successfully integrated your database with your GUI, it is essential to test the connection between

your frontend and backend. Write the program to thoroughly test both components, ensuring seamless interaction

between the user interface and the database operations.

All data pulled from the database, should be stored using the appropriate data format that allows easy access and

retrieval to keep the records. Use your knowledge of collections to select the appropriate data format.

The test should include the following steps and validations: Student Manager

ID:

Name:

Mobile:

Add

E$.$g Adding a user to the DB

E$.$g Viewing Stud users

E$.$g Deleting a user on the DB

E$.$g Mobile no$.$ Validation