摘要

在信息化时代的不断冲击下，路灯信息管理与计算机技术的结合，将会是一条提高路灯信息管理水平的捷径。使用计算机对的各项基本信息进行管理，比起手工管理来说既方便又简便，而且易于管理、搜索速度快、存储量大等多个优点。将其使用在路灯信息管理中，不仅能够提高路灯信息管理中管理员的工作效率，而且可以使路灯信息管理更加科学与规范。从某些方面上来说，现代路灯信息管理的不断标准化促使路灯信息管理各方面的管理都逐渐与现代信息处理密切相连，因此应该开发路灯信息管理系统将现代信息处理更快的融入到路灯信息管理之中。

近年来，随着路灯信息管理的发展以及路灯信息管理范围的增广无疑增加了路灯信息管理机构与工作人员的压力。通过几年的资料收集以及调查研究，路灯信息管理部门已经拥有了非常丰富的路灯信息管理数据，但以前的管理都是通过人工的去巡查、管理等，这种传统的管理方法与现在高速发展的互联网状况已经严重不能适应，在目前的路灯信息管理中已经显得困难重重，没有发挥应有的作用。近年为了健全和完善我校路灯的管理体制，充分发挥路灯的优势，提高社团发展水平，促进路灯活动向健康、文明、向上的方向发展，特制定本管理办法。实现信息化建设，使管理手段逐步走向数字化、智能化、现代化。依靠信息化建设的现代化管理系统是路灯信息管理系统逐步完善、规范和成熟应用的必然发展趋势。

根据本系统的研究现状和发展趋势，系统从需求分析、结构设计、数据库设计，在到系统实现，分别为前端实现和后端实现。论文内容从系统描述、系统分析、系统设计、系统实现、系统测试来阐述系统的开发过程。本系统力求结合实际找出一种切实可行的开发方案，经过反复研究和学习，借助JSP编程语言、sqlserver数据库和tomcat服务器来完成系统的所有功能，最后进行系统测试，来检测系统的权限和漏洞，从而将系统完善，达到符合标准。

关键字：路灯信息管理系统，JSP编程语言，sqlserver数据库

Design implementation of the JSP based lamp management information system

Abstract

Under the continuous impact of the information age, the combination of street lamp information management and computer technology will be a shortcut to improve the level of information management of street lamps. Using computer to manage all the basic information, compared with the manual management convenient and simple, and easy to manage, search speed and large storage, and other advantages. Its use in the street lamp information management, not only can improve the efficiency of work at the street lamp in the information management, and can make the street lamp information management more scientific and standard. In some ways, modern street lamp information management standardization of led street lamp information management all aspects of the management are closely connected with the modern information processing gradually, therefore should develop street lamp information management system to modern information processing, faster into the order of street lamp information management.

In recent years, with the development of lamp information management and the increasing extent of lamp information management, it has undoubtedly increased the pressure on the information management agencies and workers. Through several years of data collection and investigation and study, street lamp information management has a very rich street lamp management information data, but the previous management is through the artificial to search, management, etc., the traditional management methods and the rapid development of Internet has serious now can not adapt to, in the street light is in the information management difficulties, did not play a proper role. In recent years, in order to improve and perfect the management system of street lamp of our school, give full play to the advantages of street lamp, improve the level of community development, promote the street lamp activities to develop in the direction of healthy, civilized, and progressive, formulates this management approach. Realizing the construction of informatization, we will make the management means digital, intelligent and modern. The modernization management system relying on informationization is the inevitable trend of the gradual improvement, standardization and mature application of street lamp information management system.

According to the research status and development trend of this system, the system from the demand analysis, structure design, database design, in to the system implementation, respectively for the front-end and back-end. The paper discusses the development process of the system from system description, system analysis, system design, system implementation and system test. The system tries to combine the actual find out a feasible development plan, after repeated research and study, using the JSP programming language, essentially a database and tomcat server to accomplish all functions of the system, and finally to the system test, to detect system permissions and loopholes, thus the system perfect, to conform to the standard.

Key words:Streetlamp information management system, JSP programming language, sqlserver database

摘要

The implementation of the JSP based customer management system design