CN102541521A - Automatic operating instruction generating device based on structured query language and method - Google Patents
Automatic operating instruction generating device based on structured query language and method Download PDFInfo
- Publication number
- CN102541521A CN102541521A CN2010105994566A CN201010599456A CN102541521A CN 102541521 A CN102541521 A CN 102541521A CN 2010105994566 A CN2010105994566 A CN 2010105994566A CN 201010599456 A CN201010599456 A CN 201010599456A CN 102541521 A CN102541521 A CN 102541521A
- Authority
- CN
- China
- Prior art keywords
- operational order
- configuration file
- sql
- structured query
- query sentence
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an automatic operating instruction generating device based on structured query language and a method. The automatic operating instruction generating device based on structured query language comprises a configuration file generating module, a configuration file analyzing module and an operating instruction generating module, wherein a configuration file consists of structured query language statements and parameters. The automatic operating instruction generating device based on the structured query language and the method are easy to be operated, generated instruction codes have high reusability, timeliness and accuracy can be guaranteed, and work efficiency and performance of a system can be improved.
Description
Technical field
The present invention relates to operational order generating apparatus and method, more specifically, relate to operational order automatically generating device and method based on SQL.
Background technology
At present, along with becoming increasingly abundant of the class of business of the growing and different field of information data processing demands, based on SQL (SQL) database is operated (for example increase, deletion, modification or inquiry etc.) dynamically and become more and more important.
Usually; The ultimate principle of existing method and the device that database is carried out dynamic operation based on SQL (SQL) is following: according to demand; By the related personnel artificially is each operation definition host variable; And write corresponding sqc instruction code (promptly embedding the SQL in the C programmer) based on said host variable, according to said sqc instruction code database is carried out required operation subsequently.
Yet, because along with the becoming increasingly abundant of class of business, said operation to database is also more and more frequent, thus and the mutual quantity phenomenal growth between the database.Therefore, there is following problem in above-mentioned existing technical scheme: thus the mode of using the manual compiling instruction code to be directed against the operation of database can not satisfy the requirement of system to real-time; Simultaneously, this mode is consuming time more, thereby maintenance cost raises, and because process is loaded down with trivial details and be easy to make mistakes, so reduced whole system operation efficient and performance; In addition, the reusability of the instruction code of manual compiling is relatively poor.
Therefore, there is following demand: a kind of easy operating is provided, can guarantees real-time and accuracy and can improves the operational order automatically generating device and the method based on SQL of system works efficient and performance.
Summary of the invention
In order to solve the existing defective of above-mentioned prior art scheme, the present invention proposes a kind of operational order automatically generating device and method based on SQL.
The objective of the invention is to realize through following technical scheme:
A kind of operational order automatically generating device based on SQL, said operational order automatically generating device based on SQL comprises:
Configuration file generation module, said configuration file generation module are used for generating and storing configuration file based on user's input;
Configuration file parsing module, said configuration file parsing module are used for setting up and being connected and resolving the said structured query sentence and the parameter of said configuration file according to pre-defined rule of database, and with predetermined format storing and resolving result;
Operational order generation module, said operational order generation module are used for automatically generating the operational order to said database according to said analysis result;
Wherein, said configuration file comprises structured query sentence and parameter.
In the disclosed in the above scheme, preferably, the operational order of confirming according to the title of said configuration file to generate deposit the path.
In the disclosed in the above scheme, preferably, the title of said configuration file comprises and is used to identify the mark to the operator scheme of database, and said operator scheme is vernier pattern, at least one in new model, preference pattern and the ordered mode more.
In the disclosed in the above scheme, preferably, said configuration file parsing module further comprises:
Resolution unit, said resolution unit is used to resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array;
Storage unit, said storage unit are used for utilizing input variable and the result set information stores of the said structured query sentence that the specific command of embedded sql will parse to global structure body array.
In the disclosed in the above scheme, preferably, the input variable of the said structured query sentence that said storage unit will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
In the disclosed in the above scheme, preferably, said operational order generation module further comprises:
The header file generation unit, said header file generation unit is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates header file based on said definite type;
The instruction generation unit, said instruction generation unit is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates instruction code based on said definite type.
In the disclosed in the above scheme, preferably, said instruction code is the sqc instruction code.
In the disclosed in the above scheme, preferably, said storage unit is utilized the DESCRIBE order of embedded sql and input parameter and the result set information that the SQLDA data structure is obtained structured query sentence.
In the disclosed in the above scheme, preferably, the said said instruction code that will generate based on the operational order automatically generating device of SQL is compiled into static state and/or kinematic function storehouse.
In the disclosed in the above scheme, preferably, according to demand, to the input variable assignment of the function in the said function library, to obtain the execution result under the different condition.
The object of the invention is also realized through following technical scheme:
A kind of operational order based on SQL generates method automatically, and said operational order generation method automatically based on SQL comprises the steps:
(A1) generate and store configuration file based on user's input, said configuration file comprises structured query sentence and parameter;
(A2) set up and being connected and resolving said structured query sentence and parameter in the said configuration file of database according to pre-defined rule, and with predetermined format storing and resolving result;
(A3) automatically generate operational order according to said analysis result to said database.
In the disclosed in the above scheme, preferably, the operational order of confirming according to the title of said configuration file to generate deposit the path.
In the disclosed in the above scheme, preferably, the title of said configuration file comprises and is used to identify the mark to the operator scheme of database, and said operator scheme is vernier pattern, at least one in new model, preference pattern and the ordered mode more.
In the disclosed in the above scheme, preferably, said step (A2) further comprises:
(B1) resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array;
(B2) input variable and the result set information stores of utilizing the said structured query sentence that the specific command of embedded sql will parse are in global structure body array.
In the disclosed in the above scheme, preferably, said step (A2) further comprises: the input variable of the said structured query sentence that (B3) will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
In the disclosed in the above scheme, preferably, said step (A3) further comprises:
(C1) confirm the type of said structured query sentence according to the title of said configuration file, and generate header file based on said definite type;
(C2) confirm the type of said structured query sentence according to the title of said configuration file, and generate instruction code based on said definite type.
In the disclosed in the above scheme, preferably, said instruction code is the sqc instruction code.
In the disclosed scheme, preferably, in said step (B2), utilize the DESCRIBE order of embedded sql and input parameter and the result set information that the SQLDA data structure is obtained said structured query sentence in the above.
In the disclosed scheme, preferably, the said instruction code that generates is compiled into static state and/or kinematic function storehouse in the above.
In the disclosed in the above scheme, preferably, according to demand, to the input variable assignment of the function in the said function library, to obtain the execution result under the different condition.
Disclosed operational order automatically generating device and the method based on SQL of the present invention has following advantage: easy operating; Real-time and accuracy can be guaranteed and system works efficient and performance can be improved; The instruction code that generates has very high reusability.
Description of drawings
In conjunction with accompanying drawing, technical characterictic of the present invention and advantage will be understood by those skilled in the art better, wherein:
Fig. 1 is according to an embodiment of the invention based on the structural drawing of the operational order automatically generating device of SQL;
Fig. 2 is for generate the process flow diagram of method according to an embodiment of the invention automatically based on the operational order of SQL;
Embodiment
Fig. 1 is according to an embodiment of the invention based on the structural drawing of the operational order automatically generating device of SQL.As shown in Figure 1, exemplarily, the disclosed operational order automatically generating device 1 based on SQL of the present invention is used for automatically generating the operational order to database according to configuration file.As shown in Figure 1, said operational order automatically generating device 1 comprises configuration file generation module 2, configuration file parsing module 3 and operational order generation module 4.Wherein, said configuration file generation module 2 is used for generating and storing configuration file based on user's input, and said configuration file comprises structured query sentence (SQL) and parameter (exemplarily, said configuration file comprises a SQL statement and some input parameters).Said configuration file parsing module 3 is used for setting up and being connected and resolving the said structured query sentence and the parameter of said configuration file according to pre-defined rule of database, and with predetermined format storing and resolving result.Said operational order generation module 4 is used for automatically generating the operational order to database according to said analysis result.
Preferably, in the disclosed operational order automatically generating device of the present invention based on SQL, the operational order of confirming according to the title of said configuration file to generate deposit the path.Wherein, Exemplarily; The title of said configuration file comprises the sign that is used to discern the affiliated storehouse of configuration file; Be used to indicate the sign of depositing the path of the operational order of generation, be used for identifying said configuration file sign of the mode of operation of database (being that it has confirmed said operational order automatically generating device will according to which kind of pattern generating code) and the custom field that is used for the reservation of function expansion.Wherein, Exemplarily; Said operational order automatically generating device 1 can be with following four kinds of pattern generating codes: vernier pattern (being the DECLARE-OPEN-CLOSE mode), more new model (is the EXEXUTZ...USING... mode; Expression is to the renewal of database, insertion, deletion etc.), preference pattern (is the SELECT...INTO...USING... mode; Expression is to the wall scroll read operation of database) and ordered mode (be VALUES NEXTVAL FOR...INTO... mode, expression is to the read operation from increasing sequence of database).
As shown in Figure 1, in the disclosed operational order automatically generating device based on SQL of the present invention, exemplarily, said configuration file parsing module 3 further comprises resolution unit 5 and storage unit 6.Wherein, said resolution unit 5 is used to resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array.Said storage unit 6 is used for utilizing input variable and the result set information stores of the said structured query sentence that the specific command (for example DESCRIBE order) of damascene structures query statement will parse to global structure body array.Preferably, the input variable of the said storage unit 6 said structured query sentence that will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
As shown in Figure 1, in the disclosed operational order automatically generating device based on SQL of the present invention, exemplarily, said operational order generation module 4 further comprises header file generation unit 7 and instruction generation unit 8.Wherein, said header file generation unit 7 is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates header file based on said definite type.Said instruction generation unit 8 is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates instruction code based on said definite type.Preferably, said instruction code is the sqc instruction code.
As shown in Figure 1; Exemplarily; Said parameter in the said configuration file can use symbol "? " Mark, and can be following closely with two " # " symbols comprise this parameter another name (for example: select*from tb1_test where colum1=? #AGE#).
As shown in Figure 1, exemplarily, in the disclosed operational order automatically generating device based on SQL of the present invention, the basic functional principle of said resolution unit 5 is following: (1) is that separator is cut apart to said structured query sentence with " # "; (2) " # " part taking-up is before continued to cut apart remaining part then; (3) if inseparable, then resolving finishes; (4), then " # " variable parameter name is afterwards taken out and continue to cut apart remaining part if can divide; (5) if inseparable, represent that then the variable parameter separator does not match, and withdraws from thereby report an error; (6), then return step (2) if can divide.
As shown in Figure 1; Exemplarily; In the disclosed operational order automatically generating device of the present invention based on SQL; Said storage unit 6 is utilized the DESCRIBE order of Embedded SQL and input parameter and the result set information that SQLDA (SQL Descriptor Area) data structure is obtained structured query sentence; Wherein, said SQLDA data structure comprises information header and structure of arrays, and each element in the said structure of arrays has been described a host variable or the concentrated row of result data.By on can know, through said structured query sentence being used said DESCRIBE order, can the input variable and the result set information of said structured query sentence be written among the said SQLDA.The basic functional principle of said storage unit 6 is following: carry out initialization procedure, be said SQLDA structure storage allocation (supposing to have only a data elements in the said SQLDA structure); Judge whether the parameter value that imports into is 0,, then utilize DESCRIBE INPUT order that the input variable information that said structured query sentence needs is write in the said SQLDA structure if be 0; If be not 0, the result set information of then utilizing DESCRIBE OUTPUT order that said structured query sentence is returned writes in the said SQLDA structure; Read data element in the said SQLDA structure to obtain actual input variable or result set number; Judge whether to create the clauses and subclauses of 2 particular variables types (for example sqlvar type) for every row; If then be said SQLDA structure storage allocation space (for example, include 2* (sqld+1) data elements, wherein sqld is actual input variable or result set number) again; If not, then be said SQLDA structure storage allocation space (for example, include (sqld+1) data elements, wherein sqld is actual input variable or result set number) again; Judge once more whether the parameter value that imports into is 0; If be 0, then utilize DESCRIBE INPUT order that the input variable information that said structured query sentence needs is write in the said SQLDA structure; If be not 0, the result set information of then utilizing the DESCRIBEOUTPUT order that said structured query sentence is returned writes in the said SQLDA structure; Order reads the data element in the said SQLDA structure, thereby input variable or result set information are write in the global structure body array.
As shown in Figure 1, exemplarily, in the disclosed operational order automatically generating device based on SQL of the present invention, the basic functional principle of said header file generation unit 7 is following: the beginning note of spanned file; Data according to the said global structure body array of input variable that is used for the structured query statement and result set information generate the structure definition in the header file; Generate the function declaration in the header file according to the information in the title of configuration file.
As shown in Figure 1, exemplarily, in the disclosed operational order automatically generating device based on SQL of the present invention, the basic functional principle of said instruction generation unit 8 is following: the beginning note of spanned file; Generate header file according to the information in the title of said configuration file, header file name and comprise statement and function declaration statement; Generate the definition of host variable according to the data of the said global structure body array of input variable that is used for the structured query statement and result set information; Form with dynamic or static structure query statement generates the database manipulation function.
As shown in Figure 1, exemplarily, the sqc code that is generated by said operational order automatically generating device 1 can be compiled into function library (static library or dynamic base), calls for netscape messaging server Netscape.
As shown in Figure 1, preferably, the user can be according to demand in the input variable assignment to the sqc function in the said function library, to obtain the execution result under the different condition.
By on can know be single operation because said sqc function realizes to database, the code that is therefore generated by said operational order automatically generating device 1 has very high reusability.
Fig. 2 is the process flow diagram that generates method according to an embodiment of the invention based on the operational order of SQL automatically.As shown in Figure 2; The disclosed operational order generation method automatically based on SQL of the present invention comprises the steps: that (A1) generates and stores configuration file based on user's input; Said configuration file comprises structured query sentence (SQL) and parameter (exemplarily, said configuration file comprises a SQL statement and some input parameters); (A2) set up and being connected and resolving said structured query sentence and parameter in the said configuration file of database according to pre-defined rule, and with predetermined format storing and resolving result; (A3) automatically generate operational order according to said analysis result to said database.
Preferably, in the disclosed operational order generation method automatically of the present invention based on SQL, the operational order of confirming according to the title of said configuration file to generate deposit the path.Wherein, Exemplarily; The title of said configuration file comprises the sign that is used to discern the affiliated storehouse of configuration file; Be used to indicate the sign of depositing the path of the operational order of generation, be used for identifying said configuration file sign of the mode of operation of database (being that it has confirmed said operational order automatically generating device will according to which kind of pattern generating code) and the custom field that is used for the reservation of function expansion.Wherein, Exemplarily; Said operational order generates method automatically can be with following four kinds of pattern generating codes: vernier pattern (being the DECLARE-OPEN-CLOSE mode), more new model (is the EXEXUTZ...USING... mode; Expression is to the renewal of database, insertion, deletion etc.), preference pattern (is the SELECT...INTO...USING... mode; Expression is to the wall scroll read operation of database) and ordered mode (be VALUES NEXTVAL FOR...INTO... mode, expression is to the read operation from increasing sequence of database).
Preferably; In the disclosed operational order generation method automatically of the present invention based on SQL; Said step (A2) further comprises: (B1) resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array; (B2) input variable and the result set information stores of utilizing the said structured query sentence that the specific command (for example DESCRIBE order) of damascene structures query statement will parse are in global structure body array.Preferably, said step (A2) further comprises: the input variable of the said structured query sentence that (B3) will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
Preferably; In the disclosed operational order generation method automatically of the present invention based on SQL; Said step (A3) further comprises: (C1) confirm the type of said structured query sentence according to the title of said configuration file, and generate header file based on said definite type; (C2) confirm the type of said structured query sentence according to the title of said configuration file, and generate instruction code based on said definite type.
Preferably, said instruction code is the sqc instruction code.
Exemplarily; In the disclosed operational order generation method automatically of the present invention based on SQL; Said parameter in the said configuration file can use symbol "? " Mark, and can be following closely with two " # " symbols comprise this parameter another name (for example: select*fromtb1_test where colum1=? #AGE#).
Exemplarily, in the disclosed operational order generation method automatically based on SQL of the present invention, said step (B1) further comprises: (1) is that separator is cut apart to said structured query sentence with " # "; (2) " # " part taking-up is before continued to cut apart remaining part then; (3) if inseparable, then resolving finishes; (4), then " # " variable parameter name is afterwards taken out and continue to cut apart remaining part if can divide; (5) if inseparable, represent that then the variable parameter separator does not match, and withdraws from thereby report an error; (6), then return step (2) if can divide.
Exemplarily; In the disclosed operational order generation method automatically of the present invention based on SQL; In said step (B2), utilize the DESCRIBE order of Embedded SQL and input parameter and the result set information that SQLDA (SQL Descriptor Area) data structure is obtained structured query sentence, wherein; Said SQLDA data structure comprises information header and structure of arrays, and each element in the said structure of arrays has been described a host variable or the concentrated row of result data.By on can know, through said structured query sentence being used said DESCRIBE order, can the input variable and the result set information of said structured query sentence be written among the said SQLDA.Said step (B2) further comprises: accomplish initialization procedure, be said SQLDA structure storage allocation (supposing to have only a data elements in the said SQLDA structure); Judge whether the parameter value that imports into is 0,, then utilize DESCRIBE INPUT order that the input variable information that said structured query sentence needs is write in the said SQLDA structure if be 0; If be not 0, the result set information of then utilizing DESCRIBE OUTPUT order that said structured query sentence is returned writes in the said SQLDA structure; Read data element in the said SQLDA structure to obtain actual input variable or result set number; Judge whether to create the clauses and subclauses of 2 particular variables types (for example sqlvar type) for every row; If then be said SQLDA structure storage allocation space (for example, include 2* (sqld+1) data elements, wherein sqld is actual input variable or result set number) again; If not, then be said SQLDA structure storage allocation space (for example, include (sqld+1) data elements, wherein sqld is actual input variable or result set number) again; Judge once more whether the parameter value that imports into is 0; If be 0, then utilize DESCRIBE INPUT order that the input variable information that said structured query sentence needs is write in the said SQLDA structure; If be not 0, the result set information of then utilizing the DESCRIBEOUTPUT order that said structured query sentence is returned writes in the said SQLDA structure; Order reads the data element in the said SQLDA structure, thereby input variable or result set information are write in the global structure body array.
Exemplarily, in the disclosed operational order generation method automatically based on SQL of the present invention, said step (C1) further comprises: the beginning note of spanned file; Data according to the said global structure body array of input variable that is used for the structured query statement and result set information generate the structure definition in the header file; Generate the function declaration in the header file according to the information in the title of configuration file.
Exemplarily, in the disclosed operational order generation method automatically based on SQL of the present invention, said step (C2) further comprises: the beginning note of spanned file; Generate header file according to the information in the title of said configuration file, header file name and comprise statement and function declaration statement; Generate the definition of host variable according to the data of the said global structure body array of input variable that is used for the structured query statement and result set information; Form with dynamic or static structure query statement generates the database manipulation function.
Exemplarily, in the disclosed operational order generation method automatically based on SQL of the present invention, the sqc code of generation can be compiled into function library (static library or dynamic base), calls for netscape messaging server Netscape.
Preferably, in the disclosed operational order generation method automatically based on SQL of the present invention, the user can be according to demand in the input variable assignment to the sqc function in the said function library, to obtain the execution result under the different condition.
Although the present invention describes through above-mentioned preferred implementation, its way of realization is not limited to above-mentioned embodiment.Should be realized that: under the situation that does not break away from purport of the present invention and scope, those skilled in the art can make different variations and modification to the present invention.
Claims (20)
1. operational order automatically generating device based on SQL, said operational order automatically generating device based on SQL comprises:
Configuration file generation module, said configuration file generation module are used for generating and storing configuration file based on user's input;
Configuration file parsing module, said configuration file parsing module are used for setting up and being connected and resolving the said structured query sentence and the parameter of said configuration file according to pre-defined rule of database, and with predetermined format storing and resolving result;
Operational order generation module, said operational order generation module are used for automatically generating the operational order to said database according to said analysis result;
Wherein, said configuration file comprises structured query sentence and parameter.
2. the operational order automatically generating device based on SQL according to claim 1 is characterized in that, the operational order of confirming according to the title of said configuration file to generate deposit the path.
3. the operational order automatically generating device based on SQL according to claim 2; It is characterized in that; The title of said configuration file comprises and is used to identify the mark to the operator scheme of database, and said operator scheme is vernier pattern, at least one in new model, preference pattern and the ordered mode more.
4. the operational order automatically generating device based on SQL according to claim 3 is characterized in that, said configuration file parsing module further comprises:
Resolution unit, said resolution unit is used to resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array;
Storage unit, said storage unit are used for utilizing input variable and the result set information stores of the said structured query sentence that the specific command of embedded sql will parse to global structure body array.
5. the operational order automatically generating device based on SQL according to claim 4; It is characterized in that the input variable of the said structured query sentence that said storage unit will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
6. the operational order automatically generating device based on SQL according to claim 5 is characterized in that, said operational order generation module further comprises:
The header file generation unit, said header file generation unit is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates header file based on said definite type;
The instruction generation unit, said instruction generation unit is used for confirming according to the title of said configuration file the type of said structured query sentence, and generates instruction code based on said definite type.
7. the operational order automatically generating device based on SQL according to claim 6 is characterized in that said instruction code is the sqc instruction code.
8. the operational order automatically generating device based on SQL according to claim 7; It is characterized in that said storage unit is utilized the DESCRIBE order of embedded sql and input parameter and the result set information that the SQLDA data structure is obtained structured query sentence.
9. the operational order automatically generating device based on SQL according to claim 8; It is characterized in that the said said instruction code that will generate based on the operational order automatically generating device of SQL is compiled into static state and/or kinematic function storehouse.
10. the operational order automatically generating device based on SQL according to claim 9 is characterized in that, according to demand, to the input variable assignment of the function in the said function library, to obtain the execution result under the different condition.
11. the operational order based on SQL generates method automatically, said operational order generation method automatically based on SQL comprises the steps:
(A1) generate and store configuration file based on user's input, said configuration file comprises structured query sentence and parameter;
(A2) set up and being connected and resolving said structured query sentence and parameter in the said configuration file of database according to pre-defined rule, and with predetermined format storing and resolving result;
(A3) automatically generate operational order according to said analysis result to said database.
12. the operational order based on SQL according to claim 11 generates method automatically, it is characterized in that, the operational order of confirming according to the title of said configuration file to generate deposit the path.
13. the operational order based on SQL according to claim 12 generates method automatically; It is characterized in that; The title of said configuration file comprises and is used to identify the mark to the operator scheme of database, and said operator scheme is vernier pattern, at least one in new model, preference pattern and the ordered mode more.
14. the operational order based on SQL according to claim 13 generates method automatically, it is characterized in that, said step (A2) further comprises:
(B1) resolve the content of said configuration file, and said structured query sentence in the said configuration file and parameter are deposited in respectively in global character pointer and the global character array;
(B2) input variable and the result set information stores of utilizing the said structured query sentence that the specific command of embedded sql will parse are in global structure body array.
15. the operational order based on SQL according to claim 14 generates method automatically; It is characterized in that said step (A2) further comprises: the input variable of the said structured query sentence that (B3) will parse and result set information stores back in the global structure body array is broken off and being connected of said database.
16. the operational order based on SQL according to claim 15 generates method automatically, it is characterized in that, said step (A3) further comprises:
(C1) confirm the type of said structured query sentence according to the title of said configuration file, and generate header file based on said definite type;
(C2) confirm the type of said structured query sentence according to the title of said configuration file, and generate instruction code based on said definite type.
17. the operational order based on SQL according to claim 16 generates method automatically, it is characterized in that, said instruction code is the sqc instruction code.
18. the operational order based on SQL according to claim 17 generates method automatically; It is characterized in that; In said step (B2), utilize the DESCRIBE order of embedded sql and input parameter and the result set information that the SQLDA data structure is obtained said structured query sentence.
19. the operational order based on SQL according to claim 18 generates method automatically, it is characterized in that, the said instruction code that generates is compiled into static state and/or kinematic function storehouse.
20. the operational order based on SQL according to claim 19 generates method automatically, it is characterized in that, according to demand, to the input variable assignment of the function in the said function library, to obtain the execution result under the different condition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010599456.6A CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010599456.6A CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102541521A true CN102541521A (en) | 2012-07-04 |
| CN102541521B CN102541521B (en) | 2015-03-25 |
Family
ID=46348500
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010599456.6A Active CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102541521B (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102479A (en) * | 2013-04-10 | 2014-10-15 | 北汽福田汽车股份有限公司 | Automatic generation method of OBD (On Board Diagnostic) variable definition source files |
| CN105573774A (en) * | 2014-11-05 | 2016-05-11 | ***股份有限公司 | Application parameter managing and configuring method |
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | ***股份有限公司 | The method and apparatus generating database manipulation code |
| CN106301891A (en) * | 2016-08-02 | 2017-01-04 | ***股份有限公司 | A kind of configuring information of network appliance processing method and processing device |
| CN106844772A (en) * | 2017-02-28 | 2017-06-13 | 东软集团股份有限公司 | The update method and device of application database |
| CN107133080A (en) * | 2017-06-14 | 2017-09-05 | 郑州云海信息技术有限公司 | The adding method and system of a kind of order line |
| CN107650123A (en) * | 2017-06-30 | 2018-02-02 | 哈尔滨工大特种机器人有限公司 | A kind of robotic programming method and apparatus of expansible instruction set |
| CN108182215A (en) * | 2017-12-22 | 2018-06-19 | 微梦创科网络科技（中国）有限公司 | A kind of method and device of structured query language SQL performance statistics |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN108694172A (en) * | 2017-04-05 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Information output method and device |
| CN109509467A (en) * | 2018-11-01 | 2019-03-22 | 北京车和家信息技术有限公司 | Code generating method and device |
| CN109542953A (en) * | 2018-11-29 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Data processing method and device based on presto |
| CN111367937A (en) * | 2020-02-28 | 2020-07-03 | 艾普阳科技（深圳）有限公司 | Data processing method and device |
| CN111897911A (en) * | 2020-06-11 | 2020-11-06 | 中国科学院计算机网络信息中心 | Unstructured data query method and system based on secondary attribute graph |
| CN112328624A (en) * | 2020-11-06 | 2021-02-05 | 瀚高基础软件股份有限公司 | SQL forwarding method and device and readable storage medium |
| CN112783921A (en) * | 2021-01-26 | 2021-05-11 | ***股份有限公司 | Database operation method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通***工程有限公司 | Method and system for converting query sentence of database |
-
2010
- 2010-12-17 CN CN201010599456.6A patent/CN102541521B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通***工程有限公司 | Method and system for converting query sentence of database |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
Non-Patent Citations (1)
| Title |
|---|
| FENG PENG,SUDARSHAN S.CHAWATHE: "Streaming XPath Queries in XSQ:A Demonstration", 《PROCEEDINGS OF THE 19TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING》 * |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102479A (en) * | 2013-04-10 | 2014-10-15 | 北汽福田汽车股份有限公司 | Automatic generation method of OBD (On Board Diagnostic) variable definition source files |
| CN104102479B (en) * | 2013-04-10 | 2017-09-15 | 北汽福田汽车股份有限公司 | A kind of automatic generation method of OBD variable-definitions source file |
| CN105573774A (en) * | 2014-11-05 | 2016-05-11 | ***股份有限公司 | Application parameter managing and configuring method |
| CN105573774B (en) * | 2014-11-05 | 2019-04-05 | ***股份有限公司 | Application Parameters management and configuration method |
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | ***股份有限公司 | The method and apparatus generating database manipulation code |
| CN106301891A (en) * | 2016-08-02 | 2017-01-04 | ***股份有限公司 | A kind of configuring information of network appliance processing method and processing device |
| CN106844772A (en) * | 2017-02-28 | 2017-06-13 | 东软集团股份有限公司 | The update method and device of application database |
| CN108694172A (en) * | 2017-04-05 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Information output method and device |
| CN108694172B (en) * | 2017-04-05 | 2021-12-31 | 北京京东尚科信息技术有限公司 | Information output method and device |
| CN107133080A (en) * | 2017-06-14 | 2017-09-05 | 郑州云海信息技术有限公司 | The adding method and system of a kind of order line |
| CN107650123A (en) * | 2017-06-30 | 2018-02-02 | 哈尔滨工大特种机器人有限公司 | A kind of robotic programming method and apparatus of expansible instruction set |
| CN108182215A (en) * | 2017-12-22 | 2018-06-19 | 微梦创科网络科技（中国）有限公司 | A kind of method and device of structured query language SQL performance statistics |
| CN108182215B (en) * | 2017-12-22 | 2021-10-12 | 微梦创科网络科技（中国）有限公司 | Structured Query Language (SQL) performance statistics method and device |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN109509467A (en) * | 2018-11-01 | 2019-03-22 | 北京车和家信息技术有限公司 | Code generating method and device |
| CN109509467B (en) * | 2018-11-01 | 2022-06-24 | 北京车和家信息技术有限公司 | Code generation method and device |
| CN109542953A (en) * | 2018-11-29 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Data processing method and device based on presto |
| CN111367937A (en) * | 2020-02-28 | 2020-07-03 | 艾普阳科技（深圳）有限公司 | Data processing method and device |
| CN111367937B (en) * | 2020-02-28 | 2023-09-19 | 艾普阳科技（深圳）有限公司 | Data processing method and device |
| CN111897911A (en) * | 2020-06-11 | 2020-11-06 | 中国科学院计算机网络信息中心 | Unstructured data query method and system based on secondary attribute graph |
| CN112328624A (en) * | 2020-11-06 | 2021-02-05 | 瀚高基础软件股份有限公司 | SQL forwarding method and device and readable storage medium |
| CN112783921A (en) * | 2021-01-26 | 2021-05-11 | ***股份有限公司 | Database operation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102541521B (en) | 2015-03-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541521B (en) | Automatic operating instruction generating device based on structured query language and method | |
| CN104133772A (en) | Automatic test data generation method | |
| US20070005805A1 (en) | System and method for managing and exchanging the data of a technical project, technical installation and individual installation components | |
| CN102118281B (en) | Method, device and network equipment for automatic testing | |
| CN104778124A (en) | Automatic testing method for software application | |
| CN103441900A (en) | Centralization cross-platform automated testing system and control method thereof | |
| CN111078702B (en) | SQL sentence classification management and unified query method and device | |
| CN108229799B (en) | Multi-source heterogeneous power grid operation real-time data access system and method | |
| CN103150165A (en) | Frame and method for building outdoor data acquisition program | |
| CN100511135C (en) | Unit test system and method thereof | |
| CN101866315A (en) | Test method and system of software development tool | |
| CN110737594A (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN106325965A (en) | Method and device for compiling of operating system | |
| US9535687B2 (en) | Audited builds based upon separate class dependency records | |
| CN103905231A (en) | Method and device for unified management of device types | |
| CN103338121A (en) | System management server and method, and system for server system management | |
| CN104391731A (en) | Editing method based on C# and irrelevant to data types | |
| CN103645888A (en) | System and method for automatically building operation system | |
| US20050144596A1 (en) | Method and apparatus for parallel action processing | |
| CN101593147A (en) | Abnormal information dump method based on symbol file | |
| CN104598382B (en) | A kind of test control method and device | |
| CN103942140A (en) | Automatic testing program conversion method | |
| CN111190814A (en) | Software test case generation method and device, storage medium and terminal | |
| CN103699478A (en) | Test case generation system and test case generation method | |
| CN113254054B (en) | Intelligent contract one-stop development system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |