WO2019071898A1

WO2019071898A1 - Electronic device, database query script generation method and storage medium

Info

Publication number: WO2019071898A1
Application number: PCT/CN2018/076183
Authority: WO
Inventors: 高梁梁
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-10-09
Filing date: 2018-02-10
Publication date: 2019-04-18
Also published as: CN107844519A

Abstract

An electronic device, a database query script generation method and a storage medium. The method comprises: when a relevant data query needs to be performed on a database, generating one database query instruction based on data to be queried, and retrieving a pre-stored database query template (S301); traversing main directories of the database query template based on a category of the data to be queried, so as to acquire a main directory matching the category of the data to be queried and various function sub-directories under the matched main directory (S302); if a function sub-directory matching a function attribute of the data to be queried under the category of the data to be queried exists in the function sub-directories, acquiring a pre-configured sql script file under the function sub-directory (S303); and replacing a corresponding second query parameter in the sql script file with a first query parameter, so as to obtain a corresponding database query script (S304). The method simplifies the database query process, and improves database query efficiency.

Description

Electronic device, database query script generation method and storage medium

This application claims priority to Chinese Patent Application No. 200910929614.1, entitled "Electronic Device, Database Query Script Generation Method and Storage Medium", which is filed on October 9, 2017, the entire contents of which are incorporated by reference. In this application.

Technical field

The present application relates to the field of software development, and in particular, to an electronic device, a database query script generation method, and a storage medium.

Background technique

With the development of the Internet, the development and application of software has become more and more extensive. In the process of software product development and testing, in order to ensure that the developed content is correctly saved to the database, the software developer needs to frequently interact with the database for data and query the database-related content from time to time.

At present, the commonly used query method is that the software developer writes a corresponding database query script according to the query content. Although this kind of query method can accurately query the required data, since the developer writes the corresponding database query script and queries the related data, the database query script is not uniformly managed, resulting in different project development. During the test, or in different development stages of the same project, when the data to be queried is the same as the previously queried data, or the data to be queried is similar to the previously queried data in the functional attributes, the used data cannot be quickly obtained. Database query scripts, many times developers need to repeatedly write database query scripts that have been used before, resulting in wasted developers a lot of time, and the problem of slow data query and low efficiency.

Summary of the invention

In view of this, the present application provides an electronic device, a database script generation method, and a storage medium, which solves the problem that the database query in the prior art is cumbersome and time consuming, thereby achieving the effect of simplifying the database query process and improving the database query efficiency.

First, in order to achieve the above object, a first aspect of the present application provides an electronic device, a memory of the electronic device, and a processor connected to the memory, where the memory stores a database script generating program, where the processor is used to Executing a database script generation program stored on the memory, the database script generation program being executed by the processor to implement the following steps:

If the database needs to perform related data query, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

Traversing the main directory of the database query template based on the category, acquiring a home directory matching the category, and each function subdirectory under the matching home directory;

If the function sub-directory has a function sub-directory that matches the function attribute of the to-be-queried data in the category, the pre-configured sql script file in the function sub-directory is obtained;

The corresponding second query parameter in the sql script file is replaced with the first query parameter, and a corresponding database query script is obtained.

In addition, in order to achieve the above object, the second aspect of the present application further provides a database query script generating method, where the method includes the following steps:

Further, in order to achieve the above object, a third aspect of the present application further provides a computer readable storage medium storing a database query script generating program, where the database query script generating program can be processed by at least one Executing to cause the at least one processor to perform the following steps:

Compared with the prior art, the electronic device, the database query script generating method and the storage medium proposed by the present application generate a database query instruction based on the data to be queried when the related data query needs to be performed on the database, and retrieve the pre-stored a database query template; traversing the home directory of the database query template based on the category of the query data, obtaining a home directory matching the category of the query data, and each function subdirectory under the home directory; if each function subdirectory has and is to be queried If the function sub-directory of the data in the category matches the function sub-directory, the pre-configured sql script file in the function sub-directory is obtained; the corresponding second query parameter in the sql script file is replaced with the first query parameter, and the corresponding The database query script simplifies the database query process and improves the database query efficiency.

DRAWINGS

1 is a schematic diagram of a hardware architecture of a preferred embodiment of an electronic device proposed by the present application;

2 is a schematic diagram of a program module corresponding to a database query script generation program in an embodiment of an electronic device of the present application;

FIG. 3 is a schematic diagram of an implementation process of a preferred embodiment of a method for generating a database query script according to the present application.

The implementation, functional features and advantages of the present application will be further described with reference to the accompanying drawings.

Detailed ways

In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

It should be noted that the descriptions of "first", "second" and the like in the present application are for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. . Thus, features defining "first" and "second" may include at least one of the features, either explicitly or implicitly. In addition, the technical solutions between the various embodiments may be combined with each other, but must be based on the realization of those skilled in the art, and when the combination of the technical solutions is contradictory or impossible to implement, it should be considered that the combination of the technical solutions does not exist. Nor is it within the scope of protection required by this application.

Referring to FIG. 1 , it is an optional hardware architecture diagram of the electronic device proposed by the present application. In this embodiment, the electronic device 10 may be a PC (Personal Computer), or may be a terminal device such as a smart phone, a tablet computer, an e-book reader, or a portable computer.

The electronic device 10 includes, but is not limited to, a memory 101, a processor 102, a network interface 103, and a communication bus 104. It should be noted that FIG. 1 only shows the electronic device 10 having the components 101-104, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.

The memory 101 includes at least one type of computer readable storage medium including a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), and a static Random access memory (SRAM), read only memory (ROM), electrically erasable programmable read only memory (EEPROM), programmable read only memory (PROM), magnetic memory, magnetic disk, optical disk, and the like. In some embodiments, the memory 101 can be an internal storage unit of the electronic device 10, such as a hard disk or memory of the electronic device 10. In other embodiments, the memory 101 may also be an outsourced storage device of the electronic device 10, such as a plug-in hard disk equipped on the electronic device 10, a smart memory card (SMC), and a secure digital (Secure Digital, SD) ) cards, flash cards, etc. Of course, the memory 101 can also include both an internal storage unit of the electronic device 10 and an outsourced storage device thereof. In this embodiment, the memory 101 is generally used to store an operating system installed in the electronic device 10 and various types of application software, such as program code of a database query script generating program. Further, the memory 101 can also be used to temporarily store various types of data that have been output or are to be output.

Processor 102 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 102 is typically used to control the overall operation of the electronic device 10. In this embodiment, the processor 102 is configured to run program code or processing data stored in the memory 101, such as a program code of a running database query script generating program.

The network interface 103 can include a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 10 and other electronic devices.

Communication bus 104 is used to implement a communication connection between components 101-103.

Optionally, the electronic device 10 may further include a user interface, and the user interface may include a display, an input unit such as a keyboard, and optionally, the user interface may further include a standard wired interface and a wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch sensor, or the like. The display may also be suitably referred to as a display screen or display unit for displaying information processed in the social network based user keyword extraction device and a user interface for displaying visualization.

In the electronic device embodiment shown in FIG. 1, a memory query script generation program is stored in the memory 101, and the processor 102 executes a database query script generation program stored in the memory 101.

In an embodiment, the database query script generation program is executed by the processor 102 to implement the following steps:

A. If a related data query is needed for the database, a database query instruction is generated based on the data to be queried, and a pre-stored database query template is retrieved, wherein the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

B. traversing the home directory of the database query template retrieved based on the category of the query data, obtaining a home directory matching the category of the query data, and each function subdirectory under the matching home directory;

C. If each function subdirectory has a function subdirectory that matches the function attribute of the data to be queried in the category, obtain a pre-configured sql script file in the function subdirectory;

D. Replace the corresponding second query parameter in the obtained sql script l file with the first query parameter, and obtain a corresponding database query script.

Understandably, software developers usually process multiple projects, and the same project contains multiple development stages. In order to satisfy developers, different pre-stored database queries can be invoked in different projects and at different stages of the same project. The template generates a database query script. In this embodiment, the pre-stored database query template includes at least one selectable home directory, and each home directory corresponds to one or more selectable function subdirectories for inputting a query. The field input area of the parameter and the script display area for displaying the generated query script. In this embodiment, the database query instruction generated based on the data to be queried includes a category of data to be queried, a function attribute of the data to be queried under the category, and a first query parameter. For example, the data to be queried is: querying the insured value corresponding to a policy number, and the data query to be queried according to the database query instruction generated by the query data is a policy, and the function attribute of the data to be queried under the policy is a forbidden value, And the first query parameter is the policy number.

After generating a database query instruction based on the data to be queried, and retrieving the pre-stored database query template, traversing the home directory of the database query template based on the category of the data to be queried, for example, traversing the home directory of the database query template based on the policy, further In the main menu, you can get the main catalog that matches the policy, and the corresponding function sub-directories under the policy, for example, policy sales, policy extension, batch, policy payment, policy insurance, policy and insurance information. It can be understood that the names of the main directory in the pre-stored database query template and the corresponding function sub-directories in each main directory can be customized by the developer according to the needs of the project. In this embodiment, each home directory The name of the data to be queried corresponds to the category of the data to be queried. For example, if the category of the data to be queried is a bank card, the corresponding home directory is a bank card, and the names of the respective functional subdirectories under each home directory are respectively associated with the sql stored therein. The function attributes of the scripts in the script file correspond one-to-one.

If each function subdirectory has a function sub-directory that matches the function attribute of the data to be queried in the category, for example, the function sub-directory policy insurance amount matches the insurance amount, further obtaining the pre-configured sub-directory of the function sub-directory Sql script file, understandably, the "script" in the sql script file represents the script name, the script name is written by the developer according to the project needs, the general script name is not too long, for example, the policy extension sql script, policy Sales of sql scripts, etc., and for the convenience of query and access, add a sequence number in front of the script name, for example, 01, 02, etc., the script content is written by the developer in advance, and the script content contains dynamically modified Second, query parameters, such as policy number, insured value, and so on.

Finally, the corresponding second query parameter in the pre-configured sql script in the matched function subdirectory is replaced with the first query parameter, and the corresponding database query script is obtained.

It can be understood that if each function sub-directory does not match the function attribute of the data to be queried in the query instruction, the corresponding prompt information is sent to remind the corresponding query personnel to write the data query script.

It should be further noted that the process of generating a database query script in a pre-stored database query template includes the following steps:

Read the SQLHelper home page, and create a home directory of the local storage script based on the SQLHelper home page, where the name of the home directory matches the category of the data to be queried;

Each function subdirectory is generated in the main directory, and each function subdirectory is used to store the sql script file, and the names of the respective function subdirectories are respectively matched with the function attributes of the script in the sql script file stored therein;

The query scripts written in the software development process are synchronously stored in the corresponding function subdirectories in the form of sql script files according to the function attributes of the scripts, and the query scripts in the database query template are obtained.

The electronic device proposed by the foregoing embodiment generates a database query instruction based on the data to be queried when the related data query needs to be performed, and retrieves a pre-stored database query template; traverses the home directory of the database query template based on the category of the query data. , obtaining a home directory matching the category of the query data, and each function subdirectory under the home directory; if each function subdirectory has a function subdirectory matching the function attribute of the data to be queried under the category, Obtain the pre-configured sql script file in the function subdirectory; replace the corresponding second query parameter in the sql script file with the first query parameter, and obtain the corresponding database query script, which simplifies the database query process and improves the database query efficiency. It should be further noted that the database query script generation program may describe the database query script generation program segment by using a virtual program module having the same function according to different functions implemented by each part of the program segment.

Please refer to FIG. 2 , which is a schematic diagram of a program module corresponding to a database query script generation program in an embodiment of the electronic device of the present application. In this embodiment, the database query script generating program may be divided into a calling module 201, a first matching module 202, a second matching module 203, and a replacement module 204. The functions or operational steps implemented by the respective program modules 201-204 described above are similar to the above, and are not described in detail herein, by way of example, for example:

The retrieving module 201 is configured to generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes the category of the data to be queried and the data to be queried. a function attribute under the corresponding category, and a first query parameter;

The first matching module 202 is configured to traverse the main directory of the database query template based on the category of the data to be queried, obtain a main directory that matches the category of the data to be queried, and each functional subdirectory under the matching main directory;

The second matching module 203 is configured to obtain a pre-configured sql script in the function sub-directory if there is a function sub-directory in each function sub-directory that matches the function attribute of the data to be queried in the corresponding category;

The replacement module 204 is configured to replace the corresponding second query parameter in the sql script file with the first query parameter to obtain a corresponding database query script.

In addition, the present application also provides a database query script generation method. Please refer to FIG. 3 , which is a schematic flowchart of an implementation process of a preferred embodiment of a database query script generation method. The method can be performed by a device that can be implemented by software and/or hardware.

In this embodiment, the database query script generation method includes:

Step S301: If a related data query is required to be performed on the database, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

Step S302, traversing the home directory of the retrieved database query template based on the category of the query data, obtaining a home directory matching the category of the query data, and each function subdirectory under the matching home directory;

Step S303, if there is a function sub-directory in the function sub-directory that matches the function attribute of the data to be queried in the category, the pre-configured sql script file in the function sub-directory is obtained;

Step S304, replacing the corresponding second query parameter in the obtained sql script file with the first query parameter, to obtain a corresponding database query script.

After generating a database query instruction based on the data to be queried and retrieving the pre-stored database query template, traversing the home directory of the database query template based on the category of the data to be queried, for example, traversing the home directory of the database query template based on the policy, further In the main menu, you can get the main catalog that matches the policy, and the corresponding function sub-directories under the policy, for example, policy sales, policy extension, batch, policy payment, policy insurance, policy and insurance information. It can be understood that the names of the main directory in the pre-stored database query template and the corresponding function sub-directories in each main directory can be customized by the developer according to the needs of the project. In this embodiment, each home directory The name of the data to be queried corresponds to the category of the data to be queried. For example, if the category of the data to be queried is a bank card, the corresponding home directory is a bank card, and the names of the respective functional subdirectories under each home directory are respectively associated with the sql stored therein. The function attributes of the scripts in the script file correspond one-to-one.

If each function subdirectory has a function sub-directory that matches the function attribute of the data to be queried in the category, for example, the function sub-directory policy insurance amount matches the insurance amount, further obtaining the pre-configured sub-directory of the function sub-directory Sql script file, understandably, the "script" in the sql script file represents the script name, the script name is written by the developer according to the project needs, the general script name is not too long, for example, the policy extension sql script, policy Sales of sql scripts, etc., and for the convenience of query and access, add a sequence number in front of the script name, for example, 01, 02, etc., the script content is written by the developer in advance, and the script content contains dynamically modified The second query parameter, for example, the policy number, the insured value, and the like.

Each function subdirectory is generated in the main directory, and each function subdirectory is used to store the sql script file, and the names of the respective function subdirectories are respectively matched with the function attributes of the scripts in the sql script file stored therein;

The database query script generation method proposed by the foregoing embodiment generates a database query instruction based on the data to be queried when the related data query needs to be performed, and retrieves a pre-stored database query template; traverses the database query template based on the category of the query data. The home directory, the home directory matching the category of the query data, and the function subdirectories under the home directory; if each function subdirectory has a function that matches the function attribute of the data to be queried under the category The directory obtains the pre-configured sql script file in the function subdirectory; replaces the corresponding second query parameter in the sql script file with the first query parameter, and obtains the corresponding database query script, which simplifies the database query process and improves the database query. effectiveness.

In addition, the embodiment of the present application further provides a computer readable storage medium, where the database readable storage medium is stored with a database query script generating program, and the database query script generating program is executed by the processor to:

If the database needs to perform related data query, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, wherein the query instruction includes a category of the data to be queried, and the data to be queried is in the category of the data to be queried. Functional attributes, and first query parameters;

And traversing the home directory of the database query template based on the category, acquiring a home directory matching the category of the data to be queried, and each function sub-directory under the matching home directory;

If each function subdirectory has a function subdirectory that matches the function attribute of the data to be queried in the category of the data to be queried, the pre-configured sql script file in the function subdirectory is obtained;

The corresponding second query parameter in the sql script file is replaced with the first query parameter to obtain a corresponding database query script.

Further, when the database query script generation program is executed by the processor, the following steps are also implemented:

If the function sub-directories do not match the function attributes of the data to be queried in the query instruction, the corresponding prompt information is sent to remind the corresponding query personnel to write the data query script.

Further, the pre-stored database query template includes: a main directory, corresponding function sub-directories under each main directory, a field input area for inputting query parameters, and a script display area for displaying a generated query script.

Further, the process of generating the database query script in the pre-stored database query template includes the following steps:

The query scripts written in the software development process are synchronously stored in the corresponding function subdirectories in the form of sql script files according to the function attributes of the scripts, and the database query scripts in the database query template are obtained.

The specific embodiment of the computer readable storage medium proposed by the present application is substantially the same as the foregoing embodiments of the electronic device and the database query script generating method, and is not described herein.

The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

The above is only a preferred embodiment of the present application, and is not intended to limit the scope of the patent application, and the equivalent structure or equivalent process transformations made by the specification and the drawings of the present application, or directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of this application.

Claims

An electronic device, comprising: a memory, and a processor connected to the memory, wherein the memory stores a database query script generating program, and the processor is configured to execute the stored on the memory The database query script generation program, when the database query script generation program is executed by the processor, implements the following steps:

If the database needs to perform related data query, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

Traversing the main directory of the database query template based on the category, acquiring a home directory matching the category, and each function subdirectory under the matching home directory;

If the function sub-directory has a function sub-directory that matches the function attribute of the to-be-queried data in the category, the pre-configured sql script file in the function sub-directory is obtained;

The corresponding second query parameter in the sql script file is replaced with the first query parameter, and a corresponding database query script is obtained.
The electronic device according to claim 1, wherein the database query script generating program is further executed by the processor to:

If the function sub-directories do not match the function attributes of the data to be queried in the query instruction, the corresponding prompt information is sent to remind the corresponding query personnel to write the data query script.
The electronic device of claim 1, wherein the pre-stored database query template comprises at least one selectable home directory, a field input area for inputting query parameters, and a script for displaying the generated query script A display area, wherein each of the home directories corresponds to one or more selectable function subdirectories.
The electronic device according to claim 3, wherein the generating process of the database query script in the pre-stored database query template comprises the following steps:

Reading the SQLHelper homepage, and establishing a home directory of the local storage script based on the SQLHelper homepage, wherein the name of the home directory matches the category of the data to be queried;

Each function subdirectory is generated in the main directory, and the function subdirectories are used to store the sql script file, and the names of the function subdirectories are respectively matched with the function attributes of the scripts in the sql script file stored therein;

The query scripts written in the software development process are synchronously stored in the corresponding function subdirectories in the form of sql script files according to the function attributes of the scripts, and the database query scripts in the database query template are obtained.
The electronic device according to claim 1, wherein the sql script file includes a dynamically modified second query parameter.
The electronic device according to claim 2, wherein the sql script file includes a dynamically modified second query parameter.
The electronic device according to claim 3, wherein the sql script file includes a dynamically modified second query parameter.
The electronic device according to claim 4, wherein the sql script file includes a dynamically modified second query parameter.
A database query script generating method, characterized in that the method comprises the following steps:

If the database needs to perform related data query, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

Traversing the main directory of the database query template based on the category, acquiring a home directory matching the category, and each function subdirectory under the matching home directory;

If the function sub-directory has a function sub-directory that matches the function attribute of the to-be-queried data in the category, the pre-configured sql script file in the function sub-directory is obtained;

The corresponding second query parameter in the sql script file is replaced with the first query parameter, and a corresponding database query script is obtained.
The method of generating a database query script according to claim 9, wherein the method further comprises the following steps:

If the function sub-directories do not match the function attributes of the data to be queried in the query instruction, the corresponding prompt information is sent to remind the corresponding query personnel to write the data query script.
The database query script generating method according to claim 10, wherein said pre-stored database query template comprises at least one selectable home directory, a field input area for inputting query parameters, and a display query script for displaying The script display area, wherein each of the main directories corresponds to one or more selectable function subdirectories.
The database query script generating method according to claim 11, wherein the generating process of the database query script in the pre-stored database query template comprises the following steps:

Reading the SQLHelper homepage, and establishing a home directory of the local storage script based on the SQLHelper homepage, wherein the name of the home directory matches the category of the data to be queried;

Each function subdirectory is generated in the main directory, and the function subdirectories are used to store the sql script file, and the names of the function subdirectories are respectively matched with the function attributes of the scripts in the sql script file stored therein;

The query scripts written in the software development process are synchronously stored in the corresponding function subdirectories in the form of sql script files according to the function attributes of the scripts, and the database query scripts in the database query template are obtained.
The database query script generating method according to claim 9, wherein the sql script file includes a dynamically modified second query parameter.
The database query script generating method according to claim 10, wherein the sql script file includes a dynamically modified second query parameter.
The database query script generating method according to claim 11, wherein the sql script file includes a dynamically modified second query parameter.
The database query script generating method according to claim 12, wherein the sql script file includes a dynamically modified second query parameter.
A computer readable storage medium storing a database query script generation program executable by at least one processor to cause the at least one processor to perform the following steps:

If the database needs to perform related data query, generate a database query instruction based on the data to be queried, and retrieve a pre-stored database query template, where the query instruction includes a category of the data to be queried, and the data to be queried is in the category. Functional attributes, and first query parameters;

Traversing the main directory of the database query template based on the category, acquiring a home directory matching the category, and each function subdirectory under the matching home directory;

If the function sub-directory has a function sub-directory that matches the function attribute of the to-be-queried data in the category, the pre-configured sql script file in the function sub-directory is obtained;

The corresponding second query parameter in the sql script file is replaced with the first query parameter, and a corresponding database query script is obtained.
The storage medium of claim 17, wherein the database query script generation program is executable by the at least one processor such that the at least one processor further performs the following steps:

If the function sub-directories do not match the function attributes of the data to be queried in the query instruction, the corresponding prompt information is sent to remind the corresponding query personnel to write the data query script.
The storage medium according to claim 18, wherein said pre-stored database query template comprises at least one selectable home directory, a field input area for inputting query parameters, and a script display for displaying a generated query script An area, wherein each of the main directories corresponds to one or more selectable functional subdirectories.
The storage medium according to claim 19, wherein the generating process of the database query script in the pre-stored database query template comprises the following steps:

Reading the SQLHelper homepage, and establishing a home directory of the local storage script based on the SQLHelper homepage, wherein the name of the home directory matches the category of the data to be queried;

Each function subdirectory is generated in the main directory, and the function subdirectories are used to store the sql script file, and the names of the function subdirectories are respectively matched with the function attributes of the scripts in the sql script file stored therein;

The query scripts written in the software development process are synchronously stored in the corresponding function subdirectories in the form of sql script files according to the function attributes of the scripts, and the database query scripts in the database query template are obtained.