posted 11 years ago
Hi,
iam new from the Hibernate and spring..i hav a one query.i want to fetch data from database.we have 3 tables users,roles,userroles
the fields of users table is userid,loginid,password,status,createdby,updatedby,,createdts,updatedts.
the fields of roles table is roleid,rolename,roledesc.
the fields of usersroles table is userroleid,userid,roleid,status,createdby,updatedby,,createdts,updatedts.
in my front end i want dispaly loginid and raolename.
Ex: loginid role
kevin admin,tester
steve admin
surya developer,admin,aa
note:one user haveing any no. of role.....roles must be seperated by ,