An Investigation Of Power Business Expanding System Based On B/S Mode

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.