CN114065067A - Table display method and device, readable storage medium and electronic equipment - Google Patents
Table display method and device, readable storage medium and electronic equipment Download PDFInfo
- Publication number
- CN114065067A CN114065067A CN202111314065.XA CN202111314065A CN114065067A CN 114065067 A CN114065067 A CN 114065067A CN 202111314065 A CN202111314065 A CN 202111314065A CN 114065067 A CN114065067 A CN 114065067A
- Authority
- CN
- China
- Prior art keywords
- attribute
- service
- query
- display
- data
- 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 62
- 230000004044 response Effects 0.000 claims abstract description 23
- 238000009877 rendering Methods 0.000 claims abstract description 17
- 238000013507 mapping Methods 0.000 claims abstract description 8
- 230000006870 function Effects 0.000 claims description 155
- 238000006243 chemical reaction Methods 0.000 claims description 32
- 230000015654 memory Effects 0.000 claims description 18
- 238000012935 Averaging Methods 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 6
- 238000011161 development Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 8
- 238000013500 data storage Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000013461 design Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 239000007787 solid Substances 0.000 description 2
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9538—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
-
- 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
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)
- Artificial Intelligence (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application discloses a form display method, a form display device, a readable storage medium and electronic equipment, belongs to the field of data processing, and can solve the problem that response time of a displayed form is long after a business function changes. The method comprises the following steps: responding to a first input of a user, and acquiring a query code and an attribute code corresponding to a service function; acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; and mapping the service data to the corresponding columns of the blank display table, and generating, rendering and displaying the data display table corresponding to the service function. Thus, the development amount of the data display table can be reduced, and the response speed of displaying the data display table can be improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a form display method and apparatus, a readable storage medium, and an electronic device.
Background
With the continuous promotion of informatization, internetization and digitization processes, the rapid development of Web page related services of the world wide Web, and more service scenes need to be subjected to table display. In the related art, for each form to be displayed, a background interface of each form, an acquisition data request and a form display style are generally required to be written in a foreground request corresponding to a business requirement, then data returned by the acquisition data request is rendered through the background interface of the form corresponding to the foreground request, and finally the corresponding form is displayed according to the form display style.
When a plurality of forms are displayed on a Web page, the form corresponding to each service function has a set of codes for form display, and under the condition of service function change, the forms with changed service requirements can be displayed only by matching a foreground developer with a background developer and adaptively modifying codes in a foreground request and a background interface, so that the response time for displaying the forms after the service function change is longer.
Disclosure of Invention
The application aims to provide a form display method, a form display device, a readable storage medium and electronic equipment, which can solve the problem that the response time of a display form is long after a business function is changed.
In order to achieve the purpose, the following technical scheme is adopted in the application:
in a first aspect, the present application provides a table display method, including: responding to a first input of a user, and acquiring a query code and an attribute code corresponding to a service function; acquiring a service query attribute table corresponding to a query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to service functions and at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service functions and at least comprises the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; mapping the service data to a corresponding column of a blank display table to generate a data display table corresponding to the service function; and rendering and displaying the data display table.
Optionally, the obtaining of the service query attribute table corresponding to the query code and the service table attribute table corresponding to the attribute code includes: generating a configuration request link of a service function, wherein the configuration request link carries an inquiry code and an attribute code; and according to the configuration request link, acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code.
Optionally, before the query code and the attribute code corresponding to the service function are obtained in response to the first input of the user, the method further includes: creating a blank query attribute table and creating a blank table attribute table; configuring a blank query attribute table according to the service function to generate a service query attribute table, and configuring a blank table attribute table according to the service function to generate a service table attribute table; wherein, the data query parameters in the blank query attribute table comprise at least one of the following items: query codes, query table names, leaf nodes, directory nodes, father nodes, query statements, character definitions of data sources and query sequences; the display attribute parameters of the blank form attribute table comprise at least one of the following items: attribute coding, data fields, header words, column names corresponding to the header words, column width, whether to display, whether to browse, whether to filter, whether to search fields, group names, whether to allow editing, display type editing, enumeration source, list names to which the enumeration fields belong, editing time, whether to be an enumeration column, whether to be a summation column, whether to be an averaging value column, and display sequence.
Optionally, generating a blank display form corresponding to the service function according to the display attribute parameter in the service form attribute table, including: acquiring a header attribute parameter in the display attribute parameters; acquiring a style attribute parameter in the display attribute parameters; and generating a blank display table corresponding to the service function according to the header attribute parameter and the style attribute parameter.
Optionally, before the query code and the attribute code corresponding to the service function are obtained in response to the first input of the user, the method further includes: creating a blank enumeration conversion table; configuring a blank enumeration conversion table according to the service function to generate a service enumeration conversion table; the enumeration attribute parameters in the enumeration conversion table comprise table names to which enumeration fields belong, column names to which enumeration fields belong, word definitions of the enumeration fields and enumeration values of the enumeration fields.
Optionally, rendering and displaying the data display table includes: under the condition that the display attribute parameters comprise enumeration fields, acquiring a service enumeration conversion table corresponding to a service function; and performing data conversion on enumeration data corresponding to the enumeration fields in the data display table according to the service enumeration conversion table, rendering and displaying the data display table.
Optionally, the data query parameter in the blank query attribute table includes a permitted operation type, and the permitted operation type includes at least one of the following: add, configure, delete, save, and export; searching the service data corresponding to the service function according to the data query parameter in the service query attribute table, which comprises the following steps: and responding to a second input of the user, and reconfiguring the service query attribute table, wherein the operation type corresponding to the second input belongs to the allowed operation type.
In a second aspect, the present application provides a form display apparatus comprising: the device comprises an acquisition unit, a generation unit, a search unit and a display unit;
the acquiring unit is used for responding to first input of a user and acquiring query codes and attribute codes corresponding to service functions; the acquiring unit is further used for acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code, the service query attribute table is used for storing data query parameters of data corresponding to the service function, the service query attribute table at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service function, and the service table attribute table at least comprises the attribute code; the generating unit is used for generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; the searching unit is used for searching the service data corresponding to the service function according to the data query parameters in the service query attribute table; the generating unit is further used for mapping the service data to corresponding columns in the blank display table to generate a data display table corresponding to the service function; and the display unit is used for rendering and displaying the data display table.
In a third aspect, the present application provides a readable storage medium on which a program or instructions are stored, which when executed by a processor, implement the steps of the method according to the first aspect.
In a fourth aspect, the present application provides an electronic device comprising a processor, a memory, and a program or instructions stored on the memory and executable on the processor, the program or instructions, when executed by the processor, implementing the steps of the method according to the first aspect.
In the form display method disclosed by the application, a query code and an attribute code corresponding to a service function are acquired by responding to a first input of a user; acquiring a service query attribute table corresponding to a query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to service functions and at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service functions and at least comprises the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; mapping the service data to a corresponding column of a blank display table to generate a data display table corresponding to the service function; and rendering and displaying the data display table. Therefore, the blank display table and the service query attribute table corresponding to the service function can be obtained through the query code and the attribute code, so that different service functions can be flexibly configured, the development amount of the data display table is reduced, and the response speed of displaying the data display table can be improved.
Drawings
Fig. 1 is a schematic structural diagram of a table display system according to an embodiment of the present application;
fig. 2 is a schematic diagram of a table display method according to an embodiment of the present disclosure;
fig. 3 is a second schematic diagram of a table displaying method according to an embodiment of the present application;
fig. 4 is a third schematic diagram of a table displaying method according to an embodiment of the present application;
FIG. 5 is a fourth schematic diagram of a table displaying method according to an embodiment of the present application;
FIG. 6 is a fifth schematic diagram illustrating a table displaying method according to an embodiment of the present application;
FIG. 7 is a schematic structural diagram of a table displaying apparatus according to an embodiment of the present disclosure;
fig. 8 is a hardware schematic diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that any embodiment or design described herein as "exemplary" or "e.g.," is not to be construed as preferred or advantageous over other embodiments or designs. Rather, use of the word "exemplary" or "such as" is intended to present concepts related in a concrete fashion.
For the convenience of clearly describing the technical solutions of the embodiments of the present application, in the embodiments of the present application, the terms "first", "second", and the like are used for distinguishing the same items or similar items with basically the same functions and actions, and those skilled in the art can understand that the terms "first", "second", and the like are not limited in number or execution order.
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The table display method provided by the embodiment of the present application is described in detail below with reference to the accompanying drawings through specific embodiments and application scenarios thereof.
In a scenario of performing form display on different service functions, a form corresponding to each service function has a set of codes for form display, and under the condition of service requirement change, a foreground developer is required to cooperate with the codes in a foreground request and a background interface to adaptively modify the codes so as to display the form with the changed service requirement, thereby causing longer response time for displaying the form with the changed service function.
In order to solve the problem that the response time for displaying the form after the business function is changed is long, the form displaying method provided by the embodiment of the application is provided. The table display method can be applied to a table display system. Fig. 1 is a schematic structural diagram of a table display system applied to the embodiment of the present application. As shown in fig. 1, the table showing system includes a table showing apparatus 11 and a data storage device 12. The table showing apparatus 11 is connected with the data storage device 12. The connection mode may be a wired connection mode or a wireless connection mode, which is not limited in the embodiment of the present application.
The data storage device 12 is used for storing various data related to business functions.
The form display apparatus 11 may be configured to, in response to a first input of a user, obtain a query code and an attribute code corresponding to a service function; acquiring a service query attribute table corresponding to a query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to service functions and at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service functions and at least comprises the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; mapping the service data to a corresponding column of a blank display table to generate a data display table corresponding to the service function; and rendering and displaying the data display table.
The form display apparatus 11 may be a personal smart device such as a mobile phone, a smart watch, a video camera, a tablet computer, or the like, or may be an electronic device such as a notebook computer, a desktop computer, a television, or other electronic devices that can shoot, display, or store a target video, and the form of the form display apparatus 11 is not limited herein.
The table showing apparatus 11 and the data storage device 12 to be described may be independent devices or may be integrated into the same device, and the present invention is not limited to this. When the table showing apparatus 11 and the data storage device 12 are integrated into the same device, the communication mode between the table showing apparatus 11 and the data storage device 12 is the communication between the internal units of the device. In this case, the communication flow between the two is the same as the "communication flow between the table showing apparatus 11 and the data storage device 12 in the case where they are independent of each other".
The table display method provided by the embodiment of the present application is described below with reference to the accompanying drawings. As shown in fig. 2, the present embodiment provides a table display method, which may include steps 201 to 206 described below. The method is exemplified by taking the execution subject as a table showing device.
In the embodiment of the application, the first input is used for indicating a data presentation form corresponding to a presentation service function, and the first input carries a unique identifier used for indicating the service function, where the unique identifier may be a name, a sequence number, or a random number.
It is understood that the first input may be input through an input device such as a keyboard, a mouse, a screen, etc., or may be input through other devices via transmission means such as infrared, bluetooth, wireless network, etc.
In the embodiment of the application, the table display device obtains the service function in the first input and the unique identifier corresponding to the service function, and then searches the query code and the attribute code corresponding to the service function according to the unique identifier.
It should be noted that the query code is used to search the relevant data corresponding to the service function, and the attribute code is used to search the table attribute data of the data display table corresponding to the service function.
In the embodiment of the present application, the service query attribute table is used for storing data query parameters of data corresponding to a service function, the service query attribute table at least includes query codes, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service function, and the service table attribute table at least includes attribute codes.
Optionally, in this embodiment of the application, the step 202 may further include: the table display device generates a configuration request link of a business function; and the table display device acquires a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code according to the configuration request link.
In the embodiment of the application, the configuration request link carries the query code and the attribute code, and the configuration request link may further include a database address, a file path, a query user right, and the like.
In this embodiment of the present application, the service query attribute table is used to record relevant data of the service function, and includes: query encoding, query table name, leaf node, directory node, parent node, query statement, literal definition of data source, query order, and the like.
In this embodiment of the present application, the service form attribute table is used to record form attribute related data of the data presentation form, and includes: attribute coding, data fields, header words, column names corresponding to the header words, column widths, editing display types, list names to which enumerated fields belong, column names to which the enumerated fields belong and display sequences.
Optionally, as shown in fig. 3, in the embodiment of the present application, in step 203, a blank display table corresponding to a service function is generated according to a display attribute parameter in a service table attribute table, which may specifically include steps 301 to 303.
And step 303, generating a blank display form corresponding to the service function by the form display device according to the header attribute parameter and the style attribute parameter.
In the embodiment of the application, the header attribute parameter is used for generating a header of the blank display table, and the style attribute parameter is used for generating a style of the blank display table. Both the form attribute parameter and the style attribute parameter belong to the presentation attribute parameter.
In the embodiment of the present application, the header attribute parameters include the row number of the blank display table, the row header of each row header, the display order and the column number of each row header, the column header of each column header, and the display order of each column header.
In the embodiment of the present application, the style attribute parameters include a row or a column of the blank presentation table, whether to display, a width, a height, a data format, an editable type, and the like.
In the embodiment of the application, a blank display table with a specific row and column number, a specific header and a specific table style is generated according to the header attribute parameter and the style attribute parameter. It is to be understood that if the style attribute parameters include filterable or not, grouped or not, counted or not, summed or not, and averaged or not, then generating the blank presentation table format requires editing formulas according to the counted, summed or averaged objects, and recording the editing formulas in the counted, summed or averaged columns.
It should be noted that the blank display form is a form corresponding to a service function, and the obtained header attribute parameter and the style attribute parameter are different for different service functions, although the method for generating the display form is the same, the generated blank display form is different.
Therefore, through the difference between the header attribute parameters and the style attribute parameters corresponding to different service functions, the blank display table corresponding to the service functions is generated, codes do not need to be rewritten, and only corresponding replacement is needed, so that the response speed of the data display table is increased.
And step 204, the table display device searches the service data corresponding to the service function according to the data query parameters in the service query attribute table.
In this embodiment of the present application, the service query attribute table is used to record relevant data (i.e. data query parameters) of the service function, and includes: query encoding, query table name, leaf node, directory node, parent node, query statement, literal definition of data source, query order, and the like.
Optionally, in this embodiment of the application, the table displaying apparatus searches for corresponding service data according to a header in the blank display table, but since the header further includes indirect service data such as a count value, a sum value, an average value, and the like, and cannot be obtained through searching, an invalid search may exist in a process of searching according to the header.
In the embodiment of the application, the table display device searches the service data corresponding to the service function according to the data query parameter in the service query attribute table, so that the corresponding data can be searched every time, the searching efficiency can be improved, and the response speed of displaying the data display table is further improved.
In the embodiment of the present application, the table display apparatus searches for the business data through the query statement in the data query parameter, and the query statement may be, for example, an SQL statement.
In the embodiment of the application, the business data is mapped to the corresponding column of the blank display table through the field name or the word definition, and the blank display table is subjected to data filling to generate the data display table.
And step 206, rendering and displaying the data display table by the table display device.
In the embodiment of the application, the generated data display table is rendered and displayed.
In the form display method disclosed by the application, a query code and an attribute code corresponding to a service function are acquired by responding to a first input of a user; acquiring a service query attribute table corresponding to a query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to service functions and at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service functions and at least comprises the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; mapping the service data to a corresponding column of a blank display table to generate a data display table corresponding to the service function; and rendering and displaying the data display table. Therefore, the blank display table and the service query attribute table corresponding to the service function can be obtained through the query code and the attribute code, so that different service functions can be flexibly configured, the development amount of the data display table is reduced, and the response speed of displaying the data display table can be improved.
Optionally, as shown in fig. 4, in the embodiment of the present application, before the query code and the attribute code corresponding to the service function are obtained in step 201, the table display method provided in the embodiment of the present application may further include step 401 and step 402.
In an embodiment of the present application, the data query parameter in the blank query attribute table includes at least one of the following: query encoding, query table name, leaf node, directory node, parent node, query statement, literal definition of data source, and query order.
It should be noted that the data query parameters in the blank query attribute table include all possible parameters, so that when the blank query attribute table is configured, all data corresponding to the service function can be configured in the corresponding service query attribute table.
In the embodiment of the present application, the service query attribute table includes a data query parameter of each functional field in at least one functional field corresponding to the service function. For each functional field, the corresponding blank look-up data table is the same. Namely, the service query attribute table is obtained by configuring blank query data corresponding to each functional field in at least one functional field.
In the embodiment of the present application, as shown in table 1, in the service query attribute table, for a partial table of any function field, the data type and length of the corresponding data query parameter may also be defined according to the name of the data source or the literal definition of the data source.
Table 1 service query attribute table
| Name of data source | Text definitions of data sources | Data type | Length of | |
| queryid | Query encoding | char | 20 | |
| queryname | Look-up of table names | VERchar | 100 | |
| parentid | Father node | char | 9 | |
| querysql | Query statement | VERchar | 20480 | |
| showorder | | INT | 11 |
In an embodiment of the present application, the display attribute parameters of the blank form attribute table include at least one of the following: attribute coding, data fields, header words, column names corresponding to the header words, column width, whether to display, whether to browse, whether to filter, whether to search fields, group names, whether to allow editing, display type editing, enumeration source, list names to which the enumeration fields belong, editing time, whether to be an enumeration column, whether to be a summation column, whether to be an averaging value column, and display sequence.
In this embodiment of the present application, the display attribute parameter includes a display attribute parameter of each functional field in at least one functional field corresponding to the service function. For each function field, the corresponding blank table attribute table is the same. Namely, the service form attribute table is obtained by configuring a blank form attribute table corresponding to each function field in at least one function field.
In the embodiment of the present application, as shown in table 2, in the attribute table of the service table, for a partial table of any function field, the data type and the length of the corresponding attribute parameter to be displayed may also be defined according to the data field or the literal definition corresponding to the data field.
Table 2 service table attribute table
| Data field | Character paraphrase | Data type | Length of | |
| queryid | Attribute coding | char | 50 | |
| colname | List name corresponding to head character | char | 50 | |
| colwidth | Width of | INT | 11 | |
| visible | Whether or not to display | char | 1 | |
| brower | Whether to browse | char | 1 | |
| ordindex | | INT | 11 |
It should be noted that the blank query attribute table includes data query parameters that may be used by all service functions, and the blank query attribute table includes presentation attribute parameters that may be used by all service functions, so that when the blank table is configured, service data corresponding to the service functions are not omitted.
Therefore, the service query attribute table and the service table attribute table are configured in advance, so that when the data display table corresponding to the service function is displayed, the corresponding service data and the table style can be directly called, and the response time of displaying the data display table is prolonged.
Further optionally, in this embodiment of the application, the data query parameter in the blank query attribute table may further include a permitted operation type, and the permitted operation type includes at least one of the following: add, configure, delete, save, and export. The step 203 may include: the form presentation apparatus reconfigures the service query attribute table in response to a second input by the user.
In this embodiment of the application, the operation type corresponding to the second input belongs to an allowable operation type, and the second input may add, configure, delete, store, or export data in a certain row or a certain column, which results in a change of the configured service query attribute table, so that the service query attribute table may be reconfigured according to the second data.
It is understood that the second input may be input via an input device such as a keyboard, mouse, screen, etc., or may be input via transmission means such as infrared, bluetooth, wireless network, etc.
Therefore, the service query attribute table is modified for the second time through the second input, so that the service query attribute table is more in line with the user requirements.
Optionally, as shown in fig. 5, in the embodiment of the present application, before the query code and the attribute code corresponding to the service function are obtained in response to the first input of the user in step 201, the table display method provided in the embodiment of the present application may include step 501 and step 502.
In this embodiment of the present application, the enumeration attribute parameters in the enumeration conversion table include a table name to which the enumeration field belongs, a list name to which the enumeration field belongs, a word definition of the enumeration field, and an enumeration value of the enumeration field.
In the embodiment of the present application, for data of an enumeration type, simple numerical values such as 0, 1, and 2 are usually expressed, however, such numerical values are not easy for a user to understand, and therefore, it is necessary to store a correspondence relationship between a literal definition of an enumeration field in the data of an enumeration type and an enumeration value of the enumeration field.
Illustratively, the enumerated field has a literal interpretation of "male", the enumerated field has an enumerated value of "1", the enumerated field has a literal interpretation of "female", and the enumerated field has an enumerated value of "0".
In the embodiment of the application, the corresponding relationship is recorded by creating a blank enumeration table and then configuring a service enumeration conversion table according to the service function, so that the text paraphrase of an enumerated field can be conveniently displayed in a data display table.
Therefore, the corresponding relation between the word definitions and the enumerated values of all the enumerated fields in each service function is recorded through the service enumeration conversion table, so that the enumerated fields in each service function can be accurately recorded, and the error probability of the data display table is reduced.
Further optionally, as shown in fig. 6, in the embodiment of the present application, on the basis of step 501 and step 502 shown in fig. 5, step 206 specifically further includes step 601 and step 602.
In the embodiment of the application, in order to balance the data reading speed and the network transmission speed, the service enumeration conversion table is converted into an enumeration js file in a json object format, so that the response speed of the display data display table is improved.
In this way, the literal definitions of the enumerated fields are presented in the data presentation table to improve the user's understanding of the meaning of the enumerated fields in the data presentation table.
In summary, in the embodiment of the present application, in order to implement displaying a data display table, the data display table is roughly divided into creating a blank intermediary data table (including a blank query attribute table, a blank table attribute table, and a blank enumeration conversion table), configuring the blank intermediary data table according to a specific service function, finally generating the data display table according to the configured intermediary data table, and rendering and displaying the data display table.
The above description has presented the embodiments of the present application primarily from a method perspective. It is to be understood that the table showing apparatus includes at least one of a hardware structure and a software module corresponding to each function in order to implement the above-described functions. Those of skill in the art would readily appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as hardware or combinations of hardware and computer software. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiment of the present application, the table display apparatus may be divided into the functional units according to the method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. It should be noted that the division of the unit in the embodiment of the present application is schematic, and is only a logic function division, and there may be another division manner in actual implementation.
As shown in fig. 7, an embodiment of the present application provides a table display apparatus. The table display device includes: the device comprises an acquisition unit 71, a generation unit 72, a search unit 73 and a display unit 74;
an obtaining unit 71, configured to obtain, in response to a first input of a user, a query code and an attribute code corresponding to a service function;
the obtaining unit 71 is further configured to obtain a service query attribute table corresponding to the query code obtained by the obtaining unit 71, and a service form attribute table corresponding to the attribute code obtained by the obtaining unit 71, where the service query attribute table is used to store data query parameters of data corresponding to a service function, the service query attribute table at least includes the query code, the service form attribute table is used to store display attribute parameters of a form corresponding to the service function, and the service form attribute table at least includes the attribute code;
a generating unit 72, configured to generate a blank display form corresponding to the service function according to the display attribute parameter in the service form attribute table acquired by the acquiring unit 71;
the searching unit 73 is configured to search service data corresponding to the service function according to the data query parameter in the service query attribute table acquired by the acquiring unit 71;
the generating unit 72 is further configured to map the service data searched by the searching unit 73 to a corresponding column in the blank display table generated by the generating unit 72, and generate a data display table corresponding to the service function;
and the presentation unit 74 is used for rendering and presenting the data presentation table generated by the generation unit 72.
Optionally, the obtaining unit 71 is specifically configured to:
generating a configuration request link of a service function, wherein the configuration request link carries an inquiry code and an attribute code;
and according to the configuration request link, acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code.
Optionally, the apparatus further comprises: a creation unit 75 and a configuration unit 76;
a creating unit 75, configured to create a blank query attribute table and create a blank table attribute table before the obtaining unit 71 obtains the query code and the attribute code corresponding to the service function in response to the first input of the user;
a configuration unit 76, configured to configure the blank query attribute table created by the creating unit 75 according to the service function, to generate a service query attribute table, and configure the blank table attribute table created by the creating unit 75 according to the service function, to generate a service table attribute table;
wherein, the data query parameters in the blank query attribute table comprise at least one of the following items: query codes, query table names, leaf nodes, directory nodes, father nodes, query statements, character definitions of data sources and query sequences; the display attribute parameters of the blank form attribute table comprise at least one of the following items: attribute coding, data fields, header words, column names corresponding to the header words, column width, whether to display, whether to browse, whether to filter, whether to search fields, group names, whether to allow editing, display type editing, enumeration source, list names to which the enumeration fields belong, editing time, whether to be an enumeration column, whether to be a summation column, whether to be an averaging value column, and display sequence.
Optionally, the generating unit 72 is specifically configured to:
acquiring a header attribute parameter in the display attribute parameters;
acquiring a style attribute parameter in the display attribute parameters;
and generating a blank display table corresponding to the service function according to the header attribute parameter and the style attribute parameter.
Optionally, the apparatus further comprises:
the creating unit 75 is further configured to, in response to a first input of a user, create a blank enumeration conversion table before the obtaining unit 71 obtains the query code and the attribute code corresponding to the service function;
a configuration unit 76, configured to configure the blank enumeration conversion table created by the creation unit 75 according to the service function, and generate a service enumeration conversion table;
the enumeration attribute parameters in the enumeration conversion table comprise table names to which enumeration fields belong, column names to which enumeration fields belong, word definitions of the enumeration fields and enumeration values of the enumeration fields.
Optionally, the display unit 74 is specifically configured to:
under the condition that the display attribute parameters comprise enumeration fields, acquiring a service enumeration conversion table corresponding to a service function;
and performing data conversion on enumeration data corresponding to the enumeration fields in the data display table according to the service enumeration conversion table, rendering and displaying the data display table.
Optionally, the data query parameter in the blank query attribute table includes a permitted operation type, and the permitted operation type includes at least one of the following: add, configure, delete, save, and export;
the search unit 73 is further configured to:
and responding to a second input of the user, and reconfiguring the service query attribute table, wherein the operation type corresponding to the second input belongs to the allowed operation type.
In the form display device provided by the embodiment of the application, the query code and the attribute code corresponding to the service function are acquired by responding to the first input of a user; acquiring a service query attribute table corresponding to a query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to service functions and at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service functions and at least comprises the attribute code; generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table; searching service data corresponding to the service function according to the data query parameters in the service query attribute table; mapping the service data to a corresponding column of a blank display table to generate a data display table corresponding to the service function; and rendering and displaying the data display table. Therefore, the blank display table and the service query attribute table corresponding to the service function can be obtained through the query code and the attribute code, so that different service functions can be flexibly configured, the development amount of the data display table is reduced, and the response speed of displaying the data display table can be improved.
The embodiment of the present application further provides a readable storage medium, where a program or an instruction is stored on the readable storage medium, and when the program or the instruction is executed by a processor, the program or the instruction implements each step in the table display method flow shown in the above method embodiment.
The readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable computer diskette, and a hard disk. Random Access Memory (RAM), Read-Only Memory (ROM), Erasable Programmable Read-Only Memory (EPROM), registers, a hard disk, an optical fiber, a portable Compact disk Read-Only Memory (CD-ROM), an optical storage device, a magnetic storage device, or any other form of readable storage medium, in any suitable combination, or as appropriate in the art. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be integral to the processor. The processor and the storage medium may reside in an Application Specific Integrated Circuit (ASIC). In the embodiments of this application, a 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.
Embodiments of the present application provide a computer program product stored in a non-volatile storage medium, which is executed by at least one processor to implement the steps in the table display method flow shown in the above method embodiments.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented using a software program, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. The procedures or functions described in accordance with the embodiments of the present application are all or partially generated upon loading and execution of computer program instructions on a computer. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on a readable storage medium or transmitted from one readable storage medium to another readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center via wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The readable storage medium may be any available medium that can be accessed by a computer or a data storage device including one or more available media integrated servers, data centers, and the like. The usable medium may be a magnetic medium (e.g., a floppy Disk, a hard Disk, a magnetic tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a Solid State Disk (SSD)), etc.
Fig. 8 shows a schematic diagram of another possible structure of the electronic device according to the above embodiment. The electronic device includes: a memory 81, a processor 82, and a program or instructions stored on the memory 81 and executable on the processor 82, which when executed by the processor 82, implement the steps in the table display method flow shown in the above-described method embodiments. The electronic device may further comprise a communication interface 83 and a bus 84, the communication interface 83 being adapted to support communication of the electronic device with other network entities.
The processor 82 may also implement or execute various illustrative logical blocks, units and circuits described in connection with the disclosure herein. The processor 82 may be a central processing unit, general purpose processor, digital signal processor, application specific integrated circuit, field programmable gate array or other programmable logic device, transistor logic device, hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, units, and circuits described in connection with the disclosure. The processor described above may also be a combination of computing functions, e.g., comprising one or more microprocessors, DSPs and microprocessors, and the like.
The bus 84 may be an Extended Industry Standard Architecture (EISA) bus or the like. The bus 84 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown in FIG. 8, but this is not intended to represent only one bus or type of bus.
It is clear to those skilled in the art from the foregoing description of the embodiments that, for convenience and simplicity of description, the foregoing division of the functional units is merely used as an example, and in practical applications, the above function distribution may be performed by different functional units according to needs, that is, the internal structure of the device may be divided into different functional units to perform all or part of the above described functions. For the specific working processes of the system, the apparatus and the unit described above, reference may be made to the corresponding processes in the foregoing method embodiments, and details are not described here again.
Since the electronic device, the readable storage medium, and the computer program product in the embodiments of the present application may be applied to the table display method, so that the technical effects obtained by the method may also refer to the embodiments of the method, which are not described herein again.
The above units may be individually configured processors, or may be implemented by being integrated into one of the processors of the controller, or may be stored in a memory of the controller in the form of program codes, and the functions of the above units may be called and executed by one of the processors of the controller. The processor described herein may be a Central Processing Unit (CPU), or an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits configured to implement embodiments of the present Application.
It should be understood that, in the various embodiments of the present application, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus, and method may be implemented in other ways. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed coupling, direct coupling or communication connection between each other may be realized through an interface, and the interface connection may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A method for displaying a form, comprising:
responding to a first input of a user, and acquiring a query code and an attribute code corresponding to a service function;
acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code, wherein the service query attribute table is used for storing data query parameters of data corresponding to the service function, the service query attribute table at least comprises the query code, the service table attribute table is used for storing display attribute parameters of a table corresponding to the service function, and the service table attribute table at least comprises the attribute code;
generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table;
searching the service data corresponding to the service function according to the data query parameters in the service query attribute table;
mapping the service data to a corresponding column of the blank display table to generate a data display table corresponding to the service function;
and rendering and displaying the data display table.
2. The method of claim 1, wherein obtaining the service query attribute table corresponding to the query code and the service table attribute table corresponding to the attribute code comprises:
generating a configuration request link of the service function, wherein the configuration request link carries the query code and the attribute code;
and acquiring a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code according to the configuration request link.
3. The method of claim 1, wherein before the obtaining of the query code and the attribute code corresponding to the service function in response to the first input of the user, the method further comprises:
creating a blank query attribute table and creating a blank table attribute table;
configuring the blank query attribute table according to the service function, generating the service query attribute table, and,
configuring the blank table attribute table according to the service function to generate the service table attribute table;
wherein the data query parameters in the blank query attribute table include at least one of: the query code, the name of the query table, the leaf node, the directory node, the father node, the query statement, the character paraphrase of the data source and the query sequence; the display attribute parameters of the blank table attribute table comprise at least one of the following items: the attribute codes, data fields, header words, column names corresponding to the header words, column width, whether to display, whether to browse, whether to filter, whether to search fields, group names, whether to allow editing, display type editing, enumeration source, table names to which the enumeration fields belong, column names to which the enumeration fields belong, editing time, whether to be counting columns, whether to be summing columns, whether to be averaging value columns and display sequence.
4. The method according to claim 3, wherein the generating a blank display form corresponding to the service function according to the display attribute parameter in the service form attribute table comprises:
acquiring a header attribute parameter in the display attribute parameters;
acquiring style attribute parameters in the display attribute parameters;
and generating a blank display table corresponding to the business function according to the header attribute parameters and the style attribute parameters.
5. The method of claim 1, wherein before the obtaining of the query code and the attribute code corresponding to the service function in response to the first input of the user, the method further comprises:
creating a blank enumeration conversion table;
configuring the blank enumeration conversion table according to the service function to generate a service enumeration conversion table;
the enumeration attribute parameters in the enumeration conversion table comprise table names to which enumeration fields belong, list names to which enumeration fields belong, word definitions of the enumeration fields and enumeration values of the enumeration fields.
6. The method of claim 5, wherein rendering and presenting the data presentation table comprises:
under the condition that the display attribute parameters comprise enumeration fields, acquiring a service enumeration conversion table corresponding to the service function;
and performing data conversion on enumeration data corresponding to enumeration fields in the data display table according to the service enumeration conversion table, and rendering and displaying the data display table.
7. The method of claim 1, wherein the data query parameters in the blank query attribute table include a permitted operation type, and wherein the permitted operation type comprises at least one of: add, configure, delete, save, and export;
the searching the service data corresponding to the service function according to the data query parameter in the service query attribute table includes:
and responding to a second input of the user, and reconfiguring the service query attribute table, wherein an operation type corresponding to the second input belongs to the allowable operation type.
8. A form display apparatus, comprising: the device comprises an acquisition unit, a generation unit, a search unit and a display unit;
the acquiring unit is used for responding to a first input of a user and acquiring a query code and an attribute code corresponding to a service function;
the obtaining unit is further configured to obtain a service query attribute table corresponding to the query code and a service table attribute table corresponding to the attribute code, where the service query attribute table is used to store data query parameters of data corresponding to the service function, the service query attribute table at least includes the query code, the service table attribute table is used to store display attribute parameters of a table corresponding to the service function, and the service table attribute table at least includes the attribute code;
the generating unit is used for generating a blank display form corresponding to the business function according to the display attribute parameters in the business form attribute table;
the searching unit is used for searching the service data corresponding to the service function according to the data query parameter in the service query attribute table;
the generating unit is further configured to map the service data to a corresponding column in the blank display table, and generate a data display table corresponding to the service function;
and the display unit is used for rendering and displaying the data display table.
9. A readable storage medium, on which a program or instructions are stored, which when executed by a processor, implement the table presentation method of any one of claims 1-7.
10. An electronic device, comprising: a processor, a memory and a program or instructions stored on the memory and executable on the processor, the program or instructions when executed by the processor implementing the table presentation method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111314065.XA CN114065067A (en) | 2021-11-08 | 2021-11-08 | Table display method and device, readable storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111314065.XA CN114065067A (en) | 2021-11-08 | 2021-11-08 | Table display method and device, readable storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114065067A true CN114065067A (en) | 2022-02-18 |
Family
ID=80274264
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111314065.XA Pending CN114065067A (en) | 2021-11-08 | 2021-11-08 | Table display method and device, readable storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114065067A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117574867A (en) * | 2023-12-08 | 2024-02-20 | 北京天圣华信息技术有限责任公司 | Statistical table generation method, device, equipment and storage medium |
-
2021
- 2021-11-08 CN CN202111314065.XA patent/CN114065067A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117574867A (en) * | 2023-12-08 | 2024-02-20 | 北京天圣华信息技术有限责任公司 | Statistical table generation method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112036736A (en) | Workflow creating method and device | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| WO2018219285A1 (en) | Data object display method and device | |
| CN105094707A (en) | Method and device for storing and reading data | |
| CN108932286B (en) | Data query method and device | |
| CN111078689B (en) | Data processing method and system of discontinuous pre-ordering traversal tree algorithm | |
| CN115544183B (en) | Data visualization method, device, computer equipment and storage medium | |
| US20170199912A1 (en) | Behavior topic grids | |
| CN114065067A (en) | Table display method and device, readable storage medium and electronic equipment | |
| CN114444478A (en) | Voucher visualization method and device, electronic equipment and storage medium | |
| CN111124883B (en) | Test case library introduction method, system and equipment based on tree form | |
| CN111008198B (en) | Service data acquisition method and device, storage medium and electronic equipment | |
| CN117170655A (en) | Metadata processing method and device, data processing equipment and storage medium | |
| JP2018112919A (en) | Test input information retrieval apparatus and method | |
| CN115629763A (en) | Target code generation method and NPU instruction display method and device | |
| CN114625372A (en) | Automatic component compiling method and device, computer equipment and storage medium | |
| CN114860362A (en) | Interface updating method and device | |
| CN110674224B (en) | Entity data processing method, device and equipment and computer readable storage medium | |
| US20140317154A1 (en) | Heterogeneous data management methodology and system | |
| WO2024016789A1 (en) | Log data query method and apparatus, and device and medium | |
| CN114553954B (en) | Information pushing method, nonvolatile storage medium and electronic equipment | |
| CN116701545A (en) | Audit data analysis method, audit data analysis device, storage medium and audit data processor | |
| CN114896286A (en) | Data resource query method and device | |
| CN116483475A (en) | Configuration method and device of data conversion information, electronic equipment and storage medium | |
| CN117390060A (en) | Batch data unloading processing method and device, electronic equipment and readable storage medium |
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 |