CN115221178B - Data table binding method, device, electronic equipment and computer readable medium - Google Patents
Data table binding method, device, electronic equipment and computer readable medium Download PDFInfo
- Publication number
- CN115221178B CN115221178B CN202210955518.5A CN202210955518A CN115221178B CN 115221178 B CN115221178 B CN 115221178B CN 202210955518 A CN202210955518 A CN 202210955518A CN 115221178 B CN115221178 B CN 115221178B
- Authority
- CN
- China
- Prior art keywords
- style
- data table
- page
- button
- control
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Computer Security & Cryptography (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
Embodiments of the present disclosure disclose a data table binding method, apparatus, electronic device, and computer readable medium. One embodiment of the method comprises the following steps: in response to detecting an updating operation acting on the list template modification page, updating the data table displayed in the list template modification page according to the updating operation to obtain an updated data table; storing the updated data table to a target database in a lasting manner; generating a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance; binding a front-end page and any data table stored in a target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table; and setting the verification information of each table field in the data table bound with the front-end page according to the pre-generated verification information group. The embodiment realizes low code, expandability, high flexibility and visualization when the front-end page is generated.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technology, and in particular, to a data table binding method, apparatus, electronic device, and computer readable medium.
Background
The front page is a page for information entry. Currently, when a front-end page is generated, multiple links such as business investigation, development, testing and the like are required to be performed, and code writing is required to be performed again for a specific function.
However, when the front-end page is generated in the above manner, there are often the following technical problems:
firstly, when the functions in the front-end page are modified or new functions are added in the front-end page, the number of links is too large, the flexibility is low, the communication cost is high, and the period is long;
secondly, when the front-end page is generated or the functions in the front-end page are modified, the code needs to be rewritten, so that repeated codes are excessive, the coupling degree is high, and the later maintenance is not facilitated.
Disclosure of Invention
The disclosure is in part intended to introduce concepts in a simplified form that are further described below in the detailed description. The disclosure is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
Some embodiments of the present disclosure propose a data table binding method, apparatus, electronic device, and computer readable medium to solve one or more of the technical problems mentioned in the background section above.
In a first aspect, some embodiments of the present disclosure provide a data table binding method, the method comprising: in response to detection of an update operation acting on a list template modification page, updating a data table displayed in the list template modification page according to the update operation to obtain an updated data table; storing the updated data table to a target database in a lasting manner; generating a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance; binding the front-end page with any data table stored in the target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table; and setting the verification information of each table field in the data table bound with the front-end page according to the pre-generated verification information group.
Optionally, the generating the front-end page according to the control style set, the font style set, the button style set and the page layout information set, includes:
in response to detecting a selection operation of at least one control style in the control style set, determining the selected at least one control style as a primary screening control style, and obtaining a primary screening control style set;
and setting the font style of each primary screening control style in the primary screening control style set according to the font style set to obtain a target control style set.
Optionally, the generating the front-end page according to the control style set, the font style set, the button style set and the page layout information set, further includes:
in response to detecting a selection operation of at least one button style in the button style set, determining the selected at least one button style as a prescreened button style, resulting in a prescreened button style set;
and setting the font style of each primary screening button style in the primary screening button style set according to the font style set to obtain a target button style set.
Optionally, the generating the front-end page according to the control style set, the font style set, the button style set and the page layout information set, further includes:
and generating a front-end page by using the selected page layout information, the target control style set and the target button style set in response to detecting a selection operation of any one page layout information in the page layout information set.
In a second aspect, some embodiments of the present disclosure provide a data table binding apparatus, the apparatus comprising: the updating unit is configured to respond to the detection of the updating operation acting on the list template modification page, and update the data table displayed in the list template modification page according to the updating operation to obtain an updated data table; a storage unit configured to store the updated data table to a target database in a persistent manner; the generating unit is configured to generate a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance; the binding unit is configured to bind any data table stored in the front-end page and the target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table; and a setting unit configured to set the check information of each table field in the data table bound with the front-end page according to the pre-generated check information group.
In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device having one or more programs stored thereon, which when executed by one or more processors causes the one or more processors to implement the method described in any of the implementations of the first aspect above.
In a fourth aspect, some embodiments of the present disclosure provide a computer readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the method described in any of the implementations of the first aspect above.
The above embodiments of the present disclosure have the following advantageous effects: by the data table binding method of some embodiments of the present disclosure, low code, scalability, high flexibility and visualization at the time of front-end page generation can be achieved. Specifically, the reason for the long period of the related front-end page generation and the inconvenience of the post-maintenance is that: the functions in the front-end page are modified or the links that the front-end page experiences when adding new functions are excessive, and the code needs to be rewritten when the front-end page is generated or the functions in the front-end page are modified. Based on this, the data table binding method of some embodiments of the present disclosure first, in response to detecting an update operation acting on a list template modification page, updates a data table displayed in the list template modification page according to the update operation, and obtains an updated data table. Therefore, the user can directly operate the database table structure in the list template modification page without really knowing the related knowledge of the database, and the operation is simpler, more flexible and faster. And then, the updated data table is stored in a target database in a lasting mode. Then, generating a front-end page according to the control style set, the font style set, the button style set and the page layout information set which are generated in advance. Therefore, the user can quickly generate the front-end page according to the requirements by utilizing the control style set, the font style set, the button style set and the page layout information set. Meanwhile, the control style set, the font style set, the button style set and the page layout information set are stored once, and can be dynamically loaded when in use, so that the code quantity and the code maintenance difficulty are reduced. And then binding any data table stored in the front-end page and the target database, wherein the front-end page is used for storing the information recorded in the front-end page into the bound data table. And finally, setting the verification information of each table field in the data table bound with the front-end page according to the pre-generated verification information group. Thus, low code, scalability, high flexibility, and visualization at the time of front-end page generation are achieved.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
FIG. 1 is a flow chart of some embodiments of a data table binding method according to the present disclosure;
FIG. 2 is a schematic diagram of a table template modification page in some embodiments of a data table binding method according to the present disclosure;
FIG. 3 is a schematic diagram of an interface dynamic configuration management page in some embodiments of a data table binding method according to the present disclosure;
FIG. 4 is a schematic diagram of a business dynamic configuration management page in some embodiments of a data table binding method according to the present disclosure;
FIG. 5 is a schematic diagram of the structure of some embodiments of a data table binding apparatus of the present disclosure;
fig. 6 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings. Embodiments of the present disclosure and features of embodiments may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.
It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
With continued reference to FIG. 1, a flow 100 of some embodiments of a data table binding method according to the present disclosure is shown. The data table binding method comprises the following steps:
In some embodiments, in response to detecting an update operation applied to a list template modification page, an execution body of the data table binding method updates a data table displayed in the list template modification page according to the update operation, to obtain an updated data table, and may include the following steps:
first, in response to determining that the update operation is an update operation for a table field, updating the table field in the data table. The update operation of the table field may include adding, modifying or deleting. The data table displayed in the list template modification page can be created in the list template modification page or selected in the target database. The target database may be a specified database.
As an example, the table fields in the above-described data table may be column names, types, lengths, and the like.
And a second step of setting the attribute of the table field in the data table in response to determining that the update operation is an attribute setting operation of the table field. The attribute setting operation of the table field may include a field length setting or a field type setting.
As an example, the field type of the table field may be a character type or an integer type, etc.
And thirdly, in response to determining that the updating operation is an adding and deleting operation of the data table, newly building the data table in the list template modification page or deleting the data table displayed in the list template modification page. When the data table does not exist in the list template modification page and the updating operation is a new operation of the data table, an empty data table can be directly created and displayed in the list template modification page. When a data table exists in the list template modification page and the update operation is a new operation on the data table, the existing data table in the list template modification page may be deleted first, and then an empty data table may be created and displayed in the list template modification page.
By way of example, referring to the schematic diagram of the list template modification page in FIG. 2, the data table may be updated at the list template modification page.
And 102, persisting the updated data table to a target database.
In some embodiments, the executing entity may persist the updated data table to the target database, and may include the following steps:
and a first step of replacing the data table in the target database with the updated data table in response to determining that the data table exists in the target database.
Whether the data table exists in the target database can be determined by determining whether the data table with the same table name as the table name of the data table exists in the target database. If a data table having the same table name as the data table exists in the target database, it is determined that the data table exists in the target database. If the target database does not have a data table having the same table name as the data table, it is determined that the target database does not have the data table.
And a second step of storing the updated data table to the target database in response to determining that the data table does not exist in the target database.
And step 103, generating a front-end page according to the control style set, the font style set, the button style set and the page layout information set which are generated in advance.
In some embodiments, the front-end page is used to store information entered in the front-end page into a binding data table. The executing body generates a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance, and the executing body can comprise the following steps:
in the first step, in response to detecting a selection operation of at least one control style in the control style set, determining the selected at least one control style as a primary screening control style, and obtaining the primary screening control style set.
And secondly, setting the font style of each primary screening control style in the primary screening control style set according to the font style set to obtain a target control style set. The target control style in the target control style group may be a control style after a font style is set.
And thirdly, in response to detecting the selection operation of at least one button style in the button style set, determining the selected at least one button style as a prescreening button style, and obtaining the prescreening button style set.
And step four, setting the font style of each primary screening button style in the primary screening button style set according to the font style set to obtain a target button style set. The target control style in the target button style set is a button style after the font style is set.
And fifthly, responding to detection of selection operation of any page layout information in the page layout information group, and generating a front-end page by using the selected page layout information, the target control style group and the target button style group. Wherein, each piece of layout information in the page layout information group is used for representing the layout of each target control style and each target button style in the front-end page. And according to the selected page layout information, the target control style set and the target button style set can be laid out to obtain a front-end page.
In some optional implementations of some embodiments, the executing body may further generate the front-end page by:
in response to detecting a selection operation of any of the style templates in the set of style templates set in advance, a front page is generated using the selected style template. The style templates in the style template set may include at least one control style and a corresponding font style, at least one button style and a corresponding font style, and page layout information.
Therefore, the front-end page can be generated more quickly and conveniently through the preset style template group, and the convenience and efficiency of front-end page generation are improved.
As an example, referring to the interface dynamic configuration management page in fig. 3, a control style, a font style, and a button style, and a page layout may be set in the interface dynamic configuration management page.
The above steps are taken as an invention point of the embodiment of the present disclosure, and solve the second technical problem mentioned in the background art, which is that repeated codes are too many and the coupling degree is high, so that the later maintenance is not facilitated. Factors that cause the above technical problems are often as follows: the code needs to be rewritten either when generating the front page or when modifying the functionality therein. If the above factors are solved, the effects of reducing the code quantity, reducing the coupling degree and facilitating the later maintenance can be achieved. To achieve this, the present disclosure introduces a pre-generated control style set, font style set, button style set, and page layout information set, as well as a pre-set style template set. Therefore, a user can directly select from the control style set, the font style set, the button style set, the page layout information set and the style template set according to requirements, code is not required to be rewritten, and the code quantity is reduced. And each control style, font style, button style and page layout information, as well as the preset style templates are independent, so that the coupling property can be reduced. Thus, the post-maintenance workload is reduced.
In some embodiments, the execution body may bind the front-end page and any data table stored in the target database.
The identification of the front-end page and the table name of any data table stored in the target database can be recorded, so that the binding of the front-end page and any data table stored in the target database is realized. After the front-end page and the data table are bound, the data collected through the front-end page can be stored in the bound data table.
In some embodiments, the execution body may set the check information of each table field in the data table bound to the front-end page according to a pre-generated check information set.
As an example, refer to the traffic dynamic configuration management page in fig. 4. The service dynamic configuration management page may be used to set the verification information for each table field in the data table. The check information in the pre-generated check information set may be "non-null and character length less than 200 characters", "input non-null and special characters", and "non-null check", etc.
In some optional implementations of some embodiments, the executing entity may further send the front-end page to the target terminal for presentation in response to receiving a front-end page presentation request. The target terminal is a terminal for sending the front-end page display request.
Optionally, the executing body may set the user permission and the data state for each control in the front-end page according to the user permission information set and the data state information set. The user permission information is used for representing access permissions of different users to different controls. The data state information in the data state information set is used for representing whether the data in the control is displayed or not and whether the data in the control can be edited or not.
The above embodiments of the present disclosure have the following advantageous effects: by the data table binding method of some embodiments of the present disclosure, low code, scalability, high flexibility and visualization at the time of front-end page generation can be achieved. Specifically, the reason for the long period of the related front-end page generation and the inconvenience of the post-maintenance is that: the functions in the front-end page are modified or the links that the front-end page experiences when adding new functions are excessive, and the code needs to be rewritten when the front-end page is generated or the functions in the front-end page are modified. Based on this, the data table binding method of some embodiments of the present disclosure first, in response to detecting an update operation acting on a list template modification page, updates a data table displayed in the list template modification page according to the update operation, and obtains an updated data table. Therefore, the user can directly operate the database table structure in the list template modification page without really knowing the related knowledge of the database, and the operation is simpler, more flexible and faster. And then, the updated data table is stored in a target database in a lasting mode. Then, generating a front-end page according to the control style set, the font style set, the button style set and the page layout information set which are generated in advance. Therefore, the user can quickly generate the front-end page according to the requirements by utilizing the control style set, the font style set, the button style set and the page layout information set. Meanwhile, the control style set, the font style set, the button style set and the page layout information set are stored once, and can be dynamically loaded when in use, so that the code quantity and the code maintenance difficulty are reduced. And then binding any data table stored in the front-end page and the target database, wherein the front-end page is used for storing the information recorded in the front-end page into the bound data table. And finally, setting the verification information of each table field in the data table bound with the front-end page according to the pre-generated verification information group. Thus, low code, scalability, high flexibility, and visualization at the time of front-end page generation are achieved.
With further reference to fig. 5, as an implementation of the method shown in the above figures, the present disclosure provides some embodiments of a data table binding apparatus, which correspond to those method embodiments shown in fig. 1, and which are particularly applicable in various electronic devices.
As shown in fig. 5, the data table binding apparatus 500 of some embodiments includes: an updating unit 501, a storage unit 502, a generating unit 503, a binding unit 504, and a setting unit 505. Wherein, the updating unit 501 is configured to respond to the detection of an updating operation acting on the list template modification page, and update the data table displayed in the list template modification page according to the updating operation to obtain an updated data table; a storage unit 502 configured to store the updated data table to a target database in a persistent manner; a generating unit 503 configured to generate a front-end page according to a control style set, a font style set, a button style set, and a page layout information set that are generated in advance; a binding unit 504 configured to bind any one of the data tables stored in the front-end page and the target database, where the front-end page is used to store information recorded in the front-end page into the bound data table; a setting unit 505 configured to set the check information of each table field in the data table bound to the front-end page according to the check information group generated in advance.
It will be appreciated that the elements described in the apparatus 500 correspond to the various steps in the method described with reference to fig. 1. Thus, the operations, features and resulting benefits described above with respect to the method are equally applicable to the apparatus 500 and the units contained therein, and are not described in detail herein.
Referring now to fig. 6, a schematic diagram of an electronic device 600 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device shown in fig. 6 is merely an example and should not impose any limitations on the functionality and scope of use of embodiments of the present disclosure.
As shown in fig. 6, the electronic device 600 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 601, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage means 608 into a Random Access Memory (RAM) 603. In the RAM603, various programs and data required for the operation of the electronic apparatus 600 are also stored. The processing device 601, the ROM 602, and the RAM603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
In general, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; and a communication device 609. The communication means 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. While fig. 6 shows an electronic device 600 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead. Each block shown in fig. 6 may represent one device or a plurality of devices as needed.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via communications device 609, or from storage device 608, or from ROM 602. The above-described functions defined in the methods of some embodiments of the present disclosure are performed when the computer program is executed by the processing device 601.
It should be noted that, the computer readable medium described in some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In some implementations, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.
The computer readable medium may be contained in the electronic device; or may exist alone without being incorporated into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: in response to detection of an update operation acting on a list template modification page, updating a data table displayed in the list template modification page according to the update operation to obtain an updated data table; storing the updated data table to a target database in a lasting manner; generating a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance; binding the front-end page with any data table stored in the target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table; and setting the verification information of each table field in the data table bound with the front-end page according to the pre-generated verification information group.
Computer program code for carrying out operations for some embodiments of the present disclosure may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. The described units may also be provided in a processor, for example, described as: a processor includes an updating unit, a storage unit, a generating unit, a binding unit, and a setting unit. Where the names of the units do not constitute a limitation on the unit itself in some cases, for example, the storage unit may also be described as "a unit that persists an updated data table to the target database".
The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
Claims (7)
1. A data table binding method, comprising:
in response to detection of an update operation acting on a list template modification page, updating a data table displayed in the list template modification page according to the update operation to obtain an updated data table;
storing the updated data table to a target database in a lasting manner;
generating a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance;
binding any data table stored in the front-end page and the target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table;
setting the verification information of each table field in the data table bound with the front-end page according to a pre-generated verification information group;
setting user permission and data states for each control in the front-end page according to a user permission information set and a data state information set, wherein the user permission information in the user permission information set is used for representing access permissions of different users to different controls, and the data state information in the data state information set is used for representing whether data in the controls are displayed or not;
wherein, the responding to the detection of the update operation acting on the list template modification page updates the data table displayed in the list template modification page according to the update operation to obtain an updated data table, and the method comprises the following steps:
in response to determining that the update operation is an update operation for a table field, updating a table field in the data table, wherein the update operation for the table field includes a new addition, a modification, or a deletion;
setting an attribute of a table field in the data table in response to determining that the update operation is an attribute setting operation of the table field, wherein the attribute setting operation of the table field includes a field length setting or a field type setting;
in response to determining that the update operation is an add-delete operation to a data table, either newly building the data table in the list template modification page or deleting the data table shown in the list template modification page;
the generating the front-end page according to the control style set, the font style set, the button style set and the page layout information set, which are generated in advance, comprises the following steps:
in response to detecting a selection operation of at least one control style in the control style set, determining the selected at least one control style as a primary screening control style, and obtaining a primary screening control style set;
setting font styles of all the primary screening control styles in the primary screening control style set according to the font style set to obtain a target control style set, wherein the target control styles in the target control style set are control styles with the set font styles;
in response to detecting a selection operation of at least one button style in the button style set, determining the selected at least one button style as a prescreened button style, resulting in a prescreened button style set;
setting font styles of all the primary screening button styles in the primary screening button style set according to the font style set to obtain a target button style set, wherein the target button style in the target button style set is the button style with the set font styles;
responding to the detection of the selection operation of any one page layout information in the page layout information group, and generating a front-end page by utilizing the selected page layout information, the target control style group and the target button style group, wherein each layout information in the page layout information group is used for representing the layout of each target control style and each target button style in the front-end page, and the target control style group and the target button style group are laid out according to the selected page layout information to obtain the front-end page;
wherein, each control style, font style, button style and page layout information are independent, so that the coupling property can be reduced.
2. The method of claim 1, wherein the method further comprises:
and sending the front-end page to a target terminal for display in response to receiving a front-end page display request.
3. The method of claim 1, wherein the method further comprises:
and generating a front-end page by using the selected style template in response to detecting the selection operation of any style template in the preset style template group, wherein the style templates in the style template group comprise at least one control style and corresponding font style, at least one button style and corresponding font style and page layout information.
4. A method according to any of claims 1-3, wherein said persisting said updated data table to a target database comprises:
in response to determining that the data table exists in the target database, replacing the data table in the target database with the updated data table;
and in response to determining that the data table does not exist in the target database, storing the updated data table to the target database.
5. A data table binding apparatus, comprising:
the updating unit is configured to respond to the detection of the updating operation acting on the list template modification page, and update the data table displayed in the list template modification page according to the updating operation to obtain an updated data table;
a storage unit configured to persist the updated data table to a target database;
the generating unit is configured to generate a front-end page according to a control style set, a font style set, a button style set and a page layout information set which are generated in advance;
the binding unit is configured to bind any data table stored in the front-end page and the target database, wherein the front-end page is used for storing information recorded in the front-end page into the bound data table;
a setting unit configured to set check information of each table field in a data table bound with the front-end page according to a pre-generated check information group;
the system comprises a user permission and data state setting unit, a control display unit and a control display unit, wherein the user permission and data state setting unit is configured to set user permission and data state for each control in the front-end page according to a user permission information set and a data state information set, wherein the user permission information in the user permission information set is used for representing the access permissions of different users to different controls, and the data state information in the data state information set is used for representing whether the data in the controls are displayed or not;
wherein the updating unit is further configured to: in response to determining that the update operation is an update operation for a table field, updating a table field in the data table, wherein the update operation for the table field includes a new addition, a modification, or a deletion; setting an attribute of a table field in the data table in response to determining that the update operation is an attribute setting operation of the table field, wherein the attribute setting operation of the table field includes a field length setting or a field type setting; in response to determining that the update operation is an add-delete operation to a data table, either newly building the data table in the list template modification page or deleting the data table shown in the list template modification page;
wherein the generating unit is further configured to: in response to detecting a selection operation of at least one control style in the control style set, determining the selected at least one control style as a primary screening control style, and obtaining a primary screening control style set; setting font styles of all the primary screening control styles in the primary screening control style set according to the font style set to obtain a target control style set, wherein the target control styles in the target control style set are control styles with the set font styles; in response to detecting a selection operation of at least one button style in the button style set, determining the selected at least one button style as a prescreened button style, resulting in a prescreened button style set; setting font styles of all the primary screening button styles in the primary screening button style set according to the font style set to obtain a target button style set, wherein the target button style in the target button style set is the button style with the set font styles; responding to the detection of the selection operation of any one page layout information in the page layout information group, and generating a front-end page by utilizing the selected page layout information, the target control style group and the target button style group, wherein each layout information in the page layout information group is used for representing the layout of each target control style and each target button style in the front-end page, and the target control style group and the target button style group are laid out according to the selected page layout information to obtain the front-end page; wherein, each control style, font style, button style and page layout information are independent, so that the coupling property can be reduced.
6. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-4.
7. A computer readable medium having stored thereon a computer program, wherein the program when executed by a processor implements the method of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210955518.5A CN115221178B (en) | 2022-08-10 | 2022-08-10 | Data table binding method, device, electronic equipment and computer readable medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210955518.5A CN115221178B (en) | 2022-08-10 | 2022-08-10 | Data table binding method, device, electronic equipment and computer readable medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115221178A CN115221178A (en) | 2022-10-21 |
| CN115221178B true CN115221178B (en) | 2023-07-14 |
Family
ID=83614978
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210955518.5A Active CN115221178B (en) | 2022-08-10 | 2022-08-10 | Data table binding method, device, electronic equipment and computer readable medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115221178B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108920141A (en) * | 2018-07-02 | 2018-11-30 | 广东飞企互联科技股份有限公司 | The Automatic Typesetting generation method and generator of business form based on layout templates |
| CN111221522A (en) * | 2020-01-13 | 2020-06-02 | 大汉软件股份有限公司 | Automatic code generation method of front-end and back-end separation architecture for government intensive application development |
| CN112684968A (en) * | 2020-12-28 | 2021-04-20 | 北京五八信息技术有限公司 | Page display method and device, electronic equipment and computer readable medium |
| CN114003843A (en) * | 2021-11-01 | 2022-02-01 | 上海浦东发展银行股份有限公司 | Page generation method, device, equipment and storage medium |
| CN114115844A (en) * | 2021-11-16 | 2022-03-01 | 招联消费金融有限公司 | Page generation method and device, computer equipment and storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6567849B2 (en) * | 1998-08-17 | 2003-05-20 | International Business Machines Corporation | System and method for configuring and administering multiple instances of web servers |
| CN112685037A (en) * | 2020-11-25 | 2021-04-20 | 紫光云技术有限公司 | Method for realizing binding and checking of front-end form component layout data |
| CN114281323A (en) * | 2021-03-30 | 2022-04-05 | 北京百特运通科技有限公司 | Front-end form generation method and system |
| CN113050946A (en) * | 2021-04-29 | 2021-06-29 | 成都新希望金融信息有限公司 | Method and device for generating website application system, electronic equipment and storage medium |
| CN113076104A (en) * | 2021-04-30 | 2021-07-06 | 京东方科技集团股份有限公司 | Page generation method, device, equipment and storage medium |
-
2022
- 2022-08-10 CN CN202210955518.5A patent/CN115221178B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108920141A (en) * | 2018-07-02 | 2018-11-30 | 广东飞企互联科技股份有限公司 | The Automatic Typesetting generation method and generator of business form based on layout templates |
| CN111221522A (en) * | 2020-01-13 | 2020-06-02 | 大汉软件股份有限公司 | Automatic code generation method of front-end and back-end separation architecture for government intensive application development |
| CN112684968A (en) * | 2020-12-28 | 2021-04-20 | 北京五八信息技术有限公司 | Page display method and device, electronic equipment and computer readable medium |
| CN114003843A (en) * | 2021-11-01 | 2022-02-01 | 上海浦东发展银行股份有限公司 | Page generation method, device, equipment and storage medium |
| CN114115844A (en) * | 2021-11-16 | 2022-03-01 | 招联消费金融有限公司 | Page generation method and device, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| Heverson Borba Ribeiro et al..Implementing a Peer-to-Peer Web Browser for Publishing and Searching Web Pages on Internet.《21st International Conference on Advanced Information Networking and Applications (AINA '07)》.2007,754-761. * |
| Visual Basic中Data数据控件的使用;王凤玲;《菏泽学院学报》;80-81 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115221178A (en) | 2022-10-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111581563B (en) | Page response method and device, storage medium and electronic equipment | |
| CN111309304B (en) | Method, device, medium and electronic equipment for generating IDL file | |
| CN110389796A (en) | Edit operation processing method, device and electronic equipment | |
| CN111857720B (en) | User interface state information generation method and device, electronic equipment and medium | |
| CN115757400B (en) | Data table processing method, device, electronic equipment and computer readable medium | |
| CN115344688A (en) | Business data display method and device, electronic equipment and computer readable medium | |
| CN115145560A (en) | Business orchestration method, device, equipment, computer readable medium and program product | |
| CN114428925A (en) | Page rendering method and device, electronic equipment and computer readable medium | |
| CN112131181A (en) | Storage path display method and device and electronic equipment | |
| CN115221178B (en) | Data table binding method, device, electronic equipment and computer readable medium | |
| CN112507676B (en) | Method and device for generating energy report, electronic equipment and computer readable medium | |
| CN115079873B (en) | Information display method, information display device, electronic equipment and storage medium | |
| CN111625692B (en) | Feature extraction method, device, electronic equipment and computer readable medium | |
| CN111241368B (en) | Data processing method, device, medium and equipment | |
| CN114327453A (en) | Page display method, device, equipment and storage medium | |
| CN114968621B (en) | Data communication method, device, equipment, storage medium and system | |
| CN111008178A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN110908867B (en) | Task completion judging method and device, storage medium and electronic equipment | |
| CN117112500B (en) | Resource management method, device, equipment and storage medium | |
| CN116127137B (en) | Highway engineering structure tree construction method, electronic equipment and computer readable medium | |
| CN114706645B (en) | Interface information transmission method, device, medium and electronic equipment | |
| CN113448550B (en) | Method and device for realizing collection management of classes, electronic equipment and computer medium | |
| CN116701181B (en) | Information verification flow display method, device, equipment and computer readable medium | |
| CN113419992B (en) | File clearing configuration page display method and device, electronic equipment and medium | |
| CN112688863B (en) | Gateway data processing method and device and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |