CN107644097A - A kind of SLQ sentence generation methods - Google Patents
A kind of SLQ sentence generation methods Download PDFInfo
- Publication number
- CN107644097A CN107644097A CN201710905055.0A CN201710905055A CN107644097A CN 107644097 A CN107644097 A CN 107644097A CN 201710905055 A CN201710905055 A CN 201710905055A CN 107644097 A CN107644097 A CN 107644097A
- Authority
- CN
- China
- Prior art keywords
- slq
- flag bit
- input
- generation methods
- sentence generation
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 12
- 230000015572 biosynthetic process Effects 0.000 claims description 3
- 230000007257 malfunction Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of SLQ sentence generation methods, comprise the following steps：Object placement's model of user's input is read, the instruction of user's input is read, parses following information successively from object placement's model：Table name, type of foundation structure table, special SLQ fields handle flag bit, database upgrade processing flag bit.The present invention, the information of input can be automatically generated corresponding SQL statement according to instruction, improve written in code speed and efficiency, avoid the duplication of labour accumulate caused by mistake, SQL statement uniform format, the standard of generation, be easy to use in subsequent step.
Description
Technical field
The present invention relates to database technical field, specifically a kind of SLQ sentence generation methods.
Background technology
With the development of database technology, various demands continuously emerge, and constantly supervise further technological innovation, rise
Level.In program development, programmer runs into following situation sometimes：
When company goes to work, the sometimes work on daytime does not finish, and programmer will take work home overtime work at night and continue to do.But
It is that company is typically entity data bak with database for the supporting exploitation of program development, is deployed on development support server
, the development support server is a server inside corporate lan, and service end normal operation is dependent on exploitation branch
Hold the exploitation database on server.Due to being in, overtime work can not be accessed inside corporate lan, therefore cannot be connected
Exploitation database on upper development support server, this results in service end cisco unity malfunction, function during program development
It can not just debug.
In the prior art, a kind of solution method is exactly to use virtual data base.Just the use of company is journey when company goes to work
Sequence develops supporting exploitation database；Go back home, just use the virtual data base analog development database in internal memory, do one
A little basic function debuggings, are definitely generally enough.
Need largely to localize storage service in current app.In order to meet current business demand, we need in app
Data base tool is largely used, it is contemplated that allowing the convenient exploitation of programmer.
Entity data bak, which reads data, needs following steps：
1st, connected with Database,
2nd, SQL query statement is write,
3rd, query statement is performed,
4th, Query Result is obtained,
5th, database is closed.
Obviously, today of frequent reading/data storage is frequently interacted, needed with database in needs, accesses data
The workload in storehouse is very big, programmer it is cumbersome write SQL statement, not only workload is big, and easily causes to malfunction, it is necessary to
This further is reasonably optimized.
The content of the invention
, can it is an object of the invention to provide a kind of SLQ sentence generation methods for defect present in prior art
The information of input is automatically generated into corresponding SQL statement according to instruction, written in code speed and efficiency is improved, avoids the duplication of labour
Mistake caused by accumulation, SQL statement uniform format, the standard of generation, it is easy to use in subsequent step.
To achieve the above objectives, the present invention adopts the technical scheme that：
A kind of SLQ sentence generation methods, it is characterised in that comprise the following steps：
Object placement's model of user's input is read,
The instruction of user's input is read,
Parse following information successively from object placement's model：
Table name,
Type of foundation structure table,
Special SLQ fields handle flag bit,
Database upgrade handles flag bit.
On the basis of above-mentioned technical proposal, according to table name and type of foundation structure table, further basis of formation table knot
Structure.
On the basis of above-mentioned technical proposal, flag bit and data qurush are handled according to underlying table structure, special SLQ fields
Level processing flag bit, further forms stsndard SQL sentence.
SLQ sentence generation methods of the present invention, the information of input can be automatically generated corresponding SQL according to instruction
Sentence, improve written in code speed and efficiency, avoid the duplication of labour accumulate caused by mistake, the SQL statement uniform format of generation,
Standard, it is easy to use in subsequent step.
Brief description of the drawings
The present invention has drawings described below：
The FB(flow block) of Fig. 1 present invention.
Embodiment
The present invention is described in further detail below in conjunction with accompanying drawing.
As shown in figure 1, SLQ sentence generation methods of the present invention, comprise the following steps：
Object placement's model of user's input is read,
The instruction of user's input is read,
Parse following information successively from object placement's model：
Table name,
Type of foundation structure table,
Special SLQ fields handle flag bit,
Database upgrade handles flag bit.
On the basis of above-mentioned technical proposal, according to table name and type of foundation structure table, further basis of formation table knot
Structure.
On the basis of above-mentioned technical proposal, flag bit and data qurush are handled according to underlying table structure, special SLQ fields
Level processing flag bit, further forms stsndard SQL sentence.
The content not being described in detail in this specification belongs to prior art known to professional and technical personnel in the field.
Claims (3)
1. a kind of SLQ sentence generation methods, it is characterised in that comprise the following steps：
Object placement's model of user's input is read,
The instruction of user's input is read,
Parse following information successively from object placement's model：
Table name,
Type of foundation structure table,
Special SLQ fields handle flag bit,
Database upgrade handles flag bit.
2. SLQ sentence generation methods as claimed in claim 1, it is characterised in that：According to table name and type of foundation structure table,
Further basis of formation table structure.
3. SLQ sentence generation methods as claimed in claim 1, it is characterised in that：According to underlying table structure, special SLQ fields
Flag bit and database upgrade processing flag bit are handled, further forms stsndard SQL sentence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710905055.0A CN107644097A (en) | 2017-09-29 | 2017-09-29 | A kind of SLQ sentence generation methods |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710905055.0A CN107644097A (en) | 2017-09-29 | 2017-09-29 | A kind of SLQ sentence generation methods |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107644097A true CN107644097A (en) | 2018-01-30 |
Family
ID=61122935
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710905055.0A Pending CN107644097A (en) | 2017-09-29 | 2017-09-29 | A kind of SLQ sentence generation methods |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107644097A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102402624A (en) * | 2011-12-28 | 2012-04-04 | 用友软件股份有限公司 | Dynamic query system and method for version link data |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN104899205A (en) * | 2014-03-05 | 2015-09-09 | 张航 | Dynamic searching framework based on star-shaped structure business model |
| CN106294776A (en) * | 2016-08-12 | 2017-01-04 | 北京东方车云信息技术有限公司 | A kind of data processing method and device |
-
2017
- 2017-09-29 CN CN201710905055.0A patent/CN107644097A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102402624A (en) * | 2011-12-28 | 2012-04-04 | 用友软件股份有限公司 | Dynamic query system and method for version link data |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN104899205A (en) * | 2014-03-05 | 2015-09-09 | 张航 | Dynamic searching framework based on star-shaped structure business model |
| CN106294776A (en) * | 2016-08-12 | 2017-01-04 | 北京东方车云信息技术有限公司 | A kind of data processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109948134B (en) | Report automatic generation method, system, electronic equipment and storage medium | |
| CN101958987B (en) | Method and system for dynamically converting telecommunications service data | |
| CN104750472B (en) | The resource package management method and device of a kind of terminal applies | |
| CN103902653A (en) | Method and device for creating data warehouse table blood relationship graph | |
| CN103019726A (en) | Management method and device of software system service rules | |
| CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
| CN101859303A (en) | Metadata management method and management system | |
| CN111125440B (en) | Monad-based persistent layer composite condition query method and storage medium | |
| CN106844369B (en) | Objectification SQL sentence construction method and apparatus | |
| CN108280056A (en) | A kind of Excel file analytic method | |
| CN107562955A (en) | A kind of rapid generation of SQL statement | |
| CN107273486A (en) | Map updating method and device | |
| CN103064661A (en) | Computer monitoring configuration screen extensible makeup language (XML) descriptor system and method | |
| CN106776779B (en) | Method for generating entity file by JSON data based on Mac platform | |
| CN102171696B (en) | The generation method and apparatus of customization data | |
| CN107577812A (en) | A kind of method for quickly reading of entity data bak | |
| CN102609364A (en) | Cache exchange method | |
| CN107644097A (en) | A kind of SLQ sentence generation methods | |
| CN104462588A (en) | Intellectual property retrieval system based on cloud database | |
| CN105847329A (en) | Stock data server based management device and method | |
| CN107643926A (en) | A kind of object type turns database type method | |
| WO2022223038A1 (en) | Key name generation method and device, and computer readable storage medium | |
| CN107609181A (en) | A kind of update data of database optimized algorithm | |
| CN105607957B (en) | A kind of data acquisition analysis system based on OPC DA | |
| CN107577816A (en) | A kind of method of entity data bak read-write |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180130 |
|
| RJ01 | Rejection of invention patent application after publication |