Jesfre <[EMAIL PROTECTED]> writes:
>
>
> Hi all...
> I want to get all Users was in "admin" role... This is a third table from
> relationship User-Role
> How to get all user in "admin" role from this?
I do this by adding a dao method in UserDao:
public List listUserInRole(String RoleName);
And, implement it as follow:
public List listUserInRole(String roleName) {
StringBuffer sb = new StringBuffer();
sb.append("SELECT DISTINCT user from ")
.append (User.class.getName() + " user ")
.append (" JOIN user.roles roles ")
.append (" WHERE roles.name = '" + roleName +"' ");
return this.getHibernateTemplate().find(sb.toString());
}
Try it, cheers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
