API tools faq
paste
Guest User

Untitled

a guest
Feb 8th, 2018
86
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.87 KB | None | 0 0
raw download clone embed print report
  1. Exception in thread "JavaFX Application Thread" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
  2. at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1774)
  3. at javafx.fxml.FXMLLoader$ControllerMethodEventHandler.handle(FXMLLoader.java:1657)
  4. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  5. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  6. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  7. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  8. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  9. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  10. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  11. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  12. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  13. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  14. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  15. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  16. at javafx.event.Event.fireEvent(Event.java:198)
  17. at javafx.scene.Node.fireEvent(Node.java:8413)
  18. at javafx.scene.control.Button.fire(Button.java:185)
  19. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
  20. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
  21. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  22. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  23. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  24. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  25. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  26. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  27. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  28. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  29. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  30. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  31. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  32. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  33. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  34. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  35. at javafx.event.Event.fireEvent(Event.java:198)
  36. at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  37. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  38. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  39. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  40. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:394)
  41. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
  42. at java.security.AccessController.doPrivileged(Native Method)
  43. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$353(GlassViewEventHandler.java:432)
  44. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  45. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:431)
  46. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  47. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  48. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  49. at com.sun.glass.ui.win.WinApplication.lambda$null$147(WinApplication.java:177)
  50. at java.lang.Thread.run(Thread.java:748)
  51. Caused by: java.lang.reflect.InvocationTargetException
  52. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  53. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  54. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  55. at java.lang.reflect.Method.invoke(Method.java:498)
  56. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  57. at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  58. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  59. at java.lang.reflect.Method.invoke(Method.java:498)
  60. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  61. at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1769)
  62. ... 48 more
  63. Caused by: java.lang.NullPointerException
  64. at Login.loginController.login(loginController.java:37)
  65. ... 58 more
  66.  
  67. if (database.isLogin(username.getText(), password.getText())){
  68.  
  69. String createManagement = "CREATE TABLE IF NOT EXISTS Management (name varchar(255), surname varchar(255), username varchar(255), password varchar(255))";
  70.  
  71. public boolean insertManagement(String name, String surname, String username, String password) {
  72. try {
  73. PreparedStatement preparedStatement = connection.prepareStatement("insert into Management values (?,?,?,?);");
  74. preparedStatement.setString(1, name);
  75. preparedStatement.setString(2, surname);
  76. preparedStatement.setString(3, username);
  77. preparedStatement.setString(4, password);
  78. preparedStatement.execute();
  79. } catch (SQLException e) {
  80. System.out.println("Error with insert Management to the table");
  81. e.printStackTrace();
  82. return false;
  83. }
  84. return true;
  85. }
  86.  
  87.  
  88. public boolean isLogin(String username, String password) throws SQLException {
  89. PreparedStatement preparedStatement = null;
  90. ResultSet resultSet = null;
  91. String query = "SELECT * FROM Management where username = ?, password = ?";
  92. try {
  93. preparedStatement = connection.prepareStatement(query);
  94. preparedStatement.setString(1, username);
  95. preparedStatement.setString(2, password);
  96.  
  97. resultSet = preparedStatement.executeQuery();
  98. if (resultSet.next()) {
  99. return true;
  100. }else {
  101. return false;
  102. }
  103. } catch (Exception e) {
  104. return false;
  105. }
  106.  
  107. public Management(String name, String surname, String username, String password){
  108. this.name = new SimpleStringProperty(name);
  109. this.surname = new SimpleStringProperty(surname);
  110. this.username = new SimpleStringProperty(username);
  111. this.password = new SimpleStringProperty(password);
  112. }
  113.  
  114. public StringProperty name;
  115. public StringProperty nameProperty(){return name;}
  116. public void setName(String value){nameProperty().set(value);}
  117. public String getName(){return nameProperty().get();}
  118.  
  119.  
  120. public StringProperty surname;
  121. public StringProperty surnameProperty(){return surname;}
  122. public void setSurname(String value){surnameProperty().set(value);}
  123. public String getSurname(){return surnameProperty().get();}
  124.  
  125. public StringProperty username;
  126. public StringProperty usernameProperty(){return username;}
  127. public void setUsername(String value){usernameProperty().set(value);}
  128. public String getUsername(){return usernameProperty().get();}
  129.  
  130. public StringProperty password;
  131. public StringProperty passwordProperty(){return password;}
  132. public void setPassword(String value){passwordProperty().set(value);}
  133. public String getPassword(){return passwordProperty().get();}
  134. }
  135.  
  136. public void login (ActionEvent actionEvent){
  137. try {
  138. if (database.isLogin(username.getText(), password.getText())){
  139. isConnected.setText("Connected");
  140. }else {
  141. System.out.println("Wrong username or password!");
  142. }
  143. }catch (SQLException e){
  144. System.out.println("Wrong username or password!");
  145. e.printStackTrace();
  146. }
  147. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!