Please can someone point out to me why the commented lines aren't been executed?
public boolean managerLogin(int id, String usn, String pwd, boolean in){ try{ try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); }catch(Exception e){ JOptionPane.showMessageDialog(null, e.getMessage()); } java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/phoneShopSystem","aknessy", dbLogin.db()); String query = "SELECT managerID, managerUsername, managerPwd" + " FROM manager WHERE managerID = ? AND" + " managerUsername = ? AND" + " managerPwd = ?"; java.sql.PreparedStatement pst= con.prepareStatement(query,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); pst.setInt(1, id); pst.setString(2, usn); pst.setString(3, pwd); rset = pst.executeQuery(); if(rset.next()){ int i = rset.getInt(1); String u = rset.getString(2); String p = rset.getString(3); /*From Here if((i == id) && (u.equals(usn)) && (p.equals(pwd))){ in = true; new managerCorner(); }else{ in = false; JOptionPane.showMessageDialog(null, "The User: "+ usn +" With ID "+ id + " \n" + "Does Not Exist!", "\nLogin Failed!", JOptionPane.OK_OPTION); } To Here aren't been executed!*/ rset.close(); con.close(); } }catch(SQLException sql){ JOptionPane.showMessageDialog(null, sql.getMessage(),"SQL ERROR!!!", JOptionPane.OK_OPTION); } return in; }