JTable Problem Since 1 week

[adeeb alexander]

hi,
i have table which populates data from the data base now the problem is when ever i click the button the old rows are not erased from the JTable and the new once are added below them. Here is my code can any body just modify it.
Thanks and regards

    
jp6 = new JPanel();
due = new JButton("Dues");
due.addActionListener(this);
print.setMnemonic(KeyEvent.VK_P);
due.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
cl.show(panel,"6");
try
{
conn = DriverManager.getConnection("jdbc :-o	 dbc:addissue", "library","bismillah");
ps = conn.prepareStatement("SELECT * FROM expired WHERE days > 15 ORDER BY rollno ASC");

String colnames[] = {"ROLLNO","NAME","BOOK","BOOK ID","ISSUED","PRES_DATE","DAYS"};
DefaultTableModel model6 = (DefaultTableModel) tab6.getModel();
model6.setColumnIdentifiers(colnames);
rs=ps.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int colno = rsmd.getColumnCount();
while(rs.next())
{
Object[] row = new Object[colno];
for(int i=0;i<colno;i++)
{
row[i]=rs.getObject(i+1);
}
model6.addRow(row);
}
tab6.setModel(model6);

}

catch(Exception ce)
{
System.out.println(ce);
}

}
});
 
tab6 = new JTable();
jsp6 = new JScrollPane(tab6);
jsp6.setViewportView(tab6);
jsp6.revalidate();
jsp6.repaint();
jp6.setLayout(new BorderLayout());
 
jp6.add(jsp6);
jp6.add(viewd, BorderLayout.SOUTH);

i have tried using repaint() and revalidate but nothing works.

[Maneesh Godbole]

Originally posted by adeeb alexander:
hi,
i have table which populates data from the data base now the problem is when ever i click the button the old rows are not erased from the JTable and the new once are added below them.

No wonder.
You are picking the existing model and adding rows to it.

DefaultTableModel model6 = (DefaultTableModel) tab6.getModel();<---This is the existing model.
.
.
.<--At this stage the existing model still contains the old data
model6.addRow(row)<--You are adding new data to the old data
.
.
tab6.setModel(model6);<--You set the old/new data mix model 

What you need to do is create a new table model, populate it with data from your DB and then set it on the table.
OR
Take your existing model, delete all existing data and repopulate with new data from the DB.

[adeeb alexander]

Hi,
Manish can you please tell how can i delete all existing data and repopulate with new data from the DB.Please add that line of code in the code i gave before please.

[Maneesh Godbole]

Originally posted by adeeb alexander:
..Please add that line of code in the code i gave before please.

I am absolutely tempted to use abusive language. You think I got nothing better to do? Have you bothered to at least go through the API before asking me to do stuff for you?

[Rob Spoor]

No he hasn't.

adeeb, I've warned you before - ShowSomeEffort and SearchFirst. You still keep posting every single question you have on this board without any hint that you are even aware the API exists.