毕 业 设 计（论 文）
题目：装饰工程管理系统——项目立项子系统的设计与实现
摘 要
如今社会上各行各业，都喜欢用自己行业的专属软件工作，互联网发展到这
个时候，人们已经发现离不开了互联网。新技术的产生，往往能解决一些老技术
的弊端问题。因为传统装饰工程项目信息管理难度大，容错率低，管理人员处理
数据费工费时，所以专门为解决这个难题开发了一个装饰工程管理系统——项目
立项子系统，可以解决许多问题。
装饰工程管理系统——项目立项子系统可以实现合同信息管理，合同报价管
理，客户管理，立项项目管理，公告信息管理，员工管理，预算报价管理，装饰
材料总计划管理，装修进度管理等功能。该系统采用了 Mysql 数据库，Java 语言，
Spring Boot 框架等技术进行编程实现。
装饰工程管理系统——项目立项子系统可以提高装饰工程项目信息管理问
题的解决效率，优化装饰工程项目信息处理流程，保证装饰工程项目信息数据的
安全，它是一个非常可靠，非常安全的应用程序。
关键词：装饰工程管理系统——项目立项子系统；Mysql 数据库；Java 语言
Abstract
Nowadays, all walks of life in society like to work with their own
industry-specific software. At this point in the development of the Internet, people
have found that they cannot do without the Internet. The emergence of new
technologies can often solve the drawbacks of some old technologies. Because the
traditional decoration engineering project information management is difficult, the
fault tolerance rate is low, and the management personnel is labor-intensive and
time-consuming to process the data, so a decoration engineering management system
- the project establishment subsystem has been specially developed to solve this
problem, which can solve many problems.
Decoration engineering management system - project establishment subsystem
can realize contract information management, contract quotation management,
customer management, project establishment project management, announcement
information management, employee management, budget quotation management,
decoration material master plan management, decoration progress management and
other functions. The system uses Mysql database, Java language, Spring Boot
framework and other technologies for programming.
Decoration engineering management system - project establishment subsystem
can improve the efficiency of solving decoration engineering project information
management problems, optimize the information processing process of decoration
engineering projects, and ensure the security of decoration engineering project
information data. It is a very reliable and very safe application.
Key Words ： Decoration engineering management system - project establishment
subsystem; Mysql database; Java language
目 录
摘 要.............................................................................................................................I
ABSTRACT ..................................................................................................................II
第 1 章 绪论 ..................................................................................................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................1
第 2 章 开发环境与技术 ..............................................................................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 MYSQL 数据库 ...............................................................................................3
2.3 IDEA 开发工具................................................................................................4
2.4 SPRING BOOT 框架............................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................5
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................7
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计 ........................................................................................................13
4.1 功能结构设计 ...............................................................................................13
4.2 数据库设计 ...................................................................................................15
4.2.1 数据库概念设计 ................................................................................15
4.2.2 数据库物理设计 ................................................................................18
第 5 章 系统实现 ........................................................................................................23
5.1 管理员功能实现 ...........................................................................................23
5.1.1 立项项目管理 ....................................................................................23
5.1.2 合同报价管理 ....................................................................................23
5.1.3 装饰材料总计划管理 ........................................................................24
5.1.4 客户管理 ............................................................................................24
5.2 员工功能实现 ...............................................................................................25
5.2.1 新增立项项目 ....................................................................................25
5.2.2 预算报价管理 ....................................................................................25
5.2.3 合同信息管理 ....................................................................................26
5.3 客户功能实现 ...............................................................................................26
5.3.1 装修进度查看 ....................................................................................26
5.3.2 合同报价查看 ....................................................................................27
5.3.3 装饰材料总计划查看 ........................................................................27
第 6 章 系统测试 ........................................................................................................29
6.1 功能测试 .......................................................................................................29
6.1.1 登录功能测试 ....................................................................................29
6.1.2 修改密码功能测试 ............................................................................30
6.2 系统测试结果 ...............................................................................................31
结 论 ..........................................................................................................................32
参考文献 ......................................................................................................................33
致 谢 ..........................................................................................................................34
