GuilhermeRamalho

Parameter Index Out of Range

Sep 15th, 2015
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 6.15 KB | None | 0 0
  1. //MÉTODO QUE BUSCA NO BANCO
  2. public void validateUser(Administrator adm)
  3.     {
  4.         PreparedStatement p = null;
  5.         ResultSet rs = null;
  6.        
  7.         Connection c = new dbConnections().openConnection();
  8.        
  9.         String sql = "SELECT `username_adm`, `password_adm`\n" +
  10.                      "FROM `tb_adm` \n" +
  11.                      "WHERE username_adm = '?' AND password_adm = '?'";
  12.        
  13.         try
  14.         {
  15.             p = c.prepareStatement(sql);
  16.             p.setString(1, adm.getUsername());
  17.             p.setString(2, adm.getPassword());
  18.                    
  19.             rs = p.executeQuery();
  20.            
  21.             if(rs.next())
  22.             {
  23.                 System.out.println("Usuário validado com sucesso!");
  24.                 adminMenu sc = new adminMenu();
  25.                 sc.setVisible(true);
  26.             }
  27.             else
  28.             {
  29.                 System.out.println("Erro ao validar usuário!");
  30.                 JOptionPane.showMessageDialog(null, "Usuário ou senha inválidos!\n"
  31.                         + "Por favor, tente novamente.");
  32.             }
  33.         }
  34.         catch (SQLException ex)
  35.         {
  36.             Logger.getLogger(sqlOperations.class.getName()).log(Level.SEVERE, null, ex);
  37.         }
  38.        
  39.        
  40.     }
  41.  
  42. //CÓDIGO DENTRO DA INTERFACE DE LOGIN
  43. private Administrator adm = new Administrator();
  44.    
  45.     private void passPFieldActionPerformed(java.awt.event.ActionEvent evt) {                                          
  46.         // TODO add your handling code here:  
  47.         //String username = loginField.getText();
  48.  
  49.     }                                          
  50.  
  51.     private void loginFieldActionPerformed(java.awt.event.ActionEvent evt) {                                          
  52.         // TODO add your handling code here:
  53.         //String password = passPField.getText();
  54.  
  55.     }                                          
  56.  
  57.     private void enterButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            
  58.         // TODO add your handling code here:
  59.         String username = loginField.getText();
  60.         String password = passPField.getText();
  61.         adm.setUsername(username);
  62.         adm.setPassword(password);
  63.        
  64.         sqlOperations op = new sqlOperations();
  65.         op.validateUser(adm);
  66.        
  67.         System.out.println("Fim da execução do botão 'entrar'");
  68.     }
  69.  
  70. //EXCEPTION======================================================================================>
  71. Execução 'dbConnection.openConnection();' entrou no 'try'.
  72. Conexão estabelecida com sucesso!
  73. Fim da execução do botão 'entrar'
  74. set 15, 2015 10:52:06 AM com.nanothings.ProjetoEGD.models.sqlOperations validateUser
  75. GRAVE: null
  76. java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
  77.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
  78.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  79.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  80.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  81.     at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813)
  82.     at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795)
  83.     at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4616)
  84.     at com.nanothings.ProjetoEGD.models.sqlOperations.validateUser(sqlOperations.java:76)
  85.     at com.nanothings.ProjetoEGD.views.Login.enterButtonActionPerformed(Login.java:156)
  86.     at com.nanothings.ProjetoEGD.views.Login.access$200(Login.java:18)
  87.     at com.nanothings.ProjetoEGD.views.Login$3.actionPerformed(Login.java:72)
  88.     at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  89.     at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
  90.     at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  91.     at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  92.     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  93.     at java.awt.Component.processMouseEvent(Component.java:6535)
  94.     at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  95.     at java.awt.Component.processEvent(Component.java:6300)
  96.     at java.awt.Container.processEvent(Container.java:2236)
  97.     at java.awt.Component.dispatchEventImpl(Component.java:4891)
  98.     at java.awt.Container.dispatchEventImpl(Container.java:2294)
  99.     at java.awt.Component.dispatchEvent(Component.java:4713)
  100.     at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  101.     at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
  102.     at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  103.     at java.awt.Container.dispatchEventImpl(Container.java:2280)
  104.     at java.awt.Window.dispatchEventImpl(Window.java:2750)
  105.     at java.awt.Component.dispatchEvent(Component.java:4713)
  106.     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  107.     at java.awt.EventQueue.access$500(EventQueue.java:97)
  108.     at java.awt.EventQueue$3.run(EventQueue.java:709)
  109.     at java.awt.EventQueue$3.run(EventQueue.java:703)
  110.     at java.security.AccessController.doPrivileged(Native Method)
  111.     at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  112.     at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
  113.     at java.awt.EventQueue$4.run(EventQueue.java:731)
  114.     at java.awt.EventQueue$4.run(EventQueue.java:729)
  115.     at java.security.AccessController.doPrivileged(Native Method)
  116.     at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  117.     at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  118.     at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  119.     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  120.     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  121.     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  122.     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  123.     at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Advertisement
Add Comment
Please, Sign In to add comment