Auguem pode me ajudar com meu Login tem duas linhas erradas

Programação Java
#1

[code]package cadastro;

import javax.swing.;
import java.awt.;
import java.awt.event.;
import java.sql.;
import java.text.SimpleDateFormat;
import java.util.GregorianCalendar;
import java.util.Calendar;
import java.util.Date;
import java.io.*;

public class login extends javax.swing.JFrame {
ResultSet rs_login;
Statement st_login;
int tentativa = 0;

//String usuario,nivel_acesso;
/** Creates new form login */
public login() {
    initComponents();
       //lookandfeel();
    conecta_banco();
    //nao_maximizar();
}

/** This method is called from within the constructor to
 * initialize the form.
 * WARNING: Do NOT modify this code. The content of this method is
 * always regenerated by the Form Editor.
 */
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">//GEN-BEGIN:initComponents
private void initComponents() {
    jPanel1 = new javax.swing.JPanel();
    jl_acesso = new javax.swing.JLabel();
    jl_usuario = new javax.swing.JLabel();
    jl_senha = new javax.swing.JLabel();
    tf_usuario = new javax.swing.JTextField();
    tf_senha = new javax.swing.JPasswordField();
    bt_acesso = new javax.swing.JButton();
    bt_cancela = new javax.swing.JButton();

    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    jPanel1.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
    jl_acesso.setFont(new java.awt.Font("MS Sans Serif", 0, 24));
    jl_acesso.setText("Acesso ao sitema");

    jl_usuario.setText("Usuario");
    jl_usuario.addAncestorListener(new javax.swing.event.AncestorListener() {
        public void ancestorMoved(javax.swing.event.AncestorEvent evt) {
        }
        public void ancestorAdded(javax.swing.event.AncestorEvent evt) {
            jl_usuarioAncestorAdded(evt);
        }
        public void ancestorRemoved(javax.swing.event.AncestorEvent evt) {
        }
    });

    jl_senha.setText("Senha");

    bt_acesso.setText("Acesso");
    bt_acesso.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            bt_acessoActionPerformed(evt);
        }
    });

    bt_cancela.setText("Cancela");
    bt_cancela.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            bt_cancelaActionPerformed(evt);
        }
    });

    org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(
        jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(jPanel1Layout.createSequentialGroup()
            .addContainerGap()
            .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(jl_senha)
                .add(jl_usuario))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(tf_senha, 0, 0, Short.MAX_VALUE)
                .add(jPanel1Layout.createSequentialGroup()
                    .add(bt_acesso)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 53, Short.MAX_VALUE)
                    .add(bt_cancela))
                .add(jPanel1Layout.createSequentialGroup()
                    .add(tf_usuario, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 191, Short.MAX_VALUE)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
            .addContainerGap())
        .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel1Layout.createSequentialGroup()
            .addContainerGap(34, Short.MAX_VALUE)
            .add(jl_acesso)
            .add(30, 30, 30))
    );
    jPanel1Layout.setVerticalGroup(
        jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(jPanel1Layout.createSequentialGroup()
            .add(jl_acesso)
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(jl_usuario)
                .add(jPanel1Layout.createSequentialGroup()
                    .add(tf_usuario, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(tf_senha, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(jl_senha))))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                .add(bt_acesso)
                .add(bt_cancela))
            .add(11, 11, 11))
    );

    org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
        layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(layout.createSequentialGroup()
            .addContainerGap()
            .add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
            .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    );
    layout.setVerticalGroup(
        layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(layout.createSequentialGroup()
            .addContainerGap()
            .add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
            .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    );
    pack();
}// </editor-fold>//GEN-END:initComponents

private void jl_usuarioAncestorAdded(javax.swing.event.AncestorEvent evt) {//GEN-FIRST:event_jl_usuarioAncestorAdded

// TODO add your handling code here:
}//GEN-LAST:event_jl_usuarioAncestorAdded

private void bt_cancelaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bt_cancelaActionPerformed
System.exit(0);
}//GEN-LAST:event_bt_cancelaActionPerformed

private void bt_acessoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bt_acessoActionPerformed
acesso();      
}//GEN-LAST:event_bt_acessoActionPerformed

/**
 * @param args the command line arguments
 */
public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
        public void run() {
            new login().setVisible(true);
        }
    });
}

// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton bt_acesso;
private javax.swing.JButton bt_cancela;
private javax.swing.JPanel jPanel1;
private javax.swing.JLabel jl_acesso;
private javax.swing.JLabel jl_senha;
private javax.swing.JLabel jl_usuario;
private javax.swing.JPasswordField tf_senha;
private javax.swing.JTextField tf_usuario;
// End of variables declaration//GEN-END:variables

public void lookandfeel()
{
try
{
UIManager.setLookAndFeel("com.birosoft.liquid.LiquidLookAndFeel");
SwingUtilities.updateComponentTreeUI(this);
}
catch(Exception erro)
{
JOptionPane.showMessageDialog(null, "Não conseguiu setar o novo LookAndFeel!!!");
}
}

public void acesso()
{
String usuario = new String(tf_usuario.getText());
try
{
String SQL = “SELECT * FROM tabela_usuario where log_usuario =’”+usuario+"’";
rs_login = st_login.executeQuery(SQL);
rs_login.next();

        String senha = new String(tf_senha.getPassword());
        
        if (senha.equals(rs_login.getString("log_senha")))
                {                  
      erradas//new menu_principal().setVisible(true);
      erradas//menu_principal.jl_usuario.setText(usuario);
                    dispose();
                }
            else
                {
                    JOptionPane.showMessageDialog(null,"Senha ou Usuario nao confere!!!");
                    System.exit(0);
                }

}

catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,"Senha ou Usuario nao confere!!");
System.exit(0);
}
}

public void conecta_banco()
{
String url = "jdbc:odbc:login";
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection conexao = DriverManager.getConnection(url);
//JOptionPane.showMessageDialog(null,"Parabéns, a conexão foi realizada com sucesso");
st_login = conexao.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs_login = st_login.executeQuery("SELECT * from tabela_usuario");
rs_login.first(); //aponta para o primeiro registro

        }
    catch(ClassNotFoundException ex)
        {
            JOptionPane.showMessageDialog(null,"Driver JDBC-ODBC não encontrado!");
        }
    catch(SQLException ex)
      {
            JOptionPane.showMessageDialog(null,"Problemas na conexao com a fonte de dados, erro = "+ex);
      }

}
}
[/code]

[size=“11”][color=“red”]* Editado: Lembre-se de utilizar BBCode em seus códigos - Carneiro[/color][/size] :joia:

#2

quais são as 2 linhas q estão erradas ???

#3

Viugi!
Já penssase em trabalhar com MVC, hehe??

#4

public void acesso()
{
String usuario = new String(tf_usuario.getText());
try
{
String SQL = “SELECT * FROM tabela_usuario where log_usuario =’”+usuario+"’";
rs_login = st_login.executeQuery(SQL);
rs_login.next();

        String senha = new String(tf_senha.getPassword());
        
        if (senha.equals(rs_login.getString("log_senha")))
                {                  
                   [u] new menu_principal().setVisible(true);
                    menu_principal.lb_usuario.setText(usuario);[/u]                        dispose();
                }
            else
                {
                    JOptionPane.showMessageDialog(null,"Senha ou Usuario nao confere!!!");
                    System.exit(0);
                }

}

catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,“Senha ou Usuario nao confere!!”);
System.exit(0);
}
}

#5

Mais uma coisa como usar o firebird. valeu obrigado!

#6