aspose file tools*
The moose likes Spring and the fly likes Spring MVC, Jquery: multispan cells table, huge data to display, every cell has different colors Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Spring MVC, Jquery: multispan cells table, huge data to display, every cell has different colors" Watch "Spring MVC, Jquery: multispan cells table, huge data to display, every cell has different colors" New topic
Author

Spring MVC, Jquery: multispan cells table, huge data to display, every cell has different colors

Pintu choudhary
Greenhorn

Joined: Dec 25, 2013
Posts: 2
I want to display a report which has multispan rows and columns. I am using Spring MVC, Jquery. In worst case, no of rows is 360 and columns is 3000. hence, total no of cell, in worst case, for a report is around 10 lakhs.

Also, every cell has different colors and attributes and on click of each cell some operations need to be performed and display result in tooltip of that cell. Can someone tell me which technology in java should i use to display the report so that performance overhead will be minimum and multispan functionality can be achieved? OR can someone tell me how to achieve the above functionality?
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1671
    
    7

Are you generating a report that they download, or is there a UI where they need to be able to interact with this data? If its the latter it sounds like you need a combination of some sort of client side datatables JavaScript library together with server side pagination so that all of this data is not sent at once.

I don't think this question applies to Spring directly at this point. Its a mix of different things and needs to be broken down into smaller pieces.


[How To Ask Questions][Read before you PM me]
Pintu choudhary
Greenhorn

Joined: Dec 25, 2013
Posts: 2
Hi Bill, thanks a lot for the reply. I need to display the report in the UI, where they will be able to intract from back end (server side/Database). Additionally, i need to provide a functionality to download(export) the report data, along with header, in excel file. can you please tell more specifically the technologies/ways so that both of these can be achieved?

Yes, you are right. This question is not directly related to Spring, its just that i am using Spring MVC for this web application.


Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1671
    
    7

There is more than one way to solve this problem. I can give you one idea to investigate. Note this problem is to big to discuss in a single forum post. So once you start if you encounter problems you are going to have to break your questions into something smaller and post it in the correct forum.

For the datatables for displaying things to the user have a look at :

http://datatables.net/

For integrating datatables and Spring you can have a look at this
http://dandelion.github.io/datatables/

Pagination will have to happen on the database side of things. If you are using JPA you can use Spring-data
http://dandelion.github.io/datatables/

Exporting is also incorporated in there have a look at the documentation for those projects.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Spring MVC, Jquery: multispan cells table, huge data to display, every cell has different colors