Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.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 :");
- ComboBox<String> cbxTables = setTableNames();
- gdpTwo.add(lblTables, 0, 0);
- gdpTwo.add(cbxTables, 1, 0);
- 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 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");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement