public String getroles(String userName) {
System.out.println("checkrole");
String qry =
"SELECT ur FROM UserRole ur "
+ "JOIN FETCH ur.role "
+ "WHERE "
+ "ur.user.userName = '******'";
System.out.println("query = " + qry);
List<UserRole> userroles = em.createQuery(qry, UserRole.class).getResultList();
System.out.println("Query uitgevoerd");
String roles = "";
int i = 0;
for (UserRole ur : userroles) {
roles = roles + ur.getRole().getName();
i++;
if (i < userroles.size()) {
roles = roles + ",";
}
}
System.out.println("roles = " + roles);
return roles;
}
public ReturnStatus checkrole(String userName, String roleName) {
System.out.println("checkrole");
boolean rolefound = false;
String qry =
"SELECT ur FROM UserRole ur "
+ "JOIN FETCH ur.user "
+ "JOIN FETCH ur.role "
+ "WHERE "
+ "ur.user.userName = '******' AND "
+ "ur.role.name = '"
+ roleName
+ "'";
System.out.println("query = " + qry);
List<UserRole> userroles = em.createQuery(qry, UserRole.class).getResultList();
System.out.println("Query uitgevoerd");
for (UserRole ur : userroles) {
String foundRole = ur.getRole().getName();
System.out.println(
" User = "******" Role = "
+ foundRole
+ " UserRoleId = "
+ ur.getUserRoleId());
if (foundRole.equalsIgnoreCase(roleName)) {
rolefound = true;
}
}
if (rolefound) {
return new ReturnStatus(true);
} else {
return new ReturnStatus(false);
}
}