[FIXED] How to validate username and password from mysql netbeans

Issue

Hello guys i want to make a validation for username and password from my phpmyadmin database using netbeans Jform

here is my code

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

    String a = username.getText();
    String b = password.getText();
    try {
        //configDB is my connnection file to mysql
        java.sql.Connection conn = (Connection) config.configDB();
        String username = "select username from akun where username='" + a + "';";
        String password = "select password from akun where password='" + b + "';";

        java.sql.PreparedStatement us = conn.prepareStatement(username);
        java.sql.PreparedStatement pw = conn.prepareStatement(password);
        us.execute();
        pw.execute();

        if (a.equals(username.toString()) && b.equals(password.toString())) {
            JOptionPane.showMessageDialog(this, "Benar");
        } else {
            JOptionPane.showMessageDialog(this, "Username or Password is incorrect");
        }

    } catch (Exception e) {
        JOptionPane.showMessageDialog(this, e.getMessage());
    }        // TODO add your handling code here:
}       

Solution

Try this.

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

String a = username.getText();
String b = password.getText();

try {
    
    java.sql.Connection conn = (Connection) config.configDB();
    String query = "select username, password  from akun where username='" + a + "';";

    java.sql.PreparedStatement ps = conn.prepareStatement(query);
    java.sql.ResultSet resultSet = ps.executeQuery(query);
    String un = "";
    String pw = "";
    while (resultSet.next()) {
            un = resultSet.getString("username");
            pw = resultSet.getString("password");
     }
    

    if (a.equals(us) && b.equals(pw)) {
        JOptionPane.showMessageDialog(this, "Benar");
    } else {
        JOptionPane.showMessageDialog(this, "Username or Password is incorrect");
    }

} catch (Exception e) {
    JOptionPane.showMessageDialog(this, e.getMessage());
}        // TODO add your handling code here:

}

Answered By - UDS