CN111796810A - Method and system for configurable rapid generation of Mysql database codes - Google Patents
Method and system for configurable rapid generation of Mysql database codes Download PDFInfo
- Publication number
- CN111796810A CN111796810A CN202010637153.2A CN202010637153A CN111796810A CN 111796810 A CN111796810 A CN 111796810A CN 202010637153 A CN202010637153 A CN 202010637153A CN 111796810 A CN111796810 A CN 111796810A
- Authority
- CN
- China
- Prior art keywords
- reading
- class
- database
- template
- configuration
- 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 25
- 238000012360 testing method Methods 0.000 claims description 20
- 238000004519 manufacturing process Methods 0.000 claims description 12
- 230000001351 cycling effect Effects 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000001172 regenerating effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
-
- 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
- G06F16/2433—Query languages
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)
- Stored Programmes (AREA)
Abstract
The invention provides a configurable method for quickly generating Mysql database codes, which comprises the following steps: step S1, setting a configuration table in the Mysql database, wherein the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name; step S2, setting a database configuration index file under the project, and reading configuration information according to the configuration index file; step S3, reading template codes in the Mysql database configuration table; step S4, an ORM operation code is generated according to the configuration information and the template code; the invention improves the working efficiency of developers.
Description
Technical Field
The invention relates to the technical field of computer communication, in particular to a method and a system for configurable rapid generation of Mysql database codes.
Background
When the project development related to mysql database operation is involved, programmers need to splice sql statements according to a data table structure, and the traditional splicing mode is too inefficient and has a lot of mechanical repeated work. For addition, deletion, modification and query operations of a data table, the prior art may write codes by using the idea of Object-Relational Mapping (ORM), but how to generate ORM quickly and how to update ORM codes quickly after the data table is changed are a problem to be solved.
Disclosure of Invention
In order to overcome the problems, the invention aims to provide a configurable method for quickly generating Mysql database codes, which can quickly update ORM codes and improve the working efficiency.
The invention is realized by adopting the following scheme: a configurable method for fast generation of Mysql database code, the method comprising the steps of:
step S1, setting a configuration table in the Mysql database, wherein the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
step S2, setting a database configuration index file under the project, and reading configuration information according to the configuration index file;
step S3, reading template codes in the Mysql database configuration table;
and step S4, generating an ORM operation code according to the configuration information and the template code.
Further, the step S2 is further specifically: creating an item index folder, creating a file of appname.txt under the index folder, wherein the file content is user, and the user is used for guiding which configuration information is to be read.
Further, the method further comprises: step S5, after the class library is generated, the functions of adding, deleting, modifying and inquiring can be directly called in the project; and in the later stage, if the business adjustment is carried out, the business operation of adding the table, modifying the table field and deleting the table field is carried out, and the program can generate the c # database code again by one key through the step S4 according to the modified data table information.
Further, the step S4 is further specifically:
step 4.1: when a Mysql database code is generated, a program searches an appname.
Step 4.2: obtain app _ name = usermfrom appname.
Step 4.3: reading a record of app _ name = 'userorm' in an orm _ config table in a Mysql database;
step 4.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema. tables where table _ schema = 'test'", and reading out all data table names in the test database;
step 4.5: and cycling the data table, and reading all field information under the data table, wherein the all field information comprises: remarks, field serial number, field name, identification, whether a primary key is present, field type, number of occupied bytes, length, decimal number, whether null is allowed, default value and field description;
step 4.6: after reading all needed table information, starting to generate codes, wherein each table generates 3 classes, namely an entity class EnUser.cs, a data object operation class DaUser.cs and a service calling class BusUser.cs; the entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 4.7: reading an entity template with type = 'En' in an orm _ template table, and generating an entity class EnUser.cs according to all read fields in a data table;
step 4.8: reading orm _ template data connection type templates with type = 'Da' in a template table, and generating a data object operation type DaUser.cs according to all read fields in the data table;
step 4.9: reading a data service class generation template; generating a service call class BusUser.cs according to all the fields read in the data table;
step 4.10: and finishing the generation of the class database.
The invention also provides a system capable of configuring and rapidly generating Mysql database codes, which comprises a configuration module, an index module, a template reading module and a code production module;
the configuration module is used for setting a configuration table in a Mysql database, and the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
the index module is used for setting a database configuration index file under the project and reading configuration information according to the configuration index file;
the template reading module is used for reading template codes in a Mysql database configuration table;
and the production code module is used for generating an ORM operation code according to the configuration information and the template code.
Further, the index module is further specifically: creating an item index folder, creating a file of appname.txt under the index folder, wherein the file content is user, and the user is used for guiding which configuration information is to be read.
Furthermore, the system also comprises a code regenerating module which is used for directly calling the functions of adding, deleting, modifying and inquiring in the project after the complete library is generated; and in the later stage, if the business adjustment is carried out, the business operation of adding the table, modifying the table field and deleting the table field is carried out, and the program can generate the c # database code again by one key through the step S4 according to the modified data table information.
Further, the production code module is realized by the following steps:
step 1.1: when a Mysql database code is generated, a program searches an appname.
Step 1.2: obtain app _ name = usermfrom appname.
Step 1.3: reading a record of app _ name = 'userorm' in an orm _ config table in a Mysql database;
step 1.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema. tables where table _ schema = 'test'", and reading out all data table names in the test database;
step 1.5: and cycling the data table, and reading all field information under the data table, wherein the all field information comprises: remarks, field serial number, field name, identification, whether a primary key is present, field type, number of occupied bytes, length, decimal number, whether null is allowed, default value and field description;
step 1.6: after reading all needed table information, starting to generate codes, wherein each table generates 3 classes, namely an entity class EnUser.cs, a data object operation class DaUser.cs and a service calling class BusUser.cs; the entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 1.7: reading an entity template with type = 'En' in an orm _ template table, and generating an entity class EnUser.cs according to all read fields in a data table;
step 1.8: reading orm _ template data connection type templates with type = 'Da' in a template table, and generating a data object operation type DaUser.cs according to all read fields in the data table;
step 1.9: reading a data service class generation template; generating a service call class BusUser.cs according to all the fields read in the data table;
step 1.10: and finishing the generation of the class database.
The invention has the beneficial effects that: the method can solve the problem that unnecessary BUG is easily generated by manually constructing entity classes and manually splicing SQL sentences, and improves the working efficiency of developers.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention.
Fig. 2 is a schematic block diagram of the system of the present invention.
Detailed Description
The invention is further described below with reference to the accompanying drawings.
Referring to fig. 1, a configurable method for quickly generating Mysql database codes according to the present invention includes the following steps:
step S1, setting a configuration table in the Mysql database, wherein the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
step S2, setting a database configuration index file under the project, and reading configuration information according to the configuration index file;
step S3, reading template codes in the Mysql database configuration table;
and step S4, generating an ORM operation code according to the configuration information and the template code.
The invention is further illustrated below with reference to a specific embodiment:
step 1: filling information of items to be generated in the local configuration table orm _ config;
the watch structure is as follows
CREATE TABLE `orm_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_name` varchar(100) DEFAULT '',
"db 'varchar (100) DEFAULT' COMMENT 'database name',
"project _ namespace," varchar (100) DEFAULT "COMMENT 'project namespace',
"mysql _ connection" varchar (300) DEFAULT "COMMENT 'target data link string',
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
fill in the following configuration information:
app _ name: userorm (application name)
db: test (database name)
Reject _ namespace: orm (project namespace)
connection：server=127.0.0.1;port=3306;Uid=root;Pwd=123456;database=test;
(target database connection string)
Step 2: a project folder UserOrm is established, a file called appname.txt is established under the folder, and the content of the file is UserOrm, so that a program can know which configuration data is read by the program. The description is given by way of example to generate an operation database code of a user table under the test database;
step S3, reading template codes in the Mysql database configuration table;
and step S4, generating an ORM operation code according to the configuration information and the template code.
The following describes a specific implementation manner of step S4:
step 4.1: the program will look for the appname.
Step 4.2: obtain app _ name = usermfrom appname.
Step 4.3: reading a record of app _ name = 'user' in a configuration table orm _ config table;
step 4.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema.
Step 4.5: and (3) circulating the data table, reading all field information under the data table, remarks, field serial numbers, field names, identifications, whether a main key is used, field types, byte numbers occupied, lengths, decimal digits, whether the field is allowed to be empty, default values and field descriptions.
SELECT
The TABLE _ NAME as TABLE NAME,
COLUMN _ NAME AS field NAME,
the DATA _ TYPE AS TYPE is set to,
the COLUMN _ COMMENT as field specifies,
CASE WHEN IS_NULLABLE ='YES'
the THEN 1 ELSE 0 END as is allowed to empty,
CASE WHEN COLUMN_KEY ='PRI'
the THEN 1 ELSE 0 END as primary key,
CASE WHEN EXTRA ='auto_increment'
the THEN 1 ELSE 0 END AS identity,
CASE WHEN CHARACTER_MAXIMUM_LENGTH is not NULL
THEN CHARACTER_MAXIMUM_LENGTH
ELSE 0 END AS Length
FROM INFORMATION_SCHEMA.COLUMNS where table_name='user' and TABLE_SCHEMA='test'
Step 4.6: after reading all the required table information, code generation is started, and each table generates 3 classes, namely an entity class EnUser. The entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 4.7: an entity template of type = 'En' in the table of orm _ template is read. And generating an entity class EnUser.cs according to the table fields read in the step 4.5.
Step 4.8: the data connection class template of type = 'Da' in the orm _ template table is read. And generating a data object operation class DaUser.cs according to the table fields read in the step 4.5.
Step 4.9: reading a data service class generation template (mysql version); and generating a service calling class BusUser.cs according to the table fields read in the step 3.5.
Step 4.10: completing the generation of the class database;
and 5: after the class database is generated, functions of increasing, deleting, modifying, checking and the like can be directly called in the project;
step 6: at the later stage, if business operations such as adding a table, modifying a table field, deleting a table field and the like exist in business adjustment, the program executes step 4 again to generate the c # class library code according to the modified data table information.
Referring to fig. 2, the present invention further provides a system capable of configuring and rapidly generating Mysql database codes, where the system includes a configuration module, an index module, a template reading module, a code production module, and a code re-production module;
the configuration module is used for setting a configuration table in a Mysql database, and the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
the index module is used for setting a database configuration index file under the project and reading configuration information according to the configuration index file;
the template reading module is used for reading template codes in a Mysql database configuration table;
and the production code module is used for generating an ORM operation code according to the configuration information and the template code.
The code re-production module is used for directly calling functions of adding, deleting, modifying and inquiring in the project after the class library is generated; and in the later stage, if the business adjustment is carried out, the business operation of adding the table, modifying the table field and deleting the table field is carried out, and the program can generate the c # database code again by one key through the step S4 according to the modified data table information.
Wherein, the index module further specifically comprises: creating an item index folder, creating a file of appname.txt under the index folder, wherein the file content is user, and the user is used for guiding which configuration information is to be read.
The production code module is realized by the following steps:
step 1.1: when a Mysql database code is generated, a program searches an appname.
Step 1.2: obtain app _ name = usermfrom appname.
Step 1.3: reading a record of app _ name = 'userorm' in an orm _ config table in a Mysql database;
step 1.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema. tables where table _ schema = 'test'", and reading out all data table names in the test database;
step 1.5: and cycling the data table, and reading all field information under the data table, wherein the all field information comprises: remarks, field serial number, field name, identification, whether a primary key is present, field type, number of occupied bytes, length, decimal number, whether null is allowed, default value and field description;
step 1.6: after reading all needed table information, starting to generate codes, wherein each table generates 3 classes, namely an entity class EnUser.cs, a data object operation class DaUser.cs and a service calling class BusUser.cs; the entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 1.7: reading an entity template with type = 'En' in an orm _ template table, and generating an entity class EnUser.cs according to all read fields in a data table;
step 1.8: reading orm _ template data connection type templates with type = 'Da' in a template table, and generating a data object operation type DaUser.cs according to all read fields in the data table;
step 1.9: reading a data service class generation template; generating a service call class BusUser.cs according to all the fields read in the data table;
step 1.10: and finishing the generation of the class database.
In conclusion, the invention designs a method for quickly generating C # operation Mysql database codes aiming at the prior art. The method comprises the following steps: 1. setting a configuration table in mysql to store configuration information; 2. setting a database configuration ID under the project, and reading configuration information according to the configuration ID; 3. reading a template code in a mysql configuration table; 4. and generating an ORM operation code according to the configuration information and the template code. The problem that unnecessary BUG is easily generated due to the fact that entity classes are manually constructed and SQL sentences are manually spliced is solved, and the working efficiency of developers is improved.
The above description is only a preferred embodiment of the present invention, and all equivalent changes and modifications made in accordance with the claims of the present invention should be covered by the present invention.
Claims (8)
1. A configurable method for quickly generating Mysql database codes is characterized in that: the method comprises the following steps:
step S1, setting a configuration table in the Mysql database, wherein the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
step S2, setting a database configuration index file under the project, and reading configuration information according to the configuration index file;
step S3, reading template codes in the Mysql database configuration table;
and step S4, generating an ORM operation code according to the configuration information and the template code.
2. The method for configurable rapid generation of Mysql database code according to claim 1, wherein: the step S2 further includes: creating an item index folder, creating a file of appname.txt under the index folder, wherein the file content is user, and the user is used for guiding which configuration information is to be read.
3. The method for configurable rapid generation of Mysql database code according to claim 1, wherein: the method further comprises the following steps: step S5, after the class library is generated, the functions of adding, deleting, modifying and inquiring can be directly called in the project; and in the later stage, if the business adjustment is carried out, the business operation of adding the table, modifying the table field and deleting the table field is carried out, and the program can generate the c # database code again by one key through the step S4 according to the modified data table information.
4. The method for configurable rapid generation of Mysql database code according to claim 1, wherein: the step S4 further includes:
step 4.1: when a Mysql database code is generated, a program searches an appname.
Step 4.2: obtain app _ name = usermfrom appname.
Step 4.3: reading a record of app _ name = 'user' in a configuration table;
step 4.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema. tables where table _ schema = 'test'", and reading out all data table names in the test database;
step 4.5: and cycling the data table, and reading all field information under the data table, wherein the all field information comprises: remarks, field serial number, field name, identification, whether a primary key is present, field type, number of occupied bytes, length, decimal number, whether null is allowed, default value and field description;
step 4.6: after reading all needed table information, starting to generate codes, wherein each table generates 3 classes, namely an entity class EnUser.cs, a data object operation class DaUser.cs and a service calling class BusUser.cs; the entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 4.7: reading an entity template with type = 'En' in an orm _ template table, and generating an entity class EnUser.cs according to all read fields in a data table;
step 4.8: reading orm _ template data connection type templates with type = 'Da' in a template table, and generating a data object operation type DaUser.cs according to all read fields in the data table;
step 4.9: reading a data service class generation template; generating a service call class BusUser.cs according to all the fields read in the data table;
step 4.10: and finishing the generation of the class database.
5. A configurable system for quickly generating Mysql database codes is characterized in that: the system comprises a configuration module, an index module, a template reading module and a code production module;
the configuration module is used for setting a configuration table in a Mysql database, and the configuration table stores configuration information; the configuration information comprises an application name, a database name and a project namespace name;
the index module is used for setting a database configuration index file under the project and reading configuration information according to the configuration index file;
the template reading module is used for reading template codes in a Mysql database configuration table;
and the production code module is used for generating an ORM operation code according to the configuration information and the template code.
6. The system of claim 5, wherein the system is configured to rapidly generate Mysql database code, and comprises: the index module is further specifically: creating an item index folder, creating a file of appname.txt under the index folder, wherein the file content is user, and the user is used for guiding which configuration information is to be read.
7. The system of claim 5, wherein the system is configured to rapidly generate Mysql database code, and comprises: the system also comprises a code re-production module which is used for directly calling the functions of adding, deleting, modifying and inquiring in the project after the class library is generated; and in the later stage, if the business adjustment is carried out, the business operation of adding the table, modifying the table field and deleting the table field is carried out, and the program can generate the c # database code again by one key through the step S4 according to the modified data table information.
8. The system of claim 5, wherein the system is configured to rapidly generate Mysql database code, and comprises: the production code module is realized by the following steps:
step 1.1: when a Mysql database code is generated, a program searches an appname.
Step 1.2: obtain app _ name = usermfrom appname.
Step 1.3: reading a record of app _ name = 'userorm' in an orm _ config table in a Mysql database;
step 1.4: obtaining db = test in the record, executing a statement "select table _ name from format _ schema. tables where table _ schema = 'test'", and reading out all data table names in the test database;
step 1.5: and cycling the data table, and reading all field information under the data table, wherein the all field information comprises: remarks, field serial number, field name, identification, whether a primary key is present, field type, number of occupied bytes, length, decimal number, whether null is allowed, default value and field description;
step 1.6: after reading all needed table information, starting to generate codes, wherein each table generates 3 classes, namely an entity class EnUser.cs, a data object operation class DaUser.cs and a service calling class BusUser.cs; the entity class EnUser.cs is used for recording the one-to-one corresponding relation between attributes and data table fields, the data object operation class DaUser.cs contains codes of an operation database, and the service call class BusUser.cs provides an entry for an adding, deleting, modifying and inquiring method for data operation;
step 1.7: reading an entity template with type = 'En' in an orm _ template table, and generating an entity class EnUser.cs according to all read fields in a data table;
step 1.8: reading orm _ template data connection type templates with type = 'Da' in a template table, and generating a data object operation type DaUser.cs according to all read fields in the data table;
step 1.9: reading a data service class generation template; generating a service call class BusUser.cs according to all the fields read in the data table;
step 1.10: and finishing the generation of the class database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010637153.2A CN111796810A (en) | 2020-07-03 | 2020-07-03 | Method and system for configurable rapid generation of Mysql database codes |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010637153.2A CN111796810A (en) | 2020-07-03 | 2020-07-03 | Method and system for configurable rapid generation of Mysql database codes |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111796810A true CN111796810A (en) | 2020-10-20 |
Family
ID=72811374
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010637153.2A Pending CN111796810A (en) | 2020-07-03 | 2020-07-03 | Method and system for configurable rapid generation of Mysql database codes |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111796810A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113190218A (en) * | 2021-04-28 | 2021-07-30 | 中国邮政储蓄银行股份有限公司 | Target operation function generation method and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005148976A (en) * | 2003-11-13 | 2005-06-09 | Canon Software Inc | Program generating device, program generating method, program, and recording medium |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN103761251A (en) * | 2013-12-26 | 2014-04-30 | 无锡冠云信息科技有限公司 | Storing and finding method for large-data-volume client information |
| CN105138326A (en) * | 2015-08-11 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Method and system for achieving structured query language (sql) dynamic configuration based on ibatis |
| CN105677323A (en) * | 2015-12-31 | 2016-06-15 | 合肥大多数信息科技有限公司 | Method for automatically generating database operation layer codes |
| CN109885291A (en) * | 2019-01-25 | 2019-06-14 | 深圳市元征科技股份有限公司 | A kind of code automatic generation method and code generator |
| CN111290748A (en) * | 2020-03-11 | 2020-06-16 | 福建天晴在线互动科技有限公司 | Method for quickly generating SqlServer database operation code |
| CN114115839A (en) * | 2022-01-28 | 2022-03-01 | 云账户技术(天津)有限公司 | ORM code processing method and device, electronic equipment and readable storage medium |
-
2020
- 2020-07-03 CN CN202010637153.2A patent/CN111796810A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005148976A (en) * | 2003-11-13 | 2005-06-09 | Canon Software Inc | Program generating device, program generating method, program, and recording medium |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN103761251A (en) * | 2013-12-26 | 2014-04-30 | 无锡冠云信息科技有限公司 | Storing and finding method for large-data-volume client information |
| CN105138326A (en) * | 2015-08-11 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Method and system for achieving structured query language (sql) dynamic configuration based on ibatis |
| CN105677323A (en) * | 2015-12-31 | 2016-06-15 | 合肥大多数信息科技有限公司 | Method for automatically generating database operation layer codes |
| CN109885291A (en) * | 2019-01-25 | 2019-06-14 | 深圳市元征科技股份有限公司 | A kind of code automatic generation method and code generator |
| CN111290748A (en) * | 2020-03-11 | 2020-06-16 | 福建天晴在线互动科技有限公司 | Method for quickly generating SqlServer database operation code |
| CN114115839A (en) * | 2022-01-28 | 2022-03-01 | 云账户技术(天津)有限公司 | ORM code processing method and device, electronic equipment and readable storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113190218A (en) * | 2021-04-28 | 2021-07-30 | 中国邮政储蓄银行股份有限公司 | Target operation function generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109840429B (en) | Intelligent contract deployment and calling method and device | |
| US5564050A (en) | System and method for enabling an interpreted programming language to be executed in a database management system environment | |
| US5586330A (en) | Programmable computer with automatic translation between source and object code | |
| US8145685B2 (en) | Object relational mapping layer | |
| US6240422B1 (en) | Object to relational database mapping infrastructure in a customer care and billing system | |
| US8402062B2 (en) | Data export/import from multiple data source to a destination data repository using corresponding data exporters and an importer | |
| US6453310B1 (en) | Installable schema for low-overhead databases | |
| US7111016B2 (en) | Method and apparatus for data item movement between disparate sources and hierarchical, object-oriented representation | |
| EP0360387A2 (en) | Data base management system | |
| CN114096956A (en) | Method and device for representing database operation layer | |
| CN111290748B (en) | Method for quickly generating SqlServer database operation code | |
| CN115543402A (en) | Software knowledge graph increment updating method based on code submission | |
| US20060136471A1 (en) | Differential management of database schema changes | |
| CN111796810A (en) | Method and system for configurable rapid generation of Mysql database codes | |
| CN114238527A (en) | Data processing method and data processing device based on object relation mapping | |
| CN114443015A (en) | Method for generating adding, deleting, modifying and checking service interface based on database metadata | |
| JP2001325098A (en) | Method for preparing application program method for operating database, method for managing item object, method for controlling module operation and computer- readable recording medium recorded with program for realizing operation, management and control methods | |
| CN113918602A (en) | Data caching method and device and electronic equipment | |
| CN111782195A (en) | Query method based on adding annotation on request parameter and splicing into SQL | |
| CN108090034B (en) | Cluster-based uniform document code coding generation method and system | |
| CN112783927B (en) | Database query method and system | |
| CN114969215A (en) | Method for automatically loading data in batches on data warehouse source layer and related equipment | |
| CN114138815A (en) | Multi-database compatibility implementation method, device and medium for application program | |
| CN113761040A (en) | Database and application program bidirectional mapping method, device, medium and program product | |
| CN116627390B (en) | ICD file substitution method and device in aviation software development |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201020 |