How to generate multiple html tables dynamically over jsp using servlets?

Question

hey guys i have a situation in which i am getting a array string of selected building names and another array string of selected building subsystems. So based on the user selection i have to generate a report in which for each building a different table has to be created over jsp page.

So the table should be like one building name in first column and the chosen subsystem in second column rows. Other columns have heading 2011, 2012 upto 2016.Hence there can be multiple table but with same set of subsystems at a time. The values in other blocks comes in based on some calculation. Its kind of forecast report in which if for eg. roofing for some building has renewal cost in 2011 then its value should come at right place.

And finally i have to get the total at the bottom of each table and further a table in which must be having grand total for each column.

here is the sample table for better understanding:-

enter image description here So can anyone suggest me what approach i should take. I can generate the table by using two for loops one for buildings and other for subsystem inside buildings

like

 for(int i ; int<building.lenth; i++){
       for(int k ; i<subsystem.lenth; i++){
      //over here i subdivide the loop into various if and else if's based on the chosen subsystem and access database everytime for each subsystem 
and get their respective values for calculations over jsp directly. In that case i'm not able to total all the columns.
    And in all its a bad practice to access database like that from jsp and doing java over jsp.
    }
    }

So the question is how should i handle this situation. What data structures can help me achieve this goal. Thanks in advance. :)

Hm, I'm not sure if I understand the problem. You have to define the data structures (objects) required to implement the use case. I think this question is still too generic... — home
– home, Commented Aug 10, 2011 at 17:13

atrain · Accepted Answer · 2011-08-10 17:29:39Z

3

There are existing JSP taglibs to create tables on the fly based on your data. A good example is DisplayTag. You will probably find an example on the DisplayTag site of what you want to do, and will end up having more concise JSP code.

answered Aug 10, 2011 at 17:29

atrain

9,2951 gold badge39 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dhruv Over a year ago

Thanks, DisplayTag is nice option but is there any sample source code which may help me to understand the proper throwing of data and catching values in displaytag. I checked the link given by you but still i'm not much clear on how to use them

atrain Over a year ago

If you're loking for DisplayTag's source code, its available @ sourceforge.net/projects/displaytag/files/… . If you're looking for examples of how to use DisplayTag, it has multiple examples on the site, under the "Tutorials" section.

Collectives™ on Stack Overflow

How to generate multiple html tables dynamically over jsp using servlets?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related