CN103177008B - Method and system used for generating and executing structured query language (SQL) statement - Google Patents
Method and system used for generating and executing structured query language (SQL) statement Download PDFInfo
- Publication number
- CN103177008B CN103177008B CN201110434891.8A CN201110434891A CN103177008B CN 103177008 B CN103177008 B CN 103177008B CN 201110434891 A CN201110434891 A CN 201110434891A CN 103177008 B CN103177008 B CN 103177008B
- Authority
- CN
- China
- Prior art keywords
- sql
- xml
- sql statement
- database
- certain database
- 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.)
- Expired - Fee Related
Links
Abstract
The invention discloses a method and a system used for generating and executing a structured query language (SQL) statement. The method used for generating and executing the SQL statement is applied to an extensive makeup language (XML)_SQL analyzer. The XML_SQL analyzer is connected with at least two data bases in different types. The method used for generating and executing the SQL statement comprises the steps of receiving an XML_SQL statement input by a user, wherein the XML_SQL statement at least comprises an XML control label and the control label at least comprises at least one data base address, a data base type, a data base drive, and a data base language of a specific data base of the two data bases; judging whether the XML_SQL statement is correct or not; and generating the SQL statement which can be executed by the specific data base at least based on the control label when the XML_SQL statement is correct for being executed by the specific data base. According to the method used for generating and executing the SQL statement, the problem that the SQL statement cannot be adapted to a plurality of data bases in different types at the same time is solved.
Description
Technical field
The application is related to Computer Database field, more particularly to the method and system of a kind of generation and execution SQL statement.
Background technology
With informationalized quickening in recent years, the application of data base is more and more universal.In existing Database Systems, no
Support of the same data base to the sql language of standard is not quite similar, and different data bases often can be for some business
Requirement in purpose or performance, to the sql language of standard some extensions are done.
The applicant has found that prior art has following technical problem during the embodiment of the present application is realized：
First, when user is when a sql sentence has been write, it is difficult to ensure its integration across database.Such as, at the place to the time
In reason, oracle database and sqlserver data bases are just very different, especially, if there is an information in data base
Possess time record, it is being increased, change, during query script, the sql sentence difference that two types data place is used
Just become apparent from.
2nd, when needing the Query Result by data base to do the displaying of application level, the sql to standard is generally required
Sentence does the exploitation of personalization.Such as, Query Result is saved as into XML, by web services service caller is sent to.Or
Query Result is saved as word document, excel files, cvs files of microsoft office support etc..And the sql languages of standard
Sentence but not disclosure satisfy that the needs of its personalization exploitation.
It can be seen that, sql sentences of the prior art can not realize that integration across database is used, while personalization can not be suitable for
Development and application environment.
The content of the invention
In view of this, the application provide it is a kind of generate SQL statement method, to solve prior art in there is SQL languages
Sentence can not realize the problem that integration across database is used.
On the one hand, by one embodiment of the application, there is provided following technical scheme：
A kind of method for generating SQL statement, applies in XML_SQL resolvers, and the XML_SQL resolvers are with type not
At least two same data bases are connected, and methods described includes：
The XML_SQL sentences of receiving user's input, wherein the XML_SQL sentences at least include XML abstract factories, institute
State the database address that abstract factory at least includes a certain database at least two data base, class database
Type, database-driven and database language；
Judge whether the XML_SQL sentences are correct；
When the XML_SQL sentences are correct, at least based on the abstract factory, holding for the certain database is generated
Row SQL statement, for certain database execution.
Optionally, after the executable SQL statement of the generation certain database, methods described also includes：
Receive the implementing result that the certain database performs the executable SQL statement and obtains.
Optionally, the XML_SQL sentences also include：As a result label, passes through to perform for describing the certain database
The executable SQL statement and the document format of implementing result that obtains.
Optionally, the storing path of the implementing result is also included in the result label, the storing path is：Institute
State certain database local path or remote path.
Optionally, it is described to receive the implementing result that the certain database performs the executable SQL statement and obtains, tool
Body is：
Receive the text preserved with the document format that the certain database performs the executable SQL statement and obtains
Part.
Optionally, it is described receive that the certain database performs the executable SQL statement and obtain with the text
After the file that shelves form is preserved, methods described also includes：
The file is sent to into the storing path.
Optionally, the XML_SQL sentences also include：UI labels, for describing the XML_SQL resolvers and the spy
Determine the user operation between data base.
Optionally, the UI labels have a value attribute.
On the other hand, following technical scheme is provided by another embodiment of the application：
A kind of method for performing SQL statement, methods described applied in a certain database, the certain database be to
A data base in few two data bases, wherein, at least two data base is connected with an XML_SQL resolvers, described
At least two data bases are different types of data base, and methods described includes：
Receive the SQL statement corresponding with the certain database that the XML_SQL resolvers are generated；
The SQL statement is performed, implementing result is obtained.
Optionally, the SQL statement is based on the XML_SQL sentences of user input by the XML_SQL resolvers and is generated.
Optionally, the XML_SQL sentences include：As a result label, passes through to perform institute for describing the certain database
The document format of the implementing result stated executable SQL statement and obtain.
Optionally, the SQL statement is performed described, after obtaining implementing result, methods described also includes：
The implementing result is saved as into the file of the document format；
The file is sent to into the XML_SQL resolvers.
On the other hand, the application also provides following technical scheme：
A kind of system for generating SQL statement, the system includes XML_SQL resolvers, the XML_SQL resolvers with
Different types of at least two data base is connected, and the system includes：
First receiver module, for the XML_SQL sentences of receiving user's input, wherein the XML_SQL sentences are at least wrapped
XML abstract factories are included, the abstract factory at least includes a certain database at least two data base
Database address, type of database, database-driven and database language；
Judge module, it is whether correct for judging the XML_SQL sentences；
Generation module, for when the XML_SQL sentences are correct, at least based on the abstract factory, generates the spy
The executable SQL statement of data base is determined, for certain database execution.
Optionally, the system also includes：
Second receiver module, for after the executable SQL statement of the generation certain database, receiving described
The implementing result that certain database performs the executable SQL statement and obtains.
Another further aspect, present invention also provides following technical scheme：
A kind of system for performing SQL statement, applies in a certain database, and the certain database is at least two numbers
A data base according to storehouse, wherein, at least two data base is connected with an XML_SQL resolvers, and described at least two
Data base is different types of data base, and the system includes：
Receiver module, for receiving the SQL languages corresponding with the certain database that the XML_SQL resolvers are generated
Sentence；
Module is obtained, for performing the SQL statement, implementing result is obtained.
Optionally, the XML_SQL sentences include：As a result label, passes through to perform institute for describing the certain database
The document format of the implementing result stated executable SQL statement and obtain.
Optionally, the system also includes：
Preserving module, for performing the SQL statement described, after obtaining implementing result, the implementing result is protected
Save as the file of the document format；
Sending module, for the file to be sent to into the XML_SQL resolvers.
One or more technical schemes in above-mentioned technical proposal, have the following technical effect that or advantage：
First, by the method using the SQL statement generated in the application, prior art Plays SQL statement is solved not
The technical problem of the different data base of energy compatible type, it is achieved thereby that the operation of integration across database type.
2nd, it is further, the advantage in XML language is combined due to the SQL statement for generating so that the SQL statement of generation
Can adapt to, in some scenes that can require of having specific characteristics, extend the range of application of SQL statement.
Description of the drawings
Fig. 1 is the method flow diagram that SQL statement is generated in the embodiment of the present application；
Fig. 2 is the method flow diagram that SQL statement is performed in the embodiment of the present application；
Fig. 3 is the system module figure that SQL statement is generated in the embodiment of the present application；
Fig. 4 is the system module figure that SQL statement is performed in the embodiment of the present application.
Specific embodiment
With reference to each accompanying drawing to the embodiment of the present application technical scheme it is main realize principle, specific embodiment and its
Beneficial effect to reaching is explained in detail.
Fig. 1 is refer to, is the method flow diagram that SQL statement is generated in the embodiment of the present application；
Step 100, the XML_SQL sentences of receiving user's input；
In specific implementation process, the XML_SQL sentences at least include XML abstract factories, in the control mark
In label, the abstract factory at least includes the database address of a certain database in two data bases, class database
The information such as type, database-driven and database language, below with a specific abstract factory as an example, illustrate.
Abstract factory example one：
<Database url=" 192.168.18.1 " type=" oracle "
Driver=" oraclejdbc.driver.OracleDriver " language=" java "
Resultsize=" 1000 ">orcl</database>；
The address of data base is 192.168.18.1 in this label, and type of database is oracle, is driven to
Oracle.jdbc.driver.OracleDriver, and the language for adopting is then for java；
The XML_SQL sentences also include：As a result label, passes through to be held described in execution for describing the certain database
Row SQL statement and the document format of implementing result that obtains.Specifically, the label is an optional label, if right and wrong
The sentence such as query statement, such as deletion, insertion, renewal, it is possible to do not consider to use this label, the technical staff belonging to the application
Can arrange whether this quasi-sentence wants returning result information according to actual situation, such as delete how many information, insert
How many information etc..
The storing path of the implementing result is also included in the result label, the storing path is：It is described specific
Data base's local path or remote path.It is described to receive the certain database execution executable SQL statement and obtain
Implementing result, specially：
Receive the text preserved with the document format that the certain database performs the executable SQL statement and obtains
Part.
Protected with the document format what the reception certain database performed the executable SQL statement and obtained
After the file deposited, methods described also includes：The file is sent to into the storing path.
Below with regard to the concrete application mode of result label, illustrate.
As a result label example one：
Front 100 row of Query Result is preserved with word forms to d：Disk.
<Result savetype=" 0 " startRow=0endRow=100path=" d:\”
Type=" 0 " filename=' account_result ' filetype=' 0 '/>；
Especially, if Query Result is saved in into local disk, if not specifying the type for preserving, acquiescence will
Result set is saved in an XML file, if while path is not also specified, or attribute is sky, then can eject Path selection dialogue
Frame, points out the specific storing path of user input one or user to select the path of a presence.
As a result label example two：
By webservice (http://xxxx.xx.com/sevices/CSWsdl saveResult interfaces) are protected
Page five (per page of ten rows) of Query Result are deposited to remotely.It realizes that process is as follows：
<The pageSize=of result savetype=" 1 " pageNum=' 5 ' " 10 "
Webserviceurl=http://xxxx.xx.com/sevices/CSwsdl
WebserviceInterface=" saveResult "/>；
In addition, also include UI labels in the XML_SQL sentences, for describing the XML_SQL resolvers and the spy
Determine the user operation between data base.In addition, the UI labels also have a value attribute.
In specific implementation process, such label is used for describing carrying out the information that UI is interacted with user, actually used
When, can be these UI label dynamically generated operations interfaces, for example：Input one date, time, numeral, character string it is right
Words frame etc., in a word, UI labels are linked up primarily to entering Mobile state with user, acquisition information.
Below in the concrete application mode of UI labels, illustrate.
<Date format=" yyyy-mm-dd " description=" asking inputting date "><date>；
<Date format=" yyyy-MM-dd hh24:mm:Ss " description=" ask input time "><date
>；
<Double format=" #.00 " description=" please be input into digital (reservation two-decimal) "></
double>；
<Double format=" #. " description=" please be input into an integer "></double>；
<String size=" 10 " description=" please be input into a character string "></string>；
It can thus be seen that in each UI label, due to the difference of property value, having different display effects, such as
The difference of the value of the format attributes of date labels, can generate different time UI controls.The final response knot for producing UI controls
Fruit can replace original label, form executable sql like language；
In addition, not all UI labels can all produce dialog box to carry out being interacted with data base, all of UI marks
Sign once specify value attributes, then no longer pop-up dialogue box, but using the value of value attributes as finally handing over data base
Mutually it is used.For example, use as so following<date/>Label：
<Date value=" 1988-12-12 "><date>；
Will be 1988 in the executable SQL for ultimately forming due to being the fixed date, it is contemplated that the requirement of integration across database
On December 12, in.
So, whether final execution data base is that oracle or sqlserver or mysql can smoothly hold
OK.
Some other labels can also be included in the XML_SQL sentences
Step 110, judges whether the XML_SQL sentences are correct；
In specific implementation process, in mainly verifying the XML_SQL sentences, the label of XML whether grammaticalness
Regulation, such as processed abstract factory, confirms whether the database information added in sentence is correct, so as to real execution
When sql language, the connection of data base is obtained.UI labels are processed, it is ensured that user interacts, dynamically obtain number
According to.
Step 120, when the XML_SQL sentences are correct, at least based on the abstract factory, generates the particular data
The executable SQL statement in storehouse, for certain database execution.
In specific implementation process, according to the dynamic data of user input, resolver is by the XML part in XML_SQL
Value is replaced with real numerical value, forms real executable database SQL sentence, when SQL statement is generated, can
Be able to can be affected by result label analytic function, such as, as a result label specifies front 100 data of return, then generate actual
SQL statement have specific impact；
Meanwhile, according to the requirement of user in result label, the implementing result that data are returned is sent in a particular format
Specified location.Such as, d disks are sent to word forms, save as pdf files etc..
In the embodiment of the present application, existing UI labels can be extended, such as with<String>As a example by label, use
Family may think that the dialog box for ejecting is not attractive in appearance enough, and now, those skilled in the art can be by customizing a window again
To show dialog box；Also such as, some developers think that the UI windows for providing cannot meet the demand of business, for example, eject
One dialog box is to obtain the native place of user, and the dialog box is a common three-level combobox, and the first order selects to save, second
Level select city, the third level select district, then developer may newly-built one it is entitled<BirthPlace></
BirthPlace>UI application labels.And provide a UI window for this label.When concrete application, by this label<
BirthPlace></BirthPlace>Used in embedded XML_SQL language.
Equally, for some conventional result set preservation modes, such as：By result set save as a word document or
It is saved in remotely by WebService.These preservation modes still may be satisfied with without decree user, for example, user wishes
Result set is saved to a txt file and is broken into a zip compressed package.If it were to be so, developer just can be right
Referring herein to result set preserve label be extended, so as to reorganize to the data that data base returns, ultimately produce
The file of specified format.
Fig. 2 is refer to, is the method flow diagram that SQL statement is performed in the embodiment of the present application；
Step 200, receives the SQL statement corresponding with the certain database that the XML_SQL resolvers are generated；
In specific implementation process, the method for implementing to perform SQL statement is applied in a certain database, is stated specific
Data base is a data base at least two data bases, wherein, at least two data base and an XML_SQL resolvers
Connection, at least two data base is different types of data base；
The SQL statement is based on the XML_SQL sentences of user input by the XML_SQL resolvers and is generated.The SQL
Sentence includes abstract factory, result label, UI labels etc. label, wherein, the result label is used for describing described specific
The document format of the implementing result that data base is obtained by performing the executable SQL statement.
Step 210, performs the SQL statement, obtains implementing result.
In specific implementation process, according to the information in the label such as abstract factory in the SQL statement, perform corresponding
Content,
Also include after step 210, the implementing result is saved as into the file of the document format；Meanwhile, by institute
State file and be sent to the XML_SQL resolvers.
Just the process of the execution SQL statement is illustrated with a specific example below；
<Database url=" 192.168.18.1 " type=" oracle "
Driver=" oracle.jdbc.driver.OracleDriver " language=" java "
Resultsize=" 1000 ">orcl</database>；
Select acountid as ' account id ', customer name as ' account holder ' from user acount
where amount>,<Double format=" #. " description=" please be input into minimum account balance "></double>
and account_created<Date format=' yyyy-MM-dd ' description=' please be input into establishment
The minimum time ' of user></date>and customer_name like′<The description=' of String size=' 2 '
Please be input into a surname '>% '
<Result savetype=" 0 " startRow=0endRow=100
Path=" d:" type=" 0 " filename=' account_result '
Webservice=" " webserviceInterface=" ">；
After user input this XML_SQL sentence, XML_SQL language parsers can be sent to, resolver can be right first
This XML_SQL sentence does syntactic analysiss, confirms that grammaticalness specifies after (the mainly legitimacy of verifying XML label segment),
Resolver enters the substantial work stage：
The first step：Abstract factory is processed, confirms whether the information of data base additional in sentence is correct, so as to true
When just performing sql language, the connection of data base is obtained.
Second step：UI labels are processed, and user interacts, and so as to dynamic data, for example, upper predicate are obtained
Acquisition " minimum account balance " in sentence is exactly work in this stage.
3rd step：According to user input dynamic data, the XML part in XML_SQL is replaced with real value, shape
Into real executable database SQL sentence, " realizing integration across database characteristic " is exactly to work in this stage, is specified according to user
Data base it is different, the SQL statement of generation is not quite similar.
It should be noted that：The now generation of SQL statement is possible to the impact of the two-page separation function for being subject to result label,
For example, result label specifies front 100 data of return in this example, what the SQL statement actual for generation was then specified according to this
As a result label, returns front 100 data.
4th step：The SQL statement stage is performed, i.e., above-mentioned 3rd step is performed on real data base and is produced SQL statement.Than
Such as, if the SQL statement is query statement, query actions are performed, if cancel statement, then performs deletion action.
5th step：As a result the process of label, according to the requirement of user, the implementing result that data base is returned is with specific lattice
Formula is sent to specified location.
Fig. 3 is turned next to, is the system module figure that SQL statement is generated in the embodiment of the present application；
As illustrated, the system include XML_SQL resolvers, the XML_SQL resolvers with it is different types of extremely
Few two data bases are connected, and the system includes：
First receiver module, for the XML_SQL sentences of receiving user's input, wherein the XML_SQL sentences are at least wrapped
XML abstract factories are included, the abstract factory at least includes a certain database at least two data base
Database address, type of database, database-driven and database language；
Judge module, it is whether correct for judging the XML_SQL sentences；
Generation module, for when the XML_SQL sentences are correct, at least based on the abstract factory, generates the spy
The executable SQL statement of data base is determined, for certain database execution.
Second receiver module, for after the executable SQL statement of the generation certain database, receiving described
The implementing result that certain database performs the executable SQL statement and obtains.
Fig. 4 is turned next to, is the system module figure that SQL statement is generated in the embodiment of the present application；
As illustrated, the system is applied in a certain database, the certain database is at least two data bases
A data base, wherein, at least two data base is connected with an XML_SQL resolvers, at least two data base
For different types of data base, the system includes：
Receiver module, for receiving the SQL languages corresponding with the certain database that the XML_SQL resolvers are generated
Sentence；
Module is obtained, for performing the SQL statement, implementing result is obtained.
Preserving module, for performing the SQL statement described, after obtaining implementing result, the implementing result is protected
Save as the file of the document format；
Sending module, for the file to be sent to into the XML_SQL resolvers.
Because this device embodiment and preceding method embodiment are all based on the same invention of same inventive concept, in view of front
State the implementation process to embodiment of the method to be described in detail, for succinct, the device reality that here is omitted of description
Apply the specific implementation process of example.
By one or more embodiments of the application, it is possible to achieve following technique effect：
First, the method for the SQL statement by being generated using the application, solving prior art Plays SQL statement can not
The technical problem of the different data base of compatible type, it is achieved thereby that the operation of integration across database type.
2nd, it is further, the advantage in XML language is combined due to the SQL statement for generating so that the SQL statement of generation
Can adapt to, in some scenes that can require of having specific characteristics, extend the range of application of SQL statement.
Obviously, those skilled in the art can carry out the essence of various changes and modification without deviating from the application to the application
God and scope.So, if these modifications of the application and modification belong to the scope of the application claim and its equivalent technologies
Within, then the application is also intended to comprising these changes and modification.
Claims (12)
1. a kind of method for generating SQL statement, applies in XML_SQL resolvers, and the XML_SQL resolvers are different from type
At least two data bases be connected, it is characterised in that methods described includes：
The XML_SQL sentences of receiving user's input, wherein the XML_SQL sentences at least include XML abstract factories, the control
Label processed at least includes the database address of a certain database at least two data base, type of database,
Database-driven and database language, wherein, the XML_SQL sentences also include：UI labels, for describing the XML_SQL
User operation between resolver and the certain database, as a result label, passes through to perform institute for describing the certain database
The document format of the implementing result stated executable SQL statement and obtain；
Judge whether the XML_SQL sentences are correct；
When the XML_SQL sentences are correct, at least based on the abstract factory, the executable of the certain database is generated
SQL statement, for certain database execution.
2. the method for claim 1, it is characterised in that generate the executable SQL languages of the certain database described
After sentence, methods described also includes：
Receive the implementing result that the certain database performs the executable SQL statement and obtains.
3. the method for claim 1, it is characterised in that the guarantor of the implementing result is also included in the result label
Path is deposited, the storing path is：The certain database local path or remote path.
4. method as claimed in claim 3, it is characterised in that the reception certain database performs described executable
SQL statement and the implementing result that obtains, specially：
Receive the file preserved with the document format that the certain database performs the executable SQL statement and obtains.
5. method as claimed in claim 4, it is characterised in that it is described receive the certain database perform it is described executable
SQL statement and obtain with the document format preserve file after, methods described also includes：
The file is sent to into the storing path.
6. the method for claim 1, it is characterised in that the UI labels have a value attribute.
7. a kind of method for performing SQL statement, applies in a certain database, and the certain database is at least two data
A data base in storehouse, wherein, at least two data base is connected with an XML_SQL resolvers, at least two number
It is different types of data base according to storehouse, it is characterised in that methods described includes：
The SQL statement corresponding with the certain database that the XML_SQL resolvers are generated is received, the SQL statement is by institute
State XML_SQL resolvers to be based on the XML_SQL sentences of user input and generate, wherein, the XML_SQL sentences also include：UI
Label, for describing the user operation between the XML_SQL resolvers and the certain database, as a result label, for describing
The document format of the implementing result that the certain database is obtained by performing executable SQL statement；
The SQL statement is performed, implementing result is obtained.
8. method as claimed in claim 7, it is characterised in that perform the SQL statement described, obtain implementing result it
Afterwards, methods described also includes：
The implementing result is saved as into the file of the document format；
The file is sent to into the XML_SQL resolvers.
9. a kind of system for generating SQL statement, the system includes XML_SQL resolvers, the XML_SQL resolvers and class
At least two different data bases of type are connected, it is characterised in that the system includes：
First receiver module, for the XML_SQL sentences of receiving user's input, wherein the XML_SQL sentences are at least included
XML abstract factories, the abstract factory at least includes the data of a certain database at least two data base
Storehouse address, type of database, database-driven and database language, wherein, the XML_SQL sentences also include：UI labels, use
To describe the user operation between the XML_SQL resolvers and the certain database, as a result label, described specific for describing
The document format of the implementing result that data base is obtained by performing executable SQL statement；
Judge module, it is whether correct for judging the XML_SQL sentences；
Generation module, for when the XML_SQL sentences are correct, at least based on the abstract factory, generates the certain number
According to the executable SQL statement in storehouse, for certain database execution.
10. system as claimed in claim 9, it is characterised in that the system also includes：
Second receiver module, for after the executable SQL statement of the generation certain database, receiving described specific
The implementing result that data base performs the executable SQL statement and obtains.
A kind of 11. systems for performing SQL statement, apply in a certain database, and the certain database is at least two numbers
A data base according to storehouse, wherein, at least two data base is connected with an XML_SQL resolvers, and described at least two
Data base is different types of data base, it is characterised in that the system includes：
Receiver module, for receiving the SQL statement corresponding with the certain database that the XML_SQL resolvers are generated, institute
State SQL statement to be based on the XML_SQL sentences of user input by the XML_SQL resolvers and generated, wherein, the XML_SQL
Sentence also includes：UI labels, for describing the user operation between the XML_SQL resolvers and the certain database, as a result
Label, for describing the document format of the implementing result that the certain database is obtained by performing executable SQL statement；
Module is obtained, for performing the SQL statement, implementing result is obtained.
12. systems as claimed in claim 11, it is characterised in that the system also includes：
Preserving module, for performing the SQL statement described, after obtaining implementing result, the implementing result is saved as
The file of the document format；
Sending module, for the file to be sent to into the XML_SQL resolvers.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110434891.8A CN103177008B (en) | 2011-12-22 | 2011-12-22 | Method and system used for generating and executing structured query language (SQL) statement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110434891.8A CN103177008B (en) | 2011-12-22 | 2011-12-22 | Method and system used for generating and executing structured query language (SQL) statement |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103177008A CN103177008A (en) | 2013-06-26 |
| CN103177008B true CN103177008B (en) | 2017-04-19 |
Family
ID=48636889
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110434891.8A Expired - Fee Related CN103177008B (en) | 2011-12-22 | 2011-12-22 | Method and system used for generating and executing structured query language (SQL) statement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103177008B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077340B (en) * | 2013-07-18 | 2016-06-01 | 腾讯科技（深圳）有限公司 | The establishment method of a kind of database and server |
| CN105630475B (en) * | 2014-11-06 | 2018-12-21 | 阿里巴巴集团控股有限公司 | A kind of data label organization system and method for organizing |
| CN104536987B (en) * | 2014-12-08 | 2017-12-05 | 联动优势电子商务有限公司 | A kind of method and device for inquiring about data |
| CN106775770B (en) * | 2017-01-16 | 2020-08-11 | 兴唐通信科技有限公司 | Search method for constructing query statement based on class information |
| CN111382253B (en) * | 2020-03-02 | 2022-07-15 | 思必驰科技股份有限公司 | Semantic parsing method and semantic parser |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101290570A (en) * | 2007-04-17 | 2008-10-22 | 高丹 | Heterogeneous database data integration middleware in different language environment |
| CN102110099A (en) * | 2009-12-28 | 2011-06-29 | 五邑大学 | Heterogeneous database middleware access technique based on endowment insurance warning system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW201113731A (en) * | 2009-10-15 | 2011-04-16 | Inst Information Industry | Data query method, data query system and computer readable and writable recording medium |
-
2011
- 2011-12-22 CN CN201110434891.8A patent/CN103177008B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101290570A (en) * | 2007-04-17 | 2008-10-22 | 高丹 | Heterogeneous database data integration middleware in different language environment |
| CN102110099A (en) * | 2009-12-28 | 2011-06-29 | 五邑大学 | Heterogeneous database middleware access technique based on endowment insurance warning system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103177008A (en) | 2013-06-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9400784B2 (en) | Integrated application localization | |
| CN103177008B (en) | Method and system used for generating and executing structured query language (SQL) statement | |
| US9442744B2 (en) | Multilingual build integration for compiled applications | |
| CN102105862B (en) | Automatic user interface generation for entity interaction | |
| US20070294619A1 (en) | Generating media presentations | |
| CN105117234B (en) | A kind of web control combination method | |
| US8863083B2 (en) | Presenting user interfaces based on messages | |
| IL189152A (en) | Designating, setting and discovering parameters for spreadsheet documents | |
| US20080222572A1 (en) | Look and feel of a web services mashup designer | |
| WO2017078686A1 (en) | Translation of natural language into user interface actions | |
| CN107247544A (en) | Use interaction figure picture optimization software application user interface capabilities | |
| CN104247378A (en) | Providing rule based analysis of content to manage activation of web extension | |
| CN110347384A (en) | A method of Suresh Kumar pop-up is realized based on Object_C language classification | |
| US8122381B2 (en) | Context debugger | |
| US20120120436A1 (en) | Remote printing | |
| KR101797573B1 (en) | Web based spreadsheets service providing apparatus and method | |
| EP4058907A1 (en) | Modularizing and embedding supplemental textual and visual content in different environments | |
| EP3142025B1 (en) | Generating and distributing interactive documents | |
| US9741060B2 (en) | Recursive navigation in mobile CRM | |
| US20190392024A1 (en) | Digital Content Editing of a Document Object Model (DOM) | |
| CN106484488A (en) | Integrated cloud compilation method and system | |
| CN111061522B (en) | Method, device, equipment and storage medium for generating front-end card assembly based on back end | |
| CN101685395A (en) | Object property processing method of product data management system | |
| CN100401293C (en) | Web page based correlation inquiry and page object backfill method | |
| CN101980193B (en) | Method, device and system for modifying dynamic page |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170419 Termination date: 20191222 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |