毕 业 设 计（论 文）
题目：农家乐信息平台的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对农家乐信息管理混乱，出错率高，信息安全性差，劳动强
度大，费时费力等问题，采用农家乐信息平台可以有效管理，使信息管理能够更
加科学和规范。
农家乐信息平台在 Eclipse 环境中，使用 Java 语言进行编码，使用 Mysql 创
建数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，其管理员
管理农作物，农家乐活动，周边餐饮和住宿，以及景点等资料，对景点门票购买，
住宿预订，餐饮和农作物商品的购买订单等进行管理。用户通过本系统购买农作
物，餐饮，预订住宿，购买景点门票，查看农家乐活动，同时管理各种订单，包
括景点门票购买订单，住宿预订订单，农作物和餐饮购买的订单等。
总之，农家乐信息平台集中管理信息，有着保密性强，效率高，存储空间大，
成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。
关键词：农家乐信息平台；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic management of farmhouse
information, high error rate, poor information security, high labor intensity, and
time-consuming and labor-consuming problems, the use of farmhouse information
platform can effectively manage and make information management more scientific
and standardized.
The farmhouse information platform uses the Java language for coding in the
Eclipse environment, and uses Mysql to create a data table to save the data generated
by the system. The system can provide information display and corresponding
services, and its administrator manages crops, farmhouse activities, surrounding
catering and accommodation, and attractions and other information, and manages
attraction ticket purchases, accommodation reservations, and purchase orders for
catering and crop products. Through this system, users purchase crops, meals, book
accommodation, purchase scenic spot tickets, view farmhouse activities, and manage
various orders at the same time, including scenic spot ticket purchase orders,
accommodation booking orders, crop and meal purchase orders, etc.
In short, the farmhouse information platform centralized management
information has many advantages such as strong confidentiality, high efficiency, large
storage space, and low cost. It can reduce the cost of information management and
realize the computerization of information management.
Key Words：Farmhouse Information Platform; Java Language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
第 3 章 系统分析.......................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................6
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................11
4.1 设计原则 .......................................................................................................11
4.2 功能结构设计 ...............................................................................................11
4.3 数据库设计 ...................................................................................................13
4.3.1 数据库概念设计 ................................................................................14
IV
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现......................................23
5.1 管理员功能实现 ...........................................................................................23
5.1.1 周边住宿管理 ....................................................................................23
5.1.2 景点信息管理 ....................................................................................23
5.1.3 周边餐饮管理 ....................................................................................24
5.1.4 农家乐活动管理 ................................................................................24
5.1.5 门票购买管理 ....................................................................................25
5.1.6 已支付订单 ........................................................................................25
5.2 用户功能实现 ...............................................................................................26
5.2.1 农作物 ................................................................................................26
5.2.2 景点信息 ............................................................................................26
5.2.3 周边住宿 ............................................................................................27
5.2.4 住宿预订管理 ....................................................................................27
5.2.5 门票购买管理 ....................................................................................28
第 6 章 系统测试......................................29
6.1 功能测试 .......................................................................................................29
6.1.1 登录功能测试 ....................................................................................29
6.1.2 修改密码功能测试 ............................................................................30
6.2 测试结果 .......................................................................................................30
结 论...............................................31
致 谢...............................................32
参考文献.............................................33
