没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
毕 业 设 计
题 目 基于 B/S 的销售数据的决策支持
系统的设计与实现
学 院 信息科学与工程学院
专 业
班 级
学 生
学 号
指导教师
二〇一二 年 六 月 十 日
- -
摘 要
本课题利用数据库和 J2EE 框架技术,研究设计一个基于 B/S 的销售数据决策支
持系统,更好的实现广大的用户的需求以及销售数据汇总决策功能。通过本课题的设
计过程可以巩固学生的专业知识,锻炼学生的实际动手能力,提高学生综合分析解决
实际问题的能力。
论文中,首先对销售数据决策支持系统的实现过程中涉及的相关知识进行介绍,
主要采用 Extjs+ Strus2+Spring+Hibernate + Mysql 的技术实现本系统,然后分析
了系统的大致设计思路, 在思路的基础上进行了模块划分,而后分析了各个模块和流
程的具体划分和最后的编程实现,从问题的提出到最后逐步的实现, 都一步步的作
了系统的介绍。在实际开发阶段,为了理解和对照,本文将比较有代表性的代码给出,
并作了相关注释。
关键词:销售数据决策支持系统;Extjs 技术;Mysql;Struts;Hibernate;Spring
- I -
ABSTRACT
This issue using a database and J2EE framework technology, research and design of a
B/S-based Sales Decision Support System based on Data platform to achieve a better user
needs as well as Sales data collection decision functions. Through the design process of
this issue can be to consolidate the expertise of students, training students the actual
practical ability to improve the comprehensive analysis of student's ability to solve
practical problems.
In this report, relevant knowledge needing involving make an introduction in the
realization course to Sales Decision Support System based on Data at first,mainly use the
technology of Extjs,Strust2,Spring,Hibernate and Mysql to achieve the design of this
system. And then analyses the general design ideas, then divide the module on the basis of
the ideas . After that ,we analysed the detailed division and the last programming
realization of each module and procedure, the realization progressively finally of putting
forward from the question, doing the systematic introduction step by step. During the
course of developing actually,have this text relatively on behalf of code provide,more last
explanatory more note not relevant, easy to understand and contrast.
Key Words: Sales Decision Support System based on Data ;Extjs technology ; Mysql ;Struts;
Hibernate ; Spring
- II -
目 录
摘 要 ....................................................................................................................................................I
ABSTRACT ..............................................................................................................................................II
1 前言.........................................................................................................................................................1
1.1 课题的研究背景..........................................................................................................................1
1.2 决策支持系统的现状发展现状和课题意义..............................................................................1
1.3 选题的创新之处..........................................................................................................................2
2 相关技术简介.........................................................................................................................................3
2.1 Extjs 语言 .....................................................................................................................................3
2.1.1 Extjs 语言简介 ..................................................................................................................3
2.1.2 Extjs 语言的特点 ..............................................................................................................3
2.2 数据库技术..................................................................................................................................4
2.2.1 MYSQL 简介.....................................................................................................................4
2.3 Struts2、Spring、hibernate 技术介绍.........................................................................................4
2.3.1 Struts2 技术 .......................................................................................................................4
2.3.2 Spring 框架 ........................................................................................................................5
2.3.2 hibernate 框架....................................................................................................................5
3 相关软件介绍.........................................................................................................................................6
3.1 开发工具介绍...............................................................................................................................6
3.2 Tomcat 介绍 .................................................................................................................................6
4 系统的总体设计.....................................................................................................................................7
4.1 系统分析......................................................................................................................................7
4.1.1 系统的功能描述...............................................................................................................7
4.1.2 需求分析...........................................................................................................................7
4.1.3 总体设计...........................................................................................................................8
4.2 数据库设计................................................................................................................................12
4.2.1 数据库需求分析.............................................................................................................12
4.2.2 数据库具体设计.............................................................................................................14
5 系统的详细设计...................................................................................................................................20
5.1 Extjs+SSH+Mysql 整合开发流程与配置..................................................................................20
5.1.1 业务流程图.....................................................................................................................20
5.2 系统登陆模块与权限分配设计................................................................................................24
5.3 基础资料模块设计与实现........................................................................................................25
5.3.1 供应商资料模块实现.....................................................................................................25
5.3.2 客户资料模块实现.........................................................................................................29
5.3.3 商品管理模块实现.........................................................................................................32
5.3.4 起初库存模块实现.........................................................................................................38
5.4 进货管理模块设计与实现........................................................................................................40
5.4.1 进货入库模块的实现.....................................................................................................40
5.4.2 退货出库模块的实现.....................................................................................................43
5.4.3 进货单查询模块的实现.................................................................................................43
- III -
5.4.4 退货单查询模块的实现.................................................................................................45
5.4.5 当前库存查询模块的实现..............................................................................................45
5.5 销售管理模块的设计与实现....................................................................................................47
5.5.1 销售出库模块的实现.....................................................................................................47
5.5.2 客户退货模块的实现.....................................................................................................48
5.5.3 销售单据查询模块的实现.............................................................................................49
5.5.4 客户退货查询模块的实现.............................................................................................50
5.5.5 当前库存查询模块的实现.............................................................................................50
5.6 库存管理模块的设计与实现....................................................................................................50
5.6.1 商品报损模块的实现.....................................................................................................50
5.6.2 商品报溢模块的实现.....................................................................................................52
5.6.3 库存报警模块的实现.....................................................................................................53
5.6.4 报损报溢查询模块的实现.............................................................................................54
5.6.5 当前库存查询模块的实现.............................................................................................54
5.7 决策分析模块设计与实现........................................................................................................55
5.7.1 供应商统计模块的实现.................................................................................................55
5.7.2 客户统计模块的实现.....................................................................................................56
5.7.3 商品采购统计模块的实现.............................................................................................57
5.7.4 商品销售统计模块的实现.............................................................................................58
5.7.5 按日统计分析统计模块的实现.....................................................................................59
5.7.6 按月统计分析统计模块的实现.....................................................................................62
5.7.7 统计决策支持模块的实现.............................................................................................63
5.8 系统管理模块设计与实现.........................................................................................................64
5.8.1 角色管理模块实现.........................................................................................................64
5.8.2 用户管理模块实现.........................................................................................................66
结 论...................................................................................................................................................68
参 考 文 献.............................................................................................................................................69
致 谢...................................................................................................................................................70
剩余75页未读,继续阅读
资源评论
Q_97095639
- 粉丝: 380
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功