JComboBox Help!

[ben riches]

Hello All,
I have posted here in the past about JComboBox and you lot have helped me out greatly. I have one more problem then I can stop nagging you.
the code below puts values from a database into 2 combo boxes, and puts those combo boxes in to the JTabel. when the code is run the cells in the JTable are first of all cells untill I click into a cell it then changes to a Combo Box, I want the JTable to always display each cell as Combo Boxes.
I hope you understand what I mean?
Thanks
Ben

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

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

     // Load the database driver
   Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
    conn2 = DriverManager.getConnection( "jdbc  :-o	  dbc  :-P	  ro") ;
   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"};
DefaultTableModel model = new DefaultTableModel(data, colNames);
    JTextField jtf = new JTextField();
    JTable tbl = new JTable(model);
// 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);
  }
}

[ March 30, 2004: Message edited by: ben riches ]

[Nigel Browne]

Try changing

    tcm.getColumn(0).setCellEditor(editor2);

to this

   tcm.getColumn(0).setCellEditor(new DefaultCellEditor(editor2));

Regards
Nigel

[ben riches]

Originally posted by Nigel Browne:
Try changing

    tcm.getColumn(0).setCellEditor(editor2);

to this

   tcm.getColumn(0).setCellEditor(new DefaultCellEditor(editor2));

Regards
Nigel

Hi Nigel,
I have done what you said but I got this error
C:\j21work>javac ComboBoxTable.java
ComboBoxTable.java:98: cannot resolve symbol
symbol : constructor DefaultCellEditor (javax.swing.DefaultCellEditor)
location: class javax.swing.DefaultCellEditor
tcm.getColumn(0).setCellEditor(new DefaultCellEditor(editor2));
^
1 error
Thanks
Ben

[Nigel Browne]

Yes sorry I hadn't read your code properly. The argument should be the name of your JCombo e.g.

tcm.getColumn(0).setCellEditor(new DefaultCellEditor(myCombo1));
tcm.getColumn(1).setCellEditor(new DefaultCellEditor(myCombo2));

Regards
Nigel