A Configurable ESB Service Development Method and Device

Abstract

The present invention discloses a configurable ESB service development method and device. The method comprises the following steps: preparing an ESB service configuration, defining input parameter configuration, output parameter configuration and SQL; sending a client request to an ESB process, wherein the client request contains an ESB service code and input parameter values; parsing the client request to obtain the ESB service code and input parameter values, obtaining the input parameter configuration, output parameter configuration and SQL of the ESB service according to the ESB service code, replacing placeholder in the SQL with the input parameter values in the client request, and submitting the SQL to a database for execution; performing output parameter processing on the SQL execution result according to the output parameter configuration, and publishing the ESB service. In the present invention, the release and upgrade of the ESB service can be carried out through a client request without programming, which simplifies the release and upgrade of the ESB service and improves the efficiency.

Description

Technical Field

[0001] The present invention relates to the technical field of ESB service buses, and particularly to a configurable ESB service development method and device. Background Art

[0002] Enterprise Service Bus (ESB) provides the function of connecting new and existing software applications within an enterprise and across enterprises, and enables the management and monitoring of interactions between applications with a set of rich functions. In the SOA layered model, ESB is used between the component layer and the service layer. It can connect and integrate components on different platforms through various communication protocols and map them into services in the service layer.

[0003] As a key part of the SOA infrastructure, in terms of service interaction, the services published on the ESB are defined in the current standard Web Services Description Language, and the ESB is usually equipped with a service directory and discovery mechanism. An important function of the ESB is to integrate different systems, and it must be able to support multiple ways of accessing the ESB (such as accessing legacy systems that access the ESB, WebService, CORBA, and using Socket, etc.) and map the accessed systems into Web services.

[0004] For traditional ESB service buses, service publishing and upgrading are relatively complex, and the technical requirements for developers are high.

[0005] In view of this, it is urgent to improve the existing ESB service development method to simplify the publishing and upgrading of ESB services and improve development efficiency. Summary of the Invention

[0006] Aiming at the above defects, the technical problem to be solved by the present invention is to provide a configurable ESB service development method and device to solve the problems of complex service publishing and upgrading in the existing ESB service development and high technical requirements for developers.

[0007] To this end, a configurable ESB service development method provided by the present invention includes the following steps:

[0008] Prepare corresponding ESB service configurations for ESB services, define the input parameter configurations, output parameter configurations, and SQL to be executed for the ESB services. Among them, they correspond one-to-one with the ESB service configurations, and each ESB service configuration has a unique ESB service code;

[0009] Send a client request to the ESB process through the client. The client request contains the ESB service code and the input parameter value;

[0010] Parse the client request to obtain the corresponding ESB service code and input parameter value. According to the ESB service code, obtain the input parameter configuration, output parameter configuration, and the SQL to be executed. Replace the placeholder in the SQL with the input parameter value in the client request, and submit the SQL to the database for execution;

[0011] Perform output parameter processing on the SQL execution result according to the output parameter configuration, and publish the ESB service.

[0012] In the above method, preferably, the ESB service configuration includes:

[0013] Author, the developer of the ESB service;

[0014] SvcName, the name of the ESB service;

[0015] LinkName, the database connection string corresponding to the ESB service;

[0016] ObjCls, the type of the ESB service;

[0017] The attributes of the input parameter value and the output parameter value in the input parameter configuration and the output parameter configuration include:

[0018] DataSize, the length limit of the parameter;

[0019] DataType, the parameter type;

[0020] Describe, the parameter description;

[0021] Require, whether the parameter is required to be passed.

[0022] In the above method, preferably, perform a legitimacy verification on the input parameter value, and after the verification passes, replace the placeholder in the SQL with the input parameter value in the client request. The legitimacy verification of the input parameter value includes the following steps:

[0023] Obtain the ESB service configuration according to the ESB service code, and construct a mapping relationship between the input parameter name and the input parameter value according to the input parameter configuration in the ESB service configuration;

[0024] Verify the necessity of the input parameter according to the required attribute Require of the input parameter;

[0025] Verify the legitimacy of the type of the input parameter value according to the data type attribute DataType of the input parameter;

[0026] Verify the legality of the length of the input parameter value according to the length limit attribute DataSize of the input parameter.

[0027] In the above method, preferably, replace the placeholder in the SQL with the input parameter value and submit the SQL to the database for execution, including the following steps:

[0028] Obtain the ESB service configuration according to the ESB service code, and obtain the SQL of the ESB service according to the ESB service configuration;

[0029] Replace the parameter placeholder in the SQL with the input parameter value in the client request and update the SQL;

[0030] Obtain the connection information of the database according to the service database connection string in the ESB service configuration;

[0031] Connect to the database using the connection information, submit the updated SQL to the database to execute the updated SQL, and return the SQL execution result.

[0032] In the above method, preferably, perform out-parameter processing on the SQL execution result according to the out-parameter configuration, including the following steps:

[0033] Obtain the corresponding ESB service configuration according to the ESB service code, and obtain the out-parameter configuration of the ESB service according to the ESB service configuration;

[0034] Create a mapping relationship between the out-parameter name and the out-parameter value according to the returned SQL execution result;

[0035] Verify the necessity of the out-parameter according to the required attribute Require of the out-parameter;

[0036] Verify the legality of the type of the out-parameter value according to the data type attribute DataType of the out-parameter;

[0037] Verify the legality of the length of the out-parameter value according to the length limit attribute DataSize of the out-parameter;

[0038] In the above method, preferably, publishing the ESB service includes the following steps:

[0039] Update the database service registration configuration;

[0040] Send a command to reload the XML configuration of the ESB service to the ESB process;

[0041] Update the ESB process, XML configuration and service registration configuration.

[0042] In the above method, preferably, the ESB service configuration is compiled using the Extensible Markup Language XML.

[0043] In the above method, preferably, multiple input parameter values and output parameter values are separated by delimiters.

[0044] The present invention also provides a configurable ESB service development device, including:

[0045] A service configuration module, which is used to compile the corresponding ESB service configuration for the ESB service, define the input parameter configuration, output parameter configuration and the SQL to be executed of the ESB service. Among them, the ESB service corresponds to the ESB service configuration one by one, and each ESB service configuration has a unique ESB service code;

[0046] A request module, which is used to send a client request to the ESB process. The client request contains an ESB service code and input parameter values;

[0047] A parsing module, which is used to parse the client request, obtain the corresponding ESB service code and input parameter values, obtain the input parameter configuration, output parameter configuration and the SQL to be executed of the ESB service according to the ESB service code, replace the placeholder in the SQL with the input parameter values in the client request, and submit the SQL to the database for execution;

[0048] An output parameter processing module, which is used to perform output parameter processing on the SQL execution result according to the output parameter configuration;

[0049] A publishing module, which is used to publish the ESB service.

[0050] In the above device, preferably, it further includes:

[0051] An input parameter verification module, which verifies the necessity of the input parameter according to whether the input parameter has the mandatory attribute Require; verifies the legality of the type of the input parameter value according to the data type attribute DataType of the input parameter; verifies the legality of the length of the input parameter value according to the data size attribute DataSize of the input parameter;

[0052] An output parameter verification module, which verifies the necessity of the output parameter according to whether the output parameter has the mandatory attribute Require; verifies the legality of the type of the output parameter value according to the data type attribute DataType of the output parameter; verifies the legality of the length of the output parameter value according to the data size attribute DataSize of the output parameter.

[0053] From the above technical solutions, it can be seen that a configurable ESB service development method and device provided by the present invention solve the problems that the service publishing and upgrading in the prior art are relatively complex and have high technical requirements for developers. Compared with the prior art, the present invention has the following beneficial effects:

[0054] By pre-compiling the corresponding ESB service configurations, defining the input parameter configurations, output parameter configurations of the ESB service, and the SQL to be executed, an ESB service configuration template is formed. The input parameters are passed into the SQL through a client request, the output parameters are obtained by executing the SQL, and the service is published and upgraded based on the output parameters. The service publishing and upgrading do not need to be implemented by programming each time, which simplifies the publishing and upgrading of ESB services and improves efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following will briefly introduce and explain the drawings required for the description of the embodiments of the present invention or the prior art. Obviously, the drawings in the following description are only partial embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0056] Figure 1 Flowchart of a configurable ESB service development method provided by the present invention;

[0057] Figure 2 For Figure 1 Detailed flowchart of step 300 in

[0058] Figure 3 For Figure 2 Detailed flowchart of step 340 in

[0059] Figure 4 Flowchart of output parameter processing for the SQL execution result according to the output parameter configuration in the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0060] The following will clearly and completely describe the technical solutions of the embodiments of the present invention in conjunction with the accompanying drawings of the embodiments of the present invention. Obviously, the embodiments described below are only part of the embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.

[0061] The implementation principle of the present invention is:

[0062] For the ESB service, compile the corresponding ESB service configuration, define the input parameter configuration, output parameter configuration of the ESB service, and the SQL to be executed; send a client request to the ESB process, parse the client request, obtain the corresponding ESB service code and input parameter value, replace the placeholder in the SQL with the input parameter value in the client request, and submit the SQL to the database for execution; perform output parameter processing on the SQL execution result according to the output parameter configuration, and publish the ESB service.

[0063] The solution provided by the present invention enables the release and upgrade of ESB services to be carried out through client requests, eliminating the need for programming, simplifying the release and upgrade of ESB services, and improving efficiency.

[0064] To provide a clearer explanation and illustration of the technical solution and implementation method of the present invention, several preferred specific embodiments for implementing the technical solution of the present invention are introduced below.

[0065] It should be noted that the orientation terms such as "inside, outside", "front, back", and "left, right" in this text are expressed based on the usage state of the product as the reference object. Obviously, the use of the corresponding orientation terms does not limit the protection scope of this solution.

[0066] Please refer to Figure 1 , Figure 1 which is a flowchart of a configurable ESB service development method provided by the present invention.

[0067] As Figure 1 shown, a configurable ESB service development method provided by the present invention includes the following steps:

[0068] Step 100: Compile the ESB service configuration.

[0069] The ESB service configuration is used to define the input parameter configuration, output parameter configuration, and executed SQL of the ESB service. The ESB service corresponds one-to-one with the ESB service configuration, and each ESB service configuration has a unique ESB service code. Different ESB service configurations have different ESB service codes.

[0070] The ESB service configuration is compiled using the Extensible Markup Language XML (eXtensible Markup Language). An example of an ESB service configuration is as follows:

[0071]

[0072]

[0073] The above ESB service configuration includes:

[0074] Author: The developer of the ESB service, such as sw in the above example;

[0075] SvcName: The name of the ESB service, such as the combined information query service in the above example;

[0076] LinkName: The database connection string corresponding to the ESB service. The connection information of the database can be obtained according to this database connection string, such as TRA_LINK in the above example;

[0077] ObjCls: The type of ESB service, such as TKSBSvcType in the above example.

[0078] In addition, <indata>Part of the code is used to define the attributes of the input parameter values of the ESB service. For example, the attributes of the input parameter value vc_fund_code are as follows:

[0079] DataSize = "10", DataType = "C", Describe = "Fund Code", Require = "1".

[0080] <outdata>Part of the code is used to define the attributes of the output parameter values of the ESB service. For example, the attributes of the output parameter value l_combi_id are: DataSize = "0", DataType = "L", Describe = "Combination ID", Require = "1".

[0081] <svcsql>Part of the code is used to define the SQL for service execution.

[0082] Among them, tcombi a and tfundinfo b represent different ESB service configuration tables tableA and tableB respectively. a.l_fund_id, b.vc_fund_code, and a.l_combi_id are the parameters defined in tableA. b.l_fund_id and vc_fund_code are the parameters defined in tableB. This is only an example here, and the ESB service configuration tables tableA and tableB and the parameters therein can be defined according to actual needs.

[0083] The attributes of the input parameter values and output parameter values both include the following aspects:

[0084] DataSize: The length limit of character-type parameters;

[0085] DataType: The parameter type, for example, string, integer, floating-point, etc.;

[0086] Describe: The parameter description, used to explain the meaning of the parameter;

[0087] Require: Whether the parameter is required to be passed.

[0088] Step 200, send a client request for a certain ESB service to the ESB process through the client. The client request contains the ESB service code and input parameter values of the ESB service.

[0089] This client request can be the publication or upgrade of a certain ESB service. If there are multiple input parameter values, they are separated by a delimiter. For example, the input parameter values in the client request are: 10001|10002|10003, and | is used as the delimiter respectively.

[0090] Step 300, parse the client request to obtain the corresponding ESB service code and input parameter values. Obtain the input parameter configuration, output parameter configuration, and SQL of the ESB service according to the ESB service code. Replace the placeholder in the SQL with the input parameter values in the client request, and submit the SQL to the database for execution.

[0091] Step 400, perform output parameter processing on the SQL execution result according to the output parameter configuration, and publish the ESB service.

[0092] Among them, the specific processing steps of step 300 are as Figure 2 shown, including the following steps:

[0093] Step 310, the ESB process parses the received client request to obtain the ESB service code and each input parameter value of the client request.

[0094] Step 320: Obtain the ESB service configuration based on the ESB service code, and build a mapping relationship between the input parameter name and the input parameter value according to the input parameter configuration in the ESB service configuration.

[0095] Step 330: Verify the legality of the input parameter value. Specifically, verify the necessity of the input parameter according to whether the parameter is required (Require), verify the legality of the type of the input parameter value according to the parameter type (DataType), and verify the legality of the length of the input parameter value according to the length limit (DataSize) of the parameter.

[0096] If the input parameter value meets the legality requirements, execute Step 340. If the input parameter value does not meet the legality requirements, return an error message to the client.

[0097] Step 340: Replace the placeholder corresponding to the input parameter value in the SQL in the client request, and submit the SQL to the database for execution.

[0098] Furthermore, as Figure 3 shown, the execution of Step 340 includes the following steps:

[0099] Step 341: Obtain the ESB service configuration according to the ESB service code, and obtain the SQL of the ESB service according to the ESB service configuration;

[0100] Step 342: Use the input parameter value in the client request to replace the parameter placeholder in the SQL to generate an SQL request.

[0101] For example, for the following SQL:

[0102] select a.l_fund_id,b.vc_fund_code,a.l_combi_id from tcombi a,tfundinfob where a.l_fund_id=b.l_fund_id and b.vc_fund_code='[vc_fund_code]'orderby a.l_fund_id,a.l_combi_id

[0103] where [vc_fund_code] is a placeholder, and if the value of vc_fund_code in the client request is 10001, the SQL will be replaced with:

[0104] Select a.l_fund_id, b.vc_fund_code, a.l_combi_id from tcombi a, tfundinfob where a.l_fund_id = b.l_fund_id and b.vc_fund_code = '10001' order by a.l_fund_id, a.l_combi_id。

[0105] Step 343, obtain the database connection information according to the service database connection string in the ESB service configuration;

[0106] Step 344, use the connection information to connect to the database, submit the SQL request to the database to execute the SQL, and return the SQL execution result.

[0107] If the SQL request is executed normally, return the SQL execution result, which contains the out-parameter value; if the SQL request fails, return the SQL execution error message.

[0108] After executing the SQL, the mapping relationship between the field name and the value has been created, and its field name corresponds to the out-parameter name. Therefore, the value of the out-parameter can be obtained according to the out-parameter name, and multiple out-parameter values are separated by a delimiter, such as separated by |.

[0109] As Figure 4 shown, in step 400, the out-parameter processing of the SQL execution result according to the out-parameter configuration includes the following steps:

[0110] Step 410, obtain the corresponding ESB service configuration according to the ESB service code, and obtain the out-parameter configuration of the ESB service according to the ESB service configuration;

[0111] Step 420, create a mapping relationship between the out-parameter name and the out-parameter value according to the returned SQL execution result;

[0112] Step 430, verify the legality of the out-parameter value. Among them, verify the necessity of the out-parameter according to whether the parameter is required to be passed Require; verify the legality of the type of the out-parameter value according to the parameter type DataType; verify the legality of the length of the out-parameter value according to the length limit DataSize of the parameter.

[0113] If the out-parameter legality verification passes, return the out-parameter value; if the out-parameter legality verification fails, return the error result.

[0114] In step 400, publishing the ESB service specifically includes the following steps:

[0115] Update the database service registration configuration;

[0116] Send a reloading service XML configuration command to the ESB process;

[0117] Update the ESB process, XML configuration, and service registration configuration.

[0118] For service publishing, upgrading, or taking offline, hot swapping can be achieved.

[0119] Based on the above method, the present invention further provides a configurable ESB service development device, including:

[0120] A service configuration module, used to prepare the corresponding ESB service configuration for the ESB service, define the input parameter configuration, output parameter configuration, and the SQL to be executed of the ESB service. Among them, the ESB service corresponds to the ESB service configuration one by one, and each ESB service configuration has a unique ESB service code;

[0121] A request module, used to send a client request to the ESB process, and the client request contains an ESB service code and input parameter values;

[0122] A parsing module, used to parse the client request, obtain the corresponding ESB service code and input parameter values, obtain the input parameter configuration, output parameter configuration, and the SQL to be executed of the ESB service according to the ESB service code, replace the placeholder in the SQL with the input parameter value in the client request, and submit the SQL to the database for execution;

[0123] An output parameter processing module, used to perform output parameter processing on the SQL execution result according to the output parameter configuration;

[0124] A publishing module, used to publish the ESB service.

[0125] In the above device, preferably, it further includes:

[0126] An input parameter verification module, which verifies the necessity of the input parameter according to whether the input parameter has the required attribute Require; verifies the legality of the input parameter value type according to the data type attribute DataType of the input parameter; verifies the legality of the input parameter value length according to the data size attribute of the input parameter;

[0127] An output parameter verification module, which verifies the necessity of the output parameter according to whether the output parameter has the required attribute Require; verifies the legality of the output parameter value type according to the data type attribute DataType of the output parameter; verifies the legality of the output parameter value length according to the data size attribute of the output parameter.

[0128] Based on the description of the above specific embodiments, a configurable ESB service development method and device provided by the present invention have the following advantages compared with the prior art:

[0129] First, it has changed the traditional practices of ESB service publishing and upgrading. ESB service publishing and upgrading can be carried out through client requests without programming, simplifying the ESB service publishing and upgrading and improving efficiency.

[0130] Second, the legality of the input parameter values and output parameter values are respectively verified to ensure the effective operation of the program, avoid errors, and reduce the debugging difficulty.

[0131] Third, corresponding ESB service configurations are respectively prepared for ESB services. Through the changes in the ESB service code and input parameter values in the client request, the ESB service publishing and upgrading can be carried out flexibly and conveniently, and multiple upgrades are supported.

[0132] Finally, it should also be noted that the terms "including", "comprising" or any other variants used in this article are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. Without further limitations, an element defined by the statement "including one..." does not exclude the existence of additional identical elements in the process, method, article or device including the said element.

[0133] The present invention is not limited to the above-mentioned best implementation manners. Anyone should know that structural changes made under the inspiration of the present invention, as long as they have the same or similar technical solutions as the present invention, fall within the protection scope of the present invention.< / svcsql> < / outdata> < / indata>

Claims

1. A configurable ESB service development method, characterized in that, It includes the following steps: Prepare the corresponding ESB service configuration for the ESB service, define the input parameter configuration, output parameter configuration, and the SQL to be executed of the ESB service. Among them, the ESB service corresponds one-to-one with the ESB service configuration, and each ESB service configuration has a unique ESB service code; Send a client request to the ESB process through the client. The client request contains the ESB service code and input parameter values, and the client request is for the publication or upgrade of the ESB service; Parse the client request, obtain the corresponding ESB service code and input parameter values, obtain the input parameter configuration, output parameter configuration, and the SQL to be executed of the ESB service according to the ESB service code, replace the placeholder in the SQL with the input parameter values in the client request, and submit the SQL to the database for execution; Perform output parameter processing on the SQL execution result according to the output parameter configuration, and publish the ESB service. Performing output parameter processing on the SQL execution result according to the output parameter configuration includes the following steps: Obtain the corresponding ESB service configuration according to the ESB service code, and obtain the output parameter configuration of the ESB service according to the ESB service configuration; Create a mapping relationship between the output parameter name and the output parameter value according to the returned SQL execution result; Verify the necessity of the output parameter according to whether the output parameter is a required attribute Require; Verify the legality of the output parameter value type according to the output parameter type attribute DataType; Verify the legality of the output parameter value length according to the length limit attribute DataSize of the output parameter; 2. The method according to claim 1, wherein The ESB service configuration includes: Author, the developer of the ESB service; SvcName, the name of the ESB service; LinkName, the database connection string corresponding to the ESB service; ObjCls, the type of the ESB service; The attributes of the input parameter value and the output parameter value in the input parameter configuration and the output parameter configuration include: DataSize, the length limit of the parameter; DataType, the parameter type; Describe, the parameter description; Require, whether the parameter is required; 3. The method according to claim 2, characterized in that, Verify the legality of the input parameter value, and after the verification passes, replace the placeholder in the SQL with the input parameter value in the client request. Verifying the legality of the input parameter value includes the following steps: Obtain the ESB service configuration according to the ESB service code, and build a mapping relationship between the input parameter name and the input parameter value according to the input parameter configuration in the ESB service configuration; Verify the necessity of the input parameter according to whether the input parameter is a required attribute Require; Verify the legality of the input parameter value type according to the input parameter type attribute DataType; Verify the legality of the input parameter value length according to the length limit attribute DataSize of the input parameter; 4. The method according to claim 1, wherein Replace the placeholder in the SQL with the input parameter value and submit the SQL to the database for execution, including the following steps: Obtain the ESB service configuration according to the ESB service code, and obtain the SQL of the ESB service according to the ESB service configuration; Replace the parameter placeholder in the SQL with the input parameter value in the client request and update the SQL; Obtain the connection information of the database according to the service database connection string in the ESB service configuration; Connect to the database using connection information, submit the update SQL to the database to execute the update SQL, and return the SQL execution result.

5. The method according to claim 1, wherein Publishing an ESB service includes the following steps: Update the database service registration configuration; Send an XML configuration command to the ESB process to reload the ESB service; Update the ESB process, XML configuration, and service registration configuration.

6. The method according to claim 1, wherein The ESB service configuration is prepared using the Extensible Markup Language (XML).

7. The method according to claim 1, characterized in that, Multiple input parameter values and output parameter values are separated by delimiters.

8. A configurable ESB service development device, characterized in that, Including: A service configuration module for preparing the corresponding ESB service configuration for an ESB service, defining the input parameter configuration, output parameter configuration, and SQL to be executed for the ESB service. Here, the ESB service corresponds one-to-one with the ESB service configuration, and each ESB service configuration has a unique ESB service code; A request module for sending a client request to the ESB process, where the client request contains the ESB service code and input parameter values; A parsing module for parsing the client request to obtain the corresponding ESB service code and input parameter values, obtaining the input parameter configuration, output parameter configuration, and SQL to be executed for the ESB service based on the ESB service code, replacing the placeholder in the SQL with the input parameter value in the client request, and submitting the SQL to the database for execution. The client request is for publishing or upgrading an ESB service; An output parameter processing module for processing the output parameters based on the output parameter configuration for the SQL execution result. Specifically: Obtain the corresponding ESB service configuration based on the ESB service code, and obtain the output parameter configuration for the ESB service based on the ESB service configuration; Create a mapping relationship between the output parameter name and the output parameter value based on the returned SQL execution result; Verify the necessity of the output parameter based on whether the output parameter is a required attribute Require; Verify the legality of the output parameter value type based on the output parameter type attribute DataType; Verify the legality of the output parameter value length based on the output parameter length limit attribute DataSize; A publishing module for publishing an ESB service.

9. The device according to claim 8, wherein It also includes: An input parameter verification module for verifying the necessity of the input parameter based on whether the input parameter is a required attribute Require, verifying the legality of the input parameter value type based on the input parameter type attribute DataType, and verifying the legality of the input parameter value length based on the input parameter length limit attribute DataSize; An output parameter verification module for verifying the necessity of the output parameter based on whether the output parameter is a required attribute Require, verifying the legality of the output parameter value type based on the output parameter type attribute DataType, and verifying the legality of the output parameter value length based on the output parameter length limit attribute DataSize.

Images