【作者】 黄娟娟；

【导师】 李晓明；

【作者基本信息】 武汉大学 ， 电力系统及其自动化， 2004， 硕士

【摘要】 在电力业扩报装系统中，需要实时、动态地处理大量的数据，将其归类统计，实现数据动态交互查询，同时支持用电管理人员进行决策分析。传统的业扩报装系统一般建立在客户机／服务器(C／S)模式之上，这种模式随着电力系统的不断发展和报装规模的扩大、应用程序的复杂程度不断提高，暴露出很多问题，如缺乏伸缩性、代码逻辑无法复用、系统维护和升级比较困难等。 针对上述问题，本文应用JSP技术提出了一种基于B／S模式的电力业扩报装系统的结构及其实现方法。该方法采用B／S(浏览器／服务器)模式的数据库体系，即利用Web服务器和JSP(动态服务器网页)作为数据库服务器的中间层，将客户机／服务器模式的数据库结构与Web技术密切结合，从而形成具有三层Web结构的浏览器／服务器模式的数据库体系，用JSP进行B／S模式的应用开发。这种开发模式是目前最流行的开发模式，它与当前主流数据库管理系统Oracle结合所设计的应用系统在理论和实践上都具有其先进性。 本文首先对供电企业业扩报装工作进行了详细的需求分析，在此基础上提出了该系统的总体设计方案和安全性策略，并介绍了本人参与的实际课题所开发的应用系统。该系统利用JDBC实现与数据库的连接，结合用户从页面提供的信息形成完备的SQL指令，对相应的实时数据库表进行操作，可在友好界面的引导下，指引用户方便地进行报装申报、用电信息和报装进度查询等操作。该系统还提供统计分析功能，可以分行业、用电类别、日期等对供电部门业扩报装情况进行统计分析。直观简洁的动态图像显示有利于决策分析，极大地减轻用电管理者的工作量。 基于B／S模式的业扩报装系统已在江西吉安供电公司试运行，实际应用表明该系统具有运行可靠、高效、使用方便、可扩展和易维护的特点。更多还原

【Abstract】 In the power business expanding system, in order to support electro-managers to analysis and make decision, a great deal of real-time data should be dealt with dynamically and be classified to statistic to realize the interactive query on the dynamical database. Usually, traditional business expanding system is based on C/S (Client/Server) mode which exposures many problems such as lack of retractility, logic of codes unable to be used repeatedly, maintenance and upgrade difficulty with the development of electric power system and enlarging of business expanding scale.Aiming at the problem above, a configuration and a realization method of power business expanding system based on B/S (Browser/Server) mode are presented in the paper applying JSP technique. The structure of B/S uses Web server and JSP as interlayer. A database system of B/S mode with tri-layer Web structure comes from the tight combination of B/S and Web technique. The application development of B/S mode using JSP is the most popular development mode currently, application systems developed by which and Oracle database (the leading DBMS today) are advanced either on theory or on practice.Based on the detailed analysis of the working flow of the business expanding in the power supply corporation, the holistic design scheme and security strategy are presented in this paper. Finally, the examples of application system are presented. The system realizes the connection with database using JDBC technique and the self-contained SQL commands are formed to handle real-time data table, which based on the information provided by users by pages. Users can apply business expanding and query electro-information and schedule of business expanding conveniently by the lead of friendly interface. The system provides the function of statistic and analysis, which can analyse business expanding based on trade, electro-sort and date. The clear and handsome dynamic chart is propitious to decision-making and analysis and lessen the workload of electro-managers to a large extent.The power business expanding system based on B/S mode has applied in Ji’an power supply bureau of JiangXi Province, practice application indicates that the system is reliable, efficient, easy to use, expand and maintain.更多还原