Design And Implementation Of Cable TV Engineering Installation Management System

Nowadays we have entered an information society, where the scope of the application of information has been expanding greatly. Notably, the Project of CATV Installation & Management has become an important part in the informationization development of the overall TV engineering.Based on the fundamental thoughts and theories of the 00 analysis and design in software engineering, and making use of techniques like Java,MySQL and basic SDA, this paper has implemented the whole process of the system demand analysis and design from the TV user's application, installation work to post-charge management in the hope of meeting our demand for television management.This paper focus on the following aspects:1. The whole system is composed of the applyCATV model, installCATV model, FeesManage model, their related database models and User Information-Search model.2. The three major models:applyCATV, installCATV, FeesManage share the same SDA pattern, each of which consists of the BoundaryLayer, ControlLayer, EntityLayer, DataBase-access Layer.3. Making reasonable use of the event listeners of Swing and AWT in relevant event handling.4. Encapsulating the operation to the database to achieve a reuse of the businesss approaches.5. Making appropriate use of the CardLayout, incorporating the operation SwingLayer.6. The application of the SQL Language:the proper employment of the sql statements can enhance the system execution efficiency, so the system tries to retrieve all the query information using one sql statement.7. The application of the pop-up dialog:when we enter information via the system, the software will do verification work legally. If the entered information proved illegal, it will pop up the hint dialog. In the whole process of software development, a proper use of the pop-up dialog will significantly simplify the development work,reducing a great deal of unnecessary operation. 8. The application of TreeNodeModel:in this system, the TreeNodeModel assumes the page navigation work, making the system UI clear and operation simple.9. I have used some design patterns for the variation and evolution points of the system; when the frame displays UsingMaterialCost, the observer pattern is being used;whe computing the different projects cost, the composite pattern is being used; the different User Pay-OnFees and Privilege-Period use the strategy pattern. In addition, this paper contains the facade, singleton and factory patterns.10. In the preceding part of demand analysis, first, this paper create use cases according to the business process, including ApplyCATV, InstallCATV, FeesService. It demands to find out the important domain model in the process of analysing the use case. On the basis of this, we should make clear the main software class, class attribute, dependence of the association class, their initialization in the system and then painted out DCD(design class diagram) static view in the scenarios of ApplyCATV and InstallCATV. This created condition for the dynamic system operation.Additionally, I have done demand analysis in detailed about the system including the classes and their cooperation with each other, using Rational Rose 2003 (UML), which provides the basis for the continued code development. In the code implementation part, I list all codes of Login, UserSearchInformation and the system main frame; In the part of the ApplyCATV model, this paper lists some codes about BoundaryLayer, ControlLayer and EntityLayer; and in the part of InstallCATV and FeesService, this paper lists all the concrete implementation codes of the composite and strategy patterns for everyone.Finally, this paper sums up the technique work of system design and put forward improvement measures about existing problems.