CN115576977A

CN115576977A - Data paging query method and device, electronic equipment and storage medium

Info

Publication number: CN115576977A
Application number: CN202211307593.7A
Authority: CN
Inventors: 吴误; 王亚峰
Original assignee: Agricultural Bank of China
Current assignee: Agricultural Bank of China
Priority date: 2022-10-24
Filing date: 2022-10-24
Publication date: 2023-01-06

Abstract

The embodiment of the invention discloses a data paging query method, a data paging query device, electronic equipment and a storage medium. Responding to a data paging query request, and modifying an initial paging parameter corresponding to the data paging query request into a user-defined paging parameter; and generating a data paging query statement based on the self-defined paging parameters, and executing the data paging query statement so as to perform data paging query in a database. The technical scheme of the embodiment of the invention not only can more flexibly carry out paging query on the data, but also can avoid the condition of abnormal paging query of the data caused by version conflict.

Description

Data paging query method and device, electronic equipment and storage medium

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a data paging query method and apparatus, an electronic device, and a storage medium.

Background

In the related art, the data paging query is usually performed based on the paging parameter in the data paging plug-in. If the demand for paging inquiry changes, at this time, a professional is required to modify the paging parameters by modifying the source codes of the data paging plug-in, and then reissue the paging parameters. Therefore, the modification mode has the problem of not only the risk of version conflict, but also the technical problem of poor flexibility of data paging query.

Disclosure of Invention

In view of the foregoing problems, the present invention provides a data paging query method, apparatus, electronic device, and storage medium, so as to implement paging query on data more flexibly and avoid abnormal paging query of data due to version conflict.

According to an aspect of the present invention, a data paging query method is provided, where the method includes:

responding to a data paging query request, and modifying an initial paging parameter corresponding to the data paging query request into a user-defined paging parameter;

and generating a data paging query statement based on the self-defined paging parameters, and executing the data paging query statement so as to perform data paging query in a database.

Optionally, the method further comprises:

based on the predefined paging object, obtaining the self-defined paging parameter from the predefined paging class for creating the paging object.

Optionally, the modifying an initial paging parameter corresponding to the data paging query request into a custom paging parameter includes:

intercepting a paging method corresponding to the data paging query request;

and determining an initial paging parameter in the paging method, and modifying the initial paging parameter into a user-defined paging parameter.

Optionally, the method for intercepting the page corresponding to the data page query request includes:

and calling a predefined paging interceptor and intercepting a paging method corresponding to the data paging query request.

Optionally, the method for intercepting the page corresponding to the data page query request by calling a predefined page interceptor includes:

and determining a method to be executed, and if the method to be executed is determined to be a paging method corresponding to the data paging query request, calling a predefined paging interceptor to intercept the paging method.

Optionally, before the invoking the predefined paging interceptor, the method further comprises:

and registering the paging interceptor.

Optionally, the generating a data paging query statement based on the custom paging parameter includes:

based on a predefined parameter setting object, reassigning the self-defined paging parameter to an entry parameter of a paging query statement generation method corresponding to the data paging query request;

and after assignment is completed, calling the paging query statement generation method to generate the data paging query statement.

According to another aspect of the present invention, a data paging query apparatus is provided. The device includes:

the parameter modification module is used for responding to a data paging query request and modifying an initial paging parameter corresponding to the data paging query request into a user-defined paging parameter;

and the paging query module is used for generating a data paging query statement based on the self-defined paging parameter, and executing the data paging query statement so as to perform data paging query in a database.

According to another aspect of the present invention, there is provided an electronic apparatus including:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the data paging query method according to any of the embodiments of the present invention.

According to another aspect of the present invention, a computer-readable storage medium is provided, which stores computer instructions for causing a processor to implement the data paging query method according to any one of the embodiments of the present invention when the computer instructions are executed.

According to the technical scheme of the embodiment of the invention, the initial paging parameter corresponding to the data paging query request is modified into the self-defined paging parameter by receiving the data paging query request. And then, based on the self-defined paging parameters, generating a data paging query statement, and executing the data paging query statement to perform data paging query in a database. The technical scheme of the embodiment of the invention not only can more flexibly carry out paging query on the data, but also can avoid the condition of abnormal paging query of the data caused by version conflict.

It should be understood that the statements in this section are not intended to identify key or critical features of the embodiments of the present invention, nor are they intended to limit the scope of the invention. Other features of the present invention will become apparent from the following description.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic flowchart of a data paging query method according to an embodiment of the present invention;

fig. 2 is a schematic structural diagram of a data paging query apparatus according to a third embodiment of the present invention;

fig. 3 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention.

Detailed Description

In order to make those skilled in the art better understand the technical solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, shall fall within the protection scope of the present invention.

It should be noted that the terms "comprises" and "comprising," and any variations thereof, in the description and claims of this invention and the above-described drawings are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements explicitly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example one

Fig. 1 is a schematic flow diagram of a data paging query method according to an embodiment of the present invention, which is applicable to a scenario of paging query on data, where the data paging query method may be executed by a data paging query device, and the data paging query device may be implemented in a form of hardware and/or software, and may be configured in an electronic device, such as a computer or a server, for example, in an electronic device providing a data paging query function. As shown in fig. 1, the method of the present embodiment includes:

s110, responding to the data paging inquiry request, and modifying the initial paging parameter corresponding to the data paging inquiry request into a self-defined paging parameter.

The data paging query request may be understood as a request for performing a data paging query. The data paging query request can be obtained in various ways, for example, a click operation acting on a data paging query control is received, and the data paging query request is generated based on the click operation; or receiving a data paging query instruction input by the data paging query input box, and generating a data paging query request based on the data paging query instruction. The data paging query request may include a database name, a query keyword, a query condition, and the like. The initial paging parameter may be understood as a default paging parameter set for how the data query results should be paged. In the embodiment of the present invention, the initial paging parameter is a paging parameter set for a data paging query function in programming. The initial paging parameters may include the current page number, the total number of records (interceptor assignments), the total number of pages, the number of display pieces per page (initial value set to 500), and the like. The number of display strips per page is understood to mean that each page may include up to several query data strips. The custom paging parameter can be understood as a paging parameter set according to an actual query requirement. It is understood that, in the embodiment of the present invention, the custom paging parameter may include at least one of a current page number, a total page number, and a number of display bars per page.

Specifically, a data paging query request is received. After receiving a data paging query request, data custom paging parameters can be obtained, and initial paging parameters corresponding to the data paging query request are intercepted. After the initial paging parameter is intercepted, the intercepted initial paging parameter can be modified into the obtained custom paging parameter, so that the initial paging parameter corresponding to the data paging query request can be modified under the condition of not modifying codes.

In the embodiment of the present invention, obtaining the custom paging parameter may include: based on the predefined paging object, obtaining the self-defined paging parameter from the predefined paging class for creating the paging object.

Where the predefined page objects may be objects created based on predefined page classes. In other words, the predefined page objects are instances of predefined page classes. The predefined paging objects may be used to obtain custom paging parameters, that is, may be used to obtain custom paging parameters. The predefined paging classes may be understood as predefined classes for configuring custom paging parameters.

Specifically, predefined page classes. A paging object is created based on the paging class. After the paging object is created, the method and/or attribute of the paging object for setting the paging parameter may be called through the paging object created by the paging class, that is, the method and/or variable for setting the paging parameter in the paging class are called. Thereby obtaining the configuration and the self-defined paging parameters in the paging class. It will be appreciated that the custom paging parameters may be configured in methods and/or variables for setting the paging parameters in the paging class. It should be noted that, after creating the paging object based on the paging class, the method and/or the variable for setting the paging parameter in the paging class may be used as the method and/or the attribute for setting the paging parameter in the paging object.

Optionally, the modifying the initial paging parameter corresponding to the data paging query request to a custom paging parameter may include: intercepting a paging method corresponding to the data paging query request; and determining an initial paging parameter in the paging method, and modifying the initial paging parameter into a user-defined paging parameter.

The paging method may be understood as a method having a paging query function, and may be used to query data and page queried results. The paging method may be provided with an initial paging parameter.

Specifically, after receiving a data query request, a paging method corresponding to the data query request may be determined. And loading the paging method to a memory. After the paging method is loaded into the memory and before the paging method is run in the memory, the paging method may be intercepted. After intercepting the paging method, an initial paging parameter in the paging method may be determined. And then the initial paging parameter can be modified into a custom paging parameter.

Optionally, the intercepting a paging method corresponding to the data paging query request may include: and calling a predefined paging interceptor and intercepting a paging method corresponding to the data paging query request. A predefined paging interceptor may be understood as a predefined interceptor for intercepting a paging method before it is executed.

Further, the method for intercepting the paging corresponding to the data paging query request by calling a predefined paging interceptor may include: and determining a method to be executed, and if the method to be executed is determined to be a paging method corresponding to the data paging query request, calling a predefined paging interceptor to intercept the paging method.

A method to be executed is understood to be a method to be executed, i.e. a method that needs to be executed at a time next to the current time.

In an embodiment of the invention, a method to be executed is determined. So that the identity of the method to be performed can be determined. And then the identifier of the method to be executed can be compared with the identifier of the paging method. If the identifier of the to-be-executed method is consistent with the identifier of the paging method, it may be determined that the to-be-executed method is the paging method corresponding to the data paging query request. Therefore, a predefined paging interceptor can be called to intercept the method to be executed, namely, the predefined paging interceptor can be called to intercept the paging method.

On the basis of the above embodiment, before the invoking of the predefined paging interceptor, the method further comprises: the page interceptors are registered to facilitate efficient loading of the page interceptors so that the interceptors can be used.

And S120, generating a data paging query statement based on the self-defined paging parameter, and executing the data paging query statement to perform data paging query in a database.

The paging query statement may be a database execution statement generated based on a custom paging parameter, and may be used to query data in a database and page a query result.

Specifically, after the initial paging parameter corresponding to the data paging query request is modified into the custom paging parameter, the data paging query statement may be generated based on the custom paging parameter. The data paging query statement may then be acted on a database and executed in the database. Therefore, data query and paging of query results are carried out in the database.

In this embodiment of the present invention, the generating a data paging query statement based on the custom paging parameter may include: based on a predefined parameter setting object, reassigning the self-defined paging parameter to an entry parameter of a paging query statement generation method corresponding to the data paging query request; and after assignment is completed, calling the paging query statement generation method to generate the data paging query statement.

The parameter setting object can be used for reassigning the custom parameter to the entry parameter of the paging query statement generation method. The paging query statement generation method may be a predefined method for generating the paging query statement. The entry parameter of the generation method of the paging query statement may be understood as a form parameter of the generation method of the paging query statement. The self-defined paging parameters are reassigned to the entry parameters of the paging query statement generation method, and it can be understood that the self-defined paging parameters are used as actual parameters and are assigned to the form parameters of the paging query statement generation method.

Example two

The third embodiment of the present invention provides an optional embodiment of a data paging query method, which takes mybatis plus self-contained paging plug-in as an example, and performs data paging query based on the mybatis plus self-contained paging plug-in. Specific embodiments thereof can be seen in the following examples. The technical terms that are the same as or corresponding to the above-mentioned embodiments are not described in detail herein.

The method of the embodiment specifically comprises the following steps:

1. when the mybatis plus self-contained paging plug-in receives a data paging query request, a method to be executed can be determined. If the method to be executed is the paging method corresponding to the data paging query request, a predefined paging interceptor can be called to intercept the paging method.

2. After intercepting the paging method, a custom paging parameter may be obtained from a predefined paging class (Page class) used to create the paging object based on a predefined paging object (Page object). And initial paging parameters in the paging method may be determined. And then the initial paging parameter can be modified into a custom paging parameter. Namely, the initial paging parameter in the paging method is modified to the custom paging parameter.

3. After the modification is completed, the self-defined paging parameters can be reassigned to the entry parameters of the paging query statement (paging query sql) generation method corresponding to the data paging query request based on a predefined parameter setting object (StatementHandler);

4. and after assignment is completed, calling the paging query statement generation method to generate the data paging query statement. And the data paging query statement can be executed to perform data paging query in the database.

According to the technical scheme of the embodiment of the invention, on the basis of using the paging plug-in built in the MybatisPlus, the database paging query statements needing paging can be intercepted from the root, and the database paging query statements meeting the service requirements are spliced to realize a new paging plug-in, so that paging query can be performed on data more flexibly, and the condition that data paging query is abnormal due to version conflict can be avoided.

EXAMPLE III

Fig. 2 is a schematic structural diagram of a data paging query apparatus according to a third embodiment of the present invention. As shown in fig. 2, the apparatus includes: a parameter modification module 210 and a page lookup module 220.

The parameter modification module 210 is configured to, in response to a data paging query request, modify an initial paging parameter corresponding to the data paging query request into a custom paging parameter; the paging query module 220 is configured to generate a data paging query statement based on the self-defined paging parameter, and execute the data paging query statement to perform data paging query in a database.

According to the technical scheme of the embodiment of the invention, the data paging query request is received through the parameter modification module, and the initial paging parameter corresponding to the data paging query request is modified into the self-defined paging parameter. And then a data paging query statement is generated by the paging query module based on the self-defined paging parameters, and the data paging query statement is executed so as to perform data paging query in a database. The technical scheme of the embodiment of the invention not only can more flexibly carry out paging query on the data, but also can avoid the condition of abnormal paging query of the data caused by version conflict.

Optionally, the apparatus further comprises: and the self-defined parameter acquisition module is used for acquiring self-defined paging parameters in the pre-defined paging class for creating the paging object based on the pre-defined paging object.

Optionally, the user-defined parameter obtaining module is specifically configured to intercept a paging method corresponding to the data paging query request; and determining an initial paging parameter in the paging method, and modifying the initial paging parameter into a custom paging parameter.

Optionally, the custom parameter obtaining module includes a method intercepting unit, where the method intercepting unit is configured to invoke a predefined paging interceptor and intercept a paging method corresponding to the data paging query request.

Optionally, the method intercepting unit is specifically configured to determine a method to be executed, and if it is determined that the method to be executed is a paging method corresponding to the data paging query request, call a predefined paging interceptor to intercept the paging method.

Optionally, the apparatus further includes an interceptor registration module, configured to register the paging interceptor before the call of the predefined paging interceptor.

Optionally, the paging query module 220 is specifically configured to assign the custom paging parameter to an entry parameter of a paging query statement generation method corresponding to the data paging query request again based on a predefined parameter setting object; and after assignment is completed, calling the paging query statement generation method to generate the data paging query statement.

The data paging query device provided by the embodiment of the invention can execute the data paging query method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.

It should be noted that, the units and modules included in the data paging query apparatus are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the invention.

Example four

FIG. 3 illustrates a schematic diagram of an electronic device 10 that may be used to implement an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 3, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various dedicated Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, and so forth. The processor 11 performs the various methods and processes described above, such as the data paging query method.

In some embodiments, the data paging query method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the data paging query method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the data paging query method by any other suitable means (e.g., by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.

It should be understood that various forms of the flows shown above, reordering, adding or deleting steps, may be used. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.

The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A data paging query method is characterized by comprising the following steps:

2. The method of claim 1, further comprising:

3. The method of claim 1, wherein modifying an initial paging parameter corresponding to the data paging query request to a custom paging parameter comprises:

intercepting a paging method corresponding to the data paging query request;

4. The method of claim 3, wherein intercepting the paging corresponding to the data paging query request comprises:

5. The method of claim 4, wherein intercepting the paging corresponding to the data paging query request by invoking a predefined paging interceptor comprises:

6. The method of claim 4, wherein prior to the invoking the predefined paging interceptor, the method further comprises:

and registering the paging interceptor.

7. The method of claim 1, wherein generating a data paging query statement based on the custom paging parameter comprises:

8. A data paging query apparatus, comprising:

9. An electronic device, characterized in that the electronic device comprises:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,

the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data paging query method of any one of claims 1-7.

10. A computer-readable storage medium storing computer instructions for causing a processor to perform the data paging query method of any one of claims 1-7 when executed.