Design And Realization Of A Web Database Application System

Along with Internet and Web technology developing, the dynamic Web database, which unifies the Web technology and the database, is to become the Web engineering research hot spot nowadays. We analyzed several essential technologies about Web database system. Based on analysis of the development, composition and principle about several Web database system architecture, we discussed their advantages and defects, especially the B/S/S structure. Moreover, through the introduction, analysis and comparison about several kinds of Web database accessing technology, we showed that ASP.NET/ADO.NET solution is superior in developing the Web database application system. Aimed at the flaws of the traditional way in database operation, a new solution is proposed. We used C#. NET to visit large-scale database Oracle as an example. Differently from the traditional method, the new design does not establish a class for each table, but compiles a general module to complete all the elementary operation on all the tables. As a result, the database operation becomes succinct, the procedure structure is clear, the code quantity is reduced, and the maintenance is more convenient. Also, an example -costomer service management system based on Web is realized, which is a part of the Internet content control system, and also a Web database system, has used B/S/S architecture and ADO.NET database accessing technology. The system function and the design is described in detail, and we used a function module as an example to introduce the step of the development and the method of the realization. We used the new solution, and compared it with the traditional developing pattern. Through the test, the system is proved to have good performance.