Shulou(Shulou.com)06/02 Report--

This article mainly introduces "the method of MyBatis mass streaming data query and data export". In the daily operation, I believe that many people have doubts about the method of MyBatis mass streaming data query and data export. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "MyBatis mass streaming data query and data export method". Next, please follow the editor to study!

If you need to export a large amount of data to a file, querying millions or more of data to memory at one time may lead to a direct memory overflow crash of JVM. Even if it does not crash, it will cause JVM to GC frequently, and verification affects speed and stability!

Therefore, streaming export is used to write to the file while querying.

Take exporting excel as an example:

Data reading:

Public File exportExcel (Integer userId) {excel=openExcel (); locationViewDao.getListForExcel (userId, new ResultHandler () {@ Override public void handleResult (ResultContext)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.