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);
}
}
}
[size="11"][color="red"]* Editado: Lembre-se de utilizar BBCode em seus códigos - Carneiro[/color][/size] :joia: