I
装饰公司管理系统设计与实现
摘 要
本装饰公司管理系统是针对目前装饰公司管理的实际需求，从实际工作出发，对过
去的装饰公司管理系统存在的问题进行分析，结合计算机系统的结构、概念、模型、原
理、方法，在计算机各种优势的情况下，采用目前 jsp 中最流行 ssm 框架和 eclipse 编
辑器、sqlserver 数据库设计并实现的 。本装饰公司管理系统主要包括系统用户管理模
块、变幻图模块、行业资讯管理、员工信息管理、工资信息管理、登录模块、和退出模
块等多个模块。它帮助装饰公司管理实现了信息化、网络化，通过测试，实现了系统设
计目标，相比传统的管理模式，本系统合理的利用了装饰公司管理数据资源，有效的减
少了装饰公司管理的经济投入，大大提高了装饰公司管理的效率。
关键词：装饰公司管理；ssm 框架；sqlserver 数据库
II
ABSTRACT
This decoration company management system is aimed at the actual needs of the current
decoration company management. From the actual work, the problems existing in the
management system of the decoration company in the past are analyzed, and the structure,
concept, model, principle, and method of the computer system are combined with various
advantages of the computer. Under the circumstances, Designed and implemented using the
most popular SSM framework and eclipse editor and SQLServer database in the current JSP.
This decoration company management system mainly includes system user management
module, change diagram module, industry information management, employee information
management, salary information management, login module, and exit module. It has helped
decoration company management to realize information and networking, and has achieved the
goal of system design through testing. Compared with the traditional management model, this
system has reasonably used decoration company to manage data resources and effectively
reduced the economic investment of decoration company management. Has greatly improved
the efficiency of the decoration company's management.
【key words】：Decorative company management; ssm framework; Sqlserver database
III
目 录
装饰公司管理系统设计与实现 .........................................................................................I
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................1
2.1 ssm 框架 ...............................................................................................................1
2.1.1. Spring 框架 .................................................................................................1
2.1.2 SpringMVC..................................................................................................1
2.1.3. MyBatis.......................................................................................................2
2.2 sqlserver 数据库 ....................................................................................................2
2.3 jsp 技术 ..................................................................................................................2
第 3 章 系统分析...............................................................................................................5
3.1 可行性分析............................................................................................................5
3.1.1 经济可行性..................................................................................................5
3.1.2 技术可行性..................................................................................................5
3.1.3 操作可行性..................................................................................................5
3.2 需求分析................................................................................................................5
3.3 业务流程分析........................................................................................................6
3.4 数据流程分析........................................................................................................7
第 4 章 系统设计...............................................................................................................9
IV
4.1 系统结构设计........................................................................................................9
4.2 功能模块设计........................................................................................................9
4.3 数据库设计..........................................................................................................10
4.3.1 数据库设计概述........................................................................................10
4.3.1 概念设计....................................................................................................10
4.3.2 表设计........................................................................................................11
第 5 章 系统实现...........................................................................................................17
5.1 基本任务..............................................................................................................17
5.2 登录模块的实现..................................................................................................17
5.2.1 首页实现....................................................................................................17
5.2.2 管理员后台登录........................................................................................18
5.3 用户模块的实现..................................................................................................21
5.3.1 订单信息管理模块的实现........................................................................21
5.3.2 工资信息管理模块的实现........................................................................22
5.4 管理员模块的实现..............................................................................................24
5.4.1 用户管理模块的实现................................................................................24
5.4.2 注册模块及登录的实现............................................................................26
5.4.3 网站公告管理模块的实现........................................................................28
5.4.4 行业资讯管理模块的实现........................................................................30
5.4.5 变幻图管理模块的实现............................................................................32
5.5.5 员工信息管理模块的实现........................................................................33
第 6 章 系统测试...........................................................................................................36
6.1 测试目的..............................................................................................................36
6.2 测试概述..............................................................................................................36
6.3 单元测试..............................................................................................................36
V
6.3.1 添加测试....................................................................................................36
6.3.2 登录测试....................................................................................................37
6.4 集成测试..............................................................................................................38
第 7 章 总结...................................................................................................................39
致 谢...............................................................................................................................40
参考文献...........................................................................................................................40
