Thread: jTable trouble...

(I was currently looking into possibly using the DefaultTableModel better so I could just repaint() the damn thing easy but it is extremely hard to complete using NetBeans and there is a lack of documentation on exactly how to do it with NetBeans.)

Anywho... this is my Refresh button -

    private void btnRefreshActionPerformed(java.awt.event.ActionEvent evt) {                                           
 
 
        doDelete();
    }                                          
 
public void doDelete(){
    int i = 0;
    int r = 0;
 
    while (i < 600) {
        jTable1.remove(r);
 
        r++;i++;
    }
        doRefresh();
    }
 
 public void doRefresh(){
 
            try {
            String url = "jdbc:odbc:dts";
            String user = "";
            String password = "";
            Connection con = DriverManager.getConnection(url, user, password);
 
            String getCust = "SELECT *  FROM Customer";
            PreparedStatement ps = con.prepareStatement(getCust);
            ResultSet rs = ps.executeQuery();
 
            while (rs.next()){
                String s = rs.getString(1);
                jTable1.setValueAt(s, R, 0);
                s = rs.getString(2);
                jTable1.setValueAt(s, R, 1);
                s = rs.getString(3);
                jTable1.setValueAt(s, R, 2);
                s = rs.getString(4);
                jTable1.setValueAt(s, R, 3);
                s = rs.getString(5);
                jTable1.setValueAt(s, R, 4);
                s = rs.getString(6);
                jTable1.setValueAt(s, R, 5);
                s = rs.getString(7);
                jTable1.setValueAt(s, R, 6);
                s = rs.getString(8);
                jTable1.setValueAt(s, R, 7);
                R++;
 
 
           }
 
        } catch (Exception e) {
            lblConnect.setText("Error in doRefresh()");
        }
}

This is my Delete button -

   private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {                                          
 
        int row = jTable1.getSelectedRow();
 
        String value = (String)jTable1.getValueAt(row, 0);
        try{
            String url = "jdbc:odbc:dts";
            String user = "";
            String password = "";
            Connection con = DriverManager.getConnection(url, user, password);
        if ( row >= 0 ){
 
        String delCust = "DELETE FROM Customer WHERE FirstName = ?";
        PreparedStatement ps = con.prepareStatement(delCust);
        ps.setString(1, value);
        ps.executeUpdate();
            }
 
       }// end try
        catch(Exception e){
            lblConnect.setText("Failed to delete entry");
        }
 
    }

The main issue:

If I have two entries in the Database (displayed in the jTable) and I click one, and press Delete, it deletes it from the database without making any visual impact into the jTable, then you click Refresh, and it simply appends (to the bottom of the two other entries) the one that wasn't deleted(because it is now the only entry in the DB)


I just can't figure out how to simply completely erase all data in the jTable and reset it to start putting in data starting at row 0 col 0.

I tried your code you said to try and it gave me and error with the ".setSeletionInterval(0,0);" portion of it saying it couldn't find the Symbol: method setSelectionInterval(int, int);



:EDIT: in the event of me messing with some coding, it currently doesn't do any refreshing at all right now and changes arent made until the program restarts