my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes featching data from DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "featching data from DataBase" Watch "featching data from DataBase" New topic

featching data from DataBase

surya chintalapudi

Joined: Sep 13, 2012
Posts: 9

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 ,
I agree. Here's the link:
subject: featching data from DataBase
It's not a secret anymore!