Guest User

Untitled

a guest
May 6th, 2018
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.30 KB | None | 0 0
  1. public class DatabaseHandler extends Config {
  2. Connection dbConnection;
  3.  
  4. //подключение к базе данных
  5. public Connection getDbConnection() throws ClassNotFoundException, SQLException {
  6. String connectionString = "jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbName;
  7. Class.forName("com.mysql.jdbc.Driver");
  8.  
  9. dbConnection = DriverManager.getConnection(connectionString, dbUser, dbPass);
  10.  
  11. return dbConnection;
  12.  
  13. }
  14. //удаление
  15. public void DeleteReader(Reader reader) {
  16. try{
  17. String insert = "DELETE FROM " + Const.READER_TABLE + "WHERE" +
  18. Const.READER_ID + "=?";
  19.  
  20. PreparedStatement preparedStatement =
  21. getDbConnection().prepareStatement(insert);
  22. preparedStatement.setString(1, reader.getId());
  23. preparedStatement.executeUpdate();
  24.  
  25. } catch (SQLException e) {
  26. e.printStackTrace();
  27. } catch (ClassNotFoundException e) {
  28. e.printStackTrace();
  29. }
  30. }
  31.  
  32. void initialize() {
  33. ReaderAdd.setOnAction(eventAdd -> {
  34.  
  35. AddReader();
  36. });
  37. ReaderDellete.setOnAction(eventDelete -> {
  38. String idRead = idReader.getText().trim();
  39. if(!idRead.equals("")) {
  40. try {
  41. DelRead(idRead);
  42. } catch (SQLException e) {
  43. e.printStackTrace();
  44. }
  45. }
  46. else
  47. System.out.println("ERROR");// если не заполнил
  48. });
  49.  
  50. }
  51.  
  52.  
  53.  
  54. private void DelRead(String idRead) throws SQLException {
  55. DatabaseHandler databaseHandler = new DatabaseHandler();
  56. Reader reader = new Reader();
  57. reader.setId(idRead);
  58. reader.getId();
  59. databaseHandler.DeleteReader(reader);
  60. }
  61.  
  62. Sun May 06 16:56:45 EEST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  63. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='3'' at line 1
  64. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  65. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  66. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  67. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  68. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  69. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  70. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  71. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  72. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  73. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  74. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  75. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  76. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  77. at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
  78. at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
  79. at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
  80. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
  81. at sample.DatabaseHandler.DeleteReader(DatabaseHandler.java:97)
  82. at sample.Reader.ReaderController.DelRead(ReaderController.java:86)
  83. at sample.Reader.ReaderController.lambda$initialize$1(ReaderController.java:68)
  84. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  85. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  86. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  87. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  88. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  89. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  90. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  91. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  92. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  93. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  94. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  95. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  96. at javafx.event.Event.fireEvent(Event.java:198)
  97. at javafx.scene.Node.fireEvent(Node.java:8413)
  98. at javafx.scene.control.Button.fire(Button.java:185)
  99. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
  100. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
  101. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  102. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  103. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  104. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  105. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  106. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  107. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  108. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  109. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  110. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  111. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  112. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  113. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  114. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  115. at javafx.event.Event.fireEvent(Event.java:198)
  116. at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  117. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  118. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  119. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  120. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:381)
  121. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
  122. at java.security.AccessController.doPrivileged(Native Method)
  123. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:417)
  124. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  125. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:416)
  126. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  127. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  128. at com.sun.glass.ui.gtk.GtkApplication.enterNestedEventLoopImpl(Native Method)
  129. at com.sun.glass.ui.gtk.GtkApplication._enterNestedEventLoop(GtkApplication.java:211)
  130. at com.sun.glass.ui.Application.enterNestedEventLoop(Application.java:511)
  131. at com.sun.glass.ui.EventLoop.enter(EventLoop.java:107)
  132. at com.sun.javafx.tk.quantum.QuantumToolkit.enterNestedEventLoop(QuantumToolkit.java:583)
  133. at javafx.stage.Stage.showAndWait(Stage.java:474)
  134. at sample.HomeWindow.HomeController.openNewScene(HomeController.java:62)
  135. at sample.HomeWindow.HomeController.lambda$initialize$0(HomeController.java:45)
  136. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  137. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  138. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  139. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  140. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  141. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  142. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  143. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  144. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  145. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  146. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  147. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  148. at javafx.event.Event.fireEvent(Event.java:198)
  149. at javafx.scene.Node.fireEvent(Node.java:8413)
  150. at javafx.scene.control.Button.fire(Button.java:185)
  151. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
  152. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
  153. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  154. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  155. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  156. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  157. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  158. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  159. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  160. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  161. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  162. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  163. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  164. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  165. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  166. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  167. at javafx.event.Event.fireEvent(Event.java:198)
  168. at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  169. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  170. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  171. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  172. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:381)
  173. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
  174. at java.security.AccessController.doPrivileged(Native Method)
  175. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:417)
  176. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  177. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:416)
  178. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  179. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  180. at com.sun.glass.ui.gtk.GtkApplication._runLoop(Native Method)
  181. at com.sun.glass.ui.gtk.GtkApplication.lambda$null$5(GtkApplication.java:139)
  182. at java.lang.Thread.run(Thread.java:748)
  183.  
  184. //preparedStatement.setString(1, reader.getId());
  185. preparedStatement.setInt(1, Integer.parseInt( reader.getId() ) );
Add Comment
Please, Sign In to add comment