CN115878659A - Method, device and equipment for generating SQL (structured query language) statement and readable storage medium - Google Patents
Method, device and equipment for generating SQL (structured query language) statement and readable storage medium Download PDFInfo
- Publication number
- CN115878659A CN115878659A CN202310049201.XA CN202310049201A CN115878659A CN 115878659 A CN115878659 A CN 115878659A CN 202310049201 A CN202310049201 A CN 202310049201A CN 115878659 A CN115878659 A CN 115878659A
- Authority
- CN
- China
- Prior art keywords
- sample
- name
- matching
- reference field
- statement
- 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.)
- Granted
Links
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention provides a method, a device, equipment and a readable storage medium for generating an SQL statement, wherein the method comprises the following steps: receiving a reference sentence input by a user; the standard statement is a statement written according to a service to be executed; analyzing the reference sentence to obtain a reference field; matching the reference field with a sample name in a preset sample library to obtain a matching result; the system comprises a sample library, a database and a database, wherein the sample library is created according to a service to be executed; the sample library includes at least one of: a sample name, a sample value set corresponding to the sample name; giving a sample value set to the reference field according to the matching result; and arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement to generate the SQL statement. Therefore, the field sequence and the field value in the generated SQL statement can meet the requirements of the service to be executed in different application scenes in a targeted manner.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a method, a device and equipment for generating an SQL (structured query language) statement and a readable storage medium.
Background
Currently, in the related art, when generating an SQL statement, a random data generation method is mostly adopted, and the randomly generated data is assembled into the SQL statement. However, the randomly generated data has no logicality, and for some specific scenes, the randomly generated data cannot be applied, and cannot meet the requirements of users.
Therefore, how to make the generated SQL statement specifically suitable for a specific scenario to meet the user's requirement becomes a technical problem to be solved urgently.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a readable storage medium for generating an SQL (structured query language) statement, which are used for solving the technical problems that the randomly generated SQL statement cannot be suitable for a specific application scene and cannot meet the requirements of a user in the related technology.
In order to solve the technical problem, the invention is realized as follows:
in a first aspect, an embodiment of the present invention provides a method for generating an SQL statement, where the method includes:
receiving a reference sentence input by a user; the standard statement is a statement written according to a service to be executed;
analyzing the reference statement to obtain a reference field;
matching the reference field with a sample name in a preset sample library to obtain a matching result; the sample library is created according to the service to be executed; the sample library includes at least one of: the sample name, a sample value set corresponding to the sample name;
assigning the set of sample values to the reference field according to the matching result;
and arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement to generate the SQL statement.
Preferably, matching the reference field with a sample name in a preset sample library, and obtaining a matching result includes:
matching each reference field with a sample name in the sample library respectively;
if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful;
and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure.
Preferably, after the matching result of the reference field is a matching failure, the method further includes:
sending out prompt information; the prompt information is used for prompting the user to add a new sample name to the sample library, and the new sample name is the same as the field name of the reference field with the matching result of failure in matching so as to update the sample library;
and matching the reference field failed in matching with the updated sample library to obtain a matching result.
Preferably, assigning the set of sample values to the reference field according to the matching result comprises:
and respectively taking each value in the sample value set corresponding to the sample name as the value of the reference field matched with the sample name.
Preferably, after the assigned reference fields are arranged according to the arrangement order of the reference fields in the reference statement to generate the SQL statement, the method further includes:
running the SQL statement;
determining hit data and/or non-hit data according to the operation result of the SQL statement;
the hit data is valid data required for executing the service to be executed, and the non-hit data is invalid data.
Preferably, the method further comprises:
determining the sample name and the sample value set corresponding to the sample name according to the service to be executed;
creating the sample library from the sample name and the set of sample values.
In a second aspect, an embodiment of the present invention provides an apparatus for generating an SQL statement, where the apparatus includes:
the receiving module is used for receiving a benchmark sentence input by a user; the standard statement is a statement written according to a service to be executed;
the analysis module is used for analyzing the reference sentence to obtain a reference field;
the matching module is used for matching the reference field with a sample name in a preset sample library to obtain a matching result; the sample library is created according to the service to be executed; the sample library includes at least one of: the sample name, a sample value set corresponding to the sample name;
the assignment module is used for assigning the sample value set to the reference field according to the matching result;
and the generating module is used for arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement so as to generate the SQL statement.
Preferably, the matching module is further configured to match each reference field with a sample name in the sample library respectively;
if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful;
and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure.
Preferably, the apparatus further comprises:
the prompt module is used for sending prompt information after the matching result of the reference field is matching failure; the prompt information is used for prompting the user to add a new sample name to the sample library, and the new sample name is the same as the field name of the reference field with the matching result of failure in matching so as to update the sample library;
and the matching module is also used for matching the reference field which fails to be matched with the updated sample library to obtain a matching result.
Preferably, the assigning module is further configured to use each value in the sample value set corresponding to the sample name as a value of a reference field matched with the sample name.
Preferably, the apparatus further comprises:
the operation module is used for arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement to generate an SQL statement and then operating the SQL statement;
the determining module is used for determining hit data and/or non-hit data according to the operation result of the SQL statement;
the hit data is valid data required for executing the service to be executed, and the non-hit data is invalid data.
Preferably, the determining module is further configured to determine the sample name and the sample value set corresponding to the sample name according to the service to be executed;
the device further comprises: and the creating module is used for creating the sample library according to the sample name and the sample value set.
In a third aspect, an embodiment of the present invention provides an electronic device, including: a processor, a memory and a program stored on the memory and executable on the processor, the program, when executed by the processor, implementing the steps of the method of generating SQL statements according to the first aspect.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the method for generating an SQL statement according to the first aspect.
In the embodiment of the invention, a sample library is preset according to the service to be executed, the sample library comprises a sample name and a sample value set corresponding to the sample name, the reference field is assigned by utilizing the matching relation between the sample name and the reference field, and the assigned reference field is spliced into the SQL statement in sequence. Therefore, the SQL sentences generated by taking the preset sample library as a reference are no longer random and unordered, and the field sequence and the field value in the generated SQL sentences can meet the requirements of the service to be executed in different application scenes in a targeted manner.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a flowchart of a method for generating an SQL statement according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a sample library according to an embodiment of the present invention;
fig. 3 is a structural block diagram of an apparatus for generating an SQL statement according to an embodiment of the present invention;
fig. 4 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without inventive step based on the embodiments of the present invention, are within the scope of protection of the present invention.
Fig. 1 illustrates a method for generating an SQL statement according to an embodiment of the present invention, as shown in fig. 1, the method includes:
step S101, receiving a reference sentence input by a user;
step S102, analyzing a reference sentence to obtain a reference field;
step S103, matching the reference field with a sample name in a preset sample library to obtain a matching result;
step S104, endowing a sample value set to the reference field according to the matching result;
and S105, arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference sentences to generate the SQL sentences.
In step S101, the reference statement includes, but is not limited to, an SQL statement, where the reference statement is a statement written by a user according to a service to be executed, and the user may input the statement by character typing or the like.
In step S102, the reference sentence may be parsed, i.e., the reference sentence is divided, and the reference field constituting the reference sentence is obtained. The reference field may be a query field and/or a condition field, among others.
In step S103, the reference field needs to be matched with the sample name in the preset sample library to obtain a matching result. Wherein, the sample library is a sample library created according to the service to be executed, and exemplarily: the sample name and the sample value set corresponding to the sample name can be determined according to the service to be executed, and a sample library is created according to the sample name and the sample value set. The sample library includes at least one of: the sample name, the set of sample values corresponding to the sample name, as shown in fig. 2, the sample library may further include a sample description and a creation date. The user can update the sample library in real time or periodically according to actual conditions, such as: the 'new' icon can be clicked on the display page to update the sample library; different sample libraries can be created for different services to be executed according to actual conditions. And the matching result in step S103 includes matching success or matching failure.
In a possible implementation manner, matching the reference field with a sample name in a preset sample library, and obtaining a matching result includes: matching each reference field with a sample name in a sample library respectively; if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful; and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure. Taking the sample library shown in fig. 2 as an example, if a reference field is an amont, the reference field is successfully matched with the amont (sample name) in the sample library shown in fig. 2.
In a possible implementation manner, after the matching result of the reference field is a matching failure, the method further includes: sending out prompt information; the prompt information is used for prompting a user to add a new sample name to the sample library, and the new sample name is the same as the field name of the reference field with the matching result of failure in matching so as to update the sample library; and matching the reference field failed in matching with the updated sample library to obtain a matching result.
It can be understood that, if no sample name identical to the field name of the reference field exists in the sample library, the matching result of the reference field is matching failure, the sample library may be updated according to actual needs, and after the updating, the reference field failed in matching may be matched with the updated sample library again to obtain a matching result, so as to ensure the accuracy of the final generated SQL statement. And the prompt information can be output in the modes of voice (ring alarm), characters and the like.
In step S104, a sample value set is assigned to the reference field according to the matching result, that is: taking the sample base shown in fig. 2 as an example, each value in the sample value set corresponding to the sample name is respectively used as a value of the reference field matched with the sample name, and-1, 0, 1, 2, 3, 4, and 5 in the sample value set corresponding to the sample name of type can be respectively assigned to the reference field of type.
In one possible implementation, an inverse value may also be set in the sample value set, and the inverse value may be used for anomaly testing.
In step S105, the assigned reference fields are arranged according to the arrangement order of the reference fields in the reference statement, so as to generate the SQL statement. Because each reference field can be assigned for many times according to the sample value set corresponding to the matched sample name, a large number of SQL sentences meeting the requirements of the business to be executed can be generated. And preferably, the SQL statement is an install statement.
In a possible implementation manner, after the assigned reference fields are arranged according to the arrangement order of the reference fields in the reference statement to generate the SQL statement, the method further includes: operating SQL sentences; determining hit data and/or non-hit data according to the operation result of the SQL statement; the hit data is effective data required when the to-be-executed service is executed, and the non-hit data is invalid data. In the SQL statement corresponding to the non-hit data, the value of the reference field is a reverse value in the sample value set, and the reverse value can be used for anomaly testing. But for the traffic to be executed, the non-hit data is invalid data.
In the embodiment of the invention, a sample library is preset according to the service to be executed, the sample library comprises a sample name and a sample value set corresponding to the sample name, the reference field is assigned by utilizing the matching relation between the sample name and the reference field, and the assigned reference field is spliced into the SQL sentence in sequence. Therefore, the SQL sentences generated by taking the preset sample library as a reference are no longer random and unordered, and the field sequence and the field values in the generated SQL sentences can meet the requirements of the business to be executed in different application scenes in a targeted manner.
Fig. 3 shows an apparatus 30 for generating an SQL statement according to an embodiment of the present invention, where the apparatus 30 includes:
a receiving module 301, configured to receive a reference sentence input by a user; the standard statement is a statement written according to a service to be executed;
the analysis module 302 is configured to analyze the reference sentence to obtain a reference field;
the matching module 303 is configured to match the reference field with a sample name in a preset sample library to obtain a matching result; the system comprises a sample library, a service database and a database, wherein the sample library is created according to a service to be executed; the sample library includes at least one of: the method comprises the steps of obtaining a sample name and a sample value set corresponding to the sample name;
an assignment module 304, configured to assign a sample value set to the reference field according to the matching result;
the generating module 305 is configured to arrange the assigned reference fields according to the arrangement order of the reference fields in the reference statement, so as to generate the SQL statement.
In a possible implementation manner, the matching module 303 is further configured to match each reference field with a sample name in the sample library respectively; if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful; and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure.
In one possible implementation, the apparatus 30 further includes:
the prompt module is used for sending out prompt information after the matching result of the reference field is that the matching fails; the prompt information is used for prompting a user to add a new sample name to the sample library, and the new sample name is the same as the field name of the reference field with the matching result of failure in matching so as to update the sample library;
the matching module 303 is further configured to match the reference field that fails to be matched with the updated sample library to obtain a matching result.
In a possible implementation manner, the assigning module 304 is further configured to use each value in the sample value set corresponding to the sample name as a value of the reference field matching the sample name.
In one possible implementation, the apparatus 30 further includes:
the operation module is used for arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference sentences so as to generate SQL sentences and then operating the SQL sentences;
the determining module is used for determining hit data and/or non-hit data according to the operation result of the SQL statement;
the hit data is valid data required for executing the service to be executed, and the non-hit data is invalid data.
In a possible implementation manner, the determining module is further configured to determine, according to the service to be executed, a sample name and a sample value set corresponding to the sample name;
the apparatus 30 further comprises: and the creating module is used for creating a sample library according to the sample name and the sample value set.
In the embodiment of the invention, a sample library is preset according to a service to be executed, the sample library comprises a sample name and a sample value set corresponding to the sample name, the reference field is assigned by utilizing the matching relation between the sample name and the reference field, and the assigned reference field is spliced into the SQL statement in sequence. Therefore, the SQL sentences generated by taking the preset sample library as a reference are no longer random and unordered, and the field sequence and the field values in the generated SQL sentences can meet the requirements of the business to be executed in different application scenes in a targeted manner.
An embodiment of the present invention further provides an electronic device 40, as shown in fig. 4, including: a processor 401, a memory 402 and a program stored on the memory 402 and executable on the processor 401, which when executed by the processor implements the steps of the method of generating SQL statements as shown in fig. 1.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method for generating an SQL statement as shown in fig. 1 are implemented, and the same technical effects can be achieved. The computer-readable storage medium may be a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one of 8230, and" comprising 8230does not exclude the presence of additional like elements in a process, method, article, or apparatus comprising the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as 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.
While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (10)
1. A method of generating an SQL statement, the method comprising:
receiving a reference sentence input by a user; the standard statement is a statement written according to a service to be executed;
analyzing the reference statement to obtain a reference field;
matching the reference field with a sample name in a preset sample library to obtain a matching result; the sample library is created according to the service to be executed; the sample library includes at least one of: the sample name, a sample value set corresponding to the sample name;
assigning the set of sample values to the reference field according to the matching result;
and arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement to generate the SQL statement.
2. The method of claim 1, wherein matching the reference field with a sample name in a preset sample library, and obtaining a matching result comprises:
matching each reference field with a sample name in the sample library respectively;
if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful;
and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure.
3. The method of claim 2, wherein after the matching result of the reference field is a matching failure, the method further comprises:
sending out prompt information; the prompt information is used for prompting the user to add a new sample name to the sample library, and the new sample name is the same as the field name of the reference field with the matching result of failure in matching so as to update the sample library;
and matching the reference field failed in matching with the updated sample library to obtain a matching result.
4. The method of claim 2, wherein assigning the set of sample values to the reference field according to the matching result comprises:
and respectively taking each value in the sample value set corresponding to the sample name as the value of the reference field matched with the sample name.
5. The method according to claim 1, wherein after the assigned reference fields are arranged according to the arrangement order of the reference fields in the reference statement to generate the SQL statement, the method further comprises:
running the SQL statement;
determining hit data and/or non-hit data according to the operation result of the SQL statement;
the hit data is valid data required for executing the service to be executed, and the non-hit data is invalid data.
6. The method according to any one of claims 1-5, further comprising:
determining the sample name and the sample value set corresponding to the sample name according to the service to be executed;
creating the sample library from the sample name and the set of sample values.
7. An apparatus for generating an SQL statement, the apparatus comprising:
the receiving module is used for receiving a benchmark sentence input by a user; the standard statement is a statement written according to a service to be executed;
the analysis module is used for analyzing the reference sentence to obtain a reference field;
the matching module is used for matching the reference field with a sample name in a preset sample library to obtain a matching result; the sample library is created according to the service to be executed; the sample library includes at least one of: the sample name, a sample value set corresponding to the sample name;
the assignment module is used for assigning the sample value set to the reference field according to the matching result;
and the generating module is used for arranging the assigned reference fields according to the arrangement sequence of the reference fields in the reference statement so as to generate the SQL statement.
8. The apparatus of claim 7,
the matching module is also used for matching each reference field with the sample name in the sample library respectively;
if the sample name which is the same as the field name of the reference field exists in the sample library, the matching result of the reference field is successful;
and if the sample name which is the same as the field name of the reference field does not exist in the sample library, the matching result of the reference field is matching failure.
9. An electronic device, comprising: a processor, a memory and a program stored on the memory and executable on the processor, the program, when executed by the processor, implementing the steps of the method of generating SQL statements according to any of claims 1 to 6.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the steps of the method of generating SQL statements according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310049201.XA CN115878659B (en) | 2023-02-01 | 2023-02-01 | Method, device and equipment for generating SQL (structured query language) sentences and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310049201.XA CN115878659B (en) | 2023-02-01 | 2023-02-01 | Method, device and equipment for generating SQL (structured query language) sentences and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115878659A true CN115878659A (en) | 2023-03-31 |
| CN115878659B CN115878659B (en) | 2023-06-02 |
Family
ID=85758560
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310049201.XA Active CN115878659B (en) | 2023-02-01 | 2023-02-01 | Method, device and equipment for generating SQL (structured query language) sentences and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115878659B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
| CN109947770A (en) * | 2018-08-14 | 2019-06-28 | 武汉斗鱼网络科技有限公司 | A kind of data base query method, terminal device and storage medium |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| US20220129448A1 (en) * | 2021-06-30 | 2022-04-28 | Beijing Baidu Netcom Science Technology Co., Ltd. | Intelligent dialogue method and apparatus, and storage medium |
| CN115576984A (en) * | 2022-09-13 | 2023-01-06 | 粤港澳国际供应链(广州)有限公司 | Method for generating SQL (structured query language) statement and cross-database query by Chinese natural language |
-
2023
- 2023-02-01 CN CN202310049201.XA patent/CN115878659B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
| CN109947770A (en) * | 2018-08-14 | 2019-06-28 | 武汉斗鱼网络科技有限公司 | A kind of data base query method, terminal device and storage medium |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| US20220129448A1 (en) * | 2021-06-30 | 2022-04-28 | Beijing Baidu Netcom Science Technology Co., Ltd. | Intelligent dialogue method and apparatus, and storage medium |
| CN115576984A (en) * | 2022-09-13 | 2023-01-06 | 粤港澳国际供应链(广州)有限公司 | Method for generating SQL (structured query language) statement and cross-database query by Chinese natural language |
Non-Patent Citations (1)
| Title |
|---|
| 钟雨杰: "自然语言生成SQL语句的研究与实现", 《中国优秀硕士学位论文全文数据库信息科技辑（月刊）》, no. 04 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115878659B (en) | 2023-06-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102597993B (en) | Managing application state information by means of uniform resource identifier (URI) | |
| CN110365724B (en) | Task processing method and device and electronic equipment | |
| CN114553784A (en) | Current limiting processing method and device | |
| US20100076937A1 (en) | Feed processing | |
| CN105630684A (en) | Software development kit identification method and device | |
| US20190179624A1 (en) | Software upgrade impact analysis by cognitive services | |
| CN115809288A (en) | Data conversion method, device, equipment and storage medium | |
| CN110674426B (en) | Webpage behavior reporting method and device | |
| WO2023151397A1 (en) | Application program deployment method and apparatus, device, and medium | |
| CN115878659B (en) | Method, device and equipment for generating SQL (structured query language) sentences and readable storage medium | |
| CN111488286B (en) | Method and device for independently developing Android modules | |
| CN112558950A (en) | System interface generation method and device | |
| CN111753548A (en) | Information acquisition method and device, computer storage medium and electronic equipment | |
| Habibi et al. | Generating test as a web service (TaaWS) through a method-based attribute grammar | |
| CN112199092A (en) | Application development method and device and electronic equipment | |
| CN111158654A (en) | Algorithm calling method, device, server and storage medium | |
| CN116974653B (en) | Class loading method and system | |
| CN113342646B (en) | Use case generation method, device, electronic equipment and medium | |
| CN117573130A (en) | Code processing method, device, electronic equipment and storage medium | |
| CN115309612A (en) | Method and device for monitoring data | |
| CN115098192A (en) | Page jump method and device, electronic equipment and storage medium | |
| CN110969007A (en) | Information analysis method, platform and computer readable storage medium | |
| CN113590483A (en) | Case operation method and device | |
| CN116450805A (en) | Text processing method, device, equipment and storage medium | |
| CN114116765A (en) | Mybatis framework SQL statement anomaly detection method, server and system |
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 |