Information custom exporting method and device

Abstract

The invention discloses an information custom exporting method and device. The method comprises the steps: acquiring and extracting annotation information in a JavaBean object; acquiring to-be-selected field information from the annotation information and returning the to-be-selected field information to the front end for display; obtaining attribute set information based on the selection operation of the user; mapping the attribute set information and the JavaBean object to obtain a matching attribute and a patch field set in the JavaBean; receiving a query condition, and determining a corresponding total data amount based on the query condition and the attribute set information; if the export timeout event does not exist, integrating the matching attribute set in the JavaBean with the mybatis to obtain integrated information; receiving a user-defined sql query statement uploaded by a user, and performing querying to obtain a result value; comparing and matching the result value withthe patch field set to obtain a final information set; and setting a format of an excel table based on the annotation information corresponding to the attribute set information, and importing a finalinformation set into the excel table after the setting is completed. According to the invention, the information custom export process is simplified.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for customizing and exporting information. Background technique [0002] At present, when exporting in a fixed way, the Excel header and query result return set are all certain, and developers need to be familiar with the export function of Excel. Developers can directly complete the mapping in the code and match all the information one by one. Export the final result value, but in the custom query, the export requirements of the user are unknown. If all the information is still returned to the user, there is a situation that does not meet the business requirements, and the information is too redundant. It is necessary to filter the data that the user cares about. If According to this design, there will be a lot of unnecessary information queries, resulting in many database queries, high pressure, redundant information processing, etc. There may also b...

AI Technical Summary

Problems solved by technology

[0002] At present, when exporting in a fixed way, the Excel header and query result return set are all certain, and developers need to be familiar with the export function of Excel. Developers can directly complete the mapping in the code and match all the information one by one. Export the final result value, but in the custom query, the export requirements of the user are unknown. If all the information is still returned to the user, there is a situation that does not meet the business requirements, and the information is too redundant. It is necessary to filter the data that the user cares about. If According to this design, there will be a lot of unnecessary information queries, resulting in many database queries, high pressure, redundant information processing, etc. There may also be excessive data volume, query needs to be paged, switch data sources, multi-thread optimization, Excel A series of issues such as format and export timeout need to be dealt with

Images