JTable用JComboBox填充数据

Question

我有一个带有table的框架，combobox，我想通过combobox用来自数据库的数据填充表，但是如果我使用itemlistener我看不到表，没有itemlistener和字符串sql=“select*from arlista”，我就看到了带有数据的表(combob=combobox)

combob.addItemListener(new ItemListener(){
    @Override
    public void itemStateChanged(ItemEvent e){
        tesztvalt=(combob.getSelectedItem()).toString();

        if (e.getItem().equals(tesztvalt))
        {
            try {

                Class.forName( driver );
                Connection connection = DriverManager.getConnection( url );
                String sql="select * from "+tesztvalt+"";
                Statement stmt = connection.createStatement();
                ResultSet rs = stmt.executeQuery( sql );
                ResultSetMetaData md = rs.getMetaData();
                int columns = md.getColumnCount();

                while (rs.next()) {
                    Vector row = new Vector(columns);

                    for (int i = 1; i <= columns; i++)
                    {
                        row.addElement( rs.getObject(i) );
                    }
                    data.addElement( row );

                }
                rs.close();
                stmt.close();
                connection.close();
            }catch(Exception ex) {
                System.out.println( e );
            }
            JTable table = new JTable(data, columnNames)
            {
                public Class getColumnClass(int column)
                {
                    for (int row = 0; row < getRowCount(); row++)
                    {
                        Object o = getValueAt(row, column);

                        if (o != null)
                        {
                            return o.getClass();
                        }
                    }
                    return Object.class;
                }
            };
            JScrollPane scrollPane = new JScrollPane( table );
            getContentPane().add( scrollPane );

            JPanel buttonPanel = new JPanel();
            getContentPane().add( buttonPanel, BorderLayout.SOUTH );
        }
    }
});

Answer 1

这是一种略有不同的方式，但很简单。从组合框中选择项时，表将发生更改。它使用表模型：

//ComboTableTest.java
import java.awt.Dimension;
import java.awt.EventQueue;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;

public class ComboTableTest extends JFrame implements ActionListener {
    private static final long serialVersionUID = -3898736145211708745L;

    private JComboBox<String> combo;
    private MyTableModel tableModel;

    //constructor
    public ComboTableTest() {
        //set up frame
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setSize(600,175);
        setLayout(new FlowLayout());

        //create combo box
        combo = new JComboBox<String>(new String[]{"one", "two", "three"});
        combo.addActionListener(this);
        add(combo);

        //create table
        tableModel = new MyTableModel();
        final JTable table = new JTable(tableModel);
        table.setPreferredScrollableViewportSize(new Dimension(500, 70));
        table.setFillsViewportHeight(true);
        JScrollPane scrollPane = new JScrollPane(table);
        add(scrollPane);
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == combo) {
            tableModel.setValueAt(0,0,(String)combo.getSelectedItem());
            tableModel.setValueAt(1,1,(String)combo.getSelectedItem());
            tableModel.setValueAt(2,2,(String)combo.getSelectedItem());
        }

    }


    /*** MAIN ***/
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    ComboTableTest frame = new ComboTableTest();
                    frame.setVisible(true);

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

class MyTableModel extends AbstractTableModel {
    private static final long serialVersionUID = -1359557492205432915L;

    private String[] columnNames = {"Col 1","Col 2","Col 3"};
    private Object[][] data = new Object[][]{{"1","2","3"},{"4","5","6"},{"7","8","9"}};

    public void setValueAt(int row, int col, String s) {
        data[row][col] = s;
        fireTableDataChanged(); //EDITED
    }

    public int getColumnCount() {
        return columnNames.length;
    }

    public int getRowCount() {
        return data.length;
    }

    public String getColumnName(int col) {
        return columnNames[col];
    }

    public Object getValueAt(int row, int col) {
        return data[row][col];
    }

    public Class getColumnClass(int c) {
        return getValueAt(0, c).getClass();
    }
}