public boolean findUser(String un, String pwd) { Connection con = null; try { con = DBConnectionFactory.getConnection(); String sql = "select count(uname) from user_details" + " where uname='" + un + "' and pass='******'"; PreparedStatement st = con.prepareStatement(sql); ResultSet rs = st.executeQuery(); rs.next(); int count = rs.getInt(1); return (count == 1); } catch (SQLException e) { e.printStackTrace(); } finally { try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } // finally return false; }