public User getUser(String user) throws SQLException { start(); rs = stmt.executeQuery("SELECT * FROM userInfo WHERE username = '******'"); User rtrn = null; if (rs.next()) { rtrn = new User(); rtrn.setUserName(rs.getString(1)); rtrn.setPassWord(rs.getString(2)); rtrn.setFirstName(rs.getString(3)); rtrn.setLastName(rs.getString(4)); rtrn.setEmail(rs.getString(5)); long number = 0; String num = rs.getString(6); if (num != null) number = Long.parseLong(num.replace("-", "").replace("(", "").replace(")", "")); rtrn.setPhoneNumber(number); rtrn.setCity(rs.getString(7)); rtrn.setState(rs.getString(8)); rtrn.setRating(rs.getInt(9)); } close(); return rtrn; }