| Under the background of growing cable broadband services and based on CAMS billing system supplied by the equipment provider, user management software for cable broadband system is designed and developed to meet the requirements of a citys cable broadband user management. This paper introduces the significance of broadband management system in the development of Chinas cable television and broadband services and the component mode suitable for cable broadband user management system of this area– PC server + Windows + CAMS billing system + B/S user management software.The paper briefly introduces the user management software-related technology, including B / S architecture, ASP technique, query optimization technique, stored procedures and triggers, the ways to improve software performance and the measures to ensure system security. It makes the feasibility study of thesoftware and puts forward the software target. Using B / S design mode, the software selects ASP + IIS6.0, JavaScript and VBScript as Client-end script, Windows 2000 as the operating system of the server of cable broadband users management system and SQL Server 2000 as the server for database management.Demand analysis is the basis of systems design and implementation. This paper combines with the actual situation of cable broadband user management and makes a detailed analysis on the user requirements, including types of software users, types of broadband users, types of user service, operation types of software personnel, query requirements, statistical operation requirements, system management operation requirements and CAMS interface as well as the emphasis on the service processes such as opening an account, payment and authorization through operational flow diagram.In this paper, the software is designed and developed in a efficient, practical, real-time, flexible, scalable and secure way. The overall design of the software program is first proposed including design ideas and the composition of functional modules etc. In accordance with the steps and the standardization of the database design, the database is then designed in order to ensure security, integrity and shared ability of data. And then the detailed design on some of the software function modules is carried out including user log module, permission management module, users opening accounts operation module, users payment operation module and users authorization operation module. Finally, according to the ideas of software engineering, the software has been tested through the methods of safety test and pressure test.In the process of software research and development, we follows the ideas of the software engineering and considered fully the efficiency and the security of Software execution. Through earnest studies and practice, careful Analysis analytical and study, the solution has been proposed. |