CN109325045B - Method and device for opening bank - Google Patents
Method and device for opening bank Download PDFInfo
- Publication number
- CN109325045B CN109325045B CN201811106518.8A CN201811106518A CN109325045B CN 109325045 B CN109325045 B CN 109325045B CN 201811106518 A CN201811106518 A CN 201811106518A CN 109325045 B CN109325045 B CN 109325045B
- Authority
- CN
- China
- Prior art keywords
- data
- target
- verified
- target data
- data table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
Abstract
The application discloses a method and a device for opening a new bank, wherein the method comprises the following steps: acquiring a plurality of data tables to be verified which are filled according to a preset data template; verifying the data in each data table to be verified according to a preset corresponding relation between the position of the data in each data table to be verified and a verification rule; feeding back the position of the target data which does not accord with the verification rule and the verification rule which is required to be met by the target data; generating SQL sentences for each row of data in the target data table according to a preset SQL script template corresponding to the target data table aiming at the target data table meeting the verification rule; executing the generated SQL statement. According to the embodiment of the application, the established branch or sub-bank is established in the existing bank system on the premise of ensuring the data accuracy for establishing the branch or sub-bank.
Description
Technical Field
The present application relates to the field of data processing, and in particular, to a method and an apparatus for opening a bank.
Background
In order to expand banking, a branch or sub-branch of a certain bank needs to be opened at different places.
When each branch or sub-line is established, the established branch or sub-line needs to be established in the existing bank system, so that the established branch or sub-line can normally operate. For example, an existing bank a needs to establish a branch or a sub-bank of the bank a in a certain area, and at this time, the established branch or sub-bank needs to be established in the existing bank a system, so that the established branch or sub-bank can normally operate in the existing bank a system.
In order to ensure that a branch or a sub-branch opened in an existing banking system can normally operate, it is necessary to ensure accuracy of data required for opening the branch or the sub-branch in the existing banking system, and therefore, the established branch or the sub-branch needs to be opened in the existing banking system on the premise of ensuring the accuracy of the data for opening the branch or the sub-branch.
Disclosure of Invention
Based on this, the application provides a method for opening a new bank, which is used for opening established branches or sub-lines in an existing bank system on the premise of ensuring the data accuracy for opening the branches or sub-lines.
The application also provides a device for opening a new bank, which is used for ensuring the realization and the application of the method in practice.
The technical scheme provided by the application is as follows:
the application discloses a method for opening a new bank, which comprises the following steps:
acquiring a plurality of data tables to be verified which are filled according to a preset data template;
verifying the data in each data table to be verified according to a preset corresponding relation between the position of the data in each data table to be verified and a verification rule;
feeding back the position of the target data which does not accord with the verification rule and the verification rule which is required to be met by the target data so that a user can modify the target data according to the verification rule which is required to be met, and the data in the data tables to be verified can meet the verification rule;
generating SQL sentences for each row of data in the target data table according to a preset SQL script template corresponding to the target data table aiming at the target data table meeting the verification rule, and obtaining the SQL sentences corresponding to each row of data in the plurality of data tables; the target data table is any one of the plurality of data tables;
executing the generated SQL statement.
The verifying the data in each data table to be verified according to the corresponding relationship between the position of the data in each data table to be verified and the verification rule includes:
sequentially acquiring data tables to be verified according to a preset sequence;
aiming at the obtained target data table to be verified, obtaining the corresponding relation between the data position corresponding to the target data table to be verified and the verification rule; the corresponding relationship between the data position and the check rule comprises: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic; the target data table to be verified is any one of the multiple data tables to be verified;
and verifying the data in the target data table to be verified according to the first corresponding relation and the second corresponding relation.
Wherein, the verifying the data in the target data table to be verified according to the first corresponding relationship and the second corresponding relationship includes:
aiming at first data in the target data table to be verified, acquiring a target data format corresponding to a column label to which the first data belongs from the first corresponding relation; the first data is any data in the target data table to be checked;
judging whether the data format of the first data meets the target data format or not;
detecting a target row meeting the first corresponding relation in the target data table to be verified;
acquiring a target service logic corresponding to the line label of the target line from the second corresponding relation;
and judging whether the data in the target row meets the target business logic.
Wherein, the feedback of the target data which does not conform to the check rule and the check rule which is required to be satisfied by the target data comprises:
if the data format of the first data does not meet the target data format, determining the position of the first data in the target data table to be verified;
feeding back the position of the first data in the target data table to be verified and the target data format;
if the data in the target row does not meet the target service logic, determining the position of the target row in the target data table to be verified;
and feeding back the position of the target row in the target data table to be checked and the target business logic.
Generating an SQL statement for each row of data in the target data table according to a preset SQL script template corresponding to the target data table for the target data table meeting the verification rule, including:
aiming at a target data table meeting a verification rule, acquiring a preset SQL script template corresponding to the target data table;
and generating SQL sentences from each row of data in the target data table according to the acquired preset SQL script template.
The application also discloses a device for opening a new bank, including:
the device comprises an acquisition unit, a verification unit and a verification unit, wherein the acquisition unit is used for acquiring a plurality of data forms to be verified which are filled according to a preset data template;
the verification unit is used for verifying the data in each data table to be verified according to the preset corresponding relation between the position of the data in each data table to be verified and the verification rule;
the feedback unit is used for feeding back the position of the target data which do not accord with the verification rule and the verification rule which is required to be met by the target data so that a user can modify the target data according to the verification rule which is required to be met, and the data in the data tables to be verified can meet the verification rule;
the generating unit is used for generating SQL sentences for each row of data in the target data table according to a preset SQL script template corresponding to the target data table aiming at the target data table meeting the verification rule, so as to obtain the SQL sentences corresponding to each row of data in the plurality of data tables; the target data table is any one of the plurality of data tables;
and the execution unit is used for executing the generated SQL statement.
Wherein, the check unit includes:
the first obtaining subunit is used for sequentially obtaining the data tables to be verified according to a preset sequence;
the second obtaining subunit is configured to, for the obtained target data table to be verified, obtain a correspondence between a data position corresponding to the target data table to be verified and a verification rule; the corresponding relationship between the data position and the check rule comprises: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic; the target data table to be verified is any one of the multiple data tables to be verified;
and the checking subunit is used for checking the data in the target data table to be checked according to the first corresponding relationship and the second corresponding relationship.
Wherein, the check subunit includes:
a first obtaining module, configured to, for first data in the target data table to be verified, obtain, from the first corresponding relationship, a target data format corresponding to a column label to which the first data belongs; the first data is any data in the target data table to be checked;
the first judging module is used for judging whether the data format of the first data meets the target data format or not;
the detection module is used for detecting a target row meeting the first corresponding relation in the target data table to be verified;
a second obtaining module, configured to obtain, from the second correspondence, a target service logic corresponding to a row label to which the target row belongs;
and the second judgment module is used for judging whether the data in the target row meets the target service logic.
Wherein the feedback unit includes:
the first determining subunit is configured to determine, when the first determining module determines that the data format of the first data does not satisfy the target data format, a position of the first data in the target data table to be verified;
the first feedback subunit is used for feeding back the position of the first data in the target data table to be verified and the target data format;
the second determining subunit is configured to determine, when the second determining module determines that the data in the target row does not satisfy the target service logic, a position of the target row in the target data table to be checked;
and the second feedback subunit is used for feeding back the position of the target row in the target data table to be checked and the target service logic.
Wherein the generating unit includes:
the third obtaining subunit is configured to, for a target data table that meets a check rule, obtain a preset SQL script template corresponding to the target data table;
and the generating subunit is used for generating SQL statements for each line of data in the target data table according to the acquired preset SQL script template.
The beneficial effect of this application does:
in the embodiment of the application, according to the preset corresponding relation between the position of the data in each data table to be verified and the verification rule, the verification of the data in each acquired data table to be verified can be realized, and meanwhile, the verification accuracy of the data passing the verification can be ensured by feeding back the target data which do not accord with the verification rule and the verification rule which is required to be met by the target data; and according to a preset SQL script template corresponding to the target data table, each row of data in the target data table can be generated into an SQL statement, and the generated SQL script is executed, so that established branches or subrows can be set in the existing bank system on the premise of ensuring the data accuracy for establishing the branches or subrows in the existing bank system.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of an embodiment of a method of issuing a new bank in the present application;
FIG. 2 is a flowchart of an embodiment of a method for verifying data in a data table to be detected according to the present application;
FIG. 3 is a flow chart of an embodiment of a method for generating an SQL script according to the present application;
fig. 4 is a schematic structural diagram of an embodiment of an apparatus for issuing a new bank in the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Fig. 1 shows a method for opening a new bank disclosed in the present application, which includes the following steps:
step 101: and acquiring a plurality of data tables to be verified which are filled according to a preset data template.
In this embodiment, when a new bank needs to be established, initialization data, for example, information such as a bank number and a bank name of the newly established bank, needs to be collected; information such as department names, department numbers and the like included in the newly established bank; information such as employee names, employee numbers and the like in the newly established bank; the area where the new bank is located, and the like.
After the initialization data is collected, the initialization data is filled in a preset data template, where the data template may be a table with a preset format, such as an excel table, a Word table, a PDF table, and the like.
In addition, the data template also specifies the fields in each data form and the check rules that the contents of the fields need to satisfy; for example, the data template includes a bank basic information table, a department table, an employee table, a parameter table, and the like, wherein fields included in the bank basic information table may be a bank name, a bank organization number, an establishment date, and the like; meanwhile, the data format of each field content and the business logic required to be satisfied by each filled row of data are also specified in the bank basic information table.
For example, for the data format: the data format of the content of the field of the bank name is a character type, the data format of the content of the field of the bank organization number is a numerical type, the data format of the content of the field of the established date is a date type, and the like. And for each row of data in the bank basic information table, the service logic required to be satisfied is as follows: whether the contents for the filled-in bank name, bank organization number and establishment date exist in the database.
The collected initialization data is filled according to a data format specified by a data template, in the step, a plurality of data forms in which the initialization data is filled according to the data template are obtained, and for convenience of description, each obtained data form is collectively referred to as a data form to be verified because data in each obtained data form needs to be verified.
Step 102: and verifying the data in each data table to be verified according to the preset corresponding relation between the position of the data in each data table to be verified and the verification rule.
Since each data form in the data template specifies fields to be filled, a data format required to be satisfied by the content of each field, and business logic required to be satisfied by each row of data, at this time, for each data form, a data format required to be satisfied by the content of each cell in the data form, and business logic required to be satisfied by the cell in which any row of data is filled are formed. For convenience of description, in this embodiment, the data format and the business logic that need to be satisfied by the data in any cell in the data table are collectively referred to as the check rule of the cell. Therefore, for each data table to be checked, the corresponding relation between the cell position in the data table and the check rule is formed.
For example, in the bank basic information table, assuming that the field name of the first column is the bank name, the field name of the second column is the bank organization number, and the field name of the third column is the established date, at this time, the data format corresponding to the cell of the first column in the second row is character type, the data format of the data to be filled in the cell of the second column in the second row is numerical type, the data format of the data to be filled in the cell of the third column in the second row is date type, and the data of the second row needs to be already present in the database. Therefore, in the bank basic information table, the corresponding relation between the position of the cell in the data table and the verification rule is formed.
In this step, the data in each data table to be verified is verified according to the preset corresponding relationship between the position of the data in each data table to be verified and the verification rule. Specifically, the process of verifying the data in each data table to be verified may refer to the embodiment of the method for verifying the data in the data table corresponding to fig. 2, and is not described herein again.
Step 103: and feeding back the position of the target data which does not accord with the verification rule and the verification rule which is required to be met by the target data so that a user can modify the target data according to the verification rule which is required to be met, and the data in the data tables to be verified can meet the verification rule.
In this embodiment, for any data table to be verified, after verifying the data in any data table to be verified according to the preset corresponding relationship between the position of the data in any data table to be verified and the verification rule, there may be data in some cells that do not satisfy the required data format. And counting the position of the target data in any data table to be checked and the check rule (data format and business logic) required to be met by the target data, and feeding back the counted position of the target data and the check rule required to be met by the target data to the user, so that the user modifies the target data according to the check rule required to be met by the target data.
In this embodiment, the target data modified by the user is continuously verified, and if the target data does not meet the verification rule required by the target data, the positions of the target data which do not meet the required verification rule and the verification rule which is required to be met are continuously counted until the acquired data in the plurality of data tables to be verified meet the required verification rule, so as to obtain a plurality of data tables which meet the verification rule, wherein one data table to be verified corresponds to one data table which meets the verification rule. In practical application, after the data in all the data tables are verified, the counted target data and the verification rule that the target data needs to meet are sent to the user, so that the user can modify the target data uniformly.
Step 104: and aiming at the target data tables meeting the verification rules, generating SQL sentences for each row of data in the target data tables according to the preset SQL script template corresponding to the target data tables, and obtaining the SQL sentences corresponding to each row of data in the plurality of data tables.
In this embodiment, the target data table is any one of a plurality of target data tables that satisfy the verification rule. For the target data table, an SQL script template is preset so as to convert any line of data in the target data table into an SQL statement according to the corresponding SQL script template, and a plurality of SQL statements are obtained for the target data table.
Specifically, the process of generating the SQL statement according to the preset SQL script template may refer to the embodiment of the method for generating the SQL script corresponding to fig. 3, which is not described herein again.
Step 105: executing the generated SQL statement.
After a plurality of SQL statements are generated for each data table, the generated SQL statements are automatically executed.
Fig. 2 is a flowchart illustrating a method for verifying data in a to-be-verified data table, which includes the following steps:
step 201: and sequentially acquiring the data tables to be verified according to a preset sequence.
In the present embodiment, an order of verifying data in the multiple data tables to be verified is defined, and in this step, the data in each data table to be verified is sequentially verified according to the preset order. For example, the plurality of data tables to be verified are respectively a bank basic information table, a department table, an employee table and a parameter table, and the preset sequence is respectively as follows: a bank basic information table, an employee table, a department table and a parameter table; at this time, in this step, first, the bank basic information table is obtained as a data table to be verified, after the data in the bank basic information table is verified, the employee table is obtained, the data in the employee table is verified, then the department table is obtained, and the data in the department table is verified; and sequentially verifying the data in each data table to be verified according to a preset sequence.
Step 202: and acquiring the corresponding relation between the data position corresponding to the target data table to be verified and the verification rule aiming at the acquired target data table to be verified.
In this embodiment, the corresponding relationship between the data in the data table to be verified and the verification rule is set according to the acquisition sequence of the data table to be verified. For example, the data tables to be verified are respectively a bank basic information table, an employee table, a department table, and a parameter table, and in this embodiment, the corresponding relationship between the data corresponding to each data table to be verified and the verification rule is set in advance.
In this step, the target data table to be verified is any one of the multiple data tables to be verified, and for the obtained target data table to be verified, the corresponding relationship between the data position corresponding to the obtaining sequence of the target data table to be verified and the verification rule is obtained. Taking the target data table to be verified as the bank basic information table as an example, in this step, the corresponding relationship between the data in the bank basic information table and the verification rule is obtained.
In this step, for the target data table to be verified, the corresponding relationship between the data in the target data table to be verified and the verification rule may include: the first corresponding relation between the column label of the data and the data format, and the second corresponding relation between the row label of the data and the service logic.
Taking the bank basic information table as an example, the correspondence between the data in the bank basic information table obtained in this step and the verification rule specifically includes: the corresponding relationship between the column labels and the data formats in the basic information table of the bank, for example, the data format of the first column is character type, the data format of the second column is numerical type, the data format of the third column is date type, etc.; in addition, a second corresponding relation between the row labels and the business logic in the bank basic information table can be included, for example, each row of data in the bank basic information table must exist in the database.
Step 203: and verifying the data in the target data table to be verified according to the first corresponding relation and the second corresponding relation.
After a first corresponding relationship between the column label and the data format and a second corresponding relationship between the row label and the service logic in the target data table to be verified are obtained, in this step, data in the target data table to be verified are verified according to the first corresponding relationship and the second corresponding relationship. The specific verification process may include steps a1 to a 5:
step A1: and aiming at the first data in the target data table to be verified, acquiring a target data format corresponding to the column label to which the first data belongs from the first corresponding relation.
In this step, the first data is any data in the target data table to be verified. Specifically, the data format corresponding to the column label to which the first data belongs is obtained from the first relationship between the data position and the data format, and for convenience of description, the data formats corresponding to the column label of the first data are collectively referred to as a target data format in this step.
Step A2: and judging whether the data format of the first data meets the target data format.
For example, the first data is data of a second row and a second column in the bank basic information table, and the target data format of the second column in the bank basic information table is a numerical type. In this step, it is determined whether the data format of the second row and the second column in the bank basic information table is numerical.
If the data format of the first data does not meet the target data format, executing step a2, otherwise, acquiring the next data, and continuing to execute the action of the step.
Step A2: and determining the position of the first data in the target data table to be checked and the target data format.
And when the data format of the first data does not meet the target data format, determining the position of the first data in the target data table to be verified and the target data format.
Step A3: and detecting a target row meeting the first corresponding relation in the target data table to be verified.
After each data in the target data table to be verified is verified in a data format, for convenience of description, in this step, if data in a certain row meets the required data format, the row of data is collectively referred to as a target row, and in this step, the target row in the target data table to be verified is detected. For example, each data of the second row in the bank basic information table satisfies the required data format, and at this time, the second row data in the bank basic information table is the target row.
Step A4: and acquiring the target business logic corresponding to the line label of the target line from the second corresponding relation.
And acquiring the service logic required to be met by the second row of data from a second corresponding relation between the data row label corresponding to the bank basic information table and the service logic, wherein for convenience of description, the service logic required to be met by the acquired target row is collectively referred to as target service logic.
Step A5: and judging whether the data in the target row meets the target business logic.
And judging whether the data in the second row in the bank basic information table meets the target business logic, wherein in practical application, the target business logic can be that the data of the target row already exists in the database. At this time, whether the second row of data in the bank basic information table exists in the database is judged. If the data in the target row does not meet the target business logic, executing step A6; if yes, judging whether the next target row in the bank basic information table meets the target business logic required to be met by the next target row.
Step A6: and determining the position of the target row in the target data table to be checked and the target business logic.
If the data in the target row does not meet the required target service logic, in this step, the position of the target row in the target data table to be verified and the required target service logic are determined. Taking the bank basic information table as an example, if some data in the second row of data in the bank basic information table are not stored in the database, at this time, the second row of data is not full of the required target service logic, and at this time, the position of the target row, that is, the second row, and the target service logic required to be met by the second row are determined.
According to the steps A1-A6, after the data in the target data table to be verified are verified, the data which do not meet the required verification rule in the target data table to be verified are fed back to the user, wherein the data fed back to the user comprise the position of the data which do not meet the verification rule in the data table to be verified, and the target data format and/or the target service logic which need to be met, so that the user can modify the data which do not meet the required verification rule in the multiple data tables to be verified according to the fed-back target data format and/or the target service logic. And feeding back the modified data to the embodiment, and continuing to check according to the actions of the steps a1 to a6 until the data in each data table to be checked meet the required check rule, at this time, obtaining a plurality of data tables meeting the check rule.
Fig. 3 shows that a method for generating an SQL script disclosed in the present application includes the following steps:
step 301: and aiming at the target data table meeting the verification rule, acquiring a preset SQL script template corresponding to the target data table.
In this embodiment, the data tables meeting the verification rule are classified according to the field information in the data tables, and an SQL template is preset for any type of data table. For example, the bank basic information table includes fields related to banks, the department information table includes fields related to departments, and the employee information table includes fields related to employees. The basic information table of the bank, the department information table and the employee information table belong to different categories. The basic information tables of the bank belong to one type, the department information tables belong to one type, and the employee information tables belong to one type, so that the corresponding SQL templates are set for the basic information tables of the bank, the corresponding SQL templates are set for the department information tables, and the corresponding SQL templates are set for the employee information tables.
In this step, for a target data table satisfying the verification rule, a data table type to which the target data table belongs is determined, and a preset SQL template is determined according to the determined data table type.
Step 302: and generating SQL sentences from each row of data in the target data table according to the acquired preset SQL script template.
And aiming at the target data table meeting the verification rule, generating SQL sentences from each row of data in the target data table according to a preset SQL script template corresponding to the target data table.
At this time, in this embodiment, an SQL statement is generated for each row of data in each data table, and the generated SQL statement is executed to implement the establishment of a new bank in the existing banking system. In the embodiment, the generated SQL statement has the characteristic of being capable of being instantly called and executed by a command, so that the embodiment can execute the generated SQL script and automatically install the generated SQL script in the system without forming a release version according to the generated SQL script, thereby automatically opening a new bank.
Fig. 4 is a device for opening a new bank disclosed in the present application, including:
an obtaining unit 401, configured to obtain multiple data tables to be verified that have been filled according to a preset data template;
a verification unit 402, configured to verify data in each data table to be verified according to a preset corresponding relationship between a position of the data in each data table to be verified and a verification rule;
a feedback unit 403, configured to feed back a position of target data that does not meet the verification rule and a verification rule that needs to be satisfied by the target data, so that a user modifies the target data according to the verification rule that needs to be satisfied, so that data in the multiple data tables to be verified meet the verification rule;
a generating unit 404, configured to generate, for a target data table that meets the check rule, an SQL statement for each line of data in the target data table according to a preset SQL script template corresponding to the target data table, so as to obtain an SQL statement corresponding to each line of data in the multiple data tables; the target data table is any one of the plurality of data tables;
and an execution unit 405, configured to execute the generated SQL statement.
The verification unit 402 may include:
the first obtaining subunit is used for sequentially obtaining the data tables to be verified according to a preset sequence;
the second obtaining subunit is configured to, for the obtained target data table to be verified, obtain a correspondence between a data position corresponding to the target data table to be verified and a verification rule; the corresponding relationship between the data position and the check rule comprises: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic; the target data table to be verified is any one of the multiple data tables to be verified;
and the checking subunit is used for checking the data in the target data table to be checked according to the first corresponding relationship and the second corresponding relationship.
The checking subunit may include:
a first obtaining module, configured to, for first data in the target data table to be verified, obtain, from the first corresponding relationship, a target data format corresponding to a column label to which the first data belongs; the first data is any data in the target data table to be checked;
the first judging module is used for judging whether the data format of the first data meets the target data format or not;
the detection module is used for detecting a target row meeting the first corresponding relation in the target data table to be verified;
a second obtaining module, configured to obtain, from the second correspondence, a target service logic corresponding to a row label to which the target row belongs;
and the second judgment module is used for judging whether the data in the target row meets the target service logic.
The feedback unit 403 may include:
the first determining subunit is configured to determine, when the first determining module determines that the data format of the first data does not satisfy the target data format, a position of the first data in the target data table to be verified;
the first feedback subunit is used for feeding back the position of the first data in the target data table to be verified and the target data format;
the second determining subunit is configured to determine, when the second determining module determines that the data in the target row does not satisfy the target service logic, a position of the target row in the target data table to be checked;
and the second feedback subunit is used for feeding back the position of the target row in the target data table to be checked and the target service logic.
The generating unit 404 may include:
the third obtaining subunit is configured to, for a target data table that meets a check rule, obtain a preset SQL script template corresponding to the target data table;
and the generating subunit is used for generating SQL statements for each line of data in the target data table according to the acquired preset SQL script template.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. In this document, relational terms such as "first" and "second," and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. The terms "comprising," "including," and the like, as used herein, are to be construed in an inclusive sense as opposed to an exclusive or exhaustive sense; that is, the meaning of "includes but is not limited to". The invention can be applied to various fields, such as a mobile phone, a mobile phone.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
1. A method of opening a new bank, comprising:
acquiring a plurality of data tables to be verified which are filled according to a preset data template;
according to a preset corresponding relation between the position of data in each data table to be verified and a verification rule, verifying the data in each data table to be verified, wherein the verification rule comprises a data format and a service logic, and the preset corresponding relation between the position of the data and the verification rule comprises the following steps: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic;
feeding back the position of the target data which does not accord with the verification rule and the verification rule which is required to be met by the target data so that a user can modify the target data according to the verification rule which is required to be met, and the data in the data tables to be verified can meet the verification rule;
generating SQL sentences for each row of data in the target data table according to a preset SQL script template corresponding to the target data table aiming at the target data table meeting the verification rule, and obtaining the SQL sentences corresponding to each row of data in the plurality of data tables; the target data table is any one of the plurality of data tables;
executing the generated SQL statement;
wherein, the feedback of the position of the target data which does not conform to the check rule and the check rule which is required to be satisfied by the target data comprises:
acquiring a data format corresponding to a column label to which first data in a target data table to be verified belongs from the first corresponding relation, and determining the position of the first data in the target data table to be verified if the data format of the first data does not meet the target data format;
feeding back the position of the first data in the target data table to be verified and the target data format;
acquiring a target service logic corresponding to a row label to which a target row belongs from the second corresponding relation, and if the data in the target row does not meet the target service logic, determining the position of the target row in the target data table to be verified, wherein the target row represents that each data in the row in the target data table to be verified meets the target data format;
and feeding back the position of the target row in the target data table to be checked and the target business logic.
2. The method according to claim 1, wherein the verifying the data in each table of data to be verified according to the corresponding relationship between the position of the data in each table of data to be verified and the verification rule comprises:
sequentially acquiring data tables to be verified according to a preset sequence;
aiming at the obtained target data table to be verified, obtaining the corresponding relation between the data position corresponding to the target data table to be verified and the verification rule; the target data table to be verified is any one of the multiple data tables to be verified;
and verifying the data in the target data table to be verified according to the first corresponding relation and the second corresponding relation.
3. The method according to claim 2, wherein the verifying the data in the target data table to be verified according to the first corresponding relationship and the second corresponding relationship comprises:
aiming at first data in the target data table to be verified, acquiring a target data format corresponding to a column label to which the first data belongs from the first corresponding relation; the first data is any data in the target data table to be checked;
judging whether the data format of the first data meets the target data format or not;
detecting a target row meeting the first corresponding relation in the target data table to be verified;
acquiring a target service logic corresponding to the line label of the target line from the second corresponding relation;
and judging whether the data in the target row meets the target business logic.
4. The method according to claim 1, wherein the generating SQL statements for each row of data in the target data table according to the preset SQL script template corresponding to the target data table for the target data table meeting the check rule comprises:
aiming at a target data table meeting a verification rule, acquiring a preset SQL script template corresponding to the target data table;
and generating SQL sentences from each row of data in the target data table according to the acquired preset SQL script template.
5. An apparatus for opening a new bank, comprising:
the device comprises an acquisition unit, a verification unit and a verification unit, wherein the acquisition unit is used for acquiring a plurality of data forms to be verified which are filled according to a preset data template;
the verification unit is used for verifying the data in each data table to be verified according to a preset corresponding relationship between the position of the data in each data table to be verified and a verification rule, the verification rule comprises a data format and a service logic, and the preset corresponding relationship between the position of the data and the verification rule comprises: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic;
the feedback unit is used for feeding back the position of the target data which do not accord with the verification rule and the verification rule which is required to be met by the target data so that a user can modify the target data according to the verification rule which is required to be met, and the data in the data tables to be verified can meet the verification rule;
the generating unit is used for generating SQL sentences for each row of data in the target data table according to a preset SQL script template corresponding to the target data table aiming at the target data table meeting the verification rule, so as to obtain the SQL sentences corresponding to each row of data in the plurality of data tables; the target data table is any one of the plurality of data tables;
an execution unit for executing the generated SQL statement;
the feedback unit includes:
the first determining subunit is configured to obtain, from the first corresponding relationship, a data format corresponding to a column label to which first data in a target data table to be verified belongs, and determine, when the data format of the first data does not satisfy the target data format, a position of the first data in the target data table to be verified;
the first feedback subunit is used for feeding back the position of the first data in the target data table to be verified and the target data format;
a second determining subunit, configured to obtain, from the second correspondence, a target service logic corresponding to a row label to which a target row belongs, and determine, when data in the target row does not satisfy the target service logic, a position of the target row in the target data table to be verified, where the target row represents that each data in the row in the target data table to be verified satisfies the target data format;
and the second feedback subunit is used for feeding back the position of the target row in the target data table to be checked and the target service logic.
6. The apparatus of claim 5, wherein the verification unit comprises:
the first obtaining subunit is used for sequentially obtaining the data tables to be verified according to a preset sequence;
the second obtaining subunit is configured to, for the obtained target data table to be verified, obtain a correspondence between a data position corresponding to the target data table to be verified and a verification rule; the corresponding relationship between the data position and the check rule comprises: a first corresponding relation between a column label to which the data belongs and a data format, and a second corresponding relation between a row label to which the data belongs and business logic; the target data table to be verified is any one of the multiple data tables to be verified;
and the checking subunit is used for checking the data in the target data table to be checked according to the first corresponding relationship and the second corresponding relationship.
7. The apparatus of claim 6, wherein the syndrome unit comprises:
a first obtaining module, configured to, for first data in the target data table to be verified, obtain, from the first corresponding relationship, a target data format corresponding to a column label to which the first data belongs; the first data is any data in the target data table to be checked;
the first judging module is used for judging whether the data format of the first data meets the target data format or not;
the detection module is used for detecting a target row meeting the first corresponding relation in the target data table to be verified;
a second obtaining module, configured to obtain, from the second correspondence, a target service logic corresponding to a row label to which the target row belongs;
and the second judgment module is used for judging whether the data in the target row meets the target service logic.
8. The apparatus of claim 5, wherein the generating unit comprises:
the third obtaining subunit is configured to, for a target data table that meets a check rule, obtain a preset SQL script template corresponding to the target data table;
and the generating subunit is used for generating SQL statements for each line of data in the target data table according to the acquired preset SQL script template.
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 CN109325045A (en) | 2019-02-12 |
| CN109325045B true 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) |
Families Citing this family (1)
| 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 |
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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109325045A (en) | 2019-02-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109887153B (en) | Finance and tax processing method and system | |
| CN108985912B (en) | Data reconciliation | |
| US9589183B2 (en) | System and method for identification and extraction of data | |
| CN104991955A (en) | Method and system for automatically constructing template library | |
| CN111159982B (en) | Document editing method, device, electronic equipment and computer readable storage medium | |
| CN110765101B (en) | Label generation method and device, computer readable storage medium and server | |
| CN109783781B (en) | Image recognition-based policy entry method and related device | |
| CN109325045B (en) | Method and device for opening bank | |
| CN115544991A (en) | Report generation method, device, equipment, medium and program product | |
| CN115062117A (en) | Method for automatically generating and classifying documents based on natural language processing technology | |
| CN113938481A (en) | Receipt processing method, processing device, electronic equipment and readable storage medium | |
| CN112487138A (en) | Information extraction method and device for formatted text | |
| CN111400187A (en) | Parameter dynamic verification system and method based on customized data source | |
| US20150227787A1 (en) | Photograph billpay tagging | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| CN111046627A (en) | Chinese character display method and system | |
| CN113901075A (en) | Method and device for generating SQL (structured query language) statement, computer equipment and storage medium | |
| US11482027B2 (en) | Automated extraction of performance segments and metadata values associated with the performance segments from contract documents | |
| CN110427603B (en) | Certificate template testing method and device | |
| CN113537964A (en) | Application form processing method, device, storage medium and device | |
| CN112487152A (en) | Automatic document detection method and device | |
| KR101809362B1 (en) | Transaction Information Managing System using Optical Character Reader System and Computerized Transaction Information Managing Method using It | |
| CN105786988B (en) | Verification of data method and device | |
| US20230281380A1 (en) | Method of processing text, electronic device and storage medium | |
| CN108256120B (en) | Data acquisition and file downloading control method and device |
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 |