Research And Application Of General CRUD Development Framework Based On B/S Structure

The article deals with the present situation of WEB technology both at home and abroad.It also throws light on the significance and necessity of developing generic CRUD structure to meet inland demands.First in and generic structural production based on PHP language,FleaPhp structure and Smarty moduel has been developed There are detailed analyses about the function of this production.Also,the article throws light on the realistic principles and introduces usage of various functions.B/S (Browser/Server) structure is the browser and the server structure.lt is along with Internet technology starting, to C/S structure one kind of change or improvement structure. Under this kind of structure, the user work contact surface is realizes through the WWW browser, Little partial business logic in front end (Browser) realization, But main business logic carries the (Server) realization in the server, Forms three structures: Client side, HTTP server end, database server end.The B/S structure has the following merit: The system disposition is convenient; Lower to the client side system disposition request; Lower to the server system disposition request; Lower to the network performance requirement; The data security is high; The system promotes simply convenient; Easy to operate; Has provided the consistent user interface; Has the stronger information system integration; The system structure is clear; System use cost reduction; The system migration is convenient.In past, B/S structure main application in website development. But along with website function gradually formidable, has the more backstage data management module to need to develop. Meanwhile along with the B/S structure in enterprise's widespread application, the more and more many data management module also starts to use the B/S structure to carry on.These website backstage data management module and business data administration module, basic need same function.Namely: addition, revision, inquiry, deletes and so on.How develops the data management function fast, becomes the current software development profession the main research question.For the faster development large and middle scale B/S application project, appeared each kind of development frame.If Zend Framework, Symfony, FleaPhp, CakePhp and so on. These frame has carried on project in MVC three logic the division, and has realized the general data accessing level, as well as many commonly used first floor functions.But regarding the data sheet fast development, the current all frames does not have the thorough realization as before.CRUD is at first refers when makes computation processing the increase, the inquiry (obtains data), renews and deletes several words the first letter simple forms, mainly is used in describes in the software system the database or the lasting level elementary operation eo function.Along with the demand and the technical development, in the current software development profession, the content which CRUD contained obtained the enormous expansion. Not only including to the data sheet inquiry, the addition, revises and deletes these elementary operation eos, also includes the search, sorting, divides the page, derives, the store, chooses and so on the correlation operations.An general CRUD scaffold should have the following function at least:Tabular display: Two-dimensional surface form way demonstration data most is familiar with which by the majority users;Store demonstration: The frame may let the exploiter choose whether in front of each data line demonstrated a store, the convenient user recognizes the data line;Data statistics: Demonstrates the total data number of lines, current number of lines, total number of pages, current number of pages;Minute page navigation: The user may use "home page", "previous page", "next page", "tail page" carries on turns the page fast, also may assign the number of pages to carry on skipping directly.Minute page establishment: The user may establish each page of demonstrations the number of lines to suit own graphic display device as well as individual custom voluntarily;Sorting establishment: The user may establish the data voluntarily the sorting basis, may act according to the value which in the form arranges in order willfully to carry on sorting; May establish the sorting direction for to rise the foreword or the descending sequence arrangement;Combination inquiry: The user may conveniently inquire the data which needs. The user may act according to a data row the value to carry on the inquiry, also may simultaneously assign many data row the value to carry on the complex combination inquiry; Simultaneously may to inquire a result minute page, the sorting demonstration;Assistance search: The user when assigns a search condition, the frame can demonstrate gradually satisfies part search condition value which the user inputs, in order to the user may direct selection have the value carries on the search;Examines the details: The user may assign a data line, examines this data line the detailed information; The system can by each line demonstrate a data row the value way demonstrates this data line all data row information;Input data: The user inputs the recent data line by entire system unification form each row data value. Front end the frame can the data value which inputs to the user carry on confirms (client side) to guarantee the user input the data form accuracy and the content validity; Rear end simultaneously the frame also can the data which inputs to the user carry on confirms (server end) to prevent the illegal invasion and the malicious destruction;Revision data: The user revises the original data line by entire system unification form each row data value.Deletion data: The user may delete a data conveniently, deletes before the movement execution, the frame can prompt the user to carry on confirms this operation, in order to avoid loses the data accidentally. Chooses the operation: In order to facilitate the user concurrent operation good data, the frame provides "all elects/ cancel all elects", enables the user to be possible the disposable choice current page all data line, or cancels the choice current page all data line; The user may aim at the line which all selects to carry on the batch operation, for example: Chooses the deletion, chooses the verification to pass and so on;Data printing: The user may print the current tabular display data;The data derives: The user may derive the current tabular display data by the general data format, in order to use other tools to carry on for the data further processes.The exploiter carries on the concrete application development who regarding the use frame, an outstanding frame also needs to provide the enough expansion connection to realize user's special demand, These connections should include at least: To assigns the data line the special operation connection; Special operation connection simultaneously carries on which to the good data; Carries on before the tabulation in the data to carry on extra processing to the data the connection; Carries on before the printing to the data form the extra processing connection; Carries on to the data form derives before the operation the extra processing connection; The user increases in front of line of data the pretreatment connection; In front of user examination data pretreatment connection; In front of user revision data pretreatment connection; The user carries on before the revision operation to the data line the pretreatment connection; In front of user deletion data line pretreatment connection; After the user increases line of data the post-processing connection; After the user revises line of data the post-processing connection; The exploiter to increases the data line operation the code cover connection; The exploiter to revises the data line operation the code cover connection; The exploiter to deletes the data line operation the code cover connection; The exploiter to examines the data line details operation the code cover connection; The exploiter to tabulates the function the code cover connection; The exploiter to prints the function the code cover connection; The exploiter to derives the function the code cover connection.