private void LoginButtonActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_LoginButtonActionPerformed // TODO add your handling code here: String sql = "select * from bruker where brukerNavn=? and brukerPassord=?"; try { int userType = accountType.getSelectedIndex(); pst = conn.prepareStatement(sql); pst.setString(1, UsrInput.getText()); pst.setString(2, PswdInput.getText()); rs = pst.executeQuery(); if (rs.next()) { // JOptionPane.showMessageDialog(null,"Username and password is correct"); close(); if (userType == 0) { MainPage m = new MainPage(); m.setVisible(true); } else { fMainPage fm = new fMainPage(); fm.setVisible(true); } } else { JOptionPane.showMessageDialog(null, "Username or password is incorrect"); } } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } } // GEN-LAST:event_LoginButtonActionPerformed