skip to Main Content

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

2

Answers


  1. 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. 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