CN107844295A - Can raising efficiency database coded system - Google Patents
Can raising efficiency database coded system Download PDFInfo
- Publication number
- CN107844295A CN107844295A CN201711172859.0A CN201711172859A CN107844295A CN 107844295 A CN107844295 A CN 107844295A CN 201711172859 A CN201711172859 A CN 201711172859A CN 107844295 A CN107844295 A CN 107844295A
- Authority
- CN
- China
- Prior art keywords
- data
- identification codes
- layer identification
- module
- code
- 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
- 238000013499 data model Methods 0.000 claims description 35
- 230000005540 biological transmission Effects 0.000 claims description 10
- 238000011161 development Methods 0.000 abstract description 9
- 238000012986 modification Methods 0.000 abstract description 5
- 230000004048 modification Effects 0.000 abstract description 5
- 238000010276 construction Methods 0.000 abstract description 4
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 210000004556 brain Anatomy 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000011017 operating method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
- G06F8/24—Object-oriented
-
- 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/37—Compiler construction; Parser generation
-
- 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/38—Creation or generation of source code for implementing user interfaces
Abstract
The invention discloses can raising efficiency database coded system, including data generation module, data resolution module, data coding module and authentication module.The course of work that the present invention solves data base administration structure existing for prior art is required for the largely time of mechanical typings and the duplication of labour, the problem of energy can not thus being concentrated in the exploitation of core business logic, there is provided can raising efficiency database coded system, the base class code of table automatically generates in correspondence database when it is applied, including generating attribute, create, modification, delete, inquiry, existence, the foundation code segment such as construction of Model Attribute class, programmer is set to save time and the duplication of labour of a large amount of mechanical typings when carrying out Development of Module, so as to which more energy to be concentrated on to the exploitation of core business logic.Using small tool is automatically generated, project development easily can be easily carried out.
Description
Technical field
The present invention relates to data base administration mechanism, and in particular to can raising efficiency database coded system.
Background technology
With the development of science and technology the electronic equipment that computer, smart mobile phone etc. have operation processing function widely should
In the live and work daily used in people, turn into article essential in people's daily life and work.And software is electricity
Brain, smart mobile phone etc. these have operation processing function electronic equipment essential part, these have computing
The electronic equipment of processing function is to utilize different software so as to perform all kinds of corresponding operations.
SQL：SQL (Structured Query Language) abbreviation SQL, is a kind of specific purposes
Programming language, it is a kind of data base querying and programming language, for accessing data and inquiry, renewal and administrative relationships number
According to storehouse system；It is also the extension name of database script file simultaneously.Data manipulation class：Use ADO.NET mode operation data
, it is necessary to ground write operation class be tossed about to different databases, wherein including Model, operating method etc. during storehouse.Three-tier architecture
(3-tier architecture)：Whole service application is exactly divided into by the three-tier architecture on ordinary meaning：Boundary layer
(User Interface layer), Business Logic (Business Logic Layer), data access layer (Data
access layer)。
The course of work of existing data base administration structure is required for time and the duplication of labour of a large amount of mechanical typings, so
Energy cannot be concentrated in the exploitation of core business logic.
The content of the invention
The course of work that the present invention solves data base administration structure existing for prior art is required for a large amount of mechanical typings
Time and the duplication of labour, the problem of thus energy can not be concentrated in the exploitation of core business logic, there is provided can be lifted
The database coded system of efficiency, the base class code of table automatically generates in correspondence database when it is applied, including generation category
Property, establishment, modification, deletion, inquiry, existence, the foundation code segment such as construction of Model Attribute class, are carrying out programmer
Time and the duplication of labour of a large amount of mechanical typings can be saved during Development of Module, so as to which more energy are concentrated on into core industry
The exploitation for logic of being engaged in.Using small tool is automatically generated, project development easily can be easily carried out.
The present invention is achieved through the following technical solutions：
Can raising efficiency database coded system, including data generation module, data resolution module, data coding module
And authentication module, wherein：Data generation module, for generating data Model layer identification codes, data IDAL layer identification codes, data
Abstract factory code and DAL layer identification codes, and by the data Model layer identification codes, data IDAL layer identification codes, data abstraction factory of generation
Code and DAL layer identification codes are transferred to data resolution module；Data resolution module, come for parsing the data generation module transmission
Data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes and be transferred to data encoding
Module；Data coding module, for receiving and compiling data Model layer identification codes, the data that the data resolution module transmission comes
IDAL layer identification codes, data abstraction works code and DAL layer identification codes, then by compiled data Model layer identification codes, data IDAL layers
Code, data abstraction works code and DAL layer identification codes are output to database with dll file respectively；Authentication module, for using
Family input prefix, database server address and port, database account, password and the data name connected is needed, when testing
After card passes through, the database is connected to.
Further, can raising efficiency database coded system, the data generation module includes subscriber interface module,
The subscriber interface module includes：Typing sub-interface, self-defining data generation sub-interface, the typing sub-interface, self-defined number
It is respectively used to according to generation sub-interface for user's craft logging data, the generation data Model layer identification codes, data IDAL layer generations
Code, data abstraction works code and DAL layer identification codes.
Further, can raising efficiency database coded system, the data generation module includes memory module, stores
Module is used for the data Model layer identification codes, data IDAL layer identification codes, data for the data and generation for storing user's craft typing
Abstract factory code and DAL layer identification codes.
The present invention compared with prior art, has the following advantages and advantages：
It is 1st, of the invention by setting data generation module, data resolution module, data coding module and authentication module,
Wherein：Data generation module generation data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and DAL layer generations
Code, and the data Model layer identification codes of generation, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes are transferred to
Data resolution module；Data resolution module parses data Model layer identification codes, the data IDAL that the data generation module transmission comes
Layer identification code, data abstraction works code and DAL layer identification codes are simultaneously transferred to data coding module；Data coding module is received and compiled
Data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and the DAL that the data resolution module transmission comes
Layer identification code, then by compiled data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes
Database is output to dll file respectively；Authentication module for user input prefix, database server address and port,
The data name that database account, password and needs connect, after being verified, is connected to the database.In corresponding number
Automatically generated according to the base class code of table in storehouse, including generation attribute, establishment, modification, deletion, inquiry, existence, Model category
Property class the foundation code segment such as construction, allow programmer saved when carrying out Development of Module a large amount of mechanical typings time and
The duplication of labour, so as to which more energy to be concentrated on to the exploitation of core business logic., can be very using small tool is automatically generated
It is convenient easily to carry out project development.
2nd, heretofore described data generation module includes subscriber interface module, and the subscriber interface module includes：Typing
Sub-interface, self-defining data generation sub-interface, the typing sub-interface, self-defining data generation sub-interface are respectively used to supply user
Manual logging data, generation data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and the DAL layer generations
Code.The more convenient input data of user is made by subscriber interface module.
3rd, data generation module includes memory module in the present invention, and memory module is used for the data for storing user's craft typing
Data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes with the generation.By depositing
The data of storage module storage user's typing simultaneously store the code file of generation, so as to avoid the loss of data, when making a mistake
Recompility is also convenient for give for change.
Brief description of the drawings
Accompanying drawing described herein is used for providing further understanding the embodiment of the present invention, forms one of the application
Point, do not form the restriction to the embodiment of the present invention.In the accompanying drawings：
Fig. 1 is schematic structural view of the invention.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, with reference to embodiment and accompanying drawing, to this
Invention is described in further detail, and exemplary embodiment of the invention and its explanation are only used for explaining the present invention, do not make
For limitation of the invention.
Embodiment
As shown in figure 1, can raising efficiency database coded system, including data generation module, data resolution module, number
According to coding module and authentication module, wherein：Data generation module, for generating data Model layer identification codes, data IDAL layers
Code, data abstraction works code and DAL layer identification codes, and by the data Model layer identification codes, data IDAL layer identification codes, number of generation
Data resolution module is transferred to according to abstract factory code and DAL layer identification codes, the data generation module includes subscriber interface module,
The subscriber interface module includes：Typing sub-interface, self-defining data generation sub-interface, the typing sub-interface, self-defined number
It is respectively used to according to generation sub-interface for user's craft logging data, the generation data Model layer identification codes, data IDAL layer generations
Code, data abstraction works code and DAL layer identification codes.The data generation module includes memory module, and memory module is used to store
The data of user's craft typing and the data Model layer identification codes of the generation, data IDAL layer identification codes, data abstraction works code
With DAL layer identification codes；Data resolution module, for parsing data Model layer identification codes, the data that the data generation module transmission comes
IDAL layer identification codes, data abstraction works code and DAL layer identification codes are simultaneously transferred to data coding module；Data coding module, it is used for
Receive and compile the next data Model layer identification codes of the data resolution module transmission, data IDAL layer identification codes, data abstraction factory
Code and DAL layer identification codes, then by compiled data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and
DAL layer identification codes are output to database with dll file respectively；Authentication module, prefix, database server are inputted for user
The data name that address and port, database account, password and needs connect, after being verified, is connected to the data
Storehouse.
The course of work of the present invention is as follows：By set data generation module, data resolution module, data coding module and
Authentication module, wherein：Data generation module generation data Model layer identification codes, data IDAL layer identification codes, data abstraction factory
Code and DAL layer identification codes, and by the data Model layer identification codes of generation, data IDAL layer identification codes, data abstraction works code and
DAL layer identification codes are transferred to data resolution module；Data resolution module parses the data Model that the data generation module transmission comes
Layer identification code, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes are simultaneously transferred to data coding module；Data are compiled
Code module receives and compiles the next data Model layer identification codes of the data resolution module transmission, data IDAL layer identification codes, data and takes out
As works code and DAL layer identification codes, then by compiled data Model layer identification codes, data IDAL layer identification codes, data abstraction factory
Code and DAL layer identification codes are output to database with dll file respectively；Authentication module inputs prefix, database clothes for user
The data name that business device address and port, database account, password and needs connect, after being verified, it is connected to described
Database.The base class code of table automatically generates in correspondence database, including generation attribute, establishment, modification, deletion, inquiry,
Existence, the foundation code segment such as construction of Model Attribute class, allow programmer to save a large amount of machines when carrying out Development of Module
The time of tool typing and the duplication of labour, so as to which more energy to be concentrated on to the exploitation of core business logic.Utilize automatic life
Into small tool, project development easily can be easily carried out.The data generation module includes subscriber interface module, the use
Family interface module includes：Typing sub-interface, self-defining data generation sub-interface, the typing sub-interface, self-defining data generation
Sub-interface is respectively used to for user's craft logging data, the generation data Model layer identification codes, data IDAL layer identification codes, data
Abstract factory code and DAL layer identification codes.The more convenient input data of user is made by subscriber interface module.Data generate
Module includes memory module, and memory module is used for data and the data Model layer generations of the generation for storing user's craft typing
Code, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes.The data of user's typing are stored by memory module
And the code file of generation is stored, so as to avoid the loss of data, when making a mistake being also convenient for recompility gives for change.
Above-described embodiment, the purpose of the present invention, technical scheme and beneficial effect are carried out further
Describe in detail, should be understood that the embodiment that the foregoing is only the present invention, be not intended to limit the present invention
Protection domain, within the spirit and principles of the invention, any modification, equivalent substitution and improvements done etc., all should include
Within protection scope of the present invention.
Claims (3)
1. can raising efficiency database coded system, it is characterised in that including data generation module, data resolution module, number
According to coding module and authentication module, wherein：
Data generation module, for generating data Model layer identification codes, data IDAL layer identification codes, data abstraction works code and DAL
Layer identification code, and the data Model layer identification codes of generation, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes are passed
It is defeated to arrive data resolution module；
Data resolution module, for parsing data Model layer identification codes, the data IDAL layer generations that the data generation module transmission comes
Code, data abstraction works code and DAL layer identification codes are simultaneously transferred to data coding module；
Data coding module, for receiving and compiling data Model layer identification codes, the data that the data resolution module transmission comes
IDAL layer identification codes, data abstraction works code and DAL layer identification codes, then by compiled data Model layer identification codes, data IDAL layers
Code, data abstraction works code and DAL layer identification codes are output to database with dll file respectively；
Authentication module, for user input prefix, database server address and port, database account, password and
The data name connected is needed, after being verified, is connected to the database.
2. it is according to claim 1 can raising efficiency database coded system, it is characterised in that the data generate mould
Block includes subscriber interface module, and the subscriber interface module includes：Typing sub-interface, self-defining data generation sub-interface, it is described
Typing sub-interface, self-defining data generation sub-interface are respectively used to for user's craft logging data, the generation data Model layers
Code, data IDAL layer identification codes, data abstraction works code and DAL layer identification codes.
3. it is according to claim 1 can raising efficiency database coded system, it is characterised in that the data generate mould
Block includes memory module, memory module be used for the data and generation for storing user's craft typing data Model layer identification codes,
Data IDAL layer identification codes, data abstraction works code and DAL layer identification codes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711172859.0A CN107844295A (en) | 2017-11-22 | 2017-11-22 | Can raising efficiency database coded system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711172859.0A CN107844295A (en) | 2017-11-22 | 2017-11-22 | Can raising efficiency database coded system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107844295A true CN107844295A (en) | 2018-03-27 |
Family
ID=61680011
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711172859.0A Pending CN107844295A (en) | 2017-11-22 | 2017-11-22 | Can raising efficiency database coded system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107844295A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109634567A (en) * | 2018-12-07 | 2019-04-16 | 武汉瓯越网视有限公司 | A kind of information creating method, device, terminal and storage medium |
| CN116578273A (en) * | 2023-02-28 | 2023-08-11 | 中国长江三峡集团有限公司 | Coding structure design method and device, storage medium and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050149907A1 (en) * | 2003-12-08 | 2005-07-07 | Greg Seitz | Method and system to automatically generate software code |
| CN102122247A (en) * | 2011-03-17 | 2011-07-13 | 深圳市同洲软件有限公司 | Automatic code generating system and method |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
-
2017
- 2017-11-22 CN CN201711172859.0A patent/CN107844295A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050149907A1 (en) * | 2003-12-08 | 2005-07-07 | Greg Seitz | Method and system to automatically generate software code |
| US20170199821A1 (en) * | 2003-12-08 | 2017-07-13 | Paypal, Inc. | Custom caching |
| CN102122247A (en) * | 2011-03-17 | 2011-07-13 | 深圳市同洲软件有限公司 | Automatic code generating system and method |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109634567A (en) * | 2018-12-07 | 2019-04-16 | 武汉瓯越网视有限公司 | A kind of information creating method, device, terminal and storage medium |
| CN109634567B (en) * | 2018-12-07 | 2022-02-22 | 武汉瓯越网视有限公司 | Information creating method, device, terminal and storage medium |
| CN116578273A (en) * | 2023-02-28 | 2023-08-11 | 中国长江三峡集团有限公司 | Coding structure design method and device, storage medium and electronic equipment |
| CN116578273B (en) * | 2023-02-28 | 2024-02-09 | 中国长江三峡集团有限公司 | Coding structure design method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102542002B (en) | Satellite telemetry data treatment system and realization method thereof | |
| CN101582079B (en) | Object query method and device | |
| CN105260403A (en) | Universal cross-database access method | |
| CN104361139A (en) | Data importing device and method | |
| CN102111282A (en) | Information management system architecture based on telecommunication service (TS) and building method thereof | |
| CN102708203A (en) | Database dynamic management method based on XML metadata | |
| CN104461531B (en) | A kind of implementation method of reporting system SQL | |
| CN101256650A (en) | Method and system for extracting enterprise data based on service entity | |
| CN105138613A (en) | Business object and xml message mutual conversion method and system | |
| CN101572696A (en) | Method and device for validating data on webpage form | |
| CN106600394A (en) | Method and system for reimbursement recording of electronic proof | |
| CN102984260A (en) | Internet account number and password information management method and system | |
| CN107844295A (en) | Can raising efficiency database coded system | |
| CN106095698A (en) | OO caching write, read method and device | |
| CN103914290A (en) | Operating command processing method and device | |
| CN106155769A (en) | A kind of workflow processing method, device and workflow engine | |
| CN103746746A (en) | Business system of network device | |
| CN104679793A (en) | Dynamic invoice template invoice issuing system | |
| CN108205454A (en) | Data management automatic production of HTML page method and system based on Extensible template library | |
| CN103902269A (en) | System and method for generating MIB files through XML files | |
| CN101772043A (en) | Office data checking method and device | |
| CN102426612A (en) | Condition object query method and system | |
| CN100504878C (en) | SQL statement construction method and apparatus for preprocessing special-character | |
| CN103218723A (en) | Product anti-fake system and method by means of machine vision and on basis of two-dimensional figure | |
| CN110489207A (en) | Verification method, apparatus and computer readable storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180327 |
|
| RJ01 | Rejection of invention patent application after publication |