CN113935297A - Method, device and equipment for customizing Web application system table - Google Patents
Method, device and equipment for customizing Web application system table Download PDFInfo
- Publication number
- CN113935297A CN113935297A CN202111166544.1A CN202111166544A CN113935297A CN 113935297 A CN113935297 A CN 113935297A CN 202111166544 A CN202111166544 A CN 202111166544A CN 113935297 A CN113935297 A CN 113935297A
- Authority
- CN
- China
- Prior art keywords
- database table
- web application
- database
- application system
- column information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 230000015654 memory Effects 0.000 claims description 16
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 230000007774 longterm Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 235000014510 cooky Nutrition 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 230000003936 working memory Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Software Systems (AREA)
- Artificial Intelligence (AREA)
- Stored Programmes (AREA)
Abstract
The application provides a technical scheme for customizing a Web application system table, wherein a first database table, a second database table, a third database table and a fourth database table are constructed in a database corresponding to a Web application system; initializing a first database table, a second database table and a third database table based on the Web application system and preset customization requirements; logging in the Web application system based on a preset service identifier, and acquiring and displaying related table column information from the initialized third database table or the initialized third database table and the fourth database table; and acquiring a related customizable table column information list from the initialized third database table, selecting the customizable table column information from the third database table, and updating the fourth database table to finish customizing and displaying the Web application system table corresponding to the service identifier. The Web application system table corresponding to the service identification is customized through the method and can be stored in a database, so that long-term effectiveness is ensured.
Description
Technical Field
The application relates to the technical field of computer data processing, in particular to a technology for customizing a form of a Web application system.
Background
With the continuous promotion of digitization and networking, Web applications based on a B/S framework are more and more, service application scenes are more and more detailed, and the requirement on the efficiency of a Web application system is more and more important. Usually, a Web application system adopts a plurality of system table structures containing a plurality of table columns, and different business processes need to acquire or display only a part of the table column structures in the system table.
The currently common method for acquiring part of table columns related to services is to directly acquire a system table, tile all columns, use a horizontal scroll bar, and view the table columns related to the services by dragging left and right; or the display setting of the table columns related to the service in the system table is stored by adopting Cookies or cache, and the table columns related to the service can be directly displayed at the next login. However, the existing method is not intuitive, and the display setting of the system form cannot be customized according to different business requirements; or the customized system table can be displayed according to different service requirements, but the system table cannot be stored for a long time (the cookie is stored for a long time, and the cache is invalid when the device is restarted).
Therefore, a technical solution is needed to customize the Web application system table according to different business requirements and to save the Web application system table for a long time.
Disclosure of Invention
The application aims to provide a technical scheme for customizing a Web application system form, which is used for solving the technical problem that the existing customized Web application system form cannot be stored for a long time.
According to one aspect of the application, a method for customizing a form of a Web application system is provided, wherein the method comprises the following steps:
constructing a first database table, a second database table, a third database table and a fourth database table in a database corresponding to the Web application system;
initializing the first database table and the second database table based on the Web application system, and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements;
logging in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, acquiring and displaying fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, acquiring and displaying fixed table column information corresponding to the Web application system from the initialized third database table, and acquiring and displaying table column information corresponding to the service identifier from the fourth database table;
and acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
Optionally, wherein the first database table includes the following table column information:
the application sequence number, the application identifier and the application name are recorded, wherein the application sequence number value of each row of records is increased from 1 and is automatically and sequentially increased along with the increase of the row records.
Optionally, wherein the second database table includes the following table column information:
module serial number, the application identifier, the module identifier and the module name, wherein the module serial number value of each row of records is increased from 1 along with the increase of the row records in an automatic sequence.
Optionally, wherein the third database table includes the following table column information:
the system comprises a column serial number, the application identifier, the module identifier, a column name, a column type and a column position serial number, wherein the column serial number value of each row record is increased from 1 along with the increase of the row record in an automatic sequence.
Optionally, wherein the fourth database table includes the following table column information:
the serial number value of each row of records is increased from 1 along with the increase of the row records.
Optionally, wherein the fourth database table further includes the following table column information:
column position number.
Optionally, wherein the fourth database table further includes the following table column information:
creation time and update time.
Optionally, wherein when the table column information of the fourth database table includes a column location sequence number, after said selecting one or more customizable table column information therefrom, the method further comprises:
the location number of the selected customizable table column information is determined.
Optionally, the method for customizing the Web application system table further includes:
and packaging the constructed first database table, the second database table, the third database table and the fourth database table into a universal interface.
According to another aspect of the present application, there is also provided an apparatus for customizing a form of a Web application system, wherein the apparatus includes:
the first module is used for constructing a first database table, a second database table, a third database table and a fourth database table in a database corresponding to the Web application system;
the second module is used for initializing the first database table and the second database table based on the Web application system and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements;
a third module, configured to log in the Web application system based on a preset service identifier, if the fourth database table does not include table column information corresponding to the service identifier, obtain and display fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, obtain and display fixed table column information corresponding to the Web application system from the initialized third database table, and obtain and display table column information corresponding to the service identifier from the fourth database table;
and the fourth module is used for acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and then updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
Optionally, when the table column information of the fourth database table includes a column position sequence number, the fourth module is configured to:
and acquiring a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more customizable table column information from the customizable table column information list, and updating the fourth database table after determining the position sequence number of the customizable table column information to complete the customization and display of the Web application system table corresponding to the service identifier.
Optionally, the apparatus for customizing a Web application system table further includes:
and the fifth module is used for packaging the constructed first database table, the second database table, the third database table and the fourth database table into a universal interface.
Compared with the prior art, the technical scheme of the Web application system table is that a first database table, a second database table, a third database table and a fourth database table are constructed in a database corresponding to a Web application system; then based on the Web application system, initializing the first database table and the second database table, and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements; logging in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, acquiring and displaying fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, acquiring and displaying fixed table column information corresponding to the Web application system from the initialized third database table, and acquiring and displaying table column information corresponding to the service identifier from the fourth database table; and acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier. By the method, different services can obtain dynamically-set table column information after logging in the Web application system according to the service identification (or called service account number) of the service, so as to customize a relevant Web application system table corresponding to the service, and the relevant Web application system table can be stored in a database, thereby ensuring long-term effectiveness. Furthermore, the first database table, the second database table, the third database table and the fourth database table which are constructed can be encapsulated into a universal interface to provide read-write service for the outside, and the method and the device can be applied to any application scene where the Web application system form needs to be customized and needs to be effective for a long time.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments made with reference to the following drawings:
FIG. 1 illustrates a flow diagram of a method for customizing a form of a Web application system in accordance with an aspect of the subject application;
fig. 2 illustrates a timing diagram for invoking a general-purpose interface to initialize a POP application according to an alternative embodiment of the present application;
fig. 3 illustrates a timing diagram of a call generic interface custom POP application Web system table of another alternative embodiment of the present application;
FIG. 4 illustrates an apparatus diagram of a customized Web application system form in accordance with another aspect of the subject application;
the same or similar reference numbers in the drawings identify the same or similar elements.
Detailed Description
The present invention is described in further detail below with reference to the attached drawing figures.
In a typical configuration of the present application, each module of the device, apparatus, and/or associated trusted party includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include non-transitory computer readable media (transient media), such as modulated data signals and carrier waves.
In order to further explain the technical means and effects adopted by the present application, the following description clearly and completely describes the technical solution of the present application with reference to the accompanying drawings and preferred embodiments.
FIG. 1 illustrates a flow diagram of a method for customizing a form of a Web application system in one aspect of the subject application, wherein the method of one embodiment comprises:
s11, constructing a first database table, a second database table, a third database table and a fourth database table in the database corresponding to the Web application system;
s12, initializing the first database table and the second database table based on the Web application system, and initializing the third database table based on the initialized first database table, the initialized second database table and the preset customization requirement;
s13 logging in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, acquiring and displaying the fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, acquiring and displaying the fixed table column information corresponding to the Web application system from the initialized third database table, and acquiring and displaying the table column information corresponding to the service identifier from the fourth database table;
s14, based on the initialized third database table, obtaining and displaying the customizable table column information list corresponding to the Web application system, selecting one or more customizable table column information from the customizable table column information list, and then updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
In the present application, the method is performed by a client device 100 of a B/S architecture, the device 100 being a computer device including, but not limited to, a personal computer, a notebook computer, an industrial computer, a network host, a single network server, a plurality of network server sets, and/or a cloud; the Cloud is made up of a large number of computers or web servers based on Cloud Computing (Cloud Computing), which is a type of distributed Computing, a virtual supercomputer consisting of a collection of loosely coupled computers.
The computer device and/or cloud are merely examples, and other existing or future devices and/or resource sharing platforms, as applicable to the present application, are also intended to be included within the scope of the present application and are hereby incorporated by reference.
The device 100 may access the Web application system and a corresponding database thereof through a general browser or client software, where the database is a conventional relational database, such as Oracle, DB2, MySQL, SQL SERVER, and the like, which employ a line storage method.
In step S11, the device 100 builds a first database table, a second database table, a third database table, and a fourth database table in the database corresponding to the Web application system.
The first database table is used for recording Web applications allowing customizable table column information to be set dynamically, the second database table is used for recording Web application modules allowing customizable table column information to be set dynamically in the Web applications, and the third database table is used for recording fixed table column information and customizable table column information allowing the customizable table column information to be set dynamically in the Web application modules. The fourth database table is used for recording dynamically set customizable table column information corresponding to the service identification.
In a preferred embodiment, the database is MySQL, and the first, second, third and fourth database tables are constructed using Data Definition Language (DDL) of MySQL. According to the technical scheme, other traditional relational databases can be adopted, and the first database table, the second database table, the third database table and the fourth database table are constructed by using DDLs corresponding to the databases.
The technical scheme can be suitable for customizing and setting the Web application system table in various segmentation services of e-commerce or non-e-commerce.
Optionally, wherein the first database table includes the following table column information:
the application sequence number, the application identifier and the application name are recorded, wherein the application sequence number value of each row of records is increased from 1 and is automatically and sequentially increased along with the increase of the row records.
Wherein, the constructed first database table at least comprises the following table column information (column header): an application serial number (app _ id) serving as a primary key of the first database table, wherein the value of the application serial number corresponding to each row of records in the table column is increased from 1 and is automatically and sequentially increased along with the increase of the row records; an application identifier (app _ key), wherein each row of records under the table column corresponds to an identifier of a Web application system (or Web application page) which allows the table column to be customized, and is defined as a character string type; an application name (app _ name), and each row under the table column records the corresponding application name value corresponding to the name of the Web application system (or Web application page) that allows the table column to be customized. One example of a first database table constructed is shown in Table 1 below, which has no row records and is empty before initialization.
TABLE 1
| app_id | app_key | app_name |
Optionally, wherein the second database table includes the following table column information:
module serial number, the application identifier, the module identifier and the module name, wherein the module serial number value of each row of records is increased from 1 along with the increase of the row records in an automatic sequence.
Wherein, the constructed second database table at least comprises the following table column information (column header): a module serial number (module _ id) serving as a primary key of the second database table, wherein the module serial number value corresponding to each row of record in the table column is increased from 1 and is automatically and sequentially increased along with the increase of the row record; an application identification (app _ key) corresponding to an application identification table column in the first database table; module _ key, where each row under the table column records the corresponding module identification value corresponding to the identification of the module in the Web application system (or Web application page) allowing customization of the table column, and is defined as a character string type; module _ name, and each row under the table column records the corresponding module name value corresponding to the name of the module in the Web application system (or Web application page) allowing the table column to be customized. One example of a second database table constructed is shown in Table 2 below, which has no row records and the data is empty prior to initialization.
TABLE 2
| module_id | app_id | module_key | module_name |
Optionally, wherein the third database table includes the following table column information:
the system comprises a column serial number, the application identifier, the module identifier, a column name, a column type and a column position serial number, wherein the column serial number value of each row record is increased from 1 along with the increase of the row record in an automatic sequence.
Wherein, the constructed third database table at least comprises the following table column information (column header): column _ id as the primary key of the third database table, where the value of the column number corresponding to each row record under the table column is increased from 1 and automatically and sequentially along with the increase of the row record; an application identification (app _ key) corresponding to an application identification table column in the first database table; a module _ key corresponding to a module identification table column in the second database table; column _ key, where each row under the table column records the corresponding column identification value corresponding to the table column identification of the corresponding module in the Web application system (or called Web application page) that allows customizing the table column; column name (column _ name), where each row under the table column records the corresponding column name value corresponding to the name of the table column contained in the module in the Web application system (or Web application page) that allows customizing the table column; column type (column _ type), where the column type value may be a fixed table column, a default table column, or a customizable table column, for example, 1 may be used to identify the fixed table column type, 2 may be used to identify the default table column type, and 3 may be used to identify the dynamic table column type, where the default table column type and the dynamic table column type are customizable table column types, and after the service identifier logs in the Web application system, the table columns of the two column types may be selected to set the Web application system table thereof, so as to implement customization of the Web application system table corresponding to the service identifier, and when a third database table is subsequently imported, it is necessary to define a column type value corresponding to each row record as one of the three types; and a column position serial number (sort), wherein the column position serial number value corresponding to each row of record under the table column corresponds to the initial sorting position of the table column in the Web application system table.
One example of a third database table constructed is shown in table 3 below, where the third database table has no row records and the data is empty before initialization.
TABLE 3
| column_id | column_key | column_name | column_type | sort | app_key | module_key |
Optionally, wherein the fourth database table includes the following table column information:
the serial number value of each row of records is increased from 1 along with the increase of the row records.
Wherein, the fourth database table constructed at least comprises the following table column information (column header): the serial number (id) is used as a main key of a fourth database table, and the serial number value corresponding to each row of records under the table column is automatically and sequentially increased from 1 along with the increase of the row records; a business identifier (business _ id), wherein a business identifier value corresponding to each row of record in the table column is a unique identifier of a specific business, and for an e-commerce platform, the business identifier can be a unique merchant number, or one of a plurality of business account numbers of the same merchant (if the same merchant has different business application scenes), and is defined as a character string type; an application identifier (app _ key) corresponding to the application identifier table columns in the first database table and the third database table; a module _ key corresponding to the module identification table columns in the second database table and the third database table; column identification (column _ key). One example of a fourth database table constructed is shown in table 4 below, where the fourth database table has no row records and the data is null before any of the service identifiers first logs into the Web application system or no customizable table column settings are made.
TABLE 4
| id | business_id | app_key | module_key | column_key |
Optionally, wherein the fourth database table further includes the following table column information:
column position number.
Wherein, the fourth database table constructed may further include the following table column information (column header): and a column position serial number (sort), wherein after different service identifications are logged in, a column position serial number value corresponding to each row record in the table column can be set, so that a customizable column in the Web application system table is displayed according to the set position serial number.
Optionally, wherein the fourth database table further includes the following table column information:
creation time and update time.
Wherein, the fourth database table constructed may further include the following table column information (column header): creating time (create _ time), and the creating time value corresponding to each row of record under the column of the table can record the creating time of the row of record; update time (update _ time), and the corresponding update time value of each row record in the column of the table can record the last update time of the row record. The two table column information is adopted to facilitate the tracking query and maintenance of the operation. Another representation of a fourth database table is constructed as shown in table 5 below.
TABLE 5
| id | business_id | app_key | module_key | column_key | sort | create_time | update_time |
In this embodiment, in step S12, the device 100 initializes the first database table and the second database table based on the Web application system, and initializes the third database table based on the initialized first database table, second database table and preset customization requirement
In an exemplary application scenario of this embodiment, a system table exposed in a Web application system may be configured with a customizable table column containing some or all of the table columns in module B of Web application a, e.g., module B defines 10 table column information C1-C10.
Referring to an example of the first database table constructed as shown in table 1 above, an example after initializing the first database table is shown in table 6 below based on the Web application system.
TABLE 6
| app_id | app_key | app_name |
| 1 | A | Web application A |
Referring to an example of the second database table constructed as shown in table 2 above, an example after initializing the second database table is shown in table 7 below based on the Web application system.
TABLE 7
| module_id | app_id | module_key | module_name |
| 1 | 1 | B | Module B of Web application A |
If the preset customization requirements are: among the 10 table column information C1-C10 defined by the module B, C1-C4 are fixed table column types, C5-C6 are default table column types, C7-C10 are dynamic table column types, and the 10 table columns are arranged in sequence to form the table of the module B, and then, referring to an example of the third database table constructed as shown in the above table 3, based on the initialized first database table, the initialized second database table and the preset customization requirements, an example after the third database table is initialized is shown in the following table 8.
TABLE 8
| column_id | column_key | column_name | column_type | sort | app_key | module_key |
| 1 | C1 | C1 | 1 | 1 | A | B |
| 2 | C2 | C2 | 1 | 2 | A | B |
| 3 | C3 | C3 | 1 | 3 | A | B |
| 4 | C4 | C4 | 1 | 4 | A | B |
| 5 | C5 | C5 | 2 | 5 | A | B |
| 6 | C6 | C6 | 2 | 6 | A | B |
| 7 | C7 | C7 | 3 | 7 | A | B |
| 8 | C8 | C8 | 3 | 8 | A | B |
| 9 | C9 | C9 | 3 | 9 | A | B |
| 10 | C10 | C10 | 3 | 10 | A | B |
In this embodiment, in the step S13, the Web application system is logged in based on a preset service identifier, if the fourth database table does not include the table column information corresponding to the service identifier, the table column information of the fixed table column type corresponding to the Web application system and the table column information of the default table column type are acquired and displayed from the initialized third database table, otherwise, the table column information of the fixed table column type corresponding to the Web application system is acquired and displayed from the initialized third database table, and the table column information corresponding to the service identifier is acquired and displayed from the fourth database table.
In row record data in the initialized third database table, table column information with column type values of fixed table columns is fixedly displayed in a table of a Web application system after different service identifiers log in the Web application system; the method comprises the steps that table column information with a column type value of a default table column is displayed in a Web application system table when the Web application system table is logged in for the first time or is not set, after the Web application system is logged in, the table column information with the column type of the default table column can be set, whether the table column information is displayed in the Web application system table or not is selected as the table column information, if different business identifiers are logged in, different default table column type table column information is selected and stored, different business identifiers and different selected default table column type table column information are stored in a fourth database table, and the displayed Web application system table after logging in again can be different in table column information including the default table column type; the method comprises the steps that table column information with column type values of dynamic table columns cannot be displayed in a Web application system table when the Web application system table is logged in for the first time or is not set, the Web application system table can be selected to be modified after the Web application system is logged in, table column information of the type is selected from a table column list with the column type of the dynamic table column in an initialized third database table and stored, the modification and corresponding service identification are stored in a fourth database table, each piece of modified table column information corresponds to a row record, and the Web application system table displayed after logging in again can include the selected dynamic table column information; after logging in the Web application system, the column types can be adjusted to be the table column information of the default table column and the dynamic table column at the same time so as to modify the Web application system table and store the modification in the fourth database table.
In the above exemplary application scenario, when the Web application system including the module B of the Web application a is first logged in or is not provided with a customizable table column, the fourth database table has no data, and after logging in the Web application system by using the preset service identifier X, Y, the displayed Web application system tables all include C1 to C6 obtained from the data records of the third database table; if the service identifier X, Y logs in the Web application system before, but the Web application system table is not set, the fourth database table still has no data, and after the Web application system is logged in by adopting the preset service identifier X, Y, the displayed Web application system tables also all include C1-C6 obtained from the data records of the third database table; if the Web application system table is set, the fourth database table already contains customizable table column information corresponding to the service identifier X and customizable table column information corresponding to the service identifier Y, and if the fourth database table already contains C5 and C7 corresponding to the service identifier X and contains C5, C6 and C8 corresponding to the service identifier Y, after the Web application system is logged in by adopting the preset service identifier X, the displayed Web application system table comprises C1 to C4 obtained from the data records of the third database table and C5 and C7 obtained from the data records of the fourth database table; after logging in the Web application system by adopting the preset service identifier Y, the displayed Web application system table comprises C1-C4 obtained from the data records of the third database table and C5, C6 and C8 obtained from the data records of the fourth database table. An example of a corresponding fourth database table in this case is shown in table 9 below.
TABLE 9
| id | business_id | app_key | module_key | column_key |
| 1 | X | A | B | C5 |
| 2 | X | A | B | C7 |
| 3 | Y | A | B | C5 |
| 4 | Y | A | B | C6 |
| 5 | Y | A | B | C8 |
In this embodiment, in step S14, based on the initialized third database table, a customizable table column information list corresponding to the Web application system is obtained and displayed, and after one or more pieces of customizable table column information are selected, the fourth database table is updated, so as to complete customization and display of the Web application system table corresponding to the service identifier.
Continuing in the above example application scenario, if the service identifier X wants to further display two customizable table columns, C9 and C10, in the Web application system table after logging in the Web application system by using the service identifier X according to the service requirement of the service identifier X, logging in the Web application system by using the service identifier X, optionally setting (for example, a "setting" button may be designed on a visual interface for adjusting the table columns of the Web application system), selecting C9 and C10 from the popped up table column list for adjustment to join in the Web application system table, updating the fourth database table to complete customization of the Web application system table corresponding to the service identifier X, logging in again, and the displayed Web application system table includes C1 to C5, C7, C9, and C10. If the service identifier Y wants to display the customizable table column C7 in the Web application system table after logging in the Web application system by using the service identifier Y according to the service requirement, logging in the Web application system by using the service identifier Y, selecting and setting, selecting C7 from a popped table list which can be used for adjustment, adding the C7 into the Web application system table, updating a fourth database table to complete the customization and re-logging of the Web application system table corresponding to the service identifier Y, wherein the displayed Web application system table comprises C1-C5, C7 and C8. An example of a corresponding fourth database table in this case is shown in table 10 below.
Watch 10
The table column types stored in the fourth database table and available for selection may all be default table column types or all be dynamic table column types, or some may be default table column types and others may be dynamic table column types.
For example, in the example application scenario, the popped list of table columns available for adjustment includes: C5-C10.
In order to avoid conflict, if the table column information corresponding to the service identifier is stored in the fourth database table, these stored table columns in the popped table column list available for adjustment are selected by default, for example, in the above exemplary application scenario, the service identifier X is used to log in the Web application system for setting, and C5 and C7 in the popped table column list available for adjustment are selected by default.
Optionally, wherein when the table column information of the fourth database table includes a column position sequence number, the S14 includes:
and acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and updating the fourth database table after determining the position sequence number of the customizable table column information so as to complete the customization and display of the Web application system table corresponding to the service identifier.
If the table column information of the fourth database table further includes a column position sequence number, in the above exemplary application scenario, the fourth database table already includes C5, C7 and a column position sequence number value thereof corresponding to the service identifier X, for example, a column position sequence number value of C5 is 1, and a column position sequence number value of C7 is 2; the service identifier Y includes C5, C6, and C8 and their column position sequence numbers, for example, the column position sequence number of C5 is 1, the column position sequence number of C6 is 2, and the column position sequence number of C8 is 3. If the fourth database table also contains the create and update time table column information, an example of the corresponding fourth database table is shown in Table 11 below.
TABLE 11
| id | business_id | app_key | module_key | column_key | sort |
| 1 | X | A | B | C5 | 1 |
| 2 | X | A | B | C7 | 2 |
| 3 | Y | A | B | C5 | 1 |
| 4 | Y | A | B | C6 | 2 |
| 5 | Y | A | B | C8 | 3 |
Continuing in the above exemplary application scenario, if the service identifier X wants to further display two customizable table columns, C9 and C10, in the Web application system table after logging in the Web application system by using the service identifier X according to the service requirement, and adjust the column position sequence number value of C7 to 3, the column position sequence number value of C9 to 2, and the column position sequence number value of C10 to 4, logging in the Web application system by using the service identifier X, selecting setting, selecting C9 and C10 from the popped up table column list available for adjustment to join the Web application system table, and setting the column position sequence numbers of C9 and C10, and adjusting the column position sequence number value of C7, updating the fourth database table to complete the customization of the Web application system table corresponding to the service identifier X, and logging in again, where the displayed Web application system table sequence includes C1 to C5, C9, C7, and C10. If the service identifier Y wants to use the service identifier Y to log in the Web application system and then further display the customizable table column C7 in the Web application system table, which is arranged in front of C8, according to the service requirement, the service identifier Y is used to log in the Web application system, the setting is selected, C7 is selected from the popped list of table columns which can be used for adjustment and added into the Web application system table, the value of the column position serial number of C8 is adjusted to 4, the value of the column position serial number of C7 is set to 3, the fourth database table is updated, so that the customization of the Web application system table corresponding to the service identifier Y is completed, the login is resumed, and the displayed Web application system table sequence includes C1-C8. One example of a corresponding fourth database table in this case is shown in table 12 below.
TABLE 12
Optionally, the method for customizing the Web application system table further includes:
s15 (not shown) encapsulates the first database table, the second database table, the third database table and the fourth database table into a universal interface.
The built first database table, the second database table, the third database table and the fourth database table can be packaged into a universal interface which serves as a universal component to provide a standard read-write service interface for the outside, and the method can be applied to any standardized and modularized Web application system table customized application scene in the field of e-commerce or e-commerce application. For example, in the field of mobile internet, POP (PCtoWap Open Platform) is an important way for fusing mobile internet and integrating mobile internet resources, in an optional embodiment, a user may configure form column customization information of a POP application through a front end, and transfer the configuration customization information to a database by calling a general interface to initialize a first database table, a second database table, and a third database table related to the POP application, where a timing diagram of calling the general interface to initialize the POP application in an optional embodiment is shown in fig. 2.
In another optional embodiment, a user may access the POP application through the front end, transfer the requirement to the database by calling the general interface, and obtain the customizable table column information from the third database table and/or the fourth database table to dynamically set and store the Web application system table corresponding to the service identifier, where a timing diagram of calling the general interface customized POP application Web application system table in another optional embodiment is shown in fig. 3.
Fig. 4 is a schematic diagram of an apparatus for customizing a form of a Web application system according to another aspect of the present application, wherein the apparatus includes:
a first module 41, configured to construct a first database table, a second database table, a third database table, and a fourth database table in a database corresponding to the Web application system;
a second module 42, configured to initialize the first database table and the second database table based on the Web application system, and initialize the third database table based on the initialized first database table, second database table, and preset customization requirements;
a third module 43, configured to log in the Web application system based on a preset service identifier, if the fourth database table does not include the table column information corresponding to the service identifier, obtain and display fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, obtain and display fixed table column information corresponding to the Web application system from the initialized third database table, and obtain and display table column information corresponding to the service identifier from the fourth database table;
and a fourth module 44, configured to obtain and display a customizable table column information list corresponding to the Web application system based on the initialized third database table, select one or more pieces of customizable table column information from the customizable table column information list, and update the fourth database table to complete customization and display of the Web application system table corresponding to the service identifier.
In this embodiment, the apparatus is used to implement the method of the previous embodiment, and the apparatus is integrated in the same device as the software and hardware configuration environment of the previous device 100.
The first module 41 of the apparatus constructs a first database table, a second database table, a third database table, and a fourth database table in the database corresponding to the Web application system. The first database table is used for recording Web applications allowing customizable table column information to be set dynamically, the second database table is used for recording Web application modules allowing customizable table column information to be set dynamically in the Web applications, and the third database table is used for recording fixed table column information and customizable table column information allowing the customizable table column information to be set dynamically in the Web application modules. The fourth database table is used for recording dynamically set customizable table column information corresponding to the service identification.
The second module 42 of the apparatus initializes the first database table and the second database table based on the Web application system, and initializes the third database table based on the initialized first database table, second database table, and preset customization requirements.
The first database table and the second database table are initialized according to Web application and module related information thereof contained in a Web application system, and then the third database table is initialized according to preset customization requirements by combining data recorded in the initialized first database table and the initialized second database table.
A third module 43 of the apparatus logs in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, fixed table column information and default table column information corresponding to the Web application system are acquired and displayed from the initialized third database table, otherwise, fixed table column information corresponding to the Web application system is acquired and displayed from the initialized third database table, and customizable table column information corresponding to the service identifier is acquired and displayed from the fourth database table.
The Web application system is logged in for the first time aiming at different application scenes, such as scene one, and a displayed Web application system table comprises table column information, wherein the table column types obtained from the data records of the third database table are respectively a fixed table column type and a default table column type, because the fourth database table has no data; in a second scenario, although the Web application system table is not logged in for the first time, the Web application system table is not customized in the previous logging, at this time, the fourth database table still has no data, and the displayed Web application system table only includes table column information in which the table column types obtained from the data records of the third database table are respectively a fixed table column type and a default table column type; setting customization after login, wherein in a popped up customizable table column list, the table column information of the default table column type is selected by default; and a fourth scenario, after login, customized setting is performed, and at this time, the fourth database table includes table column information of which the type of the customized setting is a default table column type and/or a dynamic table column type.
A fourth module 44 of the apparatus customizes the Web application system table, acquires and displays a customizable table column information list corresponding to the Web application system based on the initialized third database table, and updates the fourth database table after selecting one or more customizable table column information, so as to complete customization and display of the Web application system table corresponding to the service identifier.
And popping up a customizable table column list after the customization setting operation is carried out, wherein the list is acquired and displayed from the initialized third database table and comprises table column information of a default table type and table column information of a dynamic table column type, if the fourth database table is not recorded, the table column information of the default table column type is selected by default, otherwise, the table column information of the default table column type recorded in the fourth database table is referred to determine whether the relevant default table column is selected by default.
Optionally, when the table column information of the fourth database table includes a column position sequence number, the fourth module is configured to:
and acquiring a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more customizable table column information from the customizable table column information list, and updating the fourth database table after determining the position sequence number of the customizable table column information to complete the customization and display of the Web application system table corresponding to the service identifier.
Optionally, the apparatus for customizing a Web application system table further includes:
and a fifth module 45 (not shown) for encapsulating the constructed first database table, second database table, third database table and fourth database table into a universal interface.
The fifth module 45 of the apparatus encapsulates the first database table, the second database table, the third database table and the fourth database table which are constructed into a universal interface, and the universal interface is used as a universal component to provide a standard read-write service interface for the outside, so that the apparatus is applicable to any standardized and modularized customized application scene of the Web application system table in the field of e-commerce or non-e-commerce application.
According to yet another aspect of the present application, there is also provided a computer readable medium having stored thereon computer readable instructions executable by a processor to implement the foregoing method.
It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, implemented using Application Specific Integrated Circuits (ASICs), general purpose computers or any other similar hardware devices. In one embodiment, the software programs referred to in the present application may be executed by a processor to implement the steps or functions described above. Also, the software programs (including associated data structures) of the present application may be stored in a computer-readable recording medium. Additionally, some of the steps or functions of the present application may be implemented in hardware, for example, as circuitry that cooperates with the processor to perform various steps or functions.
In addition, some of the present application may be implemented as a computer program product, such as computer program instructions, which when executed by a computer, may invoke or provide methods and/or techniques in accordance with the present application through the operation of the computer. Program instructions which invoke the methods of the present application may be stored on a fixed or removable recording medium and/or transmitted via a data stream on a broadcast or other signal-bearing medium and/or stored within a working memory of a computer device operating in accordance with the program instructions. An embodiment according to the present application comprises a device comprising a memory for storing computer program instructions and a processor for executing the program instructions, wherein the computer program instructions, when executed by the processor, trigger the device to perform a method and/or a solution according to the aforementioned embodiments of the present application.
According to another aspect of the present application, there is also provided an apparatus for customizing a form of a Web application system, wherein the apparatus includes:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform operations of the method as previously described.
For example, the computer readable instructions, when executed, cause the one or more processors to: constructing a first database table, a second database table, a third database table and a fourth database table in a database corresponding to the Web application system; initializing the first database table and the second database table based on the Web application system, and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements; logging in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, acquiring and displaying fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, acquiring and displaying fixed table column information corresponding to the Web application system from the initialized third database table, and acquiring and displaying table column information corresponding to the service identifier from the fourth database table; and acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the apparatus claims may also be implemented by one unit or means in software and/or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Claims (14)
1. A method for customizing a form of a Web application system, the method comprising:
constructing a first database table, a second database table, a third database table and a fourth database table in a database corresponding to the Web application system;
initializing the first database table and the second database table based on the Web application system, and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements;
logging in the Web application system based on a preset service identifier, if the fourth database table does not contain the table column information corresponding to the service identifier, acquiring and displaying fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, acquiring and displaying fixed table column information corresponding to the Web application system from the initialized third database table, and acquiring and displaying table column information corresponding to the service identifier from the fourth database table;
and acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
2. The method of claim 1, wherein the first database table includes the following tabular column information:
the application sequence number, the application identifier and the application name are recorded, wherein the application sequence number value of each row of records is increased from 1 and is automatically and sequentially increased along with the increase of the row records.
3. The method of claim 2, wherein the second database table includes the following table column information:
module serial number, the application identifier, the module identifier and the module name, wherein the module serial number value of each row of records is increased from 1 along with the increase of the row records in an automatic sequence.
4. The method of claim 3, wherein the third database table includes the following tabular column information:
the system comprises a column serial number, the application identifier, the module identifier, a column name, a column type and a column position serial number, wherein the column serial number value of each row record is increased from 1 along with the increase of the row record in an automatic sequence.
5. The method of claim 4, wherein the fourth database table includes the following tabular column information:
the serial number value of each row of records is increased from 1 along with the increase of the row records.
6. The method of claim 5, wherein the fourth database table further includes the following table column information:
column position number.
7. The method of claim 5 or 6, wherein the fourth database table further comprises the following table column information:
creation time and update time.
8. The method of claim 6, wherein after said selecting one or more customizable table column information therefrom, the method further comprises:
the location number of the selected customizable table column information is determined.
9. The method according to claim 1 or 8, characterized in that the method further comprises:
and packaging the constructed first database table, the second database table, the third database table and the fourth database table into a universal interface.
10. An apparatus for customizing a form of a Web application, the apparatus comprising:
the first module is used for constructing a first database table, a second database table, a third database table and a fourth database table in a database corresponding to the Web application system;
the second module is used for initializing the first database table and the second database table based on the Web application system and initializing the third database table based on the initialized first database table, the initialized second database table and preset customization requirements;
a third module, configured to log in the Web application system based on a preset service identifier, if the fourth database table does not include table column information corresponding to the service identifier, obtain and display fixed table column information and default table column information corresponding to the Web application system from the initialized third database table, otherwise, obtain and display fixed table column information corresponding to the Web application system from the initialized third database table, and obtain and display table column information corresponding to the service identifier from the fourth database table;
and the fourth module is used for acquiring and displaying a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more pieces of customizable table column information from the customizable table column information list, and then updating the fourth database table to complete the customization and display of the Web application system table corresponding to the service identifier.
11. The apparatus of claim 8, wherein when the table column information of the fourth database table includes a column position sequence number, the fourth module is to:
and acquiring a customizable table column information list corresponding to the Web application system based on the initialized third database table, selecting one or more customizable table column information from the customizable table column information list, and updating the fourth database table after determining the position sequence number of the customizable table column information to complete the customization and display of the Web application system table corresponding to the service identifier.
12. The apparatus of claim 10 or 11, further comprising:
and the fifth module is used for packaging the constructed first database table, the second database table, the third database table and the fourth database table into a universal interface.
13. A computer-readable medium comprising, in combination,
stored thereon computer readable instructions to be executed by a processor to implement the method of any one of claims 1 to 9.
14. An apparatus for customizing a form of a Web application, the apparatus comprising:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method of any of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111166544.1A CN113935297A (en) | 2021-09-30 | 2021-09-30 | Method, device and equipment for customizing Web application system table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111166544.1A CN113935297A (en) | 2021-09-30 | 2021-09-30 | Method, device and equipment for customizing Web application system table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113935297A true CN113935297A (en) | 2022-01-14 |
Family
ID=79277635
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111166544.1A Pending CN113935297A (en) | 2021-09-30 | 2021-09-30 | Method, device and equipment for customizing Web application system table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113935297A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| US20160274753A1 (en) * | 2013-12-11 | 2016-09-22 | Ricoh Company, Ltd. | Information processing apparatus, information processing method and storage medium |
| US20180285475A1 (en) * | 2017-03-28 | 2018-10-04 | Mcafee, Llc | Flexible record definitions for semi-structured data in a relational database system |
| CN111597238A (en) * | 2020-06-10 | 2020-08-28 | 北京明朝万达科技股份有限公司 | Method and device for dynamically displaying table data based on database |
| CN112329412A (en) * | 2021-01-06 | 2021-02-05 | 北京快成科技股份公司 | Method and device for dynamically controlling table columns based on front-end technology |
-
2021
- 2021-09-30 CN CN202111166544.1A patent/CN113935297A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| US20160274753A1 (en) * | 2013-12-11 | 2016-09-22 | Ricoh Company, Ltd. | Information processing apparatus, information processing method and storage medium |
| US20180285475A1 (en) * | 2017-03-28 | 2018-10-04 | Mcafee, Llc | Flexible record definitions for semi-structured data in a relational database system |
| CN111597238A (en) * | 2020-06-10 | 2020-08-28 | 北京明朝万达科技股份有限公司 | Method and device for dynamically displaying table data based on database |
| CN112329412A (en) * | 2021-01-06 | 2021-02-05 | 北京快成科技股份公司 | Method and device for dynamically controlling table columns based on front-end technology |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11531715B2 (en) | Systems and methods for single page application server-side renderer | |
| US10353993B2 (en) | Phased generation and delivery of structured documents | |
| US10776336B2 (en) | Dynamic creation and maintenance of multi-column custom indexes for efficient data management in an on-demand services environment | |
| US8418142B2 (en) | Architecture for data validation | |
| US8627204B2 (en) | Custom optimization of web pages | |
| US10438168B2 (en) | Facilitating dynamic customization of reporting tools in an on-demand services environment | |
| US9967370B2 (en) | OData enabled mobile software applications | |
| US20180121519A1 (en) | Systems and methods for a self-services data file configuration with various data sources | |
| CN108829809B (en) | Information display method, terminal equipment and network equipment thereof | |
| AU2020403002B2 (en) | Low latency dynamic content management | |
| US20150066841A1 (en) | Table-form presentation of hierarchical data | |
| WO2019105099A1 (en) | Advertising style metadata configuration method and device, computing device and storage medium | |
| CN103597464A (en) | Techniques for adapting an interpretive runtime application to multiple clients | |
| US10497039B1 (en) | Techniques for dynamic variations of a search query | |
| US10310965B2 (en) | Dynamic virtual testing environment for webpages | |
| CN110866202A (en) | Front-end paging method and device and readable storage medium | |
| US11443098B1 (en) | Federated recursive user interface element rendering | |
| US10942732B1 (en) | Integration test framework | |
| CN113935297A (en) | Method, device and equipment for customizing Web application system table | |
| US9230022B1 (en) | Customizable result sets for application program interfaces | |
| US9111014B1 (en) | Rule builder for data processing | |
| US9177255B1 (en) | Cloud systems and methods for determining the probability that a second application is installed based on installation characteristics | |
| US11586593B2 (en) | Mechanism for synchronization of hierarchical data between a mobile device and multi tenant database | |
| US11770437B1 (en) | Techniques for integrating server-side and client-side rendered content | |
| EP4009175A1 (en) | Simulation service providing a generic api endpoint |
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 |