Membuat Login Multi User dengan Java Netbeans

Buatlah sebuah database dengan nama db_login lalu buat tabel seperti gambar berikut :

Buatlah sebuah project dengan desain form login sebagai berikut :

Double klik button LOGIN dan masukan Script berikut :

       if (jTextField1.getText().equals("") && jPasswordField1.getText().equals("")) {

            JOptionPane.showMessageDialog(null, "Masukkan id dan password!!"); }

        else if (jTextField1.getText().equals("") || jPasswordField1.getText().equals("")) {

            JOptionPane.showMessageDialog(null, "Lengkapi data"); }

        else {

           

       koneksi kon = new koneksi();

       ResultSet rs = null;

        try

        {

            rs = kon.getData("select * from user where username = '"+jTextField1.getText()+"' and password = '"+jPasswordField1.getText()+"'and level = 'admin'");

            while(rs.next())

                    {

                       

                    dispose();

                    admin adm = new admin();       

                    java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();

    adm.setLocation((screenSize.width/2 - adm.getWidth()/2), (screenSize.height/2 - adm.getHeight()/2));

                    adm.setVisible(true);

                    JOptionPane.showMessageDialog(null, "Login Berhasil");

                   

                    }

               rs.close();

        }

                  catch (Exception e)

                    {

                        JOptionPane.showMessageDialog(null, "GAGAL LOGIN !");

                    }

        try

         {

            rs = kon.getData("select * from user where username = '"+jTextField1.getText()+"' and password = '"+jPasswordField1.getText()+"'and level = 'operator'");;

            while (rs.next())

                    {

                      

                    dispose();

                    operator op = new operator();       

                    java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();

        op.setLocation((screenSize.width/2 - op.getWidth()/2), (screenSize.height/2 - op.getHeight()/2));

                    op.setVisible(true);

                    JOptionPane.showMessageDialog(null, "Login Berhasil");

                  

                      

                    }

             rs.close();

         }

                    catch (Exception e)

                    {

                        JOptionPane.showMessageDialog(null, "GAGAL LOGIN !");

                    }

         }