phpmyadmin Question posted in
The official documentation can be found here.

How to validate username and password from mysql netbeans – Phpmyadmin

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:
}
Tags:

2

Answers


  1. 0

    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:

    }

    Login or Signup to reply.
  2. 0

    You need to make sure your resources are closed and use the PreparedStatement properly:

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

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

                java.sql.PreparedStatement ps = conn.prepareStatement(username);
                java.sql.Result rs = ps.executeQuery();

                if (rs.next()) {
                    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:
    }
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search