CN114296696A - Business function operation method and device, storage medium and electronic equipment - Google Patents
Business function operation method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN114296696A CN114296696A CN202111650001.7A CN202111650001A CN114296696A CN 114296696 A CN114296696 A CN 114296696A CN 202111650001 A CN202111650001 A CN 202111650001A CN 114296696 A CN114296696 A CN 114296696A
- Authority
- CN
- China
- Prior art keywords
- service function
- sql
- service
- operation request
- statement
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a business function operation method and device, a storage medium and electronic equipment. Wherein, the method comprises the following steps: acquiring a service function operation request, wherein the service function operation request carries an operation object; responding to the service function operation request, and determining a service function address matched with the operation object; acquiring a Structured Query Language (SQL) statement associated with an operation object from a business function address, wherein the SQL statement is an execution statement configured for a business function through a configuration page in advance; and executing the SQL statement to acquire a functional operation result of the operation object. The invention solves the technical problem of lower efficiency of the existing service function realization mode.
Description
Technical Field
The invention relates to the field of computers, in particular to a business function operation method and device, a storage medium and electronic equipment.
Background
With the increasing updating of computer technology, large projects are developed and managed by adopting a similar engineering management mode. Under the condition that service personnel have various requirements on the existing large-scale project, the requirement communication can be carried out only through the service personnel and developers in the existing management mode, and after the requirements of the service personnel are understood, the developers develop codes on the basis of the existing project.
But in many cases, the requirements of business personnel are actually realized only through basic code development. In this case, the business personnel may influence the progress of the project in the coordination communication with the developers, and the developers may repeatedly perform the basic code development work based on the coordination communication with the business personnel to realize the basic requirements, which consumes a lot of development time and testing time. That is to say, the existing service function implementation method has the technical problem of low efficiency.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a business function operation method and device, a storage medium and electronic equipment, which at least solve the technical problem of low efficiency in a mode of realizing business functions in the prior art.
According to an aspect of an embodiment of the present invention, a method for operating a service function is provided, including: acquiring a service function operation request, wherein the service function operation request carries an operation object; responding to the service function operation request, and determining a service function address matched with the operation object; acquiring a Structured Query Language (SQL) statement associated with an operation object from a business function address, wherein the SQL statement is an execution statement configured for a business function through a configuration page in advance; and executing the SQL statement to acquire a functional operation result of the operation object.
According to another aspect of the embodiments of the present invention, there is also provided a service function operating apparatus, including: the first obtaining unit is used for obtaining a service function operation request, wherein the service function operation request carries an operation object; the determining unit is used for responding to the service function operation request and determining a service function address matched with the operation object; a second obtaining unit, configured to obtain a Structured Query Language (SQL) statement associated with the operation object from the service function address, where the SQL statement is an execution statement configured for the service function through a configuration page in advance; and the execution unit is used for executing the SQL statement to acquire a functional operation result of the operation object.
According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, in which a computer program is stored, wherein the computer program is configured to execute the above-mentioned service function operating method when running.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including a memory and a processor, where the memory stores a computer program, and the processor is configured to execute the service function operation method through the computer program.
In the embodiment of the invention, a service function operation request is obtained, wherein the service function operation request carries an operation object; responding to the service function operation request, and determining a service function address matched with the operation object; acquiring a Structured Query Language (SQL) statement associated with an operation object from a business function address, wherein the SQL statement is an execution statement configured for a business function through a configuration page in advance; the SQL sentences are executed to obtain the functional operation results of the operation objects, so that the business functions are directly realized by calling the preconfigured SQL sentences, repeated development of basic codes of specific business functions is avoided, and the technical problem that the existing business function realization mode is low in efficiency is solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a schematic diagram of an application environment of an alternative business function operation method according to an embodiment of the present invention;
FIG. 2 is a flow chart of an alternative method of operation of a business function in accordance with an embodiment of the present invention;
fig. 3 is a schematic diagram of an alternative method of operation of a service function according to an embodiment of the present invention;
fig. 4 is a schematic diagram of another alternative method of operation of a service function according to an embodiment of the present invention;
fig. 5 is a schematic diagram of another alternative method of operation of a service function according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of an alternative service function operating apparatus according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of an alternative electronic device according to an embodiment of the invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, 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 derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, 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 expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
According to an aspect of the embodiments of the present invention, a business function operating method is provided, as an alternative implementation, the business function operating method may be, but is not limited to, applied to a business function operating system in a hardware environment as shown in fig. 1. The service function operating system may include, but is not limited to, the terminal device 102, the network 104, the server 106, and the database 108. A target client for implementing the above-described service function operation runs in the terminal device 102. The terminal device 102 includes a human-computer interaction screen, a processor and a memory. The man-machine interaction screen is used for displaying an interaction interface of the target client; and the client is also used for providing a human-computer interaction interface to receive human-computer interaction operation for a user to use the target client. The processor is configured to generate an interaction instruction in response to the human-computer interaction operation, and send the interaction instruction to the server 106. The memory is used for storing related attribute data, such as an SQL statement library, a database for realizing service functions and the like.
The specific process comprises the following steps: in step S102, an operation request for acquiring a service function is executed in a client running in the terminal device 102; s104, the terminal device 102 sends the service request to the server 106 through the network 104. The server 106 executes the steps S106-S110, responds to the service function operation request, and determines a service function address matched with the operation object; acquiring a Structured Query Language (SQL) statement associated with an operation object from a business function address, wherein the SQL statement is an execution statement configured for a business function through a configuration page in advance; and executing the SQL statement to acquire a functional operation result of the operation object. Then, as in step S112, the server 106 returns the operation result to the terminal apparatus 102 via the network 104; finally, as shown in step S114, the operation result is displayed on the client.
As another alternative, when the terminal device 102 has a relatively high computing processing capability, the steps S106 to S110 may also be performed by the terminal device 102. Here, this is an example, and this is not limited in this embodiment.
Optionally, in this embodiment, the terminal device may be a terminal device configured with a target client, and may include, but is not limited to, at least one of the following: mobile phones (such as Android phones, iOS phones, etc.), notebook computers, tablet computers, palm computers, MID (Mobile Internet Devices), PAD, desktop computers, smart televisions, etc. The target client may be a video client, an instant messaging client, a browser client, an educational client, etc. Such networks may include, but are not limited to: a wired network, a wireless network, wherein the wired network comprises: a local area network, a metropolitan area network, and a wide area network, the wireless network comprising: bluetooth, WIFI, and other networks that enable wireless communication. The server may be a single server, a server cluster composed of a plurality of servers, or a cloud server. The above is merely an example, and this is not limited in this embodiment.
As an optional implementation, as shown in fig. 2, the service function operation method includes:
s202, acquiring a service function operation request, wherein the service function operation request carries an operation object;
s204, responding to the service function operation request, and determining a service function address matched with the operation object;
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 configured for the business function through a configuration page in advance;
and S208, executing the SQL statement to acquire a functional operation result of the operation object.
In the embodiment of the invention, a service function operation request is obtained, wherein the service function operation request carries an operation object; responding to the service function operation request, and determining a service function address matched with the operation object; acquiring a Structured Query Language (SQL) statement associated with an operation object from a business function address, wherein the SQL statement is an execution statement configured for a business function through a configuration page in advance; the SQL sentences are executed to obtain the functional operation results of the operation objects, so that the business functions are directly realized by calling the preconfigured SQL sentences, repeated development of basic codes of specific business functions is avoided, and the technical problem that the existing business function realization mode is low in efficiency is solved.
As an optional implementation manner, the obtaining of the structured query language SQL statement associated with the operation object from the service function address includes: and calling a background interface through the service function address to acquire service operation SQL corresponding to the operation object.
The above method is explained with reference to fig. 3. As shown in fig. 3, after configuring the corresponding service function in advance to implement SQL, the system may be configured to generate an "add interface", "query interface", "modify interface", and "delete interface", which correspond to the functions of implementing table add, table query, table modification, and table delete on the database, respectively. After receiving the corresponding service requirements through the four interfaces, the service requests of the four interfaces are received through the unified backend interface, in this embodiment, the backend interface corresponds to the backend interface in the method, and the generation of all SQL statements is also realized through the backend interface. When a service request from a client is received through the back-end interface, a first step of matching the address of a service function is executed first, a corresponding service operation SQL is obtained through the address, and then a second step of executing a corresponding service operation in a database for realizing the operation function through the obtained SQL statement is executed. It should be noted that, the pre-configured SQL is stored in a specific table and is matched with the address of the service function, so that in the specific implementation of the service function, the SQL for implementing the service can be stored and obtained through the address of the service function. Under the condition of acquiring the SQL for realizing the business function, the specific business operation can be realized in the database through the SQL.
According to the embodiment of the application, the background interface is called through the service function address, the service operation SQL corresponding to the operation object is obtained, the SQL related to the service is called through the uniform background interface, the service operation is realized, and the realization efficiency of the service function is improved.
As an optional mode, before obtaining the service function operation request, the method further includes:
s1, displaying service data to be configured on a configuration page, where the service data includes: the method comprises the steps that table definition information, table field definition information and service function information are obtained, wherein the service function information comprises interface information of service functions;
s2, responding to the configuration operation of the service data, establishing the incidence relation between the index field and the operation result, wherein the index field comprises the table information and the table field information, and the operation result comprises the display field information and the SQL corresponding to the service function.
As a specific implementation manner, as shown in fig. 4, a configuration hierarchical relationship diagram of an optional service function configuration generation page is shown, in a first-level page, the first-level page may be used to configure table field basic information and first-level table relationship information, and in a second-level page, the first-level association is performed on service function field configuration through the basic information acquired by the first-level page to generate SQL statement information.
In another optional embodiment, the configuration page may specifically include three configuration options, including:
the first option is: the method is used for configuring the table definition relationship, namely the table name, the table Chinese name and other table information which can be used for configuring the business operation object in the option;
the second option is as follows: the definition of the fields used for the configuration table, that is, various definition information that can be used for the configuration fields, may specifically include, but is not limited to, the following three types:
the basic field attribute information may specifically include: the method comprises the following steps of (1) field name, field Chinese name, place table name, field database type, field database size, field page type, field data source type, field detailed data source, view condition, filtering type, query filtering type and query filtering value;
the page style information may specifically include: table column width, column alignment mode, date style, form item label width, and form item content component width;
the association relationship may specifically include: an association table name, an association table field, an association relationship, etc.
The third option is used for configuring the definition of the service function, and specifically includes but is not limited to the following six categories:
the configuration of the service function number comprises the following steps: configuring a service function number, a service function number name, a main table and a main key result set type;
and the related association relationship configuration comprises the following steps: associating slave tables, i.e. filtering conditions from table names, associations, left, right, and slave tables; inquiring the master table, the slave table and the associated fields according to the master table, the slave table and the table association relation table, and generating an association relation and a filtering condition; it can be understood that the slave table may also be associated with other tables, or may continue to generate corresponding association relationships, and the table relationships are defined and maintained by table fields, or may be maintained by the table relationships therein;
query field configuration, including: and acquiring the table fields according to all the tables for business personnel to select, wherein the subsequent business personnel can dynamically adjust the generated selection frame on the corresponding business function interface. Optionally, the configuration of the option may be selected according to the current field, or a value may be input. The background assembles corresponding query SQL according to the input content;
the display field configuration is used for configuring fields which can be displayed in a page, so that a user can inquire corresponding information in the service function module;
the service function is used for realizing filtering query;
and the sequencing configuration is used for realizing ascending and descending sequencing according to the selected field, and optionally, the display field is processed by adopting a general object.
When configured to implement a business function, the present embodiment generates a hierarchical diagram using the function shown in fig. 5. The method comprises an interface 1 for table field information in the SQL configuration process, an interface 2 for acquiring table structure information and an interface 3 for acquiring 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 acquired through the configuration operation of the front-end page. In addition, the hierarchical diagram also comprises an SQL attribute dictionary, so that the business function logic SQL is generated through logic matching by acquiring the data of the three interfaces and carrying the logic matching SQL dictionary class.
In this embodiment, through the configuration operation interface displayed on the page, the service staff is guided to enter the corresponding function module for configuration, the function number is transmitted from the front end to the back end, the function number is further transmitted from the back end, the corresponding function configuration in the service function is queried, the corresponding SQL statement is dynamically generated, and the corresponding data is assembled and provided for the service staff to check.
According to the implementation method, the business data to be configured is displayed on the configuration page, the incidence relation between the index field and the operation result is established in response to the configuration operation of the business data, the configuration page is displayed through the front-end page, and business personnel are guided to carry out corresponding configuration operation, so that the SQL for realizing the business function is dynamically generated, the SQL function is prevented from being manually developed, and the realization efficiency of the business function is improved.
As an optional manner, after the association relationship between the query field and the query result is established, the method further includes: checking all query fields
On the basis of the method, the configuration page is associated with the query SQL, all table field definition information is returned through the table association relation access background interface by setting the main table field, the result set type and the association relation, the query field, the display field, the filter condition and the sequencing required by the query interface are configured to generate the corresponding SQL and drop the database, and all field definitions are acquired through the table association relation for secondary verification before the database dropping. If the addition, modification, deletion and import are to be realized, the front end only needs to submit the object through the corresponding general interface, the background converts the object into a map set, and the main table and the field definition of the main table are obtained according to the service function, are subjected to security verification and are spliced into SQL to perform corresponding service logic. It will be appreciated that the secondary check herein is used to verify the reliability of the generated SQL in a particular business implementation.
By the embodiment of the application, the query field is verified, so that the generated SQL is automatically verified, and the efficiency of realizing the service function is improved.
As an optional manner, the obtaining the service function operation request includes one of the following:
acquiring an adding operation request for adding a functional module of a service function;
acquiring a modification operation request for modifying a functional module of a service function;
acquiring a deleting operation request for deleting a functional module of a service function;
acquiring a query operation request for querying a functional module of a service function;
and acquiring an operation request for importing or exporting the functional module of the service function.
It can be understood that, in this embodiment, the obtained service function operation request includes an operation request for adding a function module of the service function, an operation request for modifying a function module of the service function, an operation request for deleting a function module of the service function, and an operation request for importing or exporting a function module of the service function. It can be understood that the functional module of the business function may be a generated SQL statement configured in advance for implementing the business function. Specifically, if modification, deletion and import are to be added, the front end is only required to submit an object through a corresponding general interface, the background converts the object into a map set, and the main table and the field definition of the main table are obtained according to the service function, are subjected to security verification and are spliced into SQL to perform corresponding service logic. The export function needs to acquire front-end query conditions, display fields, service function menu numbers and background general query objects, and defines data sources to interface through table fields, so that POI can be exported universally.
In this embodiment, by obtaining multiple service function operation requests, operation requirements of service personnel can be directly obtained, and then, a corresponding SQL statement for implementing a service function is directly generated according to configuration operations of a front-end page, thereby avoiding repeated development of basic SQL function implementation, and further solving the technical problem of low efficiency of the existing service function implementation mode.
As an optional implementation manner, the foregoing manner of the present application may be specifically implemented by the following process:
s1, the front page obtains the corresponding table structure, the table field information and the service data to display;
s2, SQL modification generation operation of business function is carried out through the page, and related business function information is generated and stored in a storage;
and S3, the client terminal can realize the corresponding function operation only by calling the generated address information to the service function data generated by the same interface analysis.
By the method of the embodiment, the SQL with specific functions is generated by the configuration of the front-end page, and the generated SQL is called through the same interface under the condition that the SQL is required to be used, so that the repeated development of the basic SQL function realization is avoided, and the technical problem that the conventional business function realization mode is low in efficiency is solved.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.
According to another aspect of the embodiment of the present invention, a service function operating apparatus for implementing the service function operating method is also provided. As shown in fig. 6, the apparatus includes:
a first obtaining unit 602, configured to obtain a service function operation request, where the service function operation request carries an operation object;
a determining unit 604, configured to determine, in response to the service function operation request, a service function address matching the operation object;
a second obtaining unit 606, configured to obtain a Structured Query Language (SQL) statement associated with the operation object from the service function address, where the SQL statement is an execution statement configured for the service function through a configuration page in advance;
and the execution unit 608 is configured to execute the SQL statement to obtain a functional operation result of the operation object.
Optionally, in this embodiment, reference may be made to the above-mentioned method embodiments for implementing the above-mentioned unit modules, which are not described herein again.
According to another aspect of the embodiment of the present invention, there is also provided an electronic device for implementing the service function operation method, where the electronic device may be the terminal device or the server shown in fig. 1. The present embodiment takes the electronic device as a terminal device as an example for explanation. As shown in fig. 7, the electronic device comprises a display 701, a transmission apparatus 702, a processor 703 and a memory 704, wherein the memory 704 has a computer program stored therein, and the processor 703 is configured to perform the steps in any of the above-described method embodiments by means of the computer program.
Optionally, in this embodiment, the electronic device may be located in at least one network device of a plurality of network devices of a computer network.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, acquiring a service function operation request, wherein the service function operation request carries an operation object;
s2, responding to the operation request of the service function, and determining the address of the service function matched with the operation object;
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 for the business function through a configuration page in advance;
and S4, executing the SQL statement to obtain the functional operation result of the operation object.
Alternatively, it can be understood by those skilled in the art that the structure shown in fig. 7 is only an illustration, and the electronic device may also be a terminal device such as a smart phone (e.g., an Android phone, an iOS phone, etc.), a tablet computer, a palmtop computer, a Mobile Internet Device (MID), a PAD, and the like. Fig. 7 is a diagram illustrating a structure of the electronic device. For example, the electronics may also include more or fewer components (e.g., network interfaces, etc.) than shown in FIG. 7, or have a different configuration than shown in FIG. 7.
The memory 704 may be configured to store software programs and modules, such as program instructions/modules corresponding to the service function operating method and apparatus in the embodiments of the present invention, and the processor 703 executes various functional applications and data processing by running the software programs and modules stored in the memory 704, that is, implements the service function operating method. The memory 704 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 704 may further include memory located remotely from the processor 703, which may be connected to the terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof. As an example, as shown in fig. 7, the memory 704 may include, but is not limited to, a first obtaining unit 702, a determining unit 704, a second obtaining unit 706, and an executing unit 708 in the service function operating apparatus. In addition, the present invention may further include, but is not limited to, other module units in the service function operating apparatus, which is not described in this example again.
Optionally, the transmission device 702 is used for receiving or sending data via a network. Examples of the network may include a wired network and a wireless network. In one example, the transmission device 702 includes a Network adapter (NIC) that can be connected to a router via a Network cable and other Network devices 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 in a wireless manner.
In addition, the electronic device further includes: a display 701, configured to display, on a current page, a front-end page of SQL configured to implement a business function; and a connection bus 710 for connecting the respective module parts in the above-described electronic apparatus.
In other embodiments, the terminal device or the server may be a node in a distributed system, where the distributed system may be a blockchain system, and the blockchain system may be a distributed system formed by connecting a plurality of nodes through a network communication. Nodes can form a Peer-To-Peer (P2P, Peer To Peer) network, and any type of computing device, such as a server, a terminal, and other electronic devices, can become a node in the blockchain system by joining the Peer-To-Peer network.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
According to one aspect of the present application, there is provided a computer readable storage medium, a processor of a computer device reads the computer instructions from the computer readable storage medium, and the processor executes the computer instructions to make the computer device execute the above-mentioned business function operator method.
Alternatively, in the present embodiment, the above-mentioned computer-readable storage medium may be configured to store a computer program for executing the steps of:
s1, acquiring a service function operation request, wherein the service function operation request carries an operation object;
s2, responding to the operation request of the service function, and determining the address of the service function matched with the operation object;
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 for the business function through a configuration page in advance;
and S4, executing the SQL statement to obtain the functional operation result of the operation object.
Alternatively, in this embodiment, a person skilled in the art may understand that all or part of the steps in the methods of the foregoing embodiments may be implemented by a program instructing hardware associated with the terminal device, where the program may be stored in a computer-readable storage medium, and the storage medium may include: flash disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The integrated unit in the above embodiments, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing one or more computer devices (which may be personal computers, servers, network devices, etc.) to execute all or part of the steps of the above methods according to the embodiments of the present invention.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely illustrative, and for example, the above-described division of the units is only one type of division of logical functions, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (8)
1. A method for operating a service function, comprising:
acquiring a service function operation request, wherein the service function operation request carries an operation object;
responding to the service function operation request, and determining a service function address matched with the operation object;
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 configured for a business function through a configuration page in advance;
and executing the SQL statement to acquire a functional operation result of the operation object.
2. The method of claim 1, wherein obtaining the Structured Query Language (SQL) statement associated with the operand from the business function address comprises:
and calling a background interface through the service function address to acquire service operation SQL corresponding to the operation object.
3. The method of claim 1, prior to obtaining the service function operation request, further comprising:
displaying service data to be configured on the configuration page, wherein the service data comprises: the method comprises the steps that table definition information, table field definition information and service function information are obtained, wherein the service function information comprises interface information of service functions;
and responding to the configuration operation of the business data, and establishing an incidence relation between an index field and an operation result, wherein the index field comprises table information and table field information, and the operation result comprises display field information and SQL corresponding to business functions.
4. The method of claim 3, after the establishing the association relationship between the query field and the query result, further comprising:
and checking all the query fields.
5. The method according to any of claims 1 to 4, wherein obtaining a service function operation request comprises one of:
acquiring an adding operation request for adding a functional module of a service function;
acquiring a modification operation request for modifying a functional module of a service function;
acquiring a deleting operation request for deleting a functional module of a service function;
acquiring a query operation request for querying a functional module of a service function;
and acquiring an operation request for importing or exporting the functional module of the service function.
6. A service function operating apparatus, comprising:
a first obtaining unit, configured to obtain a service function operation request, where the service function operation request carries an operation object;
a determining unit, configured to determine, in response to the service function operation request, a service function address matched with the operation object;
a second obtaining unit, configured to obtain a Structured Query Language (SQL) statement associated with the operation object from the service function address, where the SQL statement is an execution statement configured for a service function through a configuration page in advance;
and the execution unit is used for executing the SQL statement to acquire a functional operation result of the operation object.
7. A computer-readable storage medium, comprising a stored program, wherein the program when executed performs the method of any of claims 1 to 5.
8. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 5 by means of the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111650001.7A CN114296696A (en) | 2021-12-29 | 2021-12-29 | Business function operation method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111650001.7A CN114296696A (en) | 2021-12-29 | 2021-12-29 | Business function operation method and device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114296696A true CN114296696A (en) | 2022-04-08 |
Family
ID=80973671
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111650001.7A Pending CN114296696A (en) | 2021-12-29 | 2021-12-29 | Business function operation method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114296696A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114780933A (en) * | 2022-06-22 | 2022-07-22 | 煜象科技(杭州)有限公司 | Data authority control method supporting multiple applications |
-
2021
- 2021-12-29 CN CN202111650001.7A patent/CN114296696A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114780933A (en) * | 2022-06-22 | 2022-07-22 | 煜象科技(杭州)有限公司 | Data authority control method supporting multiple applications |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210042299A1 (en) | Metadata-driven computing system | |
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| WO2021184725A1 (en) | User interface test method and apparatus, storage medium, and computer device | |
| CN107798038B (en) | Data response method and data response equipment | |
| CN106649630A (en) | Data query method and device | |
| JP6542880B2 (en) | Simplified invocation of import procedure to transfer data from data source to data target | |
| CN104679500B (en) | Method and device for realizing automatic generation of entity class | |
| CN110704476A (en) | Data processing method, device, equipment and storage medium | |
| CN112905600B (en) | Data query method and device, storage medium and electronic equipment | |
| CN112433941A (en) | Test analysis method, device, equipment and storage medium | |
| CA3169413A1 (en) | Report generating method, device, electronic equipment, and computer-readable medium | |
| CN115016784B (en) | Low code application multiplexing method, application analysis system, equipment and storage medium | |
| CN111125064A (en) | Method and device for generating database mode definition statement | |
| CN115017182A (en) | Visual data analysis method and equipment | |
| WO2023134134A1 (en) | Method and apparatus for generating association viewing model, and computer device and storage medium | |
| CN108959294B (en) | Method and device for accessing search engine | |
| CN110941634A (en) | Data processing method and device, storage medium and electronic device | |
| CN114817389A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| CN106936660B (en) | Data acquisition method and device | |
| CN114296696A (en) | Business function operation method and device, storage medium and electronic equipment | |
| CN110874365B (en) | Information query method and related equipment thereof | |
| CN111488386A (en) | Data query method and device | |
| CN113536748A (en) | Method and device for generating chart data | |
| CN115291773B (en) | Tree structure data display method and device | |
| US20230153179A1 (en) | Visitor stitching with data science notebooks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |