How to convert all query data to the String type in SpringMVC, springmvcstring
Previously, I wanted to discuss several fixed reports with the customer and found that the customer needed various reports every month. Therefore, we made a window to directly execute SQL statements; at the beginning, the data volume is not very large, and the amount of data queried is small (about 1 ~ (About), so it was very useful in the first few months. The queried data was copied directly from the page and pasted to Excel for monthly reports. That's how one year has passed. Recently, we made three phases, it was found that the O & M personnel were very busy for several days at the end of the month. The data volume was over one million (sweaty), and the SQL query statements had to write n multiple pages ....
My friends are so lucky. Let me save them ~
My solutions are as follows:
A> Add A button for querying the inverted Excel table on the page (no paging or display on the page is required)
B> convert all query result fields to the String type at the backend (mainly solve the data type conversion problem of BigDeceal and long types in JXL)
C> sort the queried data by 6 W/Page (mainly because JXL can only be exported. EXCEL files of the XLS file type (2003 type). Therefore, each sheet can contain up to 65536 rows of data)
D> query the data through pages (note that the sheet name must be named based on the current data volume and location, and the EXCEL Style is fixed)
(Coming soon ~)