Business function operation method and device, storage medium and electronic device
By obtaining and executing pre-configured SQL statements, business functions are directly implemented, which solves the problem of low efficiency in the implementation of business functions in the existing technology and improves the implementation efficiency of business functions.
Patent Information
- Application Number
- CN202111650001.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-29
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2041-12-29
AI Technical Summary
The existing business function implementation methods are less efficient, which causes the coordination and communication between business personnel and developers to consume a lot of time and affects the progress of the project.
By obtaining business function operation requests, determine the business function address matching the operation object, obtain pre-configured structured query language (SQL) statements from the address, and execute these statements to achieve business function operation results, thereby avoiding the basic code Repeat development.
Directly calling pre-configured SQL statements to implement business functions, improving the implementation efficiency of business functions and reducing the need for repeated development of basic code for specific business functions.
Smart Images

Figure CN114296696B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computers, and in particular to a business function operation method and device, a storage medium and an electronic device. Background Art
[0002] With the continuous updating of computer technology, large projects are now usually developed and managed in a similar engineering management manner. Under the current management model, when business personnel have various requirements for existing large projects, the requirements can only be communicated between business personnel and developers. After understanding the needs of business personnel, developers will develop codes based on existing projects.
[0003] However, in many cases, the needs of business personnel can actually be realized through basic code development. In this case, the coordination and communication between business personnel and developers will affect the progress of the project. At the same time, developers will repeatedly carry out basic code development work based on coordination and communication with business personnel to achieve basic needs, which consumes a lot of development time and testing time. In other words, the existing implementation methods of business functions have technical problems with low efficiency.
[0004] To address the above-mentioned problems, no effective solution has been proposed yet. Summary of the invention
[0005] The embodiments of the present invention provide a service function operation method and device, a storage medium and an electronic device, so as to at least solve the technical problem that the existing technology has low efficiency in implementing service functions.
[0006] According to one aspect of an embodiment of the present invention, a business function operation method is provided, including: obtaining a business function operation request, wherein the business function operation request carries an operation object; responding to the business function operation request, and determining a business function address that matches the operation object; obtaining a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement pre-configured for the business function through a configuration page; and executing the SQL statement to obtain a functional operation result of the operation object.
[0007] According to another aspect of an embodiment of the present invention, a business function operation device is also provided, including: a first acquisition unit, used to obtain a business function operation request, wherein the business function operation request carries an operation object; a determination unit, used to respond to the business function operation request and determine a business function address that matches the operation object; a second acquisition unit, used to obtain a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement pre-configured for the business function through a configuration page; and an execution unit, used to execute the SQL statement to obtain a functional operation result of the operation object.
[0008] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, in which a computer program is stored, wherein the computer program is configured to execute the above-mentioned business function operation method when running.
[0009] According to another aspect of an embodiment of the present invention, there is provided an electronic device, including a memory and a processor, wherein the memory stores a computer program, and the processor is configured to execute the business function operation method through the computer program.
[0010] In an embodiment of the present invention, a business function operation request is obtained, wherein the business function operation request carries an operation object; the business function operation request is responded to to determine a business function address that matches the operation object; a structured query language SQL statement associated with the operation object is obtained from the business function address, wherein the SQL statement is an execution statement pre-configured for the business function through a configuration page; the SQL statement is executed to obtain a functional operation result of the operation object, thereby directly implementing the business function by calling the pre-configured SQL statement, thereby avoiding repeated development of basic codes for specific business functions, and further solving the technical problem of low efficiency of existing business function implementation methods. BRIEF DESCRIPTION OF THE DRAWINGS
[0011] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:
[0012] Figure 1 is a schematic diagram of an application environment of an optional business function operation method according to an embodiment of the present invention;
[0013] Figure 2 is a flowchart of an optional business function operation method according to an embodiment of the present invention;
[0014] Figure 3 is a schematic diagram of an optional service function operation method according to an embodiment of the present invention;
[0015] Figure 4 is a schematic diagram of another optional service function operation method according to an embodiment of the present invention;
[0016] Figure 5 is a schematic diagram of another optional service function operation method according to an embodiment of the present invention;
[0017] Figure 6 is a schematic structural diagram of an optional service function operation device according to an embodiment of the present invention;
[0018] Figure 7 It is a schematic diagram of the structure of an optional electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION
[0019] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0020] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0021] According to one aspect of an embodiment of the present invention, a service function operation method is provided. As an optional implementation, the service function operation method can be but is not limited to being applied to Figure 1The business function operating system in the hardware environment shown. The business function operating system may include but is not limited to a terminal device 102, a network 104, a server 106, and a database 108. A target client for implementing the above-mentioned business function operations is running in the terminal device 102. The above-mentioned terminal device 102 includes a human-computer interaction screen, a processor, and a memory. The human-computer interaction screen is used to display the interactive interface of the target client; it is also used to provide a human-computer interaction interface to receive human-computer interaction operations for users to use the target client. The processor is used to generate an interaction instruction in response to the above-mentioned human-computer interaction operation, and send the interaction instruction to the server 106. The memory is used to store relevant attribute data, such as a SQL statement library, a database for implementing business functions, etc.
[0022] The specific process is as follows: as in step S102, the client running in the terminal device 102 obtains the operation request of the business function; S104, the terminal device 102 sends the above business request to the server 106 through the network 104. The server 106 will execute steps S106-S110, respond to the business function operation request, determine the business function address that matches the operation object; obtain the structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is the execution statement pre-configured for the business function through the configuration page; execute the SQL statement to obtain the function operation result of the operation object. Then as in step S112, the server 106 returns the operation result to the terminal device 102 through the network 104; finally, as in step S114, the operation result is displayed on the client.
[0023] As another optional implementation, when the terminal device 102 has a relatively powerful computing and processing capability, the above steps S106-S110 may also be completed by the terminal device 102. This is an example, and this embodiment does not impose any limitation on this.
[0024] Optionally, in this embodiment, the terminal device may be a terminal device configured with a target client, which may include but is not limited to at least one of the following: a mobile phone (such as an Android phone, an iOS phone, etc.), a laptop, a tablet computer, a PDA, a MID (Mobile Internet Devices), a PAD, a desktop computer, a smart TV, etc. The target client may be a video client, an instant messaging client, a browser client, an education client, etc. The network may include but is not limited to: a wired network, a wireless network, wherein the wired network includes: a local area network, a metropolitan area network and a wide area network, and the wireless network includes: Bluetooth, WIFI and other networks that realize wireless communication. The server may be a single server, or a server cluster consisting of multiple servers, or a cloud server. The above is only an example, and this embodiment does not impose any limitation on this.
[0025] As an optional implementation, Figure 2 As shown, the above-mentioned business function operation method includes:
[0026] S202, obtaining a business function operation request, wherein the business function operation request carries an operation object;
[0027] S204, responding to the business function operation request and determining a business function address that matches the operation object;
[0028] S206, acquiring a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement pre-configured for the business function through a configuration page;
[0029] S208, executing the SQL statement to obtain the functional operation result of the operation object.
[0030] In an embodiment of the present invention, a business function operation request is obtained, wherein the business function operation request carries an operation object; the business function operation request is responded to to determine a business function address that matches the operation object; a structured query language SQL statement associated with the operation object is obtained from the business function address, wherein the SQL statement is an execution statement pre-configured for the business function through a configuration page; the SQL statement is executed to obtain a functional operation result of the operation object, thereby directly implementing the business function by calling the pre-configured SQL statement, thereby avoiding repeated development of basic codes for specific business functions, and further solving the technical problem of low efficiency of existing business function implementation methods.
[0031] As an optional implementation, the above-mentioned obtaining the structured query language SQL statement associated with the operation object from the business function address includes: calling a background interface through the business function address to obtain the business operation SQL corresponding to the operation object.
[0032] Combination Figure 3 The above method is explained below. Figure 3 As shown, after the corresponding business function implementation SQL is pre-configured, the system can generate corresponding configurations of "add interface", "query interface", "modify interface" and "delete interface", which correspond to the functions of adding tables, querying tables, modifying tables and deleting tables in the database. After receiving the corresponding business requirements through the above four interfaces, the business requests of the above four interfaces are received through a unified back-end interface. In this embodiment, the back-end interface corresponds to the background interface in the above method, and the generation of all SQL statements is also implemented through the back-end interface. In the case of receiving a business request from the client through the back-end interface, the first step is first executed, that is, matching the address of the business function, obtaining the corresponding business operation SQL through the address, and then executing the second step, that is, executing the corresponding business operation in the database for the implementation of the operation function through the obtained SQL statement. It should be noted that the pre-configured SQL is stored in a specific table, which matches the address of the business function. Therefore, in the specific implementation of the business function, the SQL stored for business implementation can be obtained through the address of the business function. In the case of obtaining the SQL for the implementation of the business function, the specific business operation can be implemented in the database through the SQL.
[0033] Through the above-mentioned embodiments of the present application, by calling the background interface through the business function address and obtaining the business operation SQL corresponding to the operation object, it is possible to call the business-related SQL through a unified background interface and implement business operations, thereby improving the efficiency of implementing business functions.
[0034] As an optional method, before obtaining the business function operation request, the above also includes:
[0035] S1, displaying the business data to be configured on the configuration page, wherein the business data includes: table definition information, table field definition information and business function information, and the business function information includes interface information of the business function;
[0036] S2, in response to the configuration operation on the business data, establishing an association relationship between the index field and the operation result, wherein the index field includes table information and table field information, and the operation result includes display field information and SQL corresponding to the business function.
[0037] As a specific implementation method, Figure 4A configuration hierarchical relationship diagram of an optional business function configuration generation page is shown. In the first-level page, it can be used to configure the basic information of the table fields and the first-level table relationship information. In the second-level page, the business function fields are configured through the basic information obtained from the first-level page to generate the first-level association SQL statement information.
[0038] In another optional embodiment, the above configuration page may specifically include three configuration options, including:
[0039] The first option is used to configure the table definition relationship, that is, this option can be used to configure the table name, Chinese name of the table, and other information of the table of the business operation object;
[0040] The second option is used to configure table field definitions, which can be used to configure various definition information of fields, including but not limited to the following three categories:
[0041] Basic field attribute information, which may include: field name, field Chinese name, table name, field database type, field database size, field page type, field data source type, field detailed data source, view condition, filter type, query filter type, and query filter value;
[0042] Page style information, which may include: table column width, column alignment, date style, form item label width, form item content component width;
[0043] The association relationship may specifically include: association table name, association table field, association relationship, etc.
[0044] The third option is used to configure the definition of business functions, which may include but are not limited to the following six categories:
[0045] Business function number configuration, including: configuring business function number, business function number name, primary table and primary key result set type;
[0046] Related association relationship configuration includes: associating with the slave table, i.e. the slave table name, association relationship, left, right, and slave table filtering conditions; querying the master table and the slave table and the associated fields according to the master table and the slave table to table association relationship table, generating association relationships and filtering conditions; it can be understood that the slave table can also be associated with other tables, and the corresponding association relationships can also be generated. The table relationship is maintained through the table field definition, and can also be maintained through the table relationship here;
[0047] Query field configuration, including: obtaining table fields from all tables for business personnel to select, and then business personnel can dynamically adjust the generated selection box in the corresponding business function interface. Optionally, the configuration of this option can be based on the current field selection, or a value can be entered. The background assembles the corresponding query SQL based on the input content;
[0048] Display field configuration is used to configure the fields that can be displayed on the page so that users can query the corresponding information in the business function module;
[0049] Business function condition configuration is used to implement filtering query;
[0050] Sorting configuration, used to implement ascending and descending sorting based on the selected field. Optionally, the display field will be processed using a common object.
[0051] When configuring to implement business functions, this embodiment adopts Figure 5 The function generation hierarchical diagram shown in FIG. It includes interface 1 for table field information in the SQL configuration process, interface 2 for obtaining table structure information, and interface 3 for obtaining page display business logic. It can be understood that the above three interfaces link the front-end page and the database, so that the operation object information stored in the database can be obtained through the configuration operation of the front-end page. In addition, the hierarchical diagram also includes an SQL attribute dictionary, so that the business function logic SQL can be generated through logical matching by obtaining the data of the above three interfaces and carrying the logical matching SQL dictionary class.
[0052] In this embodiment, through the configuration operation interface displayed on the above page, business personnel are guided to enter the corresponding function module for configuration. The front end transmits the function number to the back end, the back end updates the function number, queries the corresponding function configuration in the business function, dynamically generates the corresponding SQL statement, and assembles the corresponding data for the business personnel to view.
[0053] Through the above-mentioned implementation method of the present application, the business data to be configured is displayed on the configuration page, and in response to the configuration operation of the business data, an association relationship between the index field and the operation result is established, so that the configuration page is displayed through the front-end page, and the business personnel are guided to perform corresponding configuration operations to realize dynamic generation of SQL for realizing business functions, thereby avoiding manual development of SQL functions and improving the efficiency of realizing business functions.
[0054] As an optional method, after establishing the association between the query field and the query result, it also includes: verifying all query fields
[0055] On the basis of the above method, the configuration page is associated with the query SQL. By setting the main table fields, result set types, and associations, the background interface is accessed through the table association to return all table field definition information, which is used to configure the query fields, display fields, filter conditions, and sorting required by the query interface, generate the corresponding SQL and store it in the database. Before storing it in the database, all field definitions are obtained through the table association for secondary verification. To implement addition, modification, deletion, and import, the front end only needs to submit the object through the corresponding general interface, and the back end converts the object into a map collection. According to the business function, the main table and its main table field definition are obtained for security verification and then spliced into SQL for the corresponding business logic. It can be understood that the secondary verification here is used to verify the reliability of the generated SQL in the specific business implementation.
[0056] Through the above-mentioned embodiments of the present application, by verifying the query fields, automatic verification of the generated SQL is achieved, thereby improving the efficiency of implementing business functions.
[0057] As an optional method, obtaining a business function operation request includes one of the following:
[0058] Obtaining an add operation request for adding a function module of a business function;
[0059] Obtain a modification operation request for modifying a function module of a business function;
[0060] Obtain a deletion operation request for deleting a function module of a business function;
[0061] Obtaining a query operation request for querying a functional module of a business function;
[0062] Gets an operation request for importing or exporting a function module of a business function.
[0063] It is understandable that in this embodiment, the obtained business function operation requests include operation requests for adding function modules of business functions, operation requests for modifying function modules of business functions, operation requests for deleting function modules of business functions, and operation requests for importing or exporting function modules of business functions. It is understandable that the function modules of the above-mentioned business functions can be pre-configured SQL statements generated to implement business functions. Specifically, if you want to add, modify, delete and import, you only need to submit objects through the corresponding general interface on the front end, convert the objects into map sets on the back end, obtain the main table and its main table field definitions according to the business function, perform security verification, and then splice them into SQL to perform the corresponding business logic. The export function needs to obtain the front-end query conditions and display fields, the business function menu number, and go to the general query object in the back end, define the data source through the table field interface, and then POI general export can be performed.
[0064] In this embodiment, by obtaining multiple business function operation requests, the operation requirements of business personnel can be directly obtained, and then the corresponding SQL statements for implementing business functions can be directly generated according to the configuration operations of the front-end page, thereby avoiding repeated development of basic SQL function implementations, and solving the technical problem of low efficiency of existing business function implementation methods.
[0065] As an optional implementation, the above method of the present application can be implemented specifically through the following process:
[0066] S1, the front-end page obtains the corresponding table structure, table field information and business data for display operations;
[0067] S2, perform SQL change generation operations on business functions through the page, and generate relevant business function information and store it in the database;
[0068] S3, the client only needs to call the same interface to parse the generated business function data through the generated address information to implement the corresponding function operation.
[0069] Through the above method of this embodiment, SQL for implementing specific functions is generated by configuring the front-end page, and the generated SQL is called through the same interface when needed, thereby avoiding repeated development of basic SQL function implementations, thereby solving the technical problem of low efficiency of existing business function implementation methods.
[0070] It should be noted that, for the above-mentioned method embodiments, for the sake of simplicity, they are all described as a series of action combinations, but those skilled in the art should know that the present invention is not limited by the described action sequence, because according to the present invention, certain steps can be performed in other sequences or simultaneously. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present invention.
[0071] According to another aspect of the embodiment of the present invention, a service function operation device for implementing the above service function operation method is also provided. Figure 6 As shown, the device comprises:
[0072] A first acquisition unit 602 is used to acquire a business function operation request, wherein the business function operation request carries an operation object;
[0073] A determination unit 604 is used to respond to the business function operation request and determine a business function address that matches the operation object;
[0074] The second acquisition unit 606 is used to acquire a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement configured in advance for the business function through a configuration page;
[0075] The execution unit 608 is used to execute the SQL statement to obtain the functional operation result of the operation object.
[0076] Optionally, in this embodiment, the embodiments to be implemented by the above-mentioned various unit modules can refer to the above-mentioned various method embodiments, which will not be repeated here.
[0077] According to another aspect of the embodiment of the present invention, an electronic device for implementing the above-mentioned service function operation method is also provided. The electronic device may be Figure 1 The terminal device or server shown in the figure. This embodiment is described by taking the electronic device as a terminal device as an example. Figure 7 As shown, the electronic device includes a display 701, a transmission device 702, a processor 703 and a memory 704, wherein the memory 704 stores a computer program, and the processor 703 is configured to execute the steps in any of the above method embodiments through the computer program.
[0078] Optionally, in this embodiment, the electronic device may be located in at least one network device among a plurality of network devices of a computer network.
[0079] Optionally, in this embodiment, the processor may be configured to perform the following steps through a computer program:
[0080] S1, obtaining a business function operation request, wherein the business function operation request carries an operation object;
[0081] S2, responding to the business function operation request and determining the business function address that matches the operation object;
[0082] S3, obtaining a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement configured in advance for the business function through a configuration page;
[0083] S4, executing the SQL statement to obtain the functional operation result of the operation object.
[0084] Alternatively, a person skilled in the art may understand that: Figure 7 The structure shown is for illustration only, and the electronic device may also be a smart phone (such as an Android phone, an iOS phone, etc.), a tablet computer, a PDA, a mobile Internet device (MID), a PAD, and other terminal devices. Figure 7The electronic device and the electronic equipment described above are not limited in structure. Figure 7 More or fewer components (such as network interfaces, etc.) as shown in, or with Figure 7 Different configurations are shown.
[0085] Among them, the memory 704 can be used to store software programs and modules, such as the program instructions / modules corresponding to the business function operation method and device in the embodiments of the present invention. The processor 703 executes various functional applications and data processing by running the software programs and modules stored in the memory 704, that is, realizing the above-mentioned business function operation method. The memory 704 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 704 may further include a memory remotely located relative to the processor 703, and these remote memories may be connected to the terminal via a network. Examples of the above-mentioned networks include, but are not limited to, the Internet, corporate intranets, local area networks, mobile communication networks, and combinations thereof. As an example, Figure 7 As shown, the memory 704 may include but is not limited to the first acquisition unit 702, determination unit 704, second acquisition unit 706 and execution unit 708 in the business function operation device. In addition, it may also include but is not limited to other module units in the business function operation device, which will not be repeated in this example.
[0086] Optionally, the transmission device 702 is used to receive or send data via a network. Specific examples of the network may include a wired network and a wireless network. In one example, the transmission device 702 includes a network adapter (Network Interface Controller, NIC), which can be connected to other network devices and routers via a network cable so as to communicate with the Internet or a local area network. In one example, the transmission device 702 is a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.
[0087] In addition, the electronic device further comprises: a display 701 for displaying a front-end page for configuring SQL for implementing business functions on the current page; and a connection bus 710 for connecting various module components in the electronic device.
[0088] In other embodiments, the terminal device or server may be a node in a distributed system, wherein the distributed system may be a blockchain system, and the blockchain system may be a distributed system formed by connecting the multiple nodes through network communication. Among them, the nodes may form a peer-to-peer (P2P, Peer To Peer) network, and any form of computing device, such as a server, terminal and other electronic devices, may become a node in the blockchain system by joining the peer-to-peer network.
[0089] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.
[0090] According to one aspect of the present application, a computer-readable storage medium is provided, and a processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes the above-mentioned business function operation method.
[0091] Optionally, in this embodiment, the computer-readable storage medium may be configured to store a computer program for performing the following steps:
[0092] S1, obtaining a business function operation request, wherein the business function operation request carries an operation object;
[0093] S2, responding to the business function operation request and determining the business function address that matches the operation object;
[0094] S3, obtaining a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement configured in advance for the business function through a configuration page;
[0095] S4, executing the SQL statement to obtain the functional operation result of the operation object.
[0096] Optionally, in this embodiment, a person of ordinary skill in the art may understand that all or part of the steps in the various methods of the above embodiments may be completed by instructing hardware related to the terminal device through a program, and the program may be stored in a computer-readable storage medium, and the storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, etc.
[0097] If the integrated units in the above embodiments are implemented in the form of software functional units and sold or used as independent products, they can be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling one or more computer devices (which can be personal computers, servers or network devices, etc.) to perform all or part of the steps of the above methods of various embodiments of the present invention.
[0098] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.
[0099] In the several embodiments provided in the present application, it should be understood that the disclosed client can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of the above units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.
[0100] The units described above as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0101] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0102] The above are only preferred embodiments of the present invention. It should be pointed out that, for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.
Claims
1. A business function operation method, characterized in that: include: In response to a configuration operation on the business data to be configured, an association relationship between an index field and an operation result is established, wherein the index field includes table information and table field information, and the operation result includes display field information and SQL corresponding to the business function; Verify all the index fields; Obtaining a business function operation request, wherein the business function operation request carries an operation object; In response to the business function operation request, determine a business function address that matches the operation object; Acquire a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement configured in advance for the business function through a configuration page, and perform a secondary check on the SQL statement, wherein the secondary check is to perform a security check on the definition of the main table and its main table fields obtained according to the business function, and then splice them into SQL to perform a corresponding business logic check to verify the reliability of the generated SQL in the specific business implementation; Execute the SQL statement to obtain the functional operation result of the operation object.
2. The method according to claim 1, characterized in that Acquiring a structured query language SQL statement associated with the operation object from the business function address includes: The backend interface is called through the business function address to obtain the business operation SQL corresponding to the operation object.
3. The method according to claim 1, characterized in that Before obtaining a business function operation request, it also includes: The business data is displayed on the configuration page, wherein the business data includes: table definition information, table field definition information and business function information, and the business function information includes interface information of the business function.
4. The method according to any one of claims 1 to 3, characterized in that The request to obtain a business function operation includes one of the following: Obtaining an add operation request for adding a function module of a business function; Obtain a modification operation request for modifying a function module of a business function; Obtain a deletion operation request for deleting a function module of a business function; Obtaining a query operation request for querying a functional module of a business function; Gets an operation request for importing or exporting a function module of a business function.
5. A business function operation device, characterized in that: include: A first acquisition unit is used to acquire a business function operation request, wherein the business function operation request carries an operation object; A determination unit, configured to respond to the business function operation request and determine a business function address that matches the operation object; A second acquisition unit is used to acquire a structured query language SQL statement associated with the operation object from the business function address, wherein the SQL statement is an execution statement configured in advance for the business function through a configuration page, and perform a secondary check on the SQL statement, wherein the secondary check is to perform a security check on the definition of the main table and its main table fields obtained according to the business function, and then splice them into SQL to perform a corresponding business logic check to verify the reliability of the generated SQL in the specific business implementation; An execution unit, used for executing the SQL statement to obtain a functional operation result of the operation object; The device is also used to establish an association relationship between index fields and operation results in response to a configuration operation on the business data to be configured before obtaining a business function operation request, wherein the index fields include table information and table field information, and the operation results include display field information and SQL corresponding to the business function; and verify all the index fields.
6. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored program, wherein the program executes the method described in any one of claims 1 to 4 when executed.
7. An electronic device comprising a memory and a processor, characterized in that: A computer program is stored in the memory, and the processor is configured to execute the method according to any one of claims 1 to 4 through the computer program.
Citation Information
Patent Citations
SQL optimization method and device, electronic equipment and computer readable storage medium
CN110399377A
Database access method, apparatus and device
CN110795485A
Blockchain node and transaction method
CN110827008A
Data query method, system and device based on data interface configuration and medium
CN111813779A
Method, device and equipment for operating relational database based on C language
CN112015831A
