Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Table insertion method and device, equipment and storage medium

A form and insert statement technology, applied in the field of data processing, can solve the problems of complex code writing, consumption of human resources, and lack of versatility, and achieve the effect of simple writing, saving human resources, and universality

Pending Publication Date: 2022-06-03
JIANGSU BAOWANGDA SOFTWARE TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above method makes the code writing more complicated, consumes a lot of human resources, and is not universal

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Table insertion method and device, equipment and storage medium
  • Table insertion method and device, equipment and storage medium
  • Table insertion method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 This is a flowchart of a method for inserting a table provided in Embodiment 1 of the present application, and this embodiment can be applied to the case of inserting data into a table in a database. The method can be performed by a table inserting device, which can be implemented by means of hardware and / or software, and can be configured in an electronic device. refer to figure 1 , the method specifically includes the following steps:

[0027] S110. Intercept the table insertion statement.

[0028] The table may be a database table in a database. A database table can be a table structure used to store data in a database. This database table contains row data and column data. It should be noted that the type of the database is not limited here, for example, it may be a MySQL database or an Oracle database.

[0029] The table insertion statement may be data inserted into the table as required, corresponding to the written code statement.

[0030] Specifi...

Embodiment 2

[0051] figure 2 This is a flowchart of a table insertion method provided in Embodiment 2 of the present application. This embodiment is further optimized on the basis of the foregoing embodiment.

[0052] Further, "control the execution of the table insertion statement according to the recognition result" is refined into "if the table insertion statement includes a system added field, then according to the addition rule of the system added field, a system added value is generated; according to The system adds values, updates the table insert statement; executes the updated table insert statement" to further improve the execution mechanism of the table insert statement.

[0053] refer to figure 2 Table insertion methods shown, including:

[0054] S210. Intercept the table insertion statement.

[0055] S220. Identify whether the table insertion statement includes a system added field.

[0056] S230. If the table insertion statement includes a system-added field, generate a s...

Embodiment 3

[0078] image 3 This is a flowchart of a table insertion method provided in Embodiment 3 of the present application. This embodiment is further optimized on the basis of the foregoing embodiment.

[0079] Further, "control the execution of the table insertion statement according to the recognition result" is refined into "if the system addition field is not included in the table insertion statement, directly execute the table insertion statement" to further improve the table The execution mechanism of the insert statement.

[0080] refer to image 3 Table insertion methods shown, including:

[0081] S310. Intercept the table insertion statement.

[0082] S320. Identify whether the table insertion statement includes a system added field.

[0083] S330. If the table insertion statement does not include the system added field, directly execute the table insertion statement to insert data into the table to be processed.

[0084] Specifically, if the system-added field is not ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a table insertion method and device, equipment and a storage medium. According to the specific implementation scheme, a table insertion statement is intercepted; identifying whether the table insertion statement comprises a system adding field or not; and according to an identification result, controlling to execute the table insertion statement so as to insert data into the to-be-processed table. According to the technical scheme, the to-be-processed table data can be automatically inserted, so that code writing is simpler, manpower resources are effectively saved, and universality is achieved.

Description

technical field [0001] The embodiments of the present application relate to data processing technologies, and in particular, to a table insertion method, apparatus, device, and storage medium. Background technique [0002] In general, data can be stored in a database. There are multiple database tables in a database. When data needs to be stored in the database, the data in the database table can be added by using an insert statement. [0003] At present, when developing applications based on databases, the coding methods for different fields added in different databases are the same. Therefore, when inserting data into database tables in different databases, developers need to encode corresponding fields in the code according to different coding methods. Writing field values. The above method makes the writing of the code more complicated, consumes a lot of human resources, and is not universal. SUMMARY OF THE INVENTION [0004] The present application provides a table...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F8/33G06F11/30
CPCG06F8/33G06F11/302G06F11/3089
Inventor 钟丹晔李业兵
Owner JIANGSU BAOWANGDA SOFTWARE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products