showing Data from 2 tables in jsf
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   pratap_tripathy
Posted On:   Thursday, January 31, 2008 09:57 AM

I am developing a project in jsf and JPA I have one table called employees with column Name,Job_code,Dept_code For employee table I have a entity I have another table called ListOfValues with column Prefix,Lov_code and Lov_desc Prefix can be JOB(for job) and DEP(for department) I want to display these columns Name Job desc(=lov_desc, comes from ListOfValues for prefix-JOB and lov_code=job_code) dept_desc(=lov_desc, comes from ListOfValues for prefix-DEPand lov_code=dept_code) I have got a session bean which does query(em.createquery(....)) and shows data using jsf datatable. It shows Name,Job_code,Dept_code fine. now I want to get job_desc and dept_desc in sa   More>>

I am developing a project in jsf and JPA

I have one table called employees with column
Name,Job_code,Dept_code
For employee table I have a entity

I have another table called ListOfValues with column
Prefix,Lov_code and Lov_desc
Prefix can be JOB(for job) and DEP(for department)

I want to display these columns
Name
Job desc(=lov_desc, comes from ListOfValues for prefix-JOB and lov_code=job_code)
dept_desc(=lov_desc, comes from ListOfValues for prefix-DEPand lov_code=dept_code)

I have got a session bean which does query(em.createquery(....)) and shows data using jsf datatable. It shows Name,Job_code,Dept_code fine. now I want to get job_desc and dept_desc in same table

Can anyone please tell me how to do it. Any help will be highly appreciated.Thanks...

   <<Less
About | Sitemap | Contact