apache / netbeans

Apache NetBeans
https://netbeans.apache.org/
Apache License 2.0
2.64k stars 848 forks source link

Floating multiple jOptionPane when using mysql phpmyadmin #6068

Closed kelvin1918 closed 1 year ago

kelvin1918 commented 1 year ago

Apache NetBeans version

Apache NetBeans 18

What happened

yesterday i create a log in system with using myql in php myadmin in xampp control panel. Im glad that yesterday it fully and succesfully works . the next day i dont know why the joptions are malfunctioning it floats multiple times. It doesnt follow the codes and floating multiple times. i found out and trying to fix this. the database from phpmyadmin is the source of all of this and i dont know how to fix this. this is not only happening in this forgotPass jframe also in every jframes with database from phpmyadmin. please tell me the steps by fixing this. i need this system for my thesis.

https://github.com/apache/netbeans/assets/136215452/2b888f8a-366b-48f6-aacc-f2f420b0b89f

image image image image image image image

How to reproduce

---i create a database with "m&r" database name and tabe "accounts"

"accounts" table from "m&r" database has 10 columns the "ID","Name","Email","mNumber","Adress","Password","sQuestion","Answer","Status","Position"

image image image image


---and then the ljframe from netbeans , a log in system with , LogIn.java, SignUp.java, forgotPass.java jframes. i only show the forgot pass. this time. image image image

-**--I will only show the code of forgot pass in Update button and search button because the problem is in there

---this is the code of forgot pass in update button and search button**

---//UPDATE button image

   public void update(){
        String password = PS.getText();
        String email = EL.getText();
        String answer = AN.getText();
        try {
            pst = con.prepareStatement("update accounts set Password = '"+password+"' where Email = '"+email+"' ");
            pst.executeUpdate();

        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

image

    private void UDActionPerformed(java.awt.event.ActionEvent evt) {                                   
        // TODO add your handling code here:
        String answer = AN.getText();

        try {
            pst = con.prepareStatement("Select * from accounts");
            rs = pst.executeQuery();
            update();
            while(rs.next()){
            String an = rs.getString("Answer");

                if(answer.equals(an)){
                    JOptionPane.showMessageDialog(this, "Password Changed Successfully");
                    clear();
                }

                else{
                    JOptionPane.showMessageDialog(this, "Incorrect Answer! Please try again");
                    AN.setText("");
                    PS.setText("");
                }
            }

        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

---this is the code of SEARCH its by the way the Jlabel with icon

image

private void SHMouseClicked(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:

        // THE SEARCH BUTTON//

        String email = EL.getText();

        try {
            pst = con.prepareStatement("Select * from accounts");
            rs = pst.executeQuery();

            while(rs.next()){ 
                String eml = rs.getString("EMAIL");

                if(email.equals(eml)){
                    SH.setEnabled(false);
                    EL.setEditable(false);                    
                    SQ.setText(rs.getString("SQUESTION"));
                    validateField();

                }
                else{
                    JOptionPane.showMessageDialog(this, "Email not found");
                }
            }
        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

this is the fullsource code of forgotPass.java

import java.awt.Image;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.ImageIcon;
import javax.swing.JOptionPane;
import javax.swing.Timer;

/**
 *
 * @author jelom
 */
public class forgotPass extends javax.swing.JFrame {

    public String emailPattern = "^[a-zA-Z0-9]+[@]+[a-zA-Z0-9]+[.]+[a-zA-Z0-9]+$";
    /**
     * Creates new form forgotPass
     */
    public forgotPass() {
        initComponents();
        icons();
        connection();
        UD.setEnabled(false);
        SH.setEnabled(false);
        SQ.setEditable(false);
        time();
        date();
    }
    Connection con;
    PreparedStatement pst;
    ResultSet rs;

    public void connection(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            try {
                con = DriverManager.getConnection("jdbc:mysql://localhost/m&r","root","");
            } catch (SQLException ex) {
                Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
            }
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public void clear(){
        UD.setEnabled(false);
        SH.setEnabled(false);
        EL.setEditable(true);
        EL.setText("");
        SQ.setText("");
        AN.setText("");
        PS.setText("");
    }

    public void validateEmail(){
        String email = EL.getText();

        if(email.matches(emailPattern)){
            SH.setEnabled(true);
        }
        else {
            SH.setEnabled(false);
        }
    }

    public void validateField(){

        String pass = PS.getText();
        String answ = AN.getText();
        String sequ = SQ.getText();
        if(!pass.equals("") && !answ.equals("") && !sequ.equals("")){
            UD.setEnabled(true);
        }
        else{
            UD.setEnabled(false);
        }
    }

    public void update(){
        String password = PS.getText();
        String email = EL.getText();
        String answer = AN.getText();
        try {
            pst = con.prepareStatement("update accounts set Password = '"+password+"' where Email = '"+email+"' ");
            pst.executeUpdate();

        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

    public void icons(){
        ImageIcon srch = new ImageIcon("search.png");
        //
        Image sch = srch.getImage();
        Image schScale = sch.getScaledInstance(SH.getWidth(), SH.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledsch = new ImageIcon(schScale);
        SH.setIcon(scaledsch);

        ImageIcon clse = new ImageIcon("52be42c857e94384cca3be4c3f9fa912.jpg");
        //
        Image cls = clse.getImage();
        Image clsScale = cls.getScaledInstance(CL.getWidth(), CL.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledbcl = new ImageIcon(clsScale);
        CL.setIcon(scaledbcl);

        ImageIcon logo = new ImageIcon("mnr.png");
        //
        Image log = logo.getImage();
        Image logsc = log.getScaledInstance(SI.getWidth(), SI.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon sclog = new ImageIcon(logsc);
        SI.setIcon(sclog);

        ImageIcon back = new ImageIcon("right-icon_318-11053 (2).jpg");
        //
        Image bck = back.getImage();
        Image bckScale = bck.getScaledInstance(BK.getWidth(), BK.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledbck = new ImageIcon(bckScale);
        BK.setIcon(scaledbck );
    }

    public void mouseicon(){
        ImageIcon srch = new ImageIcon("search1.png");
        //
        Image sch = srch.getImage();
        Image schScale = sch.getScaledInstance(SH.getWidth(), SH.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledsch = new ImageIcon(schScale);
        SH.setIcon(scaledsch);
    }
    public void mouseicon2(){
        ImageIcon srch = new ImageIcon("search2.png");
        //
        Image sch = srch.getImage();
        Image schScale = sch.getScaledInstance(SH.getWidth(), SH.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledsch = new ImageIcon(schScale);
        SH.setIcon(scaledsch);
    }

    public void date(){
        Date d = new Date();

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");

        String dd = sdf.format(d);
        DT.setText(dd);
    }
    public void time(){
        new Timer (0 , new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                Date d = new Date();
                SimpleDateFormat s = new SimpleDateFormat("hh:mm:ss a");
                String tim = s.format(d);
                TM.setText(tim);
            }
        }).start();
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jLabel15 = new javax.swing.JLabel();
        jLabel48 = new javax.swing.JLabel();
        AN = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        PS = new javax.swing.JPasswordField();
        jPanel4 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        UD = new javax.swing.JButton();
        jPanel12 = new javax.swing.JPanel();
        BK = new javax.swing.JLabel();
        CL = new javax.swing.JLabel();
        TM = new javax.swing.JLabel();
        jLabel47 = new javax.swing.JLabel();
        DT = new javax.swing.JLabel();
        SI = new javax.swing.JLabel();
        EL = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        SH = new javax.swing.JLabel();
        SQ = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setUndecorated(true);

        jPanel1.setBackground(new java.awt.Color(255, 251, 242));
        jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jPanel5.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, null, new java.awt.Color(204, 204, 204), new java.awt.Color(102, 102, 102), new java.awt.Color(51, 51, 51)));
        jPanel5.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jPanel5MouseClicked(evt);
            }
            public void mouseEntered(java.awt.event.MouseEvent evt) {
                jPanel5MouseEntered(evt);
            }
            public void mouseExited(java.awt.event.MouseEvent evt) {
                jPanel5MouseExited(evt);
            }
        });
        jPanel5.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel15.setFont(new java.awt.Font("Microsoft New Tai Lue", 0, 20)); // NOI18N
        jLabel15.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel15.setText("Create Account");
        jPanel5.add(jLabel15, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 0, 170, 50));

        jPanel1.add(jPanel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(790, 610, 210, 50));

        jLabel48.setFont(new java.awt.Font("Microsoft New Tai Lue", 1, 48)); // NOI18N
        jLabel48.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel48.setText("Forgot Password");
        jPanel1.add(jLabel48, new org.netbeans.lib.awtextra.AbsoluteConstraints(340, 120, 400, 60));

        AN.setFont(new java.awt.Font("Microsoft Tai Le", 0, 20)); // NOI18N
        AN.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                ANKeyReleased(evt);
            }
        });
        jPanel1.add(AN, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 380, 320, 50));

        jLabel6.setFont(new java.awt.Font("Microsoft New Tai Lue", 1, 20)); // NOI18N
        jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel6.setText("Answer:");
        jPanel1.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 380, 130, 40));

        jLabel9.setFont(new java.awt.Font("Microsoft New Tai Lue", 1, 20)); // NOI18N
        jLabel9.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel9.setText("Password:");
        jPanel1.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(250, 450, 140, 40));

        PS.setFont(new java.awt.Font("Microsoft Tai Le", 0, 20)); // NOI18N
        PS.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                PSKeyReleased(evt);
            }
        });
        jPanel1.add(PS, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 450, 320, 50));

        jPanel4.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, null, new java.awt.Color(204, 204, 204), new java.awt.Color(102, 102, 102), new java.awt.Color(51, 51, 51)));
        jPanel4.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jPanel4MouseClicked(evt);
            }
            public void mouseEntered(java.awt.event.MouseEvent evt) {
                jPanel4MouseEntered(evt);
            }
            public void mouseExited(java.awt.event.MouseEvent evt) {
                jPanel4MouseExited(evt);
            }
        });
        jPanel4.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel13.setFont(new java.awt.Font("Microsoft New Tai Lue", 0, 18)); // NOI18N
        jLabel13.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel13.setText("Log in");
        jPanel4.add(jLabel13, new org.netbeans.lib.awtextra.AbsoluteConstraints(70, 0, 90, 50));

        jPanel1.add(jPanel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 610, 240, 50));

        UD.setFont(new java.awt.Font("Microsoft Tai Le", 1, 21)); // NOI18N
        UD.setText("Update");
        UD.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                UDActionPerformed(evt);
            }
        });
        jPanel1.add(UD, new org.netbeans.lib.awtextra.AbsoluteConstraints(470, 520, 150, 50));

        jPanel12.setBackground(new java.awt.Color(0, 0, 0));
        jPanel12.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        BK.setBackground(new java.awt.Color(255, 255, 255));
        BK.setForeground(new java.awt.Color(255, 255, 255));
        BK.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                BKMouseClicked(evt);
            }
        });
        jPanel12.add(BK, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 40, 40));

        CL.setBackground(new java.awt.Color(255, 255, 255));
        CL.setForeground(new java.awt.Color(255, 255, 255));
        CL.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                CLMouseClicked(evt);
            }
        });
        jPanel12.add(CL, new org.netbeans.lib.awtextra.AbsoluteConstraints(990, 10, 40, 40));

        TM.setFont(new java.awt.Font("Comic Sans MS", 1, 18)); // NOI18N
        TM.setForeground(new java.awt.Color(255, 255, 255));
        TM.setText("0");
        jPanel12.add(TM, new org.netbeans.lib.awtextra.AbsoluteConstraints(840, 20, 150, -1));

        jLabel47.setFont(new java.awt.Font("Kristen ITC", 1, 24)); // NOI18N
        jLabel47.setForeground(new java.awt.Color(255, 255, 255));
        jLabel47.setText("M&R  Food House");
        jPanel12.add(jLabel47, new org.netbeans.lib.awtextra.AbsoluteConstraints(400, 10, 230, -1));

        DT.setFont(new java.awt.Font("Comic Sans MS", 1, 18)); // NOI18N
        DT.setForeground(new java.awt.Color(255, 255, 255));
        DT.setText("0");
        jPanel12.add(DT, new org.netbeans.lib.awtextra.AbsoluteConstraints(80, 20, 160, 30));

        SI.setText("jLabel1");
        jPanel12.add(SI, new org.netbeans.lib.awtextra.AbsoluteConstraints(640, 10, 50, 40));

        jPanel1.add(jPanel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1050, 60));

        EL.setFont(new java.awt.Font("Microsoft Tai Le", 0, 20)); // NOI18N
        EL.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                ELKeyPressed(evt);
            }
            public void keyReleased(java.awt.event.KeyEvent evt) {
                ELKeyReleased(evt);
            }
        });
        jPanel1.add(EL, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 240, 320, 50));

        jLabel7.setFont(new java.awt.Font("Microsoft New Tai Lue", 1, 20)); // NOI18N
        jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel7.setText("E-mail:");
        jPanel1.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 250, 120, 40));

        jLabel8.setFont(new java.awt.Font("Microsoft New Tai Lue", 1, 20)); // NOI18N
        jLabel8.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel8.setText("Security Question: ");
        jPanel1.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 320, 180, 40));

        SH.setText("jLabel1");
        SH.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                SHMouseClicked(evt);
            }
            public void mouseEntered(java.awt.event.MouseEvent evt) {
                SHMouseEntered(evt);
            }
            public void mouseExited(java.awt.event.MouseEvent evt) {
                SHMouseExited(evt);
            }
            public void mousePressed(java.awt.event.MouseEvent evt) {
                SHMousePressed(evt);
            }
            public void mouseReleased(java.awt.event.MouseEvent evt) {
                SHMouseReleased(evt);
            }
        });
        jPanel1.add(SH, new org.netbeans.lib.awtextra.AbsoluteConstraints(730, 240, 50, 50));

        SQ.setFont(new java.awt.Font("Microsoft Tai Le", 0, 20)); // NOI18N
        SQ.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                SQKeyReleased(evt);
            }
        });
        jPanel1.add(SQ, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 310, 320, 50));

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 1050, Short.MAX_VALUE)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(layout.createSequentialGroup()
                    .addGap(0, 0, Short.MAX_VALUE)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 1050, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(0, 0, Short.MAX_VALUE)))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 712, Short.MAX_VALUE)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(layout.createSequentialGroup()
                    .addGap(0, 0, Short.MAX_VALUE)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 710, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(0, 0, Short.MAX_VALUE)))
        );

        pack();
        setLocationRelativeTo(null);
    }// </editor-fold>                        

    private void jPanel5MouseClicked(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
        jPanel5.setBackground(new java.awt.Color(163,163,163));

        new selectAccount().setVisible(true);
        this.setVisible(false);
    }                                    

    private void jPanel5MouseEntered(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
        jPanel5.setBackground(new java.awt.Color(204,204,204));
    }                                    

    private void jPanel5MouseExited(java.awt.event.MouseEvent evt) {                                    
        // TODO add your handling code here:
        jPanel5.setBackground(new java.awt.Color(242,242,242));
    }                                   

    private void ANKeyReleased(java.awt.event.KeyEvent evt) {                               
        // TODO add your handling code here:
        validateField();
    }                              

    private void PSKeyReleased(java.awt.event.KeyEvent evt) {                               
        // TODO add your handling code here:
        validateField();
    }                              

    private void jPanel4MouseClicked(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:

        jPanel4.setBackground(new java.awt.Color(163,163,163));

        new selectAccount().setVisible(true);
        this.setVisible(false);

    }                                    

    private void jPanel4MouseEntered(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
        jPanel4.setBackground(new java.awt.Color(204,204,204));
    }                                    

    private void jPanel4MouseExited(java.awt.event.MouseEvent evt) {                                    
        // TODO add your handling code here:
        jPanel4.setBackground(new java.awt.Color(242,242,242));
    }                                   

    private void UDActionPerformed(java.awt.event.ActionEvent evt) {                                   
        // TODO add your handling code here:
        String answer = AN.getText();

        try {
            pst = con.prepareStatement("Select * from accounts");
            rs = pst.executeQuery();
            update();
            while(rs.next()){
            String an = rs.getString("Answer");

                if(answer.equals(an)){
                    JOptionPane.showMessageDialog(this, "Password Changed Successfully");
                    clear();
                }

                else{
                    JOptionPane.showMessageDialog(this, "Incorrect Answer! Please try again");
                    AN.setText("");
                    PS.setText("");
                }
            }

        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }                                  

    private void BKMouseClicked(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:

        int a = JOptionPane.showConfirmDialog(null, "Do you want to close?","Select",JOptionPane.YES_NO_OPTION);
        if(a==0){
            new selectAccount().setVisible(true);
            this.setVisible(false);
        }

    }                               

    private void CLMouseClicked(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:

        int a = JOptionPane.showConfirmDialog(null, "Do you want to close?","Select",JOptionPane.YES_NO_OPTION);
        if(a==0){
            System.exit(0);
        }
    }                               

    private void ELKeyReleased(java.awt.event.KeyEvent evt) {                               
        // TODO add your handling code here:
        validateEmail();
    }                              

    private void SHMouseClicked(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:

        // THE SEARCH BUTTON//

        String email = EL.getText();

        try {
            pst = con.prepareStatement("Select * from accounts");
            rs = pst.executeQuery();

            while(rs.next()){ 
                String eml = rs.getString("EMAIL");

                if(email.equals(eml)){
                    SH.setEnabled(false);
                    EL.setEditable(false);                    
                    SQ.setText(rs.getString("SQUESTION"));
                    validateField();

                }
                else{
                    JOptionPane.showMessageDialog(this, "Email not found");
                }
            }
        } catch (SQLException ex) {
            Logger.getLogger(forgotPass.class.getName()).log(Level.SEVERE, null, ex);
        }

    }                               

    private void SHMouseEntered(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:
        mouseicon2();
    }                               

    private void SHMouseExited(java.awt.event.MouseEvent evt) {                               
        // TODO add your handling code here:
        ImageIcon srch = new ImageIcon("search.png");
        //
        Image sch = srch.getImage();
        Image schScale = sch.getScaledInstance(SH.getWidth(), SH.getHeight(), Image.SCALE_SMOOTH);
        ImageIcon scaledsch = new ImageIcon(schScale);
        SH.setIcon(scaledsch);
    }                              

    private void SHMousePressed(java.awt.event.MouseEvent evt) {                                
        // TODO add your handling code here:
        mouseicon();
    }                               

    private void SHMouseReleased(java.awt.event.MouseEvent evt) {                                 
        // TODO add your handling code here:
        mouseicon2();
    }                                

    private void SQKeyReleased(java.awt.event.KeyEvent evt) {                               
        // TODO add your handling code here:
        validateField();
    }                              

    private void ELKeyPressed(java.awt.event.KeyEvent evt) {                              
        // TODO add your handling code here:
    }                             

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(forgotPass.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(forgotPass.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(forgotPass.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(forgotPass.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new forgotPass().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JTextField AN;
    private javax.swing.JLabel BK;
    private javax.swing.JLabel CL;
    private javax.swing.JLabel DT;
    private javax.swing.JTextField EL;
    private javax.swing.JPasswordField PS;
    private javax.swing.JLabel SH;
    private javax.swing.JLabel SI;
    private javax.swing.JTextField SQ;
    private javax.swing.JLabel TM;
    private javax.swing.JButton UD;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel12;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    // End of variables declaration                   
}

this is the video for more info about the problem. i hope you can hep me guys.thank you

https://github.com/apache/netbeans/assets/136215452/022dd14e-5c4b-4cbe-97a2-6eb4c9a6acca

Did this work correctly in an earlier version?

No / Don't know

Operating System

Laptop Lenovo, processor: Intel(R) Celeron(R) N4020 CPU @ 1.10GHz 1.10 GHz, Windows 11 Home Single Language

JDK

jdk-20-window-x64

Apache NetBeans packaging

Apache NetBeans provided installer

Anything else

This always occurs when i connected to mysql phpmyadmin database, but sometimes it works at once but first but in the next days it will not work

Are you willing to submit a pull request?

No

mbien commented 1 year ago

hi @kelvin1918, this issue tracker is for NetBeans bugs, we can't really help you with your project.

mbien commented 1 year ago

however lets convert this issue to a discussion.