JList não preenche com dados do banco

4 de outubro de 2011 4 respostas

jhuser 4 de outubro de 2011

Galera, to com um problema que não consigo descobrir o motivo, não abre a JList3 com os dados da tabela.

Se alguém puder me ajudar, agradeço muito.

.import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.DefaultListModel;

import javax.swing.JOptionPane;

import javax.swing.SwingUtilities;

import javax.swing.UIManager;

public class Carga extends javax.swing.JFrame {

private javax.swing.JList jList1;
private javax.swing.JList jList2;
private javax.swing.JList jList3;
private javax.swing.JList jList4;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JScrollPane jScrollPane4;
private DefaultListModel lista1 = new DefaultListModel();
private DefaultListModel lista3 = new DefaultListModel();
ConnectionDB con = new ConnectionDB("system", "12345");

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

    jScrollPane1 = new javax.swing.JScrollPane();
    jList1 = new javax.swing.JList();
    jScrollPane2 = new javax.swing.JScrollPane();
    jList2 = new javax.swing.JList();
    jScrollPane3 = new javax.swing.JScrollPane();
    jList3 = new javax.swing.JList();
    jScrollPane4 = new javax.swing.JScrollPane();
    jList4 = new javax.swing.JList();

    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

    loadJList1();
    jList1 = new javax.swing.JList(lista1);
    jScrollPane1.setViewportView(jList1);
    
    loadJList3();
    jList3 = new javax.swing.JList(lista3);
    jScrollPane3.setViewportView(jList3);
    
    jList2.setModel(new javax.swing.AbstractListModel() {

        String[] strings = {"Item 1", "Item 2", "Item 3", "Item 4", "Item 5"};

        public int getSize() {
            return strings.length;
        }

        public Object getElementAt(int i) {
            return strings[i];
        }
    });
    jScrollPane2.setViewportView(jList2);

    jList4.setModel(new javax.swing.AbstractListModel() {

        String[] strings = {"Item 1", "Item 2", "Item 3", "Item 4", "Item 5"};

        public int getSize() {
            return strings.length;
        }

        public Object getElementAt(int i) {
            return strings[i];
        }
    });
    jScrollPane4.setViewportView(jList4);

    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(27, 27, 27).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 138, Short.MAX_VALUE).addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 138, Short.MAX_VALUE)).addGap(57, 57, 57).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 139, Short.MAX_VALUE).addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 139, Short.MAX_VALUE)).addGap(39, 39, 39)));
    layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(20, 20, 20).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)).addGap(27, 27, 27).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jScrollPane4, 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>
public static void main(String args[]) {
    /* Create and display the form */
    java.awt.EventQueue.invokeLater(new Runnable() {

        public void run() {
            new Carga().setVisible(true);
        }
    });
}

public void lookandfeel() {
    try {
        UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
        SwingUtilities.updateComponentTreeUI(this);
    } catch (Exception erro) {
        JOptionPane.showMessageDialog(null, erro);
    }
}

public void loadJList1() {
    Connection conn = con.conecta();
    try {
        Statement Stmt = conn.createStatement();
        ResultSet RS = Stmt.executeQuery("Select * from all_tables");
        int i = 0;
        while (RS.next()) {
            lista1.addElement(RS.getString("table_name"));
        }
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta!",
                "Mensagem", JOptionPane.ERROR_MESSAGE);
    }
}

public void loadJList3() {
    Connection conn = con.conecta();
    try {
        Statement Stmt = conn.createStatement();
        ResultSet rs = Stmt.executeQuery("select * from empresas");
        int i = 0;
        while (rs.next()) {
            lista3.addElement(rs.getString("emp_nome"));

        }
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta loadJList3!",
                "Mensagem", JOptionPane.ERROR_MESSAGE);
    }
}

}

4 Respostas

JoaoBluSCBR 5 de out. de 2011

Primeiramente e sempre, lembre de usar as tags Code e /Code, antes e depois do código para que
ele apareça no formato correto, facilitando em muito a leitura.

Com essa tua classe somente nada aparenta acontecer. A classe eh simples e elementar.
Teus métodos também são básicos.

Tudo indica que deve ser alguma informacao na String do Select, nome de campos, ou de tabelas, algo assim.

No catch da Exceção ao invés de colocar uma mensagem tola dizendo que houve erro e nao serve para nada, faça um

System.out.println do erro, assim ele vai te dizer o que estah fazendo de erro.

Excessões são importantes principalmente durante o processo de programação, colocar um JOptionPane dizendo
que houve erro não ajuda em nada.

Coloque no post o código da classe que chama esses metodos da List3, podem ser la que nao esteja correto.

Ou não houve erro?

Se não houve, então tua tabela está vazia, ou voce estah acessando um copia vazia do banco.

jhuser 10 de out. de 2011

Bom dia!

é…realmente vc estava certo, testei esse final de semana o código e funcionou, só que precisei
colocar mais componentes na tela, e como não sei mexer com swing, fiz pelo netbeans e depois copiei e colei no meu código
em uma classe normal, só que agora o jList não funciona, fiquei sabado e domingo o dia todo e não consegui resolver.

Poderia me ajudar mais uma vez ?

abraços.

public class Carga extends javax.swing.JFrame {
   
    private javax.swing.JList jList1;
    private javax.swing.JList jList2;
    private javax.swing.JList jList3;
    private javax.swing.JList jList4;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    final DefaultListModel lista1 = new DefaultListModel();
    final DefaultListModel lista2 = new DefaultListModel();    
    private DefaultListModel lista3 = new DefaultListModel();
    private DefaultListModel lista4 = new DefaultListModel();
    private Table table;
    ConnectionDB con = new ConnectionDB("scott", "123456");
    private JButton JButtonAdd;
    private Object[] tabela;
    private javax.swing.JButton jButton1;
    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.JDialog jDialog1;
    private javax.swing.JFormattedTextField jFormattedTextField1;
    private javax.swing.JFormattedTextField jFormattedTextField2;
    private javax.swing.JFrame jFrame1;
    private javax.swing.JFrame jFrame2;
    private javax.swing.JFrame jFrame3;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPopupMenu jPopupMenu1;
    
    public Carga() {
        initComponents();
        lookandfeel();
        setSize(800,600);
    }
    @SuppressWarnings("unchecked")
    private void initComponents() {
       
        jScrollPane1 = new javax.swing.JScrollPane();
        jList1 = new javax.swing.JList();
        jScrollPane2 = new javax.swing.JScrollPane();
        jList2 = new javax.swing.JList();
        jScrollPane3 = new javax.swing.JScrollPane();
        jList3 = new javax.swing.JList();
        jScrollPane4 = new javax.swing.JScrollPane();
        jList4 = new javax.swing.JList();
        jFrame1 = new javax.swing.JFrame();
        jFrame2 = new javax.swing.JFrame();
        jFrame3 = new javax.swing.JFrame();
        jDialog1 = new javax.swing.JDialog();
        jPopupMenu1 = new javax.swing.JPopupMenu();
        jButton1 = new javax.swing.JButton();
        jFormattedTextField1 = new javax.swing.JFormattedTextField();
        jLabel1 = new javax.swing.JLabel();
        jFormattedTextField2 = new javax.swing.JFormattedTextField();
        jLabel2 = new javax.swing.JLabel();
        jButton3 = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton6 = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
          
        jLabel3.setText("PROCEDURES");
        
        jLabel3.setBounds(27, 139, 67, 14);

        jLabel4.setText("EMPRESAS");
        
        jLabel4.setBounds(30, 340, 52, 14);
      
        javax.swing.GroupLayout jFrame2Layout = new javax.swing.GroupLayout(jFrame2.getContentPane());
        jFrame2.getContentPane().setLayout(jFrame2Layout);
        jFrame2Layout.setHorizontalGroup(
            jFrame2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 400, Short.MAX_VALUE)
        );
        jFrame2Layout.setVerticalGroup(
            jFrame2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 300, Short.MAX_VALUE)
        );

        javax.swing.GroupLayout jFrame3Layout = new javax.swing.GroupLayout(jFrame3.getContentPane());
        jFrame3.getContentPane().setLayout(jFrame3Layout);
        jFrame3Layout.setHorizontalGroup(
            jFrame3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 400, Short.MAX_VALUE)
        );
        jFrame3Layout.setVerticalGroup(
            jFrame3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 300, Short.MAX_VALUE)
        );

        javax.swing.GroupLayout jDialog1Layout = new javax.swing.GroupLayout(jDialog1.getContentPane());
        jDialog1.getContentPane().setLayout(jDialog1Layout);
        jDialog1Layout.setHorizontalGroup(
            jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 400, Short.MAX_VALUE)
        );
        
        jDialog1Layout.setVerticalGroup(
            jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 300, Short.MAX_VALUE)
        );

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        getContentPane().setLayout(null);

        jButton1.setText("Add");
        getContentPane().add(jButton1);
        jButton1.setBounds(300, 150, 71, 23);

        jFormattedTextField1.setText("jFormattedTextField1");
        getContentPane().add(jFormattedTextField1);
        jFormattedTextField1.setBounds(98, 47, 109, 20);

        jLabel1.setText("Data Inicial: ");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(27, 50, 60, 14);

        jFormattedTextField2.setText("jFormattedTextField2");
        getContentPane().add(jFormattedTextField2);
        jFormattedTextField2.setBounds(98, 86, 109, 20);

        jLabel2.setText("Data Final:");
        getContentPane().add(jLabel2);
        jLabel2.setBounds(27, 92, 52, 14);

        jButton3.setText("Add");
        getContentPane().add(jButton3);
        jButton3.setBounds(300, 340, 71, 23);

        jButton4.setText("Remove");
        getContentPane().add(jButton4);
        jButton4.setBounds(300, 370, 71, 23);

        jButton5.setText("Remove");
        getContentPane().add(jButton5);
        jButton5.setBounds(300, 180, 71, 23);

        jButton2.setText("Executar");
        getContentPane().add(jButton2);
        jButton2.setBounds(545, 484, 75, 23);

        jButton6.setText("Cancelar");
        jButton6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton6ActionPerformed(evt);
            }
        });
        
        getContentPane().add(jButton6);
        jButton6.setBounds(464, 484, 75, 23);

        loadJList1();
        jList1 = new javax.swing.JList(lista1);
        //getContentPane().add(jList1);
        jScrollPane1.setViewportView(jList1);
        jList1.setBounds(545, 484, 75, 23);
        getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(310, 110, 190, 180));
        
        loadJList2();
        jList2 = new javax.swing.JList(lista2);
        jScrollPane2.setViewportView(jList2);
        getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 110, 190, 180));
        
        loadJList3();
        jList3 = new javax.swing.JList(lista3);
        jScrollPane3.setViewportView(jList3);
        
        loadJList4();
        jList4 = new javax.swing.JList(lista4);
        jScrollPane4.setViewportView(jList4);
       
  
    }
 
    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        dispose();   
    } 
    
    private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
        
    }
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                Carga c = new Carga();
                c.setVisible(true);
            }
        });
    }

    public void lookandfeel() {
        try {
            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
            SwingUtilities.updateComponentTreeUI(this);
        } catch (Exception erro) {
            JOptionPane.showMessageDialog(null, erro);
        }
    }

    public void loadJList1() {
        Connection conn = con.conecta();
        try {
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("Select * from all_tables");
            table = new Table();
            int i = 0;
            
            List list = new ArrayList();
            while (rs.next()) {

               list.add(rs.getString("table_name"));
                              
               lista1.addElement(list.get(i));
               
            }            
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta!",
                    "Mensagem", JOptionPane.ERROR_MESSAGE);
        }
    }
    public void loadJList2() {
        
    }

    public void loadJList3() {
        Connection conn = con.conecta();
        try {
            Statement Stmt = conn.createStatement();
            ResultSet rs = Stmt.executeQuery("select * from emp");
            int i = 0;
            while (rs.next()) {
                lista3.addElement(rs.getString("ename"));
            }
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta loadJList3!",
                    "Mensagem", JOptionPane.ERROR_MESSAGE);
        }
    }
    public void loadJList4() {
        
    }
}

