WO2019144550A1 - 数据录入的优化处理方法、装置、计算机设备和存储介质 - Google Patents

数据录入的优化处理方法、装置、计算机设备和存储介质 Download PDF

Info

Publication number
WO2019144550A1
WO2019144550A1 PCT/CN2018/088933 CN2018088933W WO2019144550A1 WO 2019144550 A1 WO2019144550 A1 WO 2019144550A1 CN 2018088933 W CN2018088933 W CN 2018088933W WO 2019144550 A1 WO2019144550 A1 WO 2019144550A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
function
entry
page
sub
Prior art date
Application number
PCT/CN2018/088933
Other languages
English (en)
French (fr)
Inventor
谢磊
邱治兵
魏尧东
Original Assignee
平安科技(深圳)有限公司
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 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2019144550A1 publication Critical patent/WO2019144550A1/zh

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/455Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/445Program loading or initiating
    • G06F9/44505Configuring for program initiating, e.g. using registry, configuration files
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/451Execution arrangements for user interfaces

Definitions

  • the present application relates to an optimized processing method, apparatus, computer device and storage medium for data entry.
  • a business system that manages financial data a business system that manages supply chain data
  • a business system that manages human resource data usually contain multiple entry pages for the business. There can be multiple columns or multiple rows in each entry page.
  • the corresponding data is manually entered column by column or line by line in each entry page.
  • developers have developed an application that can automatically enter data through the application without manual operations. In application development, developers often need to write different code for each entry page, which results in more work for developers, resulting in lower development efficiency.
  • an optimized processing method, apparatus, computer device, and storage medium for data entry are provided.
  • An optimized processing method for data entry including:
  • the entry function reads data in the data file according to the configuration information, simulates a keyboard operation to control cursor movement in the entry page, and records the read data into a plurality of input boxes of the entry page.
  • An optimized processing device for data entry comprising:
  • a login module for simulating mouse operation and keyboard operation, logging into a business system, and displaying a main page of the business system;
  • a page selection module configured to simulate a mouse operation in the main page, select a corresponding control, and enter an input page corresponding to the control
  • a data entry module configured to invoke an entry function, obtain, by the entry function, a page identifier of the entry page and a data file corresponding to the page identifier; and read, by the entry function, a configuration file corresponding to the page identifier Obtaining corresponding configuration information; the entry function reads data in the data file according to the configuration information, simulates a keyboard operation to control cursor movement in the entry page, and records the read data into the entry page Multiple input boxes.
  • a computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executable by the processor to cause the one or more processors to execute The following steps:
  • the entry function reads data in the data file according to the configuration information, simulates a keyboard operation to control cursor movement in the entry page, and records the read data into a plurality of input boxes of the entry page.
  • One or more non-transitory computer readable storage mediums storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:
  • the entry function reads data in the data file according to the configuration information, simulates a keyboard operation to control cursor movement in the entry page, and records the read data into a plurality of input boxes of the entry page.
  • FIG. 1 is an application scenario diagram of an optimization processing method for data entry according to one or more embodiments
  • FIG. 2 is a flow chart of an optimized processing method for data entry in accordance with one or more embodiments
  • FIG. 3 is a structural block diagram of an optimization processing apparatus for data entry in accordance with one or more embodiments
  • FIG. 4 is a block diagram showing the structure of a computer device in accordance with one or more embodiments.
  • the method for optimizing data entry provided by the present application can be applied to an application environment as shown in FIG. 1.
  • the terminal 102 and the server 104 communicate via a network.
  • An application is installed in the terminal 102.
  • the application can be launched.
  • the login account and password are used to automatically log in to the business system.
  • the main page of the service system is displayed on the terminal.
  • a variety of controls can be displayed in the main page.
  • the terminal acquires the data management process of the business system, and according to the data management process, simulates the mouse movement and clicks the corresponding control to enter the entry page corresponding to the control.
  • a database is deployed in service 104, and data files are stored in the database.
  • the terminal 102 calls the entry function through the application program, acquires the page identifier of the entry page through the entry function, and sends a request for acquiring the data file to the server 104 according to the page identifier.
  • the server 104 extracts the corresponding data file in the database according to the acquisition request, and returns the data file to the terminal 102.
  • the terminal 102 reads the configuration file corresponding to the page identifier through the entry function, and obtains corresponding configuration information.
  • the entry function reads the data in the data file according to the configuration information, simulates the keyboard operation to control the cursor movement in the entry page, and records the read data into multiple input boxes of the entry page.
  • the terminal 102 can be, but is not limited to, various personal computers, notebook computers, smart phones, tablets, etc., and the server 104 can be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
  • an optimization processing method for data entry is provided.
  • the method is applied to the terminal in FIG. 1 as an example, and includes the following steps:
  • Step 202 Simulate mouse operation and keyboard operation, log in to the business system, and display the main page of the business system.
  • Step 204 Simulate a mouse operation in the main page, select a corresponding control, and enter an input page corresponding to the control.
  • the application is installed in the terminal.
  • the application can be launched.
  • the application is running, obtain the login account and password of the business system.
  • the login account and password are used to automatically log in to the business system.
  • the service system can be installed on the same terminal as the application, and the business system can also be installed on the server.
  • the terminal when the business system is installed in the terminal, when the terminal runs the application, it can simulate the mouse click on the icon of the business system and display the login page.
  • the terminal simulates mouse movement, moves the cursor to the input box of the login page, simulates the keyboard operation to input the login account and password respectively, simulates the mouse to click the “login” control, and completes the automatic login of the business system.
  • the icon of the business system can also be displayed on the terminal screen.
  • the terminal runs the application and simulates the manual login service system as described above. If the terminal screen does not display the icon of the business system, the terminal can obtain the link address of the business system by running the application program, simulate the mouse click browser, and simulate the keyboard operation, input the link address of the business system in the input box of the browser, and enter the business system. Login page. The terminal can simulate the mouse operation and keyboard operation in the above manner, input the login account and password in the login page, and complete the automatic login of the business system. After the service system is successfully logged in, the main page of the service system is displayed on the terminal. A variety of controls can be displayed in the main page. The terminal acquires the data management process of the business system, and according to the data management process, simulates the mouse movement and clicks the corresponding control to enter the entry page corresponding to the control.
  • the user does not need to manually operate, and the user can be automatically logged into the business system and the required entry page by simulating the mouse operation and the keyboard operation, thereby providing convenience for the user.
  • step 206 the entry function is called, and the page identifier of the entry page and the data file corresponding to the page identifier are obtained through the entry function.
  • the entry page has a page identifier.
  • the page identifier of the entry page and the data file can be pre-established with a mapping relationship.
  • the terminal invokes the entry function to obtain the page identifier of the entry page through the application, and according to the mapping relationship, the corresponding data file can be obtained according to the page identifier.
  • the entry function can be a function generated by the developer pre-packaging based on the industry entry code.
  • the entry function can be a main function, including multiple sub-functions.
  • the subfunction may include a first subfunction, a second subfunction, a third subfunction, and the like. Different sub-functions can implement different functions. For example, the first sub-function can be used to parse the configuration file, the second sub-function can be used to read the data file, and the third sub-function can be used for data entry.
  • the page identifier of the entry page and the data file corresponding to the page identifier can be obtained through the second sub-function.
  • the second sub-function can obtain the data file locally in the terminal, or generate the data file acquisition request, and send the acquisition request to the server through the terminal, and the server extracts the corresponding data file according to the acquisition request database, and returns the data file to the terminal.
  • the data file can be in a variety of file formats, for example, it can be a data table, an image, or a text file.
  • the data file is saved in the first preset format.
  • the first preset format can be in the form of a column or a row.
  • the first preset format in the data file may be the same as the format of the entry page, for example, the project name and the corresponding value are saved in columns in the data file.
  • the default format in the data file can also be different from the format on the entry page. For example, multiple values are stored as columns in a data file.
  • Step 208 Read a configuration file corresponding to the page identifier by using an entry function, and obtain corresponding configuration information.
  • the entry rules for each entry page require the developer to write the corresponding entry code. If a business system has multiple entry pages, the developer needs to write multiple sets of different entry codes. By executing the entry code, the application automatically enters the data in the corresponding entry page.
  • the entry rule of each entry page may be pre-written in the corresponding configuration file.
  • Different entry pages can correspond to different profiles.
  • the entry function can be a general-purpose function, and the application can perform data entry according to the rules of each entry page by calling the entry function, thereby effectively reducing the workload of the developer.
  • the configuration file can record configuration information of multiple configuration items, such as data reading position, data reading mode, data input mode, and cursor movement mode.
  • the data read location can be the location where the data is read in the data file, for example, column F, start line 7 and end line 39.
  • Data reading methods can include: reading by column or by row, and data reading order. Among them, it is possible to read data in columns in a data file, or to read data in rows.
  • the data reading order may be the order in which the data is read in the data file, for example, a forward order or a reverse order.
  • the data entry method can be entered by column in the entry page, or by row entry.
  • the cursor movement mode can be an analog operation mode for controlling the cursor in the input page, for example, by simulating a mouse operation or an analog keyboard operation.
  • the configuration file corresponding to the page identifier is read by the entry function, and the corresponding configuration information is obtained: the configuration file corresponding to the page identifier is read by using the first sub-function; and the configuration file is parsed to obtain more The configuration information corresponding to the configuration item; the configuration information is written into the first array.
  • the configuration file corresponding to the page identifier can be read by the first sub-function.
  • the configuration file can adopt the second preset format.
  • the first sub-function reads the configuration information corresponding to the configuration item according to the second preset format, and writes the configuration information into the first array.
  • the first sub-function can read all the configuration information in the configuration file at one time, and write all the configuration information into the first array.
  • the first sub-function can also read the configuration information in the configuration file multiple times, and write the read configuration information into the first array each time.
  • the configuration information in the configuration file is written into the first array by the first sub-function, thereby facilitating the second sub-function and the third sub-function to directly read the required configuration information in the first array.
  • Step 210 The input function reads data in the data file according to the configuration information, simulates keyboard operation to control cursor movement in the input page, and records the read data into multiple input boxes of the input page.
  • the entry function also includes a second sub-function through which the data file can be read.
  • the entry function reads the data in the data file according to the configuration information, including: reading the configuration information in the first array by using the second sub-function, the read configuration information including the data reading location and the data reading
  • the second sub-function reads data in the data file according to the data reading position and the data reading mode, and writes the read data into the second array.
  • the required configuration information is read in the first array, including the data reading position and the data reading mode.
  • the second sub-function reads the data to be entered in the forward or reverse order at the corresponding position of the data file according to the data reading position and the data reading mode.
  • the second sub-function may be read in columns in column F, and from the seventh row to the end of line 39.
  • the second sub-function can read all the data to be recorded in the data file at one time, and write the read data to be recorded into the second array.
  • the second sub-function can also read the data to be entered in the data file multiple times, and write the data to be recorded each time to the second array.
  • the second sub-function is used to write the data to be recorded in the data file to the second array, thereby facilitating the third sub-function to directly read the data required for entering the page in the second array.
  • the third sub-function of the entry function reads the configuration information required for entering the data in the first array, and the read configuration information includes the input position, the cursor movement mode, the data entry mode, the data entry mode, and the data reading mode.
  • the third sub-function reads the data to be recorded in the second array according to the data reading manner, and simulates the keyboard operation or the mouse operation to control the cursor movement according to the input position and the cursor movement mode, and records the data to be entered into the plurality of input boxes of the input page. .
  • the business system is automatically logged in, and the main page of the business system is displayed. Simulate the mouse operation in the main page, you can select the corresponding control to enter the entry page.
  • the configuration file records the configuration information required for each entry page.
  • the entry function is pre-packaged according to the entry code.
  • the configuration file corresponding to each entry page can be read, thereby utilizing the configuration file.
  • the read configuration information is read in the data file, the simulated keyboard operation controls the cursor movement in the entry page, and the read data is entered into multiple input boxes of the entry page. Since the rules for entering the page are written to the corresponding configuration file, the developer does not need to write the corresponding code for each input page when facing different input pages, and only needs to write different configuration files. This effectively reduces the workload of developers and improves development efficiency.
  • steps in the flowchart of FIG. 2 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and the steps may be performed in other orders. Moreover, at least some of the steps in FIG. 2 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, the execution of these sub-steps or stages The order is also not necessarily sequential, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of the other steps.
  • the configuration information read by the third sub-function further includes a recording connection mode
  • the third sub-function reads the data to be recorded in the second array according to the data reading manner, and simulates according to the input position and the cursor movement mode.
  • the keyboard operation or the mouse operation controls the cursor movement
  • the plurality of input boxes for entering the data to be entered into the input page include: the third sub-function obtains the current position of the cursor in the input page, and the current position includes the current column identifier or the current row identifier;
  • the current column identifier or the current row identifier and the data reading mode read the corresponding data to be entered in the second array;
  • the analog keyboard operation inputs the data to be entered into the input box corresponding to the input position, and simulates the keyboard operation or the mouse according to the cursor movement mode.
  • control cursor moves in the entry page, and the read data to be entered is sequentially recorded into the current column or the plurality of input boxes of the current row; the mouse operation or the keyboard operation is simulated according to the input connection mode, and the control cursor is moved to the entry page to In the next column or the next row, repeat the third sub-function to get the cursor recorded.
  • the current step position page, until all input box enter the page entry is completed.
  • the entry position may be a position in the entry page where data needs to be entered, including an initial position, an end position, a next column or a next row, and a start position and an end position of the next column.
  • Line IDs and column IDs can be included in the initial location.
  • the position of the cursor on the entry page can also be referred to as the initial position before the data entry is started.
  • the location where the cursor is located can also be referred to as the current location.
  • the third sub-function reads a plurality of pieces of configuration information such as an input position, a cursor movement mode, and a data reading mode in the first array.
  • the initial position is the seventh row of the Fth column in the entry page
  • the third sub-function reads the data to be entered in the corresponding position of the second array according to the initial position, and the simulated keyboard operation fills in the read data to be read.
  • the data entered by column is taken as an example for description, and the case of entering by row can be deduced by analogy.
  • the third sub-function can read the data to be entered in the second array in the forward order according to the data reading mode.
  • the third sub-function can read the data to be entered in the second array in reverse order according to the data reading mode.
  • the third sub-function simulates the keyboard operation, and fills the read data to be entered into the input box where the cursor is currently located.
  • the third sub-function simulates the mouse operation or the keyboard operation according to the cursor movement mode, and controls the cursor to move to the current column or the next input box of the current line according to the data entry mode.
  • the third sub-function continues to read the corresponding data to be entered in the second array according to the position of the input box where the cursor is located, and the simulated keyboard operation fills the data to be entered into the current input box until the input column in the current column is completed. Data entry.
  • the configuration information read by the third sub-function also includes the entry mode.
  • the entry mode can be a way of moving from the current column to the next column or moving from the current row to the next row.
  • the entry mode may be to move the cursor horizontally 3 times from the current column to the right to enter the next column.
  • the third sub-function simulates a mouse operation or a keyboard operation according to the input engagement mode, and controls the cursor to move to the next column or the next row during the entry to continue to input data.
  • the third sub-function obtains the column identifier or row identifier corresponding to the position of the cursor, reads the corresponding data in the corresponding array according to the column identifier or the row identifier, and simulates the mouse operation according to the cursor movement mode. Or keyboard operation, control the cursor to move in the column or row, and record the read data into multiple input boxes.
  • the endpoint can be the top or the end.
  • the previous column is entered, it is entered in the forward order from the top to the end.
  • the entry mode can be to control the cursor to move from the last row of the previous column to the initial row of the next column.
  • the third sub-function simulates the operation of the up key ( ⁇ ) in the direction key according to the number of rows in the previous column (the number of input boxes), and then simulates the left key ( ⁇ ) or right key ( ⁇ ) operation in the direction key. , move the cursor to the top of the next column.
  • the third sub-function reads the data in the second array according to the position of the cursor in the forward order.
  • the control cursor moves downward in the next column,
  • the data read in the forward direction is sequentially entered into multiple input boxes in the next column. Therefore, the third sub-function effectively connects multiple columns or rows in the input page according to the input connection mode, thereby ensuring complete entry in the entry page.
  • the entry mode can also be to control the horizontal movement of the cursor.
  • the third sub-function can quickly move the cursor to the end point of the next column according to the left ( ⁇ ) or right ( ⁇ ) operation in the analog direction key. If the previous column is entered, it is entered from the top to the end. When the previous column is entered, the cursor is at the end of the previous column. When the cursor moves to the next column, the cursor can be at the end of the next column.
  • the third sub-function reads data in the reverse order according to the position of the cursor in the second array. According to the manner provided in the above embodiment, the control cursor is sequentially moved upward in the next column, and the reverse-read data is sequentially input to Multiple input boxes in the next column.
  • the third sub-function effectively connect multiple columns or rows in the input page according to the input connection mode, thereby ensuring complete entry in the entry page.
  • the multiple operations of the upper key ( ⁇ ) in the analog direction key are reduced, which saves the time for the cursor to move to the next column, thereby further improving the efficiency of data entry.
  • the method further includes: when the cursor is at a position other than the end point of the next column or the next row, The third sub-function records the position as a temporary position; the third sub-function reads part of the data in the corresponding array according to the temporary position, and the partial data read by the keyboard operation is sequentially recorded into the partial input box according to the cursor movement mode, part of The input box starts from the temporary position to one end of the column or row; the third sub-function simulates mouse operation or keyboard operation to control the cursor to move to the temporary position, and the remaining data is read in the array in reverse order according to the temporary position, and the simulated keyboard operation will The remaining data is entered in the remaining input boxes of the column or row where the cursor is located.
  • the data entered by column is taken as an example for description, and the case of entering by row can be deduced by analogy.
  • the third sub-function will simulate the left button ( ⁇ ) or right button ( ⁇ ) in the direction key according to the input connection mode, and the cursor will fall at the end of the next column. Outside the location.
  • the third sub-function acquires the position where the cursor is at this time and records it as a temporary position.
  • the temporary location can include the column identifier of the column in which the cursor is located, and the row identifier corresponding to the input box.
  • the third sub-function reads the data reading order corresponding to the temporary location in the first array.
  • the data reading order corresponding to the temporary position may be read backward in the forward order from the temporary position, and read forward in the reverse order from the temporary position.
  • the data reading order corresponding to the temporary position may also be read forward in reverse order from the temporary position, and then read backward in the forward order from the temporary position.
  • the third sub-function reads the data to be entered in the second array according to the temporary position and the data reading order corresponding to the temporary position.
  • the third sub-function simulates the up key ( ⁇ ) or the down key ( ⁇ ) operation in the direction key according to the data reading order corresponding to the temporary position, controls the cursor to move up or down, and sequentially records the read data to be entered. Go to the corresponding input box until you reach the end of the column from the temporary location (either the top or the end).
  • the third sub-function simulates the down key ( ⁇ ) or the up key ( ⁇ ) operation in the direction key, and controls the cursor to move downward or upward to return to the temporary position.
  • the third sub-function reads the remaining data to be entered in the second array according to the temporary position in the reverse order, and controls the control cursor to move downward or upward, and sequentially records the read data to be entered into the corresponding input box. , until the other end of the column from the temporary position to the cursor, complete the entry of the entire column of data.
  • an effective connection of data entry between columns and columns is realized.
  • the temporary position where the cursor moves to the next column can be the 19th line of the Jth column, and the array is a one-dimensional array containing 32 data.
  • the third sub-function can be read from the 19th data, and can be read in the forward direction, and the read data is sequentially input to the 39th line from the 19th line of the Jth column.
  • the third sub-function simulates the down key ( ⁇ ) operation, controls the cursor to move downward, and the read data is sequentially entered from the 19th line until the 39th line (the end of the Jth column).
  • the third sub-function simulates the up key ( ⁇ ) operation, and the control cursor moves to line 19.
  • the third sub-function reads in reverse from the temporary position in the second array, and the read data is sequentially reversed into the seventh line (the top of the Jth column). This completes the data entry of the entire column of column J. Thus, when the number of input boxes of the previous column and the next column is different, an effective connection of data entry between columns and columns is realized.
  • the configuration information further includes rejecting the entry location; the method further includes: when there is an input box in the column or row where the cursor is rejected, the third sub-function records the corresponding reject position; the cursor moves to the reject position
  • the third sub-function simulates the mouse operation to skip the reject position, move the cursor to the next input box that allows the data to be entered; obtain the next input position corresponding to the input box that allows the data to be entered, according to the continued entry position in the array.
  • the data is read at the corresponding position; the simulated keyboard operation records the read data into the corresponding input box from the continued entry position.
  • the configuration information read by the third sub-function in the first array further includes rejecting the entry position.
  • the rejected entry location can be one or more input boxes. When there are multiple input boxes in the reject position, it may be a continuous plurality of input boxes, or may be a plurality of distributed input boxes.
  • the third sub-function simulates the mouse operation, and the control cursor skips the reject position until the next input box that allows data to be entered.
  • the third sub-function marks the position of the next input box that allows entry of data as the continued entry position.
  • the third sub-function reads the data to be recorded in the second array according to the continued input position, simulates the keyboard operation, and sequentially records the read data to be entered into the corresponding input box from the continued entry position.
  • the terminal can simulate the keyboard operation or the mouse operation to skip the reject position multiple times, and continue to input the corresponding data in the input box from the corresponding resume entry position multiple times.
  • the control cursor skips the rejection position, and continues to input data from the continued entry position, thereby ensuring that the data in the entry page can be successfully entered.
  • the method before the input function reads the data in the data file according to the configuration information, the method further includes: acquiring a key file, decoding the key file, and obtaining a corresponding decoded character string; The position is extracted to obtain the corresponding character, and the hidden key in the key file is obtained; the data file is decrypted by using the key to obtain the decrypted data file.
  • Data files usually record a large amount of data related to business operations. In order to prevent these operational data from leaking, data files can be pre-encrypted.
  • the key file required to decrypt the data file can be stored in the terminal.
  • the key file can be an image.
  • the key can be a preset text or a preset graphic in the picture.
  • the key file can be generated by the server using a preset picture and a key.
  • the server can encode the preset file into a string corresponding to the preset file by using the base64 encoding method, and encode the key into a string corresponding to the key.
  • the server adds the string corresponding to the key to the preset position of the encoded string corresponding to the preset picture according to the preset rule, and generates a key file, thereby hiding the key in the key file.
  • the key file can retain the original format, and the key file adds text or graphics corresponding to the key compared to the preset file. Among them, the added text or graphic is the key needed to decrypt the data file. Since the key is hidden in the picture in the form of text or graphics, even if it is intercepted by an illegal intruder, it is difficult to crack the key hidden therein. This effectively improves the security of key storage, which in turn effectively improves the security of data files.
  • the terminal After receiving the key file returned by the key server, the terminal can decode the key file through the application program to obtain a corresponding decoded character string.
  • the terminal acquires a preset rule through the application, and extracts a corresponding character in a preset position of the decoded character string according to the preset rule.
  • the terminal may extract a plurality of consecutive characters in the preset position in the decrypted string according to the preset rule by the application, and use the extracted characters to form a character string, and mark the string as the density required for decrypting the data file. key.
  • the terminal may separately extract a plurality of discontinuous characters in a plurality of preset positions in the decrypted string according to a preset rule by the application, and use the extracted characters to form a character string, and decrypt the string file to decrypt the data file.
  • the required key may separately extract a plurality of discontinuous characters in a plurality of preset positions in the decrypted string according to a preset rule by the application, and use the extracted characters to form a character string, and decrypt the string file to decrypt the data file. The required key.
  • the key files stored in the server can be dynamically updated.
  • the preset rules required to generate the key file can also be updated.
  • the server generates updated information using the updated preset rules.
  • the server pushes the update information to the terminal. In order to ensure that the terminal can be informed of the updated preset rules in time, the server can push the update information to the terminal in real time.
  • the terminal can extract the updated key in the updated key file by using the updated preset rule, thereby ensuring that the terminal can decrypt the data file by using the updated key.
  • the step of acquiring a corresponding data file according to the page identifier comprises: acquiring a plurality of encrypted data packets according to the page identifier; decrypting the plurality of encrypted data packets to obtain a plurality of decrypted data packets.
  • the splicing is performed by using a plurality of decrypted data packets to obtain a data file corresponding to the page identifier.
  • data files can be encrypted with a key before being transmitted.
  • the data file can be split first after being encrypted, or it can be split and then encrypted.
  • the encrypted key can be hidden in the key file of the above embodiment.
  • the terminal can extract the corresponding key in the key file by referring to the manner provided in the above embodiment by the application.
  • the terminal decrypts the plurality of encrypted data packets by using the key to obtain a plurality of decrypted data packets.
  • the decrypted data packet has a corresponding data packet identifier, and the terminal identifies a splicing order of the plurality of decrypted data packets according to the data packet identifier, and splices the plurality of decrypted data packets according to the splicing order to obtain data corresponding to the page identifier. file. Since the data file is split into multiple data packets after being encrypted, even if some data packets are intercepted by the illegal intruder, the illegal intruder cannot obtain the corresponding data, thereby effectively improving the security of the data file transmission.
  • an optimization processing device for data entry including: a login module 302, a page selection module 304, and a data entry module 306, wherein:
  • the login module 302 is configured to simulate mouse operation and keyboard operation, log in to the business system, and display the main page of the business system.
  • the page selection module 304 is configured to simulate a mouse operation in the main page to select a corresponding control, and enter an input page corresponding to the control.
  • the data entry module 306 is configured to invoke the entry function, obtain the page identifier of the entry page and the data file corresponding to the page identifier through the entry function; read the configuration file corresponding to the page identifier through the entry function, and obtain corresponding configuration information; the entry function
  • the data is read in the data file according to the configuration information, the simulated keyboard operation controls the cursor movement in the entry page, and the read data is entered into multiple input boxes of the entry page.
  • the entry function includes a first sub-function; the data entry module is further configured to read the configuration file corresponding to the page identifier by using the first sub-function; parsing the configuration file to obtain configuration information corresponding to the multiple configuration items ; Write configuration information to the first array.
  • the entry function further includes a second sub-function
  • the data entry module is further configured to read the configuration information in the first array by using the second sub-function, where the read configuration information includes a data read location and a data read.
  • the second sub-function reads data in the data file according to the data reading position and the data reading mode, and writes the read data into the second array.
  • the entry function further includes a third sub-function
  • the data entry module is further configured to read the configuration information in the first array by using the third sub-function, where the read configuration information includes a record position, a cursor movement manner, Data entry method and data reading method;
  • the third sub-function reads the data to be recorded in the second array according to the data reading manner, and simulates the keyboard operation or the mouse operation to control the cursor movement according to the input position and the cursor movement mode, and records the data to be entered into the plurality of input boxes of the input page. .
  • the configuration information read by the third sub-function further includes a record connection mode; the data entry module is further configured to acquire, by using a third sub-function, a current position of the cursor in the entry page, where the current location includes the current column identifier or The current row identifier; according to the current column identifier or the current row identifier and the data reading mode, the corresponding data to be entered is read in the second array; the simulated keyboard operation inputs the data to be entered into the input box corresponding to the input position, according to the cursor movement mode.
  • Simulate keyboard operation or mouse operation control the cursor to move in the input page, and sequentially input the read data to be entered into the current column or multiple input boxes of the current line; simulate mouse operation or keyboard operation according to the input connection mode, control the cursor Move to the next column or the next row in the entry page and repeat the third sub-function to get the current position of the cursor on the entry page until all the input boxes in the entry page are entered.
  • the data entry module is further configured to record the location as a temporary location when the cursor is at a position other than the endpoint of the next column or the next row; the third subfunction reads the corresponding array according to the temporary location Part of the data is taken, and the partial data read by the keyboard operation is sequentially recorded into the partial input box according to the cursor movement mode, and some input boxes start from the temporary position to one end of the column or row; the third sub-function simulates the mouse operation or The keyboard operation controls the cursor to move to the temporary position, and the remaining data is read in the array in reverse order according to the temporary position.
  • the analog keyboard operation records the remaining data in the remaining input boxes of the column or row where the cursor is located.
  • the apparatus further includes: a decryption module, configured to acquire a key file, decode the key file, and obtain a corresponding decoded character string; extract the corresponding character in the preset position in the decoded string to obtain a secret The key hidden in the key file; the data file is decrypted by the key to obtain the decrypted data file.
  • a decryption module configured to acquire a key file, decode the key file, and obtain a corresponding decoded character string; extract the corresponding character in the preset position in the decoded string to obtain a secret The key hidden in the key file; the data file is decrypted by the key to obtain the decrypted data file.
  • the various modules in the above-described data entry optimization processing device may be implemented in whole or in part by software, hardware, and combinations thereof.
  • Each of the above modules may be embedded in or independent of the processor in the computer device, or may be stored in a memory in the computer device in a software form, so that the processor invokes the operations corresponding to the above modules.
  • a computer device is provided.
  • the computer device may be a terminal, and an internal structural diagram thereof may be as shown in FIG.
  • the computer device includes a processor, memory, network interface, display screen, and input device connected by a system bus.
  • the processor of the computer device is used to provide computing and control capabilities.
  • the memory of the computer device includes a non-volatile storage medium, an internal memory.
  • the non-volatile storage medium stores operating systems and computer readable instructions.
  • the non-volatile storage medium can be a non-transitory computer readable storage medium.
  • the internal memory provides an environment for operation of an operating system and computer readable instructions in a non-volatile storage medium.
  • the network interface of the computer device is used to communicate with an external server via a network connection.
  • the computer readable instructions are executed by the processor to implement an optimized processing method for data entry.
  • the display screen of the computer device may be a liquid crystal display or an electronic ink display screen
  • the input device of the computer device may be a touch layer covered on the display screen, or may be a button, a trackball or a touchpad provided on the computer device casing. It can also be an external keyboard, trackpad or mouse.
  • FIG. 4 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device to which the solution of the present application is applied.
  • the specific computer device may It includes more or fewer components than those shown in the figures, or some components are combined, or have different component arrangements.
  • a computer apparatus comprising a memory and a processor, the memory storing computer readable instructions that, when executed by the processor, implement the steps of the various method embodiments described above.
  • a computer readable storage medium having stored thereon computer readable instructions that, when executed by a processor, implements the steps of the various method embodiments described above.

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • User Interface Of Digital Computer (AREA)
  • Input From Keyboards Or The Like (AREA)

Abstract

一种数据录入的优化处理方法,包括:模拟鼠标操作以及键盘操作,登录业务系统,显示业务系统的主页面;在主页面中模拟鼠标操作选择相应控件,进入与控件对应的录入页面;调用录入函数,通过录入函数获取录入页面的页面标识以及与页面标识对应的数据文件;通过录入函数读取与页面标识对应的配置文件,得到相应的配置信息;录入函数根据配置信息在数据文件中读取数据,模拟键盘操作在录入页面中控制光标移动,将读取到的数据录入录入页面的多个输入框中。

Description

数据录入的优化处理方法、装置、计算机设备和存储介质
本申请要求于2018年1月29日提交中国专利局,申请号为2018100829906,申请名称为“数据录入的优化处理方法、装置、计算机设备和存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。
技术领域
本申请涉及一种数据录入的优化处理方法、装置、计算机设备和存储介质。
背景技术
随着计算机技术的发展,出现了多种与数据管理相关的业务系统。例如,管理财务数据的业务系统、管理供应链数据的业务系统以及管理人力资源数据的业务系统等。这些业务系统中通常包含了业务所需的多个录入页面。每个录入页面中可以有多列或者多行。在传统的方式中,用户登录到业务系统后,在每个录入页面中手动逐列或逐行录入对应的数据。为了提高数据录入的工作效率,开发人员开发出一种应用程序,可以不需要人工操作,通过应用程序即可实现数据自动录入。在应用程序开发时,开发人员通常需要针对每个录入页面编写不同的代码,由此给开发人员造成较多的工作量,导致开发效率较低。
发明内容
根据本申请公开的各种实施例,提供一种数据录入的优化处理方法、装置、计算机设备和存储介质。
一种数据录入的优化处理方法,包括:
模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;
通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
一种数据录入的优化处理装置,包括:
登陆模块,用于模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
页面选择模块,用于在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;及
数据录入模块,用于调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
一种计算机设备,包括存储器和一个或多个处理器,所述存储器中储存有计算机可读指令,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器执行以下步骤:
模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;
通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
一个或多个存储有计算机可读指令的非易失性计算机可读存储介质,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行以下步骤:
模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
本申请的一个或多个实施例的细节在下面的附图和描述中提出。本申请的其它特征和优点将从说明书、附图以及权利要求书变得明显。
附图说明
为了更清楚地说明本申请实施例中的技术方案,下面将对实施例中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其它的附图。
图1为根据一个或多个实施例中数据录入的优化处理方法的应用场景图;
图2为根据一个或多个实施例中数据录入的优化处理方法的流程图;
图3为根据一个或多个实施例中数据录入的优化处理装置的结构框图;
图4为根据一个或多个实施例中计算机设备的结构框图。
具体实施方式
为了使本申请的目的、技术方案及优点更加清楚明白,以下结合附图及实施例,对本申请进行进一步详细说明。应当理解,此处描述的具体实施例仅仅用以解释本申请,并不用于限定本申请。
本申请提供的数据录入的优化处理方法,可以应用于如图1所示的应用环境中。其中,终端102与服务器104通过网络进行通信。终端102中安装了应用程序。当用户需要登录业务系统录入数据时,可以启动该应用程序。通过模拟鼠标操作以及键盘操作,利用登录账号和密码自动登录业务系统。 业务系统登录成功之后,在终端展示业务系统的主页面。主页面中可以显示多种控件。终端获取业务系统的数据管理流程,根据数据管理流程,模拟鼠标移动点击相应控件,进入与控件对应的录入页面。服务104中部署了数据库,数据库中存储了数据文件。终端102通过应用程序调用录入函数,通过录入函数获取录入页面的页面标识,根据页面标识向服务器104发送数据文件的获取请求。服务器104根据该获取请求在数据库中提取相应的数据文件,并将数据文件返回至终端102。终端102通过录入函数读取与页面标识对应的配置文件,得到相应的配置信息。录入函数根据配置信息在数据文件中读取数据,模拟键盘操作在录入页面中控制光标移动,将读取到的数据录入录入页面的多个输入框中。终端102可以但不限于是各种个人计算机、笔记本电脑、智能手机以及平板电脑等,服务器104可以用独立的服务器或者是多个服务器组成的服务器集群来实现。
在一个实施例中,如图2所示,提供了一种数据录入的优化处理方法,以该方法应用于图1中的终端为例进行说明,包括以下步骤:
步骤202,模拟鼠标操作以及键盘操作,登录业务系统,显示业务系统的主页面。
步骤204,在主页面中模拟鼠标操作选择相应控件,进入与控件对应的录入页面。
终端中安装了应用程序。当用户需要登录业务系统录入数据时,可以启动该应用程序。应用程序运行时,获取业务系统的登录账号和密码。通过模拟鼠标操作以及键盘操作,利用登录账号和密码自动登录业务系统。其中,业务系统可以与应用程序安装在同一台终端,业务系统还可以安装在服务器。
当业务系统安装在终端时,终端运行应用程序时,可以模拟鼠标点击业务系统的图标,显示登录页面。终端模拟鼠标移动,将光标移动至登录页面的输入框中,模拟键盘操作分别输入登录账号与密码,模拟鼠标点击“登录”控件,完成业务系统的自动登录。
当业务系统安装在服务器时,终端屏幕中也可以显示业务系统的图标。终端运行应用程序,按照上述方式模拟人工登录业务系统。如果终端屏幕没有显示业务系统的图标,终端可以通过运行应用程序获取业务系统的链接地址,模拟鼠标点击浏览器,以及模拟键盘操作在浏览器的输入框中输入业务系统的链接地址,进入业务系统的登录页面。终端可以按照上述方式模拟鼠标操作与键盘操作在登录页面中输入登录账号与密码,完成业务系统的自动 登录。业务系统登录成功之后,在终端展示业务系统的主页面。主页面中可以显示多种控件。终端获取业务系统的数据管理流程,根据数据管理流程,模拟鼠标移动点击相应控件,进入与控件对应的录入页面。
在应用程序开启之后,不需要用户手动操作,可以通过模拟鼠标操作以及键盘操作的方式,即可自动登录业务系统以及进行所需的录入页面,为用户提供了方便。
步骤206,调用录入函数,通过录入函数获取录入页面的页面标识以及与页面标识对应的数据文件。
录入页面具有页面标识。录入页面的页面标识与数据文件可以预先建立了映射关系。终端通过应用程序调用录入函数获取录入页面的页面标识,按照映射关系,可以根据页面标识获取对应的数据文件。录入函数可以是开发人员根据业面录入代码预先进行封装所生成的函数。录入函数可以是主函数,包括多个子函数。子函数可以包含第一子函数、第二子函数以及第三子函数等。不同的子函数可以实现不同的功能。例如,第一子函数可以用于解析配置文件,第二子函数可以用于读取数据文件,第三子函数可以用于数据录入。
当录入函数被调用时,可以通过第二子函数获取录入页面的页面标识,以及与该页面标识对应的数据文件。其中,第二子函数可以在终端本地获取数据文件,也可以生成数据文件的获取请求,通过终端向服务器发送该获取请求,服务器根据该获取请求数据库中提取相应数据文件,将数据文件返回至终端。数据文件可以采用多种文件格式,例如,可以是数据表,也可以是图像,还可以是文本文件等。数据文件中按照第一预设格式保存数据。第一预设格式可以是按列或按行的形式。数据文件中的第一预设格式可以与录入页面的格式相同,例如,数据文件中以列的形式保存项目名称和对应的数值。数据文件中的预设格式也可以与录入页面中的格式不同。例如,数据文件中以列的形式保存多个数值。
步骤208,通过录入函数读取与页面标识对应的配置文件,得到相应的配置信息。
在目前已有的方式中,每个录入页面的录入规则都需要在开发人员编写相应的录入代码。如果一个业务系统有多个录入页面,那么开发人员需要编写多套不同的录入代码。通过执行录入代码,应用程序在相应的录入页面中自动录入数据。
本实施例中,每个录入页面的录入规则可以预先写入对应的配置文件中。 不同的录入页面可以对应不同的配置文件。录入函数可以是通用的函数,应用程序通过调用录入函数可以按照各个录入页面的规则进行数据录入,从而有效减少了开发人员的工作量。
配置文件中可以记录多个配置项的配置信息,例如,数据读取位置、数据读取方式、数据录入方式以及光标移动方式等。数据读取位置可以是在数据文件中读取数据的位置,例如,第F列,起始行为第7行,结束行为第39行。数据读取方式可以包括:按列或按行读取,以及数据读取顺序。其中,可以是在数据文件中按列读取数据,也可以是按行读取数据。数据读取顺序可以是在数据文件中读取数据的顺序,例如,正向顺序或者反向顺序。数据录入方式可以是在录入页面中按列录入,也可以是按行录入。光标移动方式可以是控制光标在录入页面中的模拟操作方式,例如,可以是通过模拟鼠标操作,也可以是模拟键盘操作。
在其中一个实施例中,通过录入函数读取与页面标识对应的配置文件,得到相应的配置信息包括:通过第一子函数读取与页面标识对应的配置文件;对配置文件进行解析,得到多个配置项对应的配置信息;将配置信息写入第一数组。
当录入函数被调用时,可以通过第一子函数读取与页面标识对应的配置文件。配置文件可以采用第二预设格式。第一子函数按照第二预设格式读取配置项对应的配置信息,将配置信息写入第一数组。其中,第一子函数可以一次性读取配置文件中所有的配置信息,将所有的配置信息写入第一数组。第一子函数也可以多次读取配置文件中的配置信息,每次将读取到的配置信息相应写入第一数组中。通过第一子函数将配置文件中的配置信息写入第一数组,由此可以方便第二子函数以及第三子函数直接在第一数组中读取所需的配置信息。
步骤210,录入函数根据配置信息在数据文件中读取数据,模拟键盘操作在录入页面中控制光标移动,将读取到的数据录入录入页面的多个输入框中。
录入函数还包括第二子函数,通过第二子函数可以读取数据文件。在其中一个实施例中,录入函数根据配置信息在数据文件中读取数据包括:通过第二子函数在第一数组中读取配置信息,读取到的配置信息包括数据读取位置以及数据读取方式;第二子函数根据数据读取位置以及数据读取方式在数据文件中读取数据,将读取到的数据写入第二数组。
第二子函数被调用时,在第一数组中读取所需的配置信息,包括数据读取位置以及数据读取方式等。第二子函数根据数据读取位置以及数据读取方式,在数据文件的相应位置按正向顺序或反向顺序读取待录入数据。例如,第二子函数可以是在第F列按列读取,从第7行开始依次正向读至第39行结束。
第二子函数可以一次性在数据文件中读取全部待录入数据,将读取到的待录入数据写入第二数组。第二子函数也可以多次读取数据文件中的待录入数据,将每次读取到的待录入数据写入第二数组。通过第二子函数将数据文件中的待录入数据写入第二数组,由此可以方便第三子函数直接在第二数组中读取录入页面所需的数据。
录入函数的第三子函数在第一数组中读取录入数据所需的配置信息,读取到的配置信息包括录入位置、光标移动方式、数据录入方式、数据录入方式以及数据读取方式等。第三子函数根据数据读取方式在第二数组中读取待录入数据,根据录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将待录入数据录入录入页面的多个输入框中。
本实施例中,通过模拟鼠标操作和键盘操作,便自动登录业务系统,显示业务系统的主页面。在主页面中模拟鼠标操作,可以选择相应控件,从而进入录入页面。配置文件中记录了每个录入页面所需的配置信息,录入函数是根据录入代码预先封装生成的,通过调用录入函数可以读取与每个录入页面所对应的配置文件,从而利用从配置文件中读取的配置信息,在数据文件中读取数据,模拟键盘操作在录入页面中控制光标移动,将读取到的数据录入录入页面的多个输入框中。由于录入页面的规则被写入了对应的配置文件,因此在面对不同的录入页面时,开发人员无需再针对每个录入页面编写相应的代码,只需要编写不同的配置文件。由此实现了有效减少开发人员的工作量,提高开发效率。
应该理解的是,虽然图2的流程图中的各个步骤按照箭头的指示依次显示,但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明,这些步骤的执行并没有严格的顺序限制,这些步骤可以以其它的顺序执行。而且,图2中的至少一部分步骤可以包括多个子步骤或者多个阶段,这些子步骤或者阶段并不必然是在同一时刻执行完成,而是可以在不同的时刻执行,这些子步骤或者阶段的执行顺序也不必然是依次进行,而是可以与其它步骤或者其它步骤的子步骤或者阶段的至少一部分轮流或者交替 地执行。
在一个实施例中,第三子函数读取到的配置信息还包括录入衔接方式,第三子函数根据数据读取方式在第二数组中读取待录入数据,根据录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将待录入数据录入录入页面的多个输入框中包括:第三子函数获取光标在录入页面中的当前位置,当前位置包括当前列标识或当前行标识;根据当前列标识或当前行标识以及数据读取方式在第二数组中读取相应待录入数据;模拟键盘操作将待录入数据录入至与录入位置对应的输入框,根据光标移动方式模拟键盘操作或鼠标操作,控制光标在录入页面中移动,将读取到的待录入数据依次录入至当前列或当前行的多个输入框中;根据录入衔接方式模拟鼠标操作或键盘操作,控制光标在录入页面中移动至下一列或下一行,重复执行第三子函数获取光标在录入页面中的当前位置的步骤,直至将录入页面中所有的输入框录入完毕。
录入位置可以是录入页面中需要录入数据的位置,包括初始位置、结束位置、下一列或下一行以及下一列的起始位置和结束位置等。初始位置中可以包括行标识和列标识。在开始录入数据之前,光标在录入页面中的位置也可以称为初始位置。光标所在的位置还可以称为是当前位置。第三子函数在第一数组中读取录入位置、光标移动方式以及数据读取方式等多项配置信息。例如,初始位置为录入页面中的第F列第7行,第三子函数根据该初始位置在第二数组的相应位置读取待录入数据,模拟键盘操作将读取到的待录入数据填入初始位置对应的输入框。
为了简洁描述,本文中以按列录入数据为例进行说明,按行录入的情形可以此类推。当光标在当前列的初始行开始录入数据时,第三子函数根据数据读取方式,可以按照正向顺序在第二数组中读取待录入数据。当光标在当前列的第末行开始录入数据时,第三子函数根据数据读取方式,可以按照反向顺序在第二数组中读取待录入数据。
第三子函数模拟键盘操作,将读取到的待录入数据填入光标当前所在的输入框内。第三子函数按照光标移动方式,模拟鼠标操作或键盘操作,按照数据录入方式,控制光标移动至当前列或当前行的下一输入框。第三子函数根据光标所在输入框的位置继续在第二数组中读取相应的待录入数据,模拟键盘操作将该待录入数据填入当前的输入框中,直至完成当前列中多有输入框的数据录入。
第三子函数读取到的配置信息还包括录入衔接方式。录入衔接方式可以是从当前列移动至下一列的方式或者从当前行移动至下一行的方式。例如,录入衔接方式可以是将光标从当前列向右水平移动3次进入下一列。在完成当前列或行的录入之后,第三子函数根据录入衔接方式模拟鼠标操作或键盘操作,控制光标在录入中移动至下一列或下一行,以便继续录入数据。当光标在下一列或下一行的端点时,第三子函数获取光标所在位置对应的列标识或行标识,根据列标识或行标识在对应的数组中读取相应数据,根据光标移动方式模拟鼠标操作或键盘操作,控制光标在所在列或所在行中移动,将读取到的数据依次录入多个输入框中。其中,端点可以是顶端也可以是末端。当光标移动至下一列的顶端时,终端需要模拟鼠标移动,选择下一列的顶端,或者终端需要模拟键盘中的方向键,选择下一列的顶端。
如果上一列录入时,是按顶端往末端的正向顺序录入的,那么上一列录入完毕时,光标位于上一列的末端。录入衔接方式可以是控制光标从上一列的最末行移动至下一列的初始行。第三子函数根据该录入衔接方式,按照上一列的行数(输入框数量)模拟方向键中上键(↑)的操作,再模拟方向键中的左键(←)或右键(→)操作,将光标移动至下一列的顶端。当光标位于下一列的顶端时,第三子函数根据光标所在位置在第二数组中按照正向顺序读取数据,按照上述实施例中提供的方式,控制光标在下一列中依次向下移动,将正向读取到的数据依次录入到下一列的多个输入框中。由此使得第三子函数根据录入衔接方式将录入页面中的多列或多行进行了有效衔接,确保了录入页面中能够进行完整录入。
录入衔接方式也可以是控制光标水平移动。第三子函数在完成上一列的录入之后,可以根据模拟方向键中的左键(←)或右键(→)操作,将光标快速移动至下一列的端点。如果上一列录入时,是从顶端往末端的顺序录入的,那么上一列录入完毕时,光标位于上一列的末端。光标移动至下一列时,光标可以是在下一列的末端。第三子函数根据光标所在位置在第二数组中按照反向顺序读取数据,按照上述实施例中提供的方式,控制光标在下一列中依次向上移动,将反向读取到的数据依次录入到下一列的多个输入框中。不仅使得第三子函数根据录入衔接方式将录入页面中的多列或多行进行了有效衔接,确保了录入页面中能够进行完整录入。而且减少了模拟方向键中上键(↑)的多次操作,节省了光标移动至下一列的时间,从而能够进一步提高数据录入的效率。
在一个实施例中,在根据录入衔接方式模拟鼠标操作或键盘操作,控制光标在录入页面中移动至下一列或下一行之后,还包括:当光标在下一列或下一行的端点之外的位置时,第三子函数将位置记录为临时位置;第三子函数根据临时位置在对应数组中读取部分数据,根据光标移动方式模拟键盘操作将读取到的部分数据依次录入至部分输入框中,部分输入框从临时位置开始直至所在列或行的其中一端;第三子函数模拟鼠标操作或键盘操作控制光标移动至临时位置,根据临时位置按照相反顺序在数组中读取剩余数据,模拟键盘操作将剩余数据录入在光标所在列或行的剩余输入框中。
为了简洁描述,本文中以按列录入数据为例进行说明,按行录入的情形可以以此类推。如果下一列的输入框数量多于上一列的输入框数量时,第三子函数根据录入衔接方式模拟方向键中的左键(←)或右键(→)操作后,光标会落在下一列端点之外的位置上。第三子函数获取此时光标所在的位置,并且记录为临时位置。临时位置中可以包括光标所在列的列标识,以及输入框对应的行标识。第三子函数在第一数组中读取与临时位置对应的数据读取顺序。与临时位置对应的数据读取顺序可以是从临时位置开始按照正向顺序向后读取,再从临时位置开始按反向顺序向前读取。与临时位置对应的数据读取顺序也可以是从临时位置开始按照反向顺序向前读取,再从临时位置开始按正向顺序向后读取。
第三子函数根据临时位置以及与临时位置对应的数据读取顺序,在第二数组中读取待录入数据。第三子函数按照与临时位置对应的数据读取顺序模拟方向键中的上键(↑)或下键(↓)操作,控制光标向上或者向下移动,将读取到的待录入数据依次录入至对应的输入框中,直至从临时位置到所在列的其中一端(可以是顶端也可以是末端)。第三子函数模拟方向键中的下键(↓)或上键(↑)操作,控制光标向下或者向上移动,回到临时位置。第三子函数根据临时位置按照与刚才相反的顺序在第二数组中读取剩余的待录入数据,控制控制光标向下或者向上移动,将读取到的待录入数据依次录入对应的输入框中,直至从临时位置至光标所在列的另一端,完成整列数据的录入。由此在上一列与下一列的输入框数量不同时,实现了列与列之间数据录入的有效衔接。
例如,光标移动至下一列的临时位置可以是第J列的第19行,数组为一维数组,包含32个数据。第三子函数可以从第19个数据开始读取,可以先正向读取,将读取的数据从第J列的第19行开始依次正向录入至第39行。 第三子函数模拟下键(↓)操作,控制光标向下移动,将读取到的数据依次从第19行开始录入直至第39行(第J列的末端)。第三子函数模拟上键(↑)操作,控制光标移动至第19行。第三子函数在第二数组中从临时位置开始反向读取,将读取到的数据依次反向录入直至第7行(第J列的顶端)。由此完成第J列一整列的数据录入。由此在上一列与下一列的输入框数量不同时,实现了列与列之间数据录入的有效衔接。
在一个实施例中,配置信息还包括拒绝录入位置;该方法还包括:当光标所在列或行中存在拒绝录入数据的输入框时,第三子函数记录相应的拒绝位置;光标移动至拒绝位置时,第三子函数模拟鼠标操作跳过拒绝位置,将光标移动至下一个允许录入数据的输入框;获取下一个允许录入数据的输入框对应的继续录入位置,根据继续录入位置在数组中的相应位置读取数据;模拟键盘操作将读取到的数据从继续录入位置开始依次录入至相应的输入框中。
在上述实施例中提供的页面数据录入的过程中,还可能存在部分拒绝录入数据的输入框。第三子函数在第一数组读取到的配置信息还包括拒绝录入位置。拒绝录入位置可以是一个或多个输入框。当拒绝位置有多个输入框时,可以是连续的多个输入框,也可以是分散的多个输入框。第三子函数模拟鼠标操作,控制光标跳过拒绝位置,直至下一允许录入数据的输入框。
第三子函数将下一个允许录入数据的输入框的位置标记为继续录入位置。第三子函数根据继续录入位置在第二数组读取待录入数据,模拟键盘操作,将读取到的待录入数据依次从继续录入位置开始依次录入至相应的输入框中。可以理解,当拒绝位置是分散的多个输入框时,终端可以模拟键盘操作或鼠标操作多次跳过拒绝位置,并且多次从相应的继续录入位置开始继续在输入框中录入相应的数据。通过模拟键盘操作或者鼠标操作,控制光标跳过拒绝位置,从继续录入位置开始继续录入数据,由此确保了录入页面中的数据能够顺利录入。
在一个实施例中,在录入函数根据配置信息在数据文件中读取数据之前,还包括:获取密钥文件,对密钥文件进行解码,得到对应的解码字符串;在解码字符串中的预设位置提取相应字符,得到密钥文件中隐藏的密钥;利用密钥对数据文件进行解密,得到解密后的数据文件。
数据文件中通常会记录大量与企业运营相关的数据,为了防止这些运营数据泄露,数据文件可以预先加密的。终端中可以存储了对数据文件进行解 密所需的密钥文件。密钥文件可以是图片。密钥可以是图片中的预设文字或预设图形。密钥文件可以是服务器利用预设图片与密钥进行编码生成的。编码方式可以有多种,例如,服务器可以采用base64的编码方式将预设文件编码为预设文件对应的字符串,以及将密钥编码为密钥对应的字符串。服务器按照预设规则将密钥对应的字符串添加至预设图片对应的编码字符串的预设位置,生成密钥文件,以此将密钥隐藏在密钥文件中。
密钥文件可以保留原本的格式,密钥文件与预设文件相比,增加了与密钥对应的文字或图形。其中,所增加的文字或图形即为对数据文件进行解密所需的密钥。由于密钥以文字或图形的形式隐藏在图片中,即使被非法入侵者截获,也很难破解得到其中隐藏的密钥。由此有效提高了密钥保存的安全性,继而有效提高了数据文件的安全性。
终端在接收到密钥服务器返回的密钥文件后,可以通过应用程序对密钥文件进行解码,得到相应的解码字符串。终端通过应用程序获取预设规则,按照预设规则在解码字符串的预设位置提取相应字符。其中,终端通过应用程序按照预设规则可以在解密字符串中的预设位置提取多个连续的字符,利用提取到的字符组成字符串,将字符串标记为对数据文件进行解密所需的密钥。终端通过应用程序按照预设规则也可以在解密字符串中的多个预设位置中分别提取多个不连续的字符,利用提取到的字符组成字符串,将字符串标记对数据文件进行解密所需的密钥。
为了进一步提高数据文件的安全性,服务器中存储的密钥文件可以动态更新。密钥文件更新时,生成密钥文件所需的预设规则也可以更新。服务器利用更新后的预设规则生成更新信息。服务器将更新信息推送至终端。为了确保终端可以及时获悉更新后的预设规则,服务器可以将更新信息实时推送至终端。
终端通过应用程序可以利用更新后的预设规则在更新后的密钥文件提取更新后的密钥,以此确保了终端能够利用更新后的密钥对数据文件进行解密。
在其中一个实施例中,根据页面标识获取对应的数据文件的步骤包括:根据页面标识获取多个加密后的数据包;对多个加密后的数据包进行解密,得到多个解密后的数据包;利用多个解密后的数据包进行拼接,得到与页面标识对应的数据文件。
为了提高数据文件的传输安全,数据文件在传输之前,可以利用密钥进行加密。其中,数据文件可以先被加密后被拆分,也可以先被拆分后被加密。 加密的密钥可以隐藏在上述实施例的密钥文件中。
终端通过应用程序可以参照上述实施例中提供的方式,在密钥文件提取对应的密钥。终端利用密钥对多个加密后的数据包进行解密,得到多个解密后的数据包。解密后的数据包具有对应的数据包标识,终端根据数据包标识识别多个解密后的数据包的拼接顺序,根据拼接顺序对多个解密后的数据包进行拼接,得到与页面标识对应的数据文件。由于数据文件在加密后被拆分为多个数据包进行传输,即使部分数据包被非法入侵者截获,非法入侵者也无法得到相应的数据,从而有效提高了数据文件传输的安全性。
在一个实施例中,如图3所示,提供了一种数据录入的优化处理装置,包括:登陆模块302、页面选择模块304以及数据录入模块306,其中:
登陆模块302,用于模拟鼠标操作以及键盘操作,登录业务系统,显示业务系统的主页面。
页面选择模块304,用于在主页面中模拟鼠标操作选择相应控件,进入与控件对应的录入页面。
数据录入模块306,用于调用录入函数,通过录入函数获取录入页面的页面标识以及与页面标识对应的数据文件;通过录入函数读取与页面标识对应的配置文件,得到相应的配置信息;录入函数根据配置信息在数据文件中读取数据,模拟键盘操作在录入页面中控制光标移动,将读取到的数据录入录入页面的多个输入框中。
在一个实施例中,录入函数包括第一子函数;数据录入模块还用于通过第一子函数读取与页面标识对应的配置文件;对配置文件进行解析,得到多个配置项对应的配置信息;将配置信息写入第一数组。
在一个实施例中,录入函数还包括第二子函数,数据录入模块还用于通过第二子函数在第一数组中读取配置信息,读取到的配置信息包括数据读取位置以及数据读取方式;第二子函数根据数据读取位置以及数据读取方式在数据文件中读取数据,将读取到的数据写入第二数组。
在一个实施例中,录入函数还包括第三子函数,数据录入模块还用于通过第三子函数在第一数组中读取配置信息,读取到的配置信息包括录入位置、光标移动方式、数据录入方式以及数据读取方式;
第三子函数根据数据读取方式在第二数组中读取待录入数据,根据录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将待录入数据录入录入页面的多个输入框中。
在一个实施例中,第三子函数读取到的配置信息还包括录入衔接方式;数据录入模块还用于通过第三子函数获取光标在录入页面中的当前位置,当前位置包括当前列标识或当前行标识;根据当前列标识或当前行标识以及数据读取方式在第二数组中读取相应待录入数据;模拟键盘操作将待录入数据录入至与录入位置对应的输入框,根据光标移动方式模拟键盘操作或鼠标操作,控制光标在录入页面中移动,将读取到的待录入数据依次录入至当前列或当前行的多个输入框中;根据录入衔接方式模拟鼠标操作或键盘操作,控制光标在录入页面中移动至下一列或下一行,重复执行第三子函数获取光标在录入页面中的当前位置的步骤,直至将录入页面中所有的输入框录入完毕。
在一个实施例中,数据录入模块还用于当光标在下一列或下一行的端点之外的位置时,第三子函数将位置记录为临时位置;第三子函数根据临时位置在对应数组中读取部分数据,根据光标移动方式模拟键盘操作将读取到的部分数据依次录入至部分输入框中,部分输入框从临时位置开始直至所在列或行的其中一端;第三子函数模拟鼠标操作或键盘操作控制光标移动至临时位置,根据临时位置按照相反顺序在数组中读取剩余数据,模拟键盘操作将剩余数据录入在光标所在列或行的剩余输入框中。
在一个实施例中,该装置还包括:解密模块,用于获取密钥文件,对密钥文件进行解码,得到对应的解码字符串;在解码字符串中的预设位置提取相应字符,得到密钥文件中隐藏的密钥;利用密钥对数据文件进行解密,得到解密后的数据文件。
关于数据录入的优化处理装置的具体限定可以参见上文中对于数据录入的优化处理方法的限定,在此不再赘述。上述数据录入的优化处理装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中,也可以以软件形式存储于计算机设备中的存储器中,以便于处理器调用执行以上各个模块对应的操作。
在一个实施例中,提供了一种计算机设备,例如,计算机设备可以是终端,其内部结构图可以如图4所示。该计算机设备包括通过系统总线连接的处理器、存储器、网络接口、显示屏和输入装置。其中,该计算机设备的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统和计算机可读指令。非易失性存储介质可以是非易失性计算机可读存储介质。该内存储器为非易失性存储介质中的操作系统和计算机可读指令的运行提供环境。该计算机设备 的网络接口用于与外部的服务器通过网络连接通信。该计算机可读指令被处理器执行时以实现一种数据录入的优化处理方法。该计算机设备的显示屏可以是液晶显示屏或者电子墨水显示屏,该计算机设备的输入装置可以是显示屏上覆盖的触摸层,也可以是计算机设备外壳上设置的按键、轨迹球或触控板,还可以是外接的键盘、触控板或鼠标等。
本领域技术人员可以理解,图4中示出的结构,仅仅是与本申请方案相关的部分结构的框图,并不构成对本申请方案所应用于其上的计算机设备的限定,具体的计算机设备可以包括比图中所示更多或更少的部件,或者组合某些部件,或者具有不同的部件布置。
在一个实施例中,提供了一种计算机设备,包括存储器和处理器,该存储器存储有计算机可读指令,该处理器执行计算机可读指令时实现上述各个方法实施例中的步骤。
在一个实施例中,提供了一种计算机可读存储介质,其上存储有计算机可读指令,计算机可读指令被处理器执行时实现上述各个方法实施例中的步骤。
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,是可以通过计算机可读指令来指令相关的硬件来完成,所述的计算机可读指令可存储于一非易失性计算机可读取存储介质中,该计算机可读指令在执行时,可包括如上述各方法的实施例的流程。以上实施例的各技术特征可以进行任意的组合,为使描述简洁,未对上述实施例中的各个技术特征所有可能的组合都进行描述,然而,只要这些技术特征的组合不存在矛盾,都应当认为是本说明书记载的范围。
以上所述实施例仅表达了本申请的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本申请构思的前提下,还可以做出若干变形和改进,这些都属于本申请的保护范围。因此,本申请专利的保护范围应以所附权利要求为准。

Claims (20)

  1. 一种数据录入的优化处理方法,包括:
    模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
    在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
    调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;
    通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
    所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
  2. 根据权利要求1所述的方法,其特征在于,所述录入函数包括第一子函数;所述通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息包括:
    通过所述第一子函数读取与所述页面标识对应的配置文件;
    对所述配置文件进行解析,得到多个配置项对应的配置信息;及
    将所述配置信息写入第一数组。
  3. 根据权利要求2所述的方法,其特征在于,所述录入函数还包括第二子函数,所述录入函数根据所述配置信息在所述数据文件中读取数据包括:
    通过所述第二子函数在所述第一数组中读取配置信息,读取到的配置信息包括数据读取位置以及数据读取方式;及
    所述第二子函数根据所述数据读取位置以及数据读取方式在数据文件中读取数据,将读取到的数据写入第二数组。
  4. 根据权利要求3所述的方法,其特征在于,所述录入函数还包括第三子函数,所述模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中包括:
    通过所述第三子函数在所述第一数组中读取配置信息,读取到的配置信息包括录入位置、光标移动方式、数据录入方式以及数据读取方式;及
    所述第三子函数根据所述数据读取方式在第二数组中读取待录入数据,根据所述录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动, 将所述待录入数据录入所述录入页面的多个输入框中。
  5. 根据权利要求4所述的方法,其特征在于,所述第三子函数读取到的配置信息还包括录入衔接方式;所述第三子函数根据所述数据读取方式在第二数组中读取待录入数据,根据所述录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将所述待录入数据录入所述录入页面的多个输入框中包括:
    所述第三子函数获取光标在所述录入页面中的当前位置,所述当前位置包括当前列标识或当前行标识;
    根据所述当前列标识或当前行标识以及所述数据读取方式在第二数组中读取相应待录入数据;
    模拟键盘操作将所述待录入数据录入至与所述录入位置对应的输入框,根据光标移动方式模拟键盘操作或鼠标操作,控制光标在所述录入页面中移动,将读取到的待录入数据依次录入至当前列或当前行的多个输入框中;及
    根据所述录入衔接方式模拟鼠标操作或键盘操作,控制光标在所述录入页面中移动至下一列或下一行,重复执行所述第三子函数获取光标在所述录入页面中的当前位置的步骤,直至将所述录入页面中所有的输入框录入完毕。
  6. 根据权利要求5所述的方法,其特征在于,在所述根据所述录入衔接方式模拟鼠标操作或键盘操作,控制光标在所述录入页面中移动至下一列或下一行之后,还包括:
    当光标在下一列或下一行的端点之外的位置时,所述第三子函数将所述位置记录为临时位置;
    所述第三子函数根据所述临时位置在对应数组中读取部分数据,根据所述光标移动方式模拟键盘操作将读取到的部分数据依次录入至部分输入框中,所述部分输入框从所述临时位置开始直至所在列或行的其中一端;及
    所述第三子函数模拟鼠标操作或键盘操作控制光标移动至所述临时位置,根据所述临时位置按照相反顺序在所述数组中读取剩余数据,模拟键盘操作将所述剩余数据录入在光标所在列或行的剩余输入框中。
  7. 根据权利要求1至6任一项所述的方法,其特征在于,在所述录入函数根据所述配置信息在所述数据文件中读取数据之前,还包括:
    获取密钥文件,对所述密钥文件进行解码,得到对应的解码字符串;
    在所述解码字符串中的预设位置提取相应字符,得到所述密钥文件中隐藏的密钥;及
    利用所述密钥对数据文件进行解密,得到解密后的数据文件。
  8. 一种数据录入的优化处理装置,包括:
    登陆模块,用于模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
    页面选择模块,用于在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
    数据录入模块,用于调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
  9. 根据权利要求8所述的装置,其特征在于,所述录入函数包括第一子函数;所述数据录入模块还用于通过所述第一子函数读取与所述页面标识对应的配置文件;对所述配置文件进行解析,得到多个配置项对应的配置信息;及将所述配置信息写入第一数组。
  10. 一种计算机设备,包括存储器和一个或多个处理器,所述存储器中储存有计算机可读指令,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器执行以下步骤:
    模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
    在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
    调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;
    通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
    所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
  11. 根据权利要求10所述的计算机设备,其特征在于,所述录入函数包括第一子函数;所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    通过所述第一子函数读取与所述页面标识对应的配置文件;
    对所述配置文件进行解析,得到多个配置项对应的配置信息;及
    将所述配置信息写入第一数组。
  12. 根据权利要求11所述的计算机设备,其特征在于,所述录入函数还包括第二子函数,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    通过所述第二子函数在所述第一数组中读取配置信息,读取到的配置信息包括数据读取位置以及数据读取方式;及
    所述第二子函数根据所述数据读取位置以及数据读取方式在数据文件中读取数据,将读取到的数据写入第二数组。
  13. 根据权利要求13所述的计算机设备,其特征在于,所述录入函数还包括第三子函数,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    通过所述第三子函数在所述第一数组中读取配置信息,读取到的配置信息包括录入位置、光标移动方式、数据录入方式以及数据读取方式;及
    所述第三子函数根据所述数据读取方式在第二数组中读取待录入数据,根据所述录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将所述待录入数据录入所述录入页面的多个输入框中。
  14. 根据权利要求13所述的计算机设备,其特征在于,所述第三子函数读取到的配置信息还包括录入衔接方式,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    所述第三子函数获取光标在所述录入页面中的当前位置,所述当前位置包括当前列标识或当前行标识;
    根据所述当前列标识或当前行标识以及所述数据读取方式在第二数组中读取相应待录入数据;
    模拟键盘操作将所述待录入数据录入至与所述录入位置对应的输入框,根据光标移动方式模拟键盘操作或鼠标操作,控制光标在所述录入页面中移动,将读取到的待录入数据依次录入至当前列或当前行的多个输入框中;及
    根据所述录入衔接方式模拟鼠标操作或键盘操作,控制光标在所述录入页面中移动至下一列或下一行,重复执行所述第三子函数获取光标在所述录入页面中的当前位置的步骤,直至将所述录入页面中所有的输入框录入完毕。
  15. 根据权利要求14所述的计算机设备,其特征在于,所述计算机可读 指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    当光标在下一列或下一行的端点之外的位置时,所述第三子函数将所述位置记录为临时位置;
    所述第三子函数根据所述临时位置在对应数组中读取部分数据,根据所述光标移动方式模拟键盘操作将读取到的部分数据依次录入至部分输入框中,所述部分输入框从所述临时位置开始直至所在列或行的其中一端;及
    所述第三子函数模拟鼠标操作或键盘操作控制光标移动至所述临时位置,根据所述临时位置按照相反顺序在所述数组中读取剩余数据,模拟键盘操作将所述剩余数据录入在光标所在列或行的剩余输入框中。
  16. 根据权利要求10至15任一项所述的计算机设备,其特征在于,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:
    获取密钥文件,对所述密钥文件进行解码,得到对应的解码字符串;
    在所述解码字符串中的预设位置提取相应字符,得到所述密钥文件中隐藏的密钥;及
    利用所述密钥对数据文件进行解密,得到解密后的数据文件。
  17. 一个或多个存储有计算机可读指令的非易失性计算机可读存储介质,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行以下步骤:
    模拟鼠标操作以及键盘操作,登录业务系统,显示所述业务系统的主页面;
    在所述主页面中模拟鼠标操作选择相应控件,进入与所述控件对应的录入页面;
    调用录入函数,通过所述录入函数获取所述录入页面的页面标识以及与所述页面标识对应的数据文件;
    通过所述录入函数读取与所述页面标识对应的配置文件,得到相应的配置信息;及
    所述录入函数根据所述配置信息在所述数据文件中读取数据,模拟键盘操作在所述录入页面中控制光标移动,将读取到的数据录入所述录入页面的多个输入框中。
  18. 根据权利要求17所述的存储介质,其特征在于,所述录入函数包括第一子函数;计算机可读指令被一个或多个处理器执行时,使得一个或多个 处理器还执行以下步骤:
    通过所述第一子函数读取与所述页面标识对应的配置文件;
    对所述配置文件进行解析,得到多个配置项对应的配置信息;及
    将所述配置信息写入第一数组。
  19. 根据权利要求18所述的存储介质,其特征在于,所述录入函数还包括第二子函数,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:
    通过所述第二子函数在所述第一数组中读取配置信息,读取到的配置信息包括数据读取位置以及数据读取方式;及
    所述第二子函数根据所述数据读取位置以及数据读取方式在数据文件中读取数据,将读取到的数据写入第二数组。
  20. 根据权利要求19所述的存储介质,其特征在于,所述录入函数还包括第三子函数,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:
    通过所述第三子函数在所述第一数组中读取配置信息,读取到的配置信息包括录入位置、光标移动方式、数据录入方式以及数据读取方式;及
    所述第三子函数根据所述数据读取方式在第二数组中读取待录入数据,根据所述录入位置和光标移动方式模拟键盘操作或鼠标操作控制光标移动,将所述待录入数据录入所述录入页面的多个输入框中。
PCT/CN2018/088933 2018-01-29 2018-05-30 数据录入的优化处理方法、装置、计算机设备和存储介质 WO2019144550A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810082990.6 2018-01-29
CN201810082990.6A CN108255566B (zh) 2018-01-29 2018-01-29 数据录入的优化处理方法、装置、计算机设备和存储介质

Publications (1)

Publication Number Publication Date
WO2019144550A1 true WO2019144550A1 (zh) 2019-08-01

Family

ID=62743095

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/088933 WO2019144550A1 (zh) 2018-01-29 2018-05-30 数据录入的优化处理方法、装置、计算机设备和存储介质

Country Status (2)

Country Link
CN (1) CN108255566B (zh)
WO (1) WO2019144550A1 (zh)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109388397B (zh) * 2018-09-26 2024-05-03 中国平安财产保险股份有限公司 产品页面生成方法、系统、计算机设备和存储介质
CN109582229A (zh) * 2018-11-16 2019-04-05 陕西千山航空电子有限责任公司 一种固态记录设备数据存储和查找方法
CN111427545A (zh) * 2019-01-10 2020-07-17 长沙博为软件技术股份有限公司 一种c/s程序界面的自动写入方法
CN110321284B (zh) * 2019-06-03 2024-05-03 平安科技(深圳)有限公司 测试数据录入方法、装置、计算机设备和存储介质
CN111104195A (zh) * 2019-12-05 2020-05-05 东软集团股份有限公司 多表单页面的控制方法、装置、可读存储介质及电子设备
CN111338731B (zh) * 2020-02-24 2022-05-24 腾讯科技(深圳)有限公司 页面的显示方法、装置、计算机可读存储介质和计算机设备
CN114138393B (zh) * 2021-11-30 2024-06-11 中国工商银行股份有限公司 业务数据录入方法及装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080158160A1 (en) * 2006-12-29 2008-07-03 Christof Engel Central storage for data entry processing
CN104375818A (zh) * 2013-10-11 2015-02-25 北京金辉东方科技有限公司 一种通过配置文件实现通用数据格式录入的系统及方法
CN104573087A (zh) * 2015-01-28 2015-04-29 南京慧目信息技术有限公司 一种基于模拟计算机外设的数据传输方法
CN106681971A (zh) * 2015-11-11 2017-05-17 阿里巴巴集团控股有限公司 一种表单数据处理方法及装置

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110271173A1 (en) * 2010-05-03 2011-11-03 Xerox Corporation Method and apparatus for automatic filling of forms with data
CN105094329B (zh) * 2015-07-23 2019-06-21 大信沃思财务顾问(武汉)股份有限公司 数据录入方法、装置及应用其的电子设备
CN107133205A (zh) * 2017-05-04 2017-09-05 山东浪潮云服务信息科技有限公司 一种基于数据服务的云表单组件实现方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080158160A1 (en) * 2006-12-29 2008-07-03 Christof Engel Central storage for data entry processing
CN104375818A (zh) * 2013-10-11 2015-02-25 北京金辉东方科技有限公司 一种通过配置文件实现通用数据格式录入的系统及方法
CN104573087A (zh) * 2015-01-28 2015-04-29 南京慧目信息技术有限公司 一种基于模拟计算机外设的数据传输方法
CN106681971A (zh) * 2015-11-11 2017-05-17 阿里巴巴集团控股有限公司 一种表单数据处理方法及装置

Also Published As

Publication number Publication date
CN108255566A (zh) 2018-07-06
CN108255566B (zh) 2020-08-21

Similar Documents

Publication Publication Date Title
WO2019144550A1 (zh) 数据录入的优化处理方法、装置、计算机设备和存储介质
US10606576B1 (en) Developer experience for live applications in a cloud collaboration platform
US10686788B2 (en) Developer based document collaboration
WO2019144547A1 (zh) 数据录入方法、装置、计算机设备和存储介质
US10956652B2 (en) Support for non-native file types in web application environment
WO2019184138A1 (zh) 票据信息录入方法、装置、计算机设备和存储介质
Lawson Web scraping with Python
CN108292231B (zh) 从数据生成应用的方法和系统
CN116225399A (zh) 基于电子表格的软件应用程序开发
CN104704468B (zh) Web应用程序的跨系统安装
US20020184303A1 (en) Embedded web server capable of managing dynamic content delivery of data stream, audio stream, or video stream
US20190340230A1 (en) System and method for generating websites from predefined templates
US11418592B2 (en) Uploading user and system data from a source location to a destination location
CN111767095A (zh) 微服务生成方法、装置、终端设备及存储介质
WO2017151012A1 (ru) Способ обработки машиночитаемой информации
CN111783119B (zh) 表单数据安全控制方法、装置、电子设备及存储介质
CN114780497B (zh) 批量文件处理方法、装置、计算机设备、介质和程序产品
US20180090174A1 (en) Video generation of project revision history
US20180341717A1 (en) Providing instant preview of cloud based file
KR101866033B1 (ko) 웹 브라우저에서의 그리드 렌더링 방법 및 이를 적용한 컴퓨팅 시스템
TW201926017A (zh) 電子裝置與其視窗管理方法
RU2625936C1 (ru) Способ обработки машиночитаемой информации
Sur Visual Studio 2013 and. NET 4.5 Expert Cookbook
CN117933202A (zh) 报告生成方法、装置、计算机设备和存储介质
CN117521125A (zh) 文件处理方法、装置、电子设备及存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18901923

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 11.11.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18901923

Country of ref document: EP

Kind code of ref document: A1