Ola, pessoal,
Não estou conseguindo Conectar ao banco de dados e gostaria de uma ajuda para apos a autenticação …
Agradeço desde já!
Os codigos
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
public class login extends javax.swing.JFrame {
conexao conexao;
public login() {
initComponents();
{
conexao = new conexao();
conexao.conecta();
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
txtlogin = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
txtsenha = new javax.swing.JPasswordField();
jPanel2 = new javax.swing.JPanel();
botaologar = new javax.swing.JButton();
botaocancelar = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Dados do Login", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Aharoni", 1, 16), new java.awt.Color(0, 51, 204))); // NOI18N
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 11));
jLabel1.setText("Login:");
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 11));
jLabel2.setText("Senha:");
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)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(23, 23, 23)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtlogin, javax.swing.GroupLayout.DEFAULT_SIZE, 259, Short.MAX_VALUE)
.addComponent(txtsenha, javax.swing.GroupLayout.PREFERRED_SIZE, 121, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtlogin, 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(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtsenha, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
botaologar.setFont(new java.awt.Font("Tahoma", 1, 11));
botaologar.setText("Logar");
botaologar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
botaologarActionPerformed(evt);
}
});
botaocancelar.setFont(new java.awt.Font("Tahoma", 1, 11));
botaocancelar.setText("Cancelar");
botaocancelar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
botaocancelarActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(70, 70, 70)
.addComponent(botaologar, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(31, 31, 31)
.addComponent(botaocancelar, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(76, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(botaologar)
.addComponent(botaocancelar))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(8, 8, 8)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void botaocancelarActionPerformed(java.awt.event.ActionEvent evt) {
int resp = JOptionPane.showConfirmDialog(rootPane, "Deseja cancelar o login?", "Atencão", JOptionPane.OK_CANCEL_OPTION, JOptionPane.QUESTION_MESSAGE);
if (resp == 0) {
System.exit(0);
} else if (resp == 1) {
JOptionPane.showMessageDialog(rootPane, "Operação cancelada!");
}
}//GEN-LAST:event_botaocancelarActionPerformed
private void botaologarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_botaologarActionPerformed
/*if (txtlogin.getText().equals("") || txtsenha.getText().equals(""));
JOptionPane.showInternalMessageDialog(null, "Os campos não podem ser nulos!");*/
int resp = JOptionPane.showConfirmDialog(rootPane, "Deseja autenticar este login e senha?", "Atencão", JOptionPane.OK_CANCEL_OPTION, JOptionPane.QUESTION_MESSAGE);
String sql = "";
if (resp == 0) {
if (txtlogin.getText().equals("login")&& new String(txtsenha.getPassword()).equals("senha")) {
sql = " select from cadastro_usuario where login = " + txtlogin.getText();
conexao.consultar(sql);
sql = " select from cadastro_usuario where senha = " + txtsenha.getText();
conexao.consultar(sql);
JOptionPane.showMessageDialog(rootPane, "login realizado com sucesso!");
} else {
JOptionPane.showMessageDialog(rootPane, "Erro no login: verifique!");
}
} else if (resp == 2) {
JOptionPane.showMessageDialog(rootPane, "Operação cancelada!");
}
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
new login().setVisible(true);
}
});
}
private javax.swing.JButton botaocancelar;
private javax.swing.JButton botaologar;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JTextField txtlogin;
private javax.swing.JPasswordField txtsenha;
public class Interface_Grafica extends JFrame{
private JMenuItem menuItemCliente = new JMenuItem("Cliente");
private JMenuItem menuItemFornecedor = new JMenuItem("Fornecedor");
private JMenuItem menuItemProduto = new JMenuItem("Produto");
private JMenuItem menuItemFechar = new JMenuItem("Fechar");
private JMenuItem menuItemPedido_Vendas = new JMenuItem("Pedido de Vendas");
private JMenuItem menuItemCancelar_vendas = new JMenuItem("Cancelar Ped. de Vendas");
private JMenuItem menuItemEnvia_Caixa = new JMenuItem("Enviar Ped. para o Caixa");
private JMenuItem menuItemPedido_Pendente = new JMenuItem("Ped. Pendente por Produto");
private JMenuItem menuItemLocalizar = new JMenuItem("Localizar Pedido");
//Gerar Menus
private JMenu menuCadastro = new JMenu("Cadastro");
private JMenu menuVendas = new JMenu("Vendas");
private JMenu menuConsulta = new JMenu("Consulta");
private JMenu menuEstoque = new JMenu("Estoque");
private JMenu menuCliente = new JMenu("Cliente");
private JMenu menuRelatorio = new JMenu("Relatorio");
private JMenuBar menuBar = new JMenuBar();
public Interface_Grafica(){
setTitle("Servidor Gabé e Tinho");
menuCadastro.add(menuItemCliente);
menuCadastro.add(menuItemFornecedor);
menuCadastro.add(menuItemProduto);
menuCadastro.addSeparator();
menuCadastro.add(menuItemFechar);
menuItemCliente.setText("Cadastro de Cliente");
menuItemCliente.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
// chama o frame
new login.Cad_Cliente();
}
});
menuVendas .add(menuItemPedido_Vendas);
menuVendas .add(menuItemCancelar_vendas);
menuVendas .add(menuItemEnvia_Caixa);
menuVendas .addSeparator();
menuVendas .add(menuItemLocalizar);
menuConsulta .add(menuEstoque);
menuConsulta .add(menuCliente);
menuConsulta .add(menuItemEnvia_Caixa);
menuConsulta .addSeparator();
menuConsulta .add(menuItemLocalizar);
menuEstoque .add(menuItemPedido_Pendente);
menuBar .add(menuCadastro);
menuBar .add(menuVendas);
menuBar .add(menuConsulta);
menuBar .add(menuRelatorio);
this.setJMenuBar(menuBar);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setSize(800, 600);
setLocation(150,100);
this.setVisible(true);
}
}
public class Cad_Cliente extends JFrame {
JButton button1 = new JButton("Novo");
JButton button2 = new JButton("Salvar");
JButton button3 = new JButton("Abrir");
JButton button4 = new JButton("Editar");
public Cad_Cliente() {
Container pane = this.getContentPane();
setTitle("Cadastro de Cliente");
pane.setLayout(new FlowLayout(FlowLayout.CENTER));
pane.add(button1);
pane.add(button2);
pane.add(button3);
pane.add(button4);
this.setSize(800, 550);
setLocation(150,150);
this.setVisible(true);
button1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
// chama o frame
new login.Nov_Cliente();
}
});
}
}
public class Nov_Cliente extends JFrame{
JLabel lb_Nome, lb_Endereço, lb_Telefone, lb_CPF, lb_DataNasc;
JTextField tf_Nome, tf_Endereço, tf_Telefone, tf_CPF;
JButton bt_Salvar, bt_Cancelar, bt_Sair;
JComboBox comboMes = new JComboBox();
JComboBox comboAno = new JComboBox();
JComboBox comboCidade = new JComboBox();
JComboBox comboEstado = new JComboBox();
public Nov_Cliente(){
setTitle("Cadastro de um Novo Cliente");
setSize(800,600);
setLocation(150,100);
setResizable(false);
getContentPane().setLayout(null);
lb_Nome = new JLabel("Nome Completo do Cliente.: ");
lb_Endereço = new JLabel("Endereço Completo.: ");
lb_Telefone = new JLabel("Telefone com o DDD.: ");
lb_CPF = new JLabel("CPF.: ");
lb_DataNasc = new JLabel("Data de Nascimento.: ");
bt_Salvar = new JButton("Salvar");
bt_Cancelar = new JButton("Cancelar");
bt_Sair = new JButton("Sair");
tf_Nome = new JTextField();
tf_Endereço = new JTextField();
tf_Telefone = new JTextField();
tf_CPF = new JTextField();
lb_Nome .setBounds( 10,60,300,20);
tf_Nome .setBounds(240,60,300,20);
lb_Endereço .setBounds( 10,100,300,20);
tf_Endereço .setBounds(240,100,300,20);
comboCidade .setBounds(550,100,140,20);
comboEstado .setBounds(700,100, 60,20);
lb_Telefone .setBounds( 10,140,300,20);
tf_Telefone .setBounds(240,140,140,20);
lb_CPF .setBounds( 10,180,300,20);
tf_CPF .setBounds(240,180,140,20);
lb_DataNasc .setBounds( 10,210,300,20);
comboMes .setBounds(240,210,140,20);
comboAno .setBounds(400,210,140,20);
bt_Salvar .setBounds( 20,320,180,30);
bt_Cancelar .setBounds( 220,320,180,30);
bt_Sair .setBounds( 420,320,160,30);
lb_Nome .setFont(new Font("Arial", Font.BOLD,14));
lb_Endereço .setFont(new Font("Arial", Font.BOLD,14));
lb_Telefone .setFont(new Font("Arial", Font.BOLD,14));
lb_CPF .setFont(new Font("Arial", Font.BOLD,14));
lb_DataNasc .setFont(new Font("Arial", Font.BOLD,14));
//Caixa Data de Nascimento
comboMes.addItem("JANEIRO"); comboMes.addItem("FEVEIRO");
comboMes.addItem("MARÇO"); comboMes.addItem("ABRIL");
comboMes.addItem("MAIO"); comboMes.addItem("JUNHO");
comboMes.addItem("JULHO"); comboMes.addItem("AGOSTO");
comboMes.addItem("SETEMBRO"); comboMes.addItem("OUTUBRO");
comboMes.addItem("NOVEMBRO"); comboMes.addItem("DEZEMBRO");
comboCidade.addItem("Jaboatão"); comboCidade.addItem("Recife");
comboEstado.addItem("AL"); comboEstado.addItem("PE");
for (int i = 1940; i <= 2010; i++) comboAno.addItem(i);
comboAno.setEditable(true);
Container pane = this.getContentPane();
getContentPane().add(lb_Nome);
getContentPane().add(tf_Nome);
getContentPane().add(lb_Endereço);
getContentPane().add(lb_DataNasc);
getContentPane().add(tf_Endereço);
getContentPane().add(lb_Telefone);
getContentPane().add(tf_Telefone);
getContentPane().add(lb_CPF);
getContentPane().add(tf_CPF);
pane.add(bt_Salvar);
pane.add(bt_Cancelar);
pane.add(bt_Sair);
pane.add(comboMes);
pane.add(comboAno);
pane.add(comboCidade);
pane.add(comboEstado);
bt_Cancelar.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
login.Nov_Cliente.this.dispose();
}
});
this.setVisible(true);
this.setSize(800, 480);
setLocation(150,220);
this.setResizable(false);
this.setVisible(true);
}
}
}
Classe conecta
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
public class conexao {
Connection conexao;
Statement statement;
ResultSet resultado;
public boolean conecta() {
String driver = "com.mysql.jdbc.Driver";
String host = "LocalHost";
String usuario = "root";
String senha = "123456";
String banco = "Server";
String url = "jdbc:mysql://" + host + ":3306/" + banco;
try {
Class.forName(driver);
conexao = DriverManager.getConnection(url, usuario, senha);
System.out.println("Conectou");
return true;
} catch (SQLException erro) {
JOptionPane.showMessageDialog(null, "Erro na conexão. Verifique! " + erro.getMessage());
} catch (ClassNotFoundException ex) {
JOptionPane.showMessageDialog(null, "Erro na conexão. Verifique! " + ex.getMessage());
}
return false;
}
public void desconectar() {
try {
conexao.close();
System.out.println("Desconectou");
} catch (SQLException ex) {
System.out.println("Conexão não fechada!");
}
}
public void consultar(String sql) {
try {
statement = conexao.createStatement();
resultado = statement.executeQuery(sql);
System.out.println("sql executado com sucesso!");
} catch (SQLException ex) {
System.out.println("Erro na execução do sql !");
}
}
public void alterar(String sql) {
try {
statement = conexao.createStatement();
statement.executeUpdate(sql);
System.out.println("sql executado com sucesso!");
} catch (SQLException ex) {
System.out.println("Erro na execução do sql !" + ex.getMessage());
}
}
}