[RESOLVIDO] login e senha

1 resposta
E

pessoal boa noite !.

estou com o seguinte problema:

[b]

    nt -f C:\\Sisbar\\sisbarLogin -Djavac.includes=br/sisbar/principal/sisbarLogin.java -Drun.class=br.sisbar.principal.sisbarLogin -Dnb.internal.action.name=run.single run-single
init:

Deleting: C:\Sisbar\sisbarLogin\build\built-jar.properties

deps-jar:

Updating property file: C:\Sisbar\sisbarLogin\build\built-jar.properties

Compiling 1 source file to C:\Sisbar\sisbarLogin\build\classes

warning: [options] bootstrap class path not set in conjunction with -source 1.5

1 warning

compile-single:

run-single:

org.postgresql.util.PSQLException: ERRO: relação login não existe

Posição: 27

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)

at br.sisbar.principal.loginControle.localizar(loginControle.java:40)

at br.sisbar.principal.sisbarLogin$1.actionPerformed(sisbarLogin.java:87)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

at java.awt.Component.processMouseEvent(Component.java:6505)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

at java.awt.Component.processEvent(Component.java:6270)

at java.awt.Container.processEvent(Container.java:2229)

at java.awt.Component.dispatchEventImpl(Component.java:4861)

at java.awt.Container.dispatchEventImpl(Container.java:2287)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

at java.awt.Container.dispatchEventImpl(Container.java:2273)

at java.awt.Window.dispatchEventImpl(Window.java:2719)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

at java.awt.EventQueue.access$200(EventQueue.java:103)

at java.awt.EventQueue$3.run(EventQueue.java:694)

at java.awt.EventQueue$3.run(EventQueue.java:692)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

at java.awt.EventQueue$4.run(EventQueue.java:708)

at java.awt.EventQueue$4.run(EventQueue.java:706)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
[/b]

segue abaixo código :

package br.sisbar.principal;

import br.sisbar.conexao.ConexaoPostgresql;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;



public class loginControle {
    
    private PreparedStatement pstm;  
    private ResultSet rs;
    private String consultaUsuario = "select USUARIO,SENHA from LOGIN where USUARIO = ? and SENHA = ? ";
       
    
  public void localizar(String user,char[] sen){  
    
    try{  
        
        String use = user;
        char[] senh = sen;
        String s = String.valueOf(senh);
        
        ConexaoPostgresql postgre = new ConexaoPostgresql();         
        
        pstm = postgre.conecta().prepareStatement(consultaUsuario);
        pstm.setObject(1,use);
        pstm.setObject(2, s);
        rs = pstm.executeQuery();
        
         LoginBean logi;
         logi = new LoginBean();
         
         if(rs.next()){
             
             logi.setUsuario(rs.getString("USUARIO"));
             logi.setSenha(rs.getString("SENHA"));
                              
               sisbarPrincipal.abrePrincipal();
                 
                }         
                else{
             
                JOptionPane.showMessageDialog(null,"Login ou Senha Incorretos");                
             }              
            } 
           catch(SQLException e){
               e.printStackTrace();           
           }                                       
          }  
   }

não roda a aplicação, vocês poderiam me ajudar ?.

1 Resposta

E

eductd:
pessoal boa noite !.

estou com o seguinte problema:

[b]

    nt -f C:\\Sisbar\\sisbarLogin -Djavac.includes=br/sisbar/principal/sisbarLogin.java -Drun.class=br.sisbar.principal.sisbarLogin -Dnb.internal.action.name=run.single run-single
init:

Deleting: C:\Sisbar\sisbarLogin\build\built-jar.properties

deps-jar:

Updating property file: C:\Sisbar\sisbarLogin\build\built-jar.properties

Compiling 1 source file to C:\Sisbar\sisbarLogin\build\classes

warning: [options] bootstrap class path not set in conjunction with -source 1.5

1 warning

compile-single:

run-single:

org.postgresql.util.PSQLException: ERRO: relação login não existe

Posição: 27

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)

at br.sisbar.principal.loginControle.localizar(loginControle.java:40)

at br.sisbar.principal.sisbarLogin$1.actionPerformed(sisbarLogin.java:87)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

at java.awt.Component.processMouseEvent(Component.java:6505)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

at java.awt.Component.processEvent(Component.java:6270)

at java.awt.Container.processEvent(Container.java:2229)

at java.awt.Component.dispatchEventImpl(Component.java:4861)

at java.awt.Container.dispatchEventImpl(Container.java:2287)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

at java.awt.Container.dispatchEventImpl(Container.java:2273)

at java.awt.Window.dispatchEventImpl(Window.java:2719)

at java.awt.Component.dispatchEvent(Component.java:4687)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

at java.awt.EventQueue.access$200(EventQueue.java:103)

at java.awt.EventQueue$3.run(EventQueue.java:694)

at java.awt.EventQueue$3.run(EventQueue.java:692)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

at java.awt.EventQueue$4.run(EventQueue.java:708)

at java.awt.EventQueue$4.run(EventQueue.java:706)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
[/b]

segue abaixo código :

package br.sisbar.principal;

import br.sisbar.conexao.ConexaoPostgresql;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;



public class loginControle {
    
    private PreparedStatement pstm;  
    private ResultSet rs;
    private String consultaUsuario = "select USUARIO,SENHA from LOGIN where USUARIO = ? and SENHA = ? ";
       
    
  public void localizar(String user,char[] sen){  
    
    try{  
        
        String use = user;
        char[] senh = sen;
        String s = String.valueOf(senh);
        
        ConexaoPostgresql postgre = new ConexaoPostgresql();         
        
        pstm = postgre.conecta().prepareStatement(consultaUsuario);
        pstm.setObject(1,use);
        pstm.setObject(2, s);
        rs = pstm.executeQuery();
        
         LoginBean logi;
         logi = new LoginBean();
         
         if(rs.next()){
             
             logi.setUsuario(rs.getString("USUARIO"));
             logi.setSenha(rs.getString("SENHA"));
                              
               sisbarPrincipal.abrePrincipal();
                 
                }         
                else{
             
                JOptionPane.showMessageDialog(null,"Login ou Senha Incorretos");                
             }              
            } 
           catch(SQLException e){
               e.printStackTrace();           
           }                                       
          }  
   }

não roda a aplicação, vocês poderiam me ajudar ?.

Criado 26 de janeiro de 2014
Ultima resposta 26 de jan. de 2014
Respostas 1
Participantes 1