CN109062883A

CN109062883A - Tables of data dynamic deriving method, device, computer equipment and storage medium

Info

Publication number: CN109062883A
Application number: CN201810788103.7A
Authority: CN
Inventors: 李源
Original assignee: Ping An Technology Shenzhen Co Ltd
Current assignee: Ping An Technology Shenzhen Co Ltd
Priority date: 2018-07-18
Filing date: 2018-07-18
Publication date: 2018-12-21
Anticipated expiration: 2038-07-18
Also published as: WO2020015150A1; CN109062883B

Abstract

The present invention discloses a kind of tables of data dynamic deriving method, device, computer equipment and storage medium.The tables of data dynamic deriving method, comprising: obtain data export request, data export request includes target matrix ID；Database is inquired based on target data table id, obtains target allocation list corresponding with target data table id, target allocation list includes at least two target configuration datas, and each target configuration data includes table ID, source table id and derived field；Each target configuration data in target allocation list is traversed, source table id and derived field are based on, obtains target query sentence corresponding with table ID；Target data is obtained based on target query sentence, and target data is stored in EXCEL table, obtain and exports target page table corresponding with table ID.This method may make each data export request that can quickly export at least two target page tables, and process is conducive to improve efficiency derived from data page without writing or modifying code.

Description

Tables of data dynamic deriving method, device, computer equipment and storage medium

Technical field

The present invention relates to data processing field more particularly to a kind of tables of data dynamic deriving methods, device, computer equipment And storage medium.

Background technique

In project development process, the business demand that data are exported to the tables of data of EXCEL format is often had, especially It is the tables of data for needing to export to data multiple EXCEL formats, that is, needs to export data page, so that each tables of data Data comprising different derived fields.When exporting data page, the export of each tables of data is required to write corresponding Code, so that the heavy workload of written in code, increases the workload of project development, to reduce the efficiency of project development.Moreover, In data page export, the pagings content alterations such as the sequence of paging is modified, increases newly or delete are required to modification code, make total According to larger workload derived from paging.In addition, when exporting data page, derived field in tables of data derived from each paging Sequence adjustment, increase, delete and modification etc. fields change, it is also desirable to code is modified, so that workload derived from data page Increase.To sum up, when exporting data page in project development process, corresponding code need to be write or is modified, item is significantly greatly increased The workload of mesh exploitation, is also easy to cause project development to malfunction, influences the quality and efficiency of project development.

Summary of the invention

The embodiment of the present invention provides a kind of tables of data dynamic deriving method, device, computer equipment and storage medium, with solution Larger workload and easy the problem of malfunctioning when certainly current data paging exports.

A kind of tables of data dynamic deriving method, comprising:

Data export request is obtained, the data export request includes target matrix ID；

Database is inquired based on the target data table id, obtains target configuration corresponding with the target data table id Table, the target allocation list include at least two target configuration datas, and each target configuration data includes table ID, source table ID and derived field；

Each target configuration data in the target allocation list is traversed, the source table id and the export word are based on Section obtains target query sentence corresponding with the table ID；

Target data is obtained based on the target query sentence, and the target data is stored in EXCEL table, is obtained And export target page table corresponding with the table ID.

A kind of tables of data dynamic guiding device, comprising:

Request module is exported, for obtaining data export request, the data export request includes target matrix ID；

Target allocation list obtains module, for inquiring database based on the target data table id, obtains and the target The corresponding target allocation list of tables of data ID, the target allocation list include at least two target configuration datas, each mesh It includes table ID, source table id and derived field that standard configuration, which sets data,；

Query statement obtains module and is based on for traversing each target configuration data in the target allocation list The source table id and the derived field obtain target query sentence corresponding with the table ID；

Target page table obtains module, for obtaining target data based on the target query sentence, and by the target Data are stored in EXCEL table, are obtained and are exported target page table corresponding with the table ID.

A kind of computer equipment, including memory, processor and storage are in the memory and can be in the processing The computer program run on device, the processor realize above-mentioned tables of data dynamic deriving method when executing the computer program The step of.

A kind of computer readable storage medium, the computer-readable recording medium storage have computer program, the meter The step of calculation machine program realizes above-mentioned tables of data dynamic deriving method when being executed by processor.

Above-mentioned tables of data dynamic deriving method, device, computer equipment and storage medium, according in data export request Target data table id can quick search get target allocation list；Due to containing at least two target configuration number in target allocation list According to, according in each target configuration data source table id and derived field can the automatic corresponding target query sentence of quick obtaining, This process is not necessarily to manual intervention, helps to improve efficiency derived from data；It is inquired based on each target query sentence and obtains target The target data is stored in EXCEL table by data, can be obtained and be exported corresponding target page table.Due to each target It include at least two target configuration datas in allocation list, each target configuration data can export a target page table, so that each Data export request can quickly export at least two target page tables, and process is conducive to improve without writing or modifying code Efficiency derived from data page.

Detailed description of the invention

In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings Obtain other attached drawings.

Fig. 1 is an application environment schematic diagram of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 2 is a flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 3 is another flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 4 is another flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 5 is another flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 6 is another flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 7 is another flow chart of tables of data dynamic deriving method in one embodiment of the invention；

Fig. 8 is a schematic diagram of tables of data dynamic guiding device in one embodiment of the invention；

Fig. 9 is a schematic diagram of computer equipment in one embodiment of the invention.

Specific embodiment

Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts Example, shall fall within the protection scope of the present invention.

Tables of data dynamic deriving method provided in an embodiment of the present invention, can be applicable in the application environment such as Fig. 1, wherein Client is communicated by network with server, and the data for being uploaded based on client export request, executes server The derived operation of tables of data dynamic.Wherein, client is also known as user terminal, refers to corresponding with server, provides this for client The program of ground service.Client it is mountable but be not limited to various personal computers, laptop, smart phone, plate electricity Brain and portable wearable device.Server can use the server cluster of the either multiple server compositions of independent server To realize.

In one embodiment, it as shown in Fig. 2, providing a kind of tables of data dynamic deriving method, applies in Fig. 1 in this way Server for be illustrated, which includes the following steps:

S10: data export request is obtained, data export request includes target matrix ID.

Wherein, data export request is that the request of tables of data dynamic export processing is carried out for trigger the server.Number of targets It is the corresponding tables of data ID of this data export request according to table id, and tables of data ID is the mark for unique identification allocation list Know.

Multiple allocation lists are previously stored in the present embodiment, in database, each allocation list corresponds to a tables of data ID, so as to It is subsequent that corresponding allocation list is obtained based on tables of data ID inquiry.Specifically, at least one allocation list is stored in advance in database, The allocation list is that user is pre-configured with and carries out duplicate removal according to business demand and close the conjunction after rule verify to advise allocation list, to avoid rear It is continuous to carry out mistake occur when tables of data dynamic exports based on the allocation list, to guarantee to go on smoothly derived from tables of data dynamic. Wherein, closing rule allocation list is the pre- allocation list for first passing through duplicate removal processing and obtaining with conjunction rule verification.

Be provided with script (i.e. computer journey derived from achievable tables of data dynamic in the present embodiment, in server in advance Sequence), in project development process, when if desired carrying out data page export, user can " data be led in client by clicking Button or corresponding control instruction is inputted by order line out ", to trigger data export request, and the data is exported Request is sent to server, so that server receives data export request, to make the preconfigured script of server can Request, which is exported, according to the data executes the derived operation of tables of data dynamic.

S20: inquiring database based on target data table id, obtain target allocation list corresponding with target data table id, Target allocation list includes at least two target configuration datas, and each target configuration data includes table ID, source table id and export word Section.

Target allocation list is based on after target data table id inquiry database, and what is got is corresponding with target data table id Conjunction advise allocation list.Specifically, server executes corresponding with the inquiry field using target data table id as inquiry field Query statement obtains target allocation list corresponding with target data table id from database.

Target configuration data is configuration data pre-configured in target allocation list, and each target configuration data can correspond to Export a tables of data.It include at least two target configuration datas i.e. in target allocation list, so that the target allocation list can be corresponding At least two tables of data are exported, it can be achieved that data page exports.

Specifically, each target configuration data includes table ID, source table id and derived field, can also include list name Claim, as shown in following table one.Wherein, table ID is the mark for each tables of data after the export of unique identification data page, such as table SHEET_1 and SHEET_2 in one.Source table id is the mark for set of source data derived from the unique identification data of being carried out, Such as 1001 and 1002 in table one.The set of source data is the tables of data for storing initial data, is to need to carry out data export Data source.Derived field is used to limit the field that the tables of data after paging export is included, such as Name, Age in table one With City etc..The derived field need to be field present in the corresponding set of source data of source table id, can not be successfully and lead to avoid data Out the problem of.Title is used to limit the title of the tables of data after paging export, such as " result exports paging 1 " in table one It is the title that the tables of data formed after data page export is carried out based on this entry mark configuration data of the SHEET_1.This implementation In example, in target allocation list, table ID is incremented by successively according to the line number in target allocation list, so that its table ID has uniquely Property, it avoids there are identical two table ID, so that its correspondence can not be uniquely determined when subsequent progress data page export Target configuration data.

One target allocation list of table

Table ID	Title	Source table id	Derived field
				SHEET_1	As a result paging 1 is exported	1001	Name, Age, City
SHEET_2	As a result paging 2 is exported	1002	Name, Level ... ..., Group

S30: each target configuration data in traversal target allocation list is based on source table id and derived field, acquisition and table The corresponding target query sentence of lattice ID.

Specifically, at least two target configuration datas in server traversal target allocation list, are configured based on each target Source table id and derived field in data obtain a target query sentence, so that the target query sentence is opposite with its table ID It answers.In the present embodiment, source table id can uniquely determine its corresponding set of source data, and derived field can limit the data after paging export The content that table is included produces corresponding target query sentence based on the source table id and derived field, so that each target is looked into One tables of data of export can be corresponded to by asking sentence.

S40: target data is obtained based on target query sentence, and target data is stored in EXCEL table, obtains and leads Target page table corresponding with table ID out.

Wherein, target data refers to the target query sentence using source table id and derived field formation, query source table id pair The set of source data answered obtains source data set data corresponding with derived field.Target page table is based on target dataform At EXCEL table, be that server executes the tables of data that gets after data page export operation.Each target configuration data is corresponding One target page table, in the present embodiment, the target configuration data in target allocation list includes at least two, so that its target paging Table includes at least two.

Specifically, server is being based on the corresponding set of source data of target query sentence query source table id, obtains target data Afterwards, which is stored in EXCEL table, to generate corresponding with table ID target page table, and by the target Page table export.It is each since the target data table id in the export request of this data contains at least two target configuration data Target configuration data produces and exports a target page table, so that server executes step in the case where this data exports request triggering The step of rapid S20-S40, this process can be preparatory by server, it can be achieved that dynamic exports the purpose of at least two target page tables The script of configuration executes automatically, without writing or modifying code, reduces code development quantity, and help to reduce code generation mistake Probability, thus be conducive to improve data page derived from efficiency, ensure the progress of project development.

Further, after exporting target page table, user can be based on the content and column of each column in target page table Sequence between column, orients whether target configuration data goes wrong.Specifically, user can intuitively find out target paging The content of each column in table and sequence between the column and the column, if the content of each column is empty or sequence between the column and the column It is problematic, target configuration data corresponding with the target page table in the target allocation list can be directly targeted to and be likely to occur mistake Accidentally, without consulting the reason of code is to find problem, the efficiency of project development is helped to improve.

In tables of data dynamic deriving method provided by the present embodiment, according to the target data table id in data export request Can quick search get target allocation list；Due to containing at least two target configuration data in target allocation list, according to each Source table id and derived field in target configuration data the corresponding target query sentence of quick obtaining, this process can be not necessarily to people automatically Work intervention helps to improve efficiency derived from data；It is inquired based on each target query sentence and obtains target data, by the target Data are stored in EXCEL table, can be obtained and be exported corresponding target page table.Due to including extremely in each target allocation list Few two target configuration datas, each target configuration data can export a target page table, so that the export request of each data can Quickly at least two target page tables of export, process are conducive to improve derived from data page without writing or modifying code Efficiency.It is subsequent after the completion of " dynamic exports " mentioned by the present embodiment refers to the initial code of the preconfigured script of server When carrying out data page export based on the script, it is not necessary to modify the codes of the script, need to only adjust the content of target allocation list, have Help largely reduce the workload of code in data page export process write and modified.

In one embodiment, it is based on source table id and derived field in step S30, obtains target corresponding with table ID and looks into Sentence is ask, specifically comprises the following steps: to handle source table id and derived field using SQL query statement create-rule, obtain Take target query sentence corresponding with table ID.

Wherein, SQL query statement create-rule is pre-set for being looked into according to source table id and derived field generation SQL Ask the rule of sentence.In the present embodiment, SQL query statement create-rule is specially " source Select derived field From table id ", Quickly source table id and derived field can be handled based on the SQL query statement create-rule, to generate target query sentence.

As shown in Table 1, for this target configuration data of SHEET_1, in use SQL query statement create-rule to source When table id and derived field are handled, " 1001 " this target query of Select Name, Age, City From can be got Sentence.Correspondingly, in step s 40, server is by executing " 1001 " this mesh of Select Name, Age, City From Query statement is marked, can be 1001 corresponding source data sets from source table id, inquiry gets Name, Age and City, and these three are led Name, Age and City these three derived fields target data corresponding with its is stored in by the corresponding target data of field out In EXCEL table, that is, target page table corresponding with SHEET_1 this table ID is produced, which can be with list name Title is named.

In the present embodiment, since server is stored with SQL query statement create-rule, so that it can be based on target allocation list In each target configuration data automatically generate corresponding target query sentence, be not necessarily to the corresponding code of manual compiling, with improve It is subsequent that target data is obtained based on the target query sentence, to obtain and export the efficiency of target page table.It is to be appreciated that step When traversing each target configuration data in target allocation list in rapid S30, each target is parsed by server background and configures number According to being handled by SQL query statement create-rule its source table id and derived field, phase can be got in server background The target query sentence answered writes corresponding query statement according to different derived fields and source table id without project development personnel, The workload that project development personnel write code is reduced, is also beneficial to reduce the probability of manual compiling code error.

In one embodiment, as shown in figure 3, obtaining target data based on target query sentence in step S40, and by mesh Mark data are stored in EXCEL table, are specifically comprised the following steps:

S41: inquiring set of source data corresponding with source table id based on target query sentence, obtains and leads from source data set The corresponding target data of field out.

Specifically, server according in each target configuration data source table id and derived field get corresponding mesh After marking query statement, set of source data corresponding with source table id is inquired using target query request, as 1001 pairs in table one The set of source data answered, to obtain the corresponding content of derived field as target data from the source data set.

Target data: being stored in EXCEL table by S42 using JAVA principle of reflection, is obtained and is exported opposite with table ID The target page table answered.

JAVA principle of reflection is, for any one class, can to know all properties of this class in operating status And method；For any one object, its any one method and attribute can be called；The information of this dynamic acquisition with And the function of the method for dynamic call object is known as the reflection mechanism of java language.

In the present embodiment, when server uses JAVA language to write preconfigured script in advance, so that the script is being held During row, it can be reflected using JAVA former after obtaining target data corresponding with derived field according to target query sentence Derived field and target data are stored in an EXCEL table by reason, to get target page table corresponding with table ID, and Target page table is exported.

In table one, server traverses target allocation list, first traversal this target configuration data of SHEET_1, in base In source table id and Name, after Age and City these three derived fields get target query sentence, according to target query language Sentence first obtains the corresponding set of source data LIST_1 of source table id, according to derived field Name, Age and City, is reflected using JAVA former Reason obtains the particular content of Name, Age and City these three derived fields in set of source data LIST_1 as target data, The corresponding target data of Name, Age and City these three derived fields is filled in EXCEL table, successively to form a target paging Table.Then, this target configuration data of SHEET_2 is traversed to obtain corresponding target page table, until the target allocation list In after all target configuration datas get corresponding target page table, all target page tables are exported.

In the present embodiment, the initial code of script derived from achievable data page is write using JAVA language in advance Afterwards, after server receives data export request, script operation is triggered, is exporting request mesh according to data to execute At least two target configuration datas in allocation list are marked, according to the source table id and derived field acquisition in each target configuration data After corresponding target query sentence, target data is obtained based on the data query sentence, using JAVA principle of reflection by number of targets According to being stored in EXCEL table, to obtain target page table corresponding with the target configuration data.In the present embodiment, server In pre-set script complete after initial code writes, during perform script is to realize derived from data page, Without writing or modifying the code of the script, at least two target page tables can be realized according to the content of target allocation list Dynamic exports, so that written in code or the workload of modification are greatly decreased in data page export process, is conducive to raising project The efficiency of exploitation.

In one embodiment, it when exporting due to data page, needs to export the target data table id in request based on data Database is inquired, obtains target allocation list corresponding with the target matrix, therefore, it is necessary to be pre-created to be stored at least one The database of a allocation list, the corresponding tables of data ID of each allocation list.As shown in figure 4, acquisition data i.e. in step slo Before the step of export request, the tables of data dynamic deriving method further include:

S51: obtaining paging configuring request, and paging configuring request includes original configuration table, and original configuration table includes at least two A original configuration data, each original configuration data include table ID, source table id and derived field.

Wherein, paging configuring request is can to carry out asking for allocation list derived from data page for trigger the server configuration It asks.Original configuration table is the allocation list that user voluntarily configures according to own service demand.Original configuration data are original configuration tables The configuration data that middle user voluntarily configures, can user determined according to own service demand and need the letter of tables of data derived from paging Breath.Each original configuration data include table ID, source table id and derived field, can also include title, as shown in Table 2. Table ID is the mark for carrying out the tables of data after data page export according to the original configuration data for unique identification.Source table id It is the mark for set of source data derived from the unique identification data page of being carried out.Derived field is for limiting paging export The tables of data field to be included.Title is used to limit the title of each tables of data after data page export.

In the present embodiment, user can send a paging configuring request, the paging configuring request to server by client It is middle to carry original configuration table as shown in Table 2, so that server obtains the original configuration table.It is original in the original configuration table The quantity of configuration data is that the quantity of tables of data derived from data page is carried out required for this paging configuring request.Original configuration The sequence between derived field in table is that data page exports sequence in the tables of data to be formed between field.

Two original configuration table of table

Table ID	Title	Source table id	Derived field
				SHEET_1	As a result paging 1 is exported	1001	Name, Age, City
SHEET_2	As a result paging 2 is exported	1002	Name, Level ... ..., Group
				SHEET_3	As a result paging 1 is exported	1001	Name, Age, City
SHEET_4	As a result paging 4 is exported	1001	Name, City, Age
				SHEET_5	As a result paging 5 is exported	1001	Name, Age, City
SHEET_6	As a result paging 6 is exported	1002	Name；Level；……；Group

S52: duplicate removal processing is carried out at least two original configuration data in original configuration table, obtains the first allocation list.

Since the original configuration table in this paging configuring request is the allocation list that user independently uploads, in original configuration table When the quantity of the original configuration data of middle configuration is more, it is understood that there may be the phenomenon that configuring is repeated, so that subsequent be directly based upon the original When beginning allocation list carries out data page export, in fact it could happen that therefore the problem of repeating export and influencing export efficiency, is getting After each paging configuring request, at least two in original configuration table that server need to carry the paging configuring request are original to be matched It sets data and carries out duplicate removal processing, obtain the first allocation list.Wherein, the first allocation list is to the original configuration number in original configuration table According to the allocation list obtained after duplicate removal processing.Specifically, duplicate removal processing is carried out at least two original configuration data, referred to pair Source table id and the identical at least two original configurations data of derived field are handled in original configuration data, so that the first configuration It only include the process of one of original configuration data in table.

S53: carrying out each original configuration data in the first allocation list to close rule verification, obtains and closes the conjunction that rule verification passes through Allocation list is advised, the storage of rule allocation list will be closed in the database.

It further include at least in first allocation list after the first allocation list for carrying out duplicate removal processing acquisition to original configuration table One original configuration data, each original configuration data are the configuration datas that user independently fills in, these original configuration data Fill in may not meet it is pre-set fill in specification, prevent it from by the pre-set script execution of server, so as to cause When the subsequent progress data page export based on first allocation list, there is the problem of export mistake.Therefore, it is needed in step S53 pair Each original configuration data in first allocation list carry out closing rule verification, advise allocation list to obtain the conjunction that conjunction rule verification passes through, make The conjunction rule allocation list in each original configuration data meet it is pre-set fill in specification, by the conjunction rule allocation list store In the database, there is the general of mistake when carrying out data page export with the conjunction rule allocation list reduced in the subsequent calls database Rate.

In tables of data dynamic deriving method provided by the present embodiment, pass through the original configuration carried to paging configuring request Duplicate removal processing is carried out between at least two original configuration data in table, to obtain the first allocation list, to avoid based on the first configuration At least two original configuration data in table carry out that repetition export operation need to be executed when data page export, to improve data point Efficiency derived from page.Then, by carrying out closing rule verification to each original configuration data in the first allocation list, rule are closed to retain The conjunction rule allocation list that all original configuration data passed through are formed is verified, so that subsequent carry out data point based on conjunction rule allocation list Error rate is reduced when page export, to improve efficiency derived from data page.It is to be appreciated that being configured by step S51-S53 In the database, each conjunction rule allocation list corresponds to a tables of data ID, so that subsequent led based on data for good conjunction rule allocation list storage The target data table id in request inquires corresponding conjunction rule allocation list as target allocation list out.

In one embodiment, original configuration data form ID, source table id, derived field and title.As shown in figure 5, Duplicate removal processing is carried out at least two original configuration data in original configuration table in step S52, obtains the first allocation list, specifically Include the following steps:

S521: judge that at least two original configuration data in original configuration table are complete with the presence or absence of source table id and derived field Exactly the same at least two repeat configuration data.

Specifically, server obtains original in the paging configuring request after getting this paging configuring request Allocation list (as shown in Table 2) judges at least two original configuration data in the original configuration table with the presence or absence of source table id and leads Field identical at least two repeats configuration data out.At least two repetitions configuration data refers to source table id and export word The identical at least two original configurations data of section.Due to subsequent in data page export process, it need to be configured based on target Source table id in data and derived field obtain target query sentence, if it exists source table id and derived field identical two Configuration data is repeated, the target query sentence that it may be made to be subsequently formed is identical, will lead to repetitive operation, so that its efficiency drops It is low.In the present embodiment, source table id identical with derived field not only includes that source table id is identical with the title of derived field, is also wrapped The sequence for including derived field is identical, because the sequence of derived field determines field in target page table derived from follow-up data paging Sequence.As shown in Table 2, table ID is source table id in the corresponding original configuration data of SHEET_1, SHEET_3 and SHEET_5 Identical with derived field, therefore, the corresponding original configuration data of SHEET_1, SHEET_3 and SHEET_5 compounding of attaching most importance to is set Data.But this original configuration data of SHEET_4 and these three original configuration data of SHEET_1, SHEET_3 and SHEET_5 The sequence of derived field is not identical, then it is not to repeat configuration data.

S522: source table id and derived field identical at least two repeat configuration data if it exists, then judge at least Whether the title in two repetition configuration datas is identical.

Target query sentence will form based on source table id and derived field due to subsequent, it is equal based on each target query sentence A target page table can be obtained, each target page table is named with title, therefore, there are source table id and export word When section identical at least two repeats configuration data, need to judge whether is title at least two repetition configuration datas It is identical.If the title of at least two repetition configuration datas is identical, the subsequent at least two repetition configuration datas that are based on can be led Content is identical out and the identical at least two targets page table of title.If the title of two repetition configuration datas is not identical, It is then subsequent to repeat two target page tables that configuration datas obtain in export based at least two, can export content is identical and name Claim at least two different target page tables, so that cause confusion during at least two target page table of subsequent calls, and Cause to duplicate operation in its data page export process, reduces efficiency derived from data page.

S523: if the title at least two repetition configuration datas is identical, retains a repetition configuration data, obtain Take the first allocation list.

Specifically, if at least two titles that repeat in configuration datas are identical, illustrate subsequent to be based at least two The target query sentence that the source table id and derived field for repeating configuration data are formed is identical, and at least two identical targets of execution are looked into The title that inquiry sentence gets at least two target page tables is also identical, at this point, need to only retain a repetition configuration data, The first allocation list that the removal from original configuration table repeats configuration data can be obtained.As shown in Table 2, SHEET_1, SHEET_3 Original configuration data corresponding with SHEET_5 are attached most importance to multiple configuration data, are repeated in configuration datas at these three, SHEET_1 and The title of SHEET_3 is identical, i.e., subsequent the two repetition configuration datas based on SHEET_1 and SHEET_3 are formed by mesh The title of mark page table is " result exports paging 1 ", and the two is identical, therefore can only retain one of them and repeat to match Data are set, to obtain the first allocation list, the subsequent original configuration data based in first allocation list are avoided to carry out data page When export, identical operation need to be repeated, influences efficiency derived from data page.

S524: if the title at least two repetition configuration datas is not identical, prompt information is generated, and will be prompted to Information is sent to the client of triggering paging configuring request, obtains the modification information of client feedback, is obtained based on modification information First allocation list.

Specifically, if the title at least two repetition configuration datas is not identical, illustrate subsequent based at least two The target query sentence that a source table id for repeating configuration data and derived field are formed is identical, executes at least two identical targets The title that query statement is got at least two target page tables is not identical, that is, understands that export content is identical and title is different At least two target page tables reduce data page so that carry out repetitive operation in subsequent progress data page export process Derived efficiency.

In the present embodiment, when the title that judgement at least two repeats configuration data is not identical, generation mentions server Show information, it is identical with derived field which prompts in this paging configuring request that there are source table ids in original configuration table, But different at least two repeated data of title.Then, the prompt information of generation is sent to and triggers this by server The client of paging configuring request so that user views the prompt information by the client, and feeds back corresponding modification letter Breath, the modification information are to delete at least two to repeat at least one of configuration data, repeat configuration number so that reservation is one of According to.Server obtains the first allocation list after getting the modification information of client feedback, based on the modification information.

In step S521-S524, it is identical at least that there are source table ids and derived field in determining original configuration table After two repetition configuration datas, whether the title according at least two repetition configuration datas is identical, at least two weights Configuration data carries out duplicate removal processing again, to obtain the first allocation list, to ensure that subsequent advised based on first allocation list acquisition conjunction is matched It after setting table, closes and does not include repetition configuration data in rule allocation list, so that avoiding carrying out weight when subsequent progress data page export Multiple export operation, improves efficiency derived from data page.

