why is my JTable not showing up?

[ben riches]

Hello All,
Why is my Jtable not showing up?
Thanks
Ben

import java.awt.event.*;
import java.awt.*; 
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
  public class ComboBoxDemo extends JPanel implements ActionListener {
 
   static Connection conn;
   DatabaseMetaData DMD;
   JComboBox group = new JComboBox();
   JComboBox groupList = new JComboBox();
static JTable tbl1;


    public ComboBoxDemo()  {
group.addActionListener(this);
try  { 

     // Load the database driver
   Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
   String url = "jdbc :-o	 dbc:myproject" ;
    conn = DriverManager.getConnection(url) ;
   DMD=conn .getMetaData();
   ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
   while(rs.next()) {

group.addItem((String)rs.getString(3));
System.out.println(rs);

   }
   rs.close() ;

 } catch (SQLException se ) {
   System.out.println( "SQL Exception: " + se ) ;
 } catch (Exception e ) {
   System.out.println( e ) ;
 }


 
    }
public void actionPerformed(ActionEvent e)  {
String tbl = (String)group.getSelectedItem();
 try {
      Statement st=conn.createStatement();
    st.execute("SELECT * FROM "+tbl+"");
    ResultSet rs=st.getResultSet();
    ResultSetMetaData md=rs.getMetaData();
    groupList.removeAllItems();
   for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
System.out.println(groupList);
    }

   st.close() ;
 } catch (SQLException se ) {
   System.out.println( "SQL Exception: " + se ) ;
 } catch (Exception ex ) {
   System.out.println( ex ) ;
 }
   int j1=10;
String[][] data = new String[j1][2];
      for (int k=0; k<j1; k++){
         String[] row = {"",""};
         data[k] = row;
      }
 String[] colNames = {"Column A", "Column B"};
 tbl1 = new JTable(data, colNames);
 DefaultCellEditor editor = new DefaultCellEditor(groupList);
 DefaultCellEditor editor2 = new DefaultCellEditor(group);
 TableColumnModel tcm = tbl1.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
tcm.getColumn(1).setCellEditor(editor);
tcm.getColumn(0).setPreferredWidth(200);
   tcm.getColumn(1).setPreferredWidth(100);
tbl1.setRowHeight(20);
    tbl1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    tbl1.setPreferredScrollableViewportSize(tbl1.getPreferredSize());

}

  public static void main(String s[])  {
 

JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl1), "Center");
f.addWindowListener(new WindowAdapter() {


      public void windowClosing(WindowEvent evt) {
         System.exit(0);
      }
    });

f.setContentPane(new ComboBoxDemo());
 f.pack();
 f.setVisible(true);
    }
}

[Brian Pipa]

Has it EVER shown up? You should probably put in some dummy/test values to begin with to see if your table shows up - once you confirm that it does, THEN try getting the data from a DB.
Brian

[ben riches]

Originally posted by Brian Pipa:
Has it EVER shown up? You should probably put in some dummy/test values to begin with to see if your table shows up - once you confirm that it does, THEN try getting the data from a DB.
Brian

Yes I have got it to show with the ComBoxes showing all that I need but when one of the Table Names is not accepted it thows 1 Exception when I choose that Table Name, then thows the same Exception again when I go back into the ComboBox to change the table name.
Why do you think this is?

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxTable { 

   static Connection conn2;
   static DatabaseMetaData DMD;
   static JComboBox group = new JComboBox();
   static JComboBox groupList = new JComboBox();
  public static void main(String[] args) {
 
try  { 

     // Load the database driver
   Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
    conn2 = DriverManager.getConnection( "jdbc :-o	 dbc:myProject") ;
   DMD=conn2 .getMetaData();
   ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
   while(rs.next()) {

group.addItem((String)rs.getString(3));

   }
   rs.close() ;

 } catch (SQLException se ) {
   System.out.println( "SQL Exception: " + se ) ;
 } catch (Exception e ) {
   System.out.println( e ) ;
 }

group.addActionListener(new ActionListener()  {
   public void actionPerformed(ActionEvent e ) {
String tbl = (String)group.getSelectedItem();
 try {
      Statement st=conn2.createStatement();
    st.execute("SELECT * FROM "+tbl+"");
    ResultSet rs=st.getResultSet();
    ResultSetMetaData md=rs.getMetaData();
    groupList.removeAllItems();
   for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
    }
   st.close() ;

 } catch (SQLException se ) {
   System.out.println( "SQL Exception: " + se ) ;
 } catch (Exception ex ) {
   System.out.println( ex ) ;
 }
      }
});
int j1=10;
String[][] data = new String[j1][2];
      for (int k=0; k<j1; k++){
         String[] row = {"",""};
         data[k] = row;
      }

      
   
    String[] colNames = {"Column A", "Column B"};
    JTextField jtf = new JTextField();
    JTable tbl = new JTable(data, colNames);
// Create the combo box editor
    DefaultCellEditor editor = new DefaultCellEditor(groupList);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
    DefaultCellEditor editor2 = new DefaultCellEditor(group);
// Assign the editor to the second column
    TableColumnModel tcm = tbl.getColumnModel();
    tcm.getColumn(0).setCellEditor(editor2);
 // ADDED
    tcm.getColumn(1).setCellEditor(editor);
// Set column widths
    tcm.getColumn(0).setPreferredWidth(200);
    tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
    tbl.setRowHeight(20);
    tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
    f.getContentPane().add(new JScrollPane(tbl), "Center");
   
    f.pack();
    f.addWindowListener(new WindowAdapter() {


      public void windowClosing(WindowEvent evt) {
         System.exit(0);
      }
    });
    f.setVisible(true);
  }
}

Thanks
Ben

[Eddie Vanda]

Hi Ben,
I got your code to work straight away when I connected to one of my own databases by adjusting your connect statement. "Column A" comboboxes show the table names and "Column B" comboboxes show field names.

Yes I have got it to show with the ComBoxes showing all that I need but when one of the Table Names is not accepted it thows 1 Exception when I choose that Table Name, then thows the same Exception again when I go back into the ComboBox to change the table name

All my tables show up without any exceptions. What exceptions are you seeing? I am not sure how you would change the table name? Perhaps if you
explain exactly what you expect to see I can help you.
Ed
[ March 22, 2004: Message edited by: Eddie Vanda ]