Boa Noite Pessoal.
Estou terminando a aplicação abaixo, vai ser um trabalho que utiliza chord, tabela hash e outros.....
Porem eu criei uma janela para login, mas não sei oq acontece com o banco esta correto, mas não valida, ou não aceita nenhum usuario cadastrado....
Sera que alguem pode me ajudar????
import com.sun.org.apache.bcel.internal.generic.NEW;
import javax.swing.JButton;
//import Conectar.Cont;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Teste_login extends javax.swing.JFrame {
Statement st = null;
Connection con ;
ResultSet rs = null;
/** Creates new form Teste_login */
public Teste_login() {
initComponents();
}
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
Usuario1 = new javax.swing.JLabel();
Senha1 = new javax.swing.JLabel();
jCheckBox1 = new javax.swing.JCheckBox();
senha = new javax.swing.JPasswordField();
Entrar = new javax.swing.JButton();
nome = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setBackground(new java.awt.Color(0, 51, 102));
setResizable(false);
jPanel1.setBackground(new java.awt.Color(0, 51, 51));
jPanel1.setBorder(javax.swing.BorderFactory.createMatteBorder(1, 1, 1, 1, new java.awt.Color(102, 51, 0)));
jPanel1.setRequestFocusEnabled(false);
jLabel1.setFont(new java.awt.Font("Tahoma", 0, 24));
jLabel1.setForeground(new java.awt.Color(0, 0, 204));
jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel1.setText("Controle ");
Usuario1.setFont(new java.awt.Font("Tahoma", 1, 12));
Usuario1.setForeground(new java.awt.Color(153, 102, 0));
Usuario1.setText("Usu\u00e1rio");
Senha1.setFont(new java.awt.Font("Tahoma", 1, 12));
Senha1.setForeground(new java.awt.Color(153, 102, 0));
Senha1.setText("Senha");
jCheckBox1.setBackground(new java.awt.Color(0, 51, 51));
jCheckBox1.setForeground(new java.awt.Color(0, 0, 204));
jCheckBox1.setText("Lembra");
jCheckBox1.setBorder(javax.swing.BorderFactory.createEmptyBorder(0, 0, 0, 0));
jCheckBox1.setMargin(new java.awt.Insets(0, 0, 0, 0));
Entrar.setText("Entrar");
Entrar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
EntrarActionPerformed(evt);
}
});
nome.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nomeActionPerformed(evt);
}
});
jLabel2.setIcon(new javax.swing.ImageIcon("C:\Documents and Settings\asilva\Meus documentos\Minhas imagens\Microsoft Media Gallery\mais_uma.JPG"));
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jCheckBox1)
.addGap(15, 15, 15)
.addComponent(Entrar))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(Senha1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Usuario1, javax.swing.GroupLayout.DEFAULT_SIZE, 47, Short.MAX_VALUE))
.addGap(13, 13, 13)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(senha)
.addComponent(nome, javax.swing.GroupLayout.DEFAULT_SIZE, 113, Short.MAX_VALUE))))
.addGap(31, 31, 31)
.addComponent(jLabel2))
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 330, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(16, 16, 16)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Usuario1)
.addComponent(nome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Senha1)
.addComponent(senha, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(14, 14, 14)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Entrar)
.addComponent(jCheckBox1)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(15, 15, 15)
.addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGap(136, 136, 136)))
.addContainerGap())
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 333, javax.swing.GroupLayout.PREFERRED_SIZE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE)
);
pack();
}// </editor-fold>
private void nomeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void EntrarActionPerformed(java.awt.event.ActionEvent evt) {
try
{
cont();
//Cria Instancia para conexao com o Banco
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // verifica se existe
con=DriverManager.getConnection("jdbc:odbc:popo","","");
//Cria a instrução SQL que será executada
st=con.createStatement();
String sql = "select * from login where senha = " + senha.getText() + " and nome = '" + nome.getText() + "'";
//executa a a instrução SQL
rs = st.executeQuery(sql);
//percorres os dados obtidos pela instrução SQL
rs.next();
//atribui os valores aos campos
nome.setText(rs.getString("nome"));
senha.setText(rs.getString("senha"));
new Teste_login().setVisible(true);
new Teste_login().setVisible(false);
setVisible(false);
//Fecha a conexao
con.close();
}
catch(Exception ex)
{
nome.setText("Não existe o Codigo " + nome.getText());
}
}
public void sair(){
new Teste_login().setVisible(true);
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Teste_login().setVisible(true);
}
});
}
private void cont() {
throw new UnsupportedOperationException("Not yet implemented");
}
// Variables declaration - do not modify
private javax.swing.JButton Entrar;
private javax.swing.JLabel Senha1;
private javax.swing.JLabel Usuario1;
private javax.swing.JCheckBox jCheckBox1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JPanel jPanel1;
private javax.swing.JTextField nome;
private javax.swing.JPasswordField senha;
// End of variables declaration
}