Thread: jTable and jdbc

I have my jTable populated with the data from a database using this code:

       try {
            String url = "jdbc:odbc:dts";
            String user = "";
            String password = "";
            Connection con = DriverManager.getConnection(url, user, password);
            lblConnect.setText("Successfully connected.");
            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("Connection Failed. Error A009");
        }
    }

but can't figure out how I'd be able to implement a way for the user to be able to select the entire (already have it set to where once clicked, it highlights the row of data on the jTable) row and then click "Delete" button and it pick that exact row out and find it in the database and delete it.

How would I get which row the user clicked before clicking the Delete button?

Yeah it seems I really need to start reading the API more closely (although most of it makes stuff more complex then it is), I think the thing that is throwing me off is that when I learned Java I learned it all using TextPad and never used an IDE. This NetBeans is a different feel (and most commands i haven't used/heard of).


Like now I can't figure out how to enable my btnDelete when someone clicks on the jTable. I know I used ActionListeners before but when I go netbeans' Event box and use the "actionClick" or whatever, and put this in it:

btnDelete.enable(true);

It has a line through it and then I run the program and it doesn't work. (thats the only way I know to utilize an ActionListener inside NetBeans ona button

Like now I can't figure out how to enable my btnDelete when someone clicks on the jTable

Post an SSCCE that demonstrates the problem and it can be dealt with. If you are using a GUI builder and are more familiar with building things manually - then my opinion is (unless you have the time and patience) stick to what you are familiar with. I personally do not like GUI builders for the reason that they decouple the coder from the code...my .02

I got the button issue figured out (had to use the .setEnabled function). I feel like the GUI Builder (NetBeans) allows me to build applications way faster then using hard coding. I never thought it'd be a huge difference until I actually used one, but like you said, it doesn kind of take the coder from the code in a way.
Thank you again for all your help!

Just one last question (i hope lol)

What would be a good logically way of "refreshing" a jTable to reflect any changes made? I have an add and delete button and want the jTable to automatically reflect the changes made.

    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();
 
 
        }
       //delete from database given the value(s) to define the entry
            }
        catch(Exception e){
            lblConnect.setText("Failed to delete entry");
        }
 
    }

    private void btnSubmitActionPerformed(java.awt.event.ActionEvent evt) {                                          
           String FName = txtFirst.getText();
           String LName = txtLast.getText();
           String Addr = txtAddress.getText();
           String City = txtCity.getText();
           String State = txtState.getText();
           String Zip = txtZip.getText();
           String Phone = txtPhone.getText();
           String Email = txtEmail.getText();
            try{
 
             new JdbcOdbcDriver();
              String url = "jdbc:odbc:dts";
              String user = "";
              String password = "";
              Connection con = DriverManager.getConnection(url, user, password);
                String insertCustomer = "INSERT INTO Customer VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
              PreparedStatement ps = con.prepareStatement(insertCustomer);
              ps.setString(1, FName);
              ps.setString(2, LName);
              ps.setString(3, Addr);
              ps.setString(4, City);
              ps.setString(5, State);
              ps.setString(6, Zip);
              ps.setString(7, Phone);
              ps.setString(8, Email);
              int count = ps.executeUpdate();
        }
             catch (Exception e){
                 JOptionPane.showMessageDialog(null,"Sorry could not add new customer.");
             }
    }

The only issue is, the Submit (add new) button is on a separate form and when I try to pass anything back to the original jFrame it gives me the whole non-static to static issue and i can't change the static value of the other one because NetBeans locks it to where I can't make changes to the "Private blah blah blah" stuff. (unless there is a way that im not aware of to change the static thing)

I've tried even using:

 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()");
        }
}

and it doesn't work really.


The "Delete" button will delete the info from the database properly (won't reflect changes to the jTable though) then you press the "Refresh" button and all of instead of the entire jTable being deleted and re-populated, it just appends the new database (minus the row you selected to be deleted)