public User getUserDetails(String userId) { PreparedStatement ps = null; ResultSet rs = null; User user = null; RegisterService registerService = new RegisterService(); try { ps = connection.prepareStatement("SELECT * FROM user WHERE username=? LIMIT 1"); ps.setString(1, username); rs = ps.executeQuery(); if (rs != null && rs.next()) { user = new User(userId); user.setFirstName(rs.getString("firstname")); user.setLastName(rs.getString("lastname")); user.setEmail(rs.getString("email")); user.setPhoneNumber(rs.getString("primaryPhone")); user.setCellphone(rs.getString("secondaryPhone")); user.setAddress(registerService.createAddressFromID(rs.getInt("addressID"))); user.setCard(registerService.createCardFromID(rs.getInt("creditCardID"))); } } catch (SQLException e) { e.printStackTrace(); } return user; }