CN106775770A - The lookup method of query statement is built based on category information - Google Patents
The lookup method of query statement is built based on category information Download PDFInfo
- Publication number
- CN106775770A CN106775770A CN201710032574.0A CN201710032574A CN106775770A CN 106775770 A CN106775770 A CN 106775770A CN 201710032574 A CN201710032574 A CN 201710032574A CN 106775770 A CN106775770 A CN 106775770A
- Authority
- CN
- China
- Prior art keywords
- information
- category information
- user
- entry
- attribute
- 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
- 238000000034 method Methods 0.000 title claims abstract description 26
- 230000002045 lasting effect Effects 0.000 claims abstract description 10
- 239000000284 extract Substances 0.000 claims abstract description 5
- 239000012634 fragment Substances 0.000 claims description 8
- 230000007246 mechanism Effects 0.000 claims description 8
- 230000011514 reflex Effects 0.000 claims description 8
- 230000005540 biological transmission Effects 0.000 claims description 3
- 230000018109 developmental process Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 241000406668 Loxodonta cyclotis Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000007493 shaping process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
- G06F8/24—Object-oriented
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of lookup method that query statement is built based on category information, comprise the following steps：Step S1. server ends extract java class information and its attribute information by scanning lasting classification file；The configuration file that reading pre-sets, obtains the configuration of each attribute acquiescence；According to java class information, attribute information and configuration information, category information data list file is automatically generated；Step S2. user sets service parameter by client, and dynamically adds Text Entry；The inquiry content of input and service parameter are sent to server end by user in the lump by Text Entry input inquiry content；Inquiry content and service parameter that step S3. received server-sides are input into by client, risk SQL statement automatically, and carry out corresponding database lookup operations according to the SQL statement being spliced into, and carry out feedback of the information to client.This method improves lookup speed, user can be helped to be rapidly completed operation, and simplify code.
Description
Technical field
The present invention relates to field of database query technology, more particularly to a kind of based on category information, (category information refers to and database
The corresponding java class of middle table, the row of table are the attribute of class) build the lookup method of query statement.
Background technology
Java language is widely applied in various software developments as a kind of more ripe programming language.Current
Software development in, mainly with B/S browser models develop, AJAX Local hydrodynamic units interaction aspect be application and development master
Stream, service end typically uses Hibernate, such as JDBCTEMPLATE, HIBERNATE, IBATIS.Typical application
Framework is JavaScript+Struts+Spring+Hibernate/Ibatis.Meanwhile, in software development, data access is
Essential, the use of SQL statement is the main method of database manipulation in database technology.
All it is mostly only to be introduced and innovate in terms of foreground or backstage are single in previous patent, it is comprehensive in the present invention
Front page layout querying condition dynamic addition, and background query sentence automatic Mosaic, make user using only shirtsleeve operation
Complicated inquiry operation can be completed.At present, the comprehensive dynamic class information query method solved from backstage to foreground is less, rarely has
It is related to dynamic construction query statement, is automatically performed and the technical scheme of the aspect such as prompting automatically, and lacks in terms of category information
Application.It is therefore desirable to provide a kind of querying method that query statement is built based on category information, Java object can be automatically generated
Category information data list file, realize the Real-time Feedback of information.
The content of the invention
In view of above-mentioned analysis, the present invention is intended to provide a kind of lookup method that query statement is built based on category information, is used
It is less to solve the problems, such as the dynamic class information query method in existing method from backstage to foreground.
The purpose of the present invention is mainly achieved through the following technical solutions：
A kind of lookup method that query statement is built based on category information is provided, is comprised the following steps：
Step S1. server ends extract java class information and its attribute information by scanning lasting classification file；Read pre-
The configuration file for first setting, obtains the configuration of each attribute acquiescence；According to java class information, attribute information and configuration information, automatically
Generation category information data list file；
Step S2. clients receive the service parameter of user input, and dynamically add text input according to the selection of user
Frame；Client receives the inquiry content that user is input into by Text Entry, and the inquiry content that will be input into is with service parameter in the lump
It is sent to server end；
Step S3. received server-sides select the inquiry content and service parameter of input by client, and automatic Mosaic goes out
SQL statement, carries out database lookup operations, and carry out feedback of the information to client according to the SQL statement being spliced into.
Wherein, step S1 realizes that automatically generating category information data list file includes following sub-step：
Create Velocity templates；
By scanning lasting classification file, java class information and its attribute information are automatically extracted；
The configuration file that reading pre-sets, obtains the configuration of attribute acquiescence；
Using the Velocity template generation SQL statements for creating, and SQL statement is utilized by the information and its attribute of java class
Information, configuration information write-in data list file, generate category information data list file；
Output class information data list file.
Preferably, after category information data list file is generated, by edit in category information data list file java class or
Its attribute information, configuration information, update category information data list file.
Preferably, in step S2, the key entry that Text Entry can followed by user shows corresponding matching entry.
The use Java reflex mechanisms, realize dynamic addition Text Entry, and the display in Text Entry
With entry, comprise the following steps that：
Client receives the service parameter that user is set；
Client dynamically adds Text Entry, and receive user by text according to user input in the interface of foreground
The entry of input frame input, server end is sent to by the entry and service parameter of reception in the lump；
Received server-side entry and service parameter, according to category information data list file and service parameter, automatically create
Query statement, then performs query statement, Query Result is obtained, as the matching entry of user input entry；
Query Result is built into Json character strings by server end again, and is sent to client；
Client parses character string and shows matching entry, for user's selection inquiry content.
The realization of step S3 includes following sub-step：
Service parameter and the inquiry content of user's selection that server reception client transmissions come；
According to category information data list file, inquiry content and the corresponding attribute information of service parameter and configuration information are obtained；
For each inquiry content, obtain corresponding SQL statement fragment and store；
The SQL statement fragment of each inquiry content that user is selected is merged into a stsndard SQL sentence and is stored；
Corresponding database lookup operations are carried out using the SQL statement after merging.
Preferably, it is described for each inquiry content, corresponding SQL statement fragment is obtained, specifically according to text box
The data type of correspondence attribute carries out corresponding treatment.
The present invention has the beneficial effect that：
Service end of the invention on startup by scan database table correspondence java class file automatically generate Java pairs
The category information tables of data of elephant；Text Entry is dynamically added in the foreground interface of client, input frame followed by user and key in and shows
Show matching entry；Finally, SQL statement is risked in program backstage automatically according to field type, and carries out phase according to the SQL statement risked
Corresponding database manipulation, completes information Real-time Feedback.
Other features and advantages of the present invention will be illustrated in the following description, also, the partial change from specification
Obtain it is clear that or being understood by implementing the present invention.The purpose of the present invention and other advantages can be by the explanations write
Specifically noted structure is realized and obtained in book, claims and accompanying drawing.
Brief description of the drawings
Accompanying drawing is only used for showing the purpose of specific embodiment, and is not considered as limitation of the present invention, in whole accompanying drawing
In, identical reference symbol represents identical part.
Fig. 1 is the flow chart of the category information data list file for automatically generating java class；
Fig. 2 is the dynamic addition of Text Entry and the flow chart of display matching entry；
Fig. 3 is the automatic Mosaic flow chart of SQL statement；
Fig. 4 is the part spooler schematic diagram of the automatic Mosaic for realizing SQL statement；
Fig. 5 is the schematic diagram of dynamic text input frame in the interface of client foreground.
Specific embodiment
The preferred embodiments of the present invention are specifically described below in conjunction with the accompanying drawings, wherein, accompanying drawing constitutes the application part, and
It is used to explain principle of the invention together with embodiments of the present invention.
A specific embodiment of the invention, discloses a kind of lookup method that query statement is built based on category information, institute
State category information and refer to the java class corresponding with table in database, the row of table are the attribute of class, specifically include following steps：
Step S1. server ends extract java class information in itself and its attribute information by scanning lasting classification file；
The configuration file that reading pre-sets, obtains the configuration of attribute acquiescence；According to java class information, attribute information and configuration information,
Automatically generate category information data list file.This part operation is completed in server.
This step further includes sub-step S11~S15, such as Fig. 1.
Step S11. creates Velocity templates.The Velocity templates are used to realize the generality abstract of SQL statement.Institute
Complete trails of the Velocity templates of establishment including java class, Property Name, attribute front-end interface display Name, attribute front end exist
Corresponding position, width rendering intent in front end page, whether show, whether sort, whether the letter such as editable, sequence sequence number
Breath.It allows anyone that the object defined by Java code is simply only quoted using template instruction.
Step S12. automatically extracts java class information and its attribute information, including Java by scanning lasting classification file
The title of each attribute variable in the title and information, and java class of class, attribute data type, the system-wide of the corresponding class of attribute
Footpath, attribute sequence number etc.；The configuration file that reading pre-sets, obtains the configuration of attribute acquiescence, for example, if can sort, can compile
Collect, can show.
The lasting classification file refers to be stored with application item source code, text information, the table of data attribute information
Lattice etc.；
The aerial table of the java class corresponding data；Java class information refers to the information of java class itself, such as java class
Title, storage location etc.；The attribute of java class is the row of table, and the attribute information of java class can refer to what a java class included
The information of attribute, that is, the title of the information for arranging, such as attribute variable, the data type of attribute variable, sequence number of attribute variable etc.
Information；
The configuration file refers to the default configuration of each attribute variable in the java class that user oriented is defined, for example, if
Can sort, editable, can show, can inquire about.
The Velocity template generation SQL statements that step S13. is created using step S11, and will using the SQL statement
The information and its attribute information of java class, configuration information are added to category information data list file, have so automatically generated category information
Data list file.
Generation SQL statement is for example：insert into tablecolumninfo value($CLASSFULLNAME,$
COLUMNENUMNAME,$COLUMNLENGTH,$COLUMNNAME,$COLUMNTYPE,$MINI_ALIGN,$MINI_
COLUMNTEXT)。
The corresponding category information data list file of step S14. output lasting classification files.
Step S15. edits the information of java class/attribute/configuration in category information data list file, and updates category information data
List file.Category information data list file is designed in the present invention editable, can (be by changing the default configuration of attribute just
No display, whether sort, whether editable, sequence sequence number) the final configuration information for meeting user's requirement of generation, and update to class
In information data list file, so as to have recorded the configuration for meeting user's request in category information data list file.
In step sl, category information, attribute information and configuration information have been automatically extracted, has been created automatically based on Velocity technologies
The SQL statement of insertion category information is built, category information, attribute information and configuration information (equivalent to a kind of metamessage) are write into category information
In data list file, and it is updated.So operation can be obtained quickly for the lasting classification file, the class based on user configuring
Information data list file, for describing java class and its attribute, and contains the configuration information of user.Such information data table text
Part is automatically created as follow-up development is provided convenience.
Step S2. clients receive the service parameter of user input, and dynamically add text input according to the selection of user
Frame；Client receives the inquiry content that user is input into by Text Entry, and the inquiry content that will be input into is with service parameter in the lump
It is sent to server end.
Preferably, Text Entry followed by the key entry of user and show corresponding matching entry.
Java reflex mechanisms are employed in embodiment, the dynamic addition of Text Entry and the display of matching entry is realized.
Java reflex mechanisms are in running status, for any one class, can to know all properties and method of this class；It is right
In any one object, the method for any one in class can be called.The information of this dynamic access and dynamic call
The function of object is referred to as the reflex mechanism of Java language.Reflex mechanism mainly provides following functions：Operationally judge any
Class belonging to one object；Operationally construct the object of any one class.Using reflex mechanism, development efficiency can be made more
High, system maintenance and migration deployment are simpler.
Preferably, using the AJAX (Asynchronous Javascript And XML) of JS (Javascript) script
Technology realize without refresh prompt facility, or using JQUERY library component realize be automatically performed without refreshing and prompt facility, this
The technology of kind easily adds being automatically performed and automatic prompting function for input frame in may assist in website.Searched when using WEB page
Suo Shi, entry is keyed in the Text Entry of WEB page, can key in display matching entry with user, so that the time is saved,
Here it is auto-complete function.In WEB page, be automatically performed and the prompt facility of Text Entry can help user quick
Operation is completed, is extraordinary user experience.When Information-based Item is done, for example, need to select people in Added Business
Member, now, if being input into " Lee " in Text Entry, combobox can automatically occurs, and display surname is the name of the people of " Lee ".If
Continue to be input into " text " in Text Entry, combobox can automatically occur, display name includes the name of the people of " Li Wen ".
Dynamic addition Text Entry, and the specific side that matching entry is shown in input frame are realized using reflex mechanism
Method is as follows, and flow chart is as shown in Figure 2.
S21. client receives the service parameter that user is set, and the table and needs of retrieval are needed when service parameter is inquiry
The row (attribute of java class object) of retrieval；
S22. client is according to user input, Text Entry is dynamically added in the interface of foreground, and receives user and pass through
The entry of Text Entry input, server end is sent to by the entry and service parameter of reception in the lump；
S23. received server-side entry and service parameter；
S24. server end automatically creates query statement according to category information data list file and service parameter；
S25. server end performs query statement, Query Result is obtained, as the matching entry of user input entry；
S26. Query Result is built into server end the Json character strings that can be parsed by client, and is sent to client
End；
S27. client parses character string and shows matching entry, for user's selection inquiry content.
The dynamic addition of above-mentioned input frame and the Auto-matching entry of Text Entry, can help user to quickly finish
Text box input operation.
The inquiry content and service parameter of step S3. received server-sides client selection input, automatic Mosaic go out SQL languages
Sentence, and corresponding database lookup operations are carried out according to the SQL statement being spliced into, and carry out feedback of the information to client.
Specifically, the automatic Mosaic of SQL statement is to carry out SQL to the inquiry content being input at least one Text Entry
Sentence treatment.Preferably, the information first against single Text Entry carries out SQL statement treatment, then recycles condition language
Sentence joins together them.
Preferably, for the information processing of single Text Entry, can be according to the data type of text box correspondence attribute
Carry out respective handling.For example in one Text Entry input is character string, the category of text input frame correspondence character string type
Property, the SQL statement that this attribute can be carried out by the way of " Like " this string matching is created；For shaping long
Data, the then SQL statement for carrying out this attribute using "=" whether numerical value manner of comparison is created.One example of program is as schemed
4。
By the automatic Mosaic of SQL statement, reduce because being manually entered character errors mistake caused by, while saving
The time of coding, reduce programing work personnel writes difficulty.
Step S3 specifically includes following sub-step, as shown in Figure 3：
S31. server reception client transmissions come service parameter and the inquiry content of user's selection；
S32. according to category information data list file, inquiry content and the corresponding attribute information of service parameter is obtained successively and is matched somebody with somebody
Confidence ceases；Such as data type, can inquire about；
S33. for each inquiry content, obtain corresponding SQL statement fragment and store；
The SQL statement fragment of each inquiry content that S34. user is selected is merged into a stsndard SQL sentence and is stored；
S35. corresponding database lookup operations are carried out using the SQL statement after merging.
In sum, a kind of method that query statement is built based on category information is the embodiment of the invention provides, is can be used for
WEB page is searched for.Service end of the invention can automatically generate category information data list file, and this document can describe the information of java class
And wherein attribute information and configuration information, equivalent to metamessage data list file, this tables of data this can be follow-up work number
It is investigated that ask, inquiry splicing provides facility, without all going to search attribute information and configuration information in corresponding java class each time, and
The information in java class and configuration are directly obtained according to category information data list file, therefore facilitates number between different queried for items
It is investigated that looking for, lookup speed is improve.Additionally, when the present invention dynamically adds Text Entry in the interface of java applet foreground,
Input frame can followed by user and key in display matching entry, can so help user to be rapidly completed operation.Finally, after program
Platform risks SQL statement automatically according to field type, and carries out corresponding database manipulation according to the SQL statement risked, and completes
Information Real-time Feedback, simplifies code, reduces input error, while saving the time of coding.
It will be understood by those skilled in the art that all or part of flow of above-described embodiment method is realized, can be by meter
Calculation machine program is completed to instruct the hardware of correlation, and described program can be stored in computer-readable recording medium.Wherein, institute
It is disk, CD, read-only memory or random access memory etc. to state computer-readable recording medium.
The above, the only present invention preferably specific embodiment, but protection scope of the present invention is not limited thereto,
Any one skilled in the art the invention discloses technical scope in, the change or replacement that can be readily occurred in,
Should all be included within the scope of the present invention.
Claims (8)
1. it is a kind of based on category information build query statement lookup method, it is characterised in that comprise the following steps：
Step S1. server ends extract java class information and its attribute information by scanning lasting classification file；Reading sets in advance
The configuration file put, obtains the configuration of each attribute acquiescence；According to java class information, attribute information and configuration information, automatically generate
Category information data list file；
Step S2. clients receive the service parameter of user input, and dynamically add Text Entry according to the selection of user；Visitor
Family end receives the inquiry content that user is input into by Text Entry, and inquiry content and the service parameter of input are sent in the lump
Server end；
Step S3. received server-sides select the inquiry content and service parameter of input by client, and automatic Mosaic goes out SQL languages
Sentence, carries out database lookup operations, and carry out feedback of the information to client according to the SQL statement being spliced into.
2. it is according to claim 1 based on category information build query statement lookup method, it is characterised in that step S1 realities
Now automatically generating category information data list file includes following sub-step：
Create Velocity templates；
By scanning lasting classification file, java class information and its attribute information are automatically extracted；
The configuration file that reading pre-sets, obtains the configuration of attribute acquiescence；
Using the Velocity template generation SQL statements for creating, and the information of java class and its attribute are believed using SQL statement
Breath, configuration information write-in data list file, generate category information data list file；
Output class information data list file.
3. it is according to claim 1 and 2 based on category information build query statement lookup method, it is characterised in that generation
After category information data list file, by editing java class or its attribute information, configuration information in category information data list file, more
New category information data list file.
4. it is according to claim 1 based on category information build query statement lookup method, it is characterised in that text input
The key entry that frame followed by user shows corresponding matching entry.
5. it is according to claim 4 based on category information build query statement lookup method, it is characterised in that the realization
Dynamic addition Text Entry, and show that the step of matching entry is as follows in Text Entry：
Client receives the service parameter that user is set；
Client dynamically adds Text Entry, and receive user by text input according to user input in the interface of foreground
The entry of frame input, server end is sent to by the entry and service parameter of reception in the lump；
Received server-side entry and service parameter, according to category information data list file and service parameter, automatically create inquiry
Sentence, then performs query statement, Query Result is obtained, as the matching entry of user input entry；
Query Result is built into Json character strings by server end again, and is sent to client；
Client parses character string and shows matching entry, for user's selection inquiry content.
6. according to claim 4 or 5 based on category information build query statement lookup method, it is characterised in that use
Java reflex mechanisms, realize the dynamic addition of Text Entry and the display of matching entry.
7. it is according to claim 1 based on category information build query statement lookup method, it is characterised in that step S3's
Realization includes following sub-step：
Service parameter and the inquiry content of user's selection that server reception client transmissions come；
According to category information data list file, inquiry content and the corresponding attribute information of service parameter and configuration information are obtained；
For each inquiry content, obtain corresponding SQL statement fragment and store；
The SQL statement fragment of each inquiry content that user is selected is merged into a stsndard SQL sentence and is stored；
Corresponding database lookup operations are carried out using the SQL statement after merging.
8. it is according to claim 7 based on category information build query statement lookup method, it is characterised in that it is described to be directed to
Each inquiry content, obtains corresponding SQL statement fragment, and the specifically data type according to text box correspondence attribute carries out right
The treatment answered.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710032574.0A CN106775770B (en) | 2017-01-16 | 2017-01-16 | Search method for constructing query statement based on class information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710032574.0A CN106775770B (en) | 2017-01-16 | 2017-01-16 | Search method for constructing query statement based on class information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106775770A true CN106775770A (en) | 2017-05-31 |
| CN106775770B CN106775770B (en) | 2020-08-11 |
Family
ID=58947085
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710032574.0A Active CN106775770B (en) | 2017-01-16 | 2017-01-16 | Search method for constructing query statement based on class information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106775770B (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN108446398A (en) * | 2018-03-27 | 2018-08-24 | 北京邦邦共赢网络科技有限公司 | A kind of generation method and device of database |
| CN109634590A (en) * | 2018-12-28 | 2019-04-16 | 北京神舟航天软件技术有限公司 | A kind of Object Query method based on business model |
| CN109739493A (en) * | 2019-01-18 | 2019-05-10 | 宜创(北京)科技有限公司 | Generation method, device, electronic equipment and the storage medium of data base manipulation statement |
| CN109918394A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Data query method, system, computer installation and computer readable storage medium |
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN109977317A (en) * | 2019-04-03 | 2019-07-05 | 恒生电子股份有限公司 | Data query method and device |
| CN109977139A (en) * | 2019-03-18 | 2019-07-05 | 京东数字科技控股有限公司 | Data processing method and device based on type of structured query statement |
| CN110109947A (en) * | 2017-12-28 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus for extracting data |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN110674141A (en) * | 2019-10-09 | 2020-01-10 | 四川长虹电器股份有限公司 | Method for adding database table to page based on java development |
| CN110750705A (en) * | 2018-07-06 | 2020-02-04 | 北京高德云图科技有限公司 | Search result display method and device and electronic equipment |
| CN110825389A (en) * | 2018-08-07 | 2020-02-21 | 北京国双科技有限公司 | Json character string generation method and device, storage medium and processor |
| CN111966704A (en) * | 2020-07-09 | 2020-11-20 | 杭州传化智能制造科技有限公司 | ORM framework implementation method, system, computer equipment and storage medium |
| CN114218904A (en) * | 2021-12-14 | 2022-03-22 | 中国建设银行股份有限公司 | A method and system for configurable report export design |
| CN114756554A (en) * | 2022-06-13 | 2022-07-15 | 中建电子商务有限责任公司 | Data query processing method based on MyBatis framework |
| CN119201982A (en) * | 2024-11-29 | 2024-12-27 | 上海艾拉比智能科技有限公司 | A method and device for dynamically generating database scripts |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101000626A (en) * | 2007-01-12 | 2007-07-18 | 宋晓伟 | Information storing method and method for converting search inquiry into inquiry statement |
| CN102722372A (en) * | 2012-05-25 | 2012-10-10 | 上海学智科技有限公司 | Method and system for automatically generating codes through classification and configuration |
| CN103177008A (en) * | 2011-12-22 | 2013-06-26 | 北大方正集团有限公司 | Method and system used for generating and executing structured query language (SQL) statement |
-
2017
- 2017-01-16 CN CN201710032574.0A patent/CN106775770B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101000626A (en) * | 2007-01-12 | 2007-07-18 | 宋晓伟 | Information storing method and method for converting search inquiry into inquiry statement |
| CN103177008A (en) * | 2011-12-22 | 2013-06-26 | 北大方正集团有限公司 | Method and system used for generating and executing structured query language (SQL) statement |
| CN102722372A (en) * | 2012-05-25 | 2012-10-10 | 上海学智科技有限公司 | Method and system for automatically generating codes through classification and configuration |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679056B (en) * | 2017-06-25 | 2021-03-02 | 平安科技（深圳）有限公司 | Method for generating SQL (structured query language) statement, electronic device and readable storage medium |
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN110109947A (en) * | 2017-12-28 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus for extracting data |
| CN108446398A (en) * | 2018-03-27 | 2018-08-24 | 北京邦邦共赢网络科技有限公司 | A kind of generation method and device of database |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN110750705A (en) * | 2018-07-06 | 2020-02-04 | 北京高德云图科技有限公司 | Search result display method and device and electronic equipment |
| CN110825389A (en) * | 2018-08-07 | 2020-02-21 | 北京国双科技有限公司 | Json character string generation method and device, storage medium and processor |
| CN109634590A (en) * | 2018-12-28 | 2019-04-16 | 北京神舟航天软件技术有限公司 | A kind of Object Query method based on business model |
| CN109739493A (en) * | 2019-01-18 | 2019-05-10 | 宜创(北京)科技有限公司 | Generation method, device, electronic equipment and the storage medium of data base manipulation statement |
| CN109918394B (en) * | 2019-01-23 | 2023-11-28 | 中国平安人寿保险股份有限公司 | Data query method, system, computer device and computer readable storage medium |
| CN109918394A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Data query method, system, computer installation and computer readable storage medium |
| CN109977139A (en) * | 2019-03-18 | 2019-07-05 | 京东数字科技控股有限公司 | Data processing method and device based on type of structured query statement |
| CN109977317B (en) * | 2019-04-03 | 2021-04-27 | 恒生电子股份有限公司 | Data query method and device |
| CN109977317A (en) * | 2019-04-03 | 2019-07-05 | 恒生电子股份有限公司 | Data query method and device |
| CN110674141A (en) * | 2019-10-09 | 2020-01-10 | 四川长虹电器股份有限公司 | Method for adding database table to page based on java development |
| CN111966704A (en) * | 2020-07-09 | 2020-11-20 | 杭州传化智能制造科技有限公司 | ORM framework implementation method, system, computer equipment and storage medium |
| CN114218904A (en) * | 2021-12-14 | 2022-03-22 | 中国建设银行股份有限公司 | A method and system for configurable report export design |
| CN114756554A (en) * | 2022-06-13 | 2022-07-15 | 中建电子商务有限责任公司 | Data query processing method based on MyBatis framework |
| CN119201982A (en) * | 2024-11-29 | 2024-12-27 | 上海艾拉比智能科技有限公司 | A method and device for dynamically generating database scripts |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106775770B (en) | 2020-08-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106775770A (en) | The lookup method of query statement is built based on category information | |
| US11080493B2 (en) | Translation review workflow systems and methods | |
| CN109062567B (en) | B/S structure-based information management system rapid development platform | |
| US20190171696A1 (en) | Web-intrinsic interactive documents | |
| US7823086B2 (en) | Publishing protocol extensions for enhanced authoring of web pages | |
| CN109933752A (en) | A kind of method and apparatus exporting electronic document | |
| US10891430B2 (en) | Semi-automated methods for translating structured document content to chat-based interaction | |
| WO2006107529A2 (en) | Method and system for aggregating rules for a property associated with a document element | |
| CN107122166A (en) | The Extensible template pipeline applied for web | |
| CN101667118A (en) | Method and device for multi-language version development and replacement | |
| CN102096588A (en) | Control-containing page establishing method | |
| CN104252521A (en) | Web content management using predetermined project templates | |
| CN105701183A (en) | User personalized template implementation method and apparatus | |
| JP7208872B2 (en) | Systems and methods for generating proposals based on request for proposals (RFPs) | |
| CN102880664A (en) | Page editing method, device and system | |
| CN102541829A (en) | Multiuser concurrent electronic document generation device and method | |
| CN112988781A (en) | Data query method and device, electronic equipment and computer readable storage medium | |
| AU2015331030A1 (en) | System generator module for electronic document and electronic file | |
| JP2022019524A (en) | Modeling parameter configuration method, apparatus, device, computer storage medium, and computer program | |
| US20240330580A1 (en) | Generation of Personalized and Structured Content Using a Collaborative Online Generator | |
| US7941749B2 (en) | Composition of electronic document layout | |
| KR20220004343A (en) | Method for drafting business presentation document by using template database | |
| JP5747698B2 (en) | Requirements management support device | |
| JP2001344230A (en) | Device and method for generating multimedia document, and recording medium with program for allowing computer to execute the method recorded thereon | |
| CN115686447A (en) | Intelligent recommendation method for application creation, and creation method, device and system for application |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |