计算机SSM选题 - 基于SSM的剧本杀预约管理系统

- 日理万妓 2024-02-18 10:22 41阅读 0赞

> 项目类型：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 **完整的程序目录** ##

![cc8870dc14b0129232c95fbdf9185204.png][]

## 01 **管理员端功能介绍** ##

### **1.0系统首页** ###

![ef8d9078e8fd420b13547fe80b1fa65f.png][]

### **1.1用户注册** ###

![178bc3fdf6f90a048cdebfc439913cb8.png][]

### **1.2用户登录** ###

![af67f0d875999b1880d0478cc2102531.png][]

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

![85497185cd3198f2a8d7a291af8ffe2f.png][]

### **1.4用户信息管理** ###

![fd3125a0cd185624fac3eb2dca03ac7e.png][]

### **1.5员工管理** ###

![f15c194c95c4b67197d24145f015b7ec.png][]

### **1.6剧本角色管理** ###

![731f5a1578a46ea53e47e00ba64dde9a.png][]

### **1.7游玩房间管理** ###

![ea4aa38a79b961ffa3ababec298749ad.png][]

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

![92a28d45d3eda9ae3192c05ebe8cd79e.png][]

### **1.9游戏记录管理** ###

![4b505e449a4396cd9725e941ed1f3935.png][]

### **1.10评分管理** ###

![537050f0d2075eaa1bdd1561aa654689.png][]

### **1.11数据统计** ###

![feccd164ec4d9841be5b879660c88477.png][]

![5951a5ba357c1c74bb3be796a132e676.png][]

![fc39c43220308d61fab000c9952684c9.png][]

## 02 **用户端功能介绍** ##

### **2.1个人资料修改** ###

![88feffbd416324819f4ce8b318e4eadb.png][]

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

![537eef69acff7f5545cc5c8e1a29fe9e.png][]

### **2.3剧本预约** ###

![01aac86355c1126d72238d6ccac138c9.png][]

### **2.4预约记录管理** ###

![c0ac6ca1cfc936046ade4f86f4fe1f4a.png][]

### **2.5发布评论** ###

![862fb2b0b1d924bd4e3ebd01414d8a34.png][]

##  ##

## 03 **项目结构** ##

### **Eclipse版本目录** ###

![e98f0ba9114e7f035370c222a9ac05bf.png][]

### **Idea版本目录** ###

![fa22f7826015b7bda5087eb82b7940c2.png][]

## 04 **数据库设计** ##

![299c4c9837beaed7c07b6263622860fc.png][]

## 05 **演示视频** ##

【原创】基于SSM的剧本杀预约管理系统（毕业设计源代码）

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;

## 项目获取: ##

[https://gitee.com/sinonfin/L-javaWebSha/tree/master][https_gitee.com_sinonfin_L-javaWebSha_tree_master]

[cc8870dc14b0129232c95fbdf9185204.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/64690a41223f43aba8210305c329a5d6.png
[ef8d9078e8fd420b13547fe80b1fa65f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/840b112697a44e89b31018a051f932e5.png
[178bc3fdf6f90a048cdebfc439913cb8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/450edd9dd11546a2ba55ba6c35a96af3.png
[af67f0d875999b1880d0478cc2102531.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/bee709dc6ca94a4884471c8f05a45511.png
[85497185cd3198f2a8d7a291af8ffe2f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/b8e83c7cb00440d1ba10bafdc79e9075.png
[fd3125a0cd185624fac3eb2dca03ac7e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/062e88aed99446dfba86889eb596f315.png
[f15c194c95c4b67197d24145f015b7ec.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d188724c02134dbd818192d697b92dd1.png
[731f5a1578a46ea53e47e00ba64dde9a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/95063618a0d84225b3b55398c4049c30.png
[ea4aa38a79b961ffa3ababec298749ad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/684458ef34874a9fbb9271284d9386ee.png
[92a28d45d3eda9ae3192c05ebe8cd79e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/bf48edbab4d649fea1ec7343d4c0db69.png
[4b505e449a4396cd9725e941ed1f3935.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/612d130b942946b1a333a8d5c58b0a2d.png
[537050f0d2075eaa1bdd1561aa654689.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/1bdedc585c9e460ca0ab82f64d7cc568.png
[feccd164ec4d9841be5b879660c88477.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/3ff0fdb30a4c4f40b1a4668fa141d3a0.png
[5951a5ba357c1c74bb3be796a132e676.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/0431a30ad4764f198fb3856f091e2f66.png
[fc39c43220308d61fab000c9952684c9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/9bb1481190d24294b11dd5c1f83a2e86.png
[88feffbd416324819f4ce8b318e4eadb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/90bf8ca246a84c239ebfa57b77a78e01.png
[537eef69acff7f5545cc5c8e1a29fe9e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/7fe16bfa8e66415da6f90150e3cd38e2.png
[01aac86355c1126d72238d6ccac138c9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/986e19c47a5f42e8975e12a83bda673f.png
[c0ac6ca1cfc936046ade4f86f4fe1f4a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/fda4377f79ad43db8608c5da8b6a3209.png
[862fb2b0b1d924bd4e3ebd01414d8a34.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/6e571148a848417fad478320f3336a64.png
[e98f0ba9114e7f035370c222a9ac05bf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/149a50daa3e5468f9f4791578a0724db.png
[fa22f7826015b7bda5087eb82b7940c2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/38f9b8f65356457bb0a77a1fb660c281.png
[299c4c9837beaed7c07b6263622860fc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/9ce36dea6f0849d8b9bdcdb55dfdcfde.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master