网络安全与信息技术学院学士学位论文
1
毕业论文（设计）
论文题目
基于 JSP 煤炭销售管理系统的设计与实现
所在学院
专业班级
姓 名
学 号
指导教师
职 称
教 务 处 制
二零二零年五月
基于 JSP 煤炭销售管理系统的设计与实现
基于 JSP 煤炭销售管理系统的设计与实现
2
姓名
（伊犁师范大学 网络安全与信息技术学院 物联网工程 18-2 班，新疆 伊宁市
835000）
摘 要：随着经济的发展以及人们对于能源的需求，煤炭的销售量也在日益提升，煤炭
销售过程中存在大量的销售数据，包含了煤炭类型、煤炭价格、煤炭出入库管理、煤炭销售
统计等内容，然而在现实煤炭销售过程中很多销售管理的内容都是通过手动记录的方式来实
现，对于交易量比较小的应用场景这种手工管理模式还适用，但是对于大型和多销售人员的
场景下，对于煤炭销售的管理存在很多风险。本文结合了当前煤炭销售管理中的常见问题，
通过线上平台的开发设计，利用 JSP 技术以及 Mysql 数据库实现在线煤炭销售信息的管理，
包含了煤炭销售管理过程中的煤炭信息管理、煤炭销售管理、煤炭入库管理、煤炭库存管理
以及销售人员销量统计，销售员工和管理人员可以借助线上平台实现煤炭销售信息的优化管
理，利用线上平台的便捷性帮助缓解和提升煤炭交易管理的效率，同时借助线上数据信息的
查询和统计帮助优化煤炭进销存管理的数据信息准确性，从而对于煤炭整体销售过程实现有
效的管控。
关键字：JSP 技术；Mysql 数据库；煤炭销售管理；煤炭进销存管理；销量统计
网络安全与信息技术学院学士学位论文
3
Abstract
With the development of economy and people's demand for energy, the sales
volume of coal is also increasing. There are a lot of sales data in the process of coal
sales, including coal type, coal price, coal inbound and outbound management, coal
sales statistics and other contents. However, in the actual coal sales process, many sales
management contents are achieved through manual recording, This manual
management mode is also applicable to the application scenarios with small transaction
volumes, but there are many risks in the management of coal sales in the scenarios with
large and multi salespersons. This paper combines the common problems in the current
coal sales management, through the development and design of the online platform, uses
JSP technology and Mysql database to realize the management of online coal sales
information, including coal information management, coal sales management, coal
warehousing management, coal inventory management and sales statistics of sales
personnel in the process of coal sales management, Sales staff and managers can use the
online platform to optimize the management of coal sales information, use the
convenience of the online platform to help ease and improve the efficiency of coal
transaction management, and use the online data information query and statistics to help
optimize the accuracy of coal purchase, sales and inventory management data, so as to
achieve effective control over the overall coal sales process.
Keywords: JSP technology; MySQL database; Coal sales management; Management of
coal purchase, sale and storage; Sales statistics
基于 JSP 煤炭销售管理系统的设计与实现
4
目 录
1 绪论 ...............................................................................................................................................6
1.1 开发背景 ....................................................................................................................................6
1.2 国内外发展及研究现状 .............................................................................................................6
1.3 研究的意义 .................................................................................................................................7
1.4 开发工具及技术 .........................................................................................................................7
1.4.1 B/S 结构............................................................................................................................7
1.4.2 Mysql 数据库....................................................................................................................8
1.4.3 JSP 技术 ............................................................................................................................8
2 需求分析 .......................................................................................................................................9
2.1 需求调研 .....................................................................................................................................9
2.2 可行性分析 .................................................................................................................................9
2.2.1 技术的可行性 ..................................................................................................................9
2.2.2 经济的可行性 ..................................................................................................................9
2.2.3 操作可行性 ....................................................................................................................10
2.3 用户用例图 ...............................................................................................................................10
2.3.1 管理员用例图 ................................................................................................................10
2.3.2 销售员工用例图 ............................................................................................................10
3 数据库设计 .................................................................................................................................12
3.1 数据库的分析与设计 ...............................................................................................................12
3.1.1 数据库的概念结构设计.................................................................................................12
3.1.2 数据表的逻辑结构设计.................................................................................................13
4 网站功能实现 .............................................................................................................................14
4.1 系统后台界面 ..........................................................................................................................14
4.2 员工信息管理界面 ..................................................................................................................14
4.3 煤炭信息管理界面 ...................................................................................................................15
4.4 煤炭销售统计界面 ...................................................................................................................15
4.5 煤炭销售管理 ..........................................................................................................................16
4.6 煤炭入库管理 ..........................................................................................................................16
网络安全与信息技术学院学士学位论文
5
4.7 煤炭库存管理 ..........................................................................................................................17
5 系统测试 .....................................................................................................................................18
5.1 系统测试的意义 ......................................................................................................................18
5.3 系统测试的内容 ......................................................................................................................18
5.4 系统测试结果 ...........................................................................................................................18
总结 .................................................................................................................................................19
致 谢 ...............................................................................................................................................20
参考文献 .........................................................................................................................................21
