I have 3 tables table1-A,B,C,D, table2-E,F,G, table3-H,I,J. There is a 1-many relationship between tables 1 & 2 <-> B->F and similarly between F->I. I created entity classes(POJO) for 3 tables.
Now, user has to fill up a page with columns B,F,I i.e 1 column from each table. And the search results will consist of 2 columns from each table displayed on a separate page.
My issue is how do I take care of mapping. Do I create 1) 3 persistence classes 2) 3 POJOs and 1 persistence class mapped to search result page.
|