title: Trying to update my table, instead of 1 row getting updated all rows get the change
body: <p>As the title states I am trying to edit fields in and existing (local) MySQL server.
  Adding and removing rows works like a charm, but when I try to edit them using this code:</p>
  
  <pre><code>    private void EditActionPerformed(java.awt.event.ActionEvent evt) {                                     
  
     try{
         String edit1 = lNaam.getText();
         String edit2 = lEmail.getText();
         String edit3 = lAdres.getText();
         String edit4 = lPlaats.getText();
         String edit5 = lPostcode.getText();
         String edit6 = lTelefoon.getText();
         String edit7 = lBedrijfsNaam.getText();
  
         String sql="update customers set naam='"+edit1+"',email='"+edit2+"',adres='"+edit3+"',plaats='"+edit4+"',postcode='"+edit5+"',telefoon='"+edit6+"',bedrijfsnaam='"+edit7+"'where KL_NR";
         preparedStatement=connect.prepareStatement(sql);
         preparedStatement.execute();
      JOptionPane.showMessageDialog(null, "Updated");
  
     }catch(SQLException | HeadlessException e){
     JOptionPane.showMessageDialog(null, e);
     }
      Update_table();
  
  }   
  </code></pre>
  
  <p><strong>EDIT: I FORGOT TO SAY THIS, THE KL_NR FIELD IS A AUTO_INCREMENT FIELD, WHICH IS SUPPOSED TO STAY THE SAME, I HAVE NO IDEA WHAT TO PUT THERE</strong></p>
  
  <p>It keeps editing all the rows in the table in stead of just 1.</p>
  
  <p><a href="http://imgur.com/6fIhrQw" rel="nofollow">http://imgur.com/6fIhrQw</a></p>
  
  <p>this code is used to select the rows, for deletion etc.:</p>
  
  <pre><code>    private void Table_customerMouseReleased(java.awt.event.MouseEvent evt) {                                             
    try{
  
      int row = Table_customer.getSelectedRow();
      String TClick = (Table_customer.getModel().getValueAt(row, 0).toString());
      String sql="select * from customers where KL_NR='"+TClick+"'";
      preparedStatement=connect.prepareStatement(sql);
      resultSet=preparedStatement.executeQuery();
      if(resultSet.next()){
          String add1 =resultSet.getString("naam");
          lNaam.setText(add1);
          String add2 =resultSet.getString("Email");
          lEmail.setText(add2);
          String add3 =resultSet.getString("Adres");
          lAdres.setText(add3);
          String add4 =resultSet.getString("Plaats");
          lPlaats.setText(add4);
          String add5 =resultSet.getString("Postcode");
          lPostcode.setText(add5);
          String add6 =resultSet.getString("Telefoon");
          lTelefoon.setText(add6);
          String add7 =resultSet.getString("Bedrijfsnaam");
          lBedrijfsNaam.setText(add7);
      }
  
  
  
      }catch(Exception e){
          JOptionPane.showMessageDialog(null, e);
      }
  }    
  </code></pre>
  
  <p>this is my deletion code:</p>
  
  <pre><code>private void DeleteActionPerformed(java.awt.event.ActionEvent evt) {                                       
      String sql ="delete from test.customers where NAAM=? ";
      try {
          // TODO add your handling code here:
          preparedStatement = connect.prepareStatement(sql);
  
          preparedStatement.setString(1, lNaam.getText());
          preparedStatement.executeUpdate();
          JOptionPane.showMessageDialog(null, "Deleted");
  
      } catch (SQLException ex) {
          Logger.getLogger(DataView.class.getName()).log(Level.SEVERE, null, ex);
      }
      Update_table();
  }                
  </code></pre>
  
  <p>I hope you can help me. :S</p>