//Forward to the jsp page for rendering
request.getRequestDispatcher("/person/ListPerson.jsp").forward(request, response);
}
private void generateCorrespondingRoles(Connection connection, Person person) throws SQLException{
Role role = null;
RoleRelationship roleRelationship = null;
List<RoleRelationship> roleRelationships = null;
PreparedStatement statement4Role = null;
ResultSet roleResults = null;
statement4Role = connection.prepareStatement(SQL_QUERY_PERSON_ROLES);
statement4Role.setLong(1, person.getId());
roleResults = statement4Role.executeQuery();
roleRelationships = new ArrayList<RoleRelationship>();
while(roleResults.next()){
role = new Role();
role.setId(roleResults.getLong("PERSON_ROLE_ID"));
role.setName(roleResults.getString("ROLE_NAME"));
roleRelationship = new RoleRelationship();
roleRelationship.setRole(role);
roleRelationships.add(roleRelationship);
}