项目类型：SSM源码 

用户类型：2个角色（管理员+用户）

主要技术：SSM+MySQL+Layui

开发工具：Eclipse/Idea均可使用，有两个不同的版本

数据库：MySQL

数据库表：8张

项目介绍：后端采用SSM框架。前端使用的是Layui的一个网站模板。通过2种角色使用,实现了包括了剧本信息录入、剧本预约游玩、剧本评价、角色查看、预约通知等多个不同的模块。

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

00完整的程序目录

01管理员端功能介绍

1.0系统首页

1.1用户注册

1.2用户登录

1.3后台首页（剧本预约通知）

1.4用户信息管理

1.5员工管理

1.6剧本角色管理

1.7游玩房间管理

1.8预约管理（审核预约，以及游戏开始）

1.9游戏记录管理

1.10评分管理

1.11数据统计

02用户端功能介绍

2.1个人资料修改

2.2余额充值，根据会员等级折扣金额

2.3剧本预约

2.4预约记录管理

2.5发布评论

03项目结构

Eclipse版本目录

Idea版本目录

04数据库设计

05演示视频

---

00完整的程序目录

01管理员端功能介绍

1.0系统首页

1.1用户注册

1.2用户登录

1.3后台首页（剧本预约通知）

1.4用户信息管理

1.5员工管理

1.6剧本角色管理

1.7游玩房间管理

1.8预约管理（审核预约，以及游戏开始）

1.9游戏记录管理

1.10评分管理

1.11数据统计

02用户端功能介绍

2.1个人资料修改

2.2余额充值，根据会员等级折扣金额

2.3剧本预约

2.4预约记录管理

2.5发布评论

03项目结构

Eclipse版本目录

Idea版本目录

04数据库设计

05演示视频

​

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (`id` int(11) NOT NULL,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (`id` int(11) NOT NULL AUTO_INCREMENT,`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`jid` int(11) DEFAULT NULL,`jname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`score` double(11, 2) DEFAULT NULL,`pinglun` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house`  (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1 空闲 2 正在使用',`num` int(11) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for juben
-- ----------------------------
DROP TABLE IF EXISTS `juben`;
CREATE TABLE `juben`  (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`price` double(10, 2) DEFAULT NULL,`people` int(11) DEFAULT NULL,`descs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`score` double(11, 2) DEFAULT NULL,`pinglun` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '剧本类型',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`  (`id` int(11) NOT NULL AUTO_INCREMENT,`gid` int(11) DEFAULT NULL,`gname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`hid` int(11) DEFAULT NULL,`hname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`pnum` int(11) DEFAULT NULL,`dates` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`jid` int(11) DEFAULT NULL,`jname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`money` double(11, 2) DEFAULT NULL,`level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`sum` double(11, 2) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for yuyue
-- ----------------------------
DROP TABLE IF EXISTS `yuyue`;
CREATE TABLE `yuyue`  (`id` int(11) NOT NULL AUTO_INCREMENT,`person` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`rname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`jname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`hname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`dates` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`price` double(10, 2) DEFAULT NULL,`numb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;