Transaction testing method and apparatus

By capturing and outputting SQL statements to terminal devices from the server, the problem of testers being unable to directly recognize SQL statements was solved, enabling an efficient transaction testing process.

CN115374014BActive Publication Date: 2026-05-29AGRICULTURAL BANK OF CHINA

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
AGRICULTURAL BANK OF CHINA
Filing Date
2022-09-30
Publication Date
2026-05-29

Smart Images

  • Figure CN115374014B_ABST
    Figure CN115374014B_ABST
Patent Text Reader

Abstract

The application provides a transaction test method and device, and relates to the technical field of finance. The transaction test method comprises the following steps: a server receives a user-triggered transaction test request sent by a terminal device multiple times; the server executes a structured query language (SQL) statement associated with each transaction test request to request updating a transaction test result of a target field of a target data table in a relational database, wherein the SQL statement comprises a table name of the target data table and a field name of the target field; the server captures each SQL statement and outputs each SQL statement to the terminal device for display; and the server finds the transaction test result under the target field of the target data table in the relational database in response to a query instruction from the terminal device, wherein the query instruction carries the table name of the target data table and the field name of the target field; and the server outputs the transaction test result to the terminal device for display, thereby reducing the communication cost during testing and improving the testing efficiency.
Need to check novelty before this filing date? Find Prior Art