摘 要：在移动互联网带动移动电商迅猛发展的时代，手机购物商城成为了消费者主要的网购渠道，传统企业通过开发后台管理系统来开拓移动端手机市场并制作手机购物网站来打开新的产品销售渠道。本酒柜管理系统的功能主要包括：商品信息管理、会员信息管理、订单管理等核心功能，此外，还有活动管理、资讯管理、账户管理等各种员工管理模块，以及超级管理员的权限管理功能。本系统应用B/S结构,MVC模式采用iBATIS框架整合spring框架的技术编写。Spring的配置文件将连接mysql数据库的配置文件的内容关联成数据资源，再把数据资源关联到Ibatis的配置文件，最后统一封装成为SqlMapClientTemplate模板类向外提供服务。 80769

毕业论文关键词：手机网上购物系统,iBATIS框架,Spring框架，Struts

Abstract：Mobile Internet driven by the rapid development of mobile Internet era, the mobile phone is gradually changing people's consumption habits, and become the necessary supplies of people's daily life。 The mobile shopping mall has become the main consumers of online shopping channels, traditional enterprises to improve product sales, we must to open up the end of the mobile phone market and make mobile shopping website to open new channels for product sales。The cabinet management system to complete the main functions of information management, merchandise management, order management, rights management, card ticket management, message management etc。。 Front end online shopping good demand analysis based on and wine management system functions include: commodity information management, member information management, order management, and other core functions。 In addition, there are activities management, information management, account management all staff management module, and the tube member privilege management function。This system uses the B/S structure, the MVC mode uses the iBATIS frame to integrate the technical compilation of spring frame。 The spring configuration file will connect mysql database configuration file content related data resources and the data resources are associated with ibatis configuration file, and finally unified package become sqlmapclienttemplate template class to provide services outside。

Keywords：Mobile phone online shopping system, iBATIS Frame,Spring Frame,Struts

目   录 

1 引言 4

2 酒柜管理系统主要技术及功能展示图例 4

    2。1 酒柜管理系统主要技术 4

    2。2 系统功能展示图例 6

3 酒柜管理系统需求分析与总体设计 7

    3。1 系统与用户的特点 7

    3。2 酒柜商城购物系统主要实现 8

4 酒柜管理系统的数据库设计与实现 8

    4。1 酒柜系统功能模块简要介绍 8

    4。2 数据库的设计与实现 9

    4。3 数据库概述 12

    4。4 数据库表结构 13

    4。5 数据库存储过程 16

5 酒柜管理系统详细设计 18

    5。1 后台管理员登陆模块 18

    5。2 商品管理模块 20

    5。3 订单管理模块