CN109814856B - Data entry method, device, terminal and computer readable storage medium - Google Patents

Data entry method, device, terminal and computer readable storage medium Download PDF

Info

Publication number
CN109814856B
CN109814856B CN201910046793.3A CN201910046793A CN109814856B CN 109814856 B CN109814856 B CN 109814856B CN 201910046793 A CN201910046793 A CN 201910046793A CN 109814856 B CN109814856 B CN 109814856B
Authority
CN
China
Prior art keywords
field
data
identifier
storage process
preset
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
Application number
CN201910046793.3A
Other languages
Chinese (zh)
Other versions
CN109814856A (en
Inventor
刘克亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Priority to CN201910046793.3A priority Critical patent/CN109814856B/en
Publication of CN109814856A publication Critical patent/CN109814856A/en
Priority to PCT/CN2019/116736 priority patent/WO2020147385A1/en
Application granted granted Critical
Publication of CN109814856B publication Critical patent/CN109814856B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/33Intelligent editors

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data entry method, a device, a terminal and a computer readable storage medium, wherein the data entry method comprises the following steps: receiving a data reporting instruction, wherein the data reporting instruction comprises a service scene identifier; inquiring a segment table identifier corresponding to the service scene identifier, and a preset storage process and a field identifier corresponding to the segment table identifier according to a preset segment table information table; acquiring original data corresponding to the service scene identification and the field identification; transmitting the original data into the preset storage process; and executing the preset storage process to generate a report data table corresponding to the segment table identification. The invention improves the maintenance efficiency of data report generation by setting the preset storage process aiming at different service scenes.

Description

Data entry method, device, terminal and computer readable storage medium
Technical Field
The invention relates to the technical field of user behavior data statistics of pages, in particular to a data entry method, a data entry device, a terminal and a computer readable storage medium.
Background
The existing bank needs to send the relevant data of financial services such as payment putting, repayment and the like to a server of the Chinese people bank through a credit investigation reporting system for checking and archiving. In the prior art, SQL (Structured Query Language) is written for each service scenario to process the original data into a reporting data table meeting the requirements. If the audit regulation is changed or a certain original data processing method needs to be modified, the SQL corresponding to each service scene needs to be modified, which results in large workload and high maintenance cost.
Therefore, how to solve the technical problem of high maintenance cost of the data processing code corresponding to the existing banking business scene becomes a technical problem to be solved urgently at present.
Disclosure of Invention
The invention mainly aims to provide a data entry method, a data entry device, a terminal and a computer readable storage medium, and aims to solve the technical problem that a data processing code corresponding to a banking scene is high in maintenance cost.
In order to achieve the above object, the present invention provides a data entry method, including:
receiving a data reporting instruction, wherein the data reporting instruction comprises a service scene identifier;
inquiring a segment table identifier corresponding to the service scene identifier, and a preset storage process and a field identifier corresponding to the segment table identifier according to a preset segment table information table;
acquiring original data corresponding to the service scene identification and the field identification;
transmitting the original data into the preset storage process;
and executing the preset storage process to generate a report data table corresponding to the segment table identification.
Preferably, the step of transferring the original data information into the preset storage process includes:
inquiring the field type of the field identification according to a preset field table information table;
judging whether the field type is a dynamic value or not;
if the field type is the dynamic value, transmitting the original data into the preset storage process through the input parameters of the preset storage process;
and if the field type is not the dynamic value, directly writing the original data into the preset storage process.
Preferably, the step of querying the segment table identifier corresponding to the service scene identifier, and the preset storage procedure and the field identifier corresponding to the segment table identifier according to a preset segment table information table includes:
inquiring a segment table identifier corresponding to the service scene identifier and an SQL-ID sequence table corresponding to the segment table identifier according to a preset segment table information table;
and calling SQL sentences through a rank function and the SQL-ID sequence table to form the preset storage process, and sequencing the field identifications corresponding to the segment table identifications according to the SQL-ID sequence table.
Preferably, the step of executing the preset storage process and generating the report data table includes:
executing the preset storage process according to the execution instruction and the identification name of the preset storage process;
and sequentially generating fields corresponding to the field identifications according to the sequence of the field identifications corresponding to the field table identifications to form the reported data table.
Preferably, after the step of executing the preset storage process and generating the report data table corresponding to the segment table identifier, the method further includes:
arranging the reported data table corresponding to the segment table identifier according to the sequence of the segment table identifier corresponding to the service scene identifier to form a reported total table;
and sending the report summary table to an auditing terminal.
Preferably, the data entry method further comprises:
receiving a newly added field instruction, wherein the newly added field instruction comprises the segment table identification, the newly added field identification and newly added field data;
inquiring a preset storage process corresponding to the segment table identification according to a preset field table;
and adding the newly added field data into the preset storage process, and writing the newly added field identification into the preset field table information table.
Preferably, the data entry method further comprises:
receiving a field deleting instruction, wherein the field deleting instruction comprises the field identifier to be deleted;
inquiring a preset storage process corresponding to the field identification to be deleted according to a preset field table;
and deleting the part corresponding to the field identification to be deleted in the preset storage process.
In addition, the present invention also provides a data entry device, comprising:
the receiving module is used for receiving a data reporting instruction, and the data reporting instruction comprises a service scene identifier;
the first query module is used for querying a segment table identifier corresponding to the service scene identifier, and a preset storage process and a field identifier corresponding to the segment table identifier according to a preset segment table information table;
the acquisition module is used for acquiring original data corresponding to the service scene identification and the field identification;
the input module is used for transmitting the original data into the preset storage process;
and the generating module is used for executing the preset storage process and generating a report data table corresponding to the segment table identifier.
The invention also provides a terminal comprising a processor, a memory, and a data entry program stored on the memory and executable by the processor, wherein the data entry program, when executed by the processor, implements the steps of the data entry method as described above.
The present invention also provides a computer readable storage medium having stored thereon a data entry program, wherein the data entry program, when executed by a processor, implements the steps of the data entry method as described above.
According to the technical scheme, the preset storage process is preset, so that the situation that the same SQL is repeatedly written for different service scenes is omitted, and the data entry can be completed by calling the preset storage process corresponding to the segment table according to the required segment table for each service scene. When a certain field needs to be modified and a certain section of table needs to be added with or deleted with fields, the preset storage process corresponding to the section of table is directly modified without modifying the preset storage process of each service scene, so that the workload of operation and maintenance personnel is reduced, and the probability of maintenance errors is reduced.
Drawings
Fig. 1 is a schematic diagram of a hardware structure of a terminal according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a first embodiment of the data entry method of the present invention;
FIG. 3 is a schematic flow chart of a data entry method according to a second embodiment of the present invention;
FIG. 4 is a schematic flow chart of a data entry method according to a third embodiment of the present invention;
FIG. 5 is a schematic flow chart of a data entry method according to a fourth embodiment of the present invention;
FIG. 6 is a schematic flow chart of a fifth embodiment of the data entry method of the present invention;
FIG. 7 is a schematic flow chart of a data entry method according to a sixth embodiment of the present invention;
FIG. 8 is a schematic flow chart of a seventh embodiment of the data entry method of the present invention;
FIG. 9 is a block diagram of the data entry device of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The data entry method related to the embodiment of the invention is mainly applied to a terminal, and the terminal can be equipment with display and processing functions.
Referring to fig. 1, fig. 1 is a schematic diagram of a terminal structure according to an embodiment of the present invention. In the embodiment of the present invention, the terminal may include a processor 1001 (e.g., a CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. The communication bus 1002 is used for realizing connection communication among the components; the user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard); the network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface); the memory 1005 may be a high-speed RAM memory, or may be a non-volatile memory (e.g., a magnetic disk memory), and optionally, the memory 1005 may be a storage device independent of the processor 1001.
Those skilled in the art will appreciate that the hardware configuration shown in fig. 1 does not constitute a limitation of the apparatus, and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
With continued reference to FIG. 1, the memory 1005 of FIG. 1, which is one type of computer-readable storage medium, may include an operating system, a network communication module, and a data entry program.
In fig. 1, the network communication module is mainly used for connecting other terminals or servers to perform data communication; and the processor 1001 may call a data entry program stored in the memory 1005 and perform the steps of the data entry method.
Based on the hardware structure of the terminal, the invention provides various embodiments of the data entry method.
The invention provides a data entry method.
Referring to fig. 2, in a first embodiment of the present invention, a data entry method includes the following steps:
step S100, receiving a data reporting instruction, wherein the data reporting instruction comprises a service scene identifier;
specifically, the user performs an operation action through a mouse, a keyboard, and the like to generate a data reporting instruction. The service scenes can include a payment scene, a compensation scene, a repayment principal scene, a premium scene and the like, and different service scenes correspond to financial services developed by financial institutions. And setting service scene identifiers for distinguishing different service scenes, wherein the service scene identifiers are numbers, characters and the like for distinguishing each service scene. Aiming at different service scenes, the data to be input are different, and the data packets generated after the data are input and uploaded to the server of the monitoring authority are different.
Step S200, inquiring a segment table identifier corresponding to the service scene identifier, and a preset storage process and a field identifier corresponding to the segment table identifier according to a preset segment table information table;
the preset segment table information table is preset by a person skilled in the art, and at least one service scene identifier, a segment table identifier corresponding to each service scene identifier, a preset storage process corresponding to each segment table identifier, and at least one field identifier are stored in the preset segment table information table. Specifically, the service scenario identifier corresponds to at least one segment table identifier, and one segment table identifier corresponds to at least one field identifier. The database is composed of a plurality of segment tables, and the segment tables are marked by names, identification numbers and the like which can distinguish the segment tables in the database. The segment table is composed of at least one field, and the field identification is the name, identification number and the like which can distinguish each field in the same segment table.
The preset Stored Procedure is a Stored Procedure that is edited in advance by a person skilled in the art according to a segment table, the Stored Procedure (Stored Procedure) is a set of SQL statements for completing a specific function in a large database system, and the Stored Procedure can be executed by specifying the name of the pre-Stored Procedure and giving parameters. The storage process contains logic control statements and data manipulation statements that can accept arguments, output arguments, return single or multiple result sets, and return values. Since the stored procedures are compiled at the time of creation, i.e., on the database server, and stored in the database, the stored procedures run faster than a single block of SQL statements. Meanwhile, only the name of the stored process and necessary parameter information need to be provided during calling, so that the network flow can be reduced, and the network burden can be reduced.
Step S300, acquiring original data corresponding to the service scene identification and the field identification;
one or more different segment tables are required to be uploaded aiming at one service scene, and the segment tables required to be uploaded for each service scene can be the same or different. For different service scenarios, even if the segment tables to be uploaded are the same, the specifically adopted original data or calculation methods may be different. Therefore, the corresponding original data needs to be obtained according to the service scene identifier and the field identifier.
Step S400, transmitting the original data into the preset storage process;
the raw data can be directly transferred into a preset storage process or transferred into the storage process through participation.
Step S500, executing the preset storage process, and generating a report data table corresponding to the segment table identifier.
For example: the bank needs to send the data of the relevant service scenes to a Chinese people bank server through a credit investigation reporting system, the segment tables with the existing segment table identifications of B, D, F, H, I, J, K, L and M need to be uploaded, and the paying scenes need to be reported to B, D, F and H; b and H are reported in a repayment principal scene; repayment principal and premium scene reports B, H, L and M; reporting B, H, I and J of compensation scenes; and (5) reporting B, I and K of the compensation scene, namely, each service scene needs to be uploaded to B. Taking a repayment scenario as an example, the segment table B includes fields with field identifiers B1, B2, and B3, calls a preset storage process corresponding to the segment table B, transfers original data corresponding to the field identifiers B1, B2, and B3, executes the preset storage process, generates the segment table B composed of the fields B1, B2, and B3, and reports the segment table B to the data table. And making the segment tables B and H generated in the storage process into data packets corresponding to the paying scenes, and completing the reporting task of the data packets through a credit investigation reporting system.
According to the invention, the preset storage process is preset, so that the SQL which is repeatedly written for different service scenes is omitted, and the data entry can be completed by calling the preset storage process for each service scene. When a certain field needs to be modified and a certain section of table needs to be added with or deleted with, the preset storage process corresponding to the section of table is directly modified without modifying SQL aiming at each service scene, so that the workload of operation and maintenance personnel is reduced, and the probability of maintenance errors is reduced.
Further, referring to fig. 3, fig. 3 is a flowchart illustrating a second embodiment of the data entry method according to the present invention, based on the first embodiment, the step S400 includes:
step S410, inquiring the field type of the field identification according to a preset field table information table;
specifically, the field type in the invention has two types of dynamic value and fixed value, and the field type is judged by taking whether the field can be changed according to different service scenes as a standard. If the service scenes are different and the field content of the same field identifier is unchanged, the field type of the field is considered as a fixed value; and if the service scenes are different and the field content of the same field identifier is changed, the field type of the field is considered to be a dynamic value. For example: the segment table B has the following fields B1, B2, B3, B4, B5, B6 and B7., and the fields B4, B5 and B6 are not changed with different service scenes, so that the fields B4, B5 and B6 are fixed values; fields B1, B2, B3, and B7 differ with different contents of a traffic scene, so fields B1, B2, B3, and B7 are dynamic values.
Step S420, judging whether the field type is a dynamic value;
step S430, if the field type is the dynamic value, transmitting the original data into the preset storage process through the input parameter of the preset storage process;
when setting the preset storage process, a person skilled in the art sets an input parameter for a field type of the dynamic value, so that the preset storage process is a storage process with an input parameter and an output parameter.
Step S440, if the field type is not the dynamic value, directly writing the original data into the preset storage process.
For example: the default storage procedure is pro _ b (p _ b _ info), where p _ b _ info is an entry and is a RECORD custom type for Object type. The fields B4, B5, and B6 are fixed values, the original data corresponding to the fields B4, B5, and B6 can be written directly; values that change according to different scenarios, such as fields B1, B2, B3, and B7 are dynamic values, and are transmitted to the preset stored procedure pro _ B through the p _ B _ info parameter, the preset stored procedure pro _ B is called, and fields B4, B5, B6 and fields B1, B2, B3, and B7 are output and jointly form a segment table B.
Further, referring to fig. 4, fig. 4 is a flowchart illustrating a data entry method according to a third embodiment of the present invention, and based on the second embodiment, step S200 includes:
step S210, inquiring a segment table identifier corresponding to the service scene identifier and an SQL-ID sequence table corresponding to the segment table identifier according to a preset segment table information table;
SQL-ID is the only identification representing SQL statement, and the system finds the corresponding SQL statement according to SQL-ID. The SQL-ID sequence list comprises a plurality of SQL-IDs arranged in sequence, and each SQL-ID corresponds to one SQL statement. The sequence is pre-edited by a person skilled in the art according to SQL statements required for generating different segment tables and fields, so that the segment tables corresponding to different scenes are obtained by arranging the different SQL statements according to the sequence in the SQL-ID sequence table. The SQL-ID can be generated automatically or modified according to actual needs.
Step S220, calling SQL sentences through a rank function and the SQL-ID sequence table to form the preset storage process, and sorting the field identifications corresponding to the segment table identifications according to the SQL-ID sequence table.
And sequentially acquiring SQL sentences according to the SQL-ID sequence in the SQL-ID sequence table by calling a rank function to form a preset storage process, and generating a required segment table according to the preset storage process. By setting the SQL-ID sequence table, the same SQL sentences can be realized, and the segment table meeting the requirements of each scene is generated according to different arrangement orders. For example: the loan scene needs to be uploaded to a segment table B, the segment table B consists of fields B1, B2 and B3, SQL-IDs corresponding to the fields B1, B2 and B3 are obtained through an SQL-ID sequence table corresponding to the loan scene, SQL statements corresponding to the SQL-IDs are obtained, a preset storage process is generated, and then the segment table B consisting of fields B1, B2 and B3 in sequence is generated; if the loan repayment scenario requires uploading of segment table B, which consists of fields B2, B1, and B3, where field B1 generation needs to be performed on the result output from field B2. At the moment, SQL-IDs corresponding to fields B2, B1 and B3 are obtained through an SQL-ID sequence table corresponding to a repayment scene, SQL sentences corresponding to the SQL-IDs are obtained, a preset storage process is generated, and a segment table B sequentially composed of fields B2, B1 and B3 is generated.
Further, referring to fig. 5, fig. 5 is a flowchart illustrating a data entry method according to a third embodiment of the present invention, and based on the third embodiment, step S500 includes:
step S510, executing the preset storage process according to the execution instruction and the identification name of the preset storage process;
the execution instruction is an execution statement instruction for executing a preset storage process. The execution instructions are EXEC and sp _ executeSQL, and one of EXEC and sp _ executeSQL can be selected by a person skilled in the art according to actual needs. For example: if EXEC is selected to operate the preset storage process, begin + the identification name of the preset storage process + end can be input to operate; can also input "call" + preserve the storage process and discern the name to run;
and step S520, sequentially generating fields corresponding to the field identifications according to the sequence of the field identifications corresponding to the field table identifications to form the reported data table.
In this embodiment, the field identifiers corresponding to the segment table identifiers are arranged in an ordered manner, and the fields generated by the preset storage process correspond to the order of the field identifiers.
Further, referring to fig. 6, fig. 6 is a flowchart illustrating a fourth embodiment of the data entry method according to the present invention, and based on the first embodiment, after step S500, the method includes:
step S610, arranging the reported data table corresponding to the segment table identifier according to the sequence of the segment table identifier corresponding to the service scene identifier to form a reported summary table;
and step S620, sending the report summary table to an audit terminal.
Specifically, the embodiment is applied to Oracle Database, and of course, the data entry method may also be applied to other databases according to actual needs.
In this embodiment, the auditing terminal is a server where a credit investigation system of a people's bank is located. Of course, in other embodiments, the auditing terminal may also be a terminal set by the user for service monitoring. Through steps S610 and S620, for different service scenarios, the segment tables required by the service scenarios are integrated into a report summary table meeting the requirements, and the report summary table exists in the form of a data packet in general.
Further, referring to fig. 7, fig. 7 is a schematic flow chart of a fifth embodiment of the data entry method according to the present invention, and based on the first embodiment, the data entry method further includes:
step S710, receiving a new field instruction, wherein the new field instruction comprises the segment table identifier, the new field identifier and the new field data;
when a new field needs to be added to the field table, a person skilled in the art can draw up an identifier of the newly added field and write data of the newly added field corresponding to the identifier of the newly added field.
Step S720, inquiring a preset storage process corresponding to the segment table identification according to a preset field table;
step S730, adding the newly added field data into the preset storage process, and writing the newly added field identifier into the preset field table information table.
And adding the data of the newly added field into a preset storage process, so that a field table containing the newly added field can be obtained after the preset storage process is executed. Because each segment table corresponds to one storage process, when the segment table needs to be changed, the newly added field data for generating the newly added field is added into the storage process, so that maintenance can be realized, and the code of the segment table of each service scene does not need to be changed.
Further, the data entry method further comprises:
step S810, receiving a field modification instruction, wherein the field modification instruction comprises the field identification to be modified and field modification data;
step S820, inquiring a preset storage process corresponding to the field identification to be modified according to a preset field table;
step S830, deleting the portion corresponding to the field identifier to be modified in the preset storage process, and adding the modified field data to the preset storage process.
The field data is modified to be a code which is written by a person skilled in the art and meets the actual field requirement, so that the obtained field meets the requirement after the preset storage process is executed. And deleting the original codes corresponding to the fields in the preset storage process, and adding the modified field data, namely realizing maintenance without changing the codes of the segment table of each service scene.
Further, referring to fig. 8, fig. 8 is a schematic flow chart of a seventh embodiment of the data entry method of the present invention, based on the first embodiment, the data entry method further includes:
step S910, receiving a field deleting instruction, where the field deleting instruction includes the field identifier to be deleted;
step S920, inquiring a preset storage process corresponding to the field identifier to be deleted according to a preset field table;
step S930, deleting a portion corresponding to the to-be-deleted field identifier in the preset storage process.
Similar to the fifth embodiment and the sixth embodiment, each segment table corresponds to a storage process, so that when the segment table needs to be changed, new field data for generating new fields is added into the storage process, maintenance can be achieved, and the codes of the segment table of each service scene do not need to be changed.
For example: the corresponding predetermined storage procedure of the segment table B is pro _ B (p _ B _ info), where p _ B _ info is a reference. The fields B4, B5, and B6 included in the segment table B are fixed values, and the fields B1, B2, B3, and B7 are dynamic values.
If B4 needs to be modified, only the part of the stored procedure pro _ B corresponding to B4 needs to be modified; if a field B21 needs to be added to the segment table B, only SQL storing insert statements in the process pro _ B needs to be changed, and a field B21 is added to the custom p _ B _ info; if the segment table B needs to delete B7, it is sufficient to delete the part of the stored procedure pro _ B corresponding to B7. Thus the code is simple and easy to maintain.
In addition, the present invention also provides a data entry device, comprising:
a receiving module 10, where the receiving module 10 is configured to receive a data reporting instruction, where the data reporting instruction includes a service scene identifier;
a first query module 20, where the first query module 20 is configured to query, according to a preset segment table information table, a segment table identifier corresponding to the service scene identifier, and a preset storage process and a field identifier corresponding to the segment table identifier;
an obtaining module 30, where the obtaining module 30 is configured to obtain original data corresponding to the service scene identifier and the field identifier;
the logging module 40, wherein the logging module 40 is used for transmitting the original data into the preset storage process;
a generating module 50, where the generating module 50 is configured to execute the preset storage process and generate a report data table corresponding to the segment table identifier.
Further, the logging module 40 comprises:
the second query module is used for querying the field type of the field identifier according to a preset field table information table;
the judging module is used for judging whether the field type is a dynamic value or not;
a first writing module, configured to, if the field type is the dynamic value, transfer the original data into the preset storage process through an entry parameter of the preset storage process;
and the second writing module is used for directly writing the original data into the preset storage process if the field type is not the dynamic value.
Further, the obtaining module 30 is configured to query, according to a preset segment table information table, a segment table identifier corresponding to the service scene identifier and an SQL-ID sequence table corresponding to the segment table identifier;
and calling SQL sentences through a rank function and the SQL-ID sequence table to form the preset storage process, and sequencing the field identifications corresponding to the segment table identifications according to the SQL-ID sequence table.
Further, the generating module 50 includes:
and the execution module is used for executing the preset storage process, sequentially generating fields corresponding to the field identifications according to the sequence of the field identifications corresponding to the field table identifications, and forming the reported data table.
Further, the generating module 50 is further configured to arrange the report data table corresponding to the segment table identifier according to the sequence of the segment table identifier corresponding to the service scene identifier, so as to form a report summary table;
the data entry device comprises:
a sending module 60, where the sending module 60 is configured to send the report summary to an audit terminal.
Further, the receiving module 10 is further configured to receive a newly added field instruction, where the newly added field instruction includes the segment table identifier, the newly added field identifier, and newly added field data;
the first query module 20 is further configured to query a preset storage process corresponding to the segment table identifier according to a preset field table;
the data entry device comprises:
a modifying module 70, where the modifying module 70 is configured to add the newly added field data into the preset storage process, and write the newly added field identifier into the preset field table information table.
Further, the receiving module 10 is further configured to receive a modify field instruction, where the modify field instruction includes the field identifier to be modified and modify field data;
the first query module 20 is further configured to query a preset storage process corresponding to the field identifier to be modified according to a preset field table;
the modifying module 70 is further configured to delete a portion corresponding to the to-be-modified field identifier in the preset storage process, and add the modified field data to the preset storage process.
Further, the receiving module 10 is further configured to receive a delete field instruction, where the delete field instruction includes the field identifier to be deleted;
the first query module 20 is further configured to query a preset storage process corresponding to the field identifier to be deleted according to a preset field table;
the modifying module 70 is further configured to delete the portion corresponding to the field identifier in the preset storage process to be deleted.
In addition, the present invention further provides a computer-readable storage medium, on which a data entry program is stored, wherein when the data entry program is executed by a processor, the steps of the method for updating an interface as described above are implemented.
The method implemented when the data entry program is executed may refer to the embodiments of the data entry method of the present invention, and will not be described herein again.
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 system 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 system. 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 system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention 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 solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (9)

1. A data entry method, characterized in that the data entry method comprises:
receiving a data reporting instruction, wherein the data reporting instruction comprises a service scene identifier;
inquiring a segment table identifier corresponding to the service scene identifier and an SQL-ID sequence table corresponding to the segment table identifier according to a preset segment table information table, wherein the preset segment table information table stores at least one service scene identifier, a segment table identifier corresponding to the service scene identifier, a preset storage process corresponding to the segment table identifier and at least one field identifier;
calling SQL sentences through a rank function and the SQL-ID sequence table to form the preset storage process, and sorting the field identifications corresponding to the segment table identifications according to the SQL-ID sequence table;
acquiring original data corresponding to the service scene identification and the field identification;
transmitting the original data into the preset storage process;
and executing the preset storage process to generate a report data table corresponding to the segment table identification.
2. A data entry method as claimed in claim 1, wherein said step of transferring said raw data information into said predetermined storage procedure comprises:
inquiring the field type of the field identification according to a preset field table information table;
judging whether the field type is a dynamic value or not;
if the field type is the dynamic value, transmitting the original data into the preset storage process through the input parameters of the preset storage process;
and if the field type is not the dynamic value, directly writing the original data into the preset storage process.
3. A data entry method as claimed in claim 1, wherein said step of executing said predetermined storage procedure to generate a reporting data table comprises:
executing the preset storage process according to the execution instruction and the identification name of the preset storage process;
and sequentially generating fields corresponding to the field identifications according to the sequence of the field identifications corresponding to the field table identifications to form the reported data table.
4. A data entry method as claimed in claim 1, wherein after the step of executing the predetermined storage procedure to generate the reported data table corresponding to the segment table identifier, the method further comprises:
arranging the reported data table corresponding to the segment table identifier according to the sequence of the segment table identifier corresponding to the service scene identifier to form a reported total table;
and sending the report summary table to an auditing terminal.
5. A data entry method as claimed in claim 1, wherein the data entry method further comprises:
receiving a newly added field instruction, wherein the newly added field instruction comprises the segment table identification, the newly added field identification and newly added field data;
inquiring a preset storage process corresponding to the segment table identification according to a preset field table;
and adding the newly added field data into the preset storage process, and writing the newly added field identification into the preset field table information table.
6. A data entry method as claimed in claim 1, wherein the data entry method further comprises:
receiving a field deleting instruction, wherein the field deleting instruction comprises the field identifier to be deleted;
inquiring a preset storage process corresponding to the field identification to be deleted according to a preset field table;
and deleting the part corresponding to the field identification to be deleted in the preset storage process.
7. A data entry device, said data entry device comprising:
the receiving module is used for receiving a data reporting instruction, and the data reporting instruction comprises a service scene identifier;
a first query module, configured to query, according to a preset segment table information table, a segment table identifier corresponding to the service scene identifier and an SQL-ID sequence table corresponding to the segment table identifier, where the preset segment table information table stores at least one service scene identifier, a segment table identifier corresponding to the service scene identifier, a preset storage procedure corresponding to the segment table identifier, and at least one field identifier; calling SQL sentences through a rank function and the SQL-ID sequence table to form the preset storage process, and sorting the field identifications corresponding to the segment table identifications according to the SQL-ID sequence table;
the acquisition module is used for acquiring original data corresponding to the service scene identification and the field identification;
the input module is used for transmitting the original data into the preset storage process;
and the generating module is used for executing the preset storage process and generating a report data table corresponding to the segment table identifier.
8. A terminal comprising a processor, a memory, and a data entry program stored on the memory that is executable by the processor, wherein the data entry program, when executed by the processor, implements the steps of the data entry method of any of claims 1 to 6.
9. A computer-readable storage medium, having stored thereon a data entry program, wherein the data entry program, when executed by a processor, implements the steps of a data entry method as claimed in any one of claims 1 to 6.
CN201910046793.3A 2019-01-17 2019-01-17 Data entry method, device, terminal and computer readable storage medium Active CN109814856B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201910046793.3A CN109814856B (en) 2019-01-17 2019-01-17 Data entry method, device, terminal and computer readable storage medium
PCT/CN2019/116736 WO2020147385A1 (en) 2019-01-17 2019-11-08 Data entry method and apparatus, terminal and computer-readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910046793.3A CN109814856B (en) 2019-01-17 2019-01-17 Data entry method, device, terminal and computer readable storage medium

Publications (2)

Publication Number Publication Date
CN109814856A CN109814856A (en) 2019-05-28
CN109814856B true CN109814856B (en) 2022-04-15

Family

ID=66603504

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910046793.3A Active CN109814856B (en) 2019-01-17 2019-01-17 Data entry method, device, terminal and computer readable storage medium

Country Status (2)

Country Link
CN (1) CN109814856B (en)
WO (1) WO2020147385A1 (en)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109814856B (en) * 2019-01-17 2022-04-15 平安科技(深圳)有限公司 Data entry method, device, terminal and computer readable storage medium
CN112000326A (en) * 2020-08-20 2020-11-27 第四范式(北京)技术有限公司 Service providing method and device, electronic equipment and storage medium
CN112052242B (en) * 2020-09-02 2024-06-04 平安科技(深圳)有限公司 Data query method, device, electronic equipment and storage medium
CN112632078B (en) * 2020-12-29 2023-06-30 竹间智能科技(上海)有限公司 Method, system, equipment and readable storage medium for adding field to form
CN112732243B (en) * 2021-01-11 2024-06-18 京东科技控股股份有限公司 Data processing method and device for generating functional components
CN113704254B (en) * 2021-07-30 2023-06-16 北京奇艺世纪科技有限公司 Method and device for processing database business, electronic equipment and storage medium
CN113705184B (en) * 2021-09-01 2023-09-22 同盾科技有限公司 Custom report generation method and device, storage medium and electronic equipment
CN115801855B (en) * 2023-02-06 2023-05-23 广东金朋科技有限公司 Device control method, device, electronic device and storage medium
CN115840742B (en) * 2023-02-13 2023-05-12 每日互动股份有限公司 Data cleaning method, device, equipment and medium
CN116843454B (en) * 2023-07-18 2024-05-31 广东企企通科技有限公司 Channel information management method, device, equipment and medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1869982A (en) * 2005-11-08 2006-11-29 华为技术有限公司 Report data collection system and method
CN105354324A (en) * 2015-11-17 2016-02-24 国云科技股份有限公司 HC-SQL-based tree structure system and implementation method thereof
JP2016157419A (en) * 2015-02-19 2016-09-01 株式会社オービック Check business processing apparatus, check business processing method and check business processing program
CN107679057A (en) * 2017-06-26 2018-02-09 平安科技(深圳)有限公司 Data docking calculation, device, server and storage medium

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040243598A1 (en) * 2003-03-06 2004-12-02 Sleeper Dean A. Method and system for managing database SQL statements in web based and client/server applications
CN107391652B (en) * 2017-07-17 2020-07-14 浪潮通用软件有限公司 Template report interface definition system and method
CN109814856B (en) * 2019-01-17 2022-04-15 平安科技(深圳)有限公司 Data entry method, device, terminal and computer readable storage medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1869982A (en) * 2005-11-08 2006-11-29 华为技术有限公司 Report data collection system and method
JP2016157419A (en) * 2015-02-19 2016-09-01 株式会社オービック Check business processing apparatus, check business processing method and check business processing program
CN105354324A (en) * 2015-11-17 2016-02-24 国云科技股份有限公司 HC-SQL-based tree structure system and implementation method thereof
CN107679057A (en) * 2017-06-26 2018-02-09 平安科技(深圳)有限公司 Data docking calculation, device, server and storage medium

Also Published As

Publication number Publication date
WO2020147385A1 (en) 2020-07-23
CN109814856A (en) 2019-05-28

Similar Documents

Publication Publication Date Title
CN109814856B (en) Data entry method, device, terminal and computer readable storage medium
US20020129059A1 (en) XML auto map generator
CN107797826B (en) Rule configuration method based on rule engine, terminal and equipment
CN110909013B (en) Service list generation method, device, equipment and computer readable storage medium
CN107908695A (en) Operation system operation method, device, system and readable storage medium storing program for executing
CN110119292A (en) System operational parameters querying method, matching process, device and node device
CN1886976B (en) Method and apparatus for performing actions on a wireless device using action lists and versioning
US20160284013A1 (en) Order processing system and order processing method
CN113467782B (en) Method, device and equipment for determining business process
CN111343348A (en) Application method, system, device and storage medium of interactive voice response menu
CN111258940B (en) Configuration method, business auditing system, business auditing equipment and storage medium
KR20130126012A (en) Method and apparatusfor providing report of business intelligence
CN113485942B (en) Automatic testing method and device based on independent modules
CN113934526A (en) Construction method and device of business process
CN111240679B (en) Page development method and system
CN113239297A (en) Message pushing method, system and storage medium
CN110851446B (en) Data table generation method and device, computer equipment and storage medium
CN114218914A (en) Service matching method and related device
CN113822025A (en) Office file automatic generation method, device, equipment and storage medium
CN113144619A (en) Method and system for visually configuring dynamic function
CN112836479A (en) Data report generation method, system and storage device
CN114371866A (en) Version reconfiguration test method, device and equipment of service system
CN111652580A (en) Method and device for processing data of nodes
CN115481932B (en) ERP system database trigger generation method, storage medium and electronic device
CN117234512B (en) Method, system, electronic equipment and storage medium for rapidly developing business

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