JTable和DefaultTableModel

Question

我有一个从本地MySQL服务器获取信息的表。它很好地读取数据并将其发布在GUI上。

private String sql = "select * from profildb.tbl_detailed";  //to
private String sql = "select * from profildb.tbl_detailed where Y.."; //this

    JButton btnOK = new JButton("");
    btnOK.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent arg0) {

            if( (tfBirinci.getText().isEmpty() || tfBirinci.getText() == null) && (tfIkinci.getText().isEmpty() || tfIkinci.getText() == null ))
            {
                taLog.setText("Database alani bos birakilamaz...\n");
            }
            else if ( (!(tfBirinci.getText().isEmpty() )) && (tfIkinci.getText().isEmpty() || tfIkinci.getText() == null ) )
            {
                sql = ("SELECT * FROM " + tfBirinci.getText());
                taLog.setText("Komut elde edildi : " + sql + "\n");
                System.out.println("aaaa " + tfBirinci.getText());
                //anaFrame.dispose();
                //databaseHistoryCalistir(); doesnt work
            }
            else if ( ( !(tfBirinci.getText().isEmpty() ) &&  !(tfBirinci.getText() == null) )  && ( !(tfIkinci.getText().isEmpty() ) && !(tfBirinci.getText() == null) ) )
            {
                sql = ("SELECT * FROM " + tfBirinci.getText() + " WHERE " + tfIkinci.getText());
                taLog.setText("Komut elde edildi : " + sql + "\n" );
                System.out.println("bbbb " + tfBirinci.getText());
                //anaFrame.dispose();
                //databaseHistoryCalistir(); doesnt work
            }else 
                taLog.setText("Lütfen Database alanini doldurunuz, aksi taktirde komut elde edilemez...\n");
        }
    });

提前道谢。（给出一个关于DefaultTableModel的例子会很棒）

Answer 1

1）通过@camickr使用数据库中的表

2）使用resultsettablemodel之一

3）从runnable#Thread调用SQL语句，但对xxxTableModel的输出必须在invokelater内部，更多的内容请参见Swing中关于事件调度线程(EDT)的一致性

4）从SwingWorker调用SQL语句，然后从progress()、publish()或done()输出，应该在EDT上

5）DefaultTableModel不需要重写方法FirexxxTablexxx，所有方法都正确实现了

6）来自数据库的逻辑表(ResultsetTableModel)和Runnable#Thread(SwingWorker)之间的区别是

>

来自数据库的表(ResultsetTableModel)调用EDT上的所有更新，然后GUI等待所有事件完成，从数据库加载数据期间GUI不负责或冻结

runnable#thread(SwingWorker)所有更新都来自后台任务,