CN110413974A - Form template configuration and device, table deriving method and device - Google Patents
Form template configuration and device, table deriving method and device Download PDFInfo
- Publication number
- CN110413974A CN110413974A CN201910686161.3A CN201910686161A CN110413974A CN 110413974 A CN110413974 A CN 110413974A CN 201910686161 A CN201910686161 A CN 201910686161A CN 110413974 A CN110413974 A CN 110413974A
- Authority
- CN
- China
- Prior art keywords
- template
- form template
- gauge outfit
- content
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Stored Programmes (AREA)
Abstract
This application provides a kind of form template configuration methods, this method passes through display form template configuration interface, user is inputted form template and template name by related control according to the interface, it is sent again by the form template that related control is inputted user to configuration equipment, configuration equipment parses form template, to obtain the template content of the form template, to save the template content and template name of the form template.In this method, form template configuration interface is shown to user by visualization interface, form template is directed into configuration equipment by user according to the related control in form template configuration interface, saves the process of configuration personnel manual compiling form template code, configuration mode is relatively simple.
Description
Technical field
This application involves technical fields derived from table, lead more particularly to a kind of configuration of form template and device, table
Method and device out.
Background technique
Table is commonly used in daily work, is able to record, stores various data, can be convenient for users to logarithm
According to processing.The data inconvenience that data can intuitively be shown, and be stored in database profession by table for showing, because
This, the data which shows can be exported by way of table.But the data in database are passed through into table
Form export, needs in advance to configure form template, then by configured form template in conjunction with data, generates complete table
Lattice, and then export the table.
It is currently, there are a kind of form template configuration method, this method is write the code of form template by developer in advance,
The code is saved again, completes configuration.For user when calling the form template, reading from the storage equipment for storing the code should
Code, according to the code building form template.
But in above table template configuration method, the process that form template is written as code is too cumbersome.
Summary of the invention
In view of this, this application provides a kind of form template configuration method, table deriving method, to solve among the above to
Form template is written as the too cumbersome problem of process of code.
In addition, present invention also provides a kind of configuration of form template, tables to export relevant apparatus, to guarantee the method
Application and realization in practice.
In order to achieve the object, technical solution provided by the present application is as follows:
In a first aspect, it is applied to configuration equipment this application provides a kind of form template configuration method, this method comprises:
Show form template configuration interface；Wherein the form template configuration interface includes form template title input control
And form template input control；
The template name and acquisition user that acquisition user is inputted by the form template title input control pass through institute
State the form template of form template input control input；
The form template is parsed, to obtain the template content of the form template；The wherein template content
It is identified including gauge outfit content, gauge outfit pattern and business datum；
Save the template name and the corresponding template content of the template name.
Second aspect, this application provides a kind of table deriving methods, are applied to client, this method comprises:
The export of target data is instructed in response to user, the template name of multiple form templates is provided；The wherein table
The template content of grid template is obtained after parsing by the form template inputted to form template input control；
Obtain the target template title of user's selection；
Generate the query sentence of database to the target data；
Target template title and the query sentence of database are encapsulated in table export request and are sent to server.
The third aspect, this application provides a kind of table deriving methods, are applied to server, this method comprises:
After receiving the table export request to business datum, target template name is extracted from table export request
Claim；
In the template content pre-saved, the corresponding template content of the target template title is searched；The wherein mould
Plate content is obtained after parsing by the form template inputted to form template input control, and the template content includes table
Head content, gauge outfit pattern and business datum mark；
The business datum is inquired from database, the business datum includes the storage mark of business datum in the database
The content of knowledge and business datum；
In the business datum mark of the template content, target service data mark corresponding with the storage mark is determined
Know；
Gauge outfit is generated according to the gauge outfit content and the gauge outfit pattern, and by the fills of the business datum to institute
It states in the corresponding column of target service Data Identification, to obtain derived table.
Fourth aspect, this application provides a kind of form template configuration devices, are applied to configuration equipment, which includes:
Configuration interface display module, for showing form template configuration interface；The wherein form template configuration interface packet
Include form template title input control and form template input control；
Template obtains module, for obtain user by template name that the form template title input control inputs with
And it obtains user and passes through the form template that the form template input control inputs；
Template parsing module, for being parsed to the form template, to obtain the template content of the form template；
Wherein the template content includes gauge outfit content, gauge outfit pattern and business datum mark；
Template preserving module, for saving the template name and the corresponding template content of the template name.
5th aspect, this application provides a kind of table guiding devices, are applied to client, which includes:
Respond module is instructed, for instructing in response to user to the export of target data, provides the mould of multiple form templates
Board name；Wherein the template content of the form template is after being parsed by the form template inputted to form template input control
It obtains；
Template name obtains module, for obtaining the target template title of user's selection；
Query statement generation module, for generating the query sentence of database to the target data；
Request sending module is exported, is led for target template title and the query sentence of database to be encapsulated in table
Server is sent in request out.
6th aspect, this application provides a kind of table guiding devices, are applied to server, which includes:
Request receiving module is exported, after receiving the table export request to business datum, is exported from the table
Target template title is extracted in request；
Template content enquiry module, it is corresponding in the template content pre-saved, searching the target template title
Template content；Wherein the template content is obtained after being parsed by the form template inputted to form template input control
, and the template content includes gauge outfit content, gauge outfit pattern and business datum mark；
Business datum enquiry module, for inquiring the business datum from database, the business datum includes business
The storage of data in the database identifies and the content of business datum；
Determining module is identified, it is determining to identify with the storage pair in the business datum of template content mark
The target service Data Identification answered；
Table generation module, for generating gauge outfit according to the gauge outfit content and the gauge outfit pattern, and by the business
The fills of data are into the corresponding column of the target service Data Identification, to obtain derived table.
As shown from the above technical solution, this application provides a kind of form template configuration method, this method passes through display table
Grid template configuration interface, user are inputted form template and template name by related control according to the interface, then by correlation
The form template that control is inputted user is sent to configuration equipment, and configuration equipment parses form template, to obtain the table
The template content of grid template, to save the template content and template name of the form template.In this method, pass through visualization
Form template configuration interface is shown to user by interface, and user is according to the related control in form template configuration interface by table mould
Plate is directed into configuration equipment, saves the process of configuration personnel manual compiling form template code, and configuration mode is relatively simple.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of application for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is the flow chart of form template configuration method provided by the present application；
Fig. 2 is the schematic diagram of form template configuration interface provided by the present application；
Fig. 3 is the flow chart of table deriving method provided by the present application；
Fig. 4 is the flow chart of another table deriving method provided by the present application；
Fig. 5 is the structural schematic diagram of form template configuration device provided by the present application；
Fig. 6 is the structural schematic diagram of table guiding device provided by the present application；
Fig. 7 is the structural schematic diagram of another table guiding device provided by the present application.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall in the protection scope of this application.
In the prior art, server can store and management table template.The side of configuration form template on the server
Formula is that the code of developer's hand-coding form template, server saves the code, to save form template.
But the form template configuration method is too cumbersome.
For this purpose, this method can be applied in configuration equipment, configuration this application provides a kind of form template configuration method
Equipment can be specially server.Referring to Fig. 1, this method specifically includes step S101-S104.Wherein:
S101: display form template configuration interface；Wherein form template configuration interface includes the input control of form template title
Part and form template input control.
Specifically, form template configuration interface is the visualization interface that can be interacted with user.Form template configuration
The human-computer interaction interface in application program can be set in interface, the human-computer interaction interface in webpage also can be set, herein no longer
It illustrates.
It should be noted that form template configuration interface is there are the input control of multiple information relevant to form template,
Such as text control, button control.Referring to fig. 2, input control can specifically include: template name input control, identifier
Input control, form template input control, gauge outfit line number input control, query sentence of database input control etc., wherein template
Title input control, identifier input control, gauge outfit line number input control and query sentence of database input control can be with
It is text-entry control, for inputting character and character string.The identifier of identifier input control input is that form template exists
Unique identification in database.
S102: the template name and acquisition user that acquisition user is inputted by form template title input control pass through table
The form template of grid template input control input.
It should be noted that input control is the module interacted with user, as the template name of form template inputs
Control, the input control can be text-entry control, and user inputs defined template name in text input control
Text.Configuration equipment obtains the form template relevant information that user is inputted by input control by this method.
Specifically, user passes through the template name of template name input control List of input template；It is defeated by form template
Enter control List of input template, the template relevant information that user is inputted based on correlated inputs control is received by configuration equipment.
It should be noted that table input control can directly be saved the form template that user is inputted by configuration equipment
It uses, which is able to solve the problem of developer writes the code of form template manually.
After form template relevant information is input to correlated inputs control by form template configuration interface by user, configuration
Equipment can obtain form template relevant information.
S103: parsing form template, to obtain the template content of form template；Wherein template content includes gauge outfit
Content, gauge outfit pattern and business datum mark.
Specifically, meter is converted by the relevant information for the form template that user is inputted by input control by analytical tool
Calculation machine identifiable language, such as converts binary number for the relevant information of form template.It is available after form template parsing
The template content of form template, and gauge outfit content, gauge outfit pattern and business datum mark are determined from template content.
It should be noted that template name can also be by configuring equipment processing, i.e., treatment process is that template name is defeated
Enter the template name that control sends over and converts binary stream data for text information by way of parsing.
In one example, form template is parsed, to obtain the template content of form template, is specifically included as follows
Step:
Form template is converted into HTML document；HTML document is parsed, is obtained in gauge outfit
Hold, gauge outfit pattern and business datum identify.
Specifically, user is sent out the form template by form template input control List of input template, the input control
Form template will be parsed, before parsing, need after configuration equipment receives the form template by giving configuration equipment
By form template by conversion tool (such as Open-Source Tools) translate into HTML (Hyper Text Markup Language, surpass
Text mark up language) file, it is not lost with all information guaranteed in table (possible if directly being parsed to form template
The partial information that will lead in form template is lost, such as the background color of form template), and then again lead to the html file after conversion
Analytical tool (such as analytical function) is crossed to be parsed, with obtain gauge outfit content corresponding with the form template, gauge outfit pattern and
The binary stream data of business datum mark.
Equipment is configured other than handling form template, it can also be to the table inputted based on other input controls
Other relevant informations of grid template are handled, such as the template name of the form template.
S104: template name and the corresponding template content of template name are saved.
Specifically, after obtaining template content by above-mentioned steps, the template content of form template is obtained, and protected
It deposits, and the other information of the form template, such as template name information, it is corresponding with the form template.
It should be noted that the template content of form template can save in the database, the template name in database
It can be identical, but in order to guarantee uniqueness that form template identifies in the database, need to add unique identifier.Specifically
Identifier input control to be arranged in form template configuration interface, user can pass through the input control input identifier.
As shown from the above technical solution, this application provides a kind of form template configuration method, this method passes through display table
Grid template configuration interface, user are inputted form template and template name by related control according to the interface, then by correlation
The form template that control is inputted user is sent to configuration equipment, and configuration equipment parses form template, to obtain the table
The template content of grid template, to save the template content and template name of the form template.In this method, pass through visualization
Form template configuration interface is shown to user by interface, and user is according to the related control in form template configuration interface by table mould
Plate is directed into configuration equipment, saves the process of configuration personnel manual compiling form template code, and configuration mode is relatively simple.
In one example, form template configuration interface further include: query sentence of database input control and/or gauge outfit row
Number input control, then form template configuration method can also specifically comprise the following steps:
In the case where including query sentence of database input control, form template configuration method can also include:
Obtain the query sentence of database that user is inputted by query sentence of database input control；Save template name pair
The query sentence of database answered.
Specifically, user's input data library inquiry in the query sentence of database input control of form template configuration interface
The query sentence of database is sent to configuration equipment by sentence, the input control, and configuration equipment receives the data base querying language
After sentence, the query sentence of database is saved.
It should be noted that the query sentence of database can for sky, i.e., user form template configuration interface can not
Add the query sentence of database.
In the case where being included in gauge outfit line number input control, form template configuration method can also include: to obtain user
The gauge outfit line number inputted by gauge outfit line number input control.Specifically, user is defeated in the gauge outfit line number of form template configuration interface
Enter input gauge outfit line number in control, which is sent to configuration equipment for the gauge outfit line number, so that it is determined that the form template
Gauge outfit line number.
In such cases, the form template is parsed, to obtain the specific implementation of the template content of form template
Mode are as follows: since the first trip of form template, extract the corresponding list data of gauge outfit line number and solved as gauge outfit, and to gauge outfit
Analysis, to obtain gauge outfit content and gauge outfit pattern；In the next line table of gauge outfit, extracts each mark and be used as business datum mark
Know.
Specifically, after configuration equipment receives the gauge outfit line number, line number shared by the gauge outfit of the form template is determined, from
And determine the height of the gauge outfit.Assuming that gauge outfit line number is 8, after configuration equipment receives the gauge outfit line number, determination is opened from the 1st row
Begin, the part terminated to eighth row is gauge outfit part, to parse to form template, i.e., the 1st row is to the 8th in form template
Capable list data is gauge outfit data, and the content and pattern of gauge outfit are obtained after parsing.Include in gauge outfit content, that is, gauge outfit is interior
Hold, gauge outfit pattern may include line number shared by gauge outfit and columns, the frame of gauge outfit, the shading of gauge outfit, gauge outfit line color
Etc..
It should be noted that form template includes: gauge outfit part and business datum part.As shown in table 1, in the table
In template, the first row and the second behavior gauge outfit part, a line below gauge outfit are business datum mark, such as unitName, table
Show cooperation organization, specific business datum such as so-and-so company, so-and-so unit.As shown in table 1, gauge outfit content includes: mark
Topic " cooperation unit register " and the title " cooperation unit " respectively arranged, " cooperation flat type ", " cooperation unit graduation " ... " connection
It is phone " etc..
It regard the business datum mark below gauge outfit as variable, is used for when exporting business datum, by derived business number
According to corresponding with the variable.
Table 1
Configured form template can be used for exporting actual business datum.In practical applications, when user wants to export
When certain data, interface where logging in the data in client is provided with export grid control in the page, such as exports table and presses
Button, user start the export of table by clicking export table button.
This application provides a kind of table deriving method, this method is applied to client.Referring to Fig. 3, this method is specifically wrapped
Include step S301-S304.Wherein:
S301: the export of target data is instructed in response to user, the template name of multiple form templates is provided；Wherein table
The template content of grid template is obtained after parsing by the form template inputted to form template input control.
Specifically, user is based on export control and issues export instruction, after export control receives export instruction, from server
The template name for being stored in multiple form templates of server is extracted, and is shown in interface where target data.
It should be noted that the template name of form template and form template is by user in form template configuration interface
In correlated inputs control input, and the relevant information that correlated inputs control is inputted user is sent to server, by taking
Business device saves, and specifically can refer to above-described embodiment, no longer illustrates herein.
Based on the export instruction that user is inputted, client can execute two pieces thing, one is starting display control, will store
The template name of form template in server is shown；Second is that generating the query sentence of database of target data.Specifically
As described in step S302, S303.
S302: the target template title of user's selection is obtained.
Specifically, it is instructed according to the export that user is inputted, the template name for being stored in server is passed through into display control
It is shown in the display interface of client, user selects some template name in the display control, for ease of description, can incite somebody to action
The template name of user's selection is known as target template title.Client is sent to after encapsulating target template title selected by user
Server.
It should be noted that target data is stored in the database of server.
S303: the query sentence of database to target data is generated.
Specifically, for user after client inputs export instruction, client, which can generate, looks into the database of target data
Ask sentence.
Server can inquire the target data according to the query sentence of database in the database.
S304: target template title and query sentence of database are encapsulated in table export request and are sent to service
Device.
Specifically, client will show that control target template title generated and query sentence of database are packaged into table
Lattice export request, is sent to server.Wherein, the mode of encapsulation can be diversified forms, no longer illustrate herein.
As shown from the above technical solution, this application provides a kind of table deriving method, this method passes through in response to user
Export instruction to target data, provides the template name of multiple form templates；Wherein the template content of form template is to pass through
It is obtained after parsing to the form template of form template input control input；Obtain the target template title of user's selection；It generates
To the query sentence of database of target data；Target template title and query sentence of database are encapsulated in table export request
In be sent to server.Form template in this method is based in the form template configuration interface of visualization interface by user
Template input control is directed into configuration equipment, saves the process of configuration personnel manual compiling form template code, configuration mode
It is relatively simple.
This application provides a kind of table deriving method, this method is applied to server.Referring to Fig. 5, this method is specifically wrapped
Include step S401-S405.Wherein:
S401: after receiving the table export request to business datum, target template name is extracted from table export request
Claim.
Specifically, table export request includes: the query sentence of database of target template title and target data.Service
After device receives table export request, target template title is extracted from the request.
S402: in the template content pre-saved, the corresponding template content of target template title is searched；Wherein in template
Appearance be it is obtained after parsing by the form template inputted to form template input control, and template content include gauge outfit content,
Gauge outfit pattern and business datum mark.
It should be noted that the generating mode of the template content pre-saved:
Form template is input to the input control by the form template input control in form template configuration interface by user
In part, template name is input in template name input control by template name input control and is then controlled by corresponding input
The form template and template name are sent to server by part, are parsed by server to the form template, with obtain with
The corresponding template content of the form template, and by template content preservation corresponding with template name.By this method by multiple tables
Grid template is directed into server.
Specifically, target template title is extracted from table export request, according to target template title, from pre-saving
Template content in extract template content corresponding with the target template title.Template content includes gauge outfit content, gauge outfit
Pattern and business datum mark.
S403: the query traffic data from database, business datum include the storage mark of business datum in the database
And the content of business datum.
Specifically, it according to the query sentence of database in table export request, inquires from database and is looked into the database
Ask the corresponding business datum of sentence.
It should be noted that the business datum inquired is the storage mark and industry by business datum in the database
The content composition for data of being engaged in.The two parameters can be respectively stored in correlated variables, if this variable of key is for storing industry
The storage mark in the database for data of being engaged in, this variable of value are used for the content of storage service data.When server according to
Query sentence of database is inquired, will be in the storage mark and business datum of business datum when inquiring business datum
Appearance is stored in key-value centering.For example, if the business datum to be inquired of query sentence of database is certain unit, and this certain
Storage in the corresponding database of unit is identified as unitName, and according to this relationship, this time the result of inquiry is unitName-
Unit.
S404: in the business datum mark of template content, target service Data Identification corresponding with storage mark is determined.
Specifically, the storage mark of target service data is corresponding with business datum mark in template content, such as template
Content includes unitName mark, then the mark can be identified with the identical storage in business datum and be matched.
S405: generating gauge outfit according to gauge outfit content and gauge outfit pattern, and by the fills of business datum to target service
In the corresponding column of Data Identification, to obtain derived table.
Specifically, the gauge outfit of table is generated according to gauge outfit content, gauge outfit pattern and gauge outfit line number, and will be in business datum
The corresponding data of matched storage mark are identified with business datum to import in the table content.Such as: business datum is identified as
UnitName, from determining to identify in corresponding storage mark and corresponding business datum with the business datum in database
Hold, such as unitName- unit.The content of business datum, i.e. certain unit are obtained, and then certain unit is filled to business datum mark
In column where knowing.The fills of all business datums are finished by this method, complete the production of table, and then will complete
Table export afterwards.
As shown from the above technical solution, this application provides a kind of table deriving method, this method is applied to server, should
After method is by receiving the table export request to business datum, target template title is extracted from table export request；In
In the template content pre-saved, the corresponding template content of target template title is searched；Wherein template content is by table
The form template of template input control input is obtained after parsing, and template content includes gauge outfit content, gauge outfit pattern and industry
Business Data Identification；The query traffic data from database, business datum include business datum in the database storage mark with
And the content of business datum；In the business datum mark of template content, target service data corresponding with storage mark are determined
Mark；Gauge outfit is generated according to gauge outfit content and gauge outfit pattern, and by the fills of business datum to target service Data Identification
In corresponding column, to obtain derived table.Template content in this method is by inputting to form template input control
Form template is obtained after parsing, saves the process of configuration personnel manual compiling form template code, and configuration mode is relatively simple.
In one example, table export request further includes query sentence of database, then step S403: being looked into from database
Ask business datum, comprising:
According to target template title, query sentence of database corresponding with target template title is inquired；If inquiring, make
With the query sentence of database inquired, the query traffic data from database；If not inquiring, table export request is used
In query sentence of database, the query traffic data from database.
It should be noted that the process that target template imports are as follows: user passes through the table mould in form template configuration interface
Form template is input in the input control by plate input control, and the form template is sent to server by the input control.
Further include query sentence of database input control other than form template input control in form template configuration interface, uses
Family can in the input control input database query statement, server is then sent to by corresponding input control, by servicing
Device is saved.
Specifically, in table export process, according to target template title, the multiple databases saved from server are looked into
It askes in sentence, determines query sentence of database corresponding with the target template title.And execute the query sentence of database.And table
Query sentence of database in lattice export request cancels.If according to target template title, in multiple data that server is saved
In library inquiry sentence, fail to determine query sentence of database corresponding with target template title, then using table export request
In query sentence of database.
It should be noted that the query sentence of database function that server is saved is more comprehensive, the industry that will such as inquire
The management operation that business data are ranked up etc；And the query sentence of database in table export request is based on target data institute
It is generated at interface, generated query sentence of database has a single function.
To guarantee the application and realization of the above method in the actual process, present invention also provides the correlation dresses of the above method
It sets, specific as follows:
A kind of form template configuration device provided by the present application is applied to configuration equipment.Referring to Fig. 5, which includes: to match
Set interface display module 501, template obtains module 502, template parsing module 503 and template preserving module 504.Wherein:
Configuration interface display module 501, for showing form template configuration interface；Wherein form template configuration interface includes
Form template title input control and form template input control.
Template obtain module 502, for obtain user by form template title input control input template name with
And obtain the form template that user is inputted by form template input control.
Template parsing module 503, for being parsed to form template, to obtain the template content of form template；Wherein
Template content includes gauge outfit content, gauge outfit pattern and business datum mark.
Template preserving module 504, for saving template name and the corresponding template content of template name.
As shown from the above technical solution, this application provides a kind of form template configuration device, which passes through display table
Grid template configuration interface, user are inputted form template and template name by related control according to the interface, then by correlation
The form template that control is inputted user is sent to configuration equipment, and configuration equipment parses form template, to obtain the table
The template content of grid template, to save the template content and template name of the form template.In the device, pass through visualization
Form template configuration interface is shown to user by interface, and user is according to the related control in form template configuration interface by table mould
Plate is directed into configuration equipment, saves the process of configuration personnel manual compiling form template code, and configuration mode is relatively simple.
In one example, form template configuration interface further includes query sentence of database input control；Then form template
Configuration device further include:
Query statement obtains module, is looked into for obtaining user by the database that query sentence of database input control inputs
Ask sentence.
Query statement preserving module, for saving the corresponding query sentence of database of template name.
In one example, form template configuration interface further includes gauge outfit line number input control；Then form template configuration dress
It sets further include:
Gauge outfit line number obtains module, passes through the gauge outfit line number that gauge outfit line number input control inputs for obtaining user.
Correspondingly, template parsing module is parsed to form template, when template content to obtain form template, tool
Body is used for:
Since the first trip of form template, extracts the corresponding list data of gauge outfit line number and carried out as gauge outfit, and to gauge outfit
Parsing, to obtain gauge outfit content and gauge outfit pattern；In the next line table of gauge outfit, extracts each mark and be used as business datum
Mark.
In one example, template parsing module is parsed to form template, in the template to obtain form template
Rong Shi is specifically used for:
Form template is converted into HTML document；HTML document is parsed, is obtained in gauge outfit
Hold, gauge outfit pattern and business datum identify.
A kind of table guiding device provided by the present application is applied to client.Referring to Fig. 6, which is specifically included: instruction
Respond module 601, template name obtain module 602, query statement generation module 603 and export request sending module 604.Its
In:
Respond module 601 is instructed, for instructing in response to user to the export of target data, provides multiple form templates
Template name；Wherein the template content of form template is obtained after being parsed by the form template inputted to form template input control
It arrives.
Template name obtains module 602, for obtaining the target template title of user's selection.
Query statement generation module 603, for generating the query sentence of database to target data.
Request sending module 604 is exported, is led for target template title and query sentence of database to be encapsulated in table
Server is sent in request out.
As shown from the above technical solution, this application provides a kind of table guiding device, which passes through in response to user
Export instruction to target data, provides the template name of multiple form templates；Wherein the template content of form template is to pass through
It is obtained after parsing to the form template of form template input control input；Obtain the target template title of user's selection；It generates
To the query sentence of database of target data；Target template title and query sentence of database are encapsulated in table export request
In be sent to server.Form template in the device is based in the form template configuration interface of visualization interface by user
Template input control is directed into configuration equipment, saves the process of configuration personnel manual compiling form template code, configuration mode
It is relatively simple.
A kind of table guiding device provided by the present application is applied to server.Referring to Fig. 7, which is specifically included: export
Request receiving module 701, template content enquiry module 702, business datum enquiry module 703, mark determining module 704 and table
Lattice generation module 705.Wherein:
Request receiving module 701 is exported, after receiving the table export request to business datum, is asked from table export
Seek middle extraction target template title.
Template content enquiry module 702, for it is corresponding to search target template title in the template content pre-saved
Template content；Wherein template content is obtained after parsing by the form template inputted to form template input control, and mould
Plate content includes gauge outfit content, gauge outfit pattern and business datum mark.
Business datum enquiry module 703, being used for query traffic data, business datum from database includes that business datum exists
The content of storage mark and business datum in database.
Determining module 704 is identified, for determining mesh corresponding with storage mark in the business datum of template content mark
Mark business datum mark.
Table generation module 705, for generating gauge outfit according to gauge outfit content and gauge outfit pattern, and by the content of business datum
Filling is into the corresponding column of target service Data Identification, to obtain derived table.
In one example, table export request further include query sentence of database, then business datum enquiry module from
In database when query traffic data, it is specifically used for:
According to target template title, query sentence of database corresponding with target template title is inquired；If inquiring, make
With the query sentence of database inquired, the query traffic data from database；If not inquiring, table export request is used
In query sentence of database, the query traffic data from database.
It should be noted that all the embodiments in this specification are described in a progressive manner, each embodiment weight
Point explanation is the difference from other embodiments, and the same or similar parts between the embodiments can be referred to each other.
It should also be noted that, herein, relational terms such as first and second and the like are used merely to one
Entity or operation are distinguished with another entity or operation, without necessarily requiring or implying between these entities or operation
There are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant are intended to contain
Lid non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including above-mentioned element.
The foregoing description of the disclosed embodiments makes professional and technical personnel in the field can be realized or use the application.
Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the application.Therefore, the application
It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one
The widest scope of cause.
Claims (14)
1. a kind of form template configuration method, which is characterized in that it is applied to configuration equipment, this method comprises:
Show form template configuration interface；Wherein the form template configuration interface include form template title input control and
Form template input control；
The template name and acquisition user that acquisition user is inputted by the form template title input control pass through the table
The form template of grid template input control input；
The form template is parsed, to obtain the template content of the form template；Wherein the template content includes
Gauge outfit content, gauge outfit pattern and business datum mark；
Save the template name and the corresponding template content of the template name.
2. form template configuration method according to claim 1, which is characterized in that the form template configuration interface also wraps
Include query sentence of database input control；Then this method further include:
It obtains user and passes through the query sentence of database that the query sentence of database input control inputs；
Save the corresponding query sentence of database of the template name.
3. form template configuration method according to claim 1, which is characterized in that the form template configuration interface also wraps
Include gauge outfit line number input control；Then this method further include:
Obtain the gauge outfit line number that user is inputted by the gauge outfit line number input control；
Correspondingly, the form template is parsed, to obtain the template content of the form template, comprising:
Since the first trip of the form template, the corresponding list data of the gauge outfit line number is extracted as gauge outfit, and to described
Gauge outfit is parsed, to obtain gauge outfit content and gauge outfit pattern；
In the next line table of the gauge outfit, extracts each mark and identified as business datum.
4. form template configuration method according to claim 1, which is characterized in that the form template is parsed,
To obtain the template content of the form template, comprising:
The form template is converted into HTML document；
The HTML document is parsed, gauge outfit content, gauge outfit pattern and business datum mark are obtained.
5. a kind of table deriving method, which is characterized in that it is applied to client, this method comprises:
The export of target data is instructed in response to user, the template name of multiple form templates is provided；The wherein table mould
The template content of plate is obtained after parsing by the form template inputted to form template input control；
Obtain the target template title of user's selection；
Generate the query sentence of database to the target data；
Target template title and the query sentence of database are encapsulated in table export request and are sent to server.
6. a kind of table deriving method, which is characterized in that it is applied to server, this method comprises:
After receiving the table export request to business datum, target template title is extracted from table export request；
In the template content pre-saved, the corresponding template content of the target template title is searched；Wherein in the template
Appearance is obtained after parsing by the form template inputted to form template input control, and the template content includes in gauge outfit
Hold, gauge outfit pattern and business datum identify；
Inquire the business datum from database, the business datum include the storage mark of business datum in the database with
And the content of business datum；
In the business datum mark of the template content, target service Data Identification corresponding with the storage mark is determined；
Gauge outfit is generated according to the gauge outfit content and the gauge outfit pattern, and by the fills of the business datum to the mesh
It marks business datum to identify in corresponding column, to obtain derived table.
7. table deriving method according to claim 6, which is characterized in that further include data in the table export request
Library inquiry sentence, then it is described that the business datum is inquired from database, comprising:
According to the target template title, query sentence of database corresponding with the target template title is inquired；
If inquiring, using the query sentence of database inquired, the business datum is inquired from database；
If not inquiring, using the query sentence of database in table export request, the industry is inquired from database
Business data.
8. a kind of form template configuration device, which is characterized in that be applied to configuration equipment, which includes:
Configuration interface display module, for showing form template configuration interface；Wherein the form template configuration interface includes table
Grid template title input control and form template input control；
Template obtains module, for obtaining the template name and obtain that user is inputted by the form template title input control
It obtains user and passes through the form template that the form template input control inputs；
Template parsing module, for being parsed to the form template, to obtain the template content of the form template；Wherein
The template content includes gauge outfit content, gauge outfit pattern and business datum mark；
Template preserving module, for saving the template name and the corresponding template content of the template name.
9. form template configuration device according to claim 8, which is characterized in that the form template configuration interface also wraps
Include query sentence of database input control；The then device further include:
Query statement obtains module, is looked into for obtaining user by the database that the query sentence of database input control inputs
Ask sentence；
Query statement preserving module, for saving the corresponding query sentence of database of the template name.
10. form template configuration device according to claim 8, which is characterized in that the form template configuration interface is also
Including gauge outfit line number input control；The then device further include:
Gauge outfit line number obtains module, the gauge outfit line number inputted for obtaining user by the gauge outfit line number input control；
Correspondingly, the template parsing module is parsed to the form template, to obtain the template of the form template
When content, it is specifically used for:
Since the first trip of the form template, the corresponding list data of the gauge outfit line number is extracted as gauge outfit, and to described
Gauge outfit is parsed, to obtain gauge outfit content and gauge outfit pattern；In the next line table of the gauge outfit, each mark is extracted
It is identified as business datum.
11. form template configuration device according to claim 8, which is characterized in that the template parsing module is to institute
It states form template to be parsed, when template content to obtain the form template, be specifically used for:
The form template is converted into HTML document；The HTML document is parsed, table is obtained
Head content, gauge outfit pattern and business datum mark.
12. a kind of table guiding device, which is characterized in that be applied to client, which includes:
Respond module is instructed, for instructing in response to user to the export of target data, provides the template name of multiple form templates
Claim；Wherein the template content of the form template is obtained after being parsed by the form template inputted to form template input control
's；
Template name obtains module, for obtaining the target template title of user's selection；
Query statement generation module, for generating the query sentence of database to the target data；
Request sending module is exported, is asked for target template title and the query sentence of database to be encapsulated in table export
Server is sent in asking.
13. a kind of table guiding device, which is characterized in that be applied to server, which includes:
Request receiving module is exported, after receiving the table export request to business datum, exports and requests from the table
Middle extraction target template title；
Template content enquiry module, in the template content pre-saved, searching the corresponding mould of the target template title
Plate content；Wherein the template content is obtained after parsing by the form template inputted to form template input control, and
The template content includes gauge outfit content, gauge outfit pattern and business datum mark；
Business datum enquiry module, for inquiring the business datum from database, the business datum includes business datum
The content of storage mark and business datum in the database；
Determining module is identified, in the business datum of template content mark, determination to be corresponding with the storage mark
Target service Data Identification；
Table generation module, for generating gauge outfit according to the gauge outfit content and the gauge outfit pattern, and by the business datum
Fills into the corresponding column of the target service Data Identification, to obtain derived table.
14. table guiding device according to claim 13, which is characterized in that further include number in the table export request
According to library inquiry sentence, then the business datum enquiry module is specifically used for when inquiring the business datum from database:
According to the target template title, query sentence of database corresponding with the target template title is inquired；If inquiring,
Then using the query sentence of database inquired, the business datum is inquired from database；If not inquiring, using described
Query sentence of database in table export request, inquires the business datum from database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910686161.3A CN110413974A (en) | 2019-07-26 | 2019-07-26 | Form template configuration and device, table deriving method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910686161.3A CN110413974A (en) | 2019-07-26 | 2019-07-26 | Form template configuration and device, table deriving method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110413974A true CN110413974A (en) | 2019-11-05 |
Family
ID=68363693
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910686161.3A Pending CN110413974A (en) | 2019-07-26 | 2019-07-26 | Form template configuration and device, table deriving method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110413974A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112099801A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel analysis method and system based on metadata driving |
| CN113505183A (en) * | 2021-07-28 | 2021-10-15 | 中国工商银行股份有限公司 | Data visualization method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
| CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN107817990A (en) * | 2017-11-24 | 2018-03-20 | 北京恒华伟业科技股份有限公司 | A kind of generation method of list, device and electronic equipment |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
-
2019
- 2019-07-26 CN CN201910686161.3A patent/CN110413974A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN107817990A (en) * | 2017-11-24 | 2018-03-20 | 北京恒华伟业科技股份有限公司 | A kind of generation method of list, device and electronic equipment |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112099801A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel analysis method and system based on metadata driving |
| CN113505183A (en) * | 2021-07-28 | 2021-10-15 | 中国工商银行股份有限公司 | Data visualization method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8185877B1 (en) | System and method for testing applications | |
| CN102135938B (en) | Software product testing method and system | |
| JP6667931B2 (en) | Method and device for recognizing time information from audio information | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN106528129A (en) | Web application interface generation system and method | |
| CN107122365A (en) | The access method and device of heterogeneous database | |
| CN110515896B (en) | Model resource management method, model file manufacturing method, device and system | |
| CN105022615A (en) | Interface generating method and system | |
| CN110399128A (en) | Code file generation method and device | |
| CN108073688B (en) | Data migration method and device | |
| CN103905231A (en) | Method and device for unified management of device types | |
| CN112287013B (en) | Data conversion method and adapter | |
| CN110413974A (en) | Form template configuration and device, table deriving method and device | |
| CN111078702A (en) | SQL sentence classification management and unified query method and device | |
| CN108491326A (en) | Behavioral test recombination method, device and storage medium | |
| CN109582936A (en) | The method and apparatus for configuring report messages | |
| Kazi et al. | JaViz: A client/server Java profiling tool | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| CN102043570A (en) | Command line input method and device | |
| CN117194501B (en) | DCS trend measurement point jump logic configuration method, system, equipment and medium | |
| CN107977419A (en) | A kind of nuclear power station DCS O＆Ms support file identification method and system | |
| CN116301871B (en) | Method and system for developing functional page by adopting index legend | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN104537047B (en) | A kind of clothes basic pattern plate searching system based on Lucene | |
| CN108427626A (en) | Daily record text handling method, device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |