private User extractUser(ResultSet rs) throws SQLException { User user = new User(); user.setId(rs.getLong("id")); user.setEmail(rs.getString("email")); user.setPassword(rs.getString("password")); user.setFirstName(rs.getString("f_name")); user.setLastName(rs.getString("l_name")); user.setRole(Role.get(rs.getLong("role_id"))); return user; }