I have some problems but I dont know how to modify Question

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.

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javafx.event.ActionEvent;

import javafx.fxml.FXML;

import javafx.scene.control.Button;

import javafx.scene.control.TextArea;

import javafx.scene.control.TextField;

import java.sql.*;

public class SubmitController {

@FXML

private TextArea tArea;

@FXML

private TextField city;

@FXML

private Button display;

@FXML

void Display(ActionEvent event) {

String cityName = city.getText();

try {

Class.forName("oracle.jdbc.OracleDriver");

Connection c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:orcl11", "sys as SYSDBA", "qweqweqwe");

Statement st = c.createStatement();

ResultSet rs = st.executeQuery("select * from students where city = '"+cityName+"'");

StringBuilder sb = new StringBuilder();

sb.append("Student ID");

sb.append("\t");

sb.append("First Name");

sb.append("\t");

sb.append("Last Name");

sb.append("\t");

sb.append("Address");

sb.append("\t");

sb.append("City");

sb.append("\t");

sb.append("Province");

sb.append("\t");

sb.append("PostalCode");

sb.append(" ");

sb.append("-----------------------------------------------------------------");

sb.append(" ");

while(rs.next()){

String id = rs.getString("studentid");

String fname = rs.getString("firstName");

String lname = rs.getString("lastName");

String adr = rs.getString("address");

String city = rs.getString("city");

String pro = rs.getString("province");

String pos = rs.getString("postalCode");

//System.out.println(id+"\t"+fname+"\t"+lname+"\t"+adr+"\t"+city+"\t"+pro+"\t"+pos);

sb.append(id);

sb.append("\t");

sb.append(fname);

sb.append("\t");

sb.append(lname);

sb.append("\t");

sb.append(adr);

sb.append("\t");

sb.append(city);

sb.append("\t");

sb.append(pro);

sb.append("\t");

sb.append(pos);

sb.append(" ");

}

//System.out.println(sb);

//tArea.setText(sb);

tArea.setText(String.valueOf(sb));

st.close();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}catch(SQLException e1) {

e1.printStackTrace();

}

}

}

----------------------------------------------------------------

import javafx.application.Application;

import javafx.fxml.FXMLLoader;

import javafx.scene.Scene;

import javafx.stage.Stage;

public class MyJavaFX extends Application {

@Override

public void start(Stage primaryStage) throws Exception {

// TODO Auto-generated method stub

Scene sc = new Scene(FXMLLoader.load(getClass().getResource("TestFall.fxml")));

primaryStage.setScene(sc);

primaryStage.show();

}

public static void main(String[] args) {

launch(args);

}

}

- 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. > MyJavaFX.java SubmitController.java TestFall.fxml