Boa noite, sou novo aqui, estou tento um problema e gostaria se alguém puder, me ajudar.
Minha tela login (feita no netbeans) não conecta no banco de dados (postgresql)
Codigo login:
ackage form;
import factory.ConnectionFactory;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
public class LoginForm extends javax.swing.JFrame {
public LoginForm() {
initComponents();
}
public void acessarSistema() throws SQLException{
try{
ConnectionFactory conexao = new ConnectionFactory();
conexao.abrirConexao();
conexao.stmt = conexao.con.createStatement();
String sql = "SELECT * FROM LOGIN";
conexao.rs = conexao.stmt.executeQuery(sql);
conexao.rs.first();
if(txtUsuario.getText().equals(conexao.rs.getString("usuario"))
&& txtSenha.getText().equals(conexao.rs.getString("senha"))){
JOptionPane.showMessageDialog(null, "ACESSO PERMITIDO! ");
}else{
JOptionPane.showMessageDialog(null, "ACESSO NEGADO!" );
}
} catch (SQLException e){
}
}
@SuppressWarnings(“unchecked”)
//
private void initComponents() {
jLabel2 = new javax.swing.JLabel();
jlFundo = new javax.swing.JLabel();
jlLogin = new javax.swing.JLabel();
jlSenha = new javax.swing.JLabel();
txtSenha = new javax.swing.JPasswordField();
btnAcessar = new javax.swing.JButton();
btnSair = new javax.swing.JButton();
txtUsuario = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagem/login-novo.png"))); // NOI18N
jlFundo.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagem/login-novo.png"))); // NOI18N
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jlLogin.setFont(new java.awt.Font("Tahoma", 0, 20)); // NOI18N
jlLogin.setText("USUÁRIO");
getContentPane().add(jlLogin, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 50, 100, 30));
jlSenha.setFont(new java.awt.Font("Tahoma", 0, 20)); // NOI18N
jlSenha.setText("SENHA");
getContentPane().add(jlSenha, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 140, -1, -1));
txtSenha.setFont(new java.awt.Font("Tahoma", 0, 10)); // NOI18N
txtSenha.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtSenhaActionPerformed(evt);
}
});
getContentPane().add(txtSenha, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 169, 170, 20));
btnAcessar.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
btnAcessar.setText("ACESSAR");
btnAcessar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnAcessarActionPerformed(evt);
}
});
getContentPane().add(btnAcessar, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 210, 110, 23));
btnSair.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
btnSair.setText("SAIR");
btnSair.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnSairActionPerformed(evt);
}
});
getContentPane().add(btnSair, new org.netbeans.lib.awtextra.AbsoluteConstraints(320, 210, 73, 23));
txtUsuario.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtUsuarioActionPerformed(evt);
}
});
getContentPane().add(txtUsuario, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 80, 170, -1));
jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagem/login-novo.png"))); // NOI18N
getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 410, -1));
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void txtSenhaActionPerformed(java.awt.event.ActionEvent evt) {
}
private void btnAcessarActionPerformed(java.awt.event.ActionEvent evt) {
try {
acessarSistema();
} catch (SQLException ex) {
Logger.getLogger(LoginForm.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void btnSairActionPerformed(java.awt.event.ActionEvent evt) {
//MENSAGEM SE DESJAR SAIR OU NAO
Object[] options = { "SIM", "NÃO" };
int i = JOptionPane.showOptionDialog(null,
"TEM CERTEZA QUE DESEJA SAIR ?", "SAÍDA",
JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null,
options, options[0]);
if (i == JOptionPane.YES_OPTION) {
System.exit(0);
}
}
private void txtUsuarioActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new LoginForm().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btnAcessar;
private javax.swing.JButton btnSair;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jlFundo;
private javax.swing.JLabel jlLogin;
private javax.swing.JLabel jlSenha;
private javax.swing.JPasswordField txtSenha;
private javax.swing.JTextField txtUsuario;
// End of variables declaration
private void dispose(int i) {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
private void AcessarSistema() {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
private void conect() {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
}
Codigo conexão com o banco
package factory;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectionFactory {
// Dados da conexão
public Connection con;
public Statement stmt;
public ResultSet rs;
private final String driver = "org.postgresql.Driver";
private static final String URL = "jdbc:postgresql://127.0.0.1:5432/Distribuidora";
private static final String USUARIO = "postgres";
private static final String SENHA = "root";
// Método que retorna uma conexão
public static Connection abrir() throws SQLException {
// Captura uma conexão
Connection conexao = DriverManager.getConnection(URL, USUARIO, SENHA);
// Retorna a conexão aberta
return conexao;
}
public void abrirConexao() {
}
}
Alguem pra me ajudar ? Grato desde já.
