Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

featching data from DataBase

 
surya chintalapudi
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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


notene user haveing any no. of role.....roles must be seperated by ,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic