API tools faq
paste
Guest User

Untitled

a guest
Dec 15th, 2017
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.03 KB | None | 0 0
raw download clone embed print report
  1. private void caricaActionPerformed(java.awt.event.ActionEvent evt) {
  2. String username = null,ruolo=null,password;
  3. username = usernameField.getText();
  4. password = passwordField.getText();
  5. ruolo = ruoloField.getText();
  6. try {
  7. aggiungiUtente(username,password,ruolo);
  8. } catch (SQLException ex) {
  9. Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, ex);
  10. }
  11. }
  12. private void aggiungiUtente(String username,String password,String ruolo) throws SQLException {
  13. Connection conn;
  14. String url="jdbc:mysql://localhost:3306/gestionale",user="root",psw="141299Fm";
  15. conn = (Connection) DriverManager.getConnection(url,user,psw);
  16. conn.setAutoCommit(false);
  17. String sql= "insert into Utenti('username',password','ruolo') VALUES(?,?,?)";
  18. try{
  19. PreparedStatement st = conn.prepareStatement(sql);
  20. st.setString(1, username);
  21. st.setString(2, password);
  22. st.setString(3, ruolo);
  23.  
  24. ResultSet rs = st.executeQuery();
  25.  
  26. System.out.println(rs);
  27. }catch(SQLException e)
  28. {
  29. Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, e);
  30. }
  31.  
  32.  
  33. }
  34.  
  35. run:
  36. apr 09, 2017 10:38:51 PM InserisciUtente aggiungiUtente
  37. GRAVE: null
  38. java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
  39. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
  40. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  41. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  42. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  43. at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813)
  44. at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795)
  45. at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4616)
  46. at InserisciUtente.aggiungiUtente(InserisciUtente.java:136)
  47. at InserisciUtente.caricaActionPerformed(InserisciUtente.java:123)
  48. at InserisciUtente.access$000(InserisciUtente.java:20)
  49. at InserisciUtente$1.actionPerformed(InserisciUtente.java:63)
  50. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  51. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
  52. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  53. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  54. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  55. at java.awt.Component.processMouseEvent(Component.java:6533)
  56. at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  57. at java.awt.Component.processEvent(Component.java:6298)
  58. at java.awt.Container.processEvent(Container.java:2236)
  59. at java.awt.Component.dispatchEventImpl(Component.java:4889)
  60. at java.awt.Container.dispatchEventImpl(Container.java:2294)
  61. at java.awt.Component.dispatchEvent(Component.java:4711)
  62. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  63. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
  64. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  65. at java.awt.Container.dispatchEventImpl(Container.java:2280)
  66. at java.awt.Window.dispatchEventImpl(Window.java:2746)
  67. at java.awt.Component.dispatchEvent(Component.java:4711)
  68. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  69. at java.awt.EventQueue.access$500(EventQueue.java:97)
  70. at java.awt.EventQueue$3.run(EventQueue.java:709)
  71. at java.awt.EventQueue$3.run(EventQueue.java:703)
  72. at java.security.AccessController.doPrivileged(Native Method)
  73. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  74. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
  75. at java.awt.EventQueue$4.run(EventQueue.java:731)
  76. at java.awt.EventQueue$4.run(EventQueue.java:729)
  77. at java.security.AccessController.doPrivileged(Native Method)
  78. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  79. at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  80. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  81. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  82. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
  83. at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
  84. at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
  85. at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
  86. at java.security.AccessController.doPrivileged(Native Method)
  87. at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
  88. at java.awt.Dialog.show(Dialog.java:1084)
  89. at java.awt.Component.show(Component.java:1671)
  90. at java.awt.Component.setVisible(Component.java:1623)
  91. at java.awt.Window.setVisible(Window.java:1014)
  92. at java.awt.Dialog.setVisible(Dialog.java:1005)
  93. at FormUtenti.jButton1ActionPerformed(FormUtenti.java:104)
  94. at FormUtenti.access$000(FormUtenti.java:11)
  95. at FormUtenti$2.actionPerformed(FormUtenti.java:64)
  96. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  97. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
  98. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  99. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  100. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  101. at java.awt.Component.processMouseEvent(Component.java:6533)
  102. at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  103. at java.awt.Component.processEvent(Component.java:6298)
  104. at java.awt.Container.processEvent(Container.java:2236)
  105. at java.awt.Component.dispatchEventImpl(Component.java:4889)
  106. at java.awt.Container.dispatchEventImpl(Container.java:2294)
  107. at java.awt.Component.dispatchEvent(Component.java:4711)
  108. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  109. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
  110. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  111. at java.awt.Container.dispatchEventImpl(Container.java:2280)
  112. at java.awt.Window.dispatchEventImpl(Window.java:2746)
  113. at java.awt.Component.dispatchEvent(Component.java:4711)
  114. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  115. at java.awt.EventQueue.access$500(EventQueue.java:97)
  116. at java.awt.EventQueue$3.run(EventQueue.java:709)
  117. at java.awt.EventQueue$3.run(EventQueue.java:703)
  118. at java.security.AccessController.doPrivileged(Native Method)
  119. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  120. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
  121. at java.awt.EventQueue$4.run(EventQueue.java:731)
  122. at java.awt.EventQueue$4.run(EventQueue.java:729)
  123. at java.security.AccessController.doPrivileged(Native Method)
  124. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  125. at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  126. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  127. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  128. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
  129. at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
  130. at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
  131. at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
  132. at java.security.AccessController.doPrivileged(Native Method)
  133. at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
  134. at java.awt.Dialog.show(Dialog.java:1084)
  135. at java.awt.Component.show(Component.java:1671)
  136. at java.awt.Component.setVisible(Component.java:1623)
  137. at java.awt.Window.setVisible(Window.java:1014)
  138. at java.awt.Dialog.setVisible(Dialog.java:1005)
  139. at FrameMenu.pulsanteUtentiActionPerformed(FrameMenu.java:155)
  140. at FrameMenu.access$200(FrameMenu.java:11)
  141. at FrameMenu$3.actionPerformed(FrameMenu.java:65)
  142. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  143. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
  144. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  145. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  146. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  147. at java.awt.Component.processMouseEvent(Component.java:6533)
  148. at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  149. at java.awt.Component.processEvent(Component.java:6298)
  150. at java.awt.Container.processEvent(Container.java:2236)
  151. at java.awt.Component.dispatchEventImpl(Component.java:4889)
  152. at java.awt.Container.dispatchEventImpl(Container.java:2294)
  153. at java.awt.Component.dispatchEvent(Component.java:4711)
  154. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  155. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
  156. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  157. at java.awt.Container.dispatchEventImpl(Container.java:2280)
  158. at java.awt.Window.dispatchEventImpl(Window.java:2746)
  159. at java.awt.Component.dispatchEvent(Component.java:4711)
  160. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  161. at java.awt.EventQueue.access$500(EventQueue.java:97)
  162. at java.awt.EventQueue$3.run(EventQueue.java:709)
  163. at java.awt.EventQueue$3.run(EventQueue.java:703)
  164. at java.security.AccessController.doPrivileged(Native Method)
  165. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  166. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
  167. at java.awt.EventQueue$4.run(EventQueue.java:731)
  168. at java.awt.EventQueue$4.run(EventQueue.java:729)
  169. at java.security.AccessController.doPrivileged(Native Method)
  170. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
  171. at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  172. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  173. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  174. at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  175. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  176. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  177. at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  178.  
  179. **Stack Trace **
  180.  
  181. String sql= "insert into Utenti(username,password,ruolo) VALUES(?,?,?)";
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!