FirstJFrame

import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.SwingConstants;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class FirstJFrame extends JFrame {

    private JPanel contentPane;
    Connection conn=null;
    PreparedStatement pst =null;
    ResultSet rs=null;
    private JTextField usernameField;
    private JPasswordField passField;

    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    FirstJFrame frame = new FirstJFrame();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the frame.
     */
    public FirstJFrame()
    {
        setTitle("FirstFrame");
        design();
        conn= SQLConnection.ConnecrDb();

    }


            private void login() {
                try {
                    String query="SELECT * FROM EMPLOYEE WHERE E_Username = ? AND E_Password =?";

            pst = conn.prepareStatement(query);
            pst.setString(1, usernameField.getText());
            pst.setString(2, passField.getText());
            rs =pst.executeQuery();
            //int count =0;
            if(rs.next()) {
                JOptionPane.showMessageDialog(null, "Login Successfull");
                Management m= new Management();
                m.setVisible(true);
                dispose();
            }
            else {
                JOptionPane.showMessageDialog(null, "Login Failed");
            }
            pst.close();
            rs.close();

        }
        catch(Exception e) {
            e.printStackTrace();

        }
    }

    private void design()
    {

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 450, 300);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);

        JButton btnLogin = new JButton("Login");
        btnLogin.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                login();
            }
        });
        btnLogin.setBounds(153, 175, 89, 23);
        contentPane.add(btnLogin);

        JButton btnSignupHere = new JButton("Signup Here");
        btnSignupHere.setBounds(128, 209, 135, 23);
        contentPane.add(btnSignupHere);

        usernameField = new JTextField();
        usernameField.setHorizontalAlignment(SwingConstants.CENTER);
        usernameField.setBounds(45, 47, 117, 55);
        contentPane.add(usernameField);
        usernameField.setColumns(10);

        passField = new JPasswordField();
        passField.setHorizontalAlignment(SwingConstants.CENTER);
        passField.setBounds(192, 47, 135, 55);
        contentPane.add(passField);
    }
}