优化在JDBC上调用JTable的数据

恕我直言，坏习惯的根源是您不必要地查询数据库的多重时间来获取所需的数据（列，行，行号，列号等）：

要获取列号：

ResultSet rs = stmt.executeQuery("SELECt * FROM " + tableName);

要获取行号：

ResultSet rs = stmt.executeQuery("SELECt COUNT(*) FROM " + tableName);

要获取行（这是最糟糕的原因，因为它在循环内）：

data = stmt.executeQuery("SELECt " + columnName + " FROM " + tableName + " LIMIT " + j + ", " + 1);

如何解决

只需查询数据库一次。单个ResultSet及其关联的ResultSetmetaData应该足以实现您的目标。另外，正如已经建议的那样，使用a

SwingWorker

final JTable table = new JTable();SwingWorker<Void, TableModel> worker = new SwingWorker<Void, TableModel> () {    @Override    protected Void doInBackground() throws Exception {        ResultSet resultSet = stmt.executeQuery("SELECt * FROM " + tableName);        ResultSetmetaData metaData = resultSet.getmetaData();        int columnCount = metaData.getColumnCount(); // columns number        String[] columnNames = new String[columnCount];        for (int i = 1; i <= columnCount; i++) { columnNames[i] = metaData.getColumnName(i); // fill columns names        }        resultSet.last();        int rowCount = resultSet.getRow(); // get rows number        resultSet.beforeFirst();        Object[][] data = new Object[rowCount][columnCount];        int currentRow = 0;        while (resultSet.next()) { for (int currentColumn = 1; currentColumn <= columnCount; currentColumn++) {     data[currentRow][currentColumn - 1] = resultSet.getObject(currentColumn); // fill data set  }  currentRow++;        }        TableModel model = new DefaultTableModel(data, columnNames);        publish(model);        return null;    }    @Override    protected void process(List<TableModel> chunks) {        TableModel model = chunks.get(0);        table.setModel(model);    }}worker.execute();