CN107168700A - Foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven - Google Patents
Foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven Download PDFInfo
- Publication number
- CN107168700A CN107168700A CN201710300343.3A CN201710300343A CN107168700A CN 107168700 A CN107168700 A CN 107168700A CN 201710300343 A CN201710300343 A CN 201710300343A CN 107168700 A CN107168700 A CN 107168700A
- Authority
- CN
- China
- Prior art keywords
- sql
- select
- write
- database
- foundational development
- 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.)
- Granted
Links
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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- G06F16/986—Document structures and storage, e.g. HTML extensions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a kind of foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven, it is characterized in that, additions and deletions change the list looked into and database processing and all automatically generated by single sql select sentences driving, HTML form need not be write, sql insert sentences need not be write, sql update sentences need not be write, sql delete sentences need not be write, only need to define a select sql sentence, and each Chinese Fields title and the type of data-bound control of field.The rapidly and efficiently exploitation of the suitable Web background systems of the present invention, development rate is 1/10th of usual manner, substantially increases development efficiency.General Role Management, module management, rights management, built-in login authentication functions are additionally provided in framework.
Description
Technical field
The present invention relates to the full-automatic list development technique field of Web background systems, more particularly to a kind of based on SQL-
The full-automatic WEB back-stage management list foundational development framework and its implementation for realizing database manipulation of SELECT drivings.
Background technology
At present, WEB application background management system, is required for first doing HTML form, also wants HTML form to carry out specification name,
Then also to be received in service end according to these form names, and for different submission behaviors, write different
Insert update delete select sentences.It is all repeated labor that whole process is most of.For a medium complexity
The additions and deletions of list change investigation reason, generally require several hours, or even the time of several days could complete.Most efforts
In the drafting of html table and the transmission of data and simple database manipulation.In addition, module management, Role Management, authority
Management, is also required for overlapping development.
In summary, traditional development scheme, loses time and energy.
The content of the invention
It is an object of the invention to provide a kind of full-automatic list WEB background management systems driven based on SELECT-SQL
Foundational development framework, effectively solves above-mentioned technical problem.
Effectively to solve above-mentioned technical problem, the technical scheme that the present invention takes is as follows：
Based on the foundational development framework of the SQL-SELECT full-automatic list WEB background management systems driven, including one be
System framework, the system architecture is the B/S frameworks based on J2EE, and the system architecture includes database and pattern file, foundation frame
Structure is as follows：Basic UI element components layer, the UI element components layer with database binding, page view component layer and pattern layer, its
It is characterised by, additions and deletions change the list looked into and database processing and all automatically generated by single sql-select sentences driving, nothing
HTML form need to be write, without writing sql-insert sentences, without writing sql-update sentences, without writing sql-
Delete sentences, it is only necessary to define a select-sql sentence, and the Chinese Fields title of each field and data binding are controlled
The type of part.
Particularly, all java are realized and are responsible for the basic form controls of the HTML that renders, including check box CheckBox,
Date choice box DateSelect, selection of time frame DateTimeSelect, digital choice box DigitSelect, radio box
Radio and choice box Select.
Particularly, the HTML form control bound automatically with database, including database record set binding selection are realized
Frame RSSelect, grid column GridField, data form DataGrid and paged data form DataGridPage.
Particularly, the abstract class page view control for including any of the above control for rendering full page is realized.
Particularly, in service view code, it is only necessary to write a select-sql sentence, the gauge outfit of each column is defined,
The data control species of each column is defined, the newly-increased of service logic is just automatically realized, changes, delete, query function.
Particularly, built-in service menu modular functionality, each service menu module is an independent JAVA class, registration
In database.
Particularly, the rights management of built-in Role Management and service menu module granularity.
A kind of implementation for realizing above-mentioned foundational development frame application, this method comprises the following steps：
1) above-mentioned basic framework is packaged into Jar APMB packages；
2) newly-built JAVA projects；
3) Jar APMB packages and data base configuration file and css patterns file are replicated into newly-built JAVA projects；
4) configuration database is connected, configuration base library position；
5) page view base class is inherited, business module class is realized, a SQL-SELECT sentence is write, each column is defined
Gauge outfit, defines data control type；
6) issue；
7) framework overall theme style changes：Replacement is changed to the topic style css files in framework.
Particularly, the abstract foundation class for including any of the above control for rendering full page, such as page view control are realized
Part.
Beneficial effects of the present invention are：The full-automatic list WEB backstages driven based on SQL-SELECT that the present invention is provided
The foundational development framework of management system, is a set of B/S frameworks based on J2EE, without writing HTML form, without writing additions and deletions
Change and look into SQL sentences, be adapted to the rapidly and efficiently exploitation of Web background systems, development rate is 1/10th of usual manner, significantly
Improve development efficiency.General Role Management is additionally provided in framework, module management, rights management, built-in login authenticates work(
Energy.
The present invention is described in detail below in conjunction with the accompanying drawings.
Brief description of the drawings
Fig. 1 is that the basis of the present invention based on the SQL-SELECT full-automatic list WEB background management systems driven is opened
Send out the system architecture diagram of framework.
Fig. 2 is that the basis of the present invention based on the SQL-SELECT full-automatic list WEB background management systems driven is opened
Send out the development approach schematic diagram of framework.
Embodiment
Embodiment 1
As shown in Figures 1 and 2, the full-automatic list WEB back-stage management driven based on SQL-SELECT that the present invention is provided
The foundational development framework of system, is a set of B/S frameworks based on J2EE, without writing HTML form, changes without writing additions and deletions and looks into
SQL statement, is adapted to the rapidly and efficiently exploitation of Web background systems, development rate is 1/10th of usual manner, is substantially increased
Development efficiency.General Role Management, module management, rights management, built-in login authentication functions are additionally provided in framework.
Realize the basic form controls of HTML that all java are responsible for rendering, such as choice box, date choice box, time choosing
Select frame, digital choice box, radio box, check box.
Realize the HTML form control bound automatically with database, such as database record set binding choice box, grid column,
Data form, paged data form.
Realize the abstract class page view control for including any of the above control for rendering full page.
In service view code, it is only necessary to write a select-sql sentence, the gauge outfit of each column is defined, each column is defined
Data control species, just automatically realize the newly-increased of service logic, change, delete, query function.
Built-in service menu modular functionality, each service menu module is an independent JAVA class, is registered in number
According in storehouse.
The built-in rights management of Role Management and service menu module granularity.
Applicant states that person of ordinary skill in the field is on the basis of above-described embodiment, by above-described embodiment
Step, the technical scheme with Summary is combined, thus produce new method, be also the present invention record scope it
One, the application no longer enumerates the other embodiment of these steps to make specification concise.
Realize that the method for above-mentioned foundational development frame application comprises the following steps：
1) above-mentioned basic framework is packaged into Jar APMB packages
2) newly-built JAVA projects；
3) Jar APMB packages and data base configuration file and css patterns file are replicated into newly-built project；
4) configuration database is connected, configuration base library position；
5) page view base class is inherited, business module class is realized, a SQL-SELECT sentence is write, each column is defined
Gauge outfit, defines data control type；
6) issue；
7) framework overall theme style changes：Replacement is changed to the topic style css files in framework.
The technology path that prior art is different from the present embodiment is：
It is a set of B/S frameworks based on the SQL-SELECT full-automatic sheet disposals driven, without writing HTML form, nothing
Additions and deletions need to be write change and look into SQL statement, be adapted to the rapidly and efficiently exploitation of Web background systems.It is also built-in there is provided general in framework
Module management, Role Management, rights management logs in authentication functions, improves ten times of development efficiency.
The another statement of applicant, the present invention illustrates the implementation method and apparatus structure of the present invention by above-described embodiment,
But the invention is not limited in above-mentioned embodiment, that is, do not mean that the present invention has to rely on the above method and structure could be real
Apply.Person of ordinary skill in the field is it will be clearly understood that any improvement in the present invention, to institute's side implementation method of the present invention etc.
Effect replacement and addition, the selection of concrete mode of step etc., within the scope of all falling within protection scope of the present invention and being open.
The present invention is not limited to above-mentioned embodiment, all to realize the present invention using to similar structure and its method of the invention
All embodiments of purpose are within the scope of the present invention.
Claims (9)
1. based on the foundational development framework of the SQL-SELECT full-automatic list WEB background management systems driven, including a system
Framework, the system architecture is the B/S frameworks based on J2EE, and the system architecture includes database and pattern file, architecture
It is as follows：Basic UI element components layer, the UI element components layer with database binding, page view component layer and pattern layer, it is special
Levy and be, additions and deletions change the list looked into and database processing and all automatically generated by single sql-select sentences driving, without
HTML form is write, without writing sql-insert sentences, without writing sql-update sentences, without writing sql-delete
Sentence, it is only necessary to define a select-sql sentence, and each Chinese Fields title and the class of data-bound control of field
Type.
2. foundational development framework according to claim 1, it is characterised in that realize all java and be responsible for what is rendered
HTML bases form controls, including check box CheckBox, date choice box DateSelect, selection of time frame
DateTimeSelect, digital choice box DigitSelect, radio box Radio and choice box Select.
3. foundational development framework according to claim 1, it is characterised in that realize the HTML bound automatically with database
Form controls, including database record set binding choice box RSSelect, grid column GridField, data form DataGrid
With paged data form DataGridPage.
4. foundational development framework according to claim 1, it is characterised in that realize render full page include right
It is required that the abstract class page view control of various controls described in 2 and 3.
5. foundational development framework according to claim 1, it is characterised in that in service view code, it is only necessary to write
One select-sql sentence, defines the gauge outfit of each column, defines the data control species of each column, just automatically realizes service logic
It is newly-increased, change, delete, query function.
6. foundational development framework according to claim 1, it is characterised in that built-in service menu modular functionality, each
Service menu module is an independent JAVA class, is registered in database.
7. foundational development framework according to claim 1, it is characterised in that built-in Role Management and service menu module grain
The rights management of degree.
8. a kind of implementation for realizing foundational development frame application described in claim 1-7 any one, it is characterised in that should
Method comprises the following steps：
1) basic framework is packaged into Jar APMB packages；
2) newly-built JAVA projects；
3) Jar APMB packages, data base configuration file and css patterns file are replicated into newly-built JAVA projects；
4) configuration database is connected, configuration base library position；
5) page view base class is inherited, business module class is realized, a SQL-SELECT sentence is write, the gauge outfit of each column is defined,
Define data control type；
6) issue.
9. implementation according to claim 8, it is characterised in that this method is further comprising the steps of：
7) framework overall theme style changes：Replacement is changed to the topic style css files in framework.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710300343.3A CN107168700B (en) | 2017-04-30 | 2017-04-30 | Basic development framework of full-automatic form WEB background management system based on SQL-SELECT drive |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710300343.3A CN107168700B (en) | 2017-04-30 | 2017-04-30 | Basic development framework of full-automatic form WEB background management system based on SQL-SELECT drive |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107168700A true CN107168700A (en) | 2017-09-15 |
| CN107168700B CN107168700B (en) | 2020-06-30 |
Family
ID=59813752
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710300343.3A Active CN107168700B (en) | 2017-04-30 | 2017-04-30 | Basic development framework of full-automatic form WEB background management system based on SQL-SELECT drive |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107168700B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108563694A (en) * | 2018-03-19 | 2018-09-21 | 广州视源电子科技股份有限公司 | Method, apparatus, computer device and storage medium for performing SQ L for logical deletion |
| CN110531964A (en) * | 2019-08-30 | 2019-12-03 | 苏州中弘软件技术有限公司 | The intelligent developed method of software personalisation |
| CN112507011A (en) * | 2020-12-16 | 2021-03-16 | 江苏龙虎网信息科技股份有限公司 | Method for establishing program automation database model |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN103136263A (en) * | 2011-11-23 | 2013-06-05 | 英业达股份有限公司 | Method for automatic generation of structured query language (SQL) sentences |
| US20130205246A1 (en) * | 2011-12-21 | 2013-08-08 | Donald Richard Schmidt | GUI Document Management System |
| US20150074083A1 (en) * | 2013-09-06 | 2015-03-12 | Sap Ag | Sql enhancements simplifying database querying |
| CN106406884A (en) * | 2016-09-19 | 2017-02-15 | 深圳市东信时代信息技术有限公司 | A .NET MVC mode-based fundamental development framework for WEB background management application systems |
-
2017
- 2017-04-30 CN CN201710300343.3A patent/CN107168700B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN103136263A (en) * | 2011-11-23 | 2013-06-05 | 英业达股份有限公司 | Method for automatic generation of structured query language (SQL) sentences |
| US20130205246A1 (en) * | 2011-12-21 | 2013-08-08 | Donald Richard Schmidt | GUI Document Management System |
| US20150074083A1 (en) * | 2013-09-06 | 2015-03-12 | Sap Ag | Sql enhancements simplifying database querying |
| CN106406884A (en) * | 2016-09-19 | 2017-02-15 | 深圳市东信时代信息技术有限公司 | A .NET MVC mode-based fundamental development framework for WEB background management application systems |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108563694A (en) * | 2018-03-19 | 2018-09-21 | 广州视源电子科技股份有限公司 | Method, apparatus, computer device and storage medium for performing SQ L for logical deletion |
| CN108563694B (en) * | 2018-03-19 | 2021-04-13 | 广州视源电子科技股份有限公司 | SQL execution method and device for logic deletion, computer equipment and storage medium |
| CN110531964A (en) * | 2019-08-30 | 2019-12-03 | 苏州中弘软件技术有限公司 | The intelligent developed method of software personalisation |
| CN110531964B (en) * | 2019-08-30 | 2023-03-14 | 苏州中弘软件技术有限公司 | Personalized intelligent software development method |
| CN112507011A (en) * | 2020-12-16 | 2021-03-16 | 江苏龙虎网信息科技股份有限公司 | Method for establishing program automation database model |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107168700B (en) | 2020-06-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107193545B (en) | Component-oriented multi-language collaborative development device, method and system | |
| CN101729594B (en) | Remote configuration control method and system | |
| CN103425778B (en) | A kind of intelligent development platform of database application system | |
| CN110069246A (en) | The plateform system and its application that a kind of Java Web application is quickly developed | |
| CN101383871B (en) | Network element configuration implementing method and apparatus | |
| CA2446809A1 (en) | General and reusable components for defining net-centric application program architectures | |
| CN103019684A (en) | Dynamic template-based business page configuring method | |
| CN102663103A (en) | Configurable method for automatically generating database and accessing data | |
| CN104793961A (en) | Quick JavaWeb development method and system using native Web codes | |
| CN107168700A (en) | Foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven | |
| CN106201501A (en) | A kind of configurableization construction method to mobile terminal form interface and system | |
| CN104461743A (en) | Device and method for automatically generating resources and configuration | |
| CN107480234B (en) | Git-based enterprise-level document center implementation method | |
| CN102393889A (en) | Permissions configuration management system | |
| CN103996000A (en) | Authority management system and method | |
| CN107608669A (en) | A kind of method based on database table structure automatic generation function and the page | |
| CN105761007A (en) | Information management software design aiding method and information management software design aiding system | |
| CN105930344B (en) | A kind of database application system quick development platform based on product development process | |
| CN104008441A (en) | Task management system and method for automatically submitting files into version library | |
| CN104182494A (en) | Method and system capable of realizing CMS website construction with PC terminal and mobile terminal | |
| CN105867944A (en) | Web front-end terminal operating layer and implementing method thereof | |
| CN102368848A (en) | Wireless communication device and configuration method thereof | |
| CN106599167A (en) | System and method capable of supporting incremental upgrading of database | |
| CN103399744B (en) | A kind of method building business gate platform | |
| CN106406884A (en) | A .NET MVC mode-based fundamental development framework for WEB background management application systems |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |