NetBeans Forums

FAQ

Memberlist

Profile

selected data from multiple tables

NetBeans Forums -> Java EE Users

View previous topic :: View next topic

Author

Message

javaislife

Joined: 20 Jun 2009
Posts: 12

Posted: Tue Jan 19, 2010 3:31 pm Post subject: selected data from multiple tables

Hi guys,

I am doing a project in netbeans using Visual JSF(project woodstock). I have tried doing a table in netbeans which displays all or selected data from a table in the database. How do I do come up with a table which shows data extracted from various tables in a database? An example would be the following SQL statement:

Code:

select bookingdate, bookingstarttime, bookingendtime, username
from booking, user, user_has_booking
where user_has_booking.iduser = user.iduser
and user_has_booking.idbooking = booking.idbooking;

How do I get the same result that the above query would give, but in a JSF environment where we are not dealing with SQL directly. I am using netbeans version 6.5.1, the glassfish server and Toplink essentials for persistance. I hope someone can advise. Thanks.

regards
JavaisLife

Display posts from previous:

	NetBeans Forums -> Java EE Users	All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum