CN104199675A - System capable of quick system development based on database parameter utilization - Google Patents
System capable of quick system development based on database parameter utilization Download PDFInfo
- Publication number
- CN104199675A CN104199675A CN201410500902.1A CN201410500902A CN104199675A CN 104199675 A CN104199675 A CN 104199675A CN 201410500902 A CN201410500902 A CN 201410500902A CN 104199675 A CN104199675 A CN 104199675A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- database
- general
- database parameter
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a system capable of quick system development based on database parameter utilization. According to the system, parameters of a table of a relational database are utilized, programming language is utilized to perform circulation reading during corresponding process of program executing, values are assigned to a set of variables, the variables are utilized to convey corresponding values to a subprogram, the subprogram is utilized to perform data operation such as adding, deleting, reading, and changing, so that a complete data processing system is formed, and the effect of quick system development is reached. The system comprises a database parameter design module, a database parameter acquisition module, a general SQL statement generating and managing module, a general HTML statement generating and managing module, a form data acquisition and processing module, a target data table data processing module, a target database condition enquiry module and the like.
Description
Technical field
The present invention relates generally to a kind of system of data handling system fast Development, especially utilizes the correlation parameter of relevant database and two-dimensional data table to carry out fast Development and the system development system that generates versatility code.
Background technology
At present, system development all adopts the framework of relative complex to develop, especially OO development approach, many times, on stream, only need to carry out business logic processing, its database is just generated, and its middleware code of while also majority is generated.
The database that this mode generates, it lacks the planning to data structure, also to the less concern of the bottom layer treatment of database, thereby makes the system that develops discount to some extent aspect data execution efficiency.
Meanwhile, its code generating in system processing procedure is also far from the succinctly understandable of hand-written code, and this has increased difficulty to the secondary development of the execution efficiency of source code and source code and utilization etc.
Pay attention to operation flow and think little of the application of Data Structure Design and the function of underlying database own for this, and the standardization of source code is paid close attention to inadequate development mode, although on stream can be more directly perceived, and be convenient to the work of program design, but for maintenance and the secondary development of system, and carry out large data processing etc. and be all difficult to be competent at.
Summary of the invention
In order to solve the problem existing in this system development, the present invention intends disclosing a kind of system of the system fast Development utilizing based on database parameter, the utilization of the parameter that the tables of data of native system based on database is relevant, to reach, fast Development is efficient, the data structure of standard, and readability easily carries out the back-up system of secondary development.
By native system, developer only need to focus on the design of data structure and the design of operation flow on stream, and other frameworks can be completed automatically by native system.
When system needs modification, maintenance or secondary development, developer can pass through the change to database, and the code generating is write and reaches the pattern of revising more freely.
The system of a kind of system fast Development utilizing based on database parameter disclosed by the invention, it comprises that database parameter design module, database parameter acquisition module, general SQL statement generation and administration module, the generation of general HTML statement and administration module, HTML form design and editor module, form data obtain and writes the modules such as processing module, searching and managing module and target data list deletion processing module with processing module, target database condition query module, target matrix; Database parameter acquisition module is the parameter of utilizing the table of relational database, by circulating and read in the corresponding process of using programming language to carry out in program, and assignment generates and administration module to general SQL statement generation and administration module or general HTML statement, value by this module transmission correspondence passes to target database condition query module or HTML form design and editor module again, and the respective operations module of carrying out data by it is carried out the processing of target matrix.
Database parameter acquisition module comprises that the field name of tables of data obtains that program, explanation of field are obtained program, field value obtains and supervisory routine.
General SQL statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general SQL statement program and general SQL statement supervisory routine.
The processing of target data operation table comprises that tables of data increases processing, tables of data is revised processing, tables of data inquiry and tables of data and deleted processing.
General HTML statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general HTML statement program and general HTML statement supervisor.
Form data obtains with processing module and comprises that general HTML generates the general HTML form design program and the general SQL statement that generate with administration module and generates the general SQL statement handling procedure generating with administration module.
Database parameter design module and HTML form design and editor module can be realized respectively by the ready-made software of third party, program, system or module.
The method of work of native system is mainly as follows: it utilizes the parameter of the table of relational database, by circulating and read in the corresponding process of using programming language to carry out in program, and assignment is given one group of variable, value by this group variable transmission correspondence passes to subroutine again, by subroutine, carried out the respective operations of data, thereby form a complete data handling system, simultaneously, program operation will generate the code of the form of setting, and this code can be inserted into various development environments and carry out secondary development; Its key step is as follows:
During S10 Data Sheet Design, define the parameters such as title, data type, explanation of field and default value of each field;
S20 reads the field parameter described in S10 by program;
The class of operation shape that S30 judgement will generate;
S41 step S30 is judged as when data increase operation and carries out, and generation can be write list, the element of list according to the correlation parameter of field parameter distinguish, name and default settings;
S42 step S30 carries out while being judged as data edition operation, and generation can be write list, and the element of list is distinguished, named and read corresponding data value and is worth by default according to the correlation parameter of field parameter;
S43 step S30 carries out while being judged as data query operation, generates read-only list, and the element of list is distinguished, named and read corresponding data value and is worth by default according to the correlation parameter of field parameter;
S50 generates the general SQL statement of respective operations, when carry out be data deletion action time, deletion action is directly carried out, and enters step S70;
The program word name of the linguistic context that the corresponding programming language grammer of the respective operations such as the corresponding table of S60 generation or field increase, editor and inquiry and structure etc. are corresponding, and carry out;
S70 generates the code that returns to execution result;
S80 completes end.
Wherein, one group of variable, can be array, can be also two-dimensional data table.
The parameter of the table described in step S10 comprises field name, corresponding explanation of field, the corresponding parameters such as field data types.
Data manipulation type described in step S30 comprises data increase, data modification, data query and data deletion.
Step S41, step S42, step S43, S51 and step S52 can carry out separately.
The subroutine that value is transmitted comprises function, data form processing subsystem.
The code of the generation described in step S41, S42, S43, S51, S52 comprises HTML versatility code, the SQL versatility code of sending out corresponding and code corresponding to data processing of setting development language.
Various development environments described in step S60 comprise the development environment of support standard HTML code and SQL versatility code, and data processing code mentions environment according to open language and sets.
Accompanying drawing explanation
The structural drawing of the system of the system fast Development that Fig. 1 utilizes based on database parameter.
Embodiment
Shown in Fig. 1, database parameter design module comprises Data Sheet Design program, tables of data parameter designing program and data parameters supervisory routine; This module also can adopt that most relational database carries designs program or ripe third party database exploitation replaces with design software.
Database parameter acquisition module comprises that the field name of tables of data obtains that program, explanation of field are obtained program, field value obtains and supervisory routine, be mainly used in the contents such as field name, explanation of field and field value of reading out data table, to offer general SQL statement generation and administration module and general HTML statement, generate and administration module use.
General SQL statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general SQL statement program and general SQL statement supervisory routine, it mainly realizes the management of general SQL statement, for table target database condition query module, use, so that generate the individuation data processing module use that the syntax gauge of various different development languages is used.
General HTML statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general HTML statement program and general HTML statement supervisor, and the HTML statement that this module generates will be processed by HTML form design and editor module.
HTML form design and editor module are mainly used in HTML form design and editor, and for page personalized design and UI design, it can substitute by ready-made software or module.
Form data obtains with processing module and comprises that form data obtains program and form data handling procedure, when form data is submitted to this module, this module will with target database condition query module, the communication of database parameter acquisition module and target database data handling system module Combined Treatment data, complete that form data obtains and automatically generate the corresponding DPS of various dissimilar development languages.
Target database condition query module is at judgement development requirement to be processed, after inquiry, editor etc., the Data support providing according to general SQL statement generation and administration module and database parameter acquisition module again, for corresponding data processing and corresponding development language are inquired about the generation of subroutine, when program, carry out this inquiry subroutine, system will provide corresponding data processing form and data processing form to target data table handing module.
Target matrix writes the data that processing module carries out target matrix according to the taxeme of target developing language and writes processing.
Searching and managing module is according to the development requirement of the taxeme of target developing language and required realization, and user's the information such as input, and generating report forms is supported in the inquiry of realize target data simultaneously.
Target data list deletion processing module is relatively simple, directly by database parameter acquisition module, obtains after relevant parameter, directly carries out the data deletion action of agreement according to the general deletion SQL statement of setting.
Above-mentioned is one of them case study on implementation, and this method is not limited to textural association module and the method for work flow process described in this case.
Claims (7)
1. the system of the system fast Development utilizing based on database parameter, its feature comprises, it comprises that database parameter design module, database parameter acquisition module, general SQL statement generation and administration module, the generation of general HTML statement and administration module, HTML form design and editor module, form data obtain and writes the modules such as processing module, searching and managing module and target data list deletion processing module with processing module, target database condition query module, target matrix; Database parameter acquisition module is the parameter of utilizing the table of relational database, by circulating and read in the corresponding process of using programming language to carry out in program, and assignment generates and administration module to general SQL statement generation and administration module or general HTML statement, value by this module transmission correspondence passes to target database condition query module or HTML form design and editor module again, and the respective operations module of carrying out data by it is carried out the processing of target matrix.
2. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, described database parameter acquisition module comprises that the field name of tables of data obtains that program, explanation of field are obtained program, field value obtains and supervisory routine.
3. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, described general SQL statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general SQL statement program and general SQL statement supervisory routine.
4. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, the processing of described target data operation table comprises that tables of data increases processing, tables of data is revised processing, tables of data inquiry and tables of data and deleted processing.
5. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, described general HTML statement generates with administration module and comprises that the tables of data parameter of obtaining by database parameter acquisition module generates general HTML statement program and general HTML statement supervisor.
6. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, described form data obtains with processing module and comprises that general HTML generates the general HTML form design program and the general SQL statement that generate with administration module and generates the general SQL statement handling procedure generating with administration module.
7. the system of a kind of system fast Development utilizing based on database parameter according to claim 1, it is characterized in that, described database parameter design module and HTML form design and editor module can be realized respectively by the ready-made software of third party, program, system or module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410500902.1A CN104199675A (en) | 2014-09-26 | 2014-09-26 | System capable of quick system development based on database parameter utilization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410500902.1A CN104199675A (en) | 2014-09-26 | 2014-09-26 | System capable of quick system development based on database parameter utilization |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104199675A true CN104199675A (en) | 2014-12-10 |
Family
ID=52084972
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410500902.1A Pending CN104199675A (en) | 2014-09-26 | 2014-09-26 | System capable of quick system development based on database parameter utilization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104199675A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109634984A (en) * | 2018-12-13 | 2019-04-16 | 中国银行股份有限公司 | A kind of data source configuration is converted into the method and system of SQL |
| CN111095195A (en) * | 2018-03-15 | 2020-05-01 | 欧姆龙株式会社 | Controller, control method, and control program |
| CN112764728A (en) * | 2020-12-31 | 2021-05-07 | 北京谊安医疗系统股份有限公司 | Automatic programming method and system suitable for embedded software of breathing machine |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102999600A (en) * | 2012-11-20 | 2013-03-27 | 中兴通讯股份有限公司 | Method and system for automatically generating embedded database |
| CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合（北京）科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
| CN103377038A (en) * | 2012-04-11 | 2013-10-30 | 怡丰联合（北京）科技有限责任公司 | User-defined form description and form analysis method |
| CN104063232A (en) * | 2014-07-21 | 2014-09-24 | 佛山市恒南微科技有限公司 | Rapid system development method based on utilization of database parameters |
-
2014
- 2014-09-26 CN CN201410500902.1A patent/CN104199675A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合（北京）科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
| CN103377038A (en) * | 2012-04-11 | 2013-10-30 | 怡丰联合（北京）科技有限责任公司 | User-defined form description and form analysis method |
| CN102999600A (en) * | 2012-11-20 | 2013-03-27 | 中兴通讯股份有限公司 | Method and system for automatically generating embedded database |
| CN104063232A (en) * | 2014-07-21 | 2014-09-24 | 佛山市恒南微科技有限公司 | Rapid system development method based on utilization of database parameters |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111095195A (en) * | 2018-03-15 | 2020-05-01 | 欧姆龙株式会社 | Controller, control method, and control program |
| CN111095195B (en) * | 2018-03-15 | 2023-10-27 | 欧姆龙株式会社 | Controller, control method, and storage medium |
| CN109634984A (en) * | 2018-12-13 | 2019-04-16 | 中国银行股份有限公司 | A kind of data source configuration is converted into the method and system of SQL |
| CN112764728A (en) * | 2020-12-31 | 2021-05-07 | 北京谊安医疗系统股份有限公司 | Automatic programming method and system suitable for embedded software of breathing machine |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103412868B (en) | Document generates method and device | |
| US7774745B2 (en) | Mapping of designtime to runtime in a visual modeling language environment | |
| CN101271475B (en) | Commercial intelligent system | |
| RU2536390C2 (en) | Automated report generation method | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN105528418B (en) | A kind of design documentation generation method and device | |
| US9514115B2 (en) | Method for creating form validation program and corresponding form interface according to result set metadata | |
| CN105389251A (en) | Structured query language debugger | |
| CN104063764B (en) | The device and method of Visual Production item code | |
| CN104133772A (en) | Automatic test data generation method | |
| CN105761007B (en) | Auxiliary method and system for information management software design | |
| CN104965735A (en) | Apparatus for generating upgrade SQL script | |
| CN109241026B (en) | Data management method, device and system | |
| CN103903086A (en) | Method and system for developing management information system based on service model driving | |
| CN104731588B (en) | Page layout document generating method and page layout file creating apparatus | |
| WO2016181368A1 (en) | Method implemented by a computer that presents software-type applications based on design specifications | |
| US20110179397A1 (en) | Systems and methods for metamodel transformation | |
| CN108829653A (en) | A kind of generation method of report, device, equipment and medium | |
| US8732655B2 (en) | Systems and methods for metamodel transformation | |
| KR20170024998A (en) | System for authoring and executing rule-based business application | |
| CN115617773A (en) | Data migration method, device and system | |
| CN104504171A (en) | Modeling method based on unified modeling environment | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| US9159052B2 (en) | Generalizing formats of business data queries and results | |
| CN103617284A (en) | Data field extension method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141210 |