• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Pintu choudhary
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Pintu choudhary
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic