CN109815276A - Method, apparatus, computer equipment and the storage medium of declaration form extraction data - Google Patents
Method, apparatus, computer equipment and the storage medium of declaration form extraction data Download PDFInfo
- Publication number
- CN109815276A CN109815276A CN201811531547.9A CN201811531547A CN109815276A CN 109815276 A CN109815276 A CN 109815276A CN 201811531547 A CN201811531547 A CN 201811531547A CN 109815276 A CN109815276 A CN 109815276A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- preset
- declaration form
- preset field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000003860 storage Methods 0.000 title claims abstract description 33
- 238000000605 extraction Methods 0.000 title description 8
- 239000000284 extract Substances 0.000 claims abstract description 29
- 238000004590 computer program Methods 0.000 claims description 14
- 238000013507 mapping Methods 0.000 claims description 8
- 238000005457 optimization Methods 0.000 abstract description 10
- 230000006870 function Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 4
- 238000012356 Product development Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 2
- 238000005520 cutting process Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000000630 rising effect Effects 0.000 description 2
- 239000000126 substance Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000009415 formwork Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
A kind of declaration form provided herein extracts method, apparatus, computer equipment and the storage medium of data, the following steps are included: receiving the first preset field that user selects from default display interface, wherein, first preset field is from being shown at least one selected in all preset fields in the default display interface, and the preset field is that user terminal is pre-set for match the field of simultaneously associated storage data in declaration form database；Got from the declaration form database according to first preset field with matched all first data of first preset field, and table corresponding with the default display interface content is generated according to first preset field；All first data are corresponded to and are inserted in the table, and show the table.Performance is extracted in optimization, accelerates the efficiency for extracting data, the process optimization of the O&M of realization.
Description
Technical field
This application involves the technical field of computer, in particular to a kind of declaration form extracts the method, apparatus of data, computer
Equipment and storage medium..
Background technique
With the arrival of big data era, hundreds of millions of data are deposited into database, and big field data are also continuous
Appear in us at the moment.It however sometimes include special some information, therefore the word special to these in big field data
Symbol, which establishes index also, becomes the important content in studying.
Declaration form data are stored using clob type at present, although solving the problems, such as data diversification, continuous dynamic change,
But difficulty is increased to data extraction, while reducing the timeliness of performance；And the index of other modes is used, if desired change page
The setting in face needs backstage to modify for the needs of each user.
Summary of the invention
The main purpose of the application is to provide the method, apparatus, computer equipment and storage Jie of a kind of declaration form extraction data
Matter is accelerated to extract the data volume of declaration form and the efficiency of extraction.
To achieve the above object, this application provides a kind of methods that declaration form extracts data, comprising the following steps:
Receive the first preset field for selecting from default display interface of user, wherein first preset field be from
It is shown at least one selected in all preset fields in the default display interface, the preset field is that user terminal is preparatory
Field for matching simultaneously associated storage data in declaration form database is set；
It is got from the declaration form database according to first preset field matched with first preset field
All first data, and table corresponding with the default display interface content is generated according to first preset field；
All first data are corresponded to and are inserted in the table, and show the table.
Further, the preset field includes universal field and configuration field, the universal field and the configuration words
Section is the field for going out single content and getting according to declaration form.
Further, before the step of reception user is from the first preset field selected in default display interface, packet
It includes:
User terminal setting is received for match and associated storage all of data in declaration form database described preset
Field；
All preset fields are loaded in the default display interface.
Further, the step of display table, comprising:
The table is sent on the display platform, and by the download interface of the table and the category of the table
Property information be shown on the display platform, wherein the attribute information of the table include the time for generating the table, obtain
The fruiting quantities arrived and first preset field.
It is further, described by the corresponding step inserted in the table of all first data, comprising:
According to preset rules, first preset field for receiving user's selection is filled into the table and is referred to
Positioning is set；
According to the mapping relations of preset first preset field and first data, will acquire all described first
Data are filled into the table of corresponding first preset field.
Further, after the step by the corresponding filling table of all first data, comprising:
The content in the table is encrypted by data encryption algorithm.
Further, described correspond to all first data is inserted in the table, and shows the table
After step, further includes:
Receive the download instruction for the download interface that the user terminal selects from the display platform；
The table is transmitted to the user terminal by download interface.
Present invention also provides the devices that a kind of declaration form extracts data, are previously received user terminal and are arranged for matching and closing
Join the preset field for the data being stored in declaration form database, comprising:
First receiving module, the first preset field selected from default display interface for receiving user, wherein described
First preset field be from being shown at least one selected in all preset fields in the default display interface, it is described default
Field is that user terminal is pre-set for matching the field of simultaneously associated storage data in declaration form database；
First obtains module, for being got from the declaration form database according to first preset field and described the
Matched all first data of one preset field, and generated and the default display interface content according to first preset field
Corresponding table；
Generation module is inserted in the table for corresponding to all first data, and shows the table.
The application also provides a kind of computer equipment, including memory and processor, is stored with calculating in the memory
The step of machine program, the processor realizes any of the above-described the method when executing the computer program.
The application also provides a kind of computer storage medium, is stored thereon with computer program, the computer program quilt
The step of processor realizes method described in any of the above embodiments when executing.
Declaration form provided herein extracts method, apparatus, computer equipment and the storage medium of data, has with following
Beneficial effect:
The first preset field selected from default display interface by receiving user terminal, is matched to from declaration form database
Data corresponding with the first preset field, and by after the corresponding filling of data table corresponding with default display interface content, it sends
And be shown on display platform, performance is extracted in optimization, accelerates the efficiency for extracting data, the process optimization of the O&M of realization.
Detailed description of the invention
Fig. 1 is the method and step schematic diagram that declaration form extracts data in one embodiment of the application；
Fig. 2 is the apparatus structure block diagram that declaration form extracts data in one embodiment of the application；
Fig. 3 is the structural schematic block diagram of the computer equipment of one embodiment of the application.
The embodiments will be further described with reference to the accompanying drawings for realization, functional characteristics and the advantage of the application purpose.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
It referring to Fig.1, is that a kind of method that declaration form extracts data is provided in one embodiment of the application, comprising the following steps:
Step S1 receives the first preset field that user selects from default display interface, wherein first predetermined word
Section is from being shown at least one selected in all preset fields in the default display interface, and the preset field is user
End presets the field for matching simultaneously associated storage data in declaration form database；
Step S2 is got and first preset field according to first preset field from the declaration form database
Matched all first data, and table corresponding with the default display interface content is generated according to first preset field
Lattice；
All first data are corresponded to and are inserted in the table, and show the table by step S3.
In above step, user needs to configure field according to product when carrying out product development on display platform (PC)
Type is defined the field name of required configuration field, such as the setting to inquiry field, in addition to product category, insurance produce
The default queries condition field such as product, insurance period further includes having the setting of general or standard target field, chooses specified field,
Corresponding data are got in big data, and are associated with the field of selection, and previously according to the needs of product, user can match in advance
Different templates is set, it is automatic to inquire after the template is for being shown on the display platform of terminal and inputting preset field for user
Required data, wherein universal field or the content of configuration field are shown in default display interface in a manner of frame, are being set
When setting default display interface, user be free to dragging corresponding field frame, according to the addition of user and drag operation with right
Field contents in default display interface carry out typesetting；It is available when user is choosing query template and after result template
To corresponding query information required for user, query information include before the phase of required acquisition that is arranged in template of user
Data information, the information which presets before being are closed, and is associated with specified field, system receives use in advance
The preset field of family end setting is e.g. provided with all relevant data of storage to an individual field, by changing database
Type, which is realized, extracts the corresponding data of crucial words in declaration form, such as independent field is license plate number, when user inputs license plate number word
Duan Shi, all data relevant to license plate number field are taken out.
In the present embodiment, it is individually indexed by field contents of the Postgrep SQL database to Clob type,
And the inventory of business is extracted using ICORE-REPORT system, extract data volume is bigger, performance is more excellent, efficiency faster,
As needed by function pages according to " display interface setting ", " query template setting ", " inquiry sheet inquiry ", " under inquiry sheet
Load ", " declaration form inquiry ", " declaration form downloading " etc. carry out cutting, support that page individual cultivation, all pages can be by users certainly
Oneself is arranged in the page of user terminal, does not need data needed for the requirement extract that can be realized according to user is intervened on backstage.
PostgreSQL is a free Object-relational Database server (data base management system), supports big portion
Point SQL standard and provide many other Modern Characteristics: complex query, external key, trigger, view, transactional integrity,
MVCC.Equally, PostgreSQL can extend in many ways, for example, by increase new data type, function, operator,
Aggregate function, index.Free to use, modify and distribute PostgreSQL, PostgreSQL is also very rich to the support of interface
Rich, almost support all types of database client end interfaces.
Clob object includes the logical pointer of a direction SQL CLOB data rather than data itself, and Clob object is at it
During the issued transaction being created effectively, SQL CLOB is built-in type, by character blob (Character Large
Object a train value) being stored as in database table a line, driver realize Clob using SQL locator (CLOB)
Object.
The corresponding related data of all insurance kinds of insuring and declaration form, inquiry sheet of client etc. are stored in advance in the database
Corresponding related data；Need to carry out template-setup previously according to user, such as according to function needs be divided into " display interface setting ",
" query template setting ", " inquiry sheet inquiry ", " inquiry sheet downloading ", " declaration form inquiry ", " declaration form downloading "；User (business personnel) root
Template-setup is carried out to default display interface according to individual demand, corresponding data required for can obtaining from database is matched in advance
The resultant content for needing to return is set, according to the needs of product, gets return field in the template of " display interface setting "
It is corresponding as a result, wherein return field include number of policy, secondary facility, three layers of constitutions, name of product, insurant, income
People, insurer, odd numbers of supporting value, commencement of coverage, insurance stop phase etc., should be the result is that obtaining from database, by the return field
The corresponding data of configuring product, i.e., information involved by each insurance products, wherein the first word that each product is related to
Section includes universal field and configuration field, and wherein universal field refers to higher (being commonly used) field of repeatability, i.e., nonstandard
Information field, such as number of policy, insurer, beneficiary, name of product or license plate number, Vehicle Identify Number etc.；Configuration field is then
Refer to the personalized field in product, i.e. target information field.Can freely it be arranged according to user and interior with system (general-purpose platform)
Data correlation, pass through the template-setup preset field of " query template setting " and be associated with corresponding data, when user is from default
When selecting specified preset field in field, it can be got in system and the preset field specified associated corresponding first
Data, and table corresponding with the default display interface content, such as the first preset field packet are generated according to the first preset field
Vehicle insurance number of policy has been included, then has generated the numerical attribute for having vehicle insurance number of policy, row of the numerical attribute as table in corresponding table
Corresponding specific number of policy, is filled at the position in table by head or column head according to the vehicle insurance number of policy, generates corresponding
Table, and the relevant information of table is sent on display platform by interface and is shown.
In one embodiment, the preset field includes universal field and configuration field, the universal field and described
Configuration field is the field for going out single content and getting according to declaration form.
In the present embodiment, preset field includes universal field and configuration field, wherein universal field refer to repeatability compared with
High (being commonly used) field, i.e., nonstandard information field, such as number of policy, insurer, beneficiary, name of product or vehicle
The trade mark, Vehicle Identify Number etc.；Configuration field then refers to the personalized field in product, i.e. target information field, and rising can be with self-defining name
Claim, for example, the adjustment field of limit, rate etc..Preset field can be freely arranged previously according to the content of declaration form in user terminal, with
Housecoat business termination receives the preset field of user terminal setting.
In one embodiment, user is received before the step S1 of the first preset field selected in default display interface,
Include:
Step S101 receives user terminal setting for match and associated storage data in declaration form database own
The preset field；
Step S102 loads on all preset fields in the default display interface.
In above step, system receives the preset field that the needs of user terminal setting are shown in default display interface,
Preset field setting loads all on default display interface for matching simultaneously associated storage data in declaration form database
Preset field, user be free to dragging corresponding field frame, according to the addition and drag operation for receiving user to pre-
If the field contents in display interface carry out typesetting, after the first specified preset field is chosen so as to user to be received, Ke Yisheng
At table required for user, the table content is corresponding with the default display interface content.
In one embodiment, the step S3 of the table is shown, comprising:
The table is sent on the display platform by step S31, and by the download interface of the table and described
The attribute information of table is shown on the display platform, wherein the attribute information of the table includes generating the table
Time, the fruiting quantities got and first preset field.
In above step, the field and corresponding data being arranged in the template that is shown according to default display interface, when connecing
When receiving the querying condition of user's input, gets and extract the corresponding data of crucial words in declaration form, wherein the table
Attribute information includes the time for generating the table, the fruiting quantities got and first preset field, will be received
Attribute information of the querying condition of user's input as table, by the querying condition received and the corresponding data got
It is shown on display platform, the content that querying condition is shown includes such as: whether comprising Lower Establishment, Institution Code, core guarantor's time
It rises and stops, insurance period has been placed restrictions on and is stopped；It can also show the query time of user on display platform, inquirer, query time and complete
At the time, the result data amount inquired, and inquiry state, and showing Downloadable operational order, user can be according to this
Whether body demand estimation, which needs, is downloaded.
It in one embodiment, further include having inquiry sheet inquiry and inquiry sheet download module, the area of inquiry sheet and declaration form
It is not, inquiry sheet supplies information to user (business personnel) for being intended to buy, and user obtains according to the relevant information for being intended to buyer
It is obtained to corresponding related data as thought the name of product of purchase, settle a claim class, pre- insurance expenses etc. according to desire buyer
It to the corresponding premium of desire buyer, risk class etc., and is correspondingly arranged on field and is associated with corresponding data, ask when user opens
When valence list is inquired, the corresponding data of corresponding all desire buyers can be got according to the querying condition of input.
In one embodiment, by the corresponding step S3 inserted in the table of all first data, comprising:
First preset field for receiving user's selection is filled into institute according to preset rules by step S301
State designated position in table；
Step S302, according to the mapping relations of preset first preset field and first data, the institute that will acquire
There are first data to be filled into the table of corresponding first preset field.
In above step, according to the page of data of user configuration, the data of user's dynamic configuration are received；According to reception user
The default display interface being arranged obtains required each corresponding data, includes that text is defeated in the setting of default display interface
Enter frame, textview field, combobox, radio box, multiselect frame etc., user can be according to the needs of product, the type of option and installment field.Its
In, for Text Entry, can typing information, and textview field is suitble to the information of the not no immobilized substance such as remarks, brief introduction；Combobox
It then can guarantee the standardization of typing, such as policy type, mode, insured amount section classification information；Radio box and check box also can guarantee
The standardization of typing, check box are also applicable to the scene of multiselect.The corresponding table of user is got, and will be from database
It is matched in corresponding data filling table.
The mapping relations for establishing preset first preset field Yu first data, will match to meet first default
Associated all first data of field be summarized in table, since the data of each client include multiple, if entirely in table
Interior display, field bad to the experience of user, therefore being arranged in default display interface template according to user, when user's selection the
One preset field, table generate the corresponding result of content it is consistent with default display interface template-setup, be preset with according to
Family selects the sequence of the first preset field, and the first preset field selected in each template is successively filled in table, table is made
The fills of interior display are that the first preset field that the user selects from preset field and corresponding described first are preset
The first data, facilitate user to check accessed by field.
It in one embodiment, will be after the corresponding step S3 for inserting the table of all first data, comprising:
Step S401 encrypts the content in the table by data encryption algorithm.
In above step, the content in the table is encrypted by data encryption algorithm, system carries out information
Protection is to realize information hiding by encrypting to the content in table, to play the effect of the safety of protection information.
Data encryption is by being handled by certain algorithm the file or data that were originally plaintext, and becoming can not
The one section of code read, becomes ciphertext, makes it that can only can just show original content after inputting corresponding key, in this way
Approach achieve the purpose that protect the data do not stolen, read by juridical-person.
In one embodiment, all first data are corresponded to and is inserted in the table, and show the table
After step S3, further includes:
Step S4 receives the download instruction for the download interface that the user terminal selects from the display platform；
The table is transmitted to the user terminal by download interface by step S5.
In above step, the table being shown on display platform includes download interface, when receive user click or
When selecting the download instruction of download interface, after system receives user's selection download instruction, table is transmitted by download interface
To user terminal.
In conclusion the method that the declaration form to provide in the embodiment of the present application extracts data, by receiving user terminal from pre-
If the first preset field selected in display interface, corresponding data are matched to from declaration form database, and data correspondence is filled out
It after entering table corresponding with default display interface content, sends and is shown on display platform, performance is extracted in optimization, accelerates to extract
The efficiency of data, the process optimization of the O&M of realization.
Referring to Fig. 2, a kind of device of declaration form extraction data is additionally provided in one embodiment of the application, is previously received user
End setting is for matching the preset field of simultaneously data of the associated storage in declaration form database, comprising:
First receiving module 10, the first preset field selected from default display interface for receiving user, wherein institute
State the first preset field be from being shown at least one selected in all preset fields in the default display interface, it is described pre-
If field is that user terminal is pre-set for matching the field of simultaneously associated storage data in declaration form database；
First obtain module 20, for got from the declaration form database according to first preset field with it is described
Matched all first data of first preset field, and according in first preset field generation and the default display interface
Hold corresponding table；
Generation module 30 is inserted in the table for corresponding to all first data, and shows the table.
In the present embodiment, user needs to configure field according to product when carrying out product development on display platform (PC)
Type, the field name of required configuration field is defined, such as to inquiry field setting, in addition to product category, insurance
The default queries condition field such as product, insurance period further includes having the setting of general or standard target field, chooses specified word
Section, gets corresponding data, and be associated with the field of selection, previously according to the needs of product, user can be pre- in big data
Different templates is first configured, after the template is for being shown on the display platform of terminal and inputting preset field for user, automatically
Data needed for inquiring, wherein universal field or the content of configuration field are shown in default display interface in a manner of frame,
When default display interface is arranged, user be free to dragging corresponding field frame, according to the addition of user and drag operation
To carry out typesetting to the field contents in default display interface；When user is after choosing the content of query template and display interface
Afterwards, available to corresponding query information required for user, user is arranged in template before query information includes
The related data information of required acquisition, the information which presets before being, and be associated with specified field, it is
System receives the preset field of user terminal setting in advance, e.g., an individual field is provided with all relevant data of storage, leads to
It crosses change type of database and realizes that extracting the corresponding data of crucial words in declaration form works as user if independent field is license plate number
When inputting license plate number field, all data relevant to license plate number field are taken out.
In the present embodiment, it is individually indexed by field contents of the Postgrep SQL database to Clob type,
And the inventory of business is extracted using ICORE-REPORT system, extract data volume is bigger, performance is more excellent, efficiency faster,
As needed by function pages according to " display interface setting ", " query template setting ", " inquiry sheet inquiry ", " under inquiry sheet
Load ", " declaration form inquiry ", " declaration form downloading " etc. carry out cutting, support that page individual cultivation, all pages can be by users certainly
Oneself is arranged in the page of user terminal, does not need data needed for the requirement extract that can be realized according to user is intervened on backstage.
PostgreSQL is a free Object-relational Database server (data base management system), supports big portion
Point SQL standard and provide many other Modern Characteristics: complex query, external key, trigger, view, transactional integrity,
MVCC.Equally, PostgreSQL can extend in many ways, for example, by increase new data type, function, operator,
Aggregate function, index.Free to use, modify and distribute PostgreSQL, PostgreSQL is also very rich to the support of interface
Rich, almost support all types of database client end interfaces.
Clob object includes the logical pointer of a direction SQL CLOB data rather than data itself, and Clob object is at it
During the issued transaction being created effectively, SQL CLOB is built-in type, by character blob (Character Large
Object a train value) being stored as in database table a line, driver realize Clob using SQL locator (CLOB)
Object.
The corresponding related data of all insurance kinds of insuring and declaration form, inquiry sheet of client etc. are stored in advance in the database
Corresponding related data；Need to carry out template-setup previously according to user, such as according to function needs be divided into " display interface setting ",
" query template setting ", " inquiry sheet inquiry ", " inquiry sheet downloading ", " declaration form inquiry ", " declaration form downloading "；User (business personnel) root
Template-setup is carried out to default display interface according to individual demand, corresponding data required for can obtaining from database is matched in advance
The resultant content for needing to return is set, according to the needs of product, gets return field in the template of " display interface setting "
It is corresponding as a result, wherein return field include number of policy, secondary facility, three layers of constitutions, name of product, insurant, income
People, insurer, odd numbers of supporting value, commencement of coverage, insurance stop phase etc., should be the result is that obtaining from database, by the return field
The corresponding data of configuring product, i.e., information involved by each insurance products, wherein the first word that each product is related to
Section includes universal field and configuration field, and wherein universal field refers to higher (being commonly used) field of repeatability, i.e., nonstandard
Information field, such as number of policy, insurer, beneficiary, name of product or license plate number, Vehicle Identify Number etc.；Configuration field is then
Refer to the personalized field in product, i.e. target information field.Can freely it be arranged according to user and interior with system (general-purpose platform)
Data correlation, pass through the template-setup preset field of " query template setting " and be associated with corresponding data, when user is from default
When selecting specified preset field in field, it can be got in system and the preset field specified associated corresponding first
Data, and table corresponding with the default display interface content, such as the first preset field packet are generated according to the first preset field
Vehicle insurance number of policy has been included, then has generated the numerical attribute for having vehicle insurance number of policy in corresponding table, row of the numerical attribute as table
Corresponding specific number of policy, is filled at the position in table by head or column head according to the vehicle insurance number of policy, generates corresponding
Table, and the relevant information of table is sent on display platform by interface and is shown.
In one embodiment, the preset field includes universal field and configuration field, the universal field and described
Configuration field is the field for going out single content and getting according to declaration form.
In the present embodiment, preset field includes universal field and configuration field, wherein universal field refer to repeatability compared with
High (being commonly used) field, i.e., nonstandard information field, such as number of policy, insurer, beneficiary, name of product or vehicle
The trade mark, Vehicle Identify Number etc.；Configuration field then refers to the personalized field in product, i.e. target information field, and rising can be with self-defining name
Claim, for example, the adjustment field of limit, rate etc..Preset field can be freely arranged previously according to the content of declaration form in user terminal, with
Housecoat business termination receives the preset field of user terminal setting.
In one embodiment, the device of declaration form extraction data includes:
Second receiving module, for receiving, the user terminal setting is used to match and associated storage is in declaration form database
All preset fields of data；
Loading module, for loading on all preset fields in the default display interface.
In the present embodiment, system receives the predetermined word that the needs of user terminal setting are shown in default display interface
Section, preset field setting is for matching simultaneously associated storage data in declaration form database, the default display circle of loading module load
All preset fields being arranged on face, user be free to dragging corresponding field frame, according to the addition for receiving user
With drag operation to carry out typesetting to the field contents in default display interface, so that user to be received chooses the first preset field
Afterwards, table required for user can be generated, the table content is corresponding with the default display interface content.
In one embodiment, production module 30 includes:
Display unit, for the table to be sent to the display platform, and by the download interface of the table with
And the attribute information of the table is shown on the display platform, wherein the attribute information of the table includes described in generation
The time of table, the fruiting quantities got and first preset field.
In the present embodiment, the field and corresponding data being arranged in the template shown according to default display interface, when
When receiving the querying condition of user's input, gets and extract the corresponding data of crucial words in declaration form, wherein the table
Attribute information include the time for generating the table, the fruiting quantities got and first preset field, will receive
Attribute information of the querying condition inputted to user as table, by the querying condition received and the corresponding number got
Whether, according to being shown on display platform, the content that querying condition is shown includes such as: when protecting comprising Lower Establishment, Institution Code, core
Between rise with only, insurance period placed restrictions on stop；Can also show the query time of user on display platform, inquirer, query time and
Deadline, the result data amount inquired, and inquiry state, and show Downloadable operational order, user can basis
Whether demand estimation itself, which needs, is downloaded.
It in one embodiment, further include having inquiry sheet inquiry and inquiry sheet download module, the area of inquiry sheet and declaration form
It is not, inquiry sheet supplies information to user (business personnel) for being intended to buy, and user obtains according to the relevant information for being intended to buyer
It is obtained to corresponding related data as thought the name of product of purchase, settle a claim class, pre- insurance expenses etc. according to desire buyer
It to the corresponding premium of desire buyer, risk class etc., and is correspondingly arranged on field and is associated with corresponding data, ask when user opens
When valence list is inquired, the corresponding data of corresponding all desire buyers can be got according to the querying condition of input.
In one embodiment, generation module 30 includes:
First preset field for receiving user's selection is filled into institute according to preset rules by generation unit
State designated position in table；
Filling unit will acquire for the mapping relations according to preset first preset field and first data
All first data be filled into the table of corresponding first preset field.
In the present embodiment, according to the page of data of user configuration, the data of user's dynamic configuration are received；It is used according to receiving
The default display interface of family setting, obtains required each corresponding data, includes text in the setting of default display interface
Input frame, textview field, combobox, radio box, multiselect frame etc., user can be according to the needs of product, the types of option and installment field.
Wherein, for Text Entry, can typing information, and textview field is suitble to the information of the not no immobilized substance such as remarks, brief introduction；Drop-down
Frame then can guarantee the standardization of typing, such as policy type, mode, insured amount section classification information；Radio box and check box can also be protected
The standardization of typing is demonstrate,proved, check box is also applicable to the scene of multiselect.The corresponding table of user is got, and will be from database
In be matched in corresponding data filling table.
The mapping relations for establishing preset first preset field Yu first data, will match to meet first default
Associated all first data of field be summarized in table, since the data of each client include multiple, if entirely in table
Interior display, field bad to the experience of user, therefore being arranged in default display interface template according to user, when user's selection the
One preset field, table generate the corresponding result of content it is consistent with default display interface template-setup, be preset with according to
Family selects the sequence of the first preset field, and the first preset field selected in each template is once inserted in table, table is made
The fills of interior display are that the first preset field that the user selects from preset field and corresponding described first are preset
The first data, facilitate user to check accessed by field.
In one embodiment, the device of declaration form extraction data includes:
Encrypting module, for being encrypted by data encryption algorithm to the content in the table.
In the present embodiment, encrypting module encrypts the content in the table by data encryption algorithm, system
Carrying out protection to information is to realize information hiding by encrypting to the content in table, to play the peace of protection information
Full effect.
Data encryption is by being handled by certain algorithm the file or data that were originally plaintext, and becoming can not
The one section of code read, becomes ciphertext, makes it that can only can just show original content after inputting corresponding key, in this way
Approach achieve the purpose that protect the data do not stolen, read by juridical-person.
In one embodiment, declaration form extracts the device of data further include:
Download module, for receiving the downloading for the download interface that the user terminal selects from the display platform
Instruction；
Transmission module, for the table to be transmitted to the user terminal by download interface.
In this example it is shown that in the table on display platform include download interface, when receive user click or
When person selects the download instruction of download interface, after system receives user's selection download instruction, table is passed by download interface
Transport to user terminal.
In conclusion the declaration form to provide in the embodiment of the present application extracts the device of data, by receiving user terminal from pre-
If the first preset field selected in display interface, corresponding data are matched to from declaration form database, and data correspondence is filled out
It after entering table corresponding with default display interface content, sends and is shown on display platform, performance is extracted in optimization, accelerates to extract
The efficiency of data, the process optimization of the O&M of realization.
Referring to Fig. 3, a kind of computer equipment is also provided in the embodiment of the present application, which can be server,
Its internal structure can be as shown in Figure 3.The computer equipment includes processor, the memory, network connected by system bus
Interface and database.Wherein, the processor of the Computer Design is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program
And database.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.
The database of the computer equipment is for storing the data such as template, table, preset field.The network interface of the computer equipment is used
It is communicated in passing through network connection with external terminal.To realize that a kind of declaration form extracts number when the computer program is executed by processor
According to method.
Above-mentioned processor executes the method that above-mentioned declaration form extracts data, includes the following steps:
Receive the first preset field for selecting from default display interface of user, wherein first preset field be from
It is shown at least one selected in all preset fields in the default display interface, the preset field is that user terminal is preparatory
Field for matching simultaneously associated storage data in declaration form database is set；
It is got from the declaration form database according to first preset field matched with first preset field
All first data, and table corresponding with the default display interface content is generated according to first preset field；
All first data are corresponded to and are inserted in the table, and show the table.
In one embodiment, the received preset field of the processor includes universal field and configuration field, described
Universal field and the configuration field are the fields for going out single content and getting according to declaration form.
In one embodiment, the processor receives the step for the first preset field that user selects from default display interface
Before rapid, comprising:
User terminal setting is received for match and associated storage all of data in declaration form database described preset
Field；
All preset fields are loaded in the default display interface.
In one embodiment, the step of processor shows the table, comprising:
The table is sent on the display platform, and by the download interface of the table and the category of the table
Property information be shown on the display platform, wherein the attribute information of the table include the time for generating the table, obtain
The fruiting quantities arrived and first preset field.
In one embodiment, all first data are corresponded to the step inserted in the table by the processor,
Include:
According to preset rules, first preset field for receiving user's selection is filled into the table and is referred to
Positioning is set；
According to the mapping relations of preset first preset field and first data, will acquire all described first
Data are filled into the table of corresponding first preset field.
In one embodiment, the processor by the corresponding step inserted in the table of all first data it
Afterwards, comprising:
The content in the table is encrypted by data encryption algorithm.
In one embodiment, all first data are corresponded to and are inserted in the table by the processor, and are shown
After the step of table, further includes:
Receive the download instruction for the download interface that the user terminal selects from the display platform；
The table is transmitted to the user terminal by download interface.
It will be understood by those skilled in the art that structure shown in Fig. 3, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme.
One embodiment of the application also provides a kind of computer storage medium, is stored thereon with computer program, computer journey
A kind of method that declaration form extracts data is realized when sequence is executed by processor, comprising the following steps:
Receive the first preset field for selecting from default display interface of user, wherein first preset field be from
It is shown at least one selected in all preset fields in the default display interface, the preset field is that user terminal is preparatory
Field for matching simultaneously associated storage data in declaration form database is set；
It is got from the declaration form database according to first preset field matched with first preset field
All first data, and table corresponding with the default display interface content is generated according to first preset field；
All first data are corresponded to and are inserted in the table, and show the table.
In one embodiment, the received preset field of the processor includes universal field and configuration field, described
Universal field and the configuration field are the fields for going out single content and getting according to declaration form.
In one embodiment, the processor receives the step for the first preset field that user selects from default display interface
Before rapid, comprising:
User terminal setting is received for match and associated storage all of data in declaration form database described preset
Field；
All preset fields are loaded in the default display interface.
In one embodiment, the step of processor shows the table, comprising:
The table is sent on the display platform, and by the download interface of the table and the category of the table
Property information be shown on the display platform, wherein the attribute information of the table include the time for generating the table, obtain
The fruiting quantities arrived and first preset field.
In one embodiment, all first data are corresponded to the step inserted in the table by the processor,
Include:
According to preset rules, first preset field for receiving user's selection is filled into the table and is referred to
Positioning is set；
According to the mapping relations of preset first preset field and first data, will acquire all described first
Data are filled into the table of corresponding first preset field.
In one embodiment, the processor by the corresponding step inserted in the table of all first data it
Afterwards, comprising:
The content in the table is encrypted by data encryption algorithm.
In one embodiment, all first data are corresponded to and are inserted in the table by the processor, and are shown
After the step of table, further includes:
Receive the download instruction for the download interface that the user terminal selects from the display platform；
The table is transmitted to the user terminal by download interface.
In conclusion for the method, apparatus of the declaration form extraction data provided in the embodiment of the present application, computer equipment and depositing
Storage media, the first preset field selected from default display interface by receiving user terminal, is matched to from declaration form database
Corresponding data, and will data are corresponding insert table corresponding with default display interface content after, send and be shown in display and put down
On platform, performance is extracted in optimization, accelerates the efficiency for extracting data, the process optimization of the O&M of realization.
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 store and 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,
Any reference used in provided herein and embodiment to memory, storage, database or other media,
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 can by diversified forms
, such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double speed are according to rate SDRAM (SSRSDRAM), increasing
Strong 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 should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, device, article or the method that include a series of elements not only include those elements, and
And further include the other elements being not explicitly listed, or further include for this process, device, article or method institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to do
There is also other identical elements in the process, device of element, article or method.
The foregoing is merely preferred embodiment of the present application, are not intended to limit the scope of the patents of the application, all utilizations
Equivalent structure or equivalent flow shift made by present specification and accompanying drawing content is applied directly or indirectly in other correlations
Technical field, similarly include in the scope of patent protection of the application.
Claims (10)
1. a kind of method that declaration form extracts data, which comprises the following steps:
Receive the first preset field that user selects from default display interface, wherein first preset field is from display
At least one selected in all preset fields in the default display interface, the preset field are that user terminal is preset
For match simultaneously associated storage data in declaration form database field；
It is got from the declaration form database according to first preset field matched all with first preset field
First data, and table corresponding with the default display interface content is generated according to first preset field；
All first data are corresponded to and are inserted in the table, and show the table.
2. the method that declaration form according to claim 1 extracts data, which is characterized in that the preset field includes general words
Section and configuration field, the universal field and the configuration field are the fields for going out single content and getting according to declaration form.
3. the method that declaration form according to claim 1 extracts data, which is characterized in that the reception user is from default display
Before the step of the first preset field selected in interface, comprising:
The user terminal setting is received for matching all preset fields of simultaneously associated storage data in declaration form database；
All preset fields are loaded in the default display interface.
4. the method that declaration form according to claim 1 extracts data, which is characterized in that the step of the display table
Suddenly, comprising:
The table is sent on the display platform, and the attribute of the download interface of the table and the table is believed
Breath is shown on the display platform, wherein the attribute information of the table includes the time for generating the table, gets
Fruiting quantities and first preset field.
5. the method that declaration form according to claim 1 extracts data, which is characterized in that described by all first numbers
According to the corresponding step inserted in the table, comprising:
According to preset rules, first preset field for receiving user's selection is filled into specific bit in the table
It sets；
According to the mapping relations of preset first preset field and first data, all first data that will acquire
It is filled into the table of corresponding first preset field.
6. the method that declaration form according to claim 1 extracts data, which is characterized in that described by all first numbers
It is inserted after the step in the table according to corresponding, comprising:
The content in the table is encrypted by data encryption algorithm.
7. the method that declaration form according to claim 1 extracts data, which is characterized in that described by all first numbers
It is inserted in the table according to corresponding, and after the step of showing the table, further includes:
Receive the download instruction for the download interface that the user terminal selects from the display platform；
The table is transmitted to the user terminal by download interface.
8. the device that a kind of declaration form extracts data characterized by comprising
First receiving module, the first preset field selected from default display interface for receiving user, wherein described first
Preset field is from being shown at least one selected in all preset fields in the default display interface, the preset field
It is that user terminal is pre-set for matching the field of simultaneously associated storage data in declaration form database；
First obtains module, for being got from the declaration form database according to first preset field with described first in advance
If all first data of fields match, and it is corresponding with the default display interface content according to first preset field generation
Table；
Generation module is inserted in the table for corresponding to all first data, and shows the table.
9. a kind of computer equipment, including memory and processor, it is stored with computer program in the memory, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer storage medium, is stored thereon with computer program, which is characterized in that the computer program is located
The step of reason device realizes method described in any one of claims 1 to 7 when executing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811531547.9A CN109815276A (en) | 2018-12-14 | 2018-12-14 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811531547.9A CN109815276A (en) | 2018-12-14 | 2018-12-14 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109815276A true CN109815276A (en) | 2019-05-28 |
Family
ID=66602933
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811531547.9A Pending CN109815276A (en) | 2018-12-14 | 2018-12-14 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109815276A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
| CN111080459A (en) * | 2019-11-21 | 2020-04-28 | 泰康保险集团股份有限公司 | Configuration method and device of configuration file and readable storage medium |
| CN111651494A (en) * | 2020-05-29 | 2020-09-11 | 泰康保险集团股份有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
| CN113360376A (en) * | 2021-06-01 | 2021-09-07 | 北京沃东天骏信息技术有限公司 | Buried point testing method and device |
| CN114979120A (en) * | 2022-05-24 | 2022-08-30 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
| WO2023001281A1 (en) * | 2021-07-23 | 2023-01-26 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, terminal, and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for configuring field attribute |
| CN107886439A (en) * | 2017-12-21 | 2018-04-06 | 中国平安财产保险股份有限公司 | Insurance products development approach, device, equipment and computer-readable recording medium |
| CN108280768A (en) * | 2017-12-20 | 2018-07-13 | 平安科技（深圳）有限公司 | Electronic device, declaration form merchandiser expense statistical method and storage medium |
-
2018
- 2018-12-14 CN CN201811531547.9A patent/CN109815276A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for configuring field attribute |
| CN108280768A (en) * | 2017-12-20 | 2018-07-13 | 平安科技（深圳）有限公司 | Electronic device, declaration form merchandiser expense statistical method and storage medium |
| CN107886439A (en) * | 2017-12-21 | 2018-04-06 | 中国平安财产保险股份有限公司 | Insurance products development approach, device, equipment and computer-readable recording medium |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
| CN110399420B (en) * | 2019-07-30 | 2022-11-22 | 广州吉信网络科技开发有限公司 | Export method, electronic equipment and medium of configurable Excel format |
| CN111080459A (en) * | 2019-11-21 | 2020-04-28 | 泰康保险集团股份有限公司 | Configuration method and device of configuration file and readable storage medium |
| CN111080459B (en) * | 2019-11-21 | 2023-08-25 | 泰康保险集团股份有限公司 | Configuration file configuration method and device and readable storage medium |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
| CN112966481B (en) * | 2019-12-13 | 2023-09-29 | 北京懿医云科技有限公司 | Data form display method and device |
| CN111651494A (en) * | 2020-05-29 | 2020-09-11 | 泰康保险集团股份有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN111651494B (en) * | 2020-05-29 | 2023-04-18 | 泰康保险集团股份有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN113360376A (en) * | 2021-06-01 | 2021-09-07 | 北京沃东天骏信息技术有限公司 | Buried point testing method and device |
| WO2023001281A1 (en) * | 2021-07-23 | 2023-01-26 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, terminal, and storage medium |
| CN114979120A (en) * | 2022-05-24 | 2022-08-30 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
| CN114979120B (en) * | 2022-05-24 | 2023-10-13 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109815276A (en) | Method, apparatus, computer equipment and the storage medium of declaration form extraction data | |
| EP3443466B1 (en) | Document automation | |
| CN107871083A (en) | Desensitize regular collocation method, application server and computer-readable recording medium | |
| US9767316B1 (en) | Systems and methods for scrubbing confidential data | |
| CN109558440A (en) | Batch data processing method, device, computer equipment and storage medium | |
| US20110289420A1 (en) | Screen customization supporting system, screen customization supporting method, and computer-readable recording medium | |
| US20170270083A1 (en) | Web-intrinsic interactive documents | |
| US8473576B2 (en) | Communication system for process-oriented acquisition, storage, transmission, and provision of data | |
| CN102004752A (en) | Flexible cube data warehousing | |
| US20080288471A1 (en) | Apparatus and method for providing a data marketplace | |
| CN109816331A (en) | Audit task processing method, device, computer equipment and storage medium | |
| CN109062925A (en) | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence | |
| CN114611481A (en) | Template configuration method and device, computer equipment and storage medium | |
| CN107766313B (en) | A kind of introduction method and its terminal of data list | |
| EP1982245B1 (en) | Security key with instructions | |
| WO2019092117A1 (en) | Method and apparatus for providing a workpiece representation at a production station | |
| US10956408B2 (en) | Data transformation tool | |
| CN109325873A (en) | Self-service method for processing business, device, computer equipment and storage medium | |
| CN111159729A (en) | Authority control method, device and storage medium | |
| CN116756711A (en) | Data processing method, device, equipment and medium | |
| DE102012016164A1 (en) | Security element and method for installing data in the security element | |
| CN107886438A (en) | Vehicle insurance declaration form is self-service to correct method, apparatus, equipment and readable storage medium storing program for executing | |
| CN115936628A (en) | Data auditing method, device, equipment, storage medium and computer program product | |
| CN111177242B (en) | Time-based data display method and device, computer equipment and storage medium | |
| JP6705998B1 (en) | Server device, server device control method, program, genuine product determination system, and genuine product determination system control method |
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 |