CN114398031B - Page configuration method and mobile background management system - Google Patents
Page configuration method and mobile background management system Download PDFInfo
- Publication number
- CN114398031B CN114398031B CN202210051197.6A CN202210051197A CN114398031B CN 114398031 B CN114398031 B CN 114398031B CN 202210051197 A CN202210051197 A CN 202210051197A CN 114398031 B CN114398031 B CN 114398031B
- Authority
- CN
- China
- Prior art keywords
- data
- data source
- page
- terminal
- function
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
-
- 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/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
When the page configuration is carried out, firstly, the data source of the function module similar to the PC end in the mobile end can be configured based on the data source of each function module in the PC end, a data storage table is established, after the data source is configured, the function page of the function module similar to the PC end in the mobile end can be configured, the module parameter and the query data of the function page are determined, then, the module parameter and the query data can be associated with the data storage table to form the page SQL statement of the function page, and the page SQL statement can be used for querying and displaying the page data of the function page, so that the new functions of the mobile end can be developed only by configuring the function page and the data source of the new functions without redevelopment of java codes, and the development time is greatly saved, the development efficiency is improved, and the development cost and the maintenance cost are further reduced.
Description
Technical Field
The application relates to the technical field of computer software application development, in particular to a page configuration method and a mobile background management system.
Background
At present, when software development is carried out, mobile terminal data is mostly processed based on PC terminal data, data of each function module of a mobile terminal is processed from data of a corresponding function of the PC terminal, meanwhile, in order to reduce workload of development of a function interface of the mobile terminal, the mobile terminal adopts a common interface to obtain all modes of common page function data, functions of the same data structure do not need to develop java codes again, and the acquisition of the function module data of the mobile terminal is realized only through a mode of configuration of a background database.
And the functional module data of the mobile terminal acquired by the method is difficult to trace, so that the development efficiency is reduced, and the development cost is increased.
Disclosure of Invention
The purpose of the present application is to solve at least one of the above technical defects, and in particular, to solve the technical defect that the function module data of the mobile terminal acquired in the prior art is difficult to trace to the source, thereby reducing the development efficiency and improving the development cost.
The application provides a page configuration method, which comprises the following steps:
configuring a data source of a functional module similar to a PC terminal in a mobile terminal based on the data source of each functional module in the PC terminal, and establishing a data storage table, wherein the data storage table is used for storing query data corresponding to the data source of the functional module similar to the PC terminal in the mobile terminal and data source data corresponding to the query data;
configuring a functional page of a functional module similar to the PC terminal in the mobile terminal, determining module parameters and query data of the functional page, associating the module parameters and the query data with the data storage table to form a page SQL statement of the functional page, wherein the page SQL statement is used for querying and displaying page data of the functional page.
Optionally, the configuring, by the data source based on each functional module in the PC terminal, the data source of a functional module similar to the PC terminal in the mobile terminal includes:
and configuring the data source dimension, the data source classification, the data source name and the data source data acquisition mode of the functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal.
Optionally, the data source data obtaining manner includes SQL and a storage procedure.
Optionally, when the data source data is obtained in SQL;
the configuring the obtaining mode of the data source data of the functional module similar to the PC terminal in the mobile terminal includes:
writing an SQL statement corresponding to the data source name;
querying the SQL statement based on a data source of a similar functional module in the PC terminal, and returning a query field;
and setting a Chinese field and a primary key index corresponding to the data source name according to the query field.
Optionally, the establishing a data storage table includes:
setting a calculation sequence of the data source names, an SQL statement query period and a target table name;
inquiring data source data of a functional module corresponding to the data source name in the PC terminal according to the calculation sequence of the data source name and the SQL statement inquiry period;
and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
Optionally, when the data source data is acquired in a storage process;
the configuring the obtaining mode of the data source data of the functional module similar to the PC terminal in the mobile terminal includes:
developing a storage process corresponding to the data source name according to the input and output parameter specification of the storage process, and determining a query field corresponding to the storage process;
and creating the storage process in a database corresponding to the similar functional module in the PC terminal, and acquiring data source data by using the storage process.
Optionally, the establishing a data storage table includes:
setting the calculation sequence of the data source names, the query period of the storage process and the target table names;
inquiring data source data of a functional module corresponding to the data source name in the PC terminal according to the calculation sequence of the data source names and the inquiry period of the storage process;
and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
Optionally, the configuring a function page of a function module similar to the PC in the mobile terminal includes:
and configuring a function application role, a function application menu, a function application page, module parameters, a module name and query data corresponding to a function page of a function module similar to the PC terminal in the mobile terminal.
Optionally, the method further comprises:
and configuring the page display field attribute and the SQL data output parameter of the functional page.
The application also provides a mobile background management system, which comprises:
the data source management module is used for configuring data sources of functional modules similar to the PC terminal in the mobile terminal based on the data sources of the functional modules in the PC terminal and establishing a data storage table, wherein the data storage table is used for storing query data corresponding to the data sources of the functional modules similar to the PC terminal in the mobile terminal and data source data corresponding to the query data;
and the function page management module is used for configuring a function page of a function module similar to the PC terminal in the mobile terminal, determining module parameters and query data of the function page, associating the module parameters and the query data with the data storage table, and forming a page SQL statement of the function page, wherein the page SQL statement is used for querying and displaying page data of the function page.
According to the technical scheme, the embodiment of the application has the following advantages:
when the page configuration is carried out, firstly, a data source of a functional module similar to the PC terminal in the mobile terminal can be configured based on the data source of each functional module in the PC terminal, and a data storage table is established, wherein the data storage table is used for storing query data corresponding to the data source of the functional module similar to the PC terminal in the mobile terminal and data source data corresponding to the query data, so that the tracing of the functional data of the mobile terminal is realized; furthermore, after the data source is configured, the method can configure the function page of the function module similar to the PC terminal in the mobile terminal, determine the module parameters and query data of the function page, and then associate the module parameters and the query data with the data storage table to form the page SQL statement of the function page, wherein the page SQL statement can be used for querying and displaying the page data of the function page, so that the development of the new function of the mobile terminal is realized by only configuring the function page and the data source of the new function without redeveloping java codes, the development time is greatly saved, the development efficiency is improved, and the development cost and the maintenance cost are further reduced.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic flowchart of a page configuration method according to an embodiment of the present application;
FIG. 2 is a page display diagram of a data source configuration page provided by an embodiment of the present application;
FIG. 3 is a page display diagram of another data source configuration page provided by an embodiment of the present application;
FIG. 4 is a page display diagram of a configuration function page provided by an embodiment of the present application;
fig. 5 is a schematic structural diagram of a mobile backend management system according to an embodiment of the present application.
Detailed Description
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.
In an embodiment, as shown in fig. 1, fig. 1 is a schematic flowchart of a page configuration method provided in an embodiment of the present application; the application provides a page configuration method, which comprises the following steps:
s110: and configuring the data source of the functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal, and establishing a data storage table.
In this step, the same application can be divided into PC software development and mobile software development during the software development process, the mobile data is mainly processed based on the PC data, and the data of each functional module of the mobile terminal is processed based on the data of the corresponding function of the PC.
For example, the mobile terminal can acquire all the common page function data by using a common interface, so that the mobile terminal has the same data structure as the PC terminal, and the acquisition of the page interface data of the mobile terminal can be realized only by a background database configuration mode without redeveloping java codes.
On the basis of the prior art, the interface background data of the mobile terminal is configured, so that when the mobile terminal carries out software development, the whole development process can be realized only by developing a corresponding function page and determining the data source of the function page.
Specifically, when the interface background data of the mobile terminal is configured, the data source of the function module similar to the PC terminal in the mobile terminal can be configured based on the data source of each function module in the PC terminal, and a corresponding data storage table is established, so that when the function page of the mobile terminal is developed, the function page can be directly associated with the data storage table, and then the page data of the function page can be acquired.
For example, when configuring the data source of each functional module in the mobile terminal, the dimension, the type, the name, the data source data obtaining mode, and the like of the mobile terminal data source may be set according to the data source of the functional module of the PC terminal, and after obtaining the data source data by the data source data obtaining mode, the query data corresponding to the data source of each functional module is set according to the data source data. For example, the data source data with the data source name of "the expert index details" may include the query field, the chinese field of the query field, the primary key index, and the like, and the user may query the corresponding data source data through the query data.
It should be noted that the functional module similar to the PC in the mobile terminal described in this application refers to that the database in the mobile terminal is consistent with the database in the case where the functional module of the PC requests data, but there is a difference between the page display content and the page display mode of the functional module in the mobile terminal and the page display content and the page display mode of the functional module in the PC.
Further, after configuring the data source of each function module in the mobile terminal, the present application may establish a data storage table, where the data storage table stores query data corresponding to the data source of the function module similar to the PC terminal in the mobile terminal and data source data corresponding to the query data. Therefore, after the corresponding query data is configured in the function page of the mobile terminal, the user selects the query data in the function page to obtain the corresponding data source data.
S120: and configuring a function page of a function module similar to the PC terminal in the mobile terminal, determining module parameters and query data of the function page, and associating the module parameters and the query data with a data storage table to form a page SQL statement of the function page.
In this step, after the data source of the function module in the mobile terminal is configured through S110, each data source in the function page of the mobile terminal may be configured and displayed.
Specifically, the method and the device can configure a function page of a function module similar to the PC in the mobile terminal, for example, configure a function application role, a function application menu, a function application page, module parameters, a module name, query data, page display field attributes, and the like of the function page, then determine corresponding module parameters and query data according to the configured function page, and associate the module parameters, the query data, and the data storage table, thereby forming a page SQL statement of the function page, wherein the page SQL statement is used for querying and displaying page data of the function page.
It can be understood that the functional page of the application includes corresponding data sources, each data source has a corresponding functional module, after associating the module parameters and query data in the functional page with the data storage table, the data storage table can be queried through the module parameters, and the initial page SQL statements of the functional page are determined, then the current initial page SQL statements can be filtered through the query data, so as to form the final page SQL statements, and the page SQL statements can be used for querying the page data required by the functional page and return to the front end page of the mobile terminal for data rendering, so as to complete function development.
In the above embodiment, when performing page configuration, first, a data source of a functional module similar to the PC in the mobile terminal may be configured based on a data source of each functional module in the PC terminal, and a data storage table is established, where the data storage table is used to store query data corresponding to the data source of the functional module similar to the PC in the mobile terminal and data source data corresponding to the query data, so as to implement tracing of the functional data of the mobile terminal; furthermore, after the data source is configured, the method can configure the function page of the function module similar to the PC terminal in the mobile terminal, determine the module parameters and query data of the function page, and then associate the module parameters and the query data with the data storage table to form the page SQL statement of the function page, wherein the page SQL statement can be used for querying and displaying the page data of the function page, so that the development of the new function of the mobile terminal is realized by only configuring the function page and the data source of the new function without redeveloping java codes, the development time is greatly saved, the development efficiency is improved, and the development cost and the maintenance cost are further reduced.
In one embodiment, as shown in fig. 2, fig. 2 is a page presentation diagram of a data source configuration page provided by an embodiment of the present application; in S110, configuring a data source of a functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal may include:
s111: and configuring the data source dimension, the data source classification, the data source name and the data source data acquisition mode of the functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal.
In this embodiment, as shown in fig. 2, when the data sources of the functional modules in the mobile terminal are configured in fig. 2, the data sources of the mobile terminal may be divided according to the data source dimension of each functional module in the PC terminal, for example, into a mechanism data source, a member data source, or others; the data sources under different dimensionalities can be classified, for example, the data sources under the data sources of the members can be classified into performance, clients, other data sources and the like, and the data sources can also be named, for example, under the condition that the data sources are classified into the performance, a plurality of data source names can be set, including but not limited to member assessment performance, member assessment performance ranking, member index detail, member client number and the like; in addition, the present application may further set an acquisition mode of the data source, and the acquisition mode may be as an implementation mode of SQL in fig. 2.
In one embodiment, the data source data may be obtained in a manner including SQL and stored procedures.
In one embodiment, when the data source data is obtained in SQL; in S111, configuring a data source data obtaining manner of a functional module similar to the PC terminal in the mobile terminal, which may include:
s210: writing an SQL statement corresponding to the data source name.
S211: and querying the SQL statement based on the data source of the similar functional module in the PC terminal, and returning a query field.
S212: and setting a Chinese field and a primary key index corresponding to the data source name according to the query field.
In this embodiment, when the data source data is obtained in an SQL manner, an SQL statement corresponding to a data source name may be written, for example, the SQL statement corresponding to the technician index details may be written, then the written SQL statement may be queried according to a database corresponding to a data source of a similar function module in the PC terminal, and a query field is returned, where the query field is a variable in the previously written SQL statement, and after the query field is returned, a chinese field and a main key index under the data source name may be set according to the query field, so as to form query data corresponding to the data source, and a user may select a specific numerical value or a default value of the query data to obtain corresponding data source data.
As shown in fig. 2, after the SQL statement is written at the corresponding position in fig. 2, the chinese description corresponding to the returned query field, the unique index column, the operation, and the like are set under the field setting, so that the developer can accurately view the data source name, the data source classification, the SQL statement, the field setting, and the like corresponding to the current data source.
In one embodiment, the creating of the data storage table in S110 may include:
s213: and setting the calculation sequence of the data source names, the SQL statement query period and the target table names.
S214: and querying the data source data of the functional module corresponding to the data source name in the PC terminal according to the calculation sequence of the data source name and the query cycle of the SQL statement.
S215: and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
In this embodiment, when configuring a data source of each functional module in a mobile terminal, a data storage table may be established, and a target table name, a calculation order of the data source under the current data source name and an SQL statement query cycle may be set, then, data source data of the functional module corresponding to the data source name in the PC terminal may be queried according to the calculation order and the SQL statement query cycle, and a data storage table may be created according to the target table name corresponding to the data source name, the data source data, and a returned query field.
Specifically, as shown in fig. 2, a target table name "MPAS _ SJ _ HYZBMX" may be set, a calculation order of a data source with a data source name of a actor index detail is 1, a query cycle of an SQL statement is every other day, then, an SQL statement corresponding to the actor index detail data source may be written by a user, and a query field is returned after the SQL statement is queried in a database corresponding to the same data source on the PC side, for example: index name, data and other fields, then setting the returned Chinese name and main key index of the query field, and preparing for creating a data storage table; after the user-defined data source setting is verified, stored and applied, a mobile terminal data source running program can be added in the total scheduling of the PC terminal performance system scheduling function: and the system is set to be scheduled every day, all started functional module data sources in the functional data source management function can be loaded during scheduling, each data source data is inquired according to the SQL statement inquiry period and the calculation sequence, a data storage table is automatically newly built according to the custom target table name and the return field setting, and the inquired data source data is stored.
In one embodiment, when the data source data is obtained in a storage process; in S111, configuring a data source data obtaining manner of a functional module similar to the PC in the mobile terminal may include:
s310: and developing a storage process corresponding to the data source name according to the input and output parameter specification of the storage process, and determining a query field corresponding to the storage process.
S311: and creating the storage process in a database corresponding to the similar functional module in the PC terminal, and acquiring data source data by using the storage process.
In this embodiment, since the storage procedure refers to that in a large database system, a group of SQL statement sets, i.e., SQL codes, for completing a specific function are compiled and stored in the database, and a user can call the storage procedure by specifying its name and giving parameters.
Therefore, according to the specification of the input and output parameters of the storage process, the storage process corresponding to different data source names can be developed, the query field corresponding to the storage process, such as the variable name in the storage process, can be determined, then the storage process can be created in the database corresponding to the similar function module in the PC terminal, and the data source data can be obtained by using the storage process.
In one embodiment, as shown in fig. 3, fig. 3 is a page presentation diagram of another data source configuration page provided by the embodiment of the present application; the establishing of the data storage table in S110 may include:
s312: and setting the calculation sequence of the data source names, the query period of the storage process and the target table names.
S313: and querying the data source data of the functional module corresponding to the data source name in the PC terminal according to the computing sequence of the data source name and the query cycle of the storage process.
S314: and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
In this embodiment, when configuring the data source of each functional module in the mobile terminal, a data storage table may be established, and a target table name, a calculation order and a storage process query period of the data source under the current data source name may be set, and then, the data source data of the functional module corresponding to the data source name in the PC terminal may be queried according to the calculation order and the storage process query period, and the data storage table may be established according to the target table name corresponding to the data source name, the data source data, and the returned query field.
Specifically, as shown in fig. 3, in the present application, according to the storage process input/output parameter specification, a storage process required by a data source may be developed, a corresponding storage process may be created in a database, and then the custom developed data source storage process is selected for verification, storage, and application, and during application, a mobile-end data source running program may be added in the total scheduling of the PC-end performance system scheduling function: and the data storage table is automatically newly built according to the self-defined target table name and the setting of a return field, and the data source data obtained by query is stored.
In one embodiment, as shown in fig. 4, fig. 4 is a page display diagram when configuring a functional page provided by an embodiment of the present application; in S120, configuring a function page of a function module similar to the PC in the mobile terminal may include:
and configuring a function application role, a function application menu, a function application page, module parameters, a module name and query data corresponding to a function page of a function module similar to the PC terminal in the mobile terminal.
In this embodiment, as shown in fig. 2, when configuring the function page of the mobile terminal, the function application role of the function page may be configured, such as a common member; the function application menu of the function page can also be configured, such as personal performance, or personal performance relationship management, etc., or the function application page of the function page can also be configured, such as personal performance-deposit information under personal performance, or personal performance-deposit index under personal performance, etc.; and the module parameters, the module names, the query data, the page display field attributes and the like of the function page can be configured.
The setting of the module parameters can be associated with the corresponding data storage table, so that the corresponding data storage table can be searched according to the module parameters; the setting of the query data can also be associated with the corresponding data storage table, for example, when the query data is a statistical date and an evaluation object code, the user can select the corresponding statistical date and the access object code according to the self requirement, and after the query data is associated with the data storage table, irrelevant data source data in the data storage table can be screened according to the query data, and relevant data source data can be returned.
In the above embodiment, after the function page of the mobile terminal is configured, the user can clearly view the data chain of each function page of the mobile terminal, and can directly view the data source of the current page through the page name and the hierarchy. For example, when a performance index of an ordinary technician is checked, only the corresponding function page configuration, namely, the hierarchy of [ ordinary technician ] - [ performance module ] - [ personal performance function ] - [ personal performance-deposit information ], needs to be found, the current page SQL query statement can be seen, and meanwhile, the final source of the page data can be traced further by moving the public data source, for example, the current personal index data can be found in the public data source function through the data storage table. For the development of new functions, only the development of pages is needed, the page access interface can be a universal interface and is directly realized in a configuration mode, so that the function development efficiency is improved, the development cost and the maintenance cost are reduced, and the daily function maintenance is more convenient and concise.
In one embodiment, the method may further comprise: and configuring the page display field attribute and the SQL data output parameter of the functional page.
In this embodiment, as shown in fig. 4, when configuring the function page, the attribute of the page display field and the SQL data output parameter may also be configured, such as "deposit basic index", so that when displaying the page function data, the user may access a "common clerk" - [ performance module ] - [ personal performance function ] - [ personal performance-deposit information ] page to query "deposit basic index" data.
In an embodiment, as shown in fig. 5, fig. 5 is a schematic structural diagram of a mobile backend management system according to an embodiment of the present application; the application also provides a mobile background management system, which includes a data source management module 210 and a functional page management module 220, and the following is specifically provided:
the data source management module 210 is configured to configure a data source of a functional module similar to the PC terminal in the mobile terminal based on a data source of each functional module in the PC terminal, and establish a data storage table, where the data storage table is used to store query data corresponding to the data source of the functional module similar to the PC terminal in the mobile terminal and data source data corresponding to the query data.
The function page management module 220 is configured to configure a function page of a function module similar to the PC in the mobile terminal, determine module parameters and query data of the function page, and associate the module parameters and the query data with the data storage table to form a page SQL statement of the function page, where the page SQL statement is used to query and display page data of the function page.
In the above embodiment, when performing page configuration, first, a data source of a functional module similar to the PC in the mobile terminal may be configured based on a data source of each functional module in the PC terminal, and a data storage table is established, where the data storage table is used to store query data corresponding to the data source of the functional module similar to the PC in the mobile terminal and data source data corresponding to the query data, so as to implement tracing of the functional data of the mobile terminal; furthermore, after the data source is configured, the method can configure the function page of the function module similar to the PC terminal in the mobile terminal, determine the module parameters and query data of the function page, and then associate the module parameters and the query data with the data storage table to form the page SQL statement of the function page, wherein the page SQL statement can be used for querying and displaying the page data of the function page, so that the development of the new function of the mobile terminal is realized by only configuring the function page and the data source of the new function without redeveloping java codes, the development time is greatly saved, the development efficiency is improved, and the development cost and the maintenance cost are further reduced.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, the embodiments may be combined as needed, and the same and similar parts may be referred to each other.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A page configuration method, characterized in that the method comprises:
configuring a data source of a functional module similar to a PC terminal in a mobile terminal based on the data source of each functional module in the PC terminal, and establishing a data storage table, wherein the data storage table is used for storing query data corresponding to the data source of the functional module similar to the PC terminal in the mobile terminal and data source data corresponding to the query data;
configuring a function page of a function module similar to the PC terminal in the mobile terminal, determining module parameters and query data of the function page, associating the module parameters and the query data with the data storage table, and forming a page SQL statement of the function page, wherein the page SQL statement is used for querying and displaying page data of the function page;
the function module similar to the PC terminal in the mobile terminal means that the database tables in the mobile terminal are consistent with the database tables when the function module of the PC terminal requests data, but the page display content and the page display mode of the function module in the mobile terminal are different from those of the function module in the PC terminal.
2. The method according to claim 1, wherein the configuring the data source of the functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal comprises:
and configuring the data source dimension, the data source classification, the data source name and the data source data acquisition mode of the functional module similar to the PC terminal in the mobile terminal based on the data source of each functional module in the PC terminal.
3. The method of claim 2, wherein the data source data is obtained in a manner that includes SQL statement query and stored procedures.
4. The method according to claim 3, wherein when the data source data is obtained by SQL statement query;
the configuring the obtaining mode of the data source data of the functional module similar to the PC terminal in the mobile terminal includes:
writing an SQL statement corresponding to the data source name;
inquiring the SQL statement based on a data source of a similar functional module in the PC terminal, and returning an inquiry field;
and setting a Chinese field and a primary key index corresponding to the data source name according to the query field.
5. The method of claim 4, wherein the creating a data storage table comprises:
setting a calculation sequence of the data source names, an SQL statement query period and a target table name;
inquiring data source data of a functional module corresponding to the data source name in the PC terminal according to the calculation sequence of the data source name and the SQL statement inquiry period;
and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
6. The method according to claim 3, wherein when the data source data is obtained in a storage process;
the configuring the obtaining mode of the data source data of the functional module similar to the PC terminal in the mobile terminal includes:
developing a storage process corresponding to the data source name according to the input and output parameter specification of the storage process, and determining a query field corresponding to the storage process;
and creating the storage process in a database corresponding to the similar functional module in the PC terminal, and acquiring data source data by using the storage process.
7. The method of claim 6, wherein the creating a data storage table comprises:
setting the calculation sequence of the data source names, the query period of the storage process and the target table names;
inquiring data source data of a functional module corresponding to the data source name in the PC terminal according to the calculation sequence of the data source name and the inquiry period of the storage process;
and creating a data storage table according to the target table name corresponding to the data source name, the data source data and the returned query field.
8. The method according to claim 1, wherein the configuring the function page of the function module similar to the PC side in the mobile side comprises:
and configuring a function application role, a function application menu, a function application page, module parameters, a module name and query data corresponding to a function page of a function module similar to the PC terminal in the mobile terminal.
9. The method of claim 1, further comprising:
and configuring the page display field attribute and the SQL data output parameter of the functional page.
10. A mobile backend management system, comprising:
the data source management module is used for configuring data sources of functional modules similar to the PC terminal in the mobile terminal based on the data sources of the functional modules in the PC terminal and establishing a data storage table, wherein the data storage table is used for storing query data corresponding to the data sources of the functional modules similar to the PC terminal in the mobile terminal and data source data corresponding to the query data;
the function page management module is used for configuring a function page of a function module similar to the PC terminal in the mobile terminal, determining module parameters and query data of the function page, associating the module parameters and the query data with the data storage table, and forming a page SQL statement of the function page, wherein the page SQL statement is used for querying and displaying page data of the function page;
the function module similar to the PC terminal in the mobile terminal means that the database tables in the mobile terminal are consistent with the database tables when the function module of the PC terminal requests data, but the page display content and the page display mode of the function module in the mobile terminal are different from those of the function module in the PC terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210051197.6A CN114398031B (en) | 2022-01-17 | 2022-01-17 | Page configuration method and mobile background management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210051197.6A CN114398031B (en) | 2022-01-17 | 2022-01-17 | Page configuration method and mobile background management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114398031A CN114398031A (en) | 2022-04-26 |
| CN114398031B true CN114398031B (en) | 2022-08-09 |
Family
ID=81230555
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210051197.6A Active CN114398031B (en) | 2022-01-17 | 2022-01-17 | Page configuration method and mobile background management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114398031B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103942218A (en) * | 2013-01-22 | 2014-07-23 | 阿里巴巴集团控股有限公司 | Method and device for generating and updating special subject pages |
| CN108008954A (en) * | 2017-12-01 | 2018-05-08 | 深圳乐信软件技术有限公司 | Page configuration method, apparatus, server and medium |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108596516A (en) * | 2018-05-11 | 2018-09-28 | 广州天维信息技术股份有限公司 | A kind of automation appraisal procedure and system |
| US20210390098A1 (en) * | 2020-06-11 | 2021-12-16 | Data.World, Inc. | Query engine implementing auxiliary commands via computerized tools to deploy predictive data models in-situ in a networked computing platform |
-
2022
- 2022-01-17 CN CN202210051197.6A patent/CN114398031B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103942218A (en) * | 2013-01-22 | 2014-07-23 | 阿里巴巴集团控股有限公司 | Method and device for generating and updating special subject pages |
| CN108008954A (en) * | 2017-12-01 | 2018-05-08 | 深圳乐信软件技术有限公司 | Page configuration method, apparatus, server and medium |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
Non-Patent Citations (1)
| Title |
|---|
| 陈涛 ; 张永娟 ; 陈恒.Web数据到RDF数据的框架实现.《现代图书情报技术》.2015, * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114398031A (en) | 2022-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106648690B (en) | Automatic code generation method and device | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| EP3191963B1 (en) | Data-driven testing framework | |
| CN108804459B (en) | Data query method and device | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN110198327B (en) | Data transmission method and related equipment | |
| CN112396462A (en) | Crowd circling method and device based on Clickhouse | |
| CN114398031B (en) | Page configuration method and mobile background management system | |
| CN113760952A (en) | Data query method and device, storage medium and electronic device | |
| CN112434056A (en) | Method and device for inquiring detailed data | |
| CN114995877B (en) | Variable configuration method and device | |
| CN113868141A (en) | Data testing method and device, electronic equipment and storage medium | |
| CN112527917A (en) | Data processing method and device | |
| CN113779362A (en) | Data searching method and device | |
| CN112989769A (en) | Method, device and platform for constructing multi-data-source form based on form engine | |
| CN112486796A (en) | Method and device for collecting information of vehicle-mounted intelligent terminal | |
| CN113505143A (en) | Statement type conversion method and device, storage medium and electronic device | |
| CN111177146B (en) | Data analysis method, device and equipment | |
| CN111079391B (en) | Report generation method and device | |
| CN114691837B (en) | Insurance business data processing method and processing system based on big data | |
| CN107729013B (en) | Method for managing operation buttons on web page and computer-readable storage medium | |
| CN112948441A (en) | Financial data-oriented multidimensional data aggregation method and equipment | |
| CN115374761A (en) | Report generation method, report generation device, electronic equipment and storage medium | |
| CN114840551A (en) | Database table processing method and device, electronic equipment and storage medium | |
| CN115718754A (en) | Electronic accounting archive data query method and device and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |