CN104063232B - A kind of method of the system development utilizing based on database parameter - Google Patents
A kind of method of the system development utilizing based on database parameter Download PDFInfo
- Publication number
- CN104063232B CN104063232B CN201410345249.6A CN201410345249A CN104063232B CN 104063232 B CN104063232 B CN 104063232B CN 201410345249 A CN201410345249 A CN 201410345249A CN 104063232 B CN104063232 B CN 104063232B
- Authority
- CN
- China
- Prior art keywords
- data
- parameter
- code
- development
- field
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 230000033772 system development Effects 0.000 title claims description 13
- 238000011161 development Methods 0.000 claims abstract description 25
- 230000008569 process Effects 0.000 claims abstract description 5
- 230000005540 biological transmission Effects 0.000 claims abstract 2
- 230000018109 developmental process Effects 0.000 claims description 20
- 230000009471 action Effects 0.000 claims description 11
- 238000012217 deletion Methods 0.000 claims description 10
- 230000037430 deletion Effects 0.000 claims description 10
- 238000012545 processing Methods 0.000 claims description 7
- 238000013461 design Methods 0.000 claims description 5
- 238000012986 modification Methods 0.000 claims description 2
- 230000004048 modification Effects 0.000 claims description 2
- 230000015572 biosynthetic process Effects 0.000 claims 1
- 230000008859 change Effects 0.000 abstract description 2
- 230000000694 effects Effects 0.000 abstract description 2
- 238000012423 maintenance Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Patent of the present invention relates to a kind of method of the system fast Development utilizing based on database parameter, it utilizes the parameter of the table of relational database, by circulating and read in the corresponding process that uses programming language to carry out in program, and assignment is given one group of variable, pass to subprogram by the value of this group variable transmission correspondence again, by subprogram carry out data increasing, the data manipulation such as delete, read, change, thereby form a complete data handling system, to reach the effect of system fast Development. Notebook data treatment system can generate the corresponding succinct versatility code such as HTML, SQL statement fast, and according to the code of development language and environment set, these codes can directly be inserted into corresponding development environment, reduce the workload of exploitation, improve development efficiency.
Description
Technical field
The present invention relates generally to a kind of method of data handling system fast Development, especially utilize relevant database andThe relevant parameter of two-dimensional data table carries out fast Development and generates the system development method of versatility code.
Background technology
At present, system development all adopts the framework of relative complex to develop, especially OO development approach, veryMany time, on stream, only need to carry out business logic processing, its database is just generated, simultaneously its middlewareCode also majority is generated.
The database that this mode generates, it lacks the planning to data structure, also less to the bottom layer treatment of databasePay close attention to, thereby make 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 is to sourceThe execution efficiency of code and secondary development and the utilization etc. of source code have increased difficulty.
Pay attention to operation flow and think little of the application of Data Structure Design and the function of underlying database own for this, andThe normalization of source code is paid close attention to inadequate development mode, although on stream can be more directly perceived, and be convenient to programmingWork, 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 intend openly a kind of based on database parameter utilizeThe method of system fast Development, the utilization of the parameter that the tables of data of this method based on database is relevant, high to reach fast DevelopmentThe data structure of effect, specification, and readability easily carries out the back-up system of secondary development.
By this method, developer only need to focus on the design of data structure and establishing of operation flow on streamMeter, other frameworks can be completed automatically by system.
In the time that system needs amendment, maintenance or secondary development, developer can pass through the change to database, withAnd the code generating is write and reaches the pattern of revising more freely.
A method for the system development utilizing based on database parameter, it utilizes the parameter of the table of relational database, logicalCross in the corresponding process that uses programming language to carry out in program and circulate and read, and assignment gives one group of variable, then pass through this group variableTransmit corresponding value and pass to subprogram, carried out the respective operations of data by subprogram, thereby form a complete data placeReason system, meanwhile, program operation will generate the code of the form of setting, and this code can be inserted into various development environments and carry out secondaryExploitation; Its step is as follows:
When S10 Data Sheet Design, define the ginseng of title, data type, explanation of field and the default value of each fieldNumber;
S20 reads the field parameter described in S10 by program;
S30 judges the action type that will generate;
S41 step S30 is judged as when data increase operation and carries out, and generation can be write list, and the element of list is joined according to fieldThe relevant parameter of number is distinguished, 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 joined according to fieldThe relevant parameter of number is distinguished, is named and read corresponding data value and is worth by default;
S43 step S30 carries out while being judged as data query operation, generates read-only list, and the element of list is joined according to fieldThe relevant parameter of number is distinguished, is named and read corresponding data value and is worth by default;
S50 generates the general SQL statement of respective operations, when carry out be data deletion action time, deletion action is directly heldOK, enter step S70;
S60, the corresponding programming language grammer and the structure that generate corresponding table or field increase, editor and query manipulation are correspondingThe program statement of linguistic context, and carry out;
S70 generates the code that returns to execution result;
S80 completes end.
Wherein the parameter of the table described in step S10 comprises field name, corresponding explanation of field, corresponding field data classThe parameter of type.
One group of described variable, is array, or two-dimensional data table.
Data manipulation type described in step S30 comprises data increase, data modification, data query and data deletion.
Described step S41, step S42 and step S43 can carry out separately separately.
The code of the generation described in step S41, S42, S43 comprises corresponding HTML versatility code, SQL versatility code and establishesDetermine the code corresponding to data processing of development language.
Various development environments described in step S60 comprise the development environment of support standard HTML code and SQL versatility code,Data processing code mentions environment according to open language and sets.
Brief description of the drawings
The general flow chart of the method for the system fast Development that Fig. 1 utilizes based on database parameter.
Detailed description of the invention
Shown in Fig. 1, when S10 Data Sheet Design, define title, data type, the explanation of field of each fieldWith parameters such as default values;
S20 reads the field parameter described in S10 by program;
S30 judges the action type that will generate;
S41 step S30 is judged as when data increase operation and carries out, and generation can be write list, and the element of list is joined according to fieldThe relevant parameter of number is distinguished, 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 joined according to fieldThe relevant parameter of number is distinguished, is named and read corresponding data value and is worth by default;
S43 step S30 carries out while being judged as data query operation, generates read-only list, and the element of list is joined according to fieldThe relevant parameter of number is distinguished, is named and read corresponding data value and is worth by default;
S50 generates the general SQL statement of respective operations, when carry out be data deletion action time, deletion action is directly heldOK, enter step S70;
S60, the corresponding programming language grammer and the structure that generate corresponding table or field increase, editor and query manipulation are correspondingThe program statement of linguistic context, and carry out;
S70 generates the code that returns to execution result;
S80 completes end.
Step S10 emphasis sets each parameter according to rule, generally each according to the field of the table of digital library of ruleThe naming rule of parameter, then coordinate data structure planning and entire system framework to carry out unified name with planning.
Step S20 is mainly the parameter of read data field, and parameter is processed as data.
Step S30 judges by the IF statement of program language, and main distinction following step is to increase, delete, also changeTo look into.
Step S41 is the operation that data are added, and will generate general HTML code here, and code is succinct and can control, canCarry out presetting of template with the custom according to oneself.
Step S42 is data edition operation, and step S43 is data query operation, in S43 operation, and the HTML generation generatingCode is underaction relatively, needs further to be adjusted in the time of programming.
Step S51 is that the SQL versatility code of non-deletion action generates, and the SQL versatility code of generation can be for eachClose.
Step S52 is that the SQL code of deletion action generates, and generating run code.
Step S60 generates corresponding data manipulation code according to the development language of setting.
Step S70 generating run prompting code, comprises successfully, failure, guide operation etc.
Step S80 is the termination of this method, also can generate end code.
Above-mentioned flow process has part to carry out separately, also order can be exchanged to execution and is not affected implementation result.
Above-mentioned is one of them case study on implementation, and this method is not limited to the flow process described in this case.
Claims (7)
1. the method for system development of utilizing based on database parameter, its feature comprises, it utilizes the table of relational databaseParameter, by circulate and read in the corresponding process that uses programming language to carry out in program, and assignment is to one group of variable, then passes throughThe value of this group variable transmission correspondence passes to subprogram, is carried out the respective operations of data by subprogram, thereby one of formation is completeData handling system, meanwhile, program operation will generate the code of the form of setting, this code can be inserted into various development environmentsCarry out secondary development; Its step is as follows:
When S10 Data Sheet Design, define the parameter of title, data type, explanation of field and the default value of each field;
S20 reads the field parameter described in S10 by program;
S30 judges the action type that will generate;
S41 step S30 is judged as data to be increased when operation and carries out, and generation can be write list, and the element of list is according to field parameterRelevant parameter is distinguished, name and default settings;
S42 step S30 is judged as data edition when operation and carries out, and generation can be write list, and the element of list is according to field parameterRelevant parameter is distinguished, is named and read corresponding data value and is worth by default;
S43 step S30 is judged as data query when operation and carries out, and generates read-only list, and the element of list is according to field parameterRelevant parameter is distinguished, is named and read corresponding data value and is worth by default;
S50 generates the general SQL statement of respective operations, when carry out be data deletion action time, deletion action is directly carried out,Enter step S70;
S60, corresponding programming language grammer and the linguistic context corresponding to structure of the corresponding table of generation or field increase, editor and query manipulationProgram statement, and carry out;
S70 generates the code that returns to execution result;
S80 completes end.
2. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that, stepThe parameter of the table described in rapid S10 comprises field name, corresponding explanation of field, the parameter of corresponding field data types.
3. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that instituteOne group of variable stating, is array, or two-dimensional data table.
4. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that, stepData manipulation type described in rapid S30 comprises data increase, data modification, data query and data deletion.
5. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that instituteStep S41, the step S42 stating and step S43 can carry out separately separately.
6. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that, stepThe code of the generation described in rapid S41, S42, S43 comprises corresponding HTML versatility code, SQL versatility code and sets development languageCode corresponding to data processing.
7. the method for a kind of system development utilizing based on database parameter according to claim 1, is characterized in that, stepVarious development environments described in rapid S60 comprise the development environment of support standard HTML code and SQL versatility code, data processing generationCode mentions environment according to open language and sets.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410345249.6A CN104063232B (en) | 2014-07-21 | 2014-07-21 | A kind of method of the system development utilizing based on database parameter |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410345249.6A CN104063232B (en) | 2014-07-21 | 2014-07-21 | A kind of method of the system development utilizing based on database parameter |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104063232A CN104063232A (en) | 2014-09-24 |
| CN104063232B true CN104063232B (en) | 2016-05-25 |
Family
ID=51550956
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410345249.6A Expired - Fee Related CN104063232B (en) | 2014-07-21 | 2014-07-21 | A kind of method of the system development utilizing based on database parameter |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104063232B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104199675A (en) * | 2014-09-26 | 2014-12-10 | 佛山市恒南微科技有限公司 | System capable of quick system development based on database parameter utilization |
| CN109960699B (en) * | 2019-03-19 | 2021-11-02 | 广东电网有限责任公司广州供电局 | Data statistics establishing method and device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7310636B2 (en) * | 2002-01-15 | 2007-12-18 | International Business Machines Corporation | Shortcut enabled, context aware information management |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通系统工程有限公司 | Method and system for converting query sentence of database |
| CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合（北京）科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
-
2014
- 2014-07-21 CN CN201410345249.6A patent/CN104063232B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7310636B2 (en) * | 2002-01-15 | 2007-12-18 | International Business Machines Corporation | Shortcut enabled, context aware information management |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通系统工程有限公司 | Method and system for converting query sentence of database |
| CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合（北京）科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104063232A (en) | 2014-09-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103500087B (en) | A kind of based on maven plug-in unit and the code generating method of freemarker template and device | |
| RU2536390C2 (en) | Automated report generation method | |
| CN108681444A (en) | A kind of Soft- PLC configuration development approach based on XML technology | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| Popp et al. | Tool support for automated multi-device GUI generation from discourse-based communication models | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN111061743B (en) | Data processing method and device and electronic equipment | |
| CN104317587A (en) | Automatic android mobile device oriented application generation method | |
| CN105094818A (en) | Method and system for building comprehensive application of natural resources based on SOA | |
| CN101697120A (en) | Relational database based generation method of J2EE code | |
| CN104571026A (en) | Platform and method for establishing whole-process metallurgical manufacturing execution system | |
| Barnett et al. | Bootstrapping mobile app development | |
| CN102156640A (en) | Method for generating data operation code | |
| CN105242931A (en) | Method and system for editing and generating codes for game interface | |
| CN105573764A (en) | Android application reconstruction method for smart watch | |
| CN104063232B (en) | A kind of method of the system development utilizing based on database parameter | |
| KR101460794B1 (en) | Method and system for generating media art contents | |
| CN103942280A (en) | Automatic code generating method based on data structure | |
| CN110968591A (en) | Query statement generation method and device, storage medium and processor | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| CN106372152B (en) | Online form development system | |
| EP3958183A1 (en) | Deep learning model adaptation method and apparatus and electronic device | |
| Märtin et al. | Patterns and models for automated user interface construction–in search of the missing links | |
| CN117520372A (en) | SQL query optimization method and device, computer equipment and storage medium | |
| Prehofer et al. | A model-based approach for multi-device user interactions |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190313 Address after: 401120 data of Xiantao street, Yubei District, Chongqing 19 Patentee after: Chongqing Wingshengda Technology Co.,Ltd. Address before: 528000 Building 101-103, No. 12, Foshan Software Industrial Park, 28 Shiwan Zhenjiang Bay Third Road, Chancheng District, Foshan City, Guangdong Province Patentee before: FOSHAN HENGNAN MICRO TECHNOLOGY CO.,LTD. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220112 Address after: 102600 Room 802, 8 / F, building 1, No. 10, Hongda North Road, economic and Technological Development Zone, Daxing District, Beijing (Yizhuang group, high-end industrial area, Beijing Pilot Free Trade Zone) Patentee after: Yiyoule network technology (Beijing) Co.,Ltd. Address before: 401120 data of Xiantao street, Yubei District, Chongqing 19 Patentee before: Chongqing Wingshengda Technology Co.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20160525 |