CN109325045A - A kind of method and device of issuing bank - Google Patents
A kind of method and device of issuing bank Download PDFInfo
- Publication number
- CN109325045A CN109325045A CN201811106518.8A CN201811106518A CN109325045A CN 109325045 A CN109325045 A CN 109325045A CN 201811106518 A CN201811106518 A CN 201811106518A CN 109325045 A CN109325045 A CN 109325045A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- verified
- target data
- corresponding relationship
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Debugging And Monitoring (AREA)
Abstract
This application discloses a kind of method and devices for opening new bank, wherein method includes: to obtain according to multiple data forms to be verified of preset data template completion；According to the default corresponding relationship between the position and verification rule of data in each data form to be verified, the data in each data form to be verified are verified；Feedback does not meet position and the required verification rule met of the target data of the target data of the verification rule；For meet it is described verification rule target data table, according to default SQL script template corresponding to the target data table, by the target data table each row of data generate SQL statement；Execute SQL statement generated.By the embodiment of the present application, set up branch or sub-line are opened up in existing banking system under the premise of guaranteeing for opening branch's perhaps data accuracy of sub-line.
Description
Technical field
This application involves data processing fields, more particularly to a kind of method and device of issuing bank.
Background technique
For the expansion of banking, need to open up branch or the sub-line of certain bank in different places.
One branch of every establishment perhaps sub-line when need to open up set up branch or son in existing banking system
Row, operates normally set up branch or sub-line.For example, existing A bank, now need to set up again one in somewhere
The branch of A bank perhaps sub-line at this time, it may be necessary to open up set up branch or sub-line in existing A banking system so that
In existing A banking system, the branch set up or sub-line can be operated normally.
In order to guarantee that the branch opened in existing banking system or sub-line can operate normally, need to guarantee to be used for
The accuracy of data needed for opening branch or sub-line in existing banking system, therefore, it is necessary to guarantee for opening branch
Perhaps set up branch or sub-line are opened up under the premise of the data accuracy of sub-line in existing banking system.
Summary of the invention
Based on this, present applicant proposes a kind of methods for opening new bank, to guarantee for opening branch or son
Under the premise of capable data accuracy, set up branch or sub-line are opened up in existing banking system.
Present invention also provides a kind of device for opening new bank, to guarantee above method realization in practice and answer
With.
Technical solution provided by the present application are as follows:
This application discloses a kind of methods for opening new bank, comprising:
It obtains according to multiple data forms to be verified of preset data template completion；
According to the default corresponding relationship between the position and verification rule of data in each data form to be verified, to described every
Data in a data form to be verified are verified；
Feedback does not meet position and the required verification met of the target data of the target data of the verification rule
Rule, so as to target data described in verification rules modification of the user according to the required satisfaction, so that the multiple number to be verified
Meet the verification rule according to the data in table；
For the target data table for meeting the verification rule, preset according to corresponding to the target data table
Each row of data in the target data table is generated SQL statement, obtained and the multiple data form by SQL script template
The corresponding SQL statement of middle each row of data；The target data table is any one tables of data in the multiple data form
Lattice；
Execute SQL statement generated.
Wherein, the corresponding relationship between the position and verification rule according to data in each data form to be verified, it is right
Data in each data form to be verified are verified, comprising:
Data form to be verified is successively obtained according to preset order；
For acquired target data form to be verified, data corresponding with target data form to be verified are obtained
Corresponding relationship between position and verification rule；Corresponding relationship between the Data Position and verification rule includes: the data institute
Belonging to the first corresponding relationship and the data between the column label and data format of category between line label and service logic
Two corresponding relationships；The target data form to be verified is any one number to be verified in the multiple data form to be verified
According to table；
According to first corresponding relationship and second corresponding relationship, to the number in target data form to be verified
According to being verified.
Wherein, described according to first corresponding relationship and second corresponding relationship, to target data to be verified
Data in table are verified, comprising:
For the first data in target data form to be verified, described is obtained from first corresponding relationship
Target data format corresponding to column label belonging to one data；First data are in target data form to be verified
Any data；
Judge whether the data format of first data meets the target data format；
Detect the target line for meeting first corresponding relationship in target data form to be verified；
From second corresponding relationship, the corresponding target service logic of line label belonging to the target line is obtained；
Judge whether the data in the target line meet the target service logic.
Wherein, satisfaction needed for the feedback does not meet the target data and the target data of the verification rule
Verification rule, comprising:
If the data format of first data is unsatisfactory for the target data format, it is determined that first data are in institute
State the position in target data form to be verified；
Feed back position and the target data lattice of first data in target data form to be verified
Formula；
If the data in the target line are unsatisfactory for the target service logic, it is determined that the target line is in the target
Position in data form to be verified；
Feed back position and the target service logic of the target line in target data form to be verified.
Wherein, it is described for meet it is described verification rule target data table, according to the target data table institute
Each row of data in the target data table is generated SQL statement by corresponding default SQL script template, comprising:
For the target data table for meeting verification rule, the corresponding default SQL script of the target data table is obtained
Template；
According to acquired default SQL script template, each row of data in the target data table is generated into SQL language
Sentence.
Disclosed herein as well is a kind of devices for opening new bank, comprising:
Acquiring unit, for obtaining multiple data forms to be verified according to preset data template completion；
Verification unit, it is default corresponding between regular with verification for the position according to data in each data form to be verified
Relationship verifies the data in each data form to be verified；
Feedback unit, for feeding back the position for not meeting the regular target data of the verification and the target data
The verification rule of required satisfaction, so as to target data described in verification rules modification of the user according to the required satisfaction, so that institute
It states the data in multiple data forms to be verified and meets the verification rule；
Generation unit, for for meet it is described verification rule target data table, according to the target matrix
Each row of data in the target data table is generated SQL statement, obtained and institute by default SQL script template corresponding to lattice
State the corresponding SQL statement of each row of data in multiple data forms；The target data table is in the multiple data form
Any one data form；
Execution unit, for executing SQL statement generated.
Wherein, the verification unit, comprising:
First obtains subelement, for successively obtaining data form to be verified according to preset order；
Second obtains subelement, for being directed to acquired target data form to be verified, obtains and waits for school with the target
Test the corresponding relationship between the corresponding Data Position of data form and verification rule；It is corresponding between the Data Position and verification rule
Relationship includes: row belonging to the first corresponding relationship and data between column label and data format belonging to the data
The second corresponding relationship between label and service logic；The target data form to be verified is the multiple data form to be verified
In any one data form to be verified；
Subelement is verified, for waiting for school to the target according to first corresponding relationship and second corresponding relationship
The data tested in data form are verified.
Wherein, subelement is verified, comprising:
First obtains module, the first data for being directed in target data form to be verified, from described first pair
It should be related to target data format corresponding to column label belonging to middle acquisition first data；First data are the mesh
Mark any data in data form to be verified；
First judgment module, for judging whether the data format of first data meets the target data format；
Detection module, for detecting the target for meeting first corresponding relationship in target data form to be verified
Row；
Second obtains module, corresponding for from second corresponding relationship, obtaining line label belonging to the target line
Target service logic；
Whether the second judgment module, the data for judging in the target line meet the target service logic.
Wherein, the feedback unit, comprising:
First determines subelement, and the data format for judging first data in the first judgment module is discontented
In the case of the foot target data format, position of first data in target data form to be verified is determined；
First feedback subelement, for feeding back position of first data in target data form to be verified,
And the target data format；
Second determines subelement, and the data for going out in the target line in second judgment module are unsatisfactory for the mesh
In the case where marking service logic, position of the target line in target data form to be verified is determined；
Second feedback subelement, for feeding back position of the target line in target data form to be verified, with
And the target service logic.
Wherein, the generation unit, comprising:
Third obtains subelement, for obtaining the target matrix for the target data table for meeting verification rule
The corresponding default SQL script template of lattice；
Subelement is generated, for according to acquired default SQL script template, by every row in the target data table
Data generate SQL statement.
The application's has the beneficial effect that
In the embodiment of the present application, according to the position of data in pre-set each data form to be verified and verification rule
Between corresponding relationship, the verification to the data in each of acquired data form to be verified may be implemented, while passing through feedback
The verification rule met needed for the target data and target data of verification rule is not met, can guarantee that verification passes through data
Verification accuracy；And according to default SQL script template corresponding to target data table, can will be in target data table
Each row of data generate SQL statement, and execute SQL script generated, realize and guaranteeing for being opened in existing banking system
Vertical branch perhaps opens up set up branch or son under the premise of the data accuracy of sub-line in existing banking system
Row.
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 a kind of flow chart for opening new bank's embodiment of the method in the application；
Fig. 2 is the process for the embodiment of the method that the data in the application in a kind of pair of data to be tested table are verified
Figure；
Fig. 3 is a kind of flow chart for the embodiment of the method for generating SQL script in the application；
Fig. 4 is a kind of structural schematic diagram for the Installation practice for opening new bank in the 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.
Fig. 1 be one kind disclosed in the present application open new bank's method the following steps are included:
Step 101: obtaining according to multiple data forms to be verified of preset data template completion.
In the present embodiment, it when needing to open new bank, needs to collect initialization data, for example, new set up silver
The information such as capable Bank Number, Bank Name；It is new to set up department name included by bank, the information such as industry number；It is new to set up
The information such as employee's title, employee number in bank；It is new to set up the information such as bank location.
After being collected into initialization data, initialization data is filled up in pre-set data template, wherein data
Template can be the table of preset format, for example, for excel table, Word table, PDF table etc., certainly, in practical application
In, the format of table can also be other, and the present embodiment does not limit the specific format of table.
In addition, data template alsies specify the school met needed for the content of field and field in each data form
Test rule；For example, including bank's Basic Information Table, department table, Yuan Gongbiao, parameter list etc. in data template, wherein in bank's base
Field included in this information table can be Bank Name, mechanism of bank organization number and Date of Incorporation etc.；Meanwhile in bank
The data format of each field contents is alsied specify in Basic Information Table, and the business met needed for each row of data inserted is patrolled
Volume.
For example, for data format: the data format of the content of this field of Bank Name is character type, bank organization's machine
The data format that structure numbers the content of this field is numeric type, and the data format of the content of this field of the Date of Incorporation is the date
Type etc..For the service logic of satisfaction needed for each row of data in bank's Basic Information Table: for Bank Name, the silver inserted
Row organization number and the content of the Date of Incorporation whether there is in the database.
The initialization data of collection is filled according to the data format of data template defined, in this step, is obtained
Take multiple data forms after initialization data being filled according to data template, due to needing to acquired every number
It is verified according to the data in table, for convenience, acquired each data form is referred to as to school in this step
Test data form.
Step 102: according to data in each data form to be verified position and verification rule between default corresponding relationship,
Data in each data form to be verified are verified.
Needed for the field filled in as needed for being defined in each data form in data template, the content of each field
The service logic met needed for the data format and each row of data of satisfaction forms number at this point, being directed to each data form
Unit where the data format of satisfaction needed for content according to cell each in table, and any data line for being filled in
The service logic met needed for lattice.For convenience, in the present embodiment, for the number in any cell in data form
According to the data format and service logic of required satisfaction, it is referred to as the verification rule of the cell.Therefore, for each to be tested
Data form forms the corresponding relationship in the data form between cell location and verification rule.
For example, in bank's Basic Information Table, it is assumed that the entitled Bank Name of the field of first row, the field of secondary series are entitled
Mechanism of bank organization number, the tertial field entitled Date of Incorporation, at this point, the corresponding data of cell of the second row first row
Format is character type, in the cell of the second row secondary series needed for the data format of data filled in be numeric type, the second row the
The data format for the data filled in needed in the cell of three column is date type, also, the data of the second row are needed in database
In have existed.Therefore, in bank's Basic Information Table, position of the cell in data form is formd and between verification rule
Corresponding relationship.
In this step, according to the default corresponding pass between the position of data in each data form to be verified and verification rule
System, verifies the data in each data form to be verified.Specifically, to the data in each data form to be tested into
The process of row verification, the embodiment of the method that the data in data form can be verified with reference to corresponding to Fig. 2, here not
It repeats again.
Step 103: feedback does not meet position and the required verification met of target data of the target data of verification rule
Rule, so that user is according to the verification rules modification target data of required satisfaction, so that the number in multiple data forms to be verified
It is regular according to the verification is met.
In the present embodiment, for any data form to be verified, data in data form to be verified any according to this
Position and verification rule between default corresponding relationship can after being verified to the data in any data form to be verified
There can be the data in certain cells and be unsatisfactory for required data format, in this step, for convenience, will be unsatisfactory for
The data of required data format are referred to as target data.Position of the target data in any data form to be tested is counted,
And the verification rule (target data needed for meet data format and service logic) met needed for target data, and by institute
The verification rule met needed for the position of the target data of statistics and target data feeds back to user, so that user is according to target
The verification rules modification target data met needed for data.
In the present embodiment, the modified target data of user is continued to verify, if not meeting target data institute also
The verification rule needed continues the verification rule of the position of the target data of verification rule and required satisfaction needed for statistics is unsatisfactory for
Then, it until the data in acquired multiple data forms to be verified all meet required verification rule, obtains multiple meeting school
Test the data form of rule, wherein a data form to be verified corresponding one meets the data form of verification rule.In reality
It, can be after the data in all data forms be all verified, by the target data counted and target data institute in
The verification rule that need to meet is sent to user, modifies so that user is unified to target data.
Step 104: for the target data table for meeting verification rule, being preset according to corresponding to target data table
Each row of data in target data table is generated SQL statement, obtained and line number every in multiple data forms by SQL script template
According to corresponding SQL statement.
In the present embodiment, target data table is any one met in multiple target data tables of verification rule
Data form.For target data table, pre-set SQL script template, so as to according to corresponding SQL script template by mesh
Any row data in mark data form are converted into a SQL statement, for the target data table, obtain a plurality of SQL statement.
Specifically, the process of SQL statement is generated according to default SQL script template, it can be with reference to generation corresponding to Fig. 3
The embodiment of the method for SQL script, which is not described herein again.
Step 105: executing SQL statement generated.
After generating a plurality of SQL statement to each data form, SQL statement generated is executed automatically.
Fig. 2 is that the method that a kind of data treated in verification data form disclosed in the present application are verified includes following step
It is rapid:
Step 201: data form to be verified is successively obtained according to preset order.
In the present embodiment, it is specified that the sequence that is verified to the data in multiple data forms to be verified, in this step
In rapid, successively the data in each data form to be verified are verified according to preset sequence.For example, to be verified
Multiple data forms are respectively bank's Basic Information Table, department table, Yuan Gongbiao, parameter list, and preset sequence is respectively as follows: silver
Row Basic Information Table, Yuan Gongbiao, department table and parameter list；At this point, in this step, acquisition bank's Basic Information Table conduct first
Data form to be verified then obtains employee's table, to the data in employee's table after the data check in bank's Basic Information Table
It is verified, then obtains department table, the data in department table are verified；Successively according to preset order to each to be verified
Data in data form are verified.
Step 202: for acquired target data form to be verified, obtaining corresponding with target data form to be verified
Corresponding relationship between Data Position and verification rule.
In the present embodiment, according to the acquisition of data form to be verified sequence, the data in data form to be verified are set
With the corresponding relationship between verification rule.For example, the sequence of data form to be verified be respectively bank's Basic Information Table, Yuan Gongbiao,
In the present embodiment, data corresponding with each data form to be verified and verification rule has been previously set in department table and parameter list
Between corresponding relationship.
In this step, target data form to be verified is any one number to be verified in multiple data forms to be verified
According to table, for acquired target data form to be verified, the acquisition sequence obtained with target data form to be verified is right
Corresponding relationship between the Data Position answered and verification rule.By taking target data form to be verified is bank's Basic Information Table as an example,
In this step, the corresponding relationship in bank's Basic Information Table between data and verification rule is obtained.
In this step, data form to be verified for target, data and verification in target data form to be verified
Corresponding relationship between rule may include: the first corresponding relationship and the data between column label and data format belonging to data
The second corresponding relationship between affiliated line label and service logic.
Also by taking bank's Basic Information Table as an example, data and verification are advised in acquired bank's Basic Information Table in this step
Corresponding relationship between then specifically includes: the column label in bank's Basic Information Table and the corresponding relationship between data format, for example, the
The data format of one column is character type, and the data format of secondary series is numeric type, and tertial data format is date type etc.；This
It outside, can also be including the second corresponding relationship in bank's Basic Information Table between line label and service logic, for example, bank believes substantially
Each row of data must exist in the database in breath table.
Step 203: according to the first corresponding relationship and the second corresponding relationship, to the data in target data form to be verified into
Row verification.
The first corresponding relationship and rower in getting target data form to be verified between column label and data format
After the second corresponding relationship number between service logic, in this step, to the data in target data form to be verified, according to the
One corresponding relationship is verified with the second corresponding relationship.Specific checking procedure may include step A1~step A5:
Step A1: for the first data in target data form to be verified, the first number is obtained from the first corresponding relationship
According to target data format corresponding to affiliated column label.
In this step, the first data are any data in target data form to be verified.Specifically, from Data Position
In the first relationship between data format, data format corresponding to column label belonging to first data is obtained, in order to describe
Convenient, in this step, data format corresponding to the column label by the first data is referred to as target data format.
Step A2: judge whether the data format of the first data meets target data format.
For example, data of first data for the second row secondary series in bank's Basic Information Table, and bank's essential information
The target data format of secondary series in table is numeric type.In this step, judge the second row in bank's Basic Information Table
Whether the data format of two column is numeric type.
If the data format of the first data is unsatisfactory for target data format, A2 is thened follow the steps, otherwise, obtains next number
According to continuing to execute the movement of this step.
Step A2: position and target data format of first data in target data form to be verified are determined.
When the data format of the first data is unsatisfactory for target data format, determine that first data are to be verified in the target
Position and target data format in data form.
Step A3: meet the target line of the first corresponding relationship in detection target data form to be verified.
After the verification that each data in target data form to be verified are carried out with data format, for convenience,
In this step, if the data of certain a line all meet required data format, the row data are referred to as target line, in this step
In, detect the target line in target data form to be verified.For example, each data of the second row in bank's Basic Information Table
All meet required data format, at this point, the second row data in bank's Basic Information Table are exactly target line.
Step A4: from the second corresponding relationship, the corresponding target service logic of line label belonging to target line is obtained.
From the corresponding data line label of bank's Basic Information Table and the second corresponding relationship of service logic, the second row is obtained
The service logic of satisfaction needed for acquired target line is referred to as by the service logic met needed for data for convenience
Target service logic.
Step A5: judge whether the data in target line meet target service logic.
Judge whether the data in the second row in bank's Basic Information Table meet target service logic, in practical application
In, target service logic can be present in database for the data of target line.Judged in bank's Basic Information Table at this time
Whether the second row data are present in database.If the data in target line are unsatisfactory for target service logic, then follow the steps
A6；If it exists, then judge whether next target line in bank's Basic Information Table meets satisfaction needed for next target line
Target service logic.
Step A6: position and target service logic of the target line in target data form to be verified are determined.
If the data in target line are unsatisfactory for required target service logic, in this step, determine target line in mesh
Mark the position in data form to be verified and the target service logic of required satisfaction.Also by taking bank's Basic Information Table as an example, if
Some data are not stored in database in the second row data in bank's Basic Information Table, at this point, the second row data are not
Full required target service logic, at this point, determine the position of target line, i.e. the target met needed for the second row and the second row
Service logic.
According to above-mentioned steps A1~step A6, after being verified to the data in target data form to be verified, by target
It is unsatisfactory for the data of required inspection rule in data form to be verified, feeds back to user, wherein feeds back to the data packet of user
Include the data for being unsatisfactory for verification rule in data form to be verified the target data format of position and required satisfaction and/or
Target service logic, so that user is to the data of verification rule needed for being unsatisfactory in multiple data forms to be verified, according to feedback
Target data format and/or target service logic modify.And by modified data feedback to the present embodiment, this implementation
Example continues to be verified according to step A1~step A6 movement, until the data in each data form to be verified meet institute
The verification rule needed is extremely, at this point, obtaining multiple data forms for meeting verification rule.
Fig. 3 be it is disclosed in the present application it is a kind of generate SQL script method the following steps are included:
Step 301: for the target data table for meeting verification rule, it is corresponding default to obtain the target data table
SQL script template.
In the present embodiment, the data form for meeting verification rule will be met according to the field information in data form
The data form of verification rule is classified, and presets SQL template to any type of data table.For example, bank believes substantially
Include in breath table is field relevant to bank, and include in department information table is field relevant to department, employee information
It include the relevant field of employee in table.Since bank's Basic Information Table, department information table and employee information table are to belong to inhomogeneity
Information table.Wherein, bank's Basic Information Table belongs to one kind, and department information table belongs to one kind, and employee information table belongs to one kind, because
This, is arranged corresponding SQL template for bank's Basic Information Table, corresponding SQL template is arranged for department information table, for member
Corresponding SQL template is arranged in work information table.
In this step, for the target data table for meeting verification rule, number belonging to the target data table is determined
Default SQL template is determined according to form types, and according to the data form type determined.
Step 302: according to acquired default SQL script template, each row of data in the target data table being generated
SQL statement.
For the target data table for meeting verification rule, according to the corresponding default SQL script mould of the target data table
Each row of data in the target data table is generated SQL statement by plate.
At this point, in the present embodiment, each row of data in each data form is generated SQL statement, execution is given birth to
At SQL statement, realization a Ge Xin bank is opened in existing banking system.By in this present embodiment, SQL language generated
Sentence has can be by ordering the characteristic called and executed immediately, and therefore, the present embodiment may not need according to SQL script shape generated
At released version, but, it executes SQL script generated and installs in systems automatically, to open new bank automatically.
Fig. 4 is that one kind disclosed in the present application opens new bank device, comprising:
Acquiring unit 401, for obtaining multiple data forms to be verified according to preset data template completion；
Verification unit 402, for default between the position according to data in each data form to be verified and verification rule
Corresponding relationship verifies the data in each data form to be verified；
Feedback unit 403, for feeding back the position for not meeting the regular target data of the verification and the number of targets
According to the verification rule of required satisfaction, so as to target data described in verification rules modification of the user according to the required satisfaction, so that
Data in the multiple data form to be verified meet the verification rule；
Generation unit 404, for for meet it is described verification rule target data table, according to the target data
Default SQL script template corresponding to table, by the target data table each row of data generate SQL statement, obtain with
The corresponding SQL statement of each row of data in the multiple data form；The target data table is in the multiple data form
Any one data form；
Execution unit 405, for executing SQL statement generated.
Wherein, the verification unit 402 may include:
First obtains subelement, for successively obtaining data form to be verified according to preset order；
Second obtains subelement, for being directed to acquired target data form to be verified, obtains and waits for school with the target
Test the corresponding relationship between the corresponding Data Position of data form and verification rule；It is corresponding between the Data Position and verification rule
Relationship includes: row belonging to the first corresponding relationship and data between column label and data format belonging to the data
The second corresponding relationship between label and service logic；The target data form to be verified is the multiple data form to be verified
In any one data form to be verified；
Subelement is verified, for waiting for school to the target according to first corresponding relationship and second corresponding relationship
The data tested in data form are verified.
Wherein, subelement is verified, may include:
First obtains module, the first data for being directed in target data form to be verified, from described first pair
It should be related to target data format corresponding to column label belonging to middle acquisition first data；First data are the mesh
Mark any data in data form to be verified；
First judgment module, for judging whether the data format of first data meets the target data format；
Detection module, for detecting the target for meeting first corresponding relationship in target data form to be verified
Row；
Second obtains module, corresponding for from second corresponding relationship, obtaining line label belonging to the target line
Target service logic；
Whether the second judgment module, the data for judging in the target line meet the target service logic.
Wherein, the feedback unit 403 may include:
First determines subelement, and the data format for judging first data in the first judgment module is discontented
In the case of the foot target data format, position of first data in target data form to be verified is determined；
First feedback subelement, for feeding back position of first data in target data form to be verified,
And the target data format；
Second determines subelement, and the data for going out in the target line in second judgment module are unsatisfactory for the mesh
In the case where marking service logic, position of the target line in target data form to be verified is determined；
Second feedback subelement, for feeding back position of the target line in target data form to be verified, with
And the target service logic.
Wherein, the generation unit 404 may include:
Third obtains subelement, for obtaining the target matrix for the target data table for meeting verification rule
The corresponding default SQL script template of lattice；
Subelement is generated, for according to acquired default SQL script template, by every row in the target data table
Data generate SQL statement.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with it is other
The difference of embodiment, the same or similar parts in each embodiment may refer to each other.Herein, such as " first " and
The relational terms of " second " or the like are only used to distinguish one entity or operation from another entity or operation, and
Without necessarily requiring or implying that between these entities or operation, there are any actual relationship or orders.In the text
The word explanations such as "include", "comprise" be comprising meaning rather than exclusive or exhaustive meaning；That is, be " include but
Be not limited to " meaning.Deformation, same replacement without departing from the inventive concept of the premise, can also be made, improved etc., these
Belong to protection scope of the present invention.
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 (10)
1. a kind of method for opening new bank characterized by comprising
It obtains according to multiple data forms to be verified of preset data template completion；
According to data in each data form to be verified position and verification rule between default corresponding relationship, to it is described each to
Data in verification data form are verified；
Feedback does not meet position and the required verification rule met of the target data of the target data of the verification rule
Then, target data described in the verification rules modification so as to user according to the required satisfaction, so that the multiple data to be verified
Data in table meet the verification rule；
For meet it is described verification rule target data table, according to default SQL corresponding to the target data table
Each row of data in the target data table is generated SQL statement by script template, obtain with it is every in the multiple data form
The corresponding SQL statement of row data；The target data table is any one data form in the multiple data form；
Execute SQL statement generated.
2. the method according to claim 1, wherein the position according to data in each data form to be verified
The corresponding relationship between rule is set and is verified, the data in each data form to be verified are verified, comprising:
Data form to be verified is successively obtained according to preset order；
For acquired target data form to be verified, Data Position corresponding with target data form to be verified is obtained
With the corresponding relationship between verification rule；Corresponding relationship between the Data Position and verification rule includes: belonging to the data
Second pair belonging to the first corresponding relationship and the data between column label and data format between line label and service logic
It should be related to；The target data form to be verified is any one tables of data to be verified in the multiple data form to be verified
Lattice；
According to first corresponding relationship and second corresponding relationship, to the data in target data form to be verified into
Row verification.
3. according to the method described in claim 2, it is characterized in that, described according to first corresponding relationship and described second pair
It should be related to, the data in target data form to be verified are verified, comprising:
For the first data in target data form to be verified, first number is obtained from first corresponding relationship
According to target data format corresponding to affiliated column label；First data are appointing in target data form to be verified
One data；
Judge whether the data format of first data meets the target data format；
Detect the target line for meeting first corresponding relationship in target data form to be verified；
From second corresponding relationship, the corresponding target service logic of line label belonging to the target line is obtained；
Judge whether the data in the target line meet the target service logic.
4. according to the method described in claim 3, it is characterized in that, the feedback does not meet the number of targets of the verification rule
According to and the target data needed for meet verification rule, comprising:
If the data format of first data is unsatisfactory for the target data format, it is determined that first data are in the mesh
Mark the position in data form to be verified；
Feed back position and the target data format of first data in target data form to be verified；
If the data in the target line are unsatisfactory for the target service logic, it is determined that the target line waits for school in the target
Test the position in data form；
Feed back position and the target service logic of the target line in target data form to be verified.
5. the method according to claim 1, wherein described for the target matrix for meeting the verification rule
Lattice, according to default SQL script template corresponding to the target data table, by every line number in the target data table
According to generation SQL statement, comprising:
For the target data table for meeting verification rule, the corresponding default SQL script template of the target data table is obtained；
According to acquired default SQL script template, each row of data in the target data table is generated into SQL statement.
6. a kind of device for opening new bank characterized by comprising
Acquiring unit, for obtaining multiple data forms to be verified according to preset data template completion；
Verification unit, for default corresponding pass of the position according to data in each data form to be verified between regular with verification
System, verifies the data in each data form to be verified；
Feedback unit, for feeding back needed for position and the target data for the target data for not meeting the verification rule
The verification rule of satisfaction, so as to target data described in verification rules modification of the user according to the required satisfaction, so that described more
Data in a data form to be verified meet the verification rule；
Generation unit, for for meet it is described verification rule target data table, according to the target data table institute
Corresponding default SQL script template, by the target data table each row of data generate SQL statement, obtain with it is described more
The corresponding SQL statement of each row of data in a data form；The target data table is any in the multiple data form
One data form；
Execution unit, for executing SQL statement generated.
7. device according to claim 6, which is characterized in that the verification unit, comprising:
First obtains subelement, for successively obtaining data form to be verified according to preset order；
Second obtains subelement, for being directed to acquired target data form to be verified, obtains and target number to be verified
According to the corresponding relationship between the corresponding Data Position of table and verification rule；Corresponding relationship between the Data Position and verification rule
It include: line label belonging to the first corresponding relationship and the data between column label and data format belonging to the data
The second corresponding relationship between service logic；The target data form to be verified is in the multiple data form to be verified
Any one data form to be verified；
Subelement is verified, is used for according to first corresponding relationship and second corresponding relationship, to target number to be verified
It is verified according to the data in table.
8. device according to claim 7, which is characterized in that verification subelement, comprising:
First obtains module, for corresponding to and closing from described first for the first data in target data form to be verified
Target data format corresponding to column label belonging to first data is obtained in system；First data are that the target waits for
Verify any data in data form；
First judgment module, for judging whether the data format of first data meets the target data format；
Detection module, for detecting the target line for meeting first corresponding relationship in target data form to be verified；
Second obtains module, for obtaining the corresponding mesh of line label belonging to the target line from second corresponding relationship
Mark service logic；
Whether the second judgment module, the data for judging in the target line meet the target service logic.
9. device according to claim 8, which is characterized in that the feedback unit, comprising:
First determines subelement, for judging that the data format of first data is unsatisfactory for institute in the first judgment module
In the case of stating target data format, position of first data in target data form to be verified is determined；
First feedback subelement, for feeding back position of first data in target data form to be verified, and
The target data format；
Second determines subelement, and the data for going out in the target line in second judgment module are unsatisfactory for the target industry
In the case where logic of being engaged in, position of the target line in target data form to be verified is determined；
Second feedback subelement, for feeding back position of the target line in target data form to be verified, Yi Jisuo
State target service logic.
10. device according to claim 6, which is characterized in that the generation unit, comprising:
Third obtains subelement, for obtaining the target data table pair for the target data table for meeting verification rule
The default SQL script template answered；
Subelement is generated, for according to acquired default SQL script template, by each row of data in the target data table
Generate SQL statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811106518.8A CN109325045B (en) | 2018-09-21 | 2018-09-21 | Method and device for opening bank |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811106518.8A CN109325045B (en) | 2018-09-21 | 2018-09-21 | Method and device for opening bank |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109325045A true CN109325045A (en) | 2019-02-12 |
| CN109325045B CN109325045B (en) | 2021-09-28 |
Family
ID=65265692
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811106518.8A Active CN109325045B (en) | 2018-09-21 | 2018-09-21 | Method and device for opening bank |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109325045B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035355A (en) * | 2020-08-28 | 2020-12-04 | 中国平安财产保险股份有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN112667244A (en) * | 2020-12-30 | 2021-04-16 | 平安证券股份有限公司 | Data verification method and device, electronic equipment and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001071561A1 (en) * | 2000-03-22 | 2001-09-27 | Rosen Barbara | A data storing method and data storing structure |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | 中国移动（深圳）有限公司 | Checking method and device of Excel file |
| CN107229466A (en) * | 2017-05-04 | 2017-10-03 | 中国建设银行股份有限公司 | Method, system and the storage medium of business development are carried out for enterprise branch office |
-
2018
- 2018-09-21 CN CN201811106518.8A patent/CN109325045B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001071561A1 (en) * | 2000-03-22 | 2001-09-27 | Rosen Barbara | A data storing method and data storing structure |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | 中国移动（深圳）有限公司 | Checking method and device of Excel file |
| CN107229466A (en) * | 2017-05-04 | 2017-10-03 | 中国建设银行股份有限公司 | Method, system and the storage medium of business development are carried out for enterprise branch office |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035355A (en) * | 2020-08-28 | 2020-12-04 | 中国平安财产保险股份有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN112667244A (en) * | 2020-12-30 | 2021-04-16 | 平安证券股份有限公司 | Data verification method and device, electronic equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109325045B (en) | 2021-09-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9037549B2 (en) | System and method for testing data at a data warehouse | |
| CN104462981B (en) | leak detection method and device | |
| CN110348441A (en) | VAT invoice recognition methods, device, computer equipment and storage medium | |
| CN105373472B (en) | A kind of method of testing and test system of the statistical accuracy based on database | |
| US20180373711A1 (en) | Extracting searchable information from a digitized document | |
| US20130014084A1 (en) | International Testing Platform | |
| CN110287097A (en) | Batch testing method, device and computer readable storage medium | |
| Fioravanti et al. | A study on fault-proneness detection of object-oriented systems | |
| CN108446190A (en) | interface test method and device | |
| CN110378343A (en) | A kind of finance reimbursement data processing method, apparatus and system | |
| CN106599261A (en) | Processing method for detection result data | |
| CN105956410B (en) | A kind of Universal-purpose quick detection method of IEC61850 full models | |
| CN109710237A (en) | A kind of online modification method of calibration and equipment based on customized two-dimentional report | |
| CN109471857A (en) | Data modification method, device and storage medium based on SQL statement | |
| CN109359277A (en) | Data monitoring method, equipment and computer storage medium | |
| CN109885541A (en) | The method and apparatus of information batch processing | |
| CN110069279B (en) | Method, device and storage medium for checking direct current control protection program | |
| CN109388376A (en) | Risk of software development appraisal procedure, device, equipment and readable storage medium storing program for executing | |
| CN109408807A (en) | The automated testing method and test equipment of OCR recognition correct rate | |
| CN109325045A (en) | A kind of method and device of issuing bank | |
| CN106130811A (en) | Data communications test method and device | |
| CN105589837A (en) | Automatic electronic document checking method | |
| CN108920140A (en) | Method of calibration is unified in a kind of front and back end | |
| CN109558562A (en) | A kind of management method and system sentenced again for AOI | |
| CN109710528A (en) | A kind of test script generation method, device, equipment and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |