CN111026389A - Automatic building method and system of WEB framework platform software based on JDBC database connection technology - Google Patents
Automatic building method and system of WEB framework platform software based on JDBC database connection technology Download PDFInfo
- Publication number
- CN111026389A CN111026389A CN201911085478.8A CN201911085478A CN111026389A CN 111026389 A CN111026389 A CN 111026389A CN 201911085478 A CN201911085478 A CN 201911085478A CN 111026389 A CN111026389 A CN 111026389A
- Authority
- CN
- China
- Prior art keywords
- configuration
- database
- template
- module
- layer
- 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
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
- G06F8/36—Software reuse
-
- 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/21—Design, administration or maintenance of databases
-
- 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
- G06F8/35—Creation or generation of source code model driven
Abstract
The invention discloses an automatic building method and an automatic building system of WEB frame platform software based on JDBC database connection technology, which belong to the technical field of database development, wherein the method is based on a JDBC database connection technology mapping method, reads a table of a database through DriveManager database management service, acquires data information related to a table field name and a data type, matches the data information by configuring a project structure path, executes project generation logic, and creates a WEB platform system basic application function; configuring basic data building of platform software, implementation layer logic of the platform software, service layer logic of the platform software and a service calling relation of a view layer to a control layer; the system comprises a database configuration module, a framework configuration module, a template setting module, a generation module and a storage module. The invention can more effectively carry out unified specification of codes and reduce unnecessary resource waste of research personnel.
Description
Technical Field
The invention relates to the technical field of database development, in particular to a method and a system for automatically building WEB framework platform software based on JDBC database connection technology.
Background
There is a large amount of code that may be involved in the development of a software project, and for these specifications and iterations, a pattern that can be generated directly is needed to reduce unnecessary time waste during development and reduce the error rate of the code. At present, various development tools may integrate partial code generation tools, but only a small part of the development tools is often involved, and the front-end and back-end connection of a project still needs to be manually edited and associated to achieve the effect of practical application.
The codes of the existing tools also have many disadvantages, for example, when the codes are generated for the second time, the secondary generated part is added on the basis of the original codes, and in such a case, the codes still need to be sorted again by individuals, which causes unnecessary resource waste.
Disclosure of Invention
Aiming at the defects, the invention provides the automatic building method and the system of the WEB framework platform software based on the JDBC database connection technology, so that the unified specification of codes can be more effectively carried out, and unnecessary resource waste of research personnel can be reduced.
The technical scheme adopted by the invention for solving the technical problems is as follows:
a method for automatically building WEB frame platform software based on JDBC database connection technology is characterized in that a JDBC database connection technology mapping method is used, a table of a database is read through a DriveManager database management service, data information related to a table field name and a data type is obtained, a project structure path is configured and matched with the data information, project generation logic is executed, and a WEB platform system basic application function is built; the configuration comprises the construction of basic data of platform software, the realization layer logic of the platform software, the service layer logic of the platform software and the service calling relation of a view layer to a control layer.
Further, the method comprises the steps of configuring a database, configuring a framework and configuring a template,
database configuration, namely selecting corresponding database configuration in a generating module by integrating various database connection modes and related driving programs, reading related database data, and generating system codes by database fields;
frame configuration, namely uniformly configuring related paths of the project architecture, wherein the related paths comprise a rear-end frame and a front-end page structure frame;
template configuration, which is to configure corresponding framework structure for the database to set template configuration;
and combining the basic configuration of database configuration, framework configuration and template configuration to generate project codes conforming to the plan, previewing the generated codes in a self-contained container, finely adjusting to realize accurate effect, directly pointing the generated codes to the project, quickly storing the codes to a corresponding path, and avoiding complex operations such as copying again.
Further, the method comprises the following concrete implementation steps:
1) the system provides a data source registration tool, selects different types of databases, sets different versions and connection information of the databases, and calls a logic program to create database connection;
2) setting the created data table according to the registration information, and automatically extracting the relevant information of the data table by a back-end program;
3) calling the Entity configuration in the configuration information, generating a platform system Entity logic, and completing basic data construction of platform software;
4) calling Mapper configuration in the configuration information, and generating a corresponding data query interface and data query xml by combining the read data information with template library data of the Mapper so as to complete the implementation layer logic of the platform software;
5) calling Service configuration in the configuration information, calling Service layer template database data, and completing Service layer logic of platform software through matching with a Mapper layer interface;
6) calling Controller configuration in the configuration information, calling control layer template database data, matching with a Service layer interface, and generating calling configuration with a view layer;
7) and calling the View configuration in the configuration information, calling the View layer template database data, and generating a View display interface corresponding to the connection configuration of the control layer, wherein the View layer calls the service of the control layer.
Specifically, the different types of databases include large common databases such as orcale, sqlserver, and mysql.
Specifically, the backend program automatically extracts the relevant information of the database table, including the main foreign key, the field name, the length, the type and the registration field information.
Preferably, the generated code includes JAVA, SQL, JAVASCRIPT, XML, HTML, and CSS,
generating a JAVA back-end code, wherein the JAVA back-end code comprises a control layer, a service layer, a realization layer and a persistence layer of a scope project framework through a JAVA template;
JAVASCRIPT code generation, namely generating function call and callback function processing required by a view layer through a JAVASCRIPT template;
generating an XML code, wherein the XML code comprises a table, a basic statement, a result set and a search configuration which are called by a database through an XML template;
and generating CSS codes, and generating the required style processing of the view layer through a CSS template.
The invention also claims an automatic building system of WEB frame platform software based on JDBC database connection technology, which comprises a database configuration module, a frame configuration module, a template setting module, a generation module and a storage module,
the database configuration module is used for selecting corresponding database configuration in the generation module by integrating various database link modes and related driving programs, reading related database processing and generating system codes by database fields;
the framework configuration module is used for uniformly configuring related paths of the project architecture;
the template setting module is used for setting corresponding template configuration for the corresponding frame structure of the database configuration module;
the generating module is used for generating project codes conforming to the plan by combining the basic configuration of the database configuration module, the framework configuration module and the template setting module;
and the storage module is used for directly pointing the code generated by the generation module to the project, quickly storing the code to the corresponding path and avoiding the complex operations such as copying again.
Specifically, the project framework comprises a back-end framework and a front-end page structure framework.
Preferably, the project code generated by the generation module is previewed in the self-contained container and is finely adjusted to achieve an accurate effect.
Preferably, the generation module code generator generates a code range including JAVA, SQL, JAVASCRIPT, XML, HTML, and CSS,
generating a JAVA back-end code, wherein the JAVA back-end code comprises a control layer, a service layer, a realization layer and a persistence layer of a scope project framework through a JAVA template;
JAVASCRIPT code generation, namely generating function call and callback function processing required by a view layer through a JAVASCRIPT template;
generating an XML code, wherein the XML code comprises a table, a basic statement, a result set and a search configuration which are called by a database through an XML template;
and generating CSS codes, and generating the required style processing of the view layer through a CSS template.
Compared with the prior art, the automatic building method and the system of the WEB framework platform software based on the JDBC database connection technology have the following beneficial effects:
the method and the system can reduce unnecessary resource waste of research personnel, more effectively carry out unified specification of codes, and can directly realize a certain functional module through one-key generation, and the front end and the rear end are directly called and associated, thereby generating a complete functional module and achieving the effect of on-line use only by finely adjusting special service functions.
Drawings
FIG. 1 is a diagram of an automatic building system structure of JDBC database connection technology-based WEB framework platform software according to the present invention;
FIG. 2 is a flow chart of an automatic building method of JDBC database connection technology-based WEB framework platform software.
Detailed Description
The invention is further described with reference to the following figures and specific examples.
Example one
A method for automatically building WEB frame platform software based on JDBC database connection technology is characterized in that a method driver manager register is called to register the software by a method driver manager database management service based on a JDBC database connection technology mapping method, and for simple application programs, only a method driver manager getconnection (the method is used for building connection with a database) is needed. And reading the table of the database, acquiring the data information related to the table field name and the data type, matching the data information with the project structure path, executing project generation logic and establishing the basic application function of the WEB platform system.
The configuration comprises the construction of basic data of platform software, the realization layer logic of the platform software, the service layer logic of the platform software and the service calling relation of a view layer to a control layer.
The method comprises the following steps of database configuration, framework configuration and template configuration:
database configuration, namely selecting corresponding database configuration in a generating module by integrating various database connection modes and related driving programs, reading related database data, and generating system codes by database fields;
frame configuration, namely uniformly configuring related paths of the project architecture, wherein the related paths comprise a rear-end frame and a front-end page structure frame;
template configuration, which is to configure corresponding framework structure for the database to set template configuration;
and combining the basic configuration of database configuration, framework configuration and template configuration to generate project codes conforming to the plan, previewing the generated codes in a self-contained container, finely adjusting to realize accurate effect, directly pointing the generated codes to the project, quickly storing the codes to a corresponding path, and avoiding complex operations such as copying again.
The generated code includes JAVA, SQL, JAVASCRIPT, XML, HTML, and CSS,
generating a JAVA back-end code, wherein the JAVA back-end code comprises a control layer, a service layer, a realization layer and a persistence layer of a scope project framework through a JAVA template;
JAVASCRIPT code generation, namely generating function call and callback function processing required by a view layer through a JAVASCRIPT template;
generating an XML code, wherein the XML code comprises a table, a basic statement, a result set and a search configuration which are called by a database through an XML template;
and generating CSS codes, and generating the required style processing of the view layer through a CSS template.
The method comprises the following concrete implementation steps:
1. the system provides a data source registration tool, selects different types of databases, supports large common databases such as orcale, sqlserver, mysql and the like, sets different versions and connection information of the databases, and calls a logic program to create database connection;
2. setting the created data table according to the registration information, and automatically extracting relevant information of the data table by a back-end program, wherein the relevant information comprises field information such as a main foreign key, field names, lengths, types and registrations;
3. calling the Entity configuration in the configuration information, generating platform system Entity logic, and completing basic data construction of platform software;
4. calling Mapper configuration in the configuration information, and generating a corresponding data query interface and data query xml by combining the read data information with template library data of the Mapper so as to complete the implementation layer logic of the platform software;
5. calling Service configuration in the configuration information, calling Service layer template database data, and completing Service layer logic of platform software through matching with a Mapper layer interface;
6. calling Controller configuration in the configuration information, calling control layer template database data, matching with a Service layer interface, and generating calling configuration with a view layer;
7. and calling the View configuration in the configuration information, calling the View layer template database data, and generating a View display interface corresponding to the connection configuration of the control layer, wherein the View layer calls the service of the control layer.
The method directly achieves the purpose of realizing a certain function module through one-key generation, and the front end and the rear end are directly called and associated, so that a complete function module is generated, the effect of online use can be achieved only by finely adjusting the special service function, unnecessary resource waste of research personnel can be reduced, and the unified specification of codes can be more effectively carried out.
Example two
An automatic building system of WEB frame platform software based on JDBC database connection technology comprises a database configuration module, a frame configuration module, a template setting module, a generation module and a storage module.
And the database configuration module is used for selecting corresponding database configuration in the generation module by integrating various database link modes and related driving programs, reading related database processing and generating system codes by database fields.
And the frame configuration module is used for uniformly configuring related paths of the project architecture and comprises a back-end frame and a front-end page structure frame.
And the template setting module is used for setting corresponding template configuration for the corresponding frame structure of the database configuration module.
And the generating module is combined with the basic configuration of the database configuration module, the frame configuration module and the template setting module to generate project codes conforming to the plan, and the generated codes are previewed in a container, so that fine adjustment can be performed to realize an accurate effect.
And the storage module is used for directly pointing the code generated by the generation module to the project, quickly storing the code to the corresponding path and avoiding the complex operations such as copying again.
In the code generator, the generating range comprises JAVA, SQL, JAVASCRIPT, XML and HTML, CSS,
generating a JAVA back-end code, wherein the JAVA back-end code comprises a control layer, a service layer, a realization layer and a persistence layer of a scope project framework through a JAVA template;
JAVASCRIPT code generation, namely generating function call and callback function processing required by a view layer through a JAVASCRIPT template;
generating an XML code, wherein the XML code comprises a table, a basic statement, a result set and a search configuration which are called by a database through an XML template;
and generating CSS codes, and generating the required style processing of the view layer through a CSS template.
The system is shown in the block diagram of fig. 1.
The present invention can be easily implemented by those skilled in the art from the above detailed description. It should be understood, however, that the intention is not to limit the invention to the particular embodiments described. On the basis of the disclosed embodiments, a person skilled in the art can combine different technical features at will, thereby implementing different technical solutions.
In addition to the technical features described in the specification, the technology is known to those skilled in the art.
Claims (10)
1. A method for automatically building WEB frame platform software based on JDBC database connection technology is characterized in that the method is based on a JDBC database connection technology mapping method, reads a table of a database through DriveManager database management service, acquires data information related to a table field name and a data type, matches the data information through configuring a project structure path, executes project generation logic and builds a WEB platform system basic application function; the configuration comprises the construction of basic data of platform software, the realization layer logic of the platform software, the service layer logic of the platform software and the service calling relation of a view layer to a control layer.
2. The JDBC database connection technology-based WEB framework platform software automatic construction method of claim 1, wherein the method comprises database configuration, framework configuration and template configuration,
database configuration, namely selecting corresponding database configuration in a generating module by integrating various database connection modes and related driving programs, reading related database data, and generating system codes by database fields;
framework configuration, namely uniformly configuring related paths of the project architecture;
template configuration, which is to configure corresponding framework structure for the database to set template configuration;
and combining the basic configuration of database configuration, framework configuration and template configuration to generate a project code conforming to the plan, wherein the generated code directly points to the project and is quickly stored to a corresponding path.
3. The automatic building method of JDBC database connection technology-based WEB framework platform software according to claim 1 or 2, wherein the specific implementation steps of the method are as follows:
1) the system provides a data source registration tool, selects different types of databases, sets different versions and connection information of the databases, and calls a logic program to create database connection;
2) setting the created data table according to the registration information, and automatically extracting the relevant information of the data table by a back-end program;
3) calling the Entity configuration in the configuration information, generating a platform system Entity logic, and completing basic data construction of platform software;
4) calling Mapper configuration in the configuration information, and generating a corresponding data query interface and data query xml by combining the read data information with template library data of the Mapper so as to complete the implementation layer logic of the platform software;
5) calling Service configuration in the configuration information, calling Service layer template database data, and completing Service layer logic of platform software through matching with a Mapper layer interface;
6) calling Controller configuration in the configuration information, calling control layer template database data, matching with a Service layer interface, and generating calling configuration with a view layer;
7) and calling the View configuration in the configuration information, calling the View layer template database data, and generating a View display interface corresponding to the connection configuration of the control layer, wherein the View layer calls the service of the control layer.
4. The method of claim 3, wherein the different types of databases include orcale, sqlserver, and mysql.
5. The method of claim 3, wherein the backend program automatically extracts relevant information of the database table including a main foreign key, a field name, a length, a type, and registration field information.
6. The method for automatically building JDBC database connection technology-based WEB framework platform software according to claim 1 or 2, wherein the generated code includes JAVA, SQL, JAVASCRIPT, XML, HTML and CSS.
7. An automatic building system of WEB frame platform software based on JDBC database connection technology is characterized by comprising a database configuration module, a frame configuration module, a template setting module, a generation module and a storage module,
the database configuration module is used for selecting corresponding database configuration in the generation module by integrating various database link modes and related driving programs, reading related database processing and generating system codes by database fields;
the framework configuration module is used for uniformly configuring related paths of the project architecture;
the template setting module is used for setting corresponding template configuration for the corresponding frame structure of the database configuration module;
the generating module is used for generating project codes conforming to the plan by combining the basic configuration of the database configuration module, the framework configuration module and the template setting module;
and the storage module is used for directly pointing the code generated by the generation module to the project and quickly storing the code to the corresponding path.
8. The system of claim 7, wherein the project framework comprises a back-end framework and a front-end page structure framework.
9. The automatic building method of JDBC database connection technology-based WEB framework platform software according to claim 7, wherein the project code generated by the generation module is previewed and fine-tuned in its own container.
10. The method of automatically building JDBC database connection technology based WEB framework platform software according to claim 7 or 9, wherein the generation scope of the generation module code generator includes JAVA, SQL, JAVASCRIPT, XML, HTML and CSS,
generating a JAVA back-end code, wherein the JAVA back-end code comprises a control layer, a service layer, a realization layer and a persistence layer of a scope project framework through a JAVA template;
JAVASCRIPT code generation, namely generating function call and callback function processing required by a view layer through a JAVASCRIPT template;
generating an XML code, wherein the XML code comprises a table, a basic statement, a result set and a search configuration which are called by a database through an XML template;
and generating CSS codes, and generating the required style processing of the view layer through a CSS template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911085478.8A CN111026389A (en) | 2019-11-08 | 2019-11-08 | Automatic building method and system of WEB framework platform software based on JDBC database connection technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911085478.8A CN111026389A (en) | 2019-11-08 | 2019-11-08 | Automatic building method and system of WEB framework platform software based on JDBC database connection technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111026389A true CN111026389A (en) | 2020-04-17 |
Family
ID=70201009
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911085478.8A Pending CN111026389A (en) | 2019-11-08 | 2019-11-08 | Automatic building method and system of WEB framework platform software based on JDBC database connection technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111026389A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115712413A (en) * | 2022-11-15 | 2023-02-24 | 广东中设智控科技股份有限公司 | Low code development method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160041815A1 (en) * | 2014-08-11 | 2016-02-11 | Chirag P. Bhagat | Computer Source Code Generator for Building Software Applications |
| CN105824619A (en) * | 2016-03-10 | 2016-08-03 | 四川交通职业技术学院 | Code generator integrated based on Spring MVC framework, Apache Shiro framework and MyBatis framework |
| CN106873969A (en) * | 2016-12-29 | 2017-06-20 | 广州凯耀资产管理有限公司 | A kind of development approach and development platform of J2EE projects |
| CN107273116A (en) * | 2017-05-22 | 2017-10-20 | 互联天下科技发展（深圳）有限公司 | The method that code is produced using the Code Generator based on framework |
| CN109240661A (en) * | 2018-08-02 | 2019-01-18 | 武汉烽火众智数字技术有限责任公司 | A kind of code generating method and device |
| CN109634593A (en) * | 2018-04-17 | 2019-04-16 | 广东电网有限责任公司 | A kind of code automatic generation method |
| CN110069246A (en) * | 2019-03-28 | 2019-07-30 | 北京众智益成科技有限公司 | The plateform system and its application that a kind of Java Web application is quickly developed |
| CN110147225A (en) * | 2019-04-02 | 2019-08-20 | 平安科技（深圳）有限公司 | A kind of code generating method, device and computer equipment, storage medium |
-
2019
- 2019-11-08 CN CN201911085478.8A patent/CN111026389A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160041815A1 (en) * | 2014-08-11 | 2016-02-11 | Chirag P. Bhagat | Computer Source Code Generator for Building Software Applications |
| CN105824619A (en) * | 2016-03-10 | 2016-08-03 | 四川交通职业技术学院 | Code generator integrated based on Spring MVC framework, Apache Shiro framework and MyBatis framework |
| CN106873969A (en) * | 2016-12-29 | 2017-06-20 | 广州凯耀资产管理有限公司 | A kind of development approach and development platform of J2EE projects |
| CN107273116A (en) * | 2017-05-22 | 2017-10-20 | 互联天下科技发展（深圳）有限公司 | The method that code is produced using the Code Generator based on framework |
| CN109634593A (en) * | 2018-04-17 | 2019-04-16 | 广东电网有限责任公司 | A kind of code automatic generation method |
| CN109240661A (en) * | 2018-08-02 | 2019-01-18 | 武汉烽火众智数字技术有限责任公司 | A kind of code generating method and device |
| CN110069246A (en) * | 2019-03-28 | 2019-07-30 | 北京众智益成科技有限公司 | The plateform system and its application that a kind of Java Web application is quickly developed |
| CN110147225A (en) * | 2019-04-02 | 2019-08-20 | 平安科技（深圳）有限公司 | A kind of code generating method, device and computer equipment, storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115712413A (en) * | 2022-11-15 | 2023-02-24 | 广东中设智控科技股份有限公司 | Low code development method, device, equipment and storage medium |
| CN115712413B (en) * | 2022-11-15 | 2024-04-19 | 广东中设智控科技股份有限公司 | Low code development method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| CN100468396C (en) | Mapping architecture for arbitrary data models | |
| US20070271548A1 (en) | Specification to abap code converter | |
| US7831614B2 (en) | System and method for generating SQL using templates | |
| CN104793961A (en) | Quick JavaWeb development method and system using native Web codes | |
| CN113886362A (en) | Data storage system and storage method based on workflow engine and low-code platform | |
| CN110543303A (en) | Visual business platform | |
| CN116955399A (en) | Unified SQL query method, system and medium based on Calcite | |
| EA200500692A1 (en) | SYSTEM AND METHOD OF AUTOMATIC GENERATION OF SPECIFICATION OF TOOLS USING LOGICAL OPERATIONS UTILITY WHICH CAN BE USED FOR GENERATING ORDER ON PHOTOMASK | |
| CN111026389A (en) | Automatic building method and system of WEB framework platform software based on JDBC database connection technology | |
| CN114443015A (en) | Method for generating adding, deleting, modifying and checking service interface based on database metadata | |
| CN113434133B (en) | Application building method, device, equipment and computer readable storage medium | |
| US7844601B2 (en) | Quality of service feedback for technology-neutral data reporting | |
| CN115114325B (en) | Data query method and device, electronic equipment and storage medium | |
| CN112783915A (en) | Data transmission object mapping method and unit based on SpringMVC + Mybatis framework | |
| CN104731597A (en) | Method for applying SQL statements to engineering software compiling platform | |
| CN114461454A (en) | Data recovery method and device, storage medium and electronic equipment | |
| CN112825068B (en) | Data blood margin generation method and device | |
| CN109032578A (en) | Based on database SQL code generating method and system | |
| CN116226066B (en) | Low code platform code synchronization method and device, electronic equipment and storage medium | |
| CN114168110B (en) | Application development transaction management system and method for lightweight class Hongmon operating system | |
| CN114461633A (en) | Application development tool system | |
| CN117472335A (en) | Job development architecture, job processing method, storage medium, and electronic device | |
| KR0175579B1 (en) | Version Control Method of Object-Oriented SDL Specification | |
| CN117971933A (en) | Method for data service low code |
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 |