- I -
摘 要
本文介绍商贸公司库存管理系统的开发与设计流程，本系统含有的功能有用户登录
功能；我的控制面板功能，包含子功能含有个人信息、修改密码和系统公告；内容管理，
包含子功能有仓库商品管理、商品类型管理、仓库管理、公告管理、查询库存、入库管
理、出库管理、查询库存、库存报表查看；用户管理功能，包含子功能含有系统管理员
管理和供应商管理；系统设置功能包含的子功能含有系统作者设置和用户登录日志管理。
JSP 技术以其独特的优势成为开发网站系统的首选工具，使用 Eclipse 开发工具，
最终能够实现客户端的所有操作。由于 JSP 具有一次编写，各处的运行、丰富而且高质
量的工具支持、通过构件和标签实现重用、通过指令和标签库增强与面开发能力等优点，
开发的系统可以在任何平台上编写、运行在任意平台上的 JAVA 服务器构件。
关键词：商贸公司库存管理系统；内容管理；MySQL 数据库
，
- II -
Abstract
This article describes commerce company inventory management system development
and design process, the system contains features are user login function; my control panel
functions, including sub-functions contain personal information, change passwords, and
system announcement; content management, including sub-function warehouse merchandise
management, commodity type management, warehouse management, bulletin management,
query inventory, storage management, a database management, query inventory, inventory
report viewing; user management functions, including the sub-functions contained system
administrators to manage and supplier management; system Settings sub-function features
include author containing system settings and user login log management.
JSP technology with its unique advantages to become the preferred tool for system
development site, use Eclipse development tools, and ultimately enable all operations of the
client. Because JSP has write once, run everywhere, rich and high-quality tool support, and
tag reuse by members, through instruction and tag library enhancement and surface
development capabilities, etc., development of the system can be written on any platform, run
JAVA on any platform server components..
Key Words ： Commerce company inventory management system; content management;
MySQL database
- III -
目 录
摘 要 .....................................................................................................................................I
Abstract ......................................................................................................................................II
1 引言.......................................................................................................................................1
1.1 研究目标....................................................................................................................1
2 相关的理论和技术...............................................................................................................2
2.1 Java 技术介绍 ...........................................................................................................2
2.2 MyEclipse 平台 .........................................................................................................2
2.3 框架介绍....................................................................................................................3
2.3.1 Struts ...............................................................................................................3
2.3.2 hibernate.............................................................................................................8
2.4 MySQL 数据库介绍 ...............................................................................................14
3 系统需求分析.......................................................................................................................14
3.1 可行性分析..............................................................................................................14
3.2 系统功能概述..........................................................................................................15
4 概要设计.............................................................................................................................17
4.1 总体流程设计..........................................................................................................17
4.2 功能结构设计..........................................................................................................19
4.3 系统用例图..............................................................................................................19
4.4 数据库设计..............................................................................................................20
4.5 E-R 图设计 ..............................................................................................................21
5 系统的实现.........................................................................................................................22
5.1 登录板块..................................................................................................................22
5.2 我的控制面板..........................................................................................................24
5.3 内容管理..................................................................................................................25
5.4 用户管理....................................................................................................................27
5.5 系统设置....................................................................................................................28
6 系统测试与调试.................................................................................................................31
6.1 程序调试..................................................................................................................31
6.2 程序的测试..............................................................................................................31
6.2.1 测试的重要性及目的.....................................................................................31
6.2.2 测试的步骤.....................................................................................................32
6.2.3 测试的主要内容.............................................................................................32
- IV -
结 论...................................................................................................................................34
参 考 文 献.............................................................................................................................35
致 谢...................................................................................................................................36
–1–
1 引言
1.1 研究目标
本文介绍商贸公司库存管理系统的开发与设计流程，本系统含有的功能有用户登录
功能；我的控制面板功能，包含子功能含有个人信息、修改密码和系统公告；内容管理，
包含子功能有仓库商品管理、商品类型管理、仓库管理、公告管理、查询库存、入库管
理、出库管理、查询库存、库存报表查看；用户管理功能，包含子功能含有系统管理员
管理和供应商管理；系统设置功能包含的子功能含有系统作者设置和用户登录日志管理。
