Update

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javafx.application.Application;
import javafx.beans.Observable;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.geometry.Insets;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ComboBox;
import javafx.scene.control.Label;
import javafx.scene.control.ListView;
import javafx.scene.control.PasswordField;
import javafx.scene.control.SelectionMode;
import javafx.scene.control.TextField;
import javafx.scene.input.MouseEvent;
import javafx.scene.layout.GridPane;
import javafx.stage.Stage;

public class Homework5Herman extends Application{

	Scene scene1, scene2, scene3;
	Stage window;
	Connection connection;

	public static void main(String[] args) {
		launch(args);
	}

	@Override
	public void start(Stage primaryStage) {
		window = primaryStage;

		loginScreen();
	}

	public void loginScreen() {
		GridPane gdpOne = createGridPane();

		Label lblUsername = new Label("Username :");
		TextField txtUsername = new TextField("ddherman");
		Label lblPassword = new Label("Password :");
		PasswordField pwfPassword = new PasswordField();
		pwfPassword.setText("ddhermancis357d");
		Button btnConnect = new Button("Connect");
		btnConnect.setOnMouseClicked(e -> clickedConnect(e, txtUsername, pwfPassword));

		gdpOne.add(lblUsername, 0, 0);
		gdpOne.add(txtUsername, 1, 0);
		gdpOne.add(lblPassword, 0, 1);
		gdpOne.add(pwfPassword, 1, 1);
		gdpOne.add(btnConnect, 1, 2);

		scene1 = new Scene(gdpOne);
		window.setTitle("HW 5 DB");
		window.setScene(scene1);
		window.show();
	}

	public void inputScreen() throws SQLException {
	//Create nextWindow
		GridPane gdpTwo = createGridPane();

		Label lblTables = new Label("Table :");
		Label lblFields = new Label("Fields :");
		ComboBox<String> cbxTables = setTableNames();
		ListView<String> lstView = new ListView<>();

		gdpTwo.add(lblTables, 0, 0);
		gdpTwo.add(cbxTables, 1, 0);
		gdpTwo.add(lblFields, 0, 1);
		gdpTwo.add(lstView, 1, 1);

		cbxTables.getSelectionModel().selectedItemProperty().addListener((observable, oldValue, newValue) -> {
			String selectedTable = cbxTables.getValue().toString();
			try {
				lstView.getItems().clear();
				lstView.setItems(getListView(selectedTable));
				lstView.getSelectionModel().setSelectionMode(SelectionMode.MULTIPLE);
				//gdpTwo.add(lstView, 1, 1);
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		});

		scene2 = new Scene(gdpTwo);
		window.setScene(scene2);
	}

	public void clickedConnect(MouseEvent e, TextField usrname, PasswordField password) {
		//Load the driver
		loadDriver();

		//Establish the connection
		try {
		  connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:1111/ddherman" ,
					usrname.getText(), password.getText());
			System.out.println("Connection successful");

			inputScreen();
		} catch (SQLException e1) {
			System.out.println("Failed to connect");
		}
	}

	public ComboBox<String> setTableNames() throws SQLException {
		ComboBox<String> cbx = new ComboBox<>();
		ObservableList<String> tableNames = FXCollections.observableArrayList();

		DatabaseMetaData dbmd = connection.getMetaData();
		ResultSet rs = dbmd.getTables(null, null, "%", null);

		while (rs.next()) {
			String tableName = rs.getString(3);

			tableNames.add(tableName);
		}

		cbx.setItems(tableNames);

		return cbx;
	}

	public ObservableList<String> getListView(String table) throws SQLException {

		ObservableList<String> columnNames = FXCollections.observableArrayList();
		Statement statement = connection.createStatement();
		ResultSet rs = statement.executeQuery("SELECT DISTINCT COLUMN NAME" +
				" FROM INFORMATION SCHEMA.COLUMNS" +
				" WHERE TABLE_NAME = '" + table + "'");

		while (rs.next()) {
			columnNames.add(rs.getString("COLUMN_NAME"));
		}

		return columnNames;
	}

	public GridPane createGridPane() {
		GridPane gridPane = new GridPane();
		gridPane.setPadding(new Insets(10, 10, 10, 10));
		gridPane.setVgap(8);
		gridPane.setHgap(8);

		return gridPane;
	}

	public void loadDriver() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Driver Loaded");
		} catch (ClassNotFoundException e1) {
			System.out.println("Driver failed to load");
		}
	}
}