商业辅助决策系统 JAVA+Vue.js+SpringBoot+MySQL

毕 业 设 计（论 文）

题目：商业辅助决策系统的设计与实现

摘 要

如今社会上各行各业，都喜欢用自己行业的专属软件工作，互联网发展到这

个时候，人们已经发现离不开了互联网。新技术的产生，往往能解决一些老技术

的弊端问题。因为传统收支信息和销售订单信息管理难度大，容错率低，管理人

员处理数据费工费时，所以专门为解决这个难题开发了一个商业辅助决策系统，

可以解决许多问题。

商业辅助决策系统实现的功能包括收入信息管理与支出信息管理，员工销售

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 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

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

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.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