毕 业 设 计（论 文）
题目：商业辅助决策系统的设计与实现
摘 要
如今社会上各行各业，都喜欢用自己行业的专属软件工作，互联网发展到这
个时候，人们已经发现离不开了互联网。新技术的产生，往往能解决一些老技术
的弊端问题。因为传统收支信息和销售订单信息管理难度大，容错率低，管理人
员处理数据费工费时，所以专门为解决这个难题开发了一个商业辅助决策系统，
可以解决许多问题。
商业辅助决策系统实现的功能包括收入信息管理与支出信息管理，员工销售
订单信息管理，员工薪资管理，员工管理，公告管理等功能。该系统采用了 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
management of traditional income and expenditure information and sales order
information is difficult, the fault tolerance rate is low, and the management personnel
is labor-intensive and time-consuming to process data, so a business-assisted
decision-making system has been specially developed to solve this problem, which
can solve many problems.
The functions implemented by the commercial decision-making system include
income information management and expenditure information management,
employee sales order information management, employee salary management,
employee management, announcement management and other functions. The system
uses Mysql database, Java language, Spring Boot framework and other technologies
for programming.
The business auxiliary decision-making system can improve the efficiency of
solving the management problems of income and expenditure information and sales
order information, optimize the processing process of income and expenditure
information and sales order information, and ensure the security of income and
expenditure information and sales order information data. It is a very reliable and very
safe. s application.
Key Words：Commercial decision-making system; 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 章 系统设计 ........................................................................................................12
4.1 系统设计思想 ...............................................................................................12
4.2 功能结构设计 ...............................................................................................13
4.3 数据库设计 ...................................................................................................14
4.3.1 数据库概念设计 ................................................................................14
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现 ........................................................................................................21
5.1 管理员功能实现 ...........................................................................................21
5.1.1 公告管理 ............................................................................................21
5.1.2 收支管理 ............................................................................................21
5.1.3 销售订单管理 ....................................................................................22
5.1.4 薪资管理 ............................................................................................22
5.1.5 员工管理 ............................................................................................23
5.1.6 职位管理 ............................................................................................24
5.1.7 部门管理 ............................................................................................24
5.2 员工功能实现 ...............................................................................................25
5.2.1 公告查看 ............................................................................................25
5.2.2 销售订单查看 ....................................................................................25
5.2.3 薪资查看 ............................................................................................26
5.2.4 个人信息 ............................................................................................26
第 6 章 系统测试 ........................................................................................................28
6.1 测试任务 .......................................................................................................28
6.2 测试目标 .......................................................................................................28
6.3 测试方案 .......................................................................................................29
6.4 功能测试 .......................................................................................................30
6.4.1 登录功能测试 ....................................................................................30
6.4.2 修改密码功能测试 ............................................................................31
6.5 系统测试结果 ...............................................................................................32
结 论 ..........................................................................................................................33
参考文献 ......................................................................................................................34
致 谢 ..........................................................................................................................35
