private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
       String passwordBefore= String.valueOf(passwordOO.getPassword());
       String password = passwordBefore.trim();
       String username = usernameOO.getText().trim();
       if(password.length() <= 0 || username.length() <= 0){
           JOptionPane.showMessageDialog(null, "Please fill the required text "
                   + "fields in order to login!");
       }else{
       try{
        int count = 0;
        Connection myConn = DriverManager.getConnection("jdbc:mysql://frame.fpso.dk/javadb_dat2016", "java_guru", "tf58Nc?5");
        Statement mySt = myConn.createStatement();
        ResultSet myRS = mySt.executeQuery("SELECT username, password FROM users WHERE username='" + username + "'AND password='" + password+"'");
        while (myRS.next()){
        count++;
        }

        if(count == 0){
            JOptionPane.showMessageDialog(null, "Incorrect login, please try again");
        }

        if(count == 1){
            JOptionPane.showMessageDialog(null, "WELCOME " + username + " \n \n Successful Login");
            LibraryWorker window = new LibraryWorker();
            setVisible(false);
            window.setVisible(true);
        }
    }catch(Exception ex){
        System.out.println("Error:" + ex);
    }
       }
    }