Introduction to converting query data into String type in SpringMVC

Previously, we wanted to discuss with customers to make several fixed reports for use, but found that customers needed various reports every month, so we made a window for directly executing SQL statements; the amount of data was It was not very big at first and the queried data was relatively small (about 1 to 6W), so it was very useful in the first few months. The queried data was directly copied from the page and pasted into Excel to make monthly reports. So a year passed. I have done three issues recently and found that the operation and maintenance personnel were very busy in the last few days at the end of the month. The data exceeded one million (sweat), and the SQL query statement had to be written in multiple pages. . . .

My partners are so miserable, let me save them ~

My solution is roughly as follows:

It needs paging and does not need to be displayed on the page)

　B>Convert all query result fields into String type on the backend (mainly solves the data type conversion problem of BigDeceal and long types in JXL)

C>Page the queried data by 6W/per page (mainly because JXL can only export EXCEL files of the . # D>The queried data is traversed and paginated (it should be noted that the sheet name needs to be named according to the current data volume and location, and the EXCEL style is a fixed style)

The above is the detailed content of Introduction to converting query data into String type in SpringMVC. For more information, please follow other related articles on the PHP Chinese website!