Table how to clear data

Al Lestaire Acasio

How do I clear all data from the table and put new data in it..
Just like a new table.. withouth column and data row.. ?
Please help :(

Agata Vackova

table.setContainerDataSource(new BeanItemContainer<Object>(Object.class));

Al Lestaire Acasio

Hello sir..
I havent use data source..
my goal is I want to make the table be fresh again..
So it means that the header and data should be removed..
I tried table.clear();
but when the new data comes.. the previous header and data will be merge to the new data.. instead it should be replaced with the new data...

Agata Vackova

Show your code.

Al Lestaire Acasio

Class.forName(TableexporterUI.JDBC_SERVER);
                    
                        System.out.println("Connecting to databse...");
                        conn = DriverManager.getConnection(DB_URL,"root","");

                        System.out.println("Creating statement...");
                        stmt = conn.createStatement();
                        String sql;
                        sql = textField.getValue();
                        ResultSet rs = stmt.executeQuery(sql);
                        ResultSetMetaData rsmd = rs.getMetaData();
                    
                        for(int i=1; i<=rsmd.getColumnCount(); i++) {
                            table.addContainerProperty(rsmd.getColumnName(i), String.class, null);
                        }
                    
                        int count = 0;
                        while(rs.next()) {
                            count++;
                            Object tableData[] = new Object[rsmd.getColumnCount()];
                            for(int i=0; i<rsmd.getColumnCount(); i++) {
                                tableData[i] = rs.getString(rsmd.getColumnName(i+1));
                            }
                            table.addItem(tableData, new Integer(count) );
                        }

Agata Vackova

I think, that the easiest way is:

table.removeAllItems();
List props = new ArrayList(getContainerPropertyIds());
for(Object prop: props){
   table.removeContainerProperty(prop);
}

Al Lestaire Acasio

Wow.. thanks for your help sir.. :)
It help me ... :) .. thank you..

Allan Nicholas Mwangi

table.removeAllItems(); //removes all data in the table except column headers/titles

Important Notice - Forums is archived

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

Important Notice - Forums is archived

Vaadin lets you build secure, UX-first PWAs entirely in Java.Free ebook & tutorial.

Table how to clear data

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.