CN113626004A - Rapid development system based on configuration mode - Google Patents
Rapid development system based on configuration mode Download PDFInfo
- Publication number
- CN113626004A CN113626004A CN202110956245.1A CN202110956245A CN113626004A CN 113626004 A CN113626004 A CN 113626004A CN 202110956245 A CN202110956245 A CN 202110956245A CN 113626004 A CN113626004 A CN 113626004A
- Authority
- CN
- China
- Prior art keywords
- data
- name
- driving engine
- field
- dictionary
- 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/20—Software design
-
- 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
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2468—Fuzzy queries
-
- 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/34—Graphical or visual programming
Abstract
The invention belongs to the field of system development, and particularly relates to a rapid development system based on a configuration mode.A system driving engine comprises a server data driving engine, a view layer data driving engine and a fuzzy query data driving engine; after a database table is configured on a user interface, in the process of creating a table by the database, the system automatically starts a server data driving engine, and returns data to a view layer for a user to check; in the newly added or modified process, a drop-down frame data driving and cleaning program, a form automatic regular checking program and a view layer data driving program are called, data are returned to a server data driving engine, and the data are stored.
Description
Technical Field
The invention relates to the field of system development, in particular to a rapid development system based on a configuration mode.
Background
Each function of the existing framework needs to be manually written with codes to realize corresponding functions, some simpler functions including some drop-down box data needing to be associated need to be continuously written with front and back end codes to carry out association query, and check codes need to be repeatedly written for the form fields, so that the workload of developers is increased.
Disclosure of Invention
Objects of the invention
In order to solve the technical problems in the background technology, the invention provides a rapid development system based on a configuration mode, which realizes development by utilizing three basic public tables, dictionary tables and coding tables, and can complete corresponding functions only by inputting a related database table structure in a front-end interface, thereby reducing the work of code development.
(II) technical scheme
In order to solve the above technical problems, the present invention provides a rapid development system based on configuration mode, the system driving engine includes a server data driving engine, a view layer data driving engine, and a fuzzy query data driving engine,
a public table, a dictionary table, a coding table and a service table are arranged in the system driving engine;
the public table is used for recording the number of tables created by the system through a user interface, the data volume limit of each table, the sorting mode when each table inquires data and each operation record of the whole table;
the dictionary table is mainly used for creating a database table and storing field information of the database table;
the encoding table is used for storing commonly used encodings for reference by other tables.
The public table is used for previewing system table information configured by a user, and comprises a table name, a table capacity, a table sorting mode and a table index field.
The dictionary table is used for configuring basic information of the system table, and the basic information comprises data verification, data reference filtering, default prompt content and the like.
The code table is used for storing common system codes, such as nationalities, academic calendars and the like.
The invention provides the following data-driven algorithms, including the following:
1. the system functional architecture is shown in FIG. 1; firstly, starting from a public table, creating corresponding table information, and secondly, configuring all fields of the table by a dictionary table;
when the current field refers to the coding table, storing the table name of the coding table and the coding classification field;
when the business table is quoted, the table name and the quoted field name are stored;
the service program acquires corresponding sequencing fields and capacity fields from the public table according to the table names and acquires corresponding field data from the dictionary table;
returning the data obtained by the data driving program to the view layer, and performing interface rendering;
2. the server data driver flow of the server data driver engine is shown in fig. 2; the data driving engine at the server side converts data and codes, and for the data of the view display layer, firstly, the data inquired in a database is judged according to the fields in the dictionary table of the table, and the current value is the code or the original value;
if the code is coded, the corresponding reference name is inquired in the corresponding referred list according to the field data and then the reference name is stored and returned to the view layer;
3. the flow of the view layer data driver engine is shown in fig. 3; when the view layer data driver core edits data, if the current field displayed back is quoted, the displayed back value is the corresponding name, and the coded value corresponding to the current name needs to be searched according to the current field value in the dictionary table during storage, and then the coded value returns to the data driver engine at the server end;
4. the flow of the fuzzy query data driver engine is shown in fig. 4: the data engine stores codes in a database, the view layer displays corresponding names, when fuzzy query is carried out according to name fields, the fields need to be mapped into corresponding reference tables in a data driving program for fuzzy query, and if a result is queried in the reference tables, the reference codes are mapped into the original database again.
The technical scheme of the invention has the following beneficial technical effects: after a database table is configured on a user interface, in the process of creating the table by the database, the system automatically starts a server data driving engine, and returns data to the view layer for a user to check. And in the newly added or modified process, calling a drop-down frame data driving and cleaning program, a form automatic regular verification program and a view layer data driving program, returning the data to a server data engine, and storing the data.
The invention also provides computer terminal equipment which comprises one or more processors and a memory, wherein the memory is coupled with the processors and used for storing the development framework; when the development framework is executed by the one or more processors, the one or more processors are caused to implement a method for rapid development of a system based on a configuration schema.
The application of the invention, the development of system functions is migrated from code writing to data entry, and the configuration of corresponding functions can be completed only by simple training, so that personnel without code writing capability can configure the system functions required by the personnel without writing codes.
Drawings
FIG. 1 is a system architecture diagram of the present invention;
FIG. 2 is a flow chart of a server data driver according to the present invention;
FIG. 3 is a flowchart of a view layer data driver according to the present invention;
FIG. 4 is a flowchart of the fuzzy query data driver of the present invention;
FIG. 5 is a dictionary representation of the present invention;
FIG. 6 is a common representation of the present invention;
FIG. 7 is a diagram of a coding table according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings in conjunction with the following detailed description. It should be understood that the description is intended to be exemplary only, and is not intended to limit the scope of the present invention. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present invention.
As shown in fig. 1 to 7, the rapid development system based on the configuration mode provided by the present invention implements functions by a configuration manner, and the system driving engine includes a server data driving engine, a view layer data driving engine, and a fuzzy query data driving engine, which mainly depends on a public table, a dictionary table, a coding table, and a service table;
the public table is used for recording the number of tables created in the system and the data volume limit of each table, and recording each operation record of the whole table;
the public table configuration field comprises a table English name, a table Chinese name, a table capacity, a table sorting mode and a table creating state;
the dictionary table is mainly used for creating a database table and storing field information of the database table, and transferring a mode of creating a table in a database visualization tool to a system, and compared with the database visualization tool, the dictionary table increases the defined attribute of the field and comprises a reference table name;
the reference table shows the field names in a drop-down frame;
referencing a field in which the table is stored in the database;
a definition of a reference field;
checking the form;
the configuration fields of the dictionary table comprise a main key type, self-increment or not, null or not, a reference table name, a reference name field, a reference value field, reference value classification, a reference condition, a data check field, a check type, table element default prompt content, display or not in a page or an edit or newly-added window;
the coding table is used for storing commonly used codes for being referred by other tables;
wherein the encoding table configuration field includes an encoding classification, an encoding name, and an encoding value.
The field related data sets, namely the verification mode and the verification type of the field to be added, and the limitation of the numerical range.
It should be noted that: the name of the association table is displayed in the drop-down box, and the corresponding code or the primary key is stored in the database, so that quick selection can be realized.
As working examples of common tables: the public table previews the fields of the public table, adds and modifies the information of the public table and creates a physical table through a system configuration mode.
As a working example of a dictionary table: and the dictionary table previews the dictionary table information and adds and modifies the dictionary table data through a system configuration mode.
As a working example of an encoding table: and automatically generating page display after the coding table is created through a system configuration mode, wherein the page display comprises an addition, deletion, modification and check function, and the created table is a database table created for the dictionary table.
The rapid development system development method based on the configuration mode comprises the following steps:
s1, a driving engine based on the public table, the coding table, the dictionary table and the service table, firstly, the public table is used for establishing corresponding table information, and secondly, the dictionary table is used for configuring all fields of the table;
when the current field refers to the coding table, storing the table name of the coding table and the coding classification field;
when the business table is quoted, the table name and the quoted field name are stored;
the service program acquires corresponding sequencing fields and capacity fields from the public table according to the table names and acquires corresponding field data from the dictionary table;
returning the data obtained by the data driving program to the view layer, and performing interface rendering;
s2, the server data driving engine process is: the data driving engine at the server side converts data and codes, and for the data of the view display layer, firstly, the data inquired in a database is judged according to the fields in the dictionary table of the table, and the current value is the code or the original value;
if the code is coded, the corresponding reference name is inquired in the corresponding referred list according to the field data and then the reference name is stored and returned to the view layer;
and if the current field does not refer to the table, directly storing the original value and returning to the view layer.
S3, view layer data driving engine: when the view layer data driver core edits data, if the current field displayed back is referred, the displayed back value is the corresponding name, and the coded value corresponding to the current name needs to be searched according to the current field value in the dictionary table during storage, and then the coded value returns to the data driver engine at the server.
S4, fuzzy query data driving engine: the data engine stores codes in a database, the view layer displays corresponding names, when fuzzy query is carried out according to name fields, the fields need to be mapped into corresponding reference tables in a data driving program for fuzzy query, and if a result is queried in the reference tables, the reference codes are mapped into the original database again.
And S5, configuring the functions of the rapid development system based on the configuration mode.
In another embodiment, a computer terminal device includes one or more processors, a memory coupled to the processors for storing a development framework; when the development framework is executed by the one or more processors, the one or more processors are caused to implement a method for rapid development of a system based on a configuration schema.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explaining the principles of the invention and are not to be construed as limiting the invention. Therefore, any modification, equivalent replacement, improvement and the like made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. Further, it is intended that the appended claims cover all such variations and modifications as fall within the scope and boundaries of the appended claims or the equivalents of such scope and boundaries.
Claims (6)
1. A rapid development system based on configuration mode is characterized in that: the function development is realized through a configuration mode, and a system driving engine comprises a server data driving engine, a view layer data driving engine and a fuzzy query data driving engine, and mainly depends on a public table, a dictionary table, a coding table and a service table;
the public table is used for recording the number of tables created in the system and the data volume limit of each table, recording each operation record of the whole table, and configuring fields of the public table, including table English names, table Chinese names, table capacity, table sorting mode and table creation state;
the dictionary table is mainly used for creating a database table and storing field information of the database table; the configuration fields of the dictionary table comprise a main key type, whether the dictionary table is self-added or not, whether the dictionary table is empty or not, a reference table name, a reference name field, a reference value classification, a reference condition, a data verification field, a verification type, table element default prompting content, whether the dictionary table is displayed in a page or not, and whether the dictionary table is displayed in an editing or newly added window or not;
the encoding table is used for storing common codes for reference of other tables, and the configuration field of the encoding table comprises an encoding classification, an encoding name and an encoding value.
2. The rapid development system based on configuration mode according to claim 1,
the system driving engine is driven by a public table, a dictionary table, an encoding table and a service table, and the process is as follows:
firstly, starting from a public table, creating corresponding table information, and secondly, configuring all fields of the table by a dictionary table;
when the current field refers to the coding table, storing the table name of the coding table and the coding classification field;
when the business table is quoted, the table name and the quoted field name are stored;
the service program acquires corresponding sequencing fields and capacity fields from the public table according to the table names and acquires corresponding field data from the dictionary table;
and returning the data obtained by the data driving program to the view layer, and rendering the interface.
3. A rapid development system based on configuration mode according to claim 2,
the server data driving engine is driven by user data, and the process is as follows:
the data driving engine at the server side converts data and codes, and for the data of the view display layer, firstly, the data inquired in a database is judged according to the fields in the dictionary table of the table, and the current value is the code or the original value;
if the code is coded, the corresponding reference name is inquired in the corresponding referred table according to the field data, and then the reference name is stored and returned to the view layer.
4. A rapid development system based on configuration mode according to claim 3,
the view layer data driving engine is driven by a user data and server data driving program, and the process is as follows:
when the view layer data driver core edits data, if the current field displayed back is referred, the displayed back value is the corresponding name, and the coded value corresponding to the current name needs to be searched according to the current field value in the dictionary table during storage, and then the coded value returns to the data driver engine at the server.
5. The system of claim 4, wherein the fuzzy query data driver engine is driven by the query keyword and server data driver, and the process is as follows:
the data engine stores codes in a database, the view layer displays corresponding names, when fuzzy query is carried out according to name fields, the fields need to be mapped into corresponding reference tables in a data driving program for fuzzy query, and if a result is queried in the reference tables, the reference codes are mapped into the original database again.
6. A computer terminal device comprising one or more processors, a memory coupled to the processors for storing a development framework; when executed by the one or more processors, cause the one or more processors to implement the method for rapid development of a system based on configuration schema as recited in claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110956245.1A CN113626004A (en) | 2021-08-19 | 2021-08-19 | Rapid development system based on configuration mode |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110956245.1A CN113626004A (en) | 2021-08-19 | 2021-08-19 | Rapid development system based on configuration mode |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113626004A true CN113626004A (en) | 2021-11-09 |
Family
ID=78386739
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110956245.1A Pending CN113626004A (en) | 2021-08-19 | 2021-08-19 | Rapid development system based on configuration mode |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113626004A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
| CN108536705A (en) * | 2017-03-02 | 2018-09-14 | 华为技术有限公司 | The coding of object and operation method and database server in Database Systems |
| CN110990406A (en) * | 2019-11-28 | 2020-04-10 | 中国建设银行股份有限公司 | Fuzzy query method, device, equipment and medium |
| US20200265046A1 (en) * | 2019-02-15 | 2020-08-20 | Drfirst.Com, Inc. | Efficient access of chainable records |
| CN112506505A (en) * | 2020-12-16 | 2021-03-16 | 江苏龙虎网信息科技股份有限公司 | Method for producing program code by code template engine |
-
2021
- 2021-08-19 CN CN202110956245.1A patent/CN113626004A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
| CN108536705A (en) * | 2017-03-02 | 2018-09-14 | 华为技术有限公司 | The coding of object and operation method and database server in Database Systems |
| US20200265046A1 (en) * | 2019-02-15 | 2020-08-20 | Drfirst.Com, Inc. | Efficient access of chainable records |
| CN110990406A (en) * | 2019-11-28 | 2020-04-10 | 中国建设银行股份有限公司 | Fuzzy query method, device, equipment and medium |
| CN112506505A (en) * | 2020-12-16 | 2021-03-16 | 江苏龙虎网信息科技股份有限公司 | Method for producing program code by code template engine |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11250209B2 (en) | Document collaboration and consolidation tools and methods of use | |
| CN109101652B (en) | Label creating and managing system | |
| US8452818B2 (en) | Dimension-based relation graphing of documents | |
| US20040243613A1 (en) | System and method for creating a custom view from information in a managed data store | |
| US20060195788A1 (en) | Tree system diagram output method, computer program and recording medium | |
| EP1126383A1 (en) | Database system | |
| JP2004303250A (en) | Computer search with association | |
| KR20080027251A (en) | Dynamic method for generating xml documents from a database | |
| US20080162457A1 (en) | Software and method for utilizing a generic database query | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| CN108228846B (en) | Resource file management method and device | |
| CN116401407A (en) | Node attribute configuration method, device, equipment and storage medium of mind map | |
| CN110471892B (en) | Revit file data collection method and related device | |
| CN110941629A (en) | Metadata processing method, device, equipment and computer readable storage medium | |
| JP2000504861A (en) | Information exchange management computer operation method and form filling method | |
| CN103678263A (en) | Graphical interface display method and system for incidence relations among document chapters | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN113626004A (en) | Rapid development system based on configuration mode | |
| CN103870953A (en) | Contact information modification method and terminal device | |
| CN111488379B (en) | Method for optimizing Hbase large data query | |
| CN111753141A (en) | Data management method and related equipment | |
| US20080229305A1 (en) | Workflow management system | |
| CN111460779B (en) | Method for rendering and accessing flow form data based on Activiti | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| US10607239B2 (en) | Enterprise evaluation using structured data |
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 |