This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes featching data from DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Logic:iterator issue in Struts 1.3.10
JPA data retrieval query
[Hibernate] Many-to-many with non-changing data on one side
How to mapping cmr field into DB with WSAD5.0
Storing XML in the Database