Discussoes de Programacao e Tecnologia

Fazer um evento Click para meu jList

4 respostas
G
gtordin

Boa Tarde,
Estou com um probleminha, estou buscando no meu Banco de dados(MySql) os nomes das empresas ativas e desativadas e colocando dentro da minha jList1, só que não sei fazer um evento de click para quando clicar em cima do nome deste representante dentro do meu jList1 e aparecer os dados dele nos meus jTextField.

irei colocar abaixo o código que ja foi feito.

package Principal;

import Nova_Empresa.PNovo;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.DefaultListModel;

import javax.swing.JList;

import javax.swing.JMenuBar;

import javax.swing.JOptionPane;

public class Rodrigo extends javax.swing.JFrame {

public Rodrigo() {
    initComponents();
}

@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

    jButton5 = new javax.swing.JButton();
    jButton6 = new javax.swing.JButton();
    jScrollPane1 = new javax.swing.JScrollPane();
    jList1 = new javax.swing.JList();
    jButton7 = new javax.swing.JButton();
    jButton8 = new javax.swing.JButton();
    jTabbedPane1 = new javax.swing.JTabbedPane();
    jPanel1 = new javax.swing.JPanel();
    jTextField4 = new javax.swing.JTextField();
    jTextField5 = new javax.swing.JTextField();
    jTextField6 = new javax.swing.JTextField();
    jTextField7 = new javax.swing.JTextField();
    jScrollPane2 = new javax.swing.JScrollPane();
    jTextArea1 = new javax.swing.JTextArea();
    jTextField9 = new javax.swing.JTextField();
    jTextField10 = new javax.swing.JTextField();
    jTextField11 = new javax.swing.JTextField();
    jButton3 = new javax.swing.JButton();
    jButton4 = new javax.swing.JButton();
    jButton10 = new javax.swing.JButton();
    jTextField3 = new javax.swing.JTextField();
    jTextField8 = new javax.swing.JTextField();
    jButton11 = new javax.swing.JButton();
    jTextField2 = new javax.swing.JTextField();
    jLabel2 = new javax.swing.JLabel();
    jPanel2 = new javax.swing.JPanel();
    jButton9 = new javax.swing.JButton();
    jLabel4 = new javax.swing.JLabel();
    jLabel5 = new javax.swing.JLabel();
    jLabel6 = new javax.swing.JLabel();
    jLabel7 = new javax.swing.JLabel();
    jTextField12 = new javax.swing.JTextField();
    jTextField16 = new javax.swing.JTextField();
    jTextField14 = new javax.swing.JTextField();
    jTextField15 = new javax.swing.JTextField();
    jScrollPane3 = new javax.swing.JScrollPane();
    jTextArea2 = new javax.swing.JTextArea();
    jLabel8 = new javax.swing.JLabel();
    jLabel3 = new javax.swing.JLabel();
    jButton1 = new javax.swing.JButton();
    jTextField1 = new javax.swing.JTextField();
    jButton2 = new javax.swing.JButton();
    jLabel1 = new javax.swing.JLabel();

    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    setMinimumSize(new java.awt.Dimension(1024, 768));
    setUndecorated(true);
    getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

    jButton5.setBackground(new java.awt.Color(255, 0, 0));
    jButton5.setFont(new java.awt.Font("Tempus Sans ITC", 1, 18)); // NOI18N
    jButton5.setForeground(new java.awt.Color(255, 255, 255));
    jButton5.setText("X");
    jButton5.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
    jButton5.setHideActionText(true);
    jButton5.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton5ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton5, new org.netbeans.lib.awtextra.AbsoluteConstraints(940, 20, 70, 30));

    jButton6.setText("Nova Empresa");
    jButton6.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
    jButton6.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton6ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton6, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 710, 260, 40));

    jScrollPane1.setViewportView(jList1);

    getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 150, 260, 560));

    jButton7.setText("Ativos");
    jButton7.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
    jButton7.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton7ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton7, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 130, 100, 20));

    jButton8.setText("Desativados");
    jButton8.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
    jButton8.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton8ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton8, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 130, 100, 20));

    jTabbedPane1.setTabLayoutPolicy(javax.swing.JTabbedPane.SCROLL_TAB_LAYOUT);
    jTabbedPane1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

    jPanel1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
    jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

    jTextField4.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField4ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField4, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 70, 240, -1));

    jTextField5.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField5ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField5, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 110, 230, -1));

    jTextField6.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField6ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField6, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 150, 230, -1));

    jTextField7.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField7ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField7, new org.netbeans.lib.awtextra.AbsoluteConstraints(130, 270, 220, -1));

    jTextArea1.setColumns(20);
    jTextArea1.setRows(5);
    jScrollPane2.setViewportView(jTextArea1);

    jPanel1.add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(30, 400, 300, 110));

    jTextField9.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField9ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField9, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 70, 160, -1));
    jPanel1.add(jTextField10, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 110, 160, -1));

    jTextField11.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField11ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField11, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 270, 140, -1));

    jButton3.setText("Alterar");
    jPanel1.add(jButton3, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 520, 80, -1));

    jButton4.setText("Excluir");
    jPanel1.add(jButton4, new org.netbeans.lib.awtextra.AbsoluteConstraints(560, 520, 80, -1));

    jButton10.setText("Ativar");
    jButton10.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton10ActionPerformed(evt);
        }
    });
    jPanel1.add(jButton10, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 380, 80, -1));

    jTextField3.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField3ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField3, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 10, 210, -1));

    jTextField8.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField8ActionPerformed(evt);
        }
    });
    jPanel1.add(jTextField8, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 20, 160, -1));

    jButton11.setText("Desativar");
    jButton11.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton11ActionPerformed(evt);
        }
    });
    jPanel1.add(jButton11, new org.netbeans.lib.awtextra.AbsoluteConstraints(560, 380, -1, -1));
    jPanel1.add(jTextField2, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 10, 60, -1));

    jLabel2.setIcon(new javax.swing.ImageIcon("C:\\Users\\gtordin\\Desktop\\Programação\\dados_cadastrais.gif")); // NOI18N
    jPanel1.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, -1, 560));

    jTabbedPane1.addTab("Dados Cadastrais", jPanel1);

    jPanel2.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

    jButton9.setText("Alterar");
    jPanel2.add(jButton9, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 530, -1, -1));

    jLabel4.setText("Contato");
    jPanel2.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 20, -1, -1));

    jLabel5.setText("Telefone");
    jPanel2.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 60, -1, -1));

    jLabel6.setText("Telefone");
    jPanel2.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 110, -1, -1));

    jLabel7.setText("E-mail");
    jPanel2.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 160, -1, -1));
    jPanel2.add(jTextField12, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 20, 170, -1));
    jPanel2.add(jTextField16, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 160, 170, -1));

    jTextField14.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jTextField14ActionPerformed(evt);
        }
    });
    jPanel2.add(jTextField14, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 60, 170, -1));
    jPanel2.add(jTextField15, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 110, 170, -1));

    jTextArea2.setColumns(20);
    jTextArea2.setRows(5);
    jScrollPane3.setViewportView(jTextArea2);

    jPanel2.add(jScrollPane3, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 270, 500, 230));

    jLabel8.setText("Descrições");
    jPanel2.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 250, -1, -1));

    jLabel3.setIcon(new javax.swing.ImageIcon("C:\\Users\\gtordin\\Desktop\\Programação\\departamento_compra.gif")); // NOI18N
    jPanel2.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, -1, -1));

    jTabbedPane1.addTab("Dep. Financeiro", jPanel2);

    getContentPane().add(jTabbedPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(330, 110, -1, 590));
    jTabbedPane1.getAccessibleContext().setAccessibleName("");

    jButton1.setText("Todas as Empresas");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton1ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(70, 100, 170, 30));
    getContentPane().add(jTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 20, 210, 30));

    jButton2.setText("Procurar");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            jButton2ActionPerformed(evt);
        }
    });
    getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 20, 170, 30));

    jLabel1.setIcon(new javax.swing.ImageIcon("C:\\Users\\gtordin\\Desktop\\Programação\\Projeto_Rodrigo.gif")); // NOI18N
    getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1030, 770));

    java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
    setBounds((screenSize.width-1024)/2, (screenSize.height-768)/2, 1024, 768);
}// </editor-fold>

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    System.exit(0);// TODO add your handling code here:
}                                        

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                         
new PNovo().setVisible(true);

}                                        

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    
    Connection con ;  
    Statement stmt ;  
    ResultSet rs = null;
    String lista = null;
    String newempresa = null;
    JList elemtList;
        
    try {
            
        
        Class.forName("org.gjt.mm.mysql.Driver");
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo", "123");
        stmt = (Statement) con.createStatement();
        rs = (ResultSet) stmt.executeQuery("SELECT empresa_nome FROM nova_empresa WHERE empresa_ativo = 1 Order By empresa_nome");
         
        DefaultListModel m = new DefaultListModel();
        
        while (rs.next()) {

        
        m.addElement(rs.getObject("empresa_nome"));
        
        jList1.setModel(m);
        
                }
        
        }catch (Exception e) {
        e.printStackTrace();
        JOptionPane.showMessageDialog(null,"Erro na Busca");
        }
}                                        

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
         Connection con ;  
    Statement stmt ;  
    ResultSet rs = null;
    String lista = null;
    String newempresa = null;
    JList elemtList;
        
    try {
            
        
        Class.forName("org.gjt.mm.mysql.Driver");
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo", "123");
        stmt = (Statement) con.createStatement();
        rs = (ResultSet) stmt.executeQuery("SELECT empresa_nome FROM nova_empresa WHERE empresa_ativo = 0  Order By empresa_nome");
         
        DefaultListModel m = new DefaultListModel();
        
        while (rs.next()) {

        
        m.addElement(rs.getObject("empresa_nome"));
        jList1.setModel(m);
        
                }
        
        }catch (Exception e) {
        e.printStackTrace();
        JOptionPane.showMessageDialog(null,"Erro na Busca");
        } 
}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

    Connection con ;  
    Statement stmt ;  
    ResultSet rs = null;
    String lista = null;
    String newempresa = null;
    JList elemtList;
        
    try {
            
        
        Class.forName("org.gjt.mm.mysql.Driver");
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo", "123");
        stmt = (Statement) con.createStatement();
        rs = (ResultSet) stmt.executeQuery("SELECT empresa_nome FROM nova_empresa Order By empresa_nome");
         
        DefaultListModel m = new DefaultListModel();
        
        while (rs.next()) {

        
        m.addElement(rs.getObject("empresa_nome"));
        jList1.setModel(m);
       
       
                
            }
        
        }catch (Exception e) {
        e.printStackTrace();
        JOptionPane.showMessageDialog(null,"Erro na Busca");
        }
}

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
     
        Connection con = null;
        Statement stmt = null;  
        ResultSet rs = null;  
        String empresa = null;
        String valor = jTextField1.getText();
        
        try{
        Class.forName("org.gjt.mm.mysql.Driver");
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo", "123");
        stmt = (Statement) con.createStatement();
        rs = (ResultSet) stmt.executeQuery("SELECT empresa_nome FROM nova_empresa WHERE empresa_nome Like '%" + valor + "%' ORDER BY empresa_nome " );
        DefaultListModel m = new DefaultListModel();
        

               while (rs.next()) {

            m.addElement(rs.getString("empresa_nome"));
            jList1.setModel(m);

                }
            
         
        } catch (Exception e) {
            
                e.printStackTrace();
                
                
            }
}

private void jTextField14ActionPerformed(java.awt.event.ActionEvent evt) {

    // TODO add your handling code here:}

private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField9ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField8ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jTextField11ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

public static void main(String args[]) {

    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 ex) {
        java.util.logging.Logger.getLogger(Rodrigo.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
    } catch (InstantiationException ex) {
        java.util.logging.Logger.getLogger(Rodrigo.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
    } catch (IllegalAccessException ex) {
        java.util.logging.Logger.getLogger(Rodrigo.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
    } catch (javax.swing.UnsupportedLookAndFeelException ex) {
        java.util.logging.Logger.getLogger(Rodrigo.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
    }
    //</editor-fold>

    java.awt.EventQueue.invokeLater(new Runnable() {

        public void run() {
            new Rodrigo().setVisible(true);

        }
    });
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton10;
private javax.swing.JButton jButton11;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JButton jButton8;
private javax.swing.JButton jButton9;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JList jList1;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTextArea jTextArea1;
private javax.swing.JTextArea jTextArea2;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField10;
private javax.swing.JTextField jTextField11;
private javax.swing.JTextField jTextField12;
private javax.swing.JTextField jTextField14;
private javax.swing.JTextField jTextField15;
private javax.swing.JTextField jTextField16;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JTextField jTextField4;
private javax.swing.JTextField jTextField5;
private javax.swing.JTextField jTextField6;
private javax.swing.JTextField jTextField7;
private javax.swing.JTextField jTextField8;
private javax.swing.JTextField jTextField9;
// End of variables declaration

}

Alura Git Flow: entenda o que é, como e quando utilizar Entenda o que é Git Flow, como funciona seu fluxo com branches como Master, Develop, Feature, Release e Hotfix, além de vantagens e desvantagens.

4 Respostas

ViniGodoy
ViniGodoy

Assim não dá para ler o código. Use essas dicas:
http://www.guj.com.br/java/50115-voce-e-novo-no-guj-vai-criar-um-topico-e-colar-seu-codigo-fonte-leia-aqui-antes-por-favor

G
gtordin 
meu evento de click está assim:

private void jList1MouseClicked(java.awt.event.MouseEvent evt) {

Connection con;

Statement stmt; 
    
    ResultSet rs;  

    try{
        
        Class.forName("org.gjt.mm.mysql.Driver");
        
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo","123");
        
        stmt = null;
        
        stmt = (Statement) con.createStatement();

        rs = (ResultSet) stmt.executeQuery("SELECT empresa_id, empresa_nome, empresa_nomefantasia, empresa_cnpj, empresa_contato, empresa_estado, empresa_cidade, empresa_bairro, empresa_endereço, empresa_cep1, empresa_cep2, empresa_observacoes FROM nova_empresa WHERE '"+jList1.getModel() +"' ");
        
        while (rs.next()) {
           
            jTextField1.setText(rs.getString(1));
            
            jTextField2.setText(rs.getString(2));
            
            jTextField3.setText(rs.getString(3));
            
            jTextField4.setText(rs.getString(4));
            
            jTextField5.setText(rs.getString(5));
            
            jTextField6.setText(rs.getString(6));
            
            jTextField7.setText(rs.getString(7));
            
            jTextField8.setText(rs.getString(8));
            
            jTextField9.setText(rs.getString(9));
            
            jTextField10.setText(rs.getString(10));
            
            jTextField11.setText(rs.getString(11));
            
            jTextArea1.setText(rs.getString(12));
           
            /*
            jTextField12.setText(rs.getString(2));
            jTextField13.setText(rs.getString(2));
            jTextField14.setText(rs.getString(1));
            jTextField15.setText(rs.getString(2));
            
             
             */
        }
    
    } catch (Exception e) {e.printStackTrace();

    JOptionPane.showMessageDialog(null,"Erro com a conexão, Tente Novamente");
    
    }

Só não sei como falar para o banco de dados (Mysql) no WHERE quando clicar ele puxar os dados do cliente pelo nome que está no jList1

G
gtordin 
Pronto, depois de um tempo de pesquisa consigui achar como resolve este problema.

Irei deixar a solução a baixo.

private void jList1MouseClicked(java.awt.event.MouseEvent evt) {

Connection con;

Statement stmt; 
    
    ResultSet rs;  

    try{
        
        Class.forName("org.gjt.mm.mysql.Driver");
        
        con = (Connection) java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/projeto_rodrigo", "gustavo","123");
        
        stmt = null;
        
        stmt = (Statement) con.createStatement();

        rs = (ResultSet) stmt.executeQuery("SELECT empresa_id, empresa_nome, empresa_nomefantasia, empresa_cnpj, empresa_estado, empresa_cidade, empresa_bairro, empresa_endereço, empresa_cep1, empresa_cep2, empresa_observacoes, empresa_contato, empresa_tel1, empresa_tel2, empresa_tel3, empresa_departamento FROM nova_empresa WHERE empresa_nome = '"+jList1.getSelectedValue()+"' ");
        
        while (rs.next()) {
           
            jTextField1.setText(rs.getString(1));
            
            jTextField2.setText(rs.getString(2));
            
            jTextField3.setText(rs.getString(3));
            
            jTextField4.setText(rs.getString(4));
            
            jTextField5.setText(rs.getString(5));
            
            jTextField6.setText(rs.getString(6));
            
            jTextField7.setText(rs.getString(7));
            
            jTextField8.setText(rs.getString(8));
            
            jTextField9.setText(rs.getString(9));
            
            jTextField10.setText(rs.getString(10));

            jTextArea1.setText(rs.getString(11));

            jTextField12.setText(rs.getString(12));
            
            jTextField13.setText(rs.getString(13));
            
            jTextField14.setText(rs.getString(14));
            
            jTextField15.setText(rs.getString(15));
            
            jTextField16.setText(rs.getString(16));
            
             
           
        }
    
    } catch (Exception e) {e.printStackTrace();

    JOptionPane.showMessageDialog(null,"Erro com a conexão, Tente Novamente");
    
    }
}
G
gtordin

Agora gostaria de saber como faz um botão para alteração dos dados no banco de dados

Criado 20 de abril de 2012
Ultima resposta 23 de abr. de 2012
Respostas 4
Participantes 2

Topicos relacionados

Componente de forum 4 respostas Consultar CPF pelo nome na Receita Federal 5 respostas Pegadinhas que se fazem com os pobres estagiários 62 respostas [Resolvido] Como comparar Strings em C? 6 respostas Converter pixels para centímetros 9 respostas
Lumina Lumina: a IA que te traz resultados Prompts prontos por especialistas. Resolva seus problemas de verdade.
Fiap Graduacao em Tecnologia — FIAP Analise e Desenvolvimento de Sistemas, Engenharia de Software e mais