private void btnDeleteActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnDeleteActionPerformed

    int selectedOption =
        JOptionPane.showConfirmDialog(
            null,
            "Do you want to delete theis Home from the database?",
            "Choose",
            JOptionPane.YES_NO_OPTION);

    if (selectedOption == JOptionPane.YES_OPTION) {
      try {
        DBCon db = new DBCon();
        String homenumber = TFhoemnumber.getText();
        db.delHomedetails(homenumber);
        JOptionPane.showMessageDialog(this, "Deleted ...");
        TFaddress.setText("");
        TFhoemnumber.setText("");
        TFmembers.setText("");
        TFownername.setText("");
        TFtpnum.setText("");
      } catch (Exception ex) {
        log.error("Error " + ex);
        JOptionPane.showMessageDialog(this, "Error");
      }
    }
  } // GEN-LAST:event_btnDeleteActionPerformed
 private void btnSubmitActionPerformed(
     java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnSubmitActionPerformed
   Home home = null;
   DBCon db = new DBCon();
   try {
     home = db.searchHome(TFhoemnumber.getText());
   } catch (Exception ex) {
     log.error("Error " + ex);
     JOptionPane.showMessageDialog(this, "Error");
   }
   if (home == null) {
     JOptionPane.showMessageDialog(this, "Home not found...");
   }
   TFownername.setText(home.getOwner());
   TFaddress.setText(home.getAddress());
   TFtpnum.setText(home.getTpnumber());
   TFmembers.setText("" + home.getNumofmembers());
 } // GEN-LAST:event_btnSubmitActionPerformed