Advertisement
Guest User

DB Fucks me in my ass

a guest
Apr 10th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.49 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DatabaseMetaData;
  3. import java.sql.DriverManager;
  4. import java.sql.ResultSet;
  5. import java.sql.ResultSetMetaData;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.ArrayList;
  9. import java.util.List;
  10.  
  11. import javafx.application.Application;
  12. import javafx.beans.Observable;
  13. import javafx.collections.FXCollections;
  14. import javafx.collections.ObservableList;
  15. import javafx.geometry.Insets;
  16. import javafx.scene.Scene;
  17. import javafx.scene.control.Button;
  18. import javafx.scene.control.ComboBox;
  19. import javafx.scene.control.Label;
  20. import javafx.scene.control.ListView;
  21. import javafx.scene.control.PasswordField;
  22. import javafx.scene.control.TextField;
  23. import javafx.scene.input.MouseEvent;
  24. import javafx.scene.layout.GridPane;
  25. import javafx.stage.Stage;
  26.  
  27. public class Homework5Herman extends Application{
  28.  
  29. Scene scene1, scene2, scene3;
  30. Stage window;
  31. Connection connection;
  32.  
  33. public static void main(String[] args) {
  34. launch(args);
  35. }
  36.  
  37. @Override
  38. public void start(Stage primaryStage) {
  39. window = primaryStage;
  40.  
  41. loginScreen();
  42. }
  43.  
  44. public void loginScreen() {
  45. GridPane gdpOne = createGridPane();
  46.  
  47. Label lblUsername = new Label("Username :");
  48. TextField txtUsername = new TextField("ddherman");
  49. Label lblPassword = new Label("Password :");
  50. PasswordField pwfPassword = new PasswordField();
  51. pwfPassword.setText("ddhermancis357d");
  52. Button btnConnect = new Button("Connect");
  53. btnConnect.setOnMouseClicked(e -> clickedConnect(e, txtUsername, pwfPassword));
  54.  
  55. gdpOne.add(lblUsername, 0, 0);
  56. gdpOne.add(txtUsername, 1, 0);
  57. gdpOne.add(lblPassword, 0, 1);
  58. gdpOne.add(pwfPassword, 1, 1);
  59. gdpOne.add(btnConnect, 1, 2);
  60.  
  61. scene1 = new Scene(gdpOne);
  62. window.setTitle("HW 5 DB");
  63. window.setScene(scene1);
  64. window.show();
  65. }
  66.  
  67. public void inputScreen() throws SQLException {
  68. //Create nextWindow
  69. GridPane gdpTwo = createGridPane();
  70.  
  71. Label lblTables = new Label("Table :");
  72. ComboBox<String> cbxTables = setTableNames();
  73.  
  74. gdpTwo.add(lblTables, 0, 0);
  75. gdpTwo.add(cbxTables, 1, 0);
  76.  
  77. scene2 = new Scene(gdpTwo);
  78. window.setScene(scene2);
  79. }
  80.  
  81. public void clickedConnect(MouseEvent e, TextField usrname, PasswordField password) {
  82. //Load the driver
  83. loadDriver();
  84.  
  85. //Establish the connection
  86. try {
  87. connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:1111/ddherman" ,
  88. usrname.getText(), password.getText());
  89. System.out.println("Connection successful");
  90.  
  91. inputScreen();
  92. } catch (SQLException e1) {
  93. System.out.println("Failed to connect");
  94. }
  95. }
  96.  
  97. public ComboBox<String> setTableNames() throws SQLException {
  98. ComboBox<String> cbx = new ComboBox<>();
  99. ObservableList<String> tableNames = FXCollections.observableArrayList();
  100.  
  101. DatabaseMetaData dbmd = connection.getMetaData();
  102. ResultSet rs = dbmd.getTables(null, null, "%", null);
  103.  
  104. while (rs.next()) {
  105. String tableName = rs.getString(3);
  106.  
  107. tableNames.add(tableName);
  108. }
  109.  
  110. cbx.setItems(tableNames);
  111.  
  112. return cbx;
  113. }
  114.  
  115. public GridPane createGridPane() {
  116. GridPane gridPane = new GridPane();
  117. gridPane.setPadding(new Insets(10, 10, 10, 10));
  118. gridPane.setVgap(8);
  119. gridPane.setHgap(8);
  120.  
  121. return gridPane;
  122. }
  123.  
  124. public void loadDriver() {
  125. try {
  126. Class.forName("com.mysql.jdbc.Driver");
  127. System.out.println("Driver Loaded");
  128. } catch (ClassNotFoundException e1) {
  129. System.out.println("Driver failed to load");
  130. }
  131. }
  132. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement