Use javaFx

The user should be able to enter the city. The application should retrieve the student information from an Oracle table named Student. Here is the definition of the table:

CREATE TABLE Students (

studentID char(9) NOT NULL,

firstName varchar (20) NOT NULL,

lastName varchar (20) NOT NULL,

address varchar (30) NOT NULL,

city varchar(30) NOT NULL,

province char(2) NOT NULL,

postalCode char(6) NOT NULL,

PRIMARY KEY (studentID)

);

Populate the table with several rows as below:

insert into Students values('300111222','Sam', 'Malone', '10 Somewhere Road', 'Toronto','ON','M1Y2H2');

commit;

The information should be displayed in a JTextArea component which has scrolling abilities. Use \t and to format the display.

Use the most appropriate layout manager classes to implement the layout of this GUI.

- Student Info Select students by city: Toronto Display 300111222 300233444 300111777 300223444 300444222 SARA Elsa Laura Elsa Robert Malone Orange Brown Red Smith 10 Somewhere Road 222 Progress Avenue 333 Eglinton Avenue East 222 Progress Avenue 20 Green Avenue Toronto Toronto Toronto Toronto Toronto ON ON ON ON ON M1Y2H M3T5Y M3T7Y7 M3T5Y3 M5G3H