CN105354036A - Database operation code generating method and apparatus - Google Patents
Database operation code generating method and apparatus Download PDFInfo
- Publication number
- CN105354036A CN105354036A CN201510843410.7A CN201510843410A CN105354036A CN 105354036 A CN105354036 A CN 105354036A CN 201510843410 A CN201510843410 A CN 201510843410A CN 105354036 A CN105354036 A CN 105354036A
- Authority
- CN
- China
- Prior art keywords
- function
- database manipulation
- information
- instruction
- generate
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database operation code generating method and apparatus. The database operation code generating method comprises the steps of receiving an input database operation code generating instruction, wherein the database operation code generating instruction includes physical data model names and table names; reading the table information of the corresponding tables from the corresponding physical data models according to the physical data model names and table names under the database operation code generating instruction; generating a corresponding database operating function according to the read table information and a preset operating function template; assembling the generated database operating function into a C++ file; and outputting the C++ file. According to the technical scheme provided by the invention, the database operation code developing efficiency can be effectively improved.
Description
Technical field
The present invention relates to database technical field, be specifically related to a kind of database manipulation code generating method and device.
Background technology
For most software application system, be inevitable alternately with database, and in the process mutual with database, need to operate (such as insert, delete, upgrade and inquiry etc.) to the tables of data in database essentially.
At present, development technique personnel need for the corresponding database manipulation code of different tables of data hand-codings, and development efficiency lowly and on stream easily occurs unnecessary error.
Summary of the invention
The invention provides a kind of database manipulation code generating method and device, for improving database manipulation code development efficiency.
One aspect of the present invention provides a kind of database manipulation code generating method, comprising:
Receive the database manipulation code building instruction of input, wherein, the instruction of above-mentioned database manipulation code building comprises following information: Physical data model title and table name;
Under the instruction of above-mentioned database manipulation code building instruction, read the table information of respective table in respective physical data model according to above-mentioned Physical data model title and above-mentioned table name;
According to the table information read and the handling function template of presetting, generate corresponding database manipulation function;
The database manipulation group of functions of generation is dressed up C++ file;
Export above-mentioned C++ file.
The present invention provides a kind of database manipulation code generating unit on the other hand, comprising:
Receiving element, for receiving the database manipulation code building instruction of input, wherein, the instruction of above-mentioned database manipulation code building comprises following information: Physical data model title and table name;
First reading unit, under the instruction of above-mentioned database manipulation code building instruction, reads the table information of respective table in respective physical data model according to above-mentioned Physical data model title and above-mentioned table name;
Handling function generation unit, for the table information read according to above-mentioned first reading unit and the handling function template preset, generates corresponding database manipulation function;
Code file generation unit, dresses up C++ file for the database manipulation group of functions generated by aforesaid operations function generation unit;
Output unit, for exporting the C++ file that above-mentioned code file generation unit generates.
Therefore, in the present invention when receiving the instruction of database manipulation code building, the table information of respective table in the Physical data model be pre-created is read according to the Physical data model title comprised in this database manipulation code building instruction and table name, and according to the table information read and the handling function template of presetting, C++ file output is assembled into after the corresponding database manipulation function of automatic generation, thus substantially reduce the number the mechanicalness program coding work of technician in tables of data operating aspect, improve database manipulation code development efficiency and, in addition, because the assembling of database manipulation function and C++ file is the Physical data model that basis is pre-created, table and the handling function template preset generate automatically, therefore technician is without the need to being concerned about the storage implementation procedure to tables of data, relative to the scheme of traditional hand-coding database manipulation code, effectively can reduce the unnecessary error in cataloged procedure.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is database manipulation code generating method provided by the invention embodiment schematic flow sheet;
Fig. 2 is under a kind of embody rule scene provided by the invention, generates the overall flow of database manipulation code based on this DAO_CREATOR;
Fig. 3 is under another kind of embody rule scene provided by the invention, generates the overall flow of database manipulation code based on this DAO_CREATOR;
Fig. 4 is database manipulation code generating unit provided by the invention example structure schematic diagram.
Embodiment
For making goal of the invention of the present invention, feature, advantage can be more obvious and understandable, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, and not all embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Along with developing rapidly of Software Industry, and to finance, security business software system requirements severization, standardization, fast renewal.In order to avoid manpower waste, also in order to standardization, the accuracy of code, also in order to system Express specification is shaping, also write duplicated code, fast Development in order to development technique personnel reduce.Under this thought guidance, by researched and developed based on PowerDesigner physical conceptual model automatically generated data storehouse operation code instrument (for ease of describe, follow-up this instrument is described as DAO_CREATOR), the database manipulation code generating method in the embodiment of the present invention can be realized by this DAO_CREATOR.
Be described a kind of database manipulation code generating method that the embodiment of the present invention provides below, refer to Fig. 1, the database manipulation code generating method in the embodiment of the present invention, comprising:
101, the database manipulation code building instruction of input is received;
Wherein, the instruction of above-mentioned database manipulation code building comprises following information: Physical data model title and table name.
In the embodiment of the present invention, Physical data model and table is created in advance by PowerDesigner (PowerDesigner is a kind of software that can carry out database design), particularly, the mode creating Physical data model and table at PowerDesigner can realize with reference to prior art, repeats no more herein.
In the embodiment of the present invention, after creating Physical data model and table, disc operating system (DOS) (DOS can be passed through, DiskOperatingSystem) order input database operation code generates instruction, when after this dos command of execution, i.e. trigger data storehouse operation code generating apparatus (i.e. above-mentioned DAO_CREATOR), database manipulation code generating unit receives the database manipulation code building instruction inputted by this dos command.Wherein, Physical data model title and table name is specified in the instruction of above-mentioned database manipulation code building, this Physical data model title uniquely maps the Physical data model created based on PowerDesigner, and equally, this table name uniquely maps a table created in Physical data model.Certainly, also can input the instruction of above-mentioned database manipulation code building by alternate manner in the embodiment of the present invention, be not construed as limiting herein.
102, under the instruction of above-mentioned database manipulation code building instruction, the table information of respective table in respective physical data model is read according to the Physical data model title in the instruction of above-mentioned database manipulation code building and table name;
In the embodiment of the present invention, database manipulation code generating unit is according to the Physical data model title in the database manipulation code building instruction received and table name, the respective table in respective physical data model can be obtained, and read the table information (such as list structure information, index information, field information etc.) of this table.
103, according to the table information read and default handling function template, corresponding database manipulation function is generated;
In example of the present invention, database manipulation code generating unit, according to the table information read, according to the handling function template preset, can generate corresponding database manipulation function.It should be noted that, in the embodiment of the present invention, handling function template corresponding to different operating function is different, and, due to different pieces of information base management system (DBMS, DatabaseManagementSystem) grammatical differences, therefore also different for the handling function template set by different DBMS, therefore in step 103, database manipulation code generating unit specifically can obtain according to the DBMS of application and the database manipulation function that need generate the corresponding operating function template preset.Wherein, the DBMS of practical application can determine according to the DBMS arranged in the Physical data model corresponding with above-mentioned Physical data model title.
Optionally, the database manipulation code building instruction that step 101 receives also comprises following information: expand inquiry file name.This expansion inquiry file name uniquely maps an expansion inquiry file be pre-created, and this expansion inquiry file is Structured Query Language (SQL) (SQL, the StructuredQueryLanguage) message file of multilist correlation inquiry.Particularly, this expansion inquiry file creates according to extend markup language (XML, the ExtensibleMarkupLanguage) form of the Notes of PowerDesigner.Then database manipulation code generating unit is after receiving the instruction of above-mentioned database manipulation code building, under the instruction of above-mentioned database manipulation code building instruction, read according to above-mentioned expansion inquiry file name and expand inquiry file accordingly, wherein, comprise in above-mentioned expansion inquiry file: update statement and expansion are inquired about into ginseng field.In step 103, database manipulation code generating unit, under the instruction of above-mentioned update statement, is inquired about according to the list structure information in the table information that step 102 obtains and above-mentioned expansion and is generated input field territory into ginseng field; According to above-mentioned input field territory and a default update function template, generate the update function expanding inquiry.Further, can also comprise in above-mentioned expansion inquiry file: select statement, expand Query Result field and be used to indicate unirecord inquiry or the indication information of many record queries.In step 103, database manipulation code generating unit, under the instruction of above-mentioned select statement, generates output field territory according to the list structure information in the table information that step 102 obtains and above-mentioned expansion Query Result field; If above-mentioned indication information instruction is many record queries, then according to above-mentioned output field territory and default many record queries function template, generate the many record queries function expanding inquiry; If above-mentioned indication information instruction is unirecord inquiry, then according to above-mentioned output field territory and default unirecord query function template, generate the unirecord query function expanding inquiry.Above-mentioned unirecord inquiry refers to that namely vernier is closed after having called, open vernier and read data when above-mentioned many record queries refer to that first time calls and fill given structural array, if this structural array once cannot not fill completely, then recursive call is until fill this structural array, take data for the last time and automatically will close vernier, or when not taking data, show closedown vernier.
It should be noted that, above-mentioned expansion inquiry file is in advance according to the extend markup language (XML of the Notes of PowerDesigner, ExtensibleMarkupLanguage) form creates, certainly, above-mentioned expansion inquiry file also can directly configure in the Table Properties Notes of above-mentioned table, then without the need to carrying above-mentioned expansion inquiry file name in the instruction of above-mentioned database manipulation code building, in the table that database manipulation code generating unit can directly obtain from step 102, read above-mentioned expansion inquiry file.
Optionally, above-mentioned table information comprises: literary name segment information.In step 103, database manipulation code generating unit generates field domain according to above-mentioned literary name segment information, and according to above-mentioned table name, above-mentioned field domain and default insert function template, generates insert function.Further, above-mentioned table information also comprises: index information; Then in step 103, database manipulation code generating unit specifically performs following steps: database manipulation code generating unit, according to above-mentioned table name, above-mentioned field domain, above-mentioned index information (unique index in such as above-mentioned index information) and the 2nd default update function template, generates update function; Database manipulation code generating unit, according to above-mentioned table name, above-mentioned index information (unique index in such as above-mentioned index information) and default delete function template, generates delete function; Database manipulation code generating unit is according to above-mentioned table name, above-mentioned field domain, above-mentioned index information and default select function template, generate select function (for the unique index in above-mentioned index information, generate unirecord select function, for the simple index in above-mentioned index information, generate the select function of many records).
104, the database manipulation group of functions of generation is dressed up C++ file;
In the embodiment of the present invention, the database manipulation group of functions of generation is dressed up C++ file by database manipulation code generating unit.
Optionally, for different DBMS, preset corresponding C++ text template, database manipulation code generating unit is according to the DBMS of current application, call corresponding C++ text template, and according to this C++ text template, the database manipulation group of functions of generation is dressed up C++ file.Illustrate, be set in the handling function performed in SqlServer or db2 to assemble with the C++ text template of win version, be set in the handling function performed in oracle to assemble with the C++ text template of linux version, then when the DBMS of current application is SqlServer or db2, database manipulation code generating unit calls the C++ text template of win version, and according to the C++ text template of this win version, the database manipulation group of functions of generation is dressed up C++ file, this C++ file take .cpp as suffix, and header file take .h as suffix; When the DBMS of current application is oracle, database manipulation code generating unit calls the C++ text template of linux version, and according to the C++ text template of this linux version, the database manipulation group of functions of generation is dressed up C++ file, this C++ file take .sqx as suffix, and header file take .h as suffix.
105, above-mentioned C++ file is exported.
The C++ file output that database manipulation code generating unit will generate, completes the generation of database manipulation code thus.
Therefore, in the present invention when receiving the instruction of database manipulation code building, the table information of respective table in the Physical data model be pre-created is read according to the Physical data model title comprised in this database manipulation code building instruction and table name, and according to the table information read and the handling function template of presetting, C++ file output is assembled into after the corresponding database manipulation function of automatic generation, thus substantially reduce the number the mechanicalness program coding work of technician in tables of data operating aspect, improve database manipulation code development efficiency and, in addition, because the assembling of database manipulation function and C++ file is the Physical data model that basis is pre-created, table and the handling function template preset generate automatically, therefore technician is without the need to being concerned about the storage implementation procedure to tables of data, relative to the scheme of traditional hand-coding database manipulation code, effectively can reduce the unnecessary error in cataloged procedure.
From aforementioned, by exploitation can perform embodiment illustrated in fig. 1 in the DAO_CREATOR of database manipulation code generating method, technician is follow-up directly calls this DAO_CREATOR can the automatic generation of fulfillment database operation code.In a kind of embody rule scene, the overall flow generating database manipulation code based on this DAO_CREATOR can as shown in Figure 2:
201, in PowerDesigner software, create the table of physically based deformation data model.
202, in dos command, input database operation code generates instruction and performs this dos command.
203, DAO_CREATOR is called, so that DAO_CREATOR automatically generates C++ file according to the database manipulation code building instruction of input and exports.
Wherein the realization flow of step 203 specifically can refer to embodiment illustrated in fig. 1 in description.
In another kind of embody rule scene, the overall flow generating database manipulation code based on this DAO_CREATOR can as shown in Figure 3:
301, in PowerDesigner software, create the table of physically based deformation data model.
302, expansion inquiry file is created.
303, in dos command, input database operation code generates instruction and performs this dos command.
304, DAO_CREATOR is called, so that DAO_CREATOR automatically generates C++ file according to the database manipulation code building instruction of input and exports;
Wherein the realization flow of step 304 specifically can refer to embodiment illustrated in fig. 1 in description.
The embodiment of the present invention also provides a kind of database manipulation code generating unit, and as shown in Figure 4, the database manipulation code generating unit 400 in the embodiment of the present invention, comprising:
Receiving element 401, for receiving the database manipulation code building instruction of input, wherein, the instruction of above-mentioned database manipulation code building comprises following information: Physical data model title and table name;
First reading unit 402, under the instruction of above-mentioned database manipulation code building instruction, reads the table information of respective table in respective physical data model according to above-mentioned Physical data model title and above-mentioned table name;
Handling function generation unit 403, for the table information read according to the first reading unit 402 and the handling function template of presetting, generates corresponding database manipulation function;
Code file generation unit 404, dresses up C++ file for the database manipulation group of functions generated by handling function generation unit 403;
Output unit 405, for the C++ file that output code file generating unit 404 generates.
Optionally, the instruction of above-mentioned database manipulation code building also comprises following information: expand inquiry file name; Above-mentioned table information comprises: list structure information; Database manipulation code generating unit in the embodiment of the present invention also comprises: the second reading unit, for under the instruction of above-mentioned database manipulation code building instruction, read according to above-mentioned expansion inquiry file name and expand inquiry file accordingly, wherein, comprise in above-mentioned expansion inquiry file: update statement and expansion are inquired about into ginseng field; Handling function generation unit 403 specifically for: under the instruction of above-mentioned update statement, according to first reading unit 402 read list structure information and above-mentioned second reading unit read expansion inquire about into ginseng field generate input field territory; According to above-mentioned input field territory and a default update function template, generate the update function expanding inquiry.
Optionally, also comprise in above-mentioned expansion inquiry file: select statement, expand Query Result field and be used to indicate unirecord inquiry or the indication information of many record queries; Handling function generation unit 403 specifically for: under the instruction of above-mentioned select statement, according to first reading unit 402 read list structure information and above-mentioned second reading unit read expansion Query Result field generate output field territory; When above-mentioned indication information indicate be many record queries time, then according to above-mentioned output field territory and preset many record queries function template, generate expand inquiry many record queries function; When above-mentioned indication information indicate be unirecord inquiry time, according to above-mentioned output field territory and preset unirecord query function template, generate expand inquiry unirecord query function.
Optionally, above-mentioned table information comprises: literary name segment information; Handling function generation unit 403 specifically for: according to first reading unit 402 read literary name segment information generate field domain; According to above-mentioned table name, above-mentioned field domain and default insert function template, generate insert function.
Optionally, above-mentioned table information also comprises: index information; Handling function generation unit 403 specifically for: according to above-mentioned table name, above-mentioned field domain, above-mentioned index information and the 2nd default update function template, generate update function; According to above-mentioned table name, above-mentioned index information and default delete function template, generate delete function; According to above-mentioned table name, above-mentioned field domain, above-mentioned index information and default select function template, generate select function.
It should be noted that, database manipulation code generating unit in the embodiment of the present invention can as the database manipulation code generating unit mentioned in above-mentioned embodiment of the method, may be used for the whole technical schemes realized in said method embodiment, the function of its each functional module can according to the method specific implementation in said method embodiment, its specific implementation process can refer to the associated description in above-described embodiment, repeats no more herein.
Therefore, in the present invention when receiving the instruction of database manipulation code building, the table information of respective table in the Physical data model be pre-created is read according to the Physical data model title comprised in this database manipulation code building instruction and table name, and according to the table information read and the handling function template of presetting, C++ file output is assembled into after the corresponding database manipulation function of automatic generation, thus substantially reduce the number the mechanicalness program coding work of technician in tables of data operating aspect, improve database manipulation code development efficiency and, in addition, because the assembling of database manipulation function and C++ file is the Physical data model that basis is pre-created, table and the handling function template preset generate automatically, therefore technician is without the need to being concerned about the storage implementation procedure to tables of data, relative to the scheme of traditional hand-coding database manipulation code, effectively can reduce the unnecessary error in cataloged procedure.
In several embodiments that the application provides, should be understood that disclosed apparatus and method can realize by another way.Such as, device embodiment described above is only schematic, such as, the division of said units, be only a kind of logic function to divide, actual can have other dividing mode when realizing, such as multiple unit or assembly can in conjunction with or another system can be integrated into, or some features can be ignored, or do not perform.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, and the indirect coupling of device or unit or communication connection can be electrical, machinery or other form.
It should be noted that, for aforesaid each embodiment of the method, in order to easy description, therefore it is all expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not by the restriction of described sequence of movement, because according to the present invention, some step can adopt other order or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and involved action and module might not be all that the present invention is necessary.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part described in detail, can see the associated description of other embodiment.
It is more than the description to a kind of database manipulation code generating method provided by the present invention and device, for one of ordinary skill in the art, according to the thought of the embodiment of the present invention, all will change in specific embodiments and applications, to sum up, this description should not be construed as limitation of the present invention.
Claims (10)
1. a database manipulation code generating method, is characterized in that, comprising:
Receive the database manipulation code building instruction of input, wherein, the instruction of described database manipulation code building comprises following information: Physical data model title and table name;
Under the instruction of described database manipulation code building instruction, read the table information of respective table in respective physical data model according to described Physical data model title and described table name;
According to the table information read and the handling function template of presetting, generate corresponding database manipulation function;
The database manipulation group of functions of generation is dressed up C++ file;
Export described C++ file.
2. method according to claim 1, is characterized in that, the instruction of described database manipulation code building also comprises following information: expand inquiry file name; Described table information comprises: list structure information;
The described database manipulation code building instruction receiving input, also comprises afterwards:
Under the instruction of described database manipulation code building instruction, read according to described expansion inquiry file name and expand inquiry file accordingly, wherein, comprise in described expansion inquiry file: update statement and expansion are inquired about into ginseng field;
Described according to the table information read and the handling function template of presetting, generate corresponding database manipulation function and comprise:
Under the instruction of described update statement, inquire about according to described list structure information and described expansion and generate input field territory into ginseng field;
According to described input field territory and a default update function template, generate the update function expanding inquiry.
3. method according to claim 2, is characterized in that, also comprises in described expansion inquiry file: select statement, expand Query Result field and be used to indicate unirecord inquiry or the indication information of many record queries;
Described according to the table information read and the handling function template of presetting, generate corresponding database manipulation function and comprise:
Under the instruction of described select statement, generate output field territory according to described list structure information and described expansion Query Result field;
If described indication information instruction is many record queries, then according to described output field territory and default many record queries function template, generate the many record queries function expanding inquiry;
If described indication information instruction is unirecord inquiry, then according to described output field territory and default unirecord query function template, generate the unirecord query function expanding inquiry.
4. the method according to any one of claims 1 to 3, is characterized in that, described table information comprises: literary name segment information;
Described according to the table information read and the handling function template of presetting, generate corresponding database manipulation function, comprising:
Field domain is generated according to described literary name segment information;
According to described table name, described field domain and default insert function template, generate insert function.
5. method according to claim 4, is characterized in that, described table information also comprises: index information;
Described according to the table information read and the handling function template of presetting, generate corresponding database manipulation function, comprising:
According to described table name, described field domain, described index information and the 2nd default update function template, generate update function;
According to described table name, described index information and default delete function template, generate delete function;
According to described table name, described field domain, described index information and default select function template, generate select function.
6. a database manipulation code generating unit, is characterized in that, comprising:
Receiving element, for receiving the database manipulation code building instruction of input, wherein, the instruction of described database manipulation code building comprises following information: Physical data model title and table name;
First reading unit, under the instruction of described database manipulation code building instruction, reads the table information of respective table in respective physical data model according to described Physical data model title and described table name;
Handling function generation unit, for the table information read according to described first reading unit and the handling function template preset, generates corresponding database manipulation function;
Code file generation unit, dresses up C++ file for the database manipulation group of functions generated by described handling function generation unit;
Output unit, for exporting the C++ file that described code file generation unit generates.
7. database manipulation code generating unit according to claim 6, is characterized in that, the instruction of described database manipulation code building also comprises following information: expand inquiry file name; Described table information comprises: list structure information;
Described database manipulation code generating unit also comprises:
Second reading unit, under the instruction of described database manipulation code building instruction, reads according to described expansion inquiry file name and expands inquiry file accordingly, wherein, comprise in described expansion inquiry file: update statement and expansion are inquired about into ginseng field;
Described handling function generation unit specifically for: under the instruction of described update statement, according to described first reading unit read list structure information and described second reading unit read expansion inquire about into ginseng field generate input field territory; According to described input field territory and a default update function template, generate the update function expanding inquiry.
8. database manipulation code generating unit according to claim 7, is characterized in that, also comprises in described expansion inquiry file: select statement, expand Query Result field and be used to indicate unirecord inquiry or the indication information of many record queries;
Described handling function generation unit specifically for: under the instruction of described select statement, according to described first reading unit read list structure information and described second reading unit read expansion Query Result field generate output field territory; When described indication information indicate be many record queries time, then according to described output field territory and preset many record queries function template, generate expand inquiry many record queries function; When described indication information indicate be unirecord inquiry time, according to described output field territory and preset unirecord query function template, generate expand inquiry unirecord query function.
9. the database manipulation code generating unit according to any one of claim 6 to 8, is characterized in that, described table information comprises: literary name segment information;
Described handling function generation unit specifically for: according to described first reading unit read literary name segment information generate field domain; According to described table name, described field domain and default insert function template, generate insert function.
10. database manipulation code generating unit according to claim 9, is characterized in that, described table information also comprises: index information;
Described handling function generation unit specifically for: according to described table name, described field domain, described index information and the 2nd default update function template, generate update function; According to described table name, described index information and default delete function template, generate delete function; According to described table name, described field domain, described index information and default select function template, generate select function.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510843410.7A CN105354036B (en) | 2015-11-26 | 2015-11-26 | Database manipulation code generating method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510843410.7A CN105354036B (en) | 2015-11-26 | 2015-11-26 | Database manipulation code generating method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105354036A true CN105354036A (en) | 2016-02-24 |
| CN105354036B CN105354036B (en) | 2019-02-01 |
Family
ID=55330012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510843410.7A Active CN105354036B (en) | 2015-11-26 | 2015-11-26 | Database manipulation code generating method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354036B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | 中国银联股份有限公司 | The method and apparatus generating database manipulation code |
| CN106445524A (en) * | 2016-09-26 | 2017-02-22 | 杭州杉石科技有限公司 | SystemC code generation method based on model |
| CN106528228A (en) * | 2016-11-01 | 2017-03-22 | 中国银联股份有限公司 | Storage system operation realization method and apparatus |
| CN107729561A (en) * | 2017-11-09 | 2018-02-23 | 成都卓凡软件科技有限公司 | The method that the table handling of paired data storehouse is reversely given birth to based on database table structure |
| CN109032590A (en) * | 2018-09-26 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of configuration method, device, terminal and the storage medium of visual development environment |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110955410A (en) * | 2019-10-23 | 2020-04-03 | 山东中创软件工程股份有限公司 | Automatic code generation method, device, equipment and medium |
| CN112487013A (en) * | 2020-11-18 | 2021-03-12 | 中信银行股份有限公司 | Database operation code generation method and device |
| CN112631567A (en) * | 2020-12-30 | 2021-04-09 | 中国农业银行股份有限公司 | Method and device for generating database operation file |
| CN113190218A (en) * | 2021-04-28 | 2021-07-30 | 中国邮政储蓄银行股份有限公司 | Target operation function generation method and device |
| CN115495442A (en) * | 2022-11-16 | 2022-12-20 | 深圳市明源云采购科技有限公司 | Database operation file generation method, device, equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101008952A (en) * | 2007-01-30 | 2007-08-01 | 华为技术有限公司 | Method and device for generating persistence layer |
| US20080148229A1 (en) * | 2002-06-06 | 2008-06-19 | Srilekha Krishnan Gownder | Automated Source Code Generation |
| CN101359324A (en) * | 2007-08-02 | 2009-02-04 | 上海宝信软件股份有限公司 | Data access method of oracle relational database based on procedure call interface |
| CN101819530A (en) * | 2010-04-30 | 2010-09-01 | 山东中创软件工程股份有限公司 | Program object generation method and device and computer |
| CN102117202A (en) * | 2009-12-30 | 2011-07-06 | 北大方正集团有限公司 | J2EE architecture-based code generating device |
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
| CN103713887A (en) * | 2012-09-29 | 2014-04-09 | 镇江金软计算机科技有限责任公司 | Program code generator |
-
2015
- 2015-11-26 CN CN201510843410.7A patent/CN105354036B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080148229A1 (en) * | 2002-06-06 | 2008-06-19 | Srilekha Krishnan Gownder | Automated Source Code Generation |
| CN101008952A (en) * | 2007-01-30 | 2007-08-01 | 华为技术有限公司 | Method and device for generating persistence layer |
| CN101359324A (en) * | 2007-08-02 | 2009-02-04 | 上海宝信软件股份有限公司 | Data access method of oracle relational database based on procedure call interface |
| CN102117202A (en) * | 2009-12-30 | 2011-07-06 | 北大方正集团有限公司 | J2EE architecture-based code generating device |
| CN101819530A (en) * | 2010-04-30 | 2010-09-01 | 山东中创软件工程股份有限公司 | Program object generation method and device and computer |
| CN103713887A (en) * | 2012-09-29 | 2014-04-09 | 镇江金软计算机科技有限责任公司 | Program code generator |
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
Non-Patent Citations (1)
| Title |
|---|
| 曾小宁: ""数据库应用软件开发中程序代码的自动生成"", 《广西教育学院学报》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | 中国银联股份有限公司 | The method and apparatus generating database manipulation code |
| CN106445524B (en) * | 2016-09-26 | 2019-12-17 | 杭州杉石科技有限公司 | SystemC code generation method based on model |
| CN106445524A (en) * | 2016-09-26 | 2017-02-22 | 杭州杉石科技有限公司 | SystemC code generation method based on model |
| CN106528228A (en) * | 2016-11-01 | 2017-03-22 | 中国银联股份有限公司 | Storage system operation realization method and apparatus |
| CN106528228B (en) * | 2016-11-01 | 2019-12-24 | 中国银联股份有限公司 | Method and device for realizing operation of storage system |
| CN107729561A (en) * | 2017-11-09 | 2018-02-23 | 成都卓凡软件科技有限公司 | The method that the table handling of paired data storehouse is reversely given birth to based on database table structure |
| CN109032590B (en) * | 2018-09-26 | 2021-11-16 | 山东鲁能软件技术有限公司 | Configuration method, device, terminal and storage medium of visual development environment |
| CN109032590A (en) * | 2018-09-26 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of configuration method, device, terminal and the storage medium of visual development environment |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110955410A (en) * | 2019-10-23 | 2020-04-03 | 山东中创软件工程股份有限公司 | Automatic code generation method, device, equipment and medium |
| CN110955410B (en) * | 2019-10-23 | 2023-06-27 | 山东中创软件工程股份有限公司 | Code automatic generation method, device, equipment and medium |
| CN112487013A (en) * | 2020-11-18 | 2021-03-12 | 中信银行股份有限公司 | Database operation code generation method and device |
| CN112631567A (en) * | 2020-12-30 | 2021-04-09 | 中国农业银行股份有限公司 | Method and device for generating database operation file |
| CN113190218A (en) * | 2021-04-28 | 2021-07-30 | 中国邮政储蓄银行股份有限公司 | Target operation function generation method and device |
| CN115495442A (en) * | 2022-11-16 | 2022-12-20 | 深圳市明源云采购科技有限公司 | Database operation file generation method, device, equipment and storage medium |
| CN115495442B (en) * | 2022-11-16 | 2023-08-04 | 深圳市明源云采购科技有限公司 | Database operation file generation method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105354036B (en) | 2019-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105354036A (en) | Database operation code generating method and apparatus | |
| EP3042254B1 (en) | Systems and methods for virtualizing a programmable logic controller | |
| CN105335412A (en) | Method and device for data conversion and data migration | |
| CN104268428B (en) | A kind of visual configuration method calculated for index | |
| CN108509185B (en) | System and method for arbitrary software logic modeling | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN106662854B (en) | The method and system of the configuration of device for control system | |
| CN102541521B (en) | Automatic operating instruction generating device based on structured query language and method | |
| CN104216961B (en) | A kind of data processing method and device | |
| CN104965735A (en) | Apparatus for generating upgrade SQL script | |
| CN104133772A (en) | Automatic test data generation method | |
| CN103093000A (en) | Database query modeling system and database query modeling method | |
| CN106648587A (en) | Annotation-based Web application code generation method | |
| CN106293664A (en) | Code generating method and device | |
| CN104331285A (en) | Automatic code generation method and system | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN101499063A (en) | Tracing-based database schema evolution method and system | |
| CN103412868A (en) | Method and device for generating document | |
| CN103678532A (en) | Alternation statement reverse analysis method, database alternating and backspacing method and database alternating and backspacing system | |
| CN102156640A (en) | Method for generating data operation code | |
| CN104731588A (en) | Page layout file generation method and device | |
| US9652478B2 (en) | Method and apparatus for generating an electronic document schema from a relational model | |
| CN1329818C (en) | Implement method of the man machine command based on plain text command script files | |
| CN106126224A (en) | Tool, system and method for generating program object | |
| CN103593182A (en) | Method for reconfiguring software by using clustering mode |
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 |