jsp imports large amounts of data to excel_html/css_WEB-ITnose

Please help me.
----------------
I use jsp to export excel, and the java code written in the jsp page takes out the data, and then Export excel file.
Now the question arises, is it ok if the quantity is small. But if there is a large amount of data, such as 50,000 records, the data can be fetched to the jsp page, but the page will always be stuck and cannot be exported to excel. Does anyone know how to solve it?

Reply to the discussion (solution )

Why do you have to write java code on jsp? It’s very troublesome. The general approach is to submit the data retrieval conditions to the background, then re-fetch it from the database, use POI to operate Excel, generate it, and then export it.

This should be left to the database