CN117435269A - Interface-based custom query export expansion method, device and medium - Google Patents
Interface-based custom query export expansion method, device and medium Download PDFInfo
- Publication number
- CN117435269A CN117435269A CN202311386140.2A CN202311386140A CN117435269A CN 117435269 A CN117435269 A CN 117435269A CN 202311386140 A CN202311386140 A CN 202311386140A CN 117435269 A CN117435269 A CN 117435269A
- Authority
- CN
- China
- Prior art keywords
- export
- interface
- extension
- expansion
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000009795 derivation Methods 0.000 claims description 10
- 238000011161 development Methods 0.000 claims description 8
- 230000007246 mechanism Effects 0.000 claims description 5
- 239000012190 activator Substances 0.000 claims description 4
- 230000008878 coupling Effects 0.000 abstract description 4
- 238000010168 coupling process Methods 0.000 abstract description 4
- 238000005859 coupling reaction Methods 0.000 abstract description 4
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a custom query export expansion method, equipment and medium based on an interface, belongs to the technical field of information, and is used for solving the technical problems that an existing digital query platform is high in data coupling performance, poor in expansion capability and incapable of meeting complex personalized export requirements. The method comprises the following steps: creating a corresponding extended export interface in the digital query platform according to the export requirement of the user; in the digital query platform, secondarily developing an interface implementation class based on the extended export interface; configuring extension information and setting an extension switch in the digital inquiry platform; and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user. The method can dynamically load the customized derived implementation class in the digital query platform, quickly respond to various derived requirements of users, and improve the derived expandability of the digital query platform.
Description
Technical Field
The present disclosure relates to the field of information technologies, and in particular, to a method, an apparatus, and a medium for deriving and expanding a user-defined query based on an interface.
Background
The export requirements involved with the data in the digitized query platform will be different due to the different services. The current digital query platform can meet most personalized exports, such as value export, text export, paging export and the like. However, for complex scenarios, such as exporting data into Excel, some clients need to export into one Excel and insert into a different sheet page, and rename the sheet; some clients need to export to different excels; some of the materials need to be packed and exported; some wish to sort document exports by data columns, and so on. The existing digital query platform has over-high data coupling performance, poor adaptability and expansion capability for the export function in the product, and cannot meet the complex personalized requirements.
Disclosure of Invention
The embodiment of the application provides a custom query export extension method, device and medium based on an interface, which are used for solving the following technical problems: the existing digital query platform has higher data coupling performance and poorer expansion capability, and cannot meet the complex personalized export requirement.
The embodiment of the application adopts the following technical scheme:
in one aspect, an embodiment of the present application provides a method for extending a user-defined query export, where the method includes: creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
In a possible implementation manner, the creating a corresponding extended export interface in the digital query platform according to the export requirement of the user specifically includes:
determining required interface parameters according to the derived requirements of the user;
creating a corresponding extended export interface in the digital query platform according to the interface parameters, and giving public authority to the extended export interface;
wherein the extended export interface provides a standard structure for secondary development implementation classes.
In a possible implementation manner, in the digital query platform, the interface implementation class based on the extended export interface is secondarily developed, and specifically includes:
performing secondary development in the digital query platform, and creating an interface implementation class of the extended export interface;
according to the export requirement of the user, customizing corresponding personalized export logic, and configuring export data acquisition parameters in the personalized export logic;
compiling the personalized export logic to generate dll files.
In a possible implementation manner, the configuration of the derived data acquisition parameters in the personalized derived logic specifically includes:
configuring a data export address in an export data parameter serverPagingPubQueryClient of an extended export interface so as to acquire export data required by a user through the export data parameter;
and configuring a start page and an end page in a start page parameter startPageNo and an end page parameter endPageNo of the extended export interface so as to acquire the number of data pages required to be exported by a user through the start page parameter and the end page parameter.
In a possible implementation manner, the method for configuring the extension information and setting the extension switch in the digital query platform specifically includes:
adding an expansion configuration file based on Json in the digital query platform;
configuring dll files and class information of the interface implementation classes into the extension configuration files as extension information; wherein the class information comprises at least a class name and a namespace;
and configuring an expansion switch in the expansion configuration file based on the expansion information.
In a possible implementation manner, according to the extension information and the extension switch, when exporting data, the interface implementation class is dynamically loaded to realize the export requirement of the user, which specifically includes:
adding an expansion branch in the digital query platform;
determining whether to execute an extension branch according to an extension switch configured in the extension configuration file;
if the extension branch is executed, dynamically loading a program set in the extension configuration file through a system. Reflection. Createinstance reflection mechanism;
when data is exported, a system activator is used for creating an instance of the interface implementation class, and personalized export logic in the interface implementation class is obtained;
based on the personalized export logic, the set of programs is executed to fulfill the export needs of the user.
In a possible implementation manner, determining whether to execute an extension branch according to an extension switch configured in the extension configuration file specifically includes:
acquiring a switch configuration parameter exportExtendValue in the extension configuration file;
if the value of the switch configuration parameter is true, executing an expansion branch; the instruction of the extension branch is as follows: exporting a plurality of excel files according to pages;
and if the value of the switch configuration parameter is false, executing a default branch.
In a possible implementation manner, based on the personalized export logic, the program set is executed to realize the export requirement of the user, and specifically includes:
loading the extension configuration file in a Json file loading mode, and analyzing each parameter in the extension configuration file;
loading the extension information in the extension configuration file and the parsed parameters into the program set;
and executing the program set to derive the required data based on the data export address and the data page number in the personalized export logic.
On the other hand, the embodiment of the application also provides a custom query export extension device, which comprises: at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to cause the at least one processor to perform:
creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
Finally, embodiments of the present application also provide a computer storage medium that is a non-volatile computer-readable storage medium storing at least one program, each of the programs including instructions that, when executed by a terminal, cause the terminal to perform:
creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
Compared with the prior art, the method, the device and the medium for expanding the custom query export have the following beneficial effects:
the invention discloses a custom inquiry export expansion method, equipment and medium, which are characterized in that an expansion export interface is created in the existing digital inquiry platform, and interface realization classes based on the expansion export interface are secondarily developed, so that personalized export logic is custom-defined; setting an expansion gateway and configuring expansion information in a digital query platform; when the data is exported, the interface implementation class is dynamically loaded according to the expansion switch and the expansion information to realize different export requirements. Compared with the prior art, the method and the system have the advantages that the custom derived implementation class can be dynamically loaded in the digital query platform, various derived requirements of users can be responded quickly, and the derived expandability of the digital query platform is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments described in the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
FIG. 1 is a flowchart of a method for expanding custom query derivation according to an embodiment of the present application;
fig. 2 is a schematic structural diagram of a custom query export extension device according to an embodiment of the present application.
Detailed Description
In order to better understand the technical solutions in the present application, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, shall fall within the scope of the present application.
The embodiment of the application provides a custom query export extension method, as shown in fig. 1, which specifically includes steps S101-S104:
s101, creating a corresponding extended export interface in the digital query platform according to the export requirement of the user.
Specifically, according to the export requirements set forth by different users, the required interface parameters are extracted. And developing a corresponding extended export interface in the digital query platform according to the interface parameters. And gives public rights to the extended export interface. Wherein the extended export interface provides a standard structure for the secondary development implementation class.
As a possible implementation mode, an extended export interface is developed in a digital query platform based on constraint and opening mechanisms of the interface, and provides a standard structure for secondary development of implementation class compliance, so that the class or structure of the implementation interface is consistent in form, and universal processing service is provided for irrelevant classes.
As a possible implementation, the code to develop the export interface is as follows:
(1) The parameters needed in the user derived needs are determined (e.g., client, backsroundworker, startPageNo, endPageNo are all the parameters needed here).
(2) Create an extended export interface (e.g., ipubquery exportextension herein):
s102, in the digital query platform, interface implementation classes based on the expansion export interfaces are secondarily developed.
Specifically, secondary development is performed in the digital query platform, and an interface implementation class of the extended export interface is created.
Further, according to the export requirement of the user, corresponding personalized export logic is customized, and export data acquisition parameters are configured in the personalized export logic. And finally compiling the personalized export logic to generate dll files.
As a possible implementation, the data export address is configured in the export data parameter serverPagingpubQueryClient of the extended export interface to obtain the export data required by the user through the export data parameter. And configuring a start page and an end page in a start page parameter startPageNo and an end page parameter endPageNo of the extended export interface so as to acquire the number of data pages required to be exported by a user through the start page parameter and the end page parameter.
The secondary developer creates an interface implementation class, takes the data through the interface, and writes personalized export logic according to the requirements of clients. In this process, the secondary developer only needs to pay attention to the personalized export logic.
As a possible implementation, the code of the secondary development interface implementation class and the custom export logic is as follows:
(1) Defining a service class (such as PubQueryExportExpension) and realizing an interface IPubQueryExportExpension:
public class PubQueryExportExtend:IPubQueryExportExtend；
(2) The self export logic is realized in the service class, export data is obtained through a parameter serverPagingPubQueryClient in the interface, and the number of data pages is obtained through a start page startPageNo and an end page endPageNo:
s103, configuring extension information in the digital query platform and setting an extension switch.
Specifically, json-based extension profiles are added to the digitized query platform. The dll file with the interface realization class is configured into an expansion configuration file by taking the class information as expansion information; wherein the class information includes at least a class name and a namespace.
Further, an expansion switch is configured in the expansion configuration file based on the expansion information.
As a possible implementation manner, a configuration file is added in the query platform, and codes for setting configuration switches and extension class information are as follows:
wherein: the extendstre set to true, the extension interface can be triggered;
asembly: dll where the extended class is located;
className: the extended class name contains the namespace.
S104, dynamically loading interface realization classes according to the expansion information and the expansion switch when the data is exported, and realizing the export requirement of the user.
Specifically, an extension branch is added in the digital query platform. And determining whether to execute the extension branch according to the extension switch configured in the extension configuration file. If the extension branch is executed, dynamically loading the program set in the extension configuration file through a system. Reflection. Createinstance reflection mechanism.
Further, when exporting data, an instance of the interface implementation class is created using the system activator, and personalized export logic in the interface implementation class is obtained. Based on the personalized export logic, a set of programs is executed to fulfill the export needs of the user.
As a possible implementation manner, acquiring a switch configuration parameter exportextendsvalue in an extension configuration file; if the value of the switch configuration parameter is true, executing an extension branch; the instruction for expanding the branch is as follows: a plurality of excel files are exported per page. If the value of the switch configuration parameter is false, a default branch is executed.
Specifically, by loading the Json file, the extension configuration file is loaded, and each parameter in the extension configuration file is analyzed. And loading the extension information in the extension configuration file and the parsed parameters into a program set. The program set is executed to derive the desired data based on the data derivation address and the number of data pages in the personalized derivation logic.
As a possible implementation mode, an expansion branch is added in a query platform, whether the expansion branch is walked is determined according to a configuration switch in a configuration file, a program set in the expansion configuration file is dynamically loaded through a system. Reflection. Createinstance reflection mechanism, and a system activator is used for creating an instance of a two-port interface implementation class, so that personalized export logic is obtained in the running process. The application program identifies whether to walk the extension branch or not through the configuration file when running, and the extension branch automatically calls the personalized export logic.
As a possible implementation manner, the code in the digital query platform that decides whether to walk the extension branch according to the configuration switch and reflect the dynamically generated object in the extension branch is as follows:
in addition, the embodiment of the application further provides a custom query export extension device, as shown in fig. 2, where the custom query export extension device specifically includes:
at least one processor; and a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform:
creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
Finally, an embodiment of the present application further provides a computer storage medium, wherein the computer storage medium is a non-volatile computer readable storage medium, and at least one program is stored in the non-volatile computer readable storage medium, and each program includes instructions that, when executed by a terminal, cause the terminal to perform:
creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
The invention discloses an interface-based expansion method for user-defined query derivation, which comprises the following implementation steps: opening a export interface in an existing query platform; creating an interface implementation class based on an interface, and customizing personalized export logic; setting an expansion switch in the query platform and configuring expansion information; and during export, according to the expansion switch and the expansion information, dynamically loading the implementation class of two-way operation at the running time to realize different export requirements. Compared with the prior art, the interface-based extension method for custom query export can dynamically load custom export realization class in running, quickly respond to various export demands of users, and improve the expandability of query platform export. The method can meet the personalized requirements of all clients, enhance the expandability of export, meet various export requirements, reduce the data coupling and improve the self-adaption capability of the digital query platform.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present specification.
It will be appreciated by those skilled in the art that the present description may be provided as a method, system, or computer program product. Accordingly, the present specification embodiments may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present description embodiments may take the form of a computer program product on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.
The present description is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the specification. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The description may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for apparatus, devices, non-volatile computer storage medium embodiments, the description is relatively simple, as it is substantially similar to method embodiments, with reference to the section of the method embodiments being relevant.
The foregoing describes specific embodiments of the present disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
The foregoing is merely one or more embodiments of the present description and is not intended to limit the present description. Various modifications and alterations to one or more embodiments of this description will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, or the like, which is within the spirit and principles of one or more embodiments of the present description, is intended to be included within the scope of the claims of the present description. .
Claims (10)
1. A custom query derivation extension method, the method comprising:
creating a corresponding extended export interface in the digital query platform according to the export requirement of the user;
in the digital query platform, secondarily developing an interface implementation class based on the extended export interface;
configuring extension information and setting an extension switch in the digital inquiry platform;
and dynamically loading the interface implementation class according to the extension information and the extension switch when the data is exported, so as to realize the export requirement of the user.
2. The method for deriving and expanding a customized query according to claim 1, wherein the creating a corresponding extended derivation interface in the digitized query platform according to the derived requirement of the user specifically comprises:
determining required interface parameters according to the derived requirements of the user;
creating a corresponding extended export interface in the digital query platform according to the interface parameters, and giving public authority to the extended export interface;
wherein the extended export interface provides a standard structure for secondary development implementation classes.
3. The method for deriving and expanding a custom query according to claim 1, wherein in the digital query platform, the interface implementation class based on the derived and expanded interface is developed secondarily, specifically comprising:
performing secondary development in the digital query platform, and creating an interface implementation class of the extended export interface;
according to the export requirement of the user, customizing corresponding personalized export logic, and configuring export data acquisition parameters in the personalized export logic;
compiling the personalized export logic to generate dll files.
4. A method of extending a custom query derivation according to claim 3, wherein configuring derived data acquisition parameters in the personalized derivation logic comprises:
configuring a data export address in an export data parameter serverPagingPubQueryClient of an extended export interface so as to acquire export data required by a user through the export data parameter;
and configuring a start page and an end page in a start page parameter startPageNo and an end page parameter endPageNo of the extended export interface so as to acquire the number of data pages required to be exported by a user through the start page parameter and the end page parameter.
5. The method for deriving and expanding a customized query according to claim 1, wherein configuring expansion information and setting expansion switches in the digital query platform comprises:
adding an expansion configuration file based on Json in the digital query platform;
configuring dll files and class information of the interface implementation classes into the extension configuration files as extension information; wherein the class information comprises at least a class name and a namespace;
and configuring an expansion switch in the expansion configuration file based on the expansion information.
6. The method for deriving and expanding a custom query according to claim 5, wherein dynamically loading the interface implementation class to implement the derived requirement of the user when deriving data according to the expansion information and the expansion switch, specifically comprises:
adding an expansion branch in the digital query platform;
determining whether to execute an extension branch according to an extension switch configured in the extension configuration file;
if the extension branch is executed, dynamically loading a program set in the extension configuration file through a system. Reflection. Createinstance reflection mechanism;
when data is exported, a system activator is used for creating an instance of the interface implementation class, and personalized export logic in the interface implementation class is obtained;
based on the personalized export logic, the set of programs is executed to fulfill the export needs of the user.
7. The method for deriving expansion of a custom query according to claim 6, wherein determining whether to execute an expansion branch according to an expansion switch configured in the expansion configuration file comprises:
acquiring a switch configuration parameter exportExtendValue in the extension configuration file;
if the value of the switch configuration parameter is true, executing an expansion branch; the instruction of the extension branch is as follows: exporting a plurality of excel files according to pages;
and if the value of the switch configuration parameter is false, executing a default branch.
8. The method of claim 6, wherein executing the set of programs based on the personalized export logic to fulfill the export needs of the user, comprises:
loading the extension configuration file in a Json file loading mode, and analyzing each parameter in the extension configuration file;
loading the extension information in the extension configuration file and the parsed parameters into the program set;
and executing the program set to derive the required data based on the data export address and the data page number in the personalized export logic.
9. A custom query-derived extension device, the device comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a custom query derivation extension method according to any one of claims 1-8.
10. A computer storage medium, characterized in that it is a non-volatile computer-readable storage medium storing at least one program, each of said programs comprising instructions, which when executed by a terminal, cause the terminal to perform the custom query derivation extension method according to any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311386140.2A CN117435269A (en) | 2023-10-24 | 2023-10-24 | Interface-based custom query export expansion method, device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311386140.2A CN117435269A (en) | 2023-10-24 | 2023-10-24 | Interface-based custom query export expansion method, device and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117435269A true CN117435269A (en) | 2024-01-23 |
Family
ID=89552792
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311386140.2A Pending CN117435269A (en) | 2023-10-24 | 2023-10-24 | Interface-based custom query export expansion method, device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117435269A (en) |
-
2023
- 2023-10-24 CN CN202311386140.2A patent/CN117435269A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108958796B (en) | Service request processing method and device and service request processing system | |
| CN107450981B (en) | Block chain consensus method and equipment | |
| CN109725989B (en) | Task execution method and device | |
| CN107786630B (en) | Web application package processing method, device and equipment | |
| CN107479868B (en) | Interface loading method, device and equipment | |
| CN101446903A (en) | Automatic component classification method | |
| CN114547024A (en) | SQL statement risk detection method, device, equipment and medium | |
| CN113094028A (en) | Windows desktop program development framework, method and related components | |
| CN107391529B (en) | Method and device for realizing Object Relation Mapping (ORM) | |
| CN112235132B (en) | Method, device, medium and server for dynamically configuring service | |
| CN111459573B (en) | Method and device for starting intelligent contract execution environment | |
| CN107402749B (en) | Method and device for realizing picture loading library | |
| WO2020135129A1 (en) | Method and device for loading plug-in of application, and terminal | |
| CN117435269A (en) | Interface-based custom query export expansion method, device and medium | |
| CN108769152B (en) | Service refresh policy registration method, service refresh request method, device and equipment | |
| CN116382713A (en) | Method, system, device and storage medium for constructing application mirror image | |
| CN107368486B (en) | Service migration method and device | |
| CN107291439B (en) | Target incremental data construction method and device | |
| CN111651160B (en) | Plug-in construction and webpage design method and device | |
| KR101140522B1 (en) | System and Method for Managing Object | |
| CN111158940B (en) | Method and device for docking and dynamically loading different devices in field of Internet of things | |
| CN103347059A (en) | Method, client-side and system for realizing user configuration parameter transmission | |
| CN113835680A (en) | Application program generation method and device, electronic equipment and computer storage medium | |
| CN110659105A (en) | Virtualized resource processing method, device, equipment and storage medium | |
| CN110688430A (en) | Method and device for obtaining data bypass and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |