javamysqlnetbeansjform

How to validate username and password from mysql netbeans


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:
    

    }