CN112801646A - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN112801646A CN112801646A CN202110061495.9A CN202110061495A CN112801646A CN 112801646 A CN112801646 A CN 112801646A CN 202110061495 A CN202110061495 A CN 202110061495A CN 112801646 A CN112801646 A CN 112801646A
- Authority
- CN
- China
- Prior art keywords
- bank
- data
- target
- page
- account
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 27
- 238000000034 method Methods 0.000 claims abstract description 44
- 238000012545 processing Methods 0.000 claims description 25
- 238000004590 computer program Methods 0.000 claims description 18
- 230000002085 persistent effect Effects 0.000 claims description 10
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 230000008569 process Effects 0.000 abstract description 23
- 238000010586 diagram Methods 0.000 description 9
- 238000012795 verification Methods 0.000 description 5
- 230000005856 abnormality Effects 0.000 description 3
- 238000000605 extraction Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000004801 process automation Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/108—Remote banking, e.g. home banking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/22—Payment schemes or models
- G06Q20/227—Payment schemes or models characterised in that multiple accounts are available, e.g. to the payer
-
- 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)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Technology Law (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Transfer Between Computers (AREA)
Abstract
According to the data processing method and device, bank account login information of each bank is sequentially acquired from locally stored bank account login information of a user in a plurality of different banks; acquiring a bank page of a bank account under a bank according to the bank account login information of each bank; sending a query request to a server of a bank based on a bank page; receiving a target bank page sent by a server of a bank; and acquiring target bank data in the target bank page, and storing the target bank data in the database. In the scheme, the user can automatically log in different bank accounts to inquire the bank data of the user in a plurality of different banks, the user does not need to manually log in a bank official network to inquire, the inquiry process is standardized, the inquiry efficiency of the account bank fund status of different banks can be improved while the accuracy of the inquired data is guaranteed, and the human resources are saved.
Description
Technical Field
The embodiment of the application relates to the technical field of computers, in particular to a data processing method and device.
Background
With the development of economic globalization, more and more users open multiple accounts at the same time in different foreign banks or domestic banks, and in order to ensure the normal progress of transactions such as transfer, payment and remittance, the users often need to monitor the fund status of one or more accounts, such as account balance, account details and the like.
In the prior art, when bank fund monitoring is carried out, a user needs to manually log in a bank official network for checking, when bank accounts are too many, the inquired accounts need to be continuously switched, the standardization degree of the process is low, accuracy is lack of guarantee, and efficiency is low.
Disclosure of Invention
The embodiment of the application provides a data processing method and device, and aims to solve the technical problems that in the prior art, the fund status of a bank account is monitored manually, the standardization degree is low, the accuracy is lack of guarantee, and the efficiency is low.
In a first aspect, the present application provides a data processing method, including:
sequentially acquiring bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks, wherein the bank account login information comprises a login account number and a login password;
acquiring a bank page of a bank account under a bank according to the bank account login information of each bank;
sending an inquiry request to a server of a bank based on a bank page, wherein the inquiry request is used for requesting to inquire target bank data in the bank page;
receiving a target bank page sent by a server of a bank, wherein the target bank page comprises target bank data;
and acquiring target bank data in the target bank page, and storing the target bank data into a database, wherein the database is used for storing the bank data of a plurality of different banks of the user.
Optionally, the obtaining of the target bank data in the target bank page includes:
based on the target bank page, sending a downloading request to a server of the bank, wherein the downloading request is used for requesting to download target bank data;
and receiving target bank data sent by a server of the bank.
Optionally, the receiving target bank data sent by the server of the bank includes:
receiving a target excel form sent by a server of a bank, wherein the target excel form comprises target bank data;
storing the target bank data into a database, comprising:
converting the target bank data in the target excel form into target bank data of persistent data;
and storing the target bank data converted into the persistent data into the database.
Optionally, sending the query request to the server of the bank based on the bank page includes:
sending a query request to a server of a bank based on a bank page according to a first preset time interval;
sending a query request to a server of the bank based on the bank page according to a second preset time interval;
wherein the first preset time interval is smaller than the second preset time interval;
acquiring target bank data in a target bank page, comprising:
acquiring first target bank data in a target bank page inquired at intervals based on first preset time;
and acquiring second target bank data in the target bank page inquired at intervals based on second preset time.
Optionally, after the target bank data is stored in the database, the method further includes:
judging whether second target bank data in a preset time period in the database is matched with at least one first target bank data in the preset time period;
if not, outputting prompt information, wherein the prompt information is used for prompting that the bank account is abnormal.
Optionally, obtaining a bank page of a bank account under a bank according to the bank account login information of each bank includes:
determining a bank to which the bank login account belongs according to the bank login account in each bank account login information;
acquiring a login request page of a bank to which a bank login account belongs, and acquiring a bank page of a bank account under the bank based on the login request page and the login information of the bank account;
alternatively, the first and second electrodes may be,
determining a login request page corresponding to each bank account login information according to a preset corresponding relation between each bank account login information and a login request page of a bank;
and acquiring the bank page of the bank account under the bank based on the login request page and the login information of the bank account.
In a second aspect, the present application provides a data processing apparatus comprising:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for sequentially acquiring bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks, and the bank account login information comprises a login account number and a login password;
the second acquisition module is used for acquiring the bank pages of the bank accounts under the banks according to the bank account login information of each bank;
the system comprises a sending module, a receiving module and a processing module, wherein the sending module is used for sending an inquiry request to a server of a bank based on a bank page, and the inquiry request is used for requesting to inquire target bank data in the bank page;
the receiving module is used for receiving a target bank page sent by a server of a bank, and the target bank page comprises target bank data;
and the processing module is used for acquiring target bank data in the target bank page and storing the target bank data into a database, and the database is used for storing the bank data of a plurality of different banks of the user.
Optionally, the processing module is specifically configured to send a download request to a server of the bank based on the target bank page, where the download request is used to request to download the target bank data;
and receiving target bank data sent by a server of the bank.
Optionally, the processing module is specifically configured to receive a target excel form sent by a server of a bank, where the target excel form includes target bank data;
storing the target bank data into a database, comprising:
converting the target bank data in the target excel form into target bank data of persistent data;
and storing the target bank data of the persistent data into the database.
Optionally, the sending module is specifically configured to send, according to the first preset time interval, a query request to a server of the bank based on the bank page;
sending a query request to a server of the bank based on the bank page according to a second preset time interval;
wherein the first preset time interval is smaller than the second preset time interval;
acquiring target bank data in a target bank page, comprising:
acquiring first target bank data in a target bank page inquired at intervals based on first preset time;
and acquiring second target bank data in the target bank page inquired at intervals based on second preset time.
Optionally, the processing module is further configured to determine whether second target bank data in a preset time period in the database is matched with at least one first target bank data in a preset time period;
if not, outputting prompt information, wherein the prompt information is used for prompting that the bank account is abnormal.
Optionally, the second obtaining module is specifically configured to determine, according to the bank login account in each of the bank account login information, a bank to which the bank login account belongs;
acquiring a login request page of a bank to which a bank login account belongs, and acquiring a bank page of a bank account under the bank based on the login request page and the login information of the bank account;
alternatively, the first and second electrodes may be,
determining a login request page corresponding to each bank account login information according to a preset corresponding relation between each bank account login information and a login request page of a bank;
and acquiring the bank page of the bank account under the bank based on the login request page and the login information of the bank account.
In a third aspect, the present application provides an electronic device comprising:
a memory, a processor, and a computer program stored on the memory and executable on the processor; the computer program realizes the steps of the data processing method according to the first aspect when executed by a processor.
In a fourth aspect, the present application provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the data processing method according to the first aspect.
In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the data processing method of the first aspect.
According to the data processing method and device, bank account login information of each bank is sequentially acquired from locally stored bank account login information of a user in a plurality of different banks; acquiring a bank page of a bank account under a bank according to the bank account login information of each bank; sending a query request to a server of a bank based on a bank page; receiving a target bank page sent by a server of a bank; and acquiring target bank data in the target bank page, and storing the target bank data in the database. In the scheme, the user can automatically log in different bank accounts to inquire the bank data of the user in a plurality of different banks, the user does not need to manually log in a bank official network to inquire, the inquiry process is standardized, the inquiry efficiency of the account bank fund status of different banks can be improved while the accuracy of the inquired data is guaranteed, and the human resources are saved.
Drawings
Fig. 1 is a schematic view of an application scenario of a data processing method according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present application;
fig. 3 is a schematic diagram of a login request page of a bank according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a bank page provided in an embodiment of the present application;
fig. 5 is a schematic flowchart of a data processing method according to another embodiment of the present application;
fig. 6 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of 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.
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, 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 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.
The terms "first," "second," and the like in the description of the present application and in the above-described figures are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein.
It should be understood that, in the various embodiments of the present application, the size of the serial number of each process does not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
It should be understood that, in this application, "comprises" and "comprising," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Robot Process Automation (RPA) is a novel artificial intelligence virtual Process Automation robot, and with the development of economic globalization, the RPA is widely applied to various fields requiring Process Automation, especially in the field of finance and tax Automation.
In modern society, more and more users open multiple accounts at the same time in different foreign banks or domestic banks, and in order to ensure the normal progress of transactions such as transfer, payment and remittance, users often need to monitor the fund status of one or more accounts, such as account balance, account details, and the like.
In the prior art, when bank fund monitoring is carried out, a user needs to manually log in a bank official network for checking, when bank accounts are too many, the inquired accounts need to be continuously switched, the standardization degree of the process is low, accuracy is lack of guarantee, and efficiency is low.
In view of the above, the present application provides a data processing method, apparatus, device, and storage medium, which automatically log in to different bank accounts through an RPA, and query bank data of a user in a plurality of different banks, so that a bank official network does not need to be manually logged in for query, thereby standardizing a query process, improving query efficiency of account and bank fund status of different banks while ensuring accuracy of the queried data, and saving human resources.
The technical solution of the present application will be described in detail below with specific examples. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments.
Fig. 1 is an application scenario diagram of an application data processing method according to an embodiment of the present application. As shown in fig. 1, the applicable scenarios of the embodiment of the present application include: server 101, terminal device 102, funding system 103, and user.
It should be noted that at least one Robot Process Automation (RPA) software runs on the terminal device 102, and the terminal device 102 may be any device such as a desktop computer, a notebook computer, a Personal Digital Assistant (PDA), a smart phone, and a tablet computer; the server 101 is a server of any bank, which may be any electronic device or collection of electronic devices configured with a processor and memory. The connection between the terminal device 102 and the server 101, and between the terminal device 102 and the funding system 103 may be via a network.
The fund system 103 is provided with a database 104, and as for the type of the database, the embodiment of the present application is not particularly limited, and the database 104 may be a MySQL database.
Specifically, the terminal device 102 locally stores bank account login information of a plurality of users in different banks, and in the data processing process for each user, the terminal device 102 sequentially obtains the bank account login information of each bank from the locally stored bank account login information of the user in the plurality of different banks through the RPA, wherein the bank account login information includes a login account number and a login password, and sequentially logs in the server 101 of the bank where each bank account is located according to the bank account login information of each bank.
Further, the terminal device 102 sends an inquiry request to the server 101 of the bank through the RPA to inquire the bank data related to the bank data, where the bank data includes: account balance, account transaction details, bank receipt, and the like.
Further, the queried bank data is downloaded, and the terminal device 102 transmits the data to the database 104 of the fund system 103 through the RPA for storage, so that the user can query the relevant bank data from the database 104 by accessing the fund system 103.
In the scheme, different bank accounts are automatically logged in through the RPA, bank data of a user in a plurality of different banks are queried, so that the user does not need to manually log in a bank official website for querying, the querying process is standardized, the querying efficiency of the account and bank fund status of different banks can be improved while the accuracy of the queried data is guaranteed, human resources are saved, and the scheme is described in combination with a specific embodiment.
Fig. 2 is a schematic flow chart of a data processing method according to an embodiment of the present application. The embodiments of the present application relate to the main body of the method, which may be referred to as the terminal 102 above. As shown in fig. 2, the data processing method provided in the embodiment of the present application specifically includes the following steps:
s201, sequentially acquiring the bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks.
Note that, the terminal device stores bank account login information of a plurality of users in different banks. The embodiment of the present application is not specifically limited to the type of the user, and on one hand, the user may be an individual user, and on the other hand, the user may also be an enterprise user.
For each user, sequentially obtaining the bank account login information of the user in each bank, illustratively, for the user a, the bank corresponding to the user a includes: the bank A1 and the bank A2 … bank An sequentially log in the bank accounts of the bank A1 and the bank A2 … bank An, wherein the bank account log in information comprises: and the user logs in the account and the password of the bank.
In some embodiments, when acquiring the bank account login information, the corresponding bank account login information may be acquired according to the query requirement. For example, if the query only needs to query the relevant data of the user a in the bank a1, only the login information of the user in the bank a in the bank account needs to be acquired. By the scheme, the redundant data can be prevented from being acquired, and the data processing efficiency is further improved.
S202, acquiring a bank page of a bank account under a bank according to the bank account login information of each bank.
In one embodiment, the bank account login account number of each bank corresponds to different banks, and the bank corresponding to the account number can be determined according to the bank login account number.
Specifically, the bank to which the bank login account belongs is determined according to the bank login account in each bank account login information.
Further, a login request page of a bank to which the bank login account belongs is obtained, and a bank page of a bank account under the bank is obtained based on the login request page and the bank account login information.
For convenience of understanding, please refer to fig. 3, fig. 3 is a schematic diagram illustrating a login request page of a bank according to an embodiment of the present disclosure. As shown in fig. 3, for the bank a1 corresponding to the account B1 of the user a, the login request page of the bank at least includes: an account number entry area 301, a password entry area 302, and a "login" button 303. And automatically inputting the bank login account number and the login password of the account B1 of the user in the corresponding area of the login request page by the terminal equipment, thereby acquiring the bank page of the bank account B1 under the bank.
In another embodiment, the login request page corresponding to each bank account login information can be determined according to the preset corresponding relationship between each bank account login information and the login request page of the bank.
Specifically, the terminal device locally stores a login request page corresponding to login information of each bank account, and after the login information of the bank account is determined, the login request page corresponding to the login information of the bank account is locally acquired. In a feasible scheme, the network link of the bank login request page corresponding to the login information of each bank account is stored locally, and the bank login request page can be obtained according to the network link.
Further, the bank page of the bank account under the bank is obtained based on the login request page and the login information of the bank account.
As an optional scheme, in the embodiment of the present application, the bank page of the bank account under the bank may also be obtained in other manners. In an exemplary aspect, the user can log in by means of identification of the verification code, so as to obtain a bank page of a bank account under a bank.
Specifically, bank account login information of each bank is acquired from locally stored bank account login information of a user in a plurality of different banks, the account information comprises a login account number, a verification information acquisition request is sent to a server according to the login account number, and further, verification information sent by the server according to the verification information acquisition request is received.
Furthermore, the bank page of the bank account under the bank is accessed according to the login account number and the verification information. It is understood that the login account may include: cell phone numbers, mailbox numbers, etc.
On the other hand, the authentication of the user identity can be realized by adopting a private Key and a digital certificate of the user stored in a hardware storage device (USB Key, U-Key) of a USB interface of the bank, so that the bank page of the bank account of the user in the bank is obtained. The bank page is acquired through the hardware storage device of the USB interface, so that the safety of data can be guaranteed.
And S203, sending a query request to a server of the bank based on the bank page.
It should be noted that the query request is used to request to query target bank data in a bank page, where the bank data may be any one or more of account balance, account fund details, bank receipt, and the like.
For convenience of understanding, please refer to fig. 4, where fig. 4 is a schematic diagram of a bank page provided in an embodiment of the present application. As shown in fig. 4, in connection with the above-described embodiment, the bank page is the bank page of bank account B1. The bank page at least comprises: inquiry condition setting area 41 and inquiry button 42. The query condition setting area 41 may include: query date input area 411, query data type input area 412.
Specifically, a preset query condition is input in the query condition setting area to query the content in the preset query condition. It should be noted that the preset query condition may include: the query date, the query data type, and the like, and the preset query condition may be set according to actual requirements, which is not specifically limited in the embodiment of the present application. For example, if the user a needs to query account fund details from date 1 to date 2 in the bank account B1 under the bank a1, the preset query condition is set as follows: the query date is date 1 to date 2, and the query data type is: account fund detail.
Further, the terminal device automatically inputs the preset query condition in the query condition setting area, so as to send a query request to a server of the bank, and it can be understood that the query request includes: user A is queried for bank account B1 at bank A1 for account fund details on date 1 to date 2.
According to the scheme, the preset query conditions can be set according to the actual query requirements, and the related data can be automatically queried according to the preset query conditions, so that the query efficiency is improved while the accuracy of the queried data is guaranteed.
And S204, receiving the target bank page sent by the server of the bank.
In practical application, after a server of a bank receives an inquiry request, a target bank page corresponding to the inquiry request is sent according to the inquiry request, wherein the target bank page comprises target bank data.
Correspondingly, the terminal equipment receives the target bank page sent by the server of the bank.
S205, acquiring target bank data in the target bank page, and storing the target bank data in the database.
In practical application, the embodiment of the present application is not specifically limited to the method for acquiring the target bank data from the target bank page. Illustratively, a page grabbing technology may be adopted to extract unstructured information in a target bank page, so as to obtain target bank data.
Specifically, the code characteristics of the target bank data to be acquired in the target bank page can be determined, the corresponding extraction rule is formulated according to the code characteristics, and the target bank data is extracted from the target bank page according to the extraction rule. In the scheme, the target bank data are extracted from the target bank page through the extraction rule, so that the efficiency of acquiring the target bank data can be improved, and the accuracy of the acquired target bank data is improved.
In an embodiment, after the target bank data in the target bank page is acquired, the target bank data is downloaded to the local terminal device, and then the downloaded target bank data is stored in the database, where it needs to be noted that the database is used for storing the bank data of a plurality of different banks of the user.
It should be noted that, for the data type of the target bank downloaded in the bank page, the embodiment of the present application is not limited. In an alternative scheme, the type of the target bank data can be selected from the target bank page, a corresponding data type can be selected for downloading according to actual requirements, and the data type can also be determined according to the data type supported by the bank server. Illustratively, the data type of the bank data may be in excel tabular form, pdf format, and the like.
Taking the data type of the target bank data as an excel form as an example, the method receives a target excel form sent by a server of a bank, and performs data persistence processing on the target bank data in the target excel form so as to convert the target bank data into persistent data.
Further, the target bank data converted into the persistent data is stored in the database, so that the user can obtain the target bank data from the database.
In an alternative, during the data interaction, the data to be processed may be encrypted. For example, in this step, the server of the bank may encrypt the target bank data and send the encrypted target bank data to the terminal device, and the terminal device may also encrypt the data and store the encrypted data in the database.
The data processing method provided by the application sequentially acquires the bank account login information of each bank from the locally stored bank account login information of a user in a plurality of different banks; acquiring a bank page of a bank account under a bank according to the bank account login information of each bank; sending a query request to a server of a bank based on a bank page; receiving a target bank page sent by a server of a bank; and acquiring target bank data in the target bank page, and storing the target bank data in the database. In the scheme, the user can inquire the bank data of a plurality of different banks by automatically logging in different bank accounts without manually logging in a bank official network for inquiry, so that the inquiry efficiency of the account and bank fund status of different banks can be improved, and the human resources are saved.
In practical application, an inquiry rule that the terminal device inquires the bank data of each user can be preset, so that the terminal device can automatically inquire the related bank data of the user according to the inquiry rule. Wherein, the query rule may include: user information, bank account information, query duration intervals, query conditions and the like. The system comprises user information, bank account information and terminal equipment, wherein the user information represents a user needing to inquire bank data, the bank information represents a bank needing to be inquired by the user, the bank account information is used for representing a bank account needing to be inquired, and the inquiry duration interval represents a time interval of two adjacent inquiry operations of the terminal equipment on the bank account; the query conditions may include: query date, query data type, etc.
For example, the query rule may be set as: and inquiring balance data of a bank account B1 of the user A under a bank A1 in the same day at intervals of one day, and further, inquiring by the terminal equipment according to a set inquiry rule. The above-described scheme is explained below with reference to fig. 5.
Fig. 5 is a schematic flowchart of a data processing method according to another embodiment of the present application. As shown in fig. 5, an embodiment of the present application may include the following steps:
s501, sequentially acquiring the bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks.
S502, acquiring the bank pages of the bank accounts under the banks according to the bank account login information of each bank.
In practical application, for each user, firstly, a bank and a bank account which need to be queried are determined according to preset query rules, then, the bank account login information of the bank account is determined from locally stored bank account login information of the user in a plurality of different banks, and a bank page of the bank account under the bank is obtained according to the bank account login information of each bank.
Illustratively, at intervals of one day, inquiring the bank account B1 of the user A under the bank A1, and acquiring the bank page of the bank account B1 by locally acquiring the bank account login information of the bank B1 if the balance data of the day is B1.
It should be noted that the specific schemes of steps S501 to S502 are similar to steps S201 to S202 in the embodiment shown in fig. 2, and reference may be made to the above embodiments specifically, and details are not repeated here.
S503, according to the first preset time interval, sending a query request to a server of the bank based on the bank page.
It should be noted that, for a specific value of the first preset time period, the embodiment of the present application is not specifically limited, and for example, the interval of the first preset time period may be 24 hours, that is, the bank data of a certain bank account is queried every 24 hours.
For each query, a query condition is input at a bank page of the bank account to send a query request to a server of the bank. Still by way of example, on the bank page of bank account B1, the input date is the date of the day, and the query data type is: balance data. Thereby sending a query request to the server where the bank is located.
S504, according to the second preset time interval, a query request is sent to a server of the bank based on the bank page.
The first preset time interval is smaller than the second preset time interval.
It should be noted that, for a specific value of the second preset duration interval, the embodiment of the present application is also not specifically limited, and for example, the second preset duration interval may be: in one week, it should be noted that, the setting of the specific query time is also not specifically limited in the embodiment of the present application, and may be set to 18 pm every weekday, for example: 00.
in some embodiments, since the first preset duration is relatively short, in some scenarios, the data may be inaccurate, for example, when a refund occurs to a current bank account, the obtained account fund detail is not accurate enough due to the fact that the refund information is not updated timely enough. Therefore, the bank account can be inquired by setting different preset time intervals, so that accurate account details are provided.
S505, acquiring first target bank data in a target bank page inquired based on a first preset time interval, and storing the first target bank data in a database.
S506, second target bank data in the target bank page inquired based on the second preset time interval are obtained, and the second target bank data are stored in the database.
It should be noted that the schemes and principles of steps S505 and S506 are similar to those of step S205, and reference may be made to the embodiment shown in fig. 2, which is not repeated herein.
It is understood that, regarding the execution sequence of steps S503 and S504 and the execution sequence of steps S505 and S506, the embodiment of the present application is not particularly limited.
And S507, judging whether the second target bank data in the database within the preset time period is matched with at least one first target bank data within the preset time period.
It is understood that the duration of the preset time period is greater than or equal to the second preset time interval, and for a specific value thereof, the embodiment of the present application is not particularly limited, and the preset time period may be, for example, a period of one week, one month, and the like. Taking the duration of a preset time period as one week, the duration of a first preset interval as 24 hours, the duration of a second preset interval as one week, and the account fund detail with the data type of account B1 as an example for explanation, acquiring the first account fund detail of account B1 inquired at intervals of 24 hours in the week, acquiring the second account fund detail of account B1 inquired at intervals of one week, and comparing whether each detail in the first account fund detail and the second account fund detail is matched.
And S508, if the first target bank data and the second target bank data are matched, storing the first target bank data and the second target bank data into a database.
And S509, if the data are not matched, outputting prompt information.
Specifically, if the condition of mismatch exists, prompt information is output to prompt that the bank account is abnormal. It should be noted that, as to the type of the prompt information, the embodiment of the present application is not particularly limited, on one hand, the prompt information may be output by displaying the prompt message or sending a prompt sound on the terminal device, and on the other hand, the information such as a mail or a short message may be sent to a relevant worker, so as to prompt the relevant worker to handle the abnormality.
In practical applications, the above mentioned abnormality may be caused by operation errors occurring during operations such as inquiry and download of the terminal device, in addition to errors in bank account data. Therefore, as an alternative, in the above data processing process (S501 to S509) of the terminal device, the operation process of the terminal device may be recorded, so as to provide a basis for exception handling, thereby being capable of quickly finding an exception of the terminal device and improving the processing efficiency of the exception handling process.
It should be noted that, for the scheme of recording the operation process of the terminal device, the embodiment of the present application is not specifically limited, and on one hand, after sequentially obtaining the bank account login information of each bank from the locally stored bank account login information of the user in a plurality of different banks, the method further includes: and triggering the recording operation of the terminal equipment, wherein the recording operation is used for recording the data processing process of the terminal equipment. On the other hand, an operation log of the terminal device during data processing is recorded.
According to the data processing method provided by the embodiment of the application, after entering a bank login page, first target bank data in a target bank page inquired at intervals of a first preset time length are obtained; acquiring second target bank data in the target bank page inquired at intervals based on second preset time; judging whether second target bank data in a preset time period in the database is matched with at least one first target bank data in the preset time period; if not, outputting prompt information, wherein the prompt information is used for prompting that the bank account is abnormal. By comparing the target bank data with two preset time intervals in the preset time period, the bank data condition of the user can be monitored in real time, so that the worker is timely reminded to process when abnormality is found, and the accuracy of inquiring the bank data by the terminal equipment is improved.
Fig. 6 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application. As shown in fig. 6, the data processing apparatus provided in the embodiment of the present application may include:
the system comprises a first obtaining module 601, a first storage module, a second storage module and a third storage module, wherein the first obtaining module 601 is used for sequentially obtaining bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks, and the bank account login information comprises a login account number and a login password;
the second obtaining module 602 is configured to obtain a bank page of a bank account under each bank according to the bank account login information of each bank;
a sending module 603, configured to send an inquiry request to a server of a bank based on a bank page, where the inquiry request is used to request to inquire target bank data in the bank page;
a receiving module 604, configured to receive a target bank page sent by a server of a bank, where the target bank page includes target bank data;
the processing module 605 is configured to obtain target bank data in a target bank page, and store the target bank data in a database, where the database is used to store bank data of multiple different banks of a user.
The data processing apparatus provided in this embodiment may be configured to execute the technical solution provided in any of the foregoing method embodiments, and the implementation principle and the technical effect are similar, which are not described herein again.
Optionally, the processing module 605 is specifically configured to send a download request to a server of a bank based on a target bank page, where the download request is used to request to download target bank data;
and receiving target bank data sent by a server of the bank.
Optionally, the processing module 605 is specifically configured to receive a target excel form sent by a server of a bank, where the target excel form includes target bank data;
storing the target bank data into a database, comprising:
converting the target bank data in the target excel form into target bank data of persistent data;
and storing the target bank data converted into the persistent data into the database.
Optionally, the sending module 603 is specifically configured to send, according to the first preset time interval, a query request to a server of the bank based on the bank page;
sending a query request to a server of the bank based on the bank page according to a second preset time interval;
wherein the first preset time interval is smaller than the second preset time interval;
the processing module 605 is specifically configured to obtain first target bank data in a target bank page, which is queried based on a first preset time interval;
and acquiring second target bank data in the target bank page inquired at intervals based on second preset time.
Optionally, the processing module 605 is further configured to determine whether the second target bank data in the database within the preset time period is matched with at least one first target bank data in the preset time period;
if not, outputting prompt information, wherein the prompt information is used for prompting that the bank account is abnormal.
Optionally, the second obtaining module 602 is specifically configured to determine, according to the bank login account in each bank account login information, a bank to which the bank login account belongs;
acquiring a login request page of a bank to which a bank login account belongs, and acquiring a bank page of a bank account under the bank based on the login request page and the login information of the bank account;
alternatively, the first and second electrodes may be,
determining a login request page corresponding to each bank account login information according to a preset corresponding relation between each bank account login information and a login request page of a bank;
and acquiring the bank page of the bank account under the bank based on the login request page and the login information of the bank account.
Fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present application. As shown in fig. 7, the electronic device provided by the present application may include:
a memory 701, a processor 702, and a data processing program stored on the memory 701 and executable on the processor 702;
the data processing program when executed by the processor 702 implements the steps of the data processing method according to any of the embodiments described above.
Alternatively, the memory 701 may be separate or integrated with the processor 702.
For the implementation principle and the technical effect of the electronic device provided by this embodiment, reference may be made to the foregoing embodiments, which are not described herein again.
The embodiments of the present application further provide a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the data processing method according to any of the foregoing embodiments are implemented.
Embodiments of the present application further provide a computer program product, which includes a computer program, and when the computer program is executed by a processor, the computer program implements the steps of the data processing method provided in any of the foregoing embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of modules is only one logical division, and other divisions may be realized in practice, for example, a plurality of modules may be combined or integrated into another system, or some features may be omitted, or not executed.
The integrated module implemented in the form of a software functional module may be stored in a computer-readable storage medium. The software functional module is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) or a processor to execute some steps of the methods according to the embodiments of the present application.
It should be understood that the Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor, or in a combination of the hardware and software modules within the processor.
The memory may comprise a high-speed RAM memory, and may further comprise a non-volatile storage NVM, such as at least one disk memory, and may also be a usb disk, a removable hard disk, a read-only memory, a magnetic or optical disk, etc.
The storage medium may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be integral to the processor. The processor and the storage medium may reside in an Application Specific Integrated Circuits (ASIC). Of course, the processor and the storage medium may reside as discrete components in an electronic device or host device.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present application may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method of the embodiments of the present application.
The above description is only a preferred embodiment of the present application, and not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application, or which are directly or indirectly applied to other related technical fields, are included in the scope of the present application.
Claims (10)
1. A data processing method, comprising:
sequentially acquiring bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks, wherein the bank account login information comprises a login account number and a login password;
acquiring a bank page of a bank account under each bank according to the bank account login information of the bank;
sending an inquiry request to a server of the bank based on the bank page, wherein the inquiry request is used for requesting to inquire target bank data in the bank page;
receiving a target bank page sent by a server of the bank, wherein the target bank page comprises the target bank data;
and acquiring the target bank data in the target bank page, and storing the target bank data into a database, wherein the database is used for storing the bank data of a plurality of different banks of the user.
2. The method of claim 1, wherein obtaining the target bank data in the target bank page comprises:
sending a downloading request to a server of the bank based on the target bank page, wherein the downloading request is used for requesting to download the target bank data;
and receiving the target bank data sent by the server of the bank.
3. The method according to claim 2, wherein the receiving the target bank data sent by the bank's server comprises:
receiving a target excel form sent by a server of the bank, wherein the target excel form comprises the target bank data;
the storing the target bank data into a database includes:
converting the target bank data in the target excel form into target bank data of persistent data;
and storing the target bank data converted into the persistent data into the database.
4. The method of claim 1, wherein sending a query request to a server of the bank based on the bank page comprises:
sending a query request to a server of the bank based on the bank page according to a first preset time interval;
sending a query request to a server of the bank based on the bank page according to a second preset time interval;
wherein the first preset time interval is smaller than the second preset time interval;
the acquiring the target bank data in the target bank page includes:
acquiring first target bank data in a target bank page inquired at intervals based on the first preset duration;
and acquiring second target bank data in the target bank page inquired at intervals based on the second preset time length.
5. The method of claim 4, wherein after storing the target bank data in a database, further comprising:
judging whether second target bank data in a preset time period in the database is matched with at least one first target bank data in the preset time period;
and if not, outputting prompt information, wherein the prompt information is used for prompting that the bank account is abnormal.
6. The method according to any one of claims 1 to 5, wherein the obtaining the bank pages of the bank accounts under the bank according to the bank account login information of each bank comprises:
determining a bank to which the bank login account belongs according to the bank login account in each bank account login information;
acquiring a login request page of a bank to which the bank login account belongs, and acquiring a bank page of the bank account under the bank based on the login request page and the login information of the bank account;
alternatively, the first and second electrodes may be,
determining a login request page corresponding to each bank account login information according to a preset corresponding relation between each bank account login information and a login request page of a bank;
and acquiring the bank page of the bank account under the bank based on the login request page and the login information of the bank account.
7. A data processing apparatus, characterized in that the apparatus comprises:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for sequentially acquiring bank account login information of each bank from locally stored bank account login information of a user in a plurality of different banks, and the bank account login information comprises a login account number and a login password;
the second acquisition module is used for acquiring the bank pages of the bank accounts under the banks according to the bank account login information of each bank;
the query module is used for receiving a target bank page sent by a server of the bank, and the target bank page comprises the target bank data;
and the processing module is used for acquiring the target bank data in the target bank page and storing the target bank data into a database, and the database is used for storing the bank data of a plurality of different banks of the user.
8. An electronic device, characterized in that the electronic device comprises:
a memory, a processor, and a computer program stored on the memory and executable on the processor;
the computer program realizing the steps of the data processing method according to any of claims 1-6 when executed by the processor.
9. A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the data processing method according to any one of claims 1-6.
10. A computer program product comprising a computer program, characterized in that the computer program realizes the data processing method of any one of claims 1 to 6 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110061495.9A CN112801646A (en) | 2021-01-18 | 2021-01-18 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110061495.9A CN112801646A (en) | 2021-01-18 | 2021-01-18 | Data processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112801646A true CN112801646A (en) | 2021-05-14 |
Family
ID=75810025
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110061495.9A Pending CN112801646A (en) | 2021-01-18 | 2021-01-18 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112801646A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115063221A (en) * | 2022-05-26 | 2022-09-16 | 重庆银行股份有限公司 | Bank client data cross-bank query method, computer device and storage medium |
| CN115115450A (en) * | 2022-08-30 | 2022-09-27 | 平安银行股份有限公司 | Method and device for establishing silver union bill dispute case |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101315695A (en) * | 2008-07-09 | 2008-12-03 | 北京九恒星科技股份有限公司 | Bank information processing method and data extraction component |
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN105913310A (en) * | 2016-03-30 | 2016-08-31 | 上海携程商务有限公司 | Account monitoring method and system |
| CN110599316A (en) * | 2019-08-19 | 2019-12-20 | 厦门路桥信息股份有限公司 | Automatic account checking method, medium, equipment and device |
| CN111784304A (en) * | 2020-07-08 | 2020-10-16 | 广东粤财金融云科技股份有限公司 | Salary automatic issuing method and system based on RPA robot |
| CN112231673A (en) * | 2020-03-31 | 2021-01-15 | 北京来也网络科技有限公司 | Bank bill obtaining method, device, equipment and storage medium combining RPA and AI |
-
2021
- 2021-01-18 CN CN202110061495.9A patent/CN112801646A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101315695A (en) * | 2008-07-09 | 2008-12-03 | 北京九恒星科技股份有限公司 | Bank information processing method and data extraction component |
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN105913310A (en) * | 2016-03-30 | 2016-08-31 | 上海携程商务有限公司 | Account monitoring method and system |
| CN110599316A (en) * | 2019-08-19 | 2019-12-20 | 厦门路桥信息股份有限公司 | Automatic account checking method, medium, equipment and device |
| CN112231673A (en) * | 2020-03-31 | 2021-01-15 | 北京来也网络科技有限公司 | Bank bill obtaining method, device, equipment and storage medium combining RPA and AI |
| CN111784304A (en) * | 2020-07-08 | 2020-10-16 | 广东粤财金融云科技股份有限公司 | Salary automatic issuing method and system based on RPA robot |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115063221A (en) * | 2022-05-26 | 2022-09-16 | 重庆银行股份有限公司 | Bank client data cross-bank query method, computer device and storage medium |
| CN115063221B (en) * | 2022-05-26 | 2023-10-27 | 重庆银行股份有限公司 | Bank customer data cross-line query method, computer device and storage medium |
| CN115115450A (en) * | 2022-08-30 | 2022-09-27 | 平安银行股份有限公司 | Method and device for establishing silver union bill dispute case |
| CN115115450B (en) * | 2022-08-30 | 2022-11-29 | 平安银行股份有限公司 | Method and device for establishing case for dispute of Unionpay |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111343168B (en) | Identity authentication method and device, computer equipment and readable storage medium | |
| CN111274045B (en) | Multi-platform docking method and device, computer equipment and readable storage medium | |
| CN110597511B (en) | Page automatic generation method, system, terminal equipment and storage medium | |
| CN108287823B (en) | Message data processing method and device, computer equipment and storage medium | |
| CN110610196A (en) | Desensitization method, system, computer device and computer-readable storage medium | |
| CN112801646A (en) | Data processing method and device | |
| CN110599354A (en) | Online reconciliation method, system, computer device and computer-readable storage medium | |
| CN110191097B (en) | Method, system, equipment and storage medium for detecting security of login page | |
| US20220076264A1 (en) | System and method for simplifying fraud detection in real-time payment transactions from trusted accounts | |
| CN110334333B (en) | Information modification method and related device | |
| CN112463799A (en) | Data extraction method, device, equipment and storage medium | |
| CN112561488A (en) | Tax payment robot declaration method and device combining RPA and AI | |
| CN116167881A (en) | Automatic generation method, device, equipment and storage medium for payment account record | |
| CN110070383B (en) | Abnormal user identification method and device based on big data analysis | |
| CN111177099A (en) | Data processing method and device of business system, electronic equipment and storage medium | |
| CN111131393B (en) | User activity data statistical method, electronic device and storage medium | |
| US20210279720A1 (en) | Anomaly detection in a recurring transaction set | |
| CN111045983B (en) | Nuclear power station electronic file management method, device, terminal equipment and medium | |
| CN113687800A (en) | File printing processing method and device, computer equipment and storage medium | |
| US10235530B2 (en) | Protecting sensitive information when replicating data to remote systems | |
| KR102132745B1 (en) | apparatus for recording stock trading log by using SMS message | |
| CN111737080A (en) | Abnormal transaction suspicion monitoring method and device, computer equipment and storage medium | |
| CN110943982A (en) | Document data encryption method and device, electronic equipment and storage medium | |
| CN116756226B (en) | File generation method, device, server, user equipment and storage medium | |
| JP2019159578A (en) | Death notice processing program, device, and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |