Page configuration method and device, electronic equipment and readable medium

Abstract

The application discloses a page configuration method and device, electronic equipment and readable medium, the page configuration method comprises: a page configuration interface is displayed, the page configuration interface comprises a SQL template calling control; in response to the operation of the SQL template calling control, the SQL template is called; the SQL template is parsed, and attribute configuration controls corresponding to page configuration attribute information of the SQL template are displayed on the page configuration interface; in response to the configuration operation of the attribute configuration control, a page configuration SQL is generated; and the target page is rendered according to the page configuration SQL. The page configuration method provided by the application can directly modify the page configuration attribute based on the SQL template by displaying a visual page configuration interface, generate a page configuration SQL, quickly realize page configuration, greatly shorten the page configuration time and improve the configuration efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer technology, and in particular, to a page configuration method and device, an electronic device, and a readable medium. BACKGROUND

[0002] With different user needs, the page configuration of a webpage often needs to be adjusted. In the prior art, the adjustment of the page configuration usually requires modification at the code level. This approach is not only time-consuming and labor-intensive, but also requires a high level of professional knowledge of the developer, and ordinary users are difficult to adjust and maintain the page according to the needs.

[0003] Therefore, in view of the above technical problems, it is necessary to provide a new page configuration method and device. SUMMARY

[0004] The present application relates to the technical field of computer technology, and in particular, to a page configuration method and device, an electronic device, and a readable medium.

[0005] To achieve the above object, the technical solutions provided by the present application are as follows.

[0006] In a first aspect, the present application provides a page configuration method, which includes:

[0007] displaying a page configuration interface, the page configuration interface including a SQL template calling control;

[0008] in response to an operation on the SQL template calling control, calling a SQL template;

[0009] parsing the SQL template and displaying, in the page configuration interface, an attribute configuration control corresponding to page configuration attribute information of the SQL template;

[0010] in response to a configuration operation on the attribute configuration control, generating a page configuration SQL;

[0011] rendering a target page according to the page configuration SQL.

[0012] In one or more embodiments, the method further includes:

[0013] constructing a SQL template database, the SQL template database storing SQL templates.

[0014] In one or more embodiments, the method specifically includes:

[0015] In response to an operation on the SQL template calling control, an SQL template selection interface is displayed, and a template selection item corresponding to an SQL template stored in the SQL template database is displayed in the SQL template selection interface.

[0016] In response to a selection operation on the template selection item, the SQL template stored in the SQL template database is called.

[0017] In one or more embodiments, the method specifically comprises:

[0018] In the SQL template selection interface, a template search control is displayed.

[0019] In response to a keyword input in the template search control, a template selection item matching the keyword is displayed in the SQL template selection interface.

[0020] In one or more embodiments, the attribute configuration control comprises a table attribute configuration control, a field attribute configuration control, a search control attribute configuration control, and an operation button attribute configuration control.

[0021] In one or more embodiments, the method specifically comprises:

[0022] The page configuration SQL is bound to a target page, and a configuration ID associated with the page configuration SQL and the target page is generated;

[0023] The page configuration SQL and the configuration ID are stored in a page configuration database;

[0024] According to the configuration ID associated with the target page, the page configuration SQL bound to the target page is queried in the page configuration database;

[0025] The target page is rendered according to the bound page configuration SQL.

[0026] In one or more embodiments, rendering the target page according to the bound page configuration SQL specifically comprises:

[0027] According to the bound page configuration SQL, page configuration attribute information of the target page is obtained;

[0028] The target page is rendered according to the page configuration attribute information and a table template built in the target page.

[0029] In a second aspect, the application provides a page configuration device, which comprises:

[0030] The display module is configured to display a page configuration interface, wherein the page configuration interface comprises a SQL template calling control;

[0031] The calling module is configured to call a SQL template in response to an operation on the SQL template calling control.

[0032] The parsing module is configured to parse the SQL template to display attribute configuration controls corresponding to page configuration attribute information of the SQL template in the page configuration interface.

[0033] The generating module is configured to generate a page configuration SQL in response to a configuration operation on the attribute configuration controls.

[0034] The rendering module is configured to render a target page according to the page configuration SQL.

[0035] In a third aspect, the present application provides an electronic device, which comprises a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the page configuration method as described above when executing the program.

[0036] In a fourth aspect, the present application provides a computer readable medium, which carries computer execution instructions, and the computer execution instructions are used to implement the page configuration method as described above when executed by a processor.

[0037] Compared with the prior art, the page configuration method provided by the present application can greatly shorten the page configuration time and improve the configuration efficiency by displaying a visual page configuration interface, selecting and calling a pre-developed page configuration SQL template through a SQL template calling control on the page configuration interface, and directly configuring and modifying the page configuration attributes on the basis of the SQL template after parsing the SQL template to generate a page configuration SQL and quickly implement the page configuration. BRIEF DESCRIPTION OF DRAWINGS

[0038] Figure 1 is a schematic diagram of an implementation scenario in an embodiment of the present application;

[0039] Figure 2 is a flowchart of a page configuration method in an embodiment of the present application;

[0040] Figure 3 is a schematic diagram of a SQL template selection interface in an implementation scenario of the present application;

[0041] Figure 4 is a schematic diagram of a SQL template selection interface in another implementation scenario of the present application;

[0042] Figure 5is a structural schematic diagram of a page configuration device in an embodiment of the present application;

[0043] Figure 6 is a structural schematic diagram of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0044] The specific embodiments of the present application are described in detail below with reference to the accompanying drawings, but the protection scope of the present application is not limited by the specific embodiments.

[0045] Unless otherwise clearly indicated, throughout the specification and claims, the term "comprise" or variations such as "comprises" or "comprising" will be understood to imply the inclusion of a stated element or group of elements but not the exclusion of any other element or group of elements.

[0046] In order to facilitate the understanding of the technical solutions of the present application, the technical terms that may appear in the present application are first explained in detail below.

[0047] SQL (Structured Query Language, structured query language): a computer language used to store, retrieve and modify data stored in a relational database. SQL is the standard language for relational databases, and all relational database management systems (RDBMS), such as MySQL, Oracle, SQL Server, MS Access, Sybase, Informix, Postgres, etc., use SQL as their standard processing language.

[0048] Please refer to Figure 1 The present application is an embodiment of an embodiment of the present application. In this embodiment, it includes a configuration terminal 101, a page server 102 and an access terminal 103. The configuration terminal 101 and the access terminal 103 are connected by network communication, and the network can be a wide area network or a local area network, or a combination of the two, and can use wired or wireless links to realize data transmission.

[0049] When the configuration personnel logs in to the page configuration platform through the configuration terminal 101 to configure the page, the configuration terminal 101 outputs and displays a visual page configuration interface (an interface with configuration controls visible to the human eye).

[0050] Based on the page configuration operation of the configuration personnel, a page configuration SQL is generated and transmitted to the page server 102. When a user initiates an access request to the page server 102 through the access terminal 103, the page server 102 sends the page configuration SQL to the access terminal 103, and the access terminal 103 performs parsing and rendering based on the obtained page configuration SQL, and outputs and displays the rendered page to the user.

[0051] The terminal can be a mobile terminal such as a smartphone, a tablet computer, a laptop computer, and the like, or can be a desktop computer, a projection computer, and the like, and embodiments of the present application do not limit the terminal. The server can be a physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, content delivery networks (CDN), and basic cloud computing services such as big data and artificial intelligence platforms.

[0052] Please refer to Figure 2 Fig. 1 is a flow diagram of a page configuration method according to an embodiment of the present application, which can be applied to a configuration terminal as shown in Figure 1 The configuration terminal at least includes a display screen, and can output and display a visual page configuration interface on the display screen of the configuration terminal. The page configuration method includes the following steps:

[0053] S201: display a page configuration interface, the page configuration interface including a SQL template calling control.

[0054] In response to the operation of the configuration personnel logging into the page configuration platform through the configuration terminal, the page configuration interface is displayed on the display screen of the configuration terminal. The page configuration interface includes a SQL template calling control, and the SQL template calling control can be used to call a SQL template.

[0055] The page configuration interface can also include other configuration controls, and each configuration control is used to configure corresponding page-related configuration information. The configuration control can be a configuration information input control, or can be a configuration information selection control. Based on the configuration information input control, the configuration information can be manually input through an input device (such as a keyboard) or a touch operation body (such as a finger or a stylus). Based on the configuration information selection control, the configuration information can be selected through an input device (such as a mouse) or a touch operation body.

[0056] It should be noted that the SQL template is a page configuration template written in SQL language and built-in in the page configuration platform, and the SQL template includes page configuration attribute information used for page configuration.

[0057] Specifically, a plurality of SQL templates adapted to different application scenarios can be stored in a database of the page configuration platform to construct a SQL template database. For example, for hospital-side business, SQL templates applicable to scenarios such as medicine starting, medicine issuing, medicine receiving, medicine recycling, medicine sub-packaging, medicine inventory, medicine loss reporting, medicine freezing, medicine thawing, medicine destroying, equipment starting, equipment issuing, equipment receiving, equipment sub-packaging, equipment inventory, equipment loss reporting, equipment freezing, equipment thawing, and equipment destroying can be built into the SQL template database.

[0058] In an example embodiment, when the page configuration interface is displayed, adaptive output display can also be performed according to the configuration permission of the user who logs in the page configuration platform. For example, the user identifier (such as a username) who logs in the configuration platform can be obtained first, and then the configuration permission assigned to the user identifier is queried according to the user identifier. When the user identifier is displayed as a configuration administrator, the configuration permission corresponding to the user identifier is the highest configuration permission, that is, all configurable page data can be configured. The configuration permission can be divided according to a preset level, or can be directly set by the administrator.

[0059] Specifically, in the page configuration interface, only configuration items matching the configuration permission of the configuration personnel can be displayed, or all configuration items can be displayed, but the display manner of configuration items with configuration permission and configuration items without configuration permission is different. For example, configuration items with configuration permission can be displayed in black font, and configuration items without configuration permission can be displayed in gray font, and the configuration control of configuration items without configuration permission is not available.

[0060] S202: In response to the operation on the SQL template calling control, the SQL template is called.

[0061] It should be noted that the operation on the SQL template calling control is different according to the type of the configuration terminal. For example, when the configuration terminal is a general personal computer or notebook computer, and the input device is a mouse, the operation on the SQL template calling control can be the clicking or dragging operation of the configuration personnel through the mouse. When the display device of the configuration terminal is a touch display screen (such as a smart phone, a tablet computer, or a display screen of a desktop computer), the operation on the SQL template calling control can be the touch operation (such as clicking, pressing, sliding, or dragging) of the configuration personnel on the display screen area by using an operation body, such as a finger or a stylus.

[0062] In an example embodiment, in response to the operation on the SQL template calling control, a SQL template selection interface is displayed, and template selection items corresponding to the SQL templates stored in the SQL template database are displayed in the SQL template selection interface.

[0063] Taking a general personal computer as an example, the configuration personnel clicks the SQL template calling control on the page configuration interface by a mouse, and then refers to Figure 3 The SQL template selection interface is displayed in the display area of the display screen of the configuration terminal, and the template selection items corresponding to the SQL templates stored in the SQL template database are displayed in the SQL template selection interface.

[0064] For example, the SQL templates of five application scenarios, i.e., drug delivery, drug recovery, freezing management, instrument management, and loss reporting management, are stored in the SQL template database, and the drug delivery template selection item, the drug recovery template selection item, the freezing management template selection item, the instrument management template selection item, and the loss reporting management template selection item are correspondingly displayed in the SQL template selection interface.

[0065] Specifically, in response to the selection operation on the template selection item, the SQL template stored in the SQL template database is called.

[0066] The configuration personnel can select the template selection item displayed in the SQL template selection interface by means of mouse clicking. When the configuration personnel selects a template selection item, the SQL template corresponding to the selected template selection item stored in the SQL template database can be called.

[0067] For example, in the scenario shown in Figure 3 When the configuration personnel selects the loss reporting management template selection item by a mouse, the loss reporting management SQL template stored in the SQL template database can be called. Of course, in other embodiments, the configuration personnel can select the template selection item by other operation modes according to the type of the configuration terminal.

[0068] Specifically, the template search control can be displayed in the SQL template selection interface, and in response to the input of the keyword in the template search control, the template selection item matching the keyword can be displayed in the SQL template selection interface. The search control can help the configuration personnel to quickly find the required template selection item in the case of a large number of template selection items.

[0069] The search control is displayed in the SQL template selection interface, the search control has a text input box, and the search keyword can be manually input into the text input box by means of touch operation of an input device (for example, a keyboard) and an operation body (for example, a finger or a stylus), and in response to the input of the search keyword in the text input box, the template selection item matching the search keyword can be displayed in the SQL template selection interface. The display area of the search control and the template selection item in the SQL template selection interface can be set as required. For example, the search control can be displayed in the top area of the SQL template selection interface, and the template selection item can be displayed below the search control.

[0070] For example, in Figure 4 In the scenario shown, the configuration personnel can enter the keyword "damage report" in the text input box of the template search control on the SQL template selection interface, and the SQL template selection interface will display template options that match the keyword "damage report", such as "damage report management", "damage report review" and "damage report application" template options.

[0071] S203: Parse the SQL template and display the attribute configuration control corresponding to the page configuration attribute information of the SQL template on the page configuration interface.

[0072] After selecting the SQL template in step S202, the SQL template is parsed to obtain the page configuration attribute information contained in the SQL template, such as database field names and field types (including single-line input boxes, multi-line input boxes, multiple check boxes, single check boxes, dates, radio buttons, drop-down lists, reference fields, rich text editors, images, links, text, colors, and custom data bodies, etc.).

[0073] After obtaining the page configuration attribute information contained in the SQL template, the attribute configuration controls corresponding to the page configuration attribute information of the SQL template can be displayed in the page configuration interface. The attribute configuration controls include table attribute configuration controls, field attribute configuration controls, search control attribute configuration controls, operation button attribute configuration controls, etc.

[0074] S204: In response to the configuration operation of the attribute configuration control, generate page configuration SQL.

[0075] The attribute configuration control allows you to configure various page settings, such as whether a field is displayed in the table list, field column width, field column display order, whether the field supports searching based on its type, search order and default search value, whether table cells support bubbles and separators, table data status color, batch import and export of status colors, whether cell rendering functions support configuring JavaScript expressions, whether barcodes on drug packaging support searching, the number of table operation buttons, button permissions and data permissions, operation button text, button color, and button order.

[0076] By configuring the property configuration control, the configuration personnel can modify the page configuration property information contained in the SQL template, and generate a new page configuration SQL after completing the modification.

[0077] S205: Render the target page according to the SQL configured on the page.

[0078] After completing the configuration operation in step S204, the target page can be rendered based on the generated page configuration SQL (which includes page configuration attribute information after the configuration operation is executed).

[0079] Specifically, the page configuration SQL is bound to the target page, and a configuration ID associated with the page configuration SQL and the target page is generated; the page configuration SQL and the configuration ID are stored in the page configuration database; based on the configuration ID associated with the target page, the page configuration SQL bound to the target page is queried in the page configuration database; and the target page is rendered based on the bound page configuration SQL.

[0080] For example, when the target page is a drug freeze page, after the configuration personnel complete the configuration operation based on the SQL template, they bind the generated page configuration SQL with the drug freeze page to generate a configuration ID (unique ID) that associates the page configuration SQL with the drug freeze page, indicating that the page configuration SQL is the configuration SQL for the drug freeze page. After the binding is completed, the page configuration SQL and the corresponding configuration ID are stored in the page configuration database of the page server for later retrieval.

[0081] When a user sends an access request to the drug freezing page to the page server through an access terminal, the page server can query the page configuration SQL bound to the drug freezing page in the page configuration database based on the configuration ID associated with the drug freezing page, and send the page configuration SQL to the access terminal. The access terminal parses the page configuration SQL to render the drug freezing page, and displays the rendered page to the user through the access terminal's display screen.

[0082] It should be noted that a target page can correspond to one or more page configuration SQL statements. When a target page corresponds to multiple page configuration SQL statements, multiple rendering areas can be set on the target page, with each page configuration SQL statement rendering a page in one rendering area; alternatively, multiple operation buttons can be set on the target page, with each operation button corresponding to a page pop-up window, and each page pop-up window corresponding to a page configuration SQL statement.

[0083] In summary, the page configuration method provided by this invention displays a visual page configuration interface and allows selection and invocation of pre-developed page configuration SQL templates through the SQL template call control on the page configuration interface. After parsing the SQL template, page configuration attributes can be directly modified based on the SQL template to generate page configuration SQL, thereby quickly realizing page configuration. This greatly shortens page configuration time and improves configuration efficiency.

[0084] Please refer to Figure 5As shown, based on the same inventive concept as the aforementioned page configuration method, one embodiment of the present invention provides a page configuration device 500, which includes a display module 501, a calling module 502, a parsing module 503, a generation module 504, and a rendering module 505.

[0085] The display module 501 displays a page configuration interface, which includes an SQL template invocation control. The invocation module 502 invokes an SQL template in response to an operation on the SQL template invocation control. The parsing module 503 parses the SQL template to display an attribute configuration control corresponding to the page configuration attribute information of the SQL template on the page configuration interface. The generation module 504 generates page configuration SQL in response to a configuration operation on the attribute configuration control. The rendering module 505 renders the target page based on the page configuration SQL.

[0086] Specifically, the page configuration device 500 is communicatively connected to the page configuration platform, and it can obtain SQL templates from the SQL template database of the page configuration platform.

[0087] Please refer to Figure 6 As shown, embodiments of the present invention also provide an electronic device 600, which includes at least one processor 601, a memory 602 (e.g., non-volatile memory), a main memory 603, and a communication interface 604, and the at least one processor 601, the memory 602, the main memory 603, and the communication interface 604 are connected together via a bus 605. The at least one processor 601 is used to invoke at least one program instruction stored or encoded in the memory 602, so that the at least one processor 601 performs various operations and functions of the page configuration methods described in the various embodiments of this specification.

[0088] In the embodiments of this specification, electronic device 600 may include, but is not limited to: personal computer, server computer, workstation, desktop computer, laptop computer, notebook computer, mobile electronic device, smartphone, tablet computer, cellular phone, personal digital assistant (PDA), handheld device, messaging device, wearable electronic device, consumer electronic device, etc.

[0089] This invention also provides a computer-readable medium carrying computer-executable instructions, which, when executed by a processor, can be used to implement various operations and functions of the page configuration methods described in the various embodiments of this specification.

[0090] The computer-readable medium in this invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0091] In this invention, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. This propagated data signal may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wireless, wireline, optical fiber, RF, etc., or any suitable combination thereof.

[0092] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0093] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus, systems, and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart...Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0094] The foregoing description of specific exemplary embodiments of the invention is for illustrative and explanatory purposes. These descriptions are not intended to limit the invention to the precise forms disclosed, and it will be apparent that many changes and variations can be made in accordance with the foregoing teachings. The exemplary embodiments were chosen and described in order to explain the specific principles of the invention and its practical application, thereby enabling those skilled in the art to implement and utilize various different exemplary embodiments of the invention, as well as various different choices and variations. The scope of the invention is intended to be defined by the claims and their equivalents.

Claims

1. A page configuration method, characterized in that, include: The page configuration interface includes an SQL template call control. The configuration permissions of a user are queried based on the user identifier of the user who logged into the configuration platform, and only the configuration items that match the configuration permissions are displayed in the configuration interface of the page, or the configuration items that do not have the configuration permissions are displayed in gray and unavailable. In response to the operation of the SQL template call control, the SQL template selection interface is displayed, and the template selection items corresponding to the SQL templates stored in the SQL template database are displayed in the SQL template selection interface; In response to the selection operation of the template selection item, the SQL template is invoked; The SQL template is parsed, and attribute configuration controls corresponding to the page configuration attribute information of the SQL template are displayed on the page configuration interface. The attribute configuration controls include table attribute configuration controls, field attribute configuration controls, search control attribute configuration controls, and operation button attribute configuration controls. In response to configuration operations on the attribute configuration control, generate page configuration SQL; Bind the page configuration SQL to the target page and generate a configuration ID that associates the page configuration SQL with the target page; store the page configuration SQL and the configuration ID in the page configuration database; Upon receiving an access request for the target page, the system queries the page configuration database for the page configuration SQL bound to the target page based on the configuration ID associated with the target page, and then sends the page configuration SQL to the access terminal. The access terminal parses the page configuration SQL to obtain the page configuration attribute information of the target page, and renders the target page according to the page configuration attribute information and the table template built into the target page; One of the target pages may correspond to one or more page configuration SQL statements. The target page includes multiple rendering areas and / or has multiple operation buttons. Each page configuration SQL statement is rendered in one of the rendering areas or in a page pop-up window triggered by the corresponding operation button.

2. The page configuration method as described in claim 1, characterized in that, The method further includes: Construct an SQL template database, which stores SQL templates.

3. The page configuration method as described in claim 1, characterized in that, The method specifically includes: A template search control is displayed on the SQL template selection interface; In response to the keywords entered in the template search control, template options matching the keywords are displayed on the SQL template selection interface.

4. A page configuration apparatus, applied to the page configuration method of claim 1, characterized in that, include: The display module is used to display the page configuration interface, which includes an SQL template call control. The calling module is used to call the SQL template in response to an operation on the SQL template calling control; A parsing module is used to parse the SQL template so as to display attribute configuration controls corresponding to the page configuration attribute information of the SQL template on the page configuration interface; A generation module is used to generate page configuration SQL in response to configuration operations on the attribute configuration control; The rendering module is used to render the target page according to the SQL configured on the page.

5. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the page configuration method as described in any one of claims 1 to 3.

6. A computer-readable medium, characterized in that, The computer-readable medium carries computer-executable instructions, which, when executed by a processor, are used to implement the page configuration method as described in any one of claims 1 to 3.

Images