通达员工销售业绩管理系统摘要由于计算机技术的飞速发展,数据库技术作为数据管理的一个有效的手段,在各行各业中得到越来越广泛的应用。

因此,本文围绕一个“销售业绩管理系统”程序的设计课题为背景,详细介绍了以JSP和ORACLE为语言编写管理信息系统的过程。

该程序通过JDBC来实现数据库的连接,并具有典型的数据库应用系统的特征,完成了系统结构与现实生活的紧密结合。

管理系统的开发不仅是一个应用程序编写的过程,更重要的是在系统分析和设计阶段所做的工作。

该程序在设计过程中严格遵循软件工程学的方法,用分阶段的生命周期计划严格管理,并主要讲述了程序的总体设计、详细设计阶段,对程序进行需求迭代,不断修正和改进,利用ORACLE的强大数据库功能,直到形成一个完善的可行性系统.优美、秀丽的界面,方便实用的查询与维护功能共同构成了“销售业绩管理系统”。

关键词:JSP，ORACLE，软件工程，管理信息系统ABSTRACTBecause of the rapid development of computer technology, database technology as an effective means of data management, in all walks oflife are increasingly wide application. Therefore, this article on a "sale achievement management system" design and procedures for applications development topics background, details and Oracle to add language to the process of preparing management information systems. The procedure adopted to achieve the target data add the ado with JSP prospects background Oracle databases and database applications withtypical characteristics, and completed the structure and system combining real life.Management system applications development is not only a preparation process, but more importantly in the analysis and design phase work. The procedure strictly followed in the design process software engineering methods, and use a phased plan to manage the life cycle and on the main procedures designed, detailed design stage, the demand for computation procedures, and constantly revised and improved, the use of Oracle powerful database functions, Until the feasibility of forming a perfect system. beautiful and attractive interface for practical information and the maintenance of the common functions constitute a " sale achievement management system."Keywords: JSP，ORACLE，Software Engineering, Management Information 目录1 前言 ..................................................................... . (1)1.1 课题的来源及意义...................................................................... . (1)1.2 国内外发展状况...................................................................... .. (1)1.3 本课题研究的目标...................................................................... . (2)1.4 本课题研究的内容...................................................................... ............................... 2 2系统需求分析 ..................................................................... .. (3)2.1 系统的可行性研究...................................................................... . (3)2.2 功能分析...................................................................... .. (3)2.3 系统开发环境...................................................................... ....................................... 3 3 主要用到的技术和工具 ..................................................................... (4)3.1 JSP技术 ..................................................................... (4)3.2 Servlet介绍...................................................................... . (4)3.3Tomcat ................................................................. . (5)3.4 数据库访问接口---JDBC技术 ..................................................................... . (6)3.5 MVC框架...................................................................... ................................................ 6 4 总体设计 ..................................................................... . (7)4.1 系统主要功能设计...................................................................... . (7)4.2 系统登录功能流程图...................................................................... ........................... 8 5 数据库设计...................................................................... .. (9)5.1 数据库概念结构设计...................................................................... (9)5.2数据库逻辑结构设计...................................................................... .......................... 11 6 详细设计 ..................................................................... .. (13)6.1 主页面的设计实现...................................................................... .. (13)6.2 登录界面的实现...................................................................... (13)6.3 增加新员工界面的实现...................................................................... (14)6.4 更新销售业绩界面的实现...................................................................... .. (14)6.5 删除产品信息界面的实现...................................................................... .. (15)6.6关键部分及实现...................................................................... .................................. 15 7系统测试...................................................................... ...................................................... 18 结论 ..................................................................... .......................................................... 19 谢辞 ..................................................................... .......................................................... 20 参考文献 ..................................................................... . (21)1 前言1.1 课题的来源及意义现代信息技术的发展，在改变着我们的生活方式的同时，也改变着我们的工作方式。