JoaoBluSCBR 10 de out. de 2011

Me desculpe cara, mas tá muito dificil de te ajudar sem ter elementos.

Teu código tá muito truncado. A classe é um Frame e você instanciou outros frames e dialogs dentro dela!?!?!?!?!?

E criou vários Scrollpanels e em alguns colocou layout absoluto, que complica muito as coisas. Eh dificil achar
algo só olhando teu código.

Mande um print da tela nomeando componentes e corrigindo o que deveria estar aparecendo onde para
se ter uma ideia do que voce quer.

Nao consigo rodar por que faltam classes. Entao fica muito complicado entender algo assim.

JoaoBluSCBR 10 de out. de 2011

Tirei alguns lixos perdidos no teu código, faz um teste e me dá um retorno com o codigo abaixo:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;

public class Carga extends javax.swing.JFrame {   
     
    private javax.swing.JList jList1;   
    private javax.swing.JList jList2;   
    private javax.swing.JList jList3;   
    private javax.swing.JList jList4;   
    private javax.swing.JScrollPane jScrollPane1;   
    private javax.swing.JScrollPane jScrollPane2;   
    private javax.swing.JScrollPane jScrollPane3;   
    private javax.swing.JScrollPane jScrollPane4;   
    final DefaultListModel lista1 = new DefaultListModel();   
    final DefaultListModel lista2 = new DefaultListModel();       
    private DefaultListModel lista3 = new DefaultListModel();   
    private DefaultListModel lista4 = new DefaultListModel();   
    private Table table;   
    ConnectionDB con = new ConnectionDB("scott", "123456");   
    private JButton JButtonAdd;   
    private Object[] tabela;   
    private javax.swing.JButton jButton1;   
    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.JFormattedTextField jFormattedTextField1;   
    private javax.swing.JFormattedTextField jFormattedTextField2;   
    private javax.swing.JLabel jLabel1;   
    private javax.swing.JLabel jLabel2;   
    private javax.swing.JLabel jLabel3;   
    private javax.swing.JLabel jLabel4;     
       
    public Carga() {   
        initComponents();   
        lookandfeel();   
        setSize(800,600);   
    }   
    @SuppressWarnings("unchecked")   
    private void initComponents() {   
         
        jScrollPane1 = new javax.swing.JScrollPane();   
        jList1 = new javax.swing.JList();   
        jScrollPane2 = new javax.swing.JScrollPane();   
        jList2 = new javax.swing.JList();   
        jScrollPane3 = new javax.swing.JScrollPane();   
        jList3 = new javax.swing.JList();   
        jScrollPane4 = new javax.swing.JScrollPane();   
        jList4 = new javax.swing.JList(); 
          
        jButton1 = new javax.swing.JButton();   
        jFormattedTextField1 = new javax.swing.JFormattedTextField();   
        jLabel1 = new javax.swing.JLabel();   
        jFormattedTextField2 = new javax.swing.JFormattedTextField();   
        jLabel2 = new javax.swing.JLabel();   
        jButton3 = new javax.swing.JButton();   
        jButton4 = new javax.swing.JButton();   
        jButton5 = new javax.swing.JButton();   
        jButton2 = new javax.swing.JButton();   
        jButton6 = new javax.swing.JButton();   
        jLabel3 = new javax.swing.JLabel();   
        jLabel4 = new javax.swing.JLabel();   
             
        jLabel3.setText("PROCEDURES");   
           
        jLabel3.setBounds(27, 139, 67, 14);   
  
        jLabel4.setText("EMPRESAS");   
           
        jLabel4.setBounds(30, 340, 52, 14);   
         
        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);   
        getContentPane().setLayout(null);   
  
        jButton1.setText("Add");   
        getContentPane().add(jButton1);   
        jButton1.setBounds(300, 150, 71, 23);   
  
        jFormattedTextField1.setText("jFormattedTextField1");   
        getContentPane().add(jFormattedTextField1);   
        jFormattedTextField1.setBounds(98, 47, 109, 20);   
  
        jLabel1.setText("Data Inicial: ");   
        getContentPane().add(jLabel1);   
        jLabel1.setBounds(27, 50, 60, 14);   
  
        jFormattedTextField2.setText("jFormattedTextField2");   
        getContentPane().add(jFormattedTextField2);   
        jFormattedTextField2.setBounds(98, 86, 109, 20);   
  
        jLabel2.setText("Data Final:");   
        getContentPane().add(jLabel2);   
        jLabel2.setBounds(27, 92, 52, 14);   
  
        jButton3.setText("Add");   
        getContentPane().add(jButton3);   
        jButton3.setBounds(300, 340, 71, 23);   
  
        jButton4.setText("Remove");   
        getContentPane().add(jButton4);   
        jButton4.setBounds(300, 370, 71, 23);   
  
        jButton5.setText("Remove");   
        getContentPane().add(jButton5);   
        jButton5.setBounds(300, 180, 71, 23);   
  
        jButton2.setText("Executar");   
        getContentPane().add(jButton2);   
        jButton2.setBounds(545, 484, 75, 23);   
  
        jButton6.setText("Cancelar");   
        jButton6.addActionListener(new java.awt.event.ActionListener() {   
            public void actionPerformed(java.awt.event.ActionEvent evt) {   
                jButton6ActionPerformed(evt);   
            }   
        });   
           
        getContentPane().add(jButton6);   
        jButton6.setBounds(464, 484, 75, 23);   
  
        loadJList1();   
        jList1 = new javax.swing.JList(lista1);   
        //getContentPane().add(jList1);   
        jScrollPane1.setViewportView(jList1);   
        jList1.setBounds(545, 484, 75, 23);   
        getContentPane().add(jScrollPane2);   
           
        loadJList2();   
        jList2 = new javax.swing.JList(lista2);   
        jScrollPane2.setViewportView(jList2);   
        getContentPane().add(jScrollPane2);   
           
        loadJList3();   
        jList3 = new javax.swing.JList(lista3);   
        jScrollPane3.setViewportView(jList3);   
           
        loadJList4();   
        jList4 = new javax.swing.JList(lista4);   
        jScrollPane4.setViewportView(jList4);   
         
     
    }   
  
    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        dispose();     
    }   
       
    private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {   
           
    }   
    public static void main(String args[]) {   
        java.awt.EventQueue.invokeLater(new Runnable() {   
  
            public void run() {   
                Carga c = new Carga();   
                c.setVisible(true);   
            }   
        });   
    }   
  
    public void lookandfeel() {   
        try {   
            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");   
            SwingUtilities.updateComponentTreeUI(this);   
        } catch (Exception erro) {   
            JOptionPane.showMessageDialog(null, erro);   
        }   
    }   
  
    public void loadJList1() {   
        Connection conn = con.conecta();   
        try {   
            Statement stmt = conn.createStatement();   
            ResultSet rs = stmt.executeQuery("Select * from all_tables");   
            table = new Table();   
            int i = 0;   
               
            List list = new ArrayList();   
            while (rs.next()) {   
  
               list.add(rs.getString("table_name"));   
                                 
               lista1.addElement(list.get(i));   
                 
            }               
        } catch (SQLException ex) {   
            JOptionPane.showMessageDialog(this, ex.toString());
            //JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta!",   
              //      "Mensagem", JOptionPane.ERROR_MESSAGE);   
        }   
    }   
    public void loadJList2() {   
           
    }   
  
    public void loadJList3() {   
        Connection conn = con.conecta();   
        try {   
            Statement Stmt = conn.createStatement();   
            ResultSet rs = Stmt.executeQuery("select * from emp");   
            int i = 0;   
            while (rs.next()) {   
                lista3.addElement(rs.getString("ename"));   
            }   
        } catch (SQLException ex) {   
            JOptionPane.showMessageDialog(this, ex.toString());
            //JOptionPane.showMessageDialog(null, "Erro ao Executar a Consulta loadJList3!",   
              //      "Mensagem", JOptionPane.ERROR_MESSAGE);   
        }   
    }   
    public void loadJList4() {   
           
    }   
}

Criado 4 de outubro de 2011

Ultima resposta 10 de out. de 2011

Respostas 4

Participantes 2

4 Respostas

Topicos relacionados