Refresh JScrollPane JTable Data on JPanel in JFrame

Question

I wnat to fill my Table with new Datas which i get by my DataBase(MySQL). I get all datas and create a new Model with them, but if i want to refresh the specific panel, then it wont be repainted.

public class PanelWest extends JPanel implements ActionListener {
private JButton but_selectBP;
private JButton but_selectBPAdr;
private JButton but_selectGerichte;
private GroupLayout layoutGroup;
private Connector stmtExecuter = new Connector();
//  private PanelCenter tableViewer = new PanelCenter();


public PanelWest() {
    layoutGroup = createLayout();
    this.setLayout(layoutGroup);
    createButtons();
}

private GroupLayout createLayout() {
    GroupLayout layout = new GroupLayout(this);
    layout.setAutoCreateGaps(true);
    layout.setAutoCreateContainerGaps(true);
    return layout;
}


void createButtons() {
    this.but_selectBP = new JButton("Kunden anzeigen");
    this.but_selectBP.addActionListener(this);
    this.but_selectBPAdr = new JButton("Gerichte anzeigen");
    this.but_selectBPAdr.addActionListener(this);
    this.but_selectGerichte = new JButton("Lieferanten anzeigen");
    this.but_selectGerichte.addActionListener(this);

    this.layoutGroup.setHorizontalGroup(layoutGroup.createParallelGroup().addComponent(but_selectBP).addComponent(but_selectBPAdr).addComponent(but_selectGerichte));
    this.layoutGroup.setVerticalGroup(layoutGroup.createSequentialGroup().addComponent(but_selectBP).addComponent(but_selectBPAdr).addComponent(but_selectGerichte));
}

@Override
public void actionPerformed(ActionEvent e) {
    Object src = e.getSource();

    if (src.equals(this.but_selectBP)) {
        String query = "SELECT * FROM Kunde";
        ResultSet rst = this.stmtExecuter.getResultDBData(query);
    //    this.tableViewer.setTableName("Kunde");
        new PanelCenter().createTable(fillHeader(rst), fillData(rst));
    }

    if (src.equals(this.but_selectBPAdr)) {
        String query = "SELECT * FROM Gericht";
        ResultSet rst = this.stmtExecuter.getResultDBData(query);
    //    this.tableViewer.createTable(fillHeader(rst), fillData(rst));
    }

    if (src.equals(this.but_selectGerichte)) {
        String query = "SELECT * FROM Lieferant";
        ResultSet rst = this.stmtExecuter.getResultDBData(query);
     //   this.tableViewer.createTable(fillHeader(rst), fillData(rst));
    }
}

private String[] fillHeader(ResultSet rst) {
    try {
        ResultSetMetaData rstMetaData = rst.getMetaData();
        String[] header = new String[rstMetaData.getColumnCount()];
        ArrayList<String> headerDetails = new ArrayList<>();
        for (int i = 1; i <= rstMetaData.getColumnCount(); i++) {
           headerDetails.add(rstMetaData.getColumnName(i));
        }
        int j = 0;
        for(String head : headerDetails){
            header[j] = head;
            j++;
        }
        return header;
    } catch (SQLException se) {
        se.printStackTrace();
    }
    return null;
}

private Object[][] fillData(ResultSet rst) {
    try {
        ResultSetMetaData rstMetaData = rst.getMetaData();
        int rowCount = 0;

        rst.last();
        rowCount = rst.getRow();
        System.out.println(rowCount + " Rows");
        rst.beforeFirst();

        Object[][] data = new Object[rowCount][rstMetaData.getColumnCount()];

        int row = 0;
        while (rst.next()) {
            for (int i = 0; i < rstMetaData.getColumnCount(); i++) {
                data[row][i] = rst.getObject(i + 1);
            }
            row++;
        }
        return data;
    } catch (SQLException se) {
        System.out.println("Hier bei Fill");
    }
    return null;
}
}

I use remove, add revalidate and repaint on my jpanel.

 void createTable(String[] header, Object[][] data) {
    this.tableData = new JTable();
    this.tableData.setModel(new MyTableModel(header, data));
    this.tableData.setFillsViewportHeight(true);
    this.tableData.addKeyListener(this);
    this.scrollPaneTable = new JScrollPane(tableData);
    this.scrollPaneTable.setSize(500, 500);
    this.remove(this.scrollPaneTable);
    this.add(this.scrollPaneTable);
    this.revalidate();
    this.repaint();
}

score 2 · Answer 1 · 2016-07-03T15:36:29.823

You don't need to reinitialize the table, table model.

Put some global variables on the top

private MyTableModel tableModel; //Your own table model
private JTable table;

Initialize them on init

public PanelWest() {
    layoutGroup = createLayout();
    this.setLayout(layoutGroup);
    createButtons();
    tableModel = new MyTableModel(header, data); //Your own tablemodel
    table = new JTable(tableModel); //Hook the model to your table
    this.add(table)
    //...Do other things else to your table
}

Once you want to update the table, simply clear the rows from the table model and fill with new rows.

And ask JTable to update its data by calling

void createTable(String[] header, Object[][] data){
    int cols = header.length;
    int rows = data.length;

    //Remove all rows from model 
    tableModel.setRowCount(0); //(As said by HovercraftFullOfEels)

    Object[] row = new Object[cols];
    for (int j = 0; j < data.length; j++){
        for (int i = 0; i < cols; i++){
            row[i] = data[j][i];
        }
        tableModel.addRow(row);
    }
    tableModel.fireTableDataChanged();
}

Hope it will help.

Again, there is no field or variable named `mod`. If you want to clear a DefaultTableModel, you'd simply call `setRowCount(0)`. If it's your own model based on AbstractTableModel, then you'll want to write your own method to do this, but using a for loop in this way may be dangerous. — Hovercraft Full Of Eels, Jul 03 '16 at 15:25
Don't invoke `fireTabledataChange(...)`. It is the job of the TableModel to do this and the addRow(...) method will invoke the appropriate method. — camickr, Jul 03 '16 at 19:14

score 0 · Answer 2 · answered Jul 04 '16 at 09:07

Thanks for your help. I add a small test to my createTable method. I create a new window to show the new table datas and it works. i think my jpanel doesn't repaint correctly cause my grouplayout.

        this.tableData = new JTable();
    this.tableData.setModel(new MyTableModel(header, data));
    this.tableData.setFillsViewportHeight(true);
    this.tableData.addKeyListener(this);
    this.scrollPaneTable = new JScrollPane(tableData);
    this.scrollPaneTable.setSize(500, 500);

    this.layoutGroup.setVerticalGroup(layoutGroup.createSequentialGroup().addComponent(this.scrollPaneTable, 400, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE).addComponent(this.scrollPaneChanges).addComponent(this.but_user).addComponent(this.but_dataChange));


      //        JFrame fr = new JFrame("Hello");
      //        fr.setLayout(null);
     //        fr.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
    //        fr.setVisible(true);
    //        fr.add(this.scrollPaneTable);

please ignore the one row with layoutgroup – Reptain Jul 04 '16 at 09:07 — Reptain, Jul 04 '16 at 09:07

Refresh JScrollPane JTable Data on JPanel in JFrame

2 Answers2