## 本项目实现的最终作用是基于JSP网上早餐外卖店管理系统
## 分为2个角色
### 第1个角色为管理员角色,实现了如下功能:
- 分类管理
- 用户管理
- 管理员登录
- 菜品管理
- 订单管理
### 第2个角色为用户角色,实现了如下功能:
- 提交订单
- 查看菜品详情
- 查看订单
- 用户点餐首页
- 用户首页
## 数据库设计如下:
# 数据库设计文档
**数据库名:** zaocan_shop
**文档版本:**
| 表名 | 说明 |
| :---: | :---: |
| [easybuy_comment](#easybuy_comment) | |
| [easybuy_news](#easybuy_news) | |
| [easybuy_order](#easybuy_order) | |
| [easybuy_order_detail](#easybuy_order_detail) | |
| [easybuy_product](#easybuy_product) | |
| [easybuy_product_category](#easybuy_product_category) | |
| [easybuy_shop](#easybuy_shop) | |
| [easybuy_user](#easybuy_user) | |
**表名:** <a id="easybuy_comment">easybuy_comment</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EC_ID | int | 10 | 0 | N | Y | | 评论ID |
| 2 | EC_CONTENT | varchar | 255 | 0 | N | N | | 评论内容 |
| 3 | EC_CREATE_TIME | datetime | 19 | 0 | N | N | | |
| 4 | EC_REPLY | varchar | 255 | 0 | Y | N | NULL | 回复 |
| 5 | EC_REPLY_TIME | datetime | 19 | 0 | Y | N | NULL | |
| 6 | EC_NICK_NAME | varchar | 255 | 0 | N | N | | 昵称 |
**表名:** <a id="easybuy_news">easybuy_news</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EN_ID | int | 10 | 0 | N | Y | | |
| 2 | EN_TITLE | varchar | 255 | 0 | N | N | | |
| 3 | EN_CONTENT | varchar | 1000 | 0 | N | N | | |
| 4 | EN_CREATE_TIME | datetime | 19 | 0 | N | N | | |
**表名:** <a id="easybuy_order">easybuy_order</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EO_ID | int | 10 | 0 | N | Y | | |
| 2 | EO_USER_ID | varchar | 255 | 0 | N | N | | |
| 3 | EO_USER_NAME | varchar | 255 | 0 | Y | N | NULL | |
| 4 | EO_USER_ADDRESS | varchar | 255 | 0 | Y | N | NULL | |
| 5 | EO_CREATE_TIME | datetime | 19 | 0 | N | N | | |
| 6 | EO_COST | decimal | 11 | 2 | N | N | | |
| 7 | EO_STATUS | decimal | 7 | 0 | N | N | | |
| 8 | EO_TYPE | decimal | 7 | 0 | N | N | | |
**表名:** <a id="easybuy_order_detail">easybuy_order_detail</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EOD_ID | int | 10 | 0 | N | Y | | |
| 2 | EO_ID | decimal | 11 | 0 | N | N | | |
| 3 | EP_ID | decimal | 11 | 0 | N | N | | |
| 4 | EOD_QUANTITY | decimal | 7 | 0 | N | N | | |
| 5 | EOD_COST | decimal | 11 | 2 | N | N | | |
**表名:** <a id="easybuy_product">easybuy_product</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EP_ID | int | 10 | 0 | N | Y | | |
| 2 | EP_NAME | varchar | 255 | 0 | N | N | | |
| 3 | EP_DESCRIPTION | varchar | 512 | 0 | Y | N | NULL | |
| 4 | EP_PRICE | decimal | 11 | 2 | N | N | | |
| 5 | EP_STOCK | decimal | 11 | 0 | N | N | | |
| 6 | EPC_ID | decimal | 11 | 0 | Y | N | NULL | |
| 7 | EPC_CHILD_ID | decimal | 11 | 0 | Y | N | NULL | |
| 8 | EP_FILE_NAME | varchar | 255 | 0 | Y | N | NULL | |
**表名:** <a id="easybuy_product_category">easybuy_product_category</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EPC_ID | int | 10 | 0 | N | Y | | 分类ID |
| 2 | EPC_NAME | varchar | 255 | 0 | N | N | | 分类名称 |
| 3 | EPC_PARENT_ID | decimal | 11 | 0 | N | N | | 父分类ID |
**表名:** <a id="easybuy_shop">easybuy_shop</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | es_id | int | 10 | 0 | N | Y | | |
| 2 | es_ep_file_name | varchar | 255 | 0 | Y | N | NULL | |
| 3 | es_ep_name | varchar | 64 | 0 | Y | N | NULL | |
| 4 | es_ep_price | decimal | 11 | 0 | Y | N | NULL | |
| 5 | es_eod_quantity | int | 10 | 0 | Y | N | NULL | |
| 6 | es_ep_stock | int | 10 | 0 | Y | N | NULL | |
| 7 | es_ep_id | int | 10 | 0 | Y | N | NULL | |
| 8 | es_eu_user_id | varchar | 64 | 0 | Y | N | NULL | |
| 9 | es_valid | int | 10 | 0 | Y | N | NULL | |
**表名:** <a id="easybuy_user">easybuy_user</a>
**说明:**
**数据列:**
| 序号 | 名称 | 数据类型 | 长度 | 小数位 | 允许空值 | 主键 | 默认值 | 说明 |
| :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: | :---: |
| 1 | EU_USER_ID | varchar | 255 | 0 | N | Y | | |
| 2 | EU_USER_NAME | varchar | 255 | 0 | N | N | | |
| 3 | EU_PASSWORD | varchar | 255 | 0 | N | N | | |
| 4 | EU_SEX | varchar | 1 | 0 | N | N | | |
| 5 | EU_BIRTHDAY | datetime | 19 | 0 | Y | N | NULL | |
| 6 | EU_IDENTITY_CODE | varchar | 60 | 0 | Y | N | NULL | |
| 7 | EU_EMAIL | varchar | 80 | 0 | Y | N | NULL | |
| 8 | EU_MOBILE | varchar | 11 | 0 | Y | N | NULL | |
| 9 | EU_ADDRESS | varchar | 255 | 0 | Y | N | NULL | |
| 10 | EU_STATUS | decimal | 7 | 0 | N | N | | |
****
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
这个是一个JSP网上早餐外卖店管理系统,管理员角色包含以下功能:管理员登录,用户管理,分类管理,菜品管理,订单管理等功能。用户角色包含以下功能:用户点餐首页,用户首页,查看菜品详情,提交订单,查看订单等功能。 本项目实现的最终作用是基于JSP网上早餐外卖店管理系统 分为2个角色 第1个角色为管理员角色,实现了如下功能: - 分类管理 - 用户管理 - 管理员登录 - 菜品管理 - 订单管理 第2个角色为用户角色,实现了如下功能: - 提交订单 - 查看菜品详情 - 查看订单 - 用户点餐首页 - 用户首页
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![thumb](https://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 119 条
- 1
- 2
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/30cca166a8ba4bd9b70a7e3128b56485_lwx666sl.jpg!1)
熬夜写代码的平头哥
- 粉丝: 3788
- 资源: 7360
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)