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;
  }