aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "featching data from DataBase" Watch "featching data from DataBase" New topic
Author

featching data from DataBase

surya chintalapudi
Greenhorn

Joined: Sep 13, 2012
Posts: 9
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 ,
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: featching data from DataBase
 
Similar Threads
Storing XML in the Database
[Hibernate] Many-to-many with non-changing data on one side
How to mapping cmr field into DB with WSAD5.0
Logic:iterator issue in Struts 1.3.10
JPA data retrieval query