Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Information custom exporting method and device

A technology for self-defining and annotating information, applied in the field of information self-defining export methods and devices, can solve the problems of many database queries, unknown export requirements, redundancy, etc., and achieve the effect of simplifying the whole process, reducing memory usage and information conversion

Active Publication Date: 2020-05-08
SURFILTER NETWORK TECH +1
View PDF8 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Information custom exporting method and device
  • Information custom exporting method and device
  • Information custom exporting method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] refer to figure 1 , figure 1 It is a schematic flowchart of an embodiment of an information custom export method in the present invention. In one embodiment, the information custom export method includes:

[0053] Step S10, obtaining the JavaBean object, and extracting the annotation information in the JavaBean object through the reflection class;

[0054]In this embodiment, the information custom export method runs in the Spring Boot or SpringMvc-associated Mybatis database management environment. Among them, Spring Boot is a new framework provided by the Pivotal team. Its design purpose is to simplify the initial construction and development process of new Spring applications; Spring MVC is a follow-up product of SpringFrameWork, which has been integrated into Spring Web Flow; mybatis is a An excellent persistence layer framework that supports custom SQL, stored procedures, and advanced mapping. Among them, the JavaBean object is obtained by writing, and the JavaB...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F16/242G06F40/18
CPCG06F16/258G06F16/2433Y02D10/00
Inventor 王升陈浪刘永强周勇林沈智杰景晓军
Owner SURFILTER NETWORK TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products