/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package Telas;
import Banco.Conexao;
import java.sql.*;
import javax.swing.JOptionPane;
/**
*
* @author EasyKill
*/
public class TelaLogin extends javax.swing.JFrame {
/**
* Creates new form TelaLogin
*/
public TelaLogin() {
initComponents();
}
/**
* 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.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
Entrar_login = new javax.swing.JButton();
Sair_login = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
Limpar_login = new javax.swing.JButton();
Login_entrar = new javax.swing.JTextField();
Senha_entrar = new javax.swing.JTextField();
jSeparator1 = new javax.swing.JSeparator();
Contacto_login = new javax.swing.JButton();
jLabel3 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Sistema DeskFit");
Entrar_login.setText("Entrar");
Entrar_login.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
Entrar_loginMouseClicked(evt);
}
});
Entrar_login.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Entrar_loginActionPerformed(evt);
}
});
Sair_login.setText("Sair");
jLabel1.setText("Login");
jLabel2.setText("Senha");
Limpar_login.setText("Limpar");
Contacto_login.setText("Contacto");
jLabel3.setBackground(new java.awt.Color(255, 0, 0));
jLabel3.setFont(new java.awt.Font("Arial Black", 0, 12)); // NOI18N
jLabel3.setForeground(new java.awt.Color(204, 0, 0));
jLabel3.setText("Sistema de relatorios DeskFit");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jSeparator1)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Contacto_login)
.addGap(20, 20, 20))
.addGroup(layout.createSequentialGroup()
.addGap(118, 118, 118)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel3)
.addGroup(layout.createSequentialGroup()
.addComponent(Entrar_login)
.addGap(6, 6, 6)
.addComponent(Limpar_login)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Sair_login)))
.addGap(0, 112, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGap(132, 132, 132)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(Senha_entrar, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addComponent(Login_entrar, javax.swing.GroupLayout.PREFERRED_SIZE, 114, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap(38, Short.MAX_VALUE)
.addComponent(jLabel3)
.addGap(34, 34, 34)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(Login_entrar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(29, 29, 29)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(Senha_entrar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(46, 46, 46)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Entrar_login)
.addComponent(Limpar_login)
.addComponent(Sair_login))
.addGap(18, 18, 18)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Contacto_login)
.addContainerGap())
);
pack();
}// </editor-fold>
private void Entrar_loginActionPerformed(java.awt.event.ActionEvent evt) {
}
private void Entrar_loginMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
Login_teste(Login_entrar.getText(), Senha_entrar.getText());
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(TelaLogin.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
new TelaLogin().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton Contacto_login;
private javax.swing.JButton Entrar_login;
private javax.swing.JButton Limpar_login;
private javax.swing.JTextField Login_entrar;
private javax.swing.JButton Sair_login;
private javax.swing.JTextField Senha_entrar;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JSeparator jSeparator1;
// End of variables declaration
public String Login_teste(String login, String senha) {
Connection con = Conexao.getConnection();
if (Login_entrar.getText().equals("") || Senha_entrar.getText().equals("")) {
JOptionPane.showMessageDialog(null, "Login ou Senha inválido.", "Sistema DeskFit", JOptionPane.ERROR_MESSAGE);
} else {
try {
System.out.println("ddwdw");
String sql ="SELECT cd_login_adm , cd_senha_adm FROM login_admnistrador_web where cd_login_adm = ? AND cd_senha_adm = ?";
PreparedStatement pstmt = con.prepareStatement(sql);
System.out.println("dwdw");
pstmt.setString(1, login);
pstmt.setString(2, senha);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String login_teste = rs.getString(1);
String senha_teste = rs.getString(2);
if (Login_entrar.getText().equals(login_teste) && Senha_entrar.getText().equals(senha_teste)) {
JOptionPane.showMessageDialog(null, "Login Executado com sucesso", "Sistema DeskFit", JOptionPane.INFORMATION_MESSAGE);
} else {
JOptionPane.showMessageDialog(null, "Login ou Senha inválidos.", "Sistema DeskFit", JOptionPane.ERROR_MESSAGE);
Senha_entrar.setText("");
}
}
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "Erro de conexão", "Sistema DeskFit", JOptionPane.ERROR_MESSAGE);
}
}
return "";
}
}
