how to make this in limiting 3 login attempt

[Devin Cortez]

How do I make this in limited to 3 login attempts:

try{
            stmt = con.createStatement();
            rs = stmt.executeQuery("SELECT * FROM SECURITY WHERE USERNAME = '" + username.getText() + "'");
            if (rs.next()){
                if (rs.getString("PASSWORD").equals(password.getText())){
                    addRecordMenuItem.setEnabled(true);
                    deleteRecordMenuItem.setEnabled(true);
                    updateRecordMenuItem.setEnabled(true);
                    addRecordButton.setEnabled(true);
                    deleteRecordButton.setEnabled(true);
                    updateRecordButton.setEnabled(true);
                    loginInternalFrame.setVisible(false);
                    loginMenuItem.setText("Logout");
                    username.setText("");
                    password.setText("");
                }else{
                    JOptionPane.showMessageDialog(rootPane, "Incorrect password");
                }
            } else {
                JOptionPane.showMessageDialog(rootPane, "Username does not exist");
            }
        }catch(Exception e){
            JOptionPane.showMessageDialog(this, e);
        }

[Frinavale]

If you want your application to simply close after 3 attempts:

• Declare a variable called failedAttempts
• Increment failedAttempts every time the user fails to log in
• Close the application if failedAttempts is greater than 3

If the user re-opens the application, it will let him attempt to log in 3 more times and then close.

If you don't want this type of behaviour, consider keeping a table in your database that tracks who has failed to log in. This requires more work and you need to determine when this table is cleaned up etc.