Page view configuration method, device, computer equipment and storage medium

Abstract

The present application relates to the field of big data, and uses the stored procedure of the database to implement the configuration of the page view. Specifically disclosed is a page view configuration method, device, computer equipment and storage medium, the method comprising: determining the stored procedure corresponding to the target page information according to the data query instruction of the first terminal device; obtaining the configuration information deployed in the database and the basic data information associated with the configuration information by calling the stored procedure through the control layer; determining the target page view according to the configuration information and the basic data information based on the view layer; and sending the target page view to the first terminal device for display. By obtaining the configuration information and the basic data information deployed in the database based on the stored procedure, it is convenient to change the target page view by adjusting the configuration information and the basic data information deployed in the database, which can improve the efficiency of the page view configuration. The method of the present application can be applied to cloud servers of cloud computing services of big data and artificial intelligence platforms.

Description

Technical Field

[0001] The present application relates to the field of big data technology, and in particular to a page view configuration method, device, computer equipment and storage medium. Background Art

[0002] Daily customized tool products on the web often need to display some text, graphics, images, videos and other information. The more common product demand development processes such as text, graphics, images, and video display all belong to the view layer. The view layer often requires some business logic calculations, and the underlying source of logical calculations is data; some content changes often only involve some small changes. For example, page view updates that do not involve layout changes also require modification of business code deployment to change the page view, which increases the number of releases and lacks flexibility. Summary of the invention

[0003] The embodiments of the present application provide a page view configuration method, apparatus, computer equipment, and storage medium, which can improve the efficiency of page view configuration and reduce the workload of developers when changing page views.

[0004] In a first aspect, the present application provides a page view configuration method for a server, wherein the server deploys a control layer and a view layer, and the method comprises:

[0005] Obtaining a data query instruction sent by the first terminal device;

[0006] Determine the target page information and the storage process corresponding to the target page information according to the data query instruction;

[0007] Calling the stored procedure corresponding to the target page information through the control layer, and acquiring the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure;

[0008] Based on the view layer, determining a target page view according to the configuration information and the basic data information;

[0009] The target page view is sent to the first terminal device, and the target page view is used to be displayed on the first terminal device.

[0010] In a second aspect, the present application provides a page view configuration device, the device comprising:

[0011] An instruction acquisition module, used to acquire a data query instruction sent by the first terminal device;

[0012] A process determination module, used to determine the target page information and the stored process corresponding to the target page information according to the data query instruction;

[0013] A process calling module, used to call the stored process corresponding to the target page information through the control layer, and obtain the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored process;

[0014] A view determination module, used to determine a target page view based on a view layer, according to the configuration information and the basic data information;

[0015] The sending module is used to send the target page view to the first terminal device, and the target page view is used to be displayed on the first terminal device.

[0016] In a third aspect, the present application provides a computer device, comprising a memory and a processor; the memory is used to store a computer program; the processor is used to execute the computer program and implement the steps of the above-mentioned page view configuration method when executing the computer program.

[0017] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program. If the computer program is executed by a processor, the steps of the above-mentioned page view configuration method are implemented.

[0018] The present application discloses a page view configuration method, device, equipment and storage medium. The method is used in a server, and the server deploys a control layer and a view layer. The method includes: obtaining a data query instruction sent by a first terminal device; determining the target page information and the stored procedure corresponding to the target page information according to the data query instruction; calling the stored procedure corresponding to the target page information through the control layer, and obtaining the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure; determining the target page view based on the view layer according to the configuration information and the basic data information; sending the target page view to the first terminal device, and the target page view is used to be displayed on the first terminal device. By obtaining the configuration information and the basic data information deployed in the database based on the stored procedure, it is convenient to change the target page view by adjusting the configuration information and the basic data information deployed in the database, thereby improving the efficiency of page view configuration and reducing the workload of developers when changing page views. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0020] Figure 1A schematic diagram of a flow chart of a page view configuration method according to an embodiment of the present application;

[0021] Figure 2 A schematic diagram of an application scenario of a page view configuration method in an implementation manner;

[0022] Figure 3 is a schematic diagram of a target page view in one implementation manner;

[0023] Figure 4 A schematic diagram of changing a target page view in the prior art;

[0024] Figure 5 A schematic diagram of changing a target page view in one implementation of an embodiment of the present application;

[0025] Figure 6 A schematic diagram of obtaining configuration information and basic data information based on a stored procedure in one implementation;

[0026] Figure 7 A schematic diagram of the structure of a page view configuration device provided in an embodiment of the present application;

[0027] Figure 8 A schematic diagram of the structure of a computer device provided in one embodiment of the present application. DETAILED DESCRIPTION

[0028] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0029] The flowcharts shown in the accompanying drawings are only examples and do not necessarily include all the contents and operations / steps, nor do they have to be executed in the order described. For example, some operations / steps can also be decomposed, combined or partially merged, so the actual execution order may change according to actual conditions. In addition, although the functional modules are divided in the device schematic, in some cases, the module division can be different from that in the device schematic.

[0030] Embodiments of the present application provide a page view configuration method, apparatus, device and storage medium. Figure 1 is a flow chart of a page view configuration method provided by an embodiment of the present application. Figure 2 It is a schematic diagram of an application scenario of a page view configuration method in one implementation.

[0031] In conjunction with the accompanying drawings, some embodiments of the present application are described in detail below. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.

[0032] The page view configuration method is used to generate a target page view according to preset data, and the target page view is used to be displayed on the first terminal device. The target page view is, for example, a web page, but is certainly not limited thereto.

[0033] For example, the page view configuration method is used for the server, and of course it can be used for the second terminal device. Among them, the server can be an independent server, or a server cluster, or it can be a cloud server that provides cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (Content Delivery Network, CDN), and big data and artificial intelligence platforms and other basic cloud computing services; for example, the server is a web server (or it can be called a website server). The first terminal device and the second terminal device can be electronic devices such as mobile phones, tablet computers, laptops, desktop computers, personal digital assistants and wearable devices. However, for ease of understanding, the following embodiments will mainly introduce the page view configuration method applied to the server in detail.

[0034] In some implementations, the target page view may be a big data analysis page, for example, Figure 3 The report shown in the figure. The layout of the report is generally fixed, such as Figure 3 As shown, the layout format of the report generally includes a query area (where query conditions can be entered, such as business attribution, indicator keywords, etc.) and a report display area, wherein the report display area is further divided into a table header (such as container ID, indicator name, etc.), a display data column (the data corresponding to the table header, the container ID can be ID-1 to ID-1046) and a page turn (which can facilitate the location of the data displayed in the current display data column). The query area presets a drop-down single-select query and a search term query, which is convenient for users to specify the data to be queried, and the query results can be displayed in the report display area.

[0035] like Figure 4 The figure shows a flow chart of changing the page view in the prior art. It can be seen that a complete product needs to be deployed and released for user access. If the requirements or business logic change, it often needs to be redeployed to update the page view content. Specifically, when changing the page view, it is necessary to deploy the compiled and packaged control layer (control) and view layer (view) on the web server, and deploy the library table for indicating the required data in the database (data base, DB); the user can access the page view through the browser of the first terminal device. The inventor of the present application found that Figure 4 The method shown in the figure often only involves some minor changes even when some content changes only involve some minor changes, such as changes in the calculation logic of a certain data, changes in the image display size, changes in the text content, and such changes in the page view that do not involve changes in the layout. It is also necessary to modify the business code and redeploy the control layer and the view layer to change the page view, thereby increasing the number of releases and lacking flexibility.

[0036] In response to this discovery, the inventors of the present application have improved the page view configuration method to improve the efficiency of page view configuration and reduce the workload of developers when changing page views.

[0037] like Figure 5 As shown in the figure, the server, such as the web server, deploys the control layer and the view layer, and the database deploys the stored procedure. Among them, the stored procedure is a set of SQL statements to complete specific functions. The SQL statements need to be compiled and then executed. The compiled SQL statements are deployed in the database. The user calls and executes the corresponding SQL statements by specifying the name of the stored procedure and giving parameters (if the stored procedure has parameters).

[0038] A stored procedure is a programmable function that is created and saved in a database and can consist of SQL statements and control structures. Stored procedures are very useful when you want to execute the same function on different applications or platforms, or encapsulate specific functions. Stored procedures in a database can be seen as a simulation of object-oriented methods in programming, which allows control over how data is accessed. Stored procedures can be written using control statements, have strong flexibility, and can perform complex judgments and more complex operations.

[0039] See also Figure 1 The page view configuration method of the embodiment of the present application includes the following steps S110 to S150.

[0040] Step S110: Obtain a data query instruction sent by the first terminal device.

[0041] See also Figure 3 , the first terminal device displays the target page view, generates the data query instruction according to the query condition entered by the user in the query area of ​​the target page view, and sends the generated data query instruction to the server.

[0042] Step S120: determining target page information and a storage process corresponding to the target page information according to the data query instruction.

[0043] Exemplarily, the target page information includes but is not limited to at least one of the following: properties of the target page view to be displayed, properties of data in the target page view to be displayed, and data volume. Based on the correspondence between the target page information and the stored procedure, the stored procedure corresponding to the target page information determined according to the data query instruction can be determined.

[0044] Step S130: calling the stored procedure corresponding to the target page information through the control layer, and acquiring the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure.

[0045] like Figure 5 As shown, the database unit is further deployed with a configurable table and a non-configurable table. The configurable table is used to store the configuration information, and the non-configurable table is used to store the basic data information. In some embodiments, the configurable table can be called a first configuration table, and the non-configurable table can be called a second configuration table.

[0046] In some implementations, the control layer calls a stored procedure corresponding to the target page information, and obtains configuration information deployed in a database and basic data information associated with the configuration information based on the stored procedure.

[0047] Please combine Figure 6 See also Figure 3 The web server can determine the stored procedure that needs to be called according to the target page information. The control layer deployed on the web server calls the stored procedure corresponding to the target page information, and obtains the required configuration information and basic data information associated with the configuration information based on the stored procedure.

[0048] See also Figure 6 , wherein the basic data information in the non-configurable table is used to indicate the basic data, and the corresponding basic data can be obtained according to the basic data information; for example, the basic data includes but is not limited to at least one of the following: text, graphics, images, and videos; the basic data information includes, for example, at least one of the following: the data identifier of the basic data, the location of the basic data; the data identifier of the basic data is, for example, the data number data_num, and the location of the basic data is, for example, the network address image_url of the basic data. For example, Figure 3 As shown, the basic data includes the drop-down radio query box, search term query box, and query button in the query area, and may also include the header text, page turning button, drop-down radio setting box (to set the number of data items displayed per page), and jump page turning box in the report display area.

[0049] Exemplarily, the configuration information in the configurable table includes the display logic of the basic data, such as which columns are displayed in the report header, the width of the displayed columns, whether the header displays a corresponding image (icon), whether to display prompt text information, image size, etc. For example, please refer to Figure 3 The configuration information includes the query content of the drop-down radio button in the query area, the search words in the search word query box, and the properties of the header display column in the report display area and the logic of displaying data. Figure 6 , where the configuration information includes the width of the query area (image_wid), and may also include drop-down radio query content for users to select.

[0050] By acquiring the configuration information and basic data information deployed in the database based on the stored procedure, since the stored procedure is pre-compiled, the efficiency of acquiring the configuration information and the basic data information can be improved.

[0051] Exemplarily, the stored procedure obtains configuration information corresponding to the stored procedure in the configurable table, and according to an information identifier of the configuration information, obtains basic data information corresponding to the information identifier in the non-configurable table.

[0052] The information identifier of the configuration information includes, for example, the number (id) of the configuration information. For example, see Figure 6 , the stored procedure obtains the configuration information corresponding to the stored procedure in the configurable table, such as the configuration information with id 1; then the stored procedure can obtain the basic data information with the same id in the non-configurable table.

[0053] The embodiment of the present application splits the business logic that needs to be configured into a configurable table and a non-configurable table corresponding to the stored procedure. When executing the business logic that needs to be configured, the configuration information is obtained from the configurable table through the stored procedure and the basic data information in the non-configurable table is queried in association; that is, the configurable business logic can be implemented by querying the configurable table and the non-configurable table in association with the stored procedure. It is also more convenient and easier to publish to modify the business logic through stored procedures, so that the content update of views such as reports can be realized through configuration. In the development and design of customized requirements, view updates can be realized through configuration without frequent releases.

[0054] In some embodiments, see Figure 5, business logic that does not require configuration, such as business logic that does not need to be changed frequently, can be implemented by obtaining the data required by the view layer from the non-configurable table or the data combined by some logical operations (addition, subtraction, multiplication, division, etc.) through the control layer deployed by the web server. Exemplarily, the control layer and the view layer are compiled and packaged to the web server as front-end applications. The control layer of the front-end application obtains the data required by the view layer from the non-configurable table or the data processed by some logical operations (addition, subtraction, multiplication, division, etc.) and returns it to the view layer to generate the target page view, so that users can directly access it through the browser.

[0055] Step S140: Based on the view layer, according to the configuration information and the basic data information, determine a target page view, wherein the target page view is used for display on a terminal device.

[0056] In some embodiments, the determining the target page view based on the view layer according to the configuration information and the basic data information includes: the control layer obtaining basic data from the database according to the basic data information; and the determining the target page view based on the view layer according to the basic data and the display logic of the basic data in the configuration information. Exemplarily, in some embodiments, the control layer deployed on the web server transmits the configuration information and the basic data indicated by the basic data information to the view layer to obtain the target page view generated by the view layer according to the configuration information and the basic data.

[0057] For example, the view layer may generate the target page view according to the display logic of the basic data in the configuration information, such as the indicated image display size, text content, etc.

[0058] In some implementations, the method further includes: obtaining a first database deployment instruction sent by a second terminal device, and adjusting the configuration information deployed in the database according to the first database deployment instruction, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing.

[0059] Exemplarily, when the target page view needs to be changed, such as when the image display size needs to be changed, the text content needs to be changed, or other view updates that do not involve layout changes, the configuration information can be adjusted on the second terminal device, and the adjusted configuration information and / or the adjusted content of the configuration information can be transmitted to the database for deployment; the control layer can obtain the adjusted configuration information through a stored procedure, and change the target page view based on the view layer.

[0060] It can be understood that the embodiment of the present application can realize the change of the target page view without redeploying the control layer and the view layer, and realize the decoupling of the control layer, the view layer and the stored procedure that actually controls the data change of at least part of the business logic. As described in the report function area above, the logic of the configurable part of the query area and the configurable part of the display area is implemented in the stored procedure. It is only necessary to modify the corresponding stored procedure without publishing the front-end application. It is only necessary to deploy the adjusted configurable table and / or non-configurable table in the database to complete the change. The frequency of publishing the front-end application can be reduced, and the number of releases can be reduced.

[0061] In some implementations, the control layer can obtain data processed based on the data calculation logic (addition, subtraction, multiplication, division, etc.) corresponding to the stored procedure and return it to the view layer. The view layer can also determine the target page view based on the data processed by the control layer. Exemplarily, the method also includes: performing calculation processing on the basic data in the database based on the data calculation logic corresponding to the stored procedure, and sending the calculated data to the view layer. The determining the target page view based on the view layer according to the configuration information and the basic data information includes: determining the target page view based on the view layer according to the configuration information, the basic data information, and the calculated data.

[0062] Exemplarily, the method further includes: obtaining a second database deployment instruction sent by the second terminal device, and adjusting the data calculation logic corresponding to the stored procedure according to the second database deployment instruction, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing. The data calculation logic is used to calculate the basic data corresponding to the basic data information.

[0063] By adjusting the data calculation logic corresponding to the stored procedure, the calculation logic of the data in the target page view can be changed. It is only necessary to modify the corresponding stored procedure without publishing the front-end application, and only the adjusted configurable table and / or non-configurable table needs to be deployed in the database to complete the change. The frequency of publishing the front-end application can be reduced, and the number of releases can be reduced.

[0064] After a stored procedure is created or adjusted, it can be called multiple times in the program without having to rewrite the SQL statement of the stored procedure. In addition, database professionals can modify the stored procedure to change the target page view, such as changing the calculation logic of a certain data, changing the image display size, changing the text content, and other view updates that do not involve layout changes.

[0065] Step S150: sending the target page view to the first terminal device, where the target page view is used to be displayed on the first terminal device.

[0066] In some implementations, the data query instruction sent by the first terminal device includes: the data query instruction generated by the first terminal device according to the query operation of the user in the target page view, that is, the query result can be updated according to the query operation of the user.

[0067] The web server determines the target page information and the stored procedure corresponding to the target page information according to the data query instruction; thus, the web server can call the stored procedure corresponding to the target page information through the control layer, obtain the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure, and determine the target page view based on the view layer according to the configuration information and the basic data information, and the target page view is used for display on the terminal device.

[0068] The page view configuration method provided by the embodiment of the present application includes obtaining a data query instruction sent by a first terminal device; determining the target page information and the stored procedure corresponding to the target page information according to the data query instruction; calling the stored procedure corresponding to the target page information through the control layer, and obtaining the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure; determining the target page view based on the view layer according to the configuration information and the basic data information; and sending the target page view to the first terminal device, and the target page view is used to be displayed on the first terminal device. By obtaining the configuration information and the basic data information deployed in the database based on the stored procedure, because the stored procedure is pre-compiled, the efficiency of obtaining the configuration information and the basic data information can be improved; and it is convenient to change the target page view by adjusting the configuration information and the basic data information deployed in the database, for example, the target page view can be changed without redeploying the control layer and the view layer, which can improve the efficiency of page view configuration, reduce the workload of developers when the page view is changed, and reduce the frequency of publishing front-end applications and the number of releases.

[0069] See also Figure 7 , Figure 7 It is a structural diagram of a page view configuration device provided by an embodiment of the present application. Optionally, the page view configuration device can be configured in a server to execute the steps of the aforementioned page view configuration method.

[0070] like Figure 7 As shown, the page view configuration device includes:

[0071] The instruction acquisition module 110 is used to acquire the data query instruction sent by the first terminal device;

[0072] A process determination module 120, configured to determine target page information and a stored process corresponding to the target page information according to the data query instruction;

[0073] The process calling module 130 is used to call the stored process corresponding to the target page information through the control layer, and obtain the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored process;

[0074] A view determination module 140, configured to determine a target page view based on a view layer, according to the configuration information and the basic data information;

[0075] The sending module 150 is used to send the target page view to the first terminal device, and the target page view is used to be displayed on the first terminal device.

[0076] In some implementations, the database is deployed with configurable tables and non-configurable tables, the configurable tables are used to store the configuration information, and the non-configurable tables are used to store the basic data information.

[0077] The process calling module is used to call the stored process corresponding to the target page information through the control layer, and obtain the corresponding configuration information in the configurable table and the corresponding basic data information in the non-configurable table based on the stored process.

[0078] Exemplarily, the stored procedure obtains basic data information corresponding to the information identifier in the non-configurable table according to the information identifier of the configuration information.

[0079] In some embodiments, the apparatus further includes: a first deployment module, used to obtain a first database deployment instruction sent by a second terminal device, and adjust the configuration information deployed in the database according to the first database deployment instruction, wherein the adjustment includes at least one of the following: addition, deletion, modification, and replacement.

[0080] In some implementations, the configuration information includes display logic for the basic data; and the view determination module includes:

[0081] The basic data acquisition submodule is used to acquire basic data from the database according to the basic data information. The basic data information includes at least one of the following: the data identifier of the basic data and the location of the basic data; the basic data includes at least one of the following: text, graphics, images, and videos;

[0082] The view determination submodule is used to determine the target page view based on the view layer, according to the basic data and the display logic of the basic data.

[0083] In some implementations, the device further includes: a data processing module, configured to perform calculation processing on basic data in the database based on the data calculation logic corresponding to the storage process, and send the calculated data to the view layer.

[0084] The view determination module is used to determine the target page view based on the view layer, according to the configuration information, the basic data information, and the calculated and processed data.

[0085] In some embodiments, the apparatus further includes: a second deployment module, used to obtain a second database deployment instruction sent by a second terminal device, and adjust the data calculation logic corresponding to the stored process according to the second database deployment instruction, wherein the adjustment includes at least one of the following: addition, deletion, modification, and replacement.

[0086] It should be noted that those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described devices and modules and units can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0087] The method and apparatus of the present application can be used in many general or special computing system environments or configurations, such as personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronic devices, network PCs, minicomputers, mainframe computers, and distributed computing environments including any of the above systems or devices.

[0088] Exemplarily, the above method and apparatus may be implemented in the form of a computer program. The computer program may be implemented in the form of a computer program. Figure 8 Runs on the computer device shown.

[0089] See also Figure 8 , Figure 8 1 is a schematic diagram of a computer device provided in an embodiment of the present application. The computer device may be a server or a terminal.

[0090] See also Figure 8 The computer device includes a processor, a memory and a network interface connected through a system bus, wherein the memory may include a non-volatile storage medium and an internal memory.

[0091] The non-volatile storage medium can store an operating system and a computer program. The computer program includes program instructions, and when the program instructions are executed, the processor can execute the steps of any one of the page view configuration methods.

[0092] The processor is used to provide computing and control capabilities and support the operation of the entire computer equipment.

[0093] The internal memory provides an environment for the operation of the computer program in the non-volatile storage medium. When the computer program is executed by the processor, the processor can execute any page view configuration method.

[0094] The network interface is used for network communication, such as sending assigned tasks, etc. Those skilled in the art can understand that the structure of the computer device is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0095] It should be understood that the processor may be a central processing unit (CPU), and the processor may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0096] In one embodiment, the processor is used to run a computer program stored in the memory to implement the following steps:

[0097] Obtaining a data query instruction sent by the first terminal device;

[0098] Determine the target page information and the storage process corresponding to the target page information according to the data query instruction;

[0099] Calling the stored procedure corresponding to the target page information through the control layer, and acquiring the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure;

[0100] Based on the view layer, determining the target page view according to the configuration information and the basic data information;

[0101] The target page view is sent to the first terminal device, and the target page view is used to be displayed on the first terminal device.

[0102] In some implementations, the database is deployed with configurable tables and non-configurable tables, the configurable tables are used to store the configuration information, and the non-configurable tables are used to store the basic data information.

[0103] The processor implements the calling of the stored procedure corresponding to the target page information by the control layer, and when acquiring the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored procedure, is used to:

[0104] The control layer calls a stored procedure corresponding to the target page information, and obtains corresponding configuration information in the configurable table and corresponding basic data information in the non-configurable table based on the stored procedure.

[0105] Exemplarily, the stored procedure obtains basic data information corresponding to the information identifier in the non-configurable table according to the information identifier of the configuration information.

[0106] Exemplarily, the processor is also used to implement: obtaining a first database deployment instruction sent by a second terminal device, and adjusting the configuration information deployed in the database according to the first database deployment instruction, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing.

[0107] Exemplarily, the configuration information includes display logic of the basic data; when the processor implements the determination of the target page view based on the view layer according to the configuration information and the basic data information, it is used to:

[0108] According to the basic data information, basic data is obtained from the database, wherein the basic data information includes at least one of the following: a data identifier of the basic data and a location of the basic data; the basic data includes at least one of the following: text, graphics, images, and videos; and

[0109] Based on the view layer, a target page view is determined according to the basic data and the display logic of the basic data.

[0110] Exemplarily, the processor is further configured to implement:

[0111] The basic data in the database is calculated based on the data calculation logic corresponding to the stored procedure, and the calculated data is sent to the view layer.

[0112] Exemplarily, when the processor implements the determination of the target page view based on the view layer, according to the configuration information and the basic data information, it is used to: determine the target page view based on the view layer, according to the configuration information, the basic data information, and the calculated and processed data.

[0113] Exemplarily, the processor is also used to implement: obtaining a second database deployment instruction sent by a second terminal device, and adjusting the data calculation logic corresponding to the stored procedure according to the second database deployment instruction, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing.

[0114] It can be seen from the description of the above implementation methods that those skilled in the art can clearly understand that the present application can be implemented by means of software plus a necessary general hardware platform. Based on this understanding, the technical solution of the present application can be essentially or partly contributed to the prior art in the form of a software product, which can be stored in a storage medium such as ROM / RAM, a disk, an optical disk, etc., and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present application or some parts of the embodiments, such as:

[0115] A computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and the processor executes the program instructions to implement any page view configuration method provided in the embodiments of the present application.

[0116] The computer-readable storage medium may be an internal storage unit of the computer device described in the foregoing embodiment, such as a hard disk or memory of the computer device. The computer-readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a smart memory card (SmartMedia Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), etc., equipped on the computer device.

[0117] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A page view configuration method, It is characterized in that Used for a server, the server deploys a control layer and a view layer, the method comprising: Obtaining a data query instruction sent by the first terminal device; Determine the target page information and the storage process corresponding to the target page information according to the data query instruction; Calling the stored procedure corresponding to the target page information through the control layer, acquiring configuration information deployed in the database and basic data information associated with the configuration information based on the stored procedure, wherein the database is deployed with configurable tables and non-configurable tables, the configuration information is acquired from the configurable tables, and the basic data information is acquired from the non-configurable tables, the configuration information includes display logic of basic data, and the basic data includes at least one of the following: text, graphics, images, and videos; Based on the view layer, determining a target page view according to the configuration information and the basic data information; Sending the target page view to the first terminal device, where the target page view is used to be displayed on the first terminal device; Wherein, determining the target page view based on the view layer according to the configuration information and the basic data information includes: According to the basic data information, basic data is obtained from the database; the basic data information includes at least one of the following: a data identifier of the basic data and a location of the basic data; Based on the view layer, a target page view is determined according to the basic data and the display logic of the basic data.

2. The page view configuration method according to claim 1, It is characterized in that The stored procedure obtains basic data information corresponding to the information identifier in the non-configurable table according to the information identifier of the configuration information.

3. The page view configuration method according to claim 1, It is characterized in that The method further comprises: A first database deployment instruction sent by a second terminal device is obtained, and according to the first database deployment instruction, the configuration information deployed in the database is adjusted, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing.

4. The page view configuration method according to any one of claims 1 to 3, It is characterized in that The method further comprises: Performing calculation processing on the basic data in the database based on the data calculation logic corresponding to the stored procedure, and sending the calculated data to the view layer; The determining the target page view based on the view layer according to the configuration information and the basic data information includes: Based on the view layer, a target page view is determined according to the configuration information, the basic data information, and the calculated and processed data.

5. The page view configuration method according to claim 4, It is characterized in that The method further comprises: A second database deployment instruction sent by the second terminal device is obtained, and according to the second database deployment instruction, the data calculation logic corresponding to the stored procedure is adjusted, wherein the adjustment includes at least one of the following: adding, deleting, modifying, and replacing.

6. A page view configuration device, It is characterized in that include: An instruction acquisition module, used to acquire a data query instruction sent by the first terminal device; A process determination module, used to determine the target page information and the stored process corresponding to the target page information according to the data query instruction; A process calling module, used to call the stored process corresponding to the target page information through the control layer, and obtain the configuration information deployed in the database and the basic data information associated with the configuration information based on the stored process, wherein the database is deployed with configurable tables and non-configurable tables, the configuration information is obtained from the configurable tables, and the basic data information is obtained from the non-configurable tables, the configuration information includes the display logic of the basic data, and the basic data includes at least one of the following: text, graphics, images, and videos; A view determination module, configured to obtain basic data from the database according to the basic data information; the basic data information includes at least one of the following: a data identifier of the basic data and a location of the basic data; Based on the view layer, determining the target page view according to the basic data and the display logic of the basic data; The sending module is used to send the target page view to the first terminal device, and the target page view is used to be displayed on the first terminal device.

7. A computer device, It is characterized in that The computer device includes a memory and a processor; The memory is used to store computer programs; The processor is used to execute the computer program and implement the steps of the page view configuration method according to any one of claims 1 to 5 when executing the computer program.

8. A computer-readable storage medium storing a computer program. It is characterized in that If the computer program is executed by a processor, the steps of the page view configuration method as described in any one of claims 1 to 5 are implemented.

Images