CN112749215A - Data display method and related equipment - Google Patents
Data display method and related equipment Download PDFInfo
- Publication number
- CN112749215A CN112749215A CN202011631118.6A CN202011631118A CN112749215A CN 112749215 A CN112749215 A CN 112749215A CN 202011631118 A CN202011631118 A CN 202011631118A CN 112749215 A CN112749215 A CN 112749215A
- Authority
- CN
- China
- Prior art keywords
- data
- party system
- display
- data source
- rule
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—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/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/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Information Transfer Between Computers (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a data display method and related equipment, which can save labor cost, time cost and development fund and improve the utilization rate of data. The method comprises the following steps: setting a data source displaying rule according to a data providing mode of third-party system data; receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule; acquiring the third-party system data according to the target data source rule; and displaying the third-party system data according to a display mode rule.
Description
Technical Field
The present invention relates to the field of communications, and in particular, to a data display method and related device.
Background
In modern enterprises, there are a variety of computer business systems that maintain various business data.
However, since the service data is stored in the computer service system, the service data can only be used by itself and cannot be communicated with an external system, so that other computer service systems cannot use the existing service data, and an information island problem is formed.
If other computer business systems have corresponding business functions, business data can be input again, so that data are repeatedly input, and the problems of data redundancy and poor input efficiency are caused.
If other computer business systems do not have corresponding business functions, but must use third-party system data, the problems of long development period, large capital investment and the like are caused because the problems can be solved only by secondary development.
In summary, how to automatically display third-party system data, that is, according to configuration, without secondary development, third-party system data can be displayed in a workflow form or a portal, and a page for displaying the third-party system data is generated, so that labor cost, time cost and development fund are saved, and the utilization rate of data is improved, which is a problem to be solved urgently at present.
Disclosure of Invention
The invention provides a data display method and related equipment, which can save labor cost, time cost and development fund and improve the utilization rate of data.
A first aspect of an embodiment of the present invention provides a data display method, including:
setting a data source displaying rule according to a data providing mode of third-party system data;
receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
acquiring the third-party system data according to the target data source rule;
and displaying the third-party system data according to a display mode rule.
Optionally, the method further comprises:
receiving a second operation instruction of a user, wherein the second operation instruction is an operation of setting a display field;
and providing a list page, and displaying the third-party system data on the list page according to the display field.
Optionally, the method further comprises:
generating a query interface corresponding to the third-party system data according to the set query field;
and receiving the query condition of the user on the query interface, and returning display data corresponding to the query condition.
Optionally, the displaying the third-party system data according to the display mode rule includes:
displaying the third-party system data in a form of a custom browsing frame;
and/or the presence of a gas in the gas,
displaying the third party number in an external data element form;
and/or the presence of a gas in the gas,
and displaying the third-party system data in the form of an external data page.
Optionally, the data source display rule includes:
the method comprises the steps of obtaining a data source mode of display data by using a Structured Query Language (SQL) statement, obtaining a data source mode of the display data by using a storage process, obtaining a data source mode of the display data by calling a data query method from a Web Service interface of a specified third-party system, obtaining a data source mode of the display data from a specified HTTP address and/or obtaining a data source mode of the display data from an ESB Service of a specified enterprise server bus, wherein the SQL statement corresponds to the third-party system data, the storage process corresponds to the third-party system data, the Web Service interface corresponds to the third-party system data, the specified HTTP address corresponds to a third-party system data item, and the specified ESB Service corresponds to the third-party system data.
A second aspect of the embodiments of the present invention provides a data display apparatus, including:
the setting unit is used for setting a display data source rule according to a data providing mode of the third-party system data;
a receiving unit, configured to receive a first operation instruction of a user, where the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
the acquisition unit is used for acquiring the third-party system data according to the target data source rule;
and the display unit is used for displaying the third-party system data according to the display mode rule.
Optionally, the receiving unit is further configured to receive a second operation instruction of the user, where the second operation instruction is an operation of setting a presentation field;
the display unit is further used for providing a list page and displaying the third-party system data on the list page according to the display field.
Optionally, the apparatus further comprises:
the generating unit is used for generating a query interface corresponding to the third-party system data according to the set query field;
and the query unit is used for receiving the query conditions of the user on the query interface and returning the display data corresponding to the query conditions.
Optionally, the displaying, by the display unit, the third-party system data according to a display mode rule includes:
displaying the third-party system data in a form of a custom browsing frame;
and/or the presence of a gas in the gas,
displaying the third party number in an external data element form;
and/or the presence of a gas in the gas,
and displaying the third-party system data in the form of an external data page.
Optionally, the data source display rule includes:
the method comprises the steps of obtaining a data source mode of display data by using a Structured Query Language (SQL) statement, obtaining a data source mode of the display data by using a storage process, obtaining a data source mode of the display data by calling a data query method from a Web Service interface of a specified third-party system, obtaining a data source mode of the display data from a specified HTTP address and/or obtaining a data source mode of the display data from an ESB Service of a specified enterprise server bus, wherein the SQL statement corresponds to the third-party system data, the storage process corresponds to the third-party system data, the Web Service interface corresponds to the third-party system data, the specified HTTP address corresponds to a third-party system data item, and the specified ESB Service corresponds to the third-party system data.
A third aspect of the present invention provides a computer apparatus comprising: at least one connected processor, memory, and transceiver; the memory is used for storing program codes, which are loaded and executed by the processor to implement the steps of the data presentation method of the first aspect.
A fourth aspect of the present invention provides a computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the steps of the data presentation method of the first aspect.
In summary, it can be seen that, in the embodiment provided by the present invention, the data display device can set the display mode rule to satisfy the requirement of displaying the third-party system data in the workflow, the portal, and the menu page; the display data source rule can be set, and the data acquisition path of the third-party system can be flexibly configured; the display field can be set to meet the requirement that the display data column can be configured by self-definition, and a display data list is dynamically generated according to configuration; the query field can be set to meet the requirement of dynamically setting secondary query conditions, so that the effects of saving labor cost, time cost and development fund and improving the utilization rate of data are achieved.
Drawings
Fig. 1 is a schematic flow chart of a data display method according to an embodiment of the present invention;
FIG. 2 is a schematic view of a virtual structure of a data display apparatus according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a hardware structure of a data display apparatus according to an embodiment of the present invention;
fig. 4 is a schematic diagram of an embodiment of an electronic device according to an embodiment of the present invention;
fig. 5 is a schematic diagram of an embodiment of a computer-readable storage medium according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.
The terms "first," "second," and the like in the description and in the claims, and in the drawings described above, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprise" and "have," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules expressly listed, but may include other steps or modules not expressly listed or inherent to such process, method, article, or apparatus, wherein the division into blocks presented herein is merely a logical division and may be implemented in a practical application in a different manner, such that multiple blocks may be combined or integrated into another system or some feature vectors may be omitted or not implemented, and such that mutual or direct coupling or communicative coupling between blocks shown or discussed may be through interfaces, and indirect coupling or communicative coupling between blocks may be electrical or other similar, the present invention is not limited to these examples. The modules or sub-modules described as separate parts may or may not be physically separated, may or may not be physical modules, or may be distributed in a plurality of circuit modules, and some or all of the modules may be selected according to actual needs to achieve the purpose of the present invention.
The method of the present invention is described below from the perspective of a data display device, which may be a server or a service unit in the server, and is not particularly limited.
Referring to fig. 1, fig. 1 is a schematic flow chart of a data display method according to an embodiment of the present invention, including:
101. and setting a data source displaying rule according to a data providing mode of the third-party system data.
In this embodiment, the data display apparatus may set the display data source rule according to the data providing mode of the third-party system data. Wherein, the display data source rule comprises:
a data source mode of acquiring display data by using a Structured Query Language (SQL) statement, a data source mode of acquiring display data by using a storage process, a data source mode of acquiring display data by calling a Query data method from a Web Service interface of a specified third-party system, a data source mode of acquiring display data from a specified HTTP address and/or a data source mode of acquiring display data from a specified Enterprise Server Bus (ESB) Service, wherein the SQL statement corresponds to the third party system data, the stored procedure corresponds to the third party system data, the Web Service interface corresponds to the third-party system data, the designated HTTP address corresponds to the third-party system data item, and the designated ESB Service corresponds to the third-party system data. The following describes the data providing method and data source rule of the third-party system data:
when the data providing mode of the third-party system data is a database, a data source mode of acquiring display data by using SQL sentences in a specified third-party system data source is provided; the method comprises the steps of setting an external data source to obtain data source connection, configuring query SQL to obtain all display data, and configuring playback SQL to realize specified data playback, wherein the third-party system corresponds to third-party system data, namely the third-party system data is stored in the third-party system.
When the data providing mode of the third-party system data is a storage process, a data source mode of acquiring display data by using the storage process in a specified third-party system data source is provided; setting an external data source to obtain data source connection, configuring and calling a storage process to obtain all display data, and configuring the echo SQL to realize the echo of the specified data. The storage process requires the ability to query the data and return a data query result set.
When the data providing mode of the third-party system data is Web Service, a data source mode for calling a data query method in a specified third-party system Web Service interface to acquire display data is provided; and setting a Web Service interface of a third-party system, configuring a data query method to acquire all display data, and configuring a data playback method to realize the playback of the specified data. The Web Service interface returns the Extensible Markup Language (XML) data in a specified form to be analyzed and displayed.
When the data providing mode of the third-party system data is a self-defined address, a data source mode for obtaining display data from a specified HTTP address is provided; the data source mode can support the HTTP address of a third party and the HTTP address of the secondary development of the current system, and the XML data in the specified form can be analyzed and displayed as long as the HTTP address returns.
When the data providing mode of the third-party system data is ESB service, a data source mode for obtaining display data from the appointed ESB service is provided; in the data source mode, the ESB query service and the ESB echoing service registered in the ESB service by the user realize related data query so as to achieve the purpose of data display. The ESB Service can support a database, a Web Service interface, an REST interface and a user-defined interface, realize support of interface types of each third-party system in a larger range, and better support of the capability of automatically showing the data of the third-party system. The data format returned by the integrated ESB service can support XML and JS Object Notation (JavaScript Object Notification, JSON) and other standardized data formats, and has small data format constraint and stronger expansion capability.
102. Receiving a first operation instruction of a user.
In this embodiment, the data presentation apparatus may receive a first operation instruction of the user after setting the presentation data source rule, where the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the presentation data source rule, that is, the data presentation apparatus selects the target data source rule from the presentation data source rule according to the first operation instruction of the user. The manner of generating the first operation instruction is not particularly limited here, and the first operation instruction may be operated by, for example, clicking, double clicking, voice controlling, or customizing a key.
103. And acquiring the third-party system data according to the target data source rule.
In this embodiment, after the data display apparatus selects the target data source rule according to the first operation instruction of the user, the data display apparatus may obtain the third-party system data according to the target data source rule. If the target data source rule is one or more of a data source mode of acquiring display data by using a Structured Query Language (SQL) statement, a data source mode of acquiring display data by using a storage process, a data source mode of acquiring display data by calling a data query method from a Web Service interface of a specified third-party system, a data source mode of acquiring display data from a specified HTTP address and a data source mode of acquiring display data from a specified Enterprise Server Bus (ESB) Service, the following specific description is given:
when the target data source rule is a data source mode of acquiring the display data by using a Structured Query Language (SQL) statement, selecting an external data source, preparing database connection of query data, configuring the query SQL, and querying to acquire all the display data. And when the target data source rule is a data source mode of acquiring display data by using a Structured Query Language (SQL) statement and performing playback operation on the third-party system data, configuring playback SQL and inquiring the acquired playback display data. And the query result is a database result set and is displayed in the page after being analyzed.
And when the target data source rule is a data source mode for acquiring the display data by using the storage process, selecting an external data source, and preparing for database connection of query data. And configuring a storage process, and inquiring and acquiring all display data. When the target data source rule is a data source mode for acquiring the display data by using the storage process and performing the playback operation on the third-party system data, the playback SQL is configured, the display data which is played back is inquired and acquired, the inquiry result is a database result set, and the inquiry result is displayed in the page after being analyzed.
And when the target data source rule is a data source mode for calling a data query method from a Web Service interface of a specified third-party system to acquire display data, the Web Service interface of the specified third-party system is configured with the data query method, and all the display data are queried and acquired. The target data source rule is a data source mode for calling a data query method from a Web Service interface of a specified third-party system to acquire display data, and when a data playback data operation is executed on the third-party system data, a data playback method is configured to query and acquire the display data which is played back. And returning a result in an XML format, and displaying the result in a page after analysis.
When the target data source rule is a data source mode of acquiring display data from the designated HTTP address, the designated HTTP address can be a third-party HTTP address or an HTTP address developed by the current system for the second time, a returned result is in an XML format, and the XML format is displayed in a page after being analyzed.
When the target data source rule is a data source manner for obtaining display data from a designated enterprise server bus ESB service, the ESB service is designated, and the registered ESB service may be adapted to: the system comprises a database connection, a Web Service interface, a REST interface and a user-defined interface. And configuring an ESB query service, and querying and acquiring all display data. And configuring an ESB echoing service, and inquiring and acquiring the echoed display data. The returned result may be: XML format, JSON format or other data format (which can define the data analysis class) is displayed in the page after being analyzed.
104. And displaying the third-party system data according to the display mode rule.
In this embodiment, after the data display device acquires the third-party system data, the data display device may display the third-party system data according to the display mode rule, specifically, the data display device may display the third-party system data in a following manner:
displaying the third-party system data in a form of a custom browsing frame;
and/or the presence of a gas in the gas,
displaying the third party number in an external data element form;
and/or the presence of a gas in the gas,
and displaying the third-party system data in the form of an external data page.
That is, the data presentation device provides three different ways to present third party system data: the user-defined browsing frame, the external data elements and the external data page are respectively explained as follows:
customizing a browsing frame: the rule is suitable for a user-defined browsing frame of the workflow form field, and can display and query third-party system data in the specified workflow form field in a browsing frame mode, so that the data source of the workflow form field is richer, and the workload of secondary development is reduced.
External data elements: the rule is suitable for displaying and inquiring third-party system data in a portal, so that the source of portal data is richer, and the workload of secondary development is reduced.
External data page: the link of the data display page can be automatically generated by using the rule, the link can be configured into a system menu, and the third-party system data can be quickly displayed after a user clicks, so that the workload of secondary development is reduced.
In one embodiment, the data presentation device may receive a second operation instruction of the user, where the second operation instruction is an operation of setting the presentation field; and providing a list page, and displaying the third-party system data on the list page according to the display field.
In this embodiment, the data display device sets corresponding display fields according to different requirements of the user on the display data, so as to achieve personalized setting of the display data. And meanwhile, dynamically generating and displaying a third-party system data list page according to the set display field. Specifically, the presentation field may be functionalized in the following manner:
setting a display name: and setting a display name of the head of the display list, specifically setting the display name of the head of the display list, and using the display name of the head of the display list by the head of the list when constructing and displaying a third-party system data list.
field/XML Path: setting a database field name for a database and a storage process of a data source rule (namely, the target data source rule is a data source mode of acquiring display data by using a Structured Query Language (SQL) statement and a data source mode of acquiring the display data by using the storage process); setting an XML path of data for the data source rule of Web Service and a self-defined address (namely the target data source rule is a data source mode for calling a data query method from a Web Service interface of a specified third-party system to acquire display data and a data source mode for acquiring the display data from a specified HTTP address); for a data source rule that is ESB service (i.e., the target data source rule is the data source way to obtain the presentation data from the ESB service of the specified enterprise server bus), the field name of the return data structure is set.
Title bar setting: when a workflow table single-field is displayed back, the field is usually required to be designated as a title bar, that is, data is displayed by the content of the designated field when the workflow table single-field is displayed back. For example: the system stores the person ID, but should be displayed as the person name.
Setting the column width: the display width of each column of data is set. When the third-party system data is displayed, if the column width is not input, the system automatically defaults that the display width is equally divided for each column, and some data with more contents can not be fully displayed, so that the method is not friendly to users. If the corresponding display column width is set according to the content of each column of data, the data can be better displayed, the aim of completely displaying the data is fulfilled, and the method is user-friendly.
The conversion method comprises the following steps: writing SQL sentences, and converting the data stored in the external fields into the data of the current system. The data stored in the external field is identified by using a variable (currentvalue), the (currentvalue) is replaced by the data stored in the external field when the conversion operation is executed, and the variable (currentvalue) exceeds the function of a placeholder.
In one embodiment, the data display device generates a query interface corresponding to the third-party system data according to the set query field;
and receiving the query condition of the user on the query interface, and returning display data corresponding to the query condition.
In this embodiment, the data display device may set a corresponding query field for a situation that a second query needs to be performed on the third-party system data, so that when the third-party system data is displayed, a query interface is dynamically generated according to the set query field, and the display data of the second query is returned after the user inputs a query condition. The following describes the setting of the query field and the construction of the query conditions:
setting a query field: when a second query is required to be made on third-party system data, the field is usually required to be designated as a query field.
Constructing a query condition: and dynamically constructing a query above the data list of the third-party system, and returning display data of the secondary query after the user inputs a query condition.
It should be noted that, for the third-party system data, the data display device may also construct an access link address on the title field, so that the user can click to jump to the corresponding address to view the detailed information. The title field link comprises a PC link and a mobile link address, for the PC link address, the data presentation device can set a PC browser access address, the address is used for constructing the access link address on the title field, and a user can jump to the specified address to view related information by clicking the link; for the mobile link address, the data presentation device may set a mobile browser access address, construct an access link address using the address in the title field, and the user may jump to the specified address to view the relevant information by clicking the link. It is understood that whether the address is a PC link address or a mobile link address, the user may choose to use or not according to the actual situation, and the method is not limited in particular.
It should be further noted that, when the user performs the secondary query on the third-party system data, the data display device may display the data according to the query result, and the following describes the cache of the playback data of the secondary query data of the third-party system data:
aiming at the condition of high echoed data pressure, the data display device can also directly return the header field value in the echoed data cache if the echoed data hits in the echoed data cache when the echoed data is echoed, so that the performance overhead of calling a database and a calling interface is reduced, and the speed of data echoing display can be well ensured.
The echo data cache is explained as follows:
when workflow list data are stored and the field type of the displayed data is judged to be a user-defined browsing frame, taking the current workflow request ID and the current data ID as a cache main key, judging whether the cache main key exists or not, and if not, setting a header field value in the displayed field as newly-added cache data; if the data exists, the header field value is set in the display field to serve as the updated cache data.
When the field type of the workflow form display data is a custom browsing frame, taking a current workflow request ID + a current data ID as a cache main key, judging whether the cache main key exists, and if so, acquiring cache data by using the cache main key and displaying; and if the result does not exist, executing, taking the result of the query as the result, and updating the set title field value in the display field as cache data into the echoed data cache.
It should be further noted that the basic information settings such as the display mode rule, the display data source rule, the display field, the query field, the title field link, and the like are all located in the cache, so that no matter the related settings are complex, the flow data is more, and the speed of displaying the third-party system data is still very high. Aiming at the condition of high echoed data pressure, after the echoed data cache management function is started, when the echoed data hit in the echoed data cache, the header field value in the echoed data cache is directly returned, the performance overhead of calling a database and a calling interface is reduced, and the speed of data echoing display can be well ensured.
In summary, it can be seen that, in the embodiment provided by the present invention, the data display device can set the display mode rule to satisfy the requirement of displaying the third-party system data in the workflow, the portal, and the menu page; the display data source rule can be set, and the data acquisition path of the third-party system can be flexibly configured; the display field can be set to meet the requirement that the display data column can be configured by self-definition, and a display data list is dynamically generated according to configuration; the query field can be set to meet the requirement of dynamically setting secondary query conditions, so that the effects of saving labor cost, time cost and development fund and improving the utilization rate of data are achieved.
Referring to fig. 2, fig. 2 is a schematic view of a virtual structure of a data display apparatus according to an embodiment of the present invention, where the data display apparatus includes:
a setting unit 201, configured to set a display data source rule according to a data providing manner of third-party system data;
a receiving unit 202, configured to receive a first operation instruction of a user, where the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
an obtaining unit 203, configured to obtain the third-party system data according to the target data source rule;
and the display unit 204 is configured to display the third-party system data according to a display mode rule.
Optionally, the receiving unit 202 is further configured to receive a second operation instruction of the user, where the second operation instruction is an operation of setting a presentation field;
the presentation unit 204 is further configured to provide a list page, and present the third-party system data on the list page according to the presentation field.
Optionally, the apparatus further comprises:
a generating unit 205, configured to generate a query interface corresponding to the third-party system data according to the set query field;
the query unit 206 is configured to receive a query condition of a user in the query interface, and return display data corresponding to the query condition.
Optionally, the displaying unit 204 displays the third-party system data according to the display mode rule, including:
displaying the third-party system data in a form of a custom browsing frame;
and/or the presence of a gas in the gas,
displaying the third party number in an external data element form;
and/or the presence of a gas in the gas,
and displaying the third-party system data in the form of an external data page.
Optionally, the data source display rule includes:
the method comprises the steps of obtaining a data source mode of display data by using a Structured Query Language (SQL) statement, obtaining a data source mode of the display data by using a storage process, obtaining a data source mode of the display data by calling a data query method from a Web Service interface of a specified third-party system, obtaining a data source mode of the display data from a specified HTTP address and/or obtaining a data source mode of the display data from an ESB Service of a specified enterprise server bus, wherein the SQL statement corresponds to the third-party system data, the storage process corresponds to the third-party system data, the Web Service interface corresponds to the third-party system data, the specified HTTP address corresponds to a third-party system data item, and the specified ESB Service corresponds to the third-party system data.
Fig. 2 above describes the exposure sorting apparatus of the live broadcast room in the embodiment of the present invention from the perspective of the modular functional entity, and the following describes the exposure sorting apparatus of the live broadcast room in the embodiment of the present invention in detail from the perspective of hardware processing, referring to fig. 3, an embodiment of an exposure sorting apparatus 300 of the live broadcast room in the embodiment of the present invention includes:
an input device 301, an output device 302, a processor 303 and a memory 304 (wherein the number of the processor 303 may be one or more, and one processor 303 is taken as an example in fig. 3). In some embodiments of the present invention, the input device 301, the output device 502, the processor 303, and the memory 304 may be connected by a bus or other means, wherein the connection by the bus is exemplified in fig. 3.
Wherein, by calling the operation instruction stored in the memory 304, the processor 303 is configured to perform the following steps:
setting a data source displaying rule according to a data providing mode of third-party system data;
receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
acquiring the third-party system data according to the target data source rule;
and displaying the third-party system data according to a display mode rule.
The processor 303 is also configured to perform any of the methods in the corresponding embodiments of fig. 1 by calling the operation instructions stored in the memory 304.
Referring to fig. 4, fig. 4 is a schematic view of an embodiment of an electronic device according to an embodiment of the invention.
As shown in fig. 4, an embodiment of the present invention provides an electronic device, which includes a memory 410, a processor 420, and a computer program 411 stored in the memory 420 and running on the processor 420, and when the processor 420 executes the computer program 411, the following steps are implemented:
setting a data source displaying rule according to a data providing mode of third-party system data;
receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
acquiring the third-party system data according to the target data source rule;
and displaying the third-party system data according to a display mode rule.
In a specific implementation, when the processor 420 executes the computer program 411, any of the embodiments corresponding to fig. 1 may be implemented.
Since the electronic device described in this embodiment is a device used for implementing an exposure sorting apparatus in a live broadcast room in the embodiment of the present invention, based on the method described in the embodiment of the present invention, a person skilled in the art can understand a specific implementation manner of the electronic device of this embodiment and various variations thereof, so that how to implement the method in the embodiment of the present invention by the electronic device is not described in detail herein, and as long as the person skilled in the art implements the device used for implementing the method in the embodiment of the present invention, the device used for implementing the method in the embodiment of the present invention belongs to the scope of the present invention to be protected.
Referring to fig. 5, fig. 5 is a schematic diagram illustrating an embodiment of a computer-readable storage medium according to the present invention.
As shown in fig. 5, the present embodiment provides a computer-readable storage medium 500 having a computer program 511 stored thereon, the computer program 511 implementing the following steps when executed by a processor:
setting a data source displaying rule according to a data providing mode of third-party system data;
receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
acquiring the third-party system data according to the target data source rule;
and displaying the third-party system data according to a display mode rule.
In a specific implementation, the computer program 511 may implement any of the embodiments corresponding to fig. 1 when executed by a processor.
It should be noted that, in the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to relevant descriptions of other embodiments for parts that are not described in detail in a certain embodiment.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Embodiments of the present invention further provide a computer program product, where the computer program product includes computer software instructions, and when the computer software instructions are executed on a processing device, the processing device executes a flow in the method for designing a wind farm digital platform in the embodiment corresponding to fig. 1.
The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the invention to occur, in whole or in part. 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 computer readable storage medium or transmitted from one computer readable storage medium to another, for example, 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 computer-readable storage medium can be any available medium that a computer can store or a data storage device, such as a server, a data center, etc., that is integrated with one or more available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
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 embodiments provided in the present invention, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, 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 mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and 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 invention 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 integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for displaying data, comprising:
setting a data source displaying rule according to a data providing mode of third-party system data;
receiving a first operation instruction of a user, wherein the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
acquiring the third-party system data according to the target data source rule;
and displaying the third-party system data according to a display mode rule.
2. The method of claim 1, further comprising:
receiving a second operation instruction of a user, wherein the second operation instruction is an operation of setting a display field;
and providing a list page, and displaying the third-party system data on the list page according to the display field.
3. The method of claim 1, further comprising:
generating a query interface corresponding to the third-party system data according to the set query field;
and receiving the query condition of the user on the query interface, and returning display data corresponding to the query condition.
4. The method according to any one of claims 1 to 3, wherein the presenting the third-party system data according to presentation style rules comprises:
displaying the third-party system data in a form of a custom browsing frame;
and/or the presence of a gas in the gas,
displaying the third party number in an external data element form;
and/or the presence of a gas in the gas,
and displaying the third-party system data in the form of an external data page.
5. The method of any one of claims 1 to 3, wherein the presentation data source rule comprises:
the method comprises the steps of obtaining a data source mode of display data by using a Structured Query Language (SQL) statement, obtaining a data source mode of the display data by using a storage process, obtaining a data source mode of the display data by calling a data query method from a Web Service interface of a specified third-party system, obtaining a data source mode of the display data from a specified HTTP address and/or obtaining a data source mode of the display data from an ESB Service of a specified enterprise server bus, wherein the SQL statement corresponds to the third-party system data, the storage process corresponds to the third-party system data, the Web Service interface corresponds to the third-party system data, the specified HTTP address corresponds to a third-party system data item, and the specified ESB Service corresponds to the third-party system data.
6. A data presentation device, comprising:
the setting unit is used for setting a display data source rule according to a data providing mode of the third-party system data;
a receiving unit, configured to receive a first operation instruction of a user, where the first operation instruction is an operation of selecting a target data source rule, and the target data source rule is included in the display data source rule;
the acquisition unit is used for acquiring the third-party system data according to the target data source rule;
and the display unit is used for displaying the third-party system data according to the display mode rule.
7. The apparatus of claim 6,
the receiving unit is further configured to receive a second operation instruction of the user, where the second operation instruction is an operation of setting a display field;
the display unit is further used for providing a list page and displaying the third-party system data on the list page according to the display field.
8. The apparatus of claim 6, further comprising:
the generating unit is used for generating a query interface corresponding to the third-party system data according to the set query field;
and the query unit is used for receiving the query conditions of the user on the query interface and returning the display data corresponding to the query conditions.
9. A computer apparatus, comprising:
at least one connected processor, memory, and transceiver; the memory is used for storing program code which is loaded and executed by the processor to implement the steps of the data presentation method of any one of the preceding claims 1 to 5.
10. A computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the steps of the data presentation method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011631118.6A CN112749215B (en) | 2020-12-31 | 2020-12-31 | Data display method and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011631118.6A CN112749215B (en) | 2020-12-31 | 2020-12-31 | Data display method and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112749215A true CN112749215A (en) | 2021-05-04 |
| CN112749215B CN112749215B (en) | 2023-03-17 |
Family
ID=75650765
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011631118.6A Active CN112749215B (en) | 2020-12-31 | 2020-12-31 | Data display method and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112749215B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464871A (en) * | 2007-12-21 | 2009-06-24 | 鸿富锦精密工业（深圳）有限公司 | Report query collocation system and method |
| CN101493828A (en) * | 2008-01-23 | 2009-07-29 | 孔雪 | Active mode system and method for automatically customizing web application |
| US20100094829A1 (en) * | 2008-10-14 | 2010-04-15 | Castellanos Maria G | Database query profiler |
| US20120078877A1 (en) * | 2009-10-21 | 2012-03-29 | Kana Software, Inc. | Multi-source searching in a data driven application |
| CN104901862A (en) * | 2014-03-05 | 2015-09-09 | 腾讯科技（深圳）有限公司 | Method, device and system for displaying application information of third-party application in customized interface |
| CN107480208A (en) * | 2017-07-26 | 2017-12-15 | 广州供电局有限公司 | Multi-source electric power data method for amalgamation processing and device |
| CN108153808A (en) * | 2017-11-22 | 2018-06-12 | 链家网（北京）科技有限公司 | Big data data warehouse data access method and device |
| CN108228796A (en) * | 2017-12-29 | 2018-06-29 | 百度在线网络技术（北京）有限公司 | Management method, device, system, server and the medium of MPP databases |
| CN108520037A (en) * | 2018-03-30 | 2018-09-11 | 新华三大数据技术有限公司 | Data query method, apparatus and data visualisation system |
| US20190065569A1 (en) * | 2016-06-19 | 2019-02-28 | Data.World, Inc. | Dynamic composite data dictionary to facilitate data operations via computerized tools configured to access collaborative datasets in a networked computing platform |
| CN110472127A (en) * | 2019-07-17 | 2019-11-19 | 微梦创科网络科技（中国）有限公司 | A kind of data query method and system |
| CN110737674A (en) * | 2019-10-14 | 2020-01-31 | 深圳前海微众银行股份有限公司 | Visual chart query method, device and equipment and computer storage medium |
| CN111125169A (en) * | 2019-11-28 | 2020-05-08 | 江苏苏宁物流有限公司 | Data query method, control device, medium and computer equipment |
| CN111176505A (en) * | 2019-12-20 | 2020-05-19 | 上海淇玥信息技术有限公司 | Page display method and device based on third-party task linkage and electronic equipment |
| CN111459968A (en) * | 2020-03-27 | 2020-07-28 | 深圳市金蝶天燕云计算股份有限公司 | Data query method, data query system and computer storage medium |
| CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
| CN112052134A (en) * | 2020-07-21 | 2020-12-08 | 北京奇艺世纪科技有限公司 | Service data monitoring method and device |
-
2020
- 2020-12-31 CN CN202011631118.6A patent/CN112749215B/en active Active
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464871A (en) * | 2007-12-21 | 2009-06-24 | 鸿富锦精密工业（深圳）有限公司 | Report query collocation system and method |
| CN101493828A (en) * | 2008-01-23 | 2009-07-29 | 孔雪 | Active mode system and method for automatically customizing web application |
| US20100094829A1 (en) * | 2008-10-14 | 2010-04-15 | Castellanos Maria G | Database query profiler |
| US20120078877A1 (en) * | 2009-10-21 | 2012-03-29 | Kana Software, Inc. | Multi-source searching in a data driven application |
| CN104901862A (en) * | 2014-03-05 | 2015-09-09 | 腾讯科技（深圳）有限公司 | Method, device and system for displaying application information of third-party application in customized interface |
| US20190065569A1 (en) * | 2016-06-19 | 2019-02-28 | Data.World, Inc. | Dynamic composite data dictionary to facilitate data operations via computerized tools configured to access collaborative datasets in a networked computing platform |
| CN107480208A (en) * | 2017-07-26 | 2017-12-15 | 广州供电局有限公司 | Multi-source electric power data method for amalgamation processing and device |
| CN108153808A (en) * | 2017-11-22 | 2018-06-12 | 链家网（北京）科技有限公司 | Big data data warehouse data access method and device |
| CN108228796A (en) * | 2017-12-29 | 2018-06-29 | 百度在线网络技术（北京）有限公司 | Management method, device, system, server and the medium of MPP databases |
| CN108520037A (en) * | 2018-03-30 | 2018-09-11 | 新华三大数据技术有限公司 | Data query method, apparatus and data visualisation system |
| CN110472127A (en) * | 2019-07-17 | 2019-11-19 | 微梦创科网络科技（中国）有限公司 | A kind of data query method and system |
| CN110737674A (en) * | 2019-10-14 | 2020-01-31 | 深圳前海微众银行股份有限公司 | Visual chart query method, device and equipment and computer storage medium |
| CN111125169A (en) * | 2019-11-28 | 2020-05-08 | 江苏苏宁物流有限公司 | Data query method, control device, medium and computer equipment |
| CN111176505A (en) * | 2019-12-20 | 2020-05-19 | 上海淇玥信息技术有限公司 | Page display method and device based on third-party task linkage and electronic equipment |
| CN111459968A (en) * | 2020-03-27 | 2020-07-28 | 深圳市金蝶天燕云计算股份有限公司 | Data query method, data query system and computer storage medium |
| CN112052134A (en) * | 2020-07-21 | 2020-12-08 | 北京奇艺世纪科技有限公司 | Service data monitoring method and device |
| CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
Non-Patent Citations (4)
| Title |
|---|
| 姚诸香;房金彦;桂小强;汤文胜;: "一个轻便型综合监控系统的开发" * |
| 朱家麒: ""界视频监控联网与共享平台设计与实现"" * |
| 李平玉: ""自动测试系统图形化资源建模与测试描述工具的实现"" * |
| 海云瑞等: "宁夏农业物联网大数据共享及综合应用平台研究与设计", 《宁夏农林科技》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112749215B (en) | 2023-03-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10997190B2 (en) | Context-adaptive selection options in a modular visualization framework | |
| JP6761112B2 (en) | Methods and systems for server-side rendering of native content for presentation | |
| US11567959B2 (en) | Self-contained files for generating a visualization of query results | |
| US20200142915A1 (en) | Coding commands using syntax templates | |
| CN111104635B (en) | Method and device for generating form webpage | |
| CN111177231A (en) | Report generation method and report generation device | |
| US7831919B1 (en) | Generic web service frontend | |
| KR101368068B1 (en) | Method of constructing database, server performing the same and storage media storing the same | |
| US20070124502A1 (en) | Script language based network device configuration management system and method | |
| EP2369480A2 (en) | Mashup infrastructure with learning mechanism | |
| US20140156828A1 (en) | Method and system for abstracting restful web service http between a client and a server | |
| US9280402B2 (en) | System and method for updating a dual layer browser | |
| US11475053B1 (en) | Providing completion recommendations for a partial natural language request received by a natural language processing system | |
| CN109766097A (en) | UI generation method, device, electronic equipment and computer readable storage medium | |
| KR20130115654A (en) | Method of rendering user interface, server performing the same and stroage media sotring the same | |
| CN107908442B (en) | Spring-based resource loading method and device, terminal equipment and computer-readable storage medium | |
| CN111241182A (en) | Data processing method and apparatus, storage medium, and electronic apparatus | |
| KR101643436B1 (en) | Extensibility for web based diagram visualization | |
| US20170374001A1 (en) | Providing communication ranking scheme based on relationship graph | |
| US9934291B2 (en) | Dynamic presentation of a results set by a form-based software application | |
| CN112749215B (en) | Data display method and related equipment | |
| CN115576974A (en) | Data processing method, device, equipment and medium | |
| US11048760B1 (en) | Techniques for placing content in and applying layers in an extended reality environment | |
| CN116776030A (en) | Gray release method, device, computer equipment and storage medium | |
| CN112181409A (en) | Application construction method, application rendering method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |