The invention provides a data dynamic exporting method and
system based on template configuration. The method comprises the steps that a data exporting request for exporting data in a
data source in a report form is obtained; verifying the user permission data in the request to generate a
verification result; when the
verification result is that the
verification is passed, generating a dynamic
SQL statement according to template
metadata corresponding to the template classification data; executing
paging query according to the dynamic
SQL statement, and performing
data processing and streaming writing on data acquired from a
data source to which data to be exported belongs in batches; and when the
paging query is finished and
data processing and streaming writing of the data obtained in the last batch are completed, generating a
temporary file, and returning a downloading link to the
client for triggering downloading of the data in the
temporary file and generating a report corresponding to the
data export request. According to the method and the
system, the template adjustment efficiency is improved, the memory consumption is reduced, and the
big data export success rate is greatly improved.