CN116719823A - Business system development method and device - Google Patents

Abstract

The disclosure relates to a service system development method and device, wherein the method comprises the following steps: carrying out data structure definition and initialization data definition through XML, and generating an XML definition file containing database definition information; when the system is started, the actual difference between the XML definition file and the operation database is automatically detected, and the database is automatically updated; automatically generating JAVA operation class according to the XML definition file through a generator; and accessing the database through the JAVA operation class. The method and the device automatically update the database when the system is started, and are beneficial to keeping consistency of the codes and the final database structure definition.

Description

Business system development method and device

Technical field

This document relates to the field of computer technology, especially business system development methods and devices.

Background technique

Database technology is an important part of current computer software development, providing software with space for storing and managing various types of data resources. The performance of the database affects the fluency and adaptability of the software. A well-designed database can ensure the stable use of the software.

At present, basically all software development frameworks directly operate the database to define and enter initial data when developing business systems, such as Oracle, SQL Server, etc., and export SQL as the initial structure. This type of operation method cannot adapt to the rapid iteration and changes of software projects. Especially after users have gone online and generated business data, each iterative upgrade requires the system administrator to manually upgrade the database. The database structure and its initial data are not part of the business code.

Based on the above analysis of the development status of this technical field, the existing software development system lacks a database processing method that can automatically match code upgrades.

Contents of the invention

The purpose of the present invention is to provide a business system development method and device, aiming to solve the above problems in the prior art.

According to a first aspect of an embodiment of the present disclosure, a business system development method is provided, including:

Use XML to define data structures and initialize data, and generate XML definition files containing database definition information;

When the system starts, it automatically detects the actual differences between the XML definition file and the running database, and automatically updates the database;

Automatically generate JAVA operation classes based on XML definition files through the generator;

Access the database through JAVA operation classes.

According to a second aspect of the embodiment of the present disclosure, a business system development device is provided, including:

The definition module is used to define data structure and initialize data definition through XML, and generate XML definition files containing database definition information;

The update module is used to automatically detect the differences between the XML definition file and the running database when the system starts, and automatically update the database;

The generation module is used to automatically generate JAVA operation classes based on XML definition files through the generator;

Access module, used for database access through JAVA operation classes.

The technical solution provided by the embodiments of the present disclosure can include the following beneficial effects: data structure definition and initial data definition can be carried out through simple extensible markup language, and the database can be automatically compared and updated at startup, and operators no longer need to manually modify it. , and can directly generate the correct form that can be operated by the system, ensuring the consistency and integrity of data and code without affecting the normal use of the system.

It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only, and do not limit the present disclosure.

Description of the drawings

In order to more clearly illustrate one or more embodiments of this specification or technical solutions in the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, in the following description The drawings are only some of the embodiments recorded in this specification. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without exerting any creative effort.

Figure 1 is a flow chart of a business system development method according to an embodiment of the present invention;

Figure 2 is a schematic diagram of the principle of the business system development method according to the embodiment of the present invention;

Figure 3 is a schematic diagram of a business system development device according to an embodiment of the present invention.

Detailed ways

In order to enable those skilled in the art to better understand the technical solutions in one or more embodiments of this specification, the following will describe the technical solutions in one or more embodiments of this specification in conjunction with the drawings in one or more embodiments of this specification. The technical solution is described clearly and completely. Obviously, the described embodiments are only a part of the embodiments of this specification, rather than all the embodiments. Based on one or more embodiments of this specification, all other embodiments obtained by those of ordinary skill in the art without creative efforts should fall within the protection scope of this document.

Method Example

According to an embodiment of the present invention, a business system development method is provided. Figure 1 is a flow chart of the business system development method of the embodiment of the present invention. As shown in Figure 1, the business system development method according to the embodiment of the present invention specifically includes:

In step S110, data structure definition and initialization structure definition are performed through XML, and an XML definition file containing database definition information is generated. Database structure definition specifically includes: database type definition and database table structure definition.

In step S110, the type structures of various databases are defined through the fieldType-xxx.xml file; the database table structure is defined by freely dividing modules, and the divided modules are defined in different xml files and tabled according to predetermined rules. Define inheritance.

Step S110 involves initialization. The specific inheritance method is: after a table inherits an abstract table, when building a database, it merges fields with its own definition and the definition of the inherited abstract table to create the table; define the primary key in the abstract table and/or the inherited table. , if the inherited entity defines a primary key, the primary key of the abstract entity is not used; non-abstract tables are allowed to be inherited. If a non-abstract table is inherited, the inherited table must be defined first; if multiple abstract entities are inherited, use commas to separate them; If there is no auxiliary field, it will be added automatically when creating the table. If you do not want the auxiliary field, add: auxiliary="false".

In step S120, when the system starts, the actual difference between the XML definition file and the running database is automatically detected, and the database is automatically updated.

In step S120, when the system starts, connect to the database through the database check engine, print the basic information of the database, obtain all table names and their field information from the database; obtain the XML definition file in XML, and convert the XML definition file into Compare and update the database definition information with the actual table and field information of the database, and change and update the index.

Step S120 changes and updates the index specifically including: if the table in the database does not exist, create the table; if the field in the database does not exist, add a new field; if the field in the database exists, in addition to the field length, update the remarks information, and prompt the user for other inconsistencies; if the field that exists in the database does not exist in the XML definition file, it will not be deleted directly, but will prompt the user; delete indexes that are not defined in the XML definition file; add new ones in the XML definition file index of.

In step S130, the JAVA operation class is automatically generated according to the XML definition file through the generator;

In step S140, the database is accessed through the JAVA operation class.

To sum up, the above technical solution of the embodiment of the present invention proposes a business system development method that defines various database type structures through fieldType-xxx.xml files to adapt to multiple database structures, and automatically matches and updates steps to allow system development The development code maintains a strong correlation with the information contained in the database, reducing the number of manual changes to the database structure by technicians, and can be directly recognized as a software executable pattern through the generator, thereby enabling system-related operations.

The above technical solutions of the embodiments of the present invention are illustrated with examples below.

Figure 2 is a schematic principle diagram of the business system development method according to the embodiment of the present invention. As shown in Figure 2, it shows the logical structure of business system development. It adapts to multiple database structures through fieldType-xxx.xml, freely divides business modules, and The database is defined into different xml files. The system starts the database check engine to identify the data definition update, automatically synchronizes the actual database, and uses the code generator to quickly generate database entity objects in code development. Finally, the database access engine is used to conveniently and quickly operate the database.

The database type definition mainly implements a classification key identifier type, a database field type sql-type, and a type java-type mapped to the java code. This mapping can be arbitrarily extended and defined according to business needs, such as defining a char-1, char-2 etc. The database checking engine will automatically check the database structure based on the intermediate mapping relationship, and the code generator engine will generate code objects based on the mapping relationship.

The definition of database tables can be divided into modules arbitrarily. For example, the basic module is defined in a.xml, and the business system is defined in b.xml. The database check engine supports table definition inheritance, such as defining a person table, and then personA The inheritable table person only needs to add redundant field definitions. Person can be regarded as an abstract table, and personA can be regarded as an inheritance table. The purpose of the abstract table is to simplify the definition of the table in XML, but it cannot simplify the definition in the database.

The definitions of abstract tables, integrated tables and primary keys are as follows: the abstract table itself can also inherit the abstract table through extends, which does not simplify the definition in the database. After a table inherits the abstract table, it will be included in the database when building the database. The definitions of the fields and the definitions of the inherited abstract tables are merged to create the table.

The primary key can be defined in an abstract table or in an inherited table. If the inherited entity defines a primary key, the primary key of the abstract entity will not be used;

<abstract-entity abstract-entity-name="ABSTRACT_ARCHIVE" title="Abstract table: xxxx">

<field name="archive_ex_id" type="id-ne" description="ID"/>

<prim-key field="archive_ex_id"/>

</abstract-entity>

You can inherit non-abstract tables. If you inherit a non-abstract table, you must ensure that the inherited table is defined first; if you inherit multiple abstract entities, use commas to separate them; if there are no auxiliary fields, the following will be added automatically when creating the table: creator, creator_user_id, create_time, last_modified, last_modified_user_id, last_modified_do, last_time, see: ModelReader.readEntityDefFile

If you do not want auxiliary fields, add: auxiliary="false"

Database index check mainly includes the following steps:

A. Connect to the database and print the basic information of the database;

B. Obtain all table names and field information from the database;

C. Obtain the database definition information in XML;

D. Compare and update the definition information with the actual table and field information of the database

① If the table does not exist, create the table first, including remark information;

②If the field does not exist, add a new field, including default value, remarks and other information

③ If the field exists, in addition to the field length, the remarks and other information will be updated, and a prompt will be issued for other inconsistencies;

④ If the field does not exist in the XML and exists in the database, a prompt will be issued without directly deleting it;

A. Check for index changes and update

①Delete indexes that are no longer defined in XML;

② Add new indexes in XML;

The code generator can be described as a tool that is based on XML database definition files, selects specified table definitions, and automatically generates related back-end java class files and front-end access files such as Vue, js, jsp, etc. This tool can define metastructures based on data , quickly generate more than 70% of the code, significantly reducing development costs.

System embodiment

According to an embodiment of the present invention, a business system development device is provided. Figure 3 is a block diagram of the business system development device according to the embodiment of the present invention. As shown in Figure 3, the block diagram of the business system development device according to the embodiment of the present invention specifically includes:

The definition module 30 is used to define data structure and initialize data definition through XML, and generate an XML definition file containing database definition information. The database structure definition module is used to define the type structure of various databases through fieldType-xxx.xml files; the database table definition module is used to define the database table structure by freely dividing modules, and divide the divided modules into different xml files Define and inherit table definitions according to predetermined rules;

After a table inherits an abstract table, when building the database, its own definition and the definition of the inherited abstract table are combined into fields to create the table; define the primary key in the abstract table and/or the inherited table. If the inherited entity defines a primary key, then The primary key of abstract entities is not used; non-abstract tables are allowed to be inherited. If a non-abstract table is inherited, the inherited table must be defined first; if multiple abstract entities are inherited, use commas to separate them; if there are no auxiliary fields, they will be automatically created when the table is created. Add, if you do not want auxiliary fields, add: auxiliary="false".

The update module 32 is used to automatically detect differences between the XML definition file and the running database when the system is started, and automatically update the database.

The update module 32 first obtains the sub-module, which is used to connect to the database through the database check engine when the system starts, prints the basic information of the database, and obtains all table names and field information from the database; then updates the sub-module, which is used to obtain the XML XML definition file, compare and update the database definition information in the XML definition file with the actual table and field information of the database, and change and update the index.

In the update module 32, if the table in the database does not exist, create the table; if the field in the database does not exist, add a new field; if the field in the database exists, except for the field length, update the remark information and other inconsistencies. Issue a prompt to the user; if the fields that exist in the database do not exist in the XML definition file, do not delete them directly, but issue a prompt to the user; delete indexes that are not defined in the XML definition file; add new indexes in the XML definition file.

The generation module 34 is used to automatically generate JAVA operation classes according to the XML definition file through the generator;

The access module 36 is used to access the database through JAVA operation classes.

The embodiment of the present invention is a system embodiment corresponding to the above method embodiment. The specific operations of each module can be understood with reference to the description of the method embodiment, and will not be described again here.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention, but not to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: The technical solutions described in the foregoing embodiments can still be modified, or some or all of the technical features can be equivalently replaced; and these modifications or substitutions do not deviate from the essence of the corresponding technical solutions from the technical solutions of the embodiments of the present invention. scope.

Claims (10)

1. A business system development method, characterized by including: Use XML to define data structures and initialize data, and generate XML definition files containing database definition information; When the system starts, it automatically detects the actual differences between the XML definition file and the running database, and automatically updates the database; Automatically generate JAVA operation classes based on XML definition files through the generator; Access the database through JAVA operation classes. 2. The method according to claim 1, characterized in that the data structure definition specifically includes: database type definition and database table structure definition. 3. The method according to claim 1, characterized in that the data structure definition and initialization data definition through XML specifically include: Define the type structure of various databases through the fieldType-xxx.xml file; By freely dividing modules, the database table structure is defined, the divided modules are defined in different xml files, and the table definition is inherited according to predetermined rules. 4. The method according to claim 3, wherein the inheritance of table definitions according to predetermined rules specifically includes: After a table inherits an abstract table, when building the database, its own definition and the definition of the inherited abstract table are combined into fields to create the table; define the primary key in the abstract table and/or the inherited table. If the inherited entity defines a primary key, then The primary key of abstract entities is not used; non-abstract tables are allowed to be inherited. If a non-abstract table is inherited, the inherited table must be defined first; if multiple abstract entities are inherited, use commas to separate them; if there are no auxiliary fields, they will be automatically created when creating the table. Add, if you do not want auxiliary fields, add: auxiliary="false". 5. The method according to claim 1, characterized in that, when the system is started, automatically detecting the actual difference between the XML definition file and the running database, and automatically updating the database specifically includes: When the system starts, connect to the database through the database check engine, print the basic information of the database, and obtain all table names and field information from the database; Obtain the XML definition file in the XML, compare and update the database definition information in the XML definition file with the actual table and field information of the database, and change and update the index. 6. The method according to claim 4, characterized in that comparing and updating the database definition information in the XML definition file with the actual table and field information of the database, and changing and updating the index specifically includes: If the table in the database does not exist, create the table; If the field does not exist in the database, add the field; If the field in the database exists, except for the field length, the remark information is updated, and the user is prompted for other inconsistencies; If a field that exists in the database does not exist in the XML definition file, it will not be deleted directly and a prompt will be issued to the user; Delete indexes that are not defined in the XML definition file; Add the new index in the XML definition file. 7. A business system development device, characterized by including: The definition module is used to define data structure and initialize data definition through XML, and generate XML definition files containing database definition information; The update module is used to automatically detect the differences between the XML definition file and the running database when the system starts, and automatically update the database; The generation module is used to automatically generate JAVA operation classes based on XML definition files through the generator; Access module, used for database access through JAVA operation classes. 8. The device according to claim 6, characterized in that, The definition module specifically includes: The database structure definition module is used to define the type structure of various databases through the fieldType-xxx.xml file; The database table definition module is used to define the database table structure by freely dividing modules, define the divided modules in different xml files, and inherit the table definition according to predetermined rules; The update module specifically includes: The acquisition submodule is used to connect to the database through the database check engine when the system starts, print the basic information of the database, and obtain all table names and field information from the database; The update submodule is used to obtain the XML definition file in XML, compare and update the database definition information in the XML definition file with the actual table and field information of the database, and change and update the index. 9. The device according to claim 8, characterized in that the database table definition module is specifically used to: After a table inherits an abstract table, when building the database, its own definition and the definition of the inherited abstract table are combined into fields to create the table; define the primary key in the abstract table and/or the inherited table. If the inherited entity defines a primary key, then The primary key of abstract entities is not used; non-abstract tables are allowed to be inherited. If a non-abstract table is inherited, the inherited table must be defined first; if multiple abstract entities are inherited, use commas to separate them; if there are no auxiliary fields, they will be automatically created when creating the table. Add, if you do not want auxiliary fields, add: auxiliary="false". 10. The device according to claim 8, characterized in that the update sub-module is specifically used to: If the table in the database does not exist, create the table; If the field does not exist in the database, add the field; If the field in the database exists, except for the field length, the remark information is updated, and the user is prompted for other inconsistencies; If a field that exists in the database does not exist in the XML definition file, it will not be deleted directly and a prompt will be issued to the user; Delete indexes that are not defined in the XML definition file; Add the new index in the XML definition file.