How to delete MySql database records after clicking close button of JFrame?

Question

I have two JFrame forms that accept information such as Name,Rollno,Enrollment Number,gender,etc.Name and gender are on first JFrame form while the other details are on the second JFrame form.All the information gets stored in MySql Database after clicking 'next form' button.The same button takes the user to the next form.If the user fills all the details in the first form and clicks the 'next form' button of the form and he/she exits the second form,only half the database will be having the details and the other half will have nothing. So, please suggest me such code that when the user clicks the close(X) button of the second form, all the details saved in the Database get deleted. (Forms are entirely coded in NetBeans) Please help me out.

Answer 1

The best way to solve this method is to not save anything into the database until the user completes all forms (ie. cache the information from the first form and save it once all once the user completes all the data).

Option number 2 would be to delete the data when the X button is clicked, however this isn't the best since the application can be force closed or such, case in which you can't perform any action. Anyways, here's how to detect the X button being clicked.

First you want to disable automatic exiting:

// You probably have EXIT_ON_CLOSE instead of this somewhere in your code already, just replace with this
frame.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);

Then you want to handle the close event yourself:

frame.addWindowListener(new WindowAdapter() {
        @Override
        public void windowClosing(WindowEvent e) {
            // In here you can delete any data in the database or even use JOptionPane to confirm the exit
            // To close the frame once everything is done, do this:
            frame.dispose();
        }
    });

Note: You can use System.exit(0) instead of frame.dispose() to ensure that everything is terminated right away.