In one embodiment, as shown in fig. 6, in step S53 to each original configuration data in the first allocation list into Row closes rule verification, obtains and closes the conjunction rule allocation list that rule verification passes through, specifically comprises the following steps:

S531: judge in each original configuration data in the first allocation list, whether table id corresponding set of source data in source deposits In derived field.

Specifically, server is carrying out duplicate removal processing the first allocation list of acquisition to the original configuration data in original configuration table Afterwards, each original configuration data in the first allocation list need to be carried out closing rule verification, to determine each original in the first allocation list Beginning configuration data it is subsequent can by the preconfigured script execution of server, thus ensure it is subsequent based on original configuration data into It is gone on smoothly derived from row data page.

Since mesh need to be formed based on source table id and derived field when carrying out data page export based on original configuration data Query statement is marked, based on the corresponding set of source data of target query sentence inquiry acquisition source table id, thus acquisition and derived field Therefore corresponding target data need to verify in each original configuration data in advance, whether the corresponding source data set of source table id There are corresponding derived fields in original configuration data can not export respective counts when to avoid subsequent progress data page export According to so that data page export process malfunctions.

S532: if the corresponding source data set of source table id there are derived field, judge whether derived field whether include At least two derived fields.

Specifically, in each original configuration data, there are the original configuration data for the corresponding source data set of source table id When the derived field of middle setting, illustrate that the subsequent original configuration data that are based on can carry out data page export.Each original configuration It can configure a derived field in data, at least two derived fields can also be configured, if being configured at least two derived fields When, it needs to be separated using predetermined symbol between derived field and derived field.Predetermined symbol is pre-set cutting symbol, It, need to be by default symbol if the pre-set script of server recognizes the predetermined symbol in subsequent progress data page export Number former and later two derived fields are cut.In the present embodiment, which can be used comma, in each original configuration data When using comma as separator between middle any two derived field, then the original configuration data are closed rule verification and are passed through；Conversely, Rule verification is then closed not pass through.

It is to be appreciated that in each original configuration data, if table id corresponding source data set in source is matched there is no original When setting the corresponding derived field of data setting, prompt information need to be generated, which prompts the corresponding set of source data of source table id In be not present corresponding derived field.Further, which may also display the corresponding source data set of source table id and exists All fields, so that user selects.Then, which is sent to and triggers this paging configuring request by server Client so that user views the prompt information by the client, and feed back corresponding modification information.

S533: if derived field contains at least two derived field, judge the separation between any two derived field Whether symbol matches with predetermined symbol, if matching, obtains and closes the conjunction rule allocation list that rule verification passes through.

In the present embodiment, if the derived field of any original configuration data contains at least two derived field, it need to judge to appoint Whether the separator anticipated between two derived fields matches with predetermined symbol；If the separator between any two derived field Match with predetermined symbol, then obtains and close the conjunction rule allocation list that rule verification passes through；If the separation between any two derived field Symbol is not matched that with predetermined symbol, then prompt information is sent to the client for triggering this paging configuring request, to prompt user It is modified by client, until separator and default symbol in all original configuration data between any two derived field Number match.

If predetermined symbol is comma, the two original configuration data of SHEET_2 and SHEET_4 shown in table two include to Few three derived fields, due to using comma conduct between any two derived field of this original configuration data of SHEET_2 Separator matches with predetermined symbol, then the original configuration data are closed rule verification and passed through；And SHEET_4 this original configuration number According to any two derived field between using branch as separator, do not matched that with predetermined symbol, then need to generate prompt Information is simultaneously sent to the client for triggering this paging configuring request, to prompt user to modify corresponding separator, until this All original configuration data close rule verification when passing through in one allocation list, obtain and close the conjunction rule allocation list that rule verification passes through.

S534: it if derived field does not include at least two derived fields, obtains and closes the conjunction rule allocation list that rule verification passes through.

In the present embodiment, if in any original configuration tables of data, the corresponding source data set of source table id there are derived field, And derived field does not include at least two derived fields, then without judge separator between any two derived field whether with The step of predetermined symbol matches directly determines original configuration data conjunction rule verification and passes through.All originals in the first allocation list Beginning configuration data closes rule verification when passing through, and obtains and closes the conjunction rule allocation list that rule verification passes through.It is to be appreciated that conjunction rule configuration Table corresponds to a tables of data ID, and by tables of data ID and closes rule allocation list associated storage in tables of data, is based on data so as to subsequent Table id inquiry gets corresponding conjunction rule allocation list.

In step S531-S534, by each original in the first allocation list obtained after original configuration table duplicate removal processing Beginning configuration data carries out closing rule verification, allocation list is advised to obtain the conjunction that conjunction rule verification passes through, so that subsequent advised based on the conjunction is matched It sets and carries out going on smoothly derived from data page in table, the problem for occurring export mistake in data page export process is avoided to go out It is existing.Specifically, server, which first passes through the corresponding source data set of judgement source table id, whether there is corresponding derived field, to avoid The case where subsequent target query sentence formed based on source table id and derived field can not find corresponding target data appearance, It is gone on smoothly derived from follow-up data paging to ensure.Then, server exists in the corresponding source data set of source table id and leads Out when field, it need to guarantee that the separator and predetermined symbol between any two derived field match, so that subsequent carry out data When paging exports, field isolation can be carried out based on predetermined symbol, be conducive to go on smoothly derived from guarantee data page.

In one embodiment, after step S50 gets each conjunction rule allocation list, each conjunction rule allocation list configuration pair is given The tables of data ID answered, so that the corresponding tables of data ID of each conjunction rule allocation list, and conjunction rule allocation list is associated with tables of data ID Storage is in the database.After getting conjunction rule allocation list and conjunction rule allocation list is stored in database, user may root According to new business demand or other demands, allocation list need to be advised to the conjunction in database and modified, rule allocation list is closed with adjustment In original configuration data sequence, or source table id, derived field and title in each original configuration data of adjustment etc. Content, so that updated conjunction rule allocation list more meets user demand.

As shown in fig. 7, after step S50, i.e., after the step of closing the storage of rule allocation list in the database, the number Include the following steps: according to table dynamic deriving method

S61: data modification request is obtained, data modification request includes tables of data ID and modified logo to be modified.

Wherein, data modification request is the request modified for trigger the server pairing rule allocation list.Number to be modified It is used to determine that allocation list to be advised in the conjunction modified required for this data modification request according to table id.Modified logo, which refers to, to need to carry out The mark of operation is modified, each modified logo is corresponding with a Modification growth function.In the present embodiment, modified logo include delete mark, Increase mark and replacement mark.

S62: inquiring database according to tables of data ID, obtains conjunction rule allocation list corresponding with tables of data ID as to be modified Allocation list.

Specifically, server is looked into after getting data modification request based on the tables of data ID in the data modification request Database is ask, obtains conjunction rule allocation list corresponding with tables of data ID as allocation list to be modified.The allocation list to be modified is The conjunction rule allocation list modified required for this data modification request.

S63: modifying to allocation list to be modified using Modification growth function corresponding with modified logo, obtains modified Close rule allocation list.

Specifically, server is after obtaining allocation list to be modified, based on the modified logo pair in the data modification request The Modification growth function answered modifies to allocation list to be modified, to obtain modified conjunction rule configuration data.In the present embodiment, service Device can be modified according to the modified logo in the data modification request into corresponding information after receiving data modification request Interface receives user in the modification parameter of information modification interface input, which is passed to and the modified logo phase After corresponding Modification growth function, modified based on the Modification growth function to allocation list to be modified.

For example, it is to delete function that the deletion, which identifies corresponding Modification growth function, according to this if modified logo is to delete mark It deletes mark and enters corresponding information modification interface, so that user modifies the corresponding modification parameter of interface input in the information, such as An original configuration data need to be deleted, then it is table ID that it, which modifies parameter,；If you need to delete certain export in an original configuration data Field, then it modifies the derived field that parameter is table ID and required deletion.Server receive these modification parameters after, The modification parameter is transmitted into its corresponding deletion function, delete processing is carried out to allocation list to be modified using the deletion function, is obtained Modified conjunction rule allocation list is taken, so that modified conjunction rule allocation list more meets user demand.

For example, it is to increase function that the increase, which identifies corresponding Modification growth function, according to this if modified logo is to increase mark Increase mark and enter corresponding information modification interface, so that user modifies the corresponding modification parameter of interface input in the information, such as It need to increase by an original configuration data, then it is table ID, source table id and derived field that it, which modifies parameter,；If you need to increase by an original configuration Derived field in data, then it is table ID and required increased derived field that it, which modifies parameter,.Server is receiving these Modify parameter after, which is passed into its corresponding increase function, using increase function to allocation list to be modified into Row increase processing obtains modified conjunction and advises allocation list, so that modified conjunction rule allocation list more meets user demand.

For example, it is replacement function that the replacement, which identifies corresponding Modification growth function, if modified logo is replacement mark, replaced according to this Dehorn, which is known, enters corresponding information modification interface, so that user is in the corresponding modification parameter of information modification interface input；If you need to It modifies to the title in an original configuration data, then it is table ID and replaced title that it, which modifies parameter,； It modifies if you need to the derived field to an original configuration parameter, modification parameter is table ID and modified derived field. Server passes to its corresponding replacement function after receiving these modification parameters, by modification parameter, utilizes the replacement letter It is several that processing is replaced to allocation list to be modified, that is, the corresponding content of modification parameter before modifying is deleted, modification ginseng is replaced with The corresponding content of number, to obtain modified conjunction rule allocation list, so that modified conjunction rule allocation list more meets user demand.

In tables of data dynamic deriving method provided by the present embodiment, user can timely respond to use by step S61-S63 The demand at family closes rule allocation list in more new database, so that it more meets user demand.Data are being carried out based on conjunction rule allocation list When paging exports, script derived from the pre-set executable data page of server only needs pairing without carrying out code revision Original configuration parameter in rule allocation list is modified, and process can effectively reduce the written in code in project development process and repair The workload changed can help to the progress for accelerating project development.

It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit It is fixed.

In one embodiment, a kind of tables of data dynamic guiding device is provided, the tables of data dynamic guiding device and above-mentioned reality Tables of data dynamic deriving method in example is applied to correspond.As shown in figure 8, the tables of data dynamic guiding device includes export request Obtain module 10, target allocation list obtains module 20, query statement obtains module 30 and target page table obtains module 40.Each function Detailed description are as follows for energy module:

Request module 10 is exported, for obtaining data export request, data export request includes target matrix ID.

Target allocation list obtains module 20, for inquiring database, acquisition and target matrix based on target data table id The corresponding target allocation list of ID, target allocation list include at least two target configuration datas, and each target configuration data includes Table ID, source table id and derived field.

Query statement obtains module 30, for traversing each target configuration data in target allocation list, is based on source table id And derived field, obtain target query sentence corresponding with table ID.

Target page table obtains module 40, for obtaining target data based on target query sentence, and target data is deposited Storage obtains in EXCEL table and exports target page table corresponding with table ID.

Preferably, query statement obtains module 30, for source table id and exporting word using SQL query statement create-rule Duan Jinhang processing, obtains target query sentence corresponding with table ID.

Preferably, it includes target data acquiring unit 41 and page table acquiring unit 42 that target page table, which obtains module 40,.

Target data acquiring unit 41, for inquiring set of source data corresponding with source table id based on target query sentence, Target data corresponding with derived field is obtained from source data set.

Page table acquiring unit 42 is obtained simultaneously for target data to be stored in EXCEL table using JAVA principle of reflection Export target page table corresponding with table ID.

Preferably, tables of data dynamic guiding device further includes configuring request acquiring unit 51, duplicate removal processing unit 52 and closes Advise verification unit 53.

Configuring request acquiring unit 51, for obtaining paging configuring request, paging configuring request includes original configuration table, former Beginning allocation list includes at least two original configuration data, and each original configuration data include table ID, source table id and derived field.

Duplicate removal processing unit 52, for carrying out duplicate removal processing at least two original configuration data in original configuration table, Obtain the first allocation list.

Rule verification unit 53 is closed, rule verification is closed for carrying out to each original configuration data in the first allocation list, obtains The conjunction rule allocation list that rule verification passes through is closed, the storage of rule allocation list will be closed in the database.

Preferably, original configuration data further include title.

Duplicate removal processing unit 52 includes repeating judgment sub-unit 521, title judgment sub-unit 522, the first duplicate removal processing list Member 523 and the second duplicate removal processing unit 524.

Judgment sub-unit 521 is repeated, at least two original configuration data for judging in original configuration table whether there is Source table id and derived field identical at least two repeat configuration data.

Title judgment sub-unit 522 repeats to match for source table id if it exists and derived field identical at least two Data are set, then judge whether the title at least two repetition configuration datas is identical.

First duplicate removal processing unit 523 retains if the title repeated in configuration data at least two is identical One repetition configuration data obtains the first allocation list.

Second duplicate removal processing unit 524 is given birth to if the title repeated in configuration data at least two is not identical It at prompt information, and will be prompted to the client that information is sent to triggering paging configuring request, obtain the modification letter of client feedback Breath obtains the first allocation list based on modification information.

Preferably, close rule verification unit 53 include field there are judgment sub-unit 531, field quantity judgment sub-unit 532, First, which closes rule verification subelement 533 and second, closes rule verification subelement 534.

There are judgment sub-units 531 for field, for judging in each original configuration data in the first allocation list, source table id Corresponding set of source data whether there is derived field.

Field quantity judgment sub-unit 532 judges if there are derived fields for the corresponding source data set of source table id Whether whether derived field contains at least two derived field.

First, which closes rule verification subelement 533, judges any two if containing at least two derived field for derived field Whether the separator between a derived field matches with predetermined symbol, if matching, obtains and closes the conjunction that rule verification passes through Advise allocation list.

Second closes rule verification subelement 534, if not including at least two derived fields for derived field, obtains conjunction rule Verify the conjunction rule allocation list passed through.

Preferably, each corresponding tables of data ID of conjunction rule allocation list.

Tables of data dynamic guiding device further includes modification request unit 61, allocation list acquiring unit 62 to be modified and matches Set table modification processing unit 63.

Request unit 61 is modified, for obtaining data modification request, data modification request includes tables of data ID, table ID and modified logo.

Allocation list acquiring unit 62 to be modified obtains opposite with tables of data ID for inquiring database according to tables of data ID The conjunction rule allocation list answered is as allocation list to be modified.

Allocation list modifies processing unit 63, for using Modification growth function corresponding with modified logo to allocation list to be modified It modifies, obtains modified conjunction and advise allocation list.

Specific restriction about tables of data dynamic guiding device may refer to above for tables of data dynamic deriving method Restriction, details are not described herein.Modules in above-mentioned tables of data dynamic guiding device can be fully or partially through software, hard Part and combinations thereof is realized.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, It can also be stored in a software form in the memory in computer equipment, execute the above modules in order to which processor calls Corresponding operation.

In one embodiment, a kind of computer equipment is provided, which can be server, internal junction Composition can be as shown in Figure 9.The computer equipment include by system bus connect processor, memory, network interface and Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating The database of machine equipment is used to close other numbers formed in rule allocation list and target page table and data page export process According to.The network interface of the computer equipment is used to communicate with external terminal by network connection.The computer program is processed To realize a kind of tables of data dynamic deriving method when device executes.

In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory And the computer program that can be run on a processor, processor perform the steps of acquisition data and lead when executing computer program It requests out, data export request includes target matrix ID；Database, acquisition and target data are inquired based on target data table id The corresponding target allocation list of table id, target allocation list include at least two target configuration datas, each target configuration data packet Include table ID, source table id and derived field；Each target configuration data in target allocation list is traversed, source table id and export are based on Field obtains target query sentence corresponding with table ID；Target data is obtained based on target query sentence, and by number of targets According to being stored in EXCEL table, obtains and export target page table corresponding with table ID.

In one embodiment, it performs the steps of to generate using SQL query statement when processor executes computer program and advise Then source table id and derived field are handled, obtain target query sentence corresponding with table ID.

In one embodiment, it performs the steps of when processor executes computer program and is inquired based on target query sentence Set of source data corresponding with source table id obtains target data corresponding with derived field from source data set；Using JAVA Target data is stored in EXCEL table by principle of reflection, is obtained and is exported target page table corresponding with table ID.

In one embodiment, before the step of obtaining data export request, processor goes back reality when executing computer program Existing following steps: obtaining paging configuring request, and paging configuring request includes original configuration table, and original configuration table includes at least two Original configuration data, each original configuration data include table ID, source table id and derived field；To in original configuration table at least Two original configuration data carry out duplicate removal processing, obtain the first allocation list；To each original configuration data in the first allocation list It carries out closing rule verification, obtains and close the conjunction rule allocation list that rule verification passes through, the storage of rule allocation list will be closed in the database.

In one embodiment, original configuration data further include title.Processor execute computer program when realize with Lower step: judge that at least two original configuration data in original configuration table are identical with derived field with the presence or absence of source table id At least two repeat configuration datas；Source table id and derived field identical at least two repeat configuration data if it exists, Then judge whether the title at least two repetition configuration datas is identical；If at least two repeat the table in configuration data Title is identical, then retains a repetition configuration data, obtains the first allocation list；If at least two repeat the table in configuration data Title is not identical, then generates prompt information, and will be prompted to the client that information is sent to triggering paging configuring request, obtains client The modification information for holding feedback obtains the first allocation list based on modification information.

In one embodiment, processor execute computer program when perform the steps of judge it is every in the first allocation list In one original configuration data, table id corresponding set of source data in source whether there is derived field；If the corresponding set of source data of source table id In there are derived fields, then judge whether derived field contains at least two derived field；If derived field includes at least Two derived fields, then judge whether the separator between any two derived field matches with predetermined symbol, if matching, It obtains and closes the conjunction rule allocation list that rule verification passes through；If derived field does not include at least two derived fields, conjunction rule are obtained Verify the conjunction rule allocation list passed through.

In one embodiment, each corresponding tables of data ID of conjunction rule allocation list.Database is stored in rule allocation list will be closed In step after, processor execute computer program when also perform the steps of acquisition data modification request, data modification is asked It asks including tables of data ID, table ID and modified logo；Database is inquired according to tables of data ID, is obtained corresponding with tables of data ID Rule allocation list is closed as allocation list to be modified；Allocation list to be modified is repaired using Modification growth function corresponding with modified logo Change, obtains modified conjunction and advise allocation list.

In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated Machine program performs the steps of when being executed by processor obtains data export request, and data export request includes target matrix ID；Database is inquired based on target data table id, obtains target allocation list corresponding with target data table id, target allocation list Including at least two target configuration datas, each target configuration data includes table ID, source table id and derived field；Traverse target Each target configuration data in allocation list is based on source table id and derived field, obtains target query corresponding with table ID Sentence；Target data is obtained based on target query sentence, and target data is stored in EXCEL table, obtain and is exported and table The corresponding target page table of lattice ID.

In one embodiment, it performs the steps of when computer program is executed by processor and is generated using SQL query statement Rule handles source table id and derived field, obtains target query sentence corresponding with table ID.

In one embodiment, it performs the steps of when computer program is executed by processor and is looked into based on target query sentence Set of source data corresponding with source table id is ask, obtains target data corresponding with derived field from source data set；Using Target data is stored in EXCEL table by JAVA principle of reflection, is obtained and is exported target page table corresponding with table ID.

In one embodiment, before the step of obtaining data export request, when computer program is executed by processor also It performs the steps of and obtains paging configuring request, paging configuring request includes original configuration table, and original configuration table includes at least two A original configuration data, each original configuration data include table ID, source table id and derived field；To in original configuration table extremely Few two original configuration data carry out duplicate removal processing, obtain the first allocation list；To each original configuration number in the first allocation list Verification is advised according to close, conjunction rule is obtained and verifies the conjunction rule allocation list passed through, will close and advise allocation list storage in the database.

In one embodiment, original configuration data further include title.Reality is gone back when computer program is executed by processor Existing following steps: judge that at least two original configuration data in original configuration table are complete with the presence or absence of source table id and derived field Identical at least two repeat configuration data；Source table id and derived field identical at least two repeat configuration number if it exists According to whether the title for then judging that at least two repeat in configuration datas is identical；If at least two repeat in configuration data Title is identical, then retains a repetition configuration data, obtains the first allocation list；If at least two repeat in configuration data Title is not identical, then generates prompt information, and will be prompted to the client that information is sent to triggering paging configuring request, obtains The modification information of client feedback obtains the first allocation list based on modification information.

In one embodiment, it performs the steps of and is judged in the first allocation list when computer program is executed by processor In each original configuration data, table id corresponding set of source data in source whether there is derived field；If the corresponding source data of source table id There are derived fields for concentration, then judge whether derived field contains at least two derived field；If derived field includes extremely Few two derived fields, then judge whether the separator between any two derived field matches with predetermined symbol, if phase Match, obtains and close the conjunction rule allocation list that rule verification passes through；If derived field does not include at least two derived fields, conjunction is obtained The conjunction rule allocation list that rule verification passes through.

In one embodiment, each corresponding tables of data ID of conjunction rule allocation list.Database is stored in rule allocation list will be closed In step after, acquisition data modification request, data modification are also performed the steps of when computer program is executed by processor Request includes tables of data ID, table ID and modified logo；Database is inquired according to tables of data ID, is obtained corresponding with tables of data ID Conjunction rule allocation list as allocation list to be modified；Allocation list to be modified is carried out using Modification growth function corresponding with modified logo Modification obtains modified conjunction and advises allocation list.

Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, To any reference of memory, storage, database or other media used in each embodiment provided herein, Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms, Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..

It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing The all or part of function of description.

The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to the foregoing embodiments Invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each implementation Technical solution documented by example is modified or equivalent replacement of some of the technical features；And these modification or Replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all include Within protection scope of the present invention.

Claims

1. a kind of tables of data dynamic deriving method characterized by comprising

Database is inquired based on the target data table id, obtains target allocation list corresponding with the target data table id, The target allocation list includes at least two target configuration datas, and each target configuration data includes table ID, source table id And derived field；

Each target configuration data in the target allocation list is traversed, the source table id and the derived field are based on, Obtain target query sentence corresponding with the table ID；

Target data is obtained based on the target query sentence, and the target data is stored in EXCEL table, obtains and leads Target page table corresponding with the table ID out.

2. tables of data dynamic deriving method as described in claim 1, which is characterized in that described based on the source table id and described Derived field obtains target query sentence corresponding with the table ID, comprising:

The source table id and the derived field are handled using SQL query statement create-rule, obtained and the table The corresponding target query sentence of ID.

3. tables of data dynamic deriving method as described in claim 1, which is characterized in that described to be based on the target query sentence Target data is obtained, and the target data is stored in EXCEL table, comprising:

Set of source data corresponding with the source table id is inquired based on the target query sentence, is obtained from the source data set Target data corresponding with the derived field；

The target data is stored in EXCEL table using JAVA principle of reflection, obtain and is exported is opposite with the table ID The target page table answered.

4. tables of data dynamic deriving method as described in claim 1, which is characterized in that in the acquisition data export request Before step, the tables of data dynamic deriving method further include:

Paging configuring request is obtained, the paging configuring request includes original configuration table, and the original configuration table includes at least two A original configuration data, each original configuration data include table ID, source table id and derived field；

Duplicate removal processing is carried out at least two original configuration data in the original configuration table, obtains the first allocation list；

Each original configuration data in first allocation list are carried out to close rule verification, the conjunction rule that conjunction rule verification passes through is obtained and matches Table is set, in the database by the storage of conjunction rule allocation list.

5. tables of data dynamic deriving method as claimed in claim 4, which is characterized in that the original configuration data further include table Lattice title；

At least two original configuration data in the original configuration table carry out duplicate removal processing, obtain the first configuration Table, comprising:

Judge that at least two original configuration data in the original configuration table are complete with the presence or absence of source table id and derived field Exactly the same at least two repeat configuration data；

Source table id and derived field identical at least two repeat configuration data if it exists, then judge that at least two is described heavy Whether the title in multiple configuration data is identical；

If at least two titles repeated in configuration data are identical, retain the repetition configuration data, obtain Take the first allocation list；

If at least two titles repeated in configuration datas are not identical, prompt information is generated, and by the prompt Information is sent to the client for triggering the paging configuring request, obtains the modification information of the client feedback, based on described Modification information obtains the first allocation list.

6. tables of data dynamic deriving method as claimed in claim 4, which is characterized in that described in first allocation list Each original configuration data carry out closing rule verification, obtain and close the conjunction rule allocation list that rule verification passes through, comprising:

Judge in each original configuration data in first allocation list, the corresponding set of source data of the source table id whether there is The derived field；

If there are the derived fields for the corresponding source data set of the source table id, judge whether the derived field wraps Containing at least two derived fields；

If the derived field contains at least two derived field, the separator between derived field described in any two is judged Whether match with predetermined symbol, if matching, obtains and close the conjunction rule allocation list that rule verification passes through；

If the derived field does not include at least two derived fields, obtains and close the conjunction rule allocation list that rule verification passes through.

7. tables of data dynamic deriving method as claimed in claim 4, which is characterized in that each conjunction rule allocation list corresponding one Tables of data ID；

After described the step of storing conjunction rule allocation list in the database, the tables of data dynamic deriving method includes Following steps:

Data modification request is obtained, the data modification request includes tables of data ID, table ID and modified logo；

Database is inquired according to the tables of data ID, obtains conjunction rule allocation list corresponding with the tables of data ID as to be modified Allocation list；

It is modified, is obtained modified to the allocation list to be modified using Modification growth function corresponding with the modified logo Close rule allocation list.

8. a kind of tables of data dynamic guiding device characterized by comprising

Target allocation list obtains module, for inquiring database based on the target data table id, obtains and the target data The corresponding target allocation list of table id, the target allocation list include at least two target configuration datas, and each target is matched Setting data includes table ID, source table id and derived field；

Query statement obtains module, for traversing each target configuration data in the target allocation list, based on described Source table id and the derived field obtain target query sentence corresponding with the table ID；

Target page table obtains module, for obtaining target data based on the target query sentence, and by the target data It is stored in EXCEL table, obtains and exports target page table corresponding with the table ID.

9. a kind of computer equipment, including memory, processor and storage are in the memory and can be in the processor The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to The step of any one of 7 tables of data dynamic deriving method.

10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists In realization tables of data dynamic deriving method as described in any one of claim 1 to 7 when the computer program is executed by processor The step of.