Efficiently fill resultset in object model

Posted by Zeeshan on Stack Overflow See other posts from Stack Overflow or by Zeeshan
Published on 2010-05-20T08:47:19Z Indexed on 2010/05/20 8:50 UTC
Read the original article Hit count: 150

Filed under:
|
|

Hi, I have an object model whose structure is
Dashboard
  List of panels
    List of containers
      List of widgets
If i get whole dashboard, with panels + containers + widgets, from Database then multiple I/O requires I want to get it in one I/O .For this i prepared a query which gives me this resultset.

DASHBOARDID   PANELID  CONTAINERID  WIDGETID
13                          11                    5              2
13                          11                    5              3
13                          11                    6              4
13                          11                    6              5
13                          12                    7              6
13                          12                    7              7
13                          12                    8              8
13                          12                    8              9

Using list datastructure this model is able to be filled but it takes time i want to efficiently fill this resultset in above object model. is there nay way ?

© Stack Overflow or respective owner

Related posts about java-ee

Related posts about jdbc