• 计算机毕业设计 基于SSM的民宿推荐系统的设计与实现 Java实战项目 附源码+文档+视频讲解

    博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌

    🍅文末获取源码联系🍅

    👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
    ————————————————

    计算机毕业设计题目《1000套》✌

    目录

    一.前言介绍及开发技术

    二.功能设计

    三.功能截图

    四.数据库表结构设计

    五.关键代码

    六.论文目录参考

    七.源码获取

    一.前言介绍及开发技术

     起初通过HTML静态网页直接进行民宿推荐管理，具有即时性，无时空限制，蕴含丰富信息等特点，完美契合民宿推荐时效性、信息量大等需求。但随着Internet的进一步发展，实时信息不断变更，增加，交互性需求增大，静态网页显得难以胜任。民宿推荐系统的设计从最初简单的静态网页设计，到现在的基于B/S模式的民宿推荐系统，已经逐渐形成了一个系统化、规范化的设计理念。因此需要一种动态的平台实现民宿推荐管理。并且该系统应成为一个不单只是提供信息浏览服务，还要给予用户实用的交互功能。系统采用B/S架构，java语言作为主要开发语言，MySQL技术创建和管理数据库。系统主要分为管理员、用户和民宿员工三大功能模块。通过系统，管理员使用日常浏览器即可随时完成民宿推荐信息发布，契合民宿推荐管理对时效性需求的同时提高工作效率。

    二.功能设计

     系统的建设可以为民宿推荐管理提供帮助，通过对一些基础信息管理实现针对性的安排，可以按照用户的角色权限使不同用户角色看到不一样的信息界面。现根据需求阶段的分析，我们可以大致确定系统需要包含的功能如下图所示：

     

    三.功能截图

    当人们打开系统的网址后，首先看到的就是首页界面。在这里，人们能够看到系统的导航条，通过导航条导航进入各功能展示页面进行操作。

     系统注册：在系统注册页面的输入栏中输入用户注册信息进行注册操作。

     系统注册：在系统注册页面的输入栏中输入用户注册信息进行注册操作。

     近期活动：在近期活动页面的输入栏中输入民宿名称进行搜索，可以查看到近期活动详细信息。

     热门客房：在热门客房页面的输入栏中输入客房名称和选择客房类型进行搜索，可以查看到热门客房详细信息，并进行预定、评论或收藏操作。

     留言板：在留言板页面通过输入留言内容，上传图片并立即提交进行在线留言，还可以对留言内容进行回复操作。

     个人中心：在个人中心页面输入个人信息可以进行更新信息操作，并根据需要对我的收藏进行详细操作。

     后台用户登录，在登录页面选择需要登录的角色，在正确输入用户名和密码后，进入操作系统进行操作。

     管理员进入主页面，主要功能包括对个人中心、用户管理、民宿员工管理、近期活动管理、客房类型管理、热门客房管理、房间预定管理、预约服务管理、退房结账管理、投诉反馈管理、留言板、系统管理等进行操作。

     民宿员工进入系统可以对个人中心、近期活动管理、热门客房管理、房间预定管理、预约服务管理、退房结账管理等功能进行操作。

     用户进入系统可以对个人中心、房间预定管理、预约服务管理、退房结账管理、投诉反馈管理等功能进行操作。

    四.数据库表结构设计

    1. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspm2k78b` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
    2.  
    3. USE `jspm2k78b`;
    4.  
    5. --
    6. -- Table structure for table `aboutus`
    7. --
    8.  
    9. DROP TABLE IF EXISTS `aboutus`;
    10. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    11. /*!40101 SET character_set_client = utf8 */;
    12. CREATE TABLE `aboutus` (
    13.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    14.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    15.   `title` varchar(200) NOT NULL COMMENT '标题',
    16.   `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题',
    17.   `content` longtext NOT NULL COMMENT '内容',
    18.   `picture1` longtext COMMENT '图片1',
    19.   `picture2` longtext COMMENT '图片2',
    20.   `picture3` longtext COMMENT '图片3',
    21.   PRIMARY KEY (`id`)
    22. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
    23. /*!40101 SET character_set_client = @saved_cs_client */;
    24.  
    25. --
    26. -- Dumping data for table `aboutus`
    27. --
    28.  
    29. LOCK TABLES `aboutus` WRITE;
    30. /*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
    31. INSERT INTO `aboutus` VALUES (1,'2023-03-05 03:12:21','关于我们','ABOUT US','不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg');
    32. /*!40000 ALTER TABLE `aboutus` ENABLE KEYS */;
    33. UNLOCK TABLES;
    34.  
    35. --
    36. -- Table structure for table `chat`
    37. --
    38.  
    39. DROP TABLE IF EXISTS `chat`;
    40. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    41. /*!40101 SET character_set_client = utf8 */;
    42. CREATE TABLE `chat` (
    43.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    44.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    45.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    46.   `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
    47.   `ask` longtext COMMENT '提问',
    48.   `reply` longtext COMMENT '回复',
    49.   `isreply` int(11) DEFAULT NULL COMMENT '是否回复',
    50.   PRIMARY KEY (`id`)
    51. ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='在线客服';
    52. /*!40101 SET character_set_client = @saved_cs_client */;
    53.  
    54. --
    55. -- Dumping data for table `chat`
    56. --
    57.  
    58. LOCK TABLES `chat` WRITE;
    59. /*!40000 ALTER TABLE `chat` DISABLE KEYS */;
    60. INSERT INTO `chat` VALUES (101,'2023-03-05 03:12:21',1,1,'提问1','回复1',1),(102,'2023-03-05 03:12:21',2,2,'提问2','回复2',2),(103,'2023-03-05 03:12:21',3,3,'提问3','回复3',3),(104,'2023-03-05 03:12:21',4,4,'提问4','回复4',4),(105,'2023-03-05 03:12:21',5,5,'提问5','回复5',5),(106,'2023-03-05 03:12:21',6,6,'提问6','回复6',6),(107,'2023-03-05 03:12:21',7,7,'提问7','回复7',7),(108,'2023-03-05 03:12:21',8,8,'提问8','回复8',8);
    61. /*!40000 ALTER TABLE `chat` ENABLE KEYS */;
    62. UNLOCK TABLES;
    63.  
    64. --
    65. -- Table structure for table `config`
    66. --
    67.  
    68. DROP TABLE IF EXISTS `config`;
    69. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    70. /*!40101 SET character_set_client = utf8 */;
    71. CREATE TABLE `config` (
    72.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    73.   `name` varchar(100) NOT NULL COMMENT '配置参数名称',
    74.   `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
    75.   PRIMARY KEY (`id`)
    76. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
    77. /*!40101 SET character_set_client = @saved_cs_client */;
    78.  
    79. --
    80. -- Dumping data for table `config`
    81. --
    82.  
    83. LOCK TABLES `config` WRITE;
    84. /*!40000 ALTER TABLE `config` DISABLE KEYS */;
    85. INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
    86. /*!40000 ALTER TABLE `config` ENABLE KEYS */;
    87. UNLOCK TABLES;
    88.  
    89. --
    90. -- Table structure for table `discussremenkefang`
    91. --
    92.  
    93. DROP TABLE IF EXISTS `discussremenkefang`;
    94. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    95. /*!40101 SET character_set_client = utf8 */;
    96. CREATE TABLE `discussremenkefang` (
    97.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    98.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    99.   `refid` bigint(20) NOT NULL COMMENT '关联表id',
    100.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    101.   `avatarurl` longtext COMMENT '头像',
    102.   `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
    103.   `content` longtext NOT NULL COMMENT '评论内容',
    104.   `reply` longtext COMMENT '回复内容',
    105.   PRIMARY KEY (`id`)
    106. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='热门客房评论表';
    107. /*!40101 SET character_set_client = @saved_cs_client */;
    108.  
    109. --
    110. -- Dumping data for table `discussremenkefang`
    111. --
    112.  
    113. LOCK TABLES `discussremenkefang` WRITE;
    114. /*!40000 ALTER TABLE `discussremenkefang` DISABLE KEYS */;
    115. /*!40000 ALTER TABLE `discussremenkefang` ENABLE KEYS */;
    116. UNLOCK TABLES;
    117.  
    118. --
    119. -- Table structure for table `fangjianyuding`
    120. --
    121.  
    122. DROP TABLE IF EXISTS `fangjianyuding`;
    123. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    124. /*!40101 SET character_set_client = utf8 */;
    125. CREATE TABLE `fangjianyuding` (
    126.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    127.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    128.   `kefangbianhao` varchar(200) DEFAULT NULL COMMENT '客房编号',
    129.   `kefangmingcheng` varchar(200) DEFAULT NULL COMMENT '客房名称',
    130.   `kefangtupian` longtext COMMENT '客房图片',
    131.   `kefangleixing` varchar(200) DEFAULT NULL COMMENT '客房类型',
    132.   `yiwanjiage` varchar(200) DEFAULT NULL COMMENT '一晚价格',
    133.   `ruzhushijian` date DEFAULT NULL COMMENT '入住时间',
    134.   `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
    135.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    136.   `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
    137.   `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
    138.   `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
    139.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    140.   PRIMARY KEY (`id`)
    141. ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='房间预定';
    142. /*!40101 SET character_set_client = @saved_cs_client */;
    143.  
    144. --
    145. -- Dumping data for table `fangjianyuding`
    146. --
    147.  
    148. LOCK TABLES `fangjianyuding` WRITE;
    149. /*!40000 ALTER TABLE `fangjianyuding` DISABLE KEYS */;
    150. INSERT INTO `fangjianyuding` VALUES (61,'2023-03-05 03:12:21','客房编号1','客房名称1','upload/fangjianyuding_kefangtupian1.jpg,upload/fangjianyuding_kefangtupian2.jpg,upload/fangjianyuding_kefangtupian3.jpg','客房类型1','一晚价格1','2023-03-05','用户账号1','用户姓名1','手机1','员工工号1','员工姓名1','联系电话1'),(62,'2023-03-05 03:12:21','客房编号2','客房名称2','upload/fangjianyuding_kefangtupian2.jpg,upload/fangjianyuding_kefangtupian3.jpg,upload/fangjianyuding_kefangtupian4.jpg','客房类型2','一晚价格2','2023-03-05','用户账号2','用户姓名2','手机2','员工工号2','员工姓名2','联系电话2'),(63,'2023-03-05 03:12:21','客房编号3','客房名称3','upload/fangjianyuding_kefangtupian3.jpg,upload/fangjianyuding_kefangtupian4.jpg,upload/fangjianyuding_kefangtupian5.jpg','客房类型3','一晚价格3','2023-03-05','用户账号3','用户姓名3','手机3','员工工号3','员工姓名3','联系电话3'),(64,'2023-03-05 03:12:21','客房编号4','客房名称4','upload/fangjianyuding_kefangtupian4.jpg,upload/fangjianyuding_kefangtupian5.jpg,upload/fangjianyuding_kefangtupian6.jpg','客房类型4','一晚价格4','2023-03-05','用户账号4','用户姓名4','手机4','员工工号4','员工姓名4','联系电话4'),(65,'2023-03-05 03:12:21','客房编号5','客房名称5','upload/fangjianyuding_kefangtupian5.jpg,upload/fangjianyuding_kefangtupian6.jpg,upload/fangjianyuding_kefangtupian7.jpg','客房类型5','一晚价格5','2023-03-05','用户账号5','用户姓名5','手机5','员工工号5','员工姓名5','联系电话5'),(66,'2023-03-05 03:12:21','客房编号6','客房名称6','upload/fangjianyuding_kefangtupian6.jpg,upload/fangjianyuding_kefangtupian7.jpg,upload/fangjianyuding_kefangtupian8.jpg','客房类型6','一晚价格6','2023-03-05','用户账号6','用户姓名6','手机6','员工工号6','员工姓名6','联系电话6'),(67,'2023-03-05 03:12:21','客房编号7','客房名称7','upload/fangjianyuding_kefangtupian7.jpg,upload/fangjianyuding_kefangtupian8.jpg,upload/fangjianyuding_kefangtupian9.jpg','客房类型7','一晚价格7','2023-03-05','用户账号7','用户姓名7','手机7','员工工号7','员工姓名7','联系电话7'),(68,'2023-03-05 03:12:21','客房编号8','客房名称8','upload/fangjianyuding_kefangtupian8.jpg,upload/fangjianyuding_kefangtupian9.jpg,upload/fangjianyuding_kefangtupian10.jpg','客房类型8','一晚价格8','2023-03-05','用户账号8','用户姓名8','手机8','员工工号8','员工姓名8','联系电话8');
    151. /*!40000 ALTER TABLE `fangjianyuding` ENABLE KEYS */;
    152. UNLOCK TABLES;
    153.  
    154. --
    155. -- Table structure for table `jinqihuodong`
    156. --
    157.  
    158. DROP TABLE IF EXISTS `jinqihuodong`;
    159. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    160. /*!40101 SET character_set_client = utf8 */;
    161. CREATE TABLE `jinqihuodong` (
    162.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    163.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    164.   `huodongbianhao` varchar(200) DEFAULT NULL COMMENT '活动编号',
    165.   `huodongbiaoti` varchar(200) DEFAULT NULL COMMENT '活动标题',
    166.   `tupian` longtext COMMENT '图片',
    167.   `neirong` longtext COMMENT '内容',
    168.   `huodongshijian` date DEFAULT NULL COMMENT '活动时间',
    169.   `minsumingcheng` varchar(200) DEFAULT NULL COMMENT '民宿名称',
    170.   `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
    171.   `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
    172.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    173.   `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
    174.   `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
    175.   PRIMARY KEY (`id`),
    176.   UNIQUE KEY `huodongbianhao` (`huodongbianhao`)
    177. ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='近期活动';
    178. /*!40101 SET character_set_client = @saved_cs_client */;
    179.  
    180. --
    181. -- Dumping data for table `jinqihuodong`
    182. --
    183.  
    184. LOCK TABLES `jinqihuodong` WRITE;
    185. /*!40000 ALTER TABLE `jinqihuodong` DISABLE KEYS */;
    186. INSERT INTO `jinqihuodong` VALUES (31,'2023-03-05 03:12:21','活动编号1','活动标题1','upload/jinqihuodong_tupian1.jpg,upload/jinqihuodong_tupian2.jpg,upload/jinqihuodong_tupian3.jpg','内容1','2023-03-05','民宿名称1','员工工号1','员工姓名1','13823888881','2023-03-05 11:12:21',1),(32,'2023-03-05 03:12:21','活动编号2','活动标题2','upload/jinqihuodong_tupian2.jpg,upload/jinqihuodong_tupian3.jpg,upload/jinqihuodong_tupian4.jpg','内容2','2023-03-05','民宿名称2','员工工号2','员工姓名2','13823888882','2023-03-05 11:12:21',2),(33,'2023-03-05 03:12:21','活动编号3','活动标题3','upload/jinqihuodong_tupian3.jpg,upload/jinqihuodong_tupian4.jpg,upload/jinqihuodong_tupian5.jpg','内容3','2023-03-05','民宿名称3','员工工号3','员工姓名3','13823888883','2023-03-05 11:12:21',3),(34,'2023-03-05 03:12:21','活动编号4','活动标题4','upload/jinqihuodong_tupian4.jpg,upload/jinqihuodong_tupian5.jpg,upload/jinqihuodong_tupian6.jpg','内容4','2023-03-05','民宿名称4','员工工号4','员工姓名4','13823888884','2023-03-05 11:12:21',4),(35,'2023-03-05 03:12:21','活动编号5','活动标题5','upload/jinqihuodong_tupian5.jpg,upload/jinqihuodong_tupian6.jpg,upload/jinqihuodong_tupian7.jpg','内容5','2023-03-05','民宿名称5','员工工号5','员工姓名5','13823888885','2023-03-05 11:12:21',5),(36,'2023-03-05 03:12:21','活动编号6','活动标题6','upload/jinqihuodong_tupian6.jpg,upload/jinqihuodong_tupian7.jpg,upload/jinqihuodong_tupian8.jpg','内容6','2023-03-05','民宿名称6','员工工号6','员工姓名6','13823888886','2023-03-05 11:12:21',6),(37,'2023-03-05 03:12:21','活动编号7','活动标题7','upload/jinqihuodong_tupian7.jpg,upload/jinqihuodong_tupian8.jpg,upload/jinqihuodong_tupian9.jpg','内容7','2023-03-05','民宿名称7','员工工号7','员工姓名7','13823888887','2023-03-05 11:12:21',7),(38,'2023-03-05 03:12:21','活动编号8','活动标题8','upload/jinqihuodong_tupian8.jpg,upload/jinqihuodong_tupian9.jpg,upload/jinqihuodong_tupian10.jpg','内容8','2023-03-05','民宿名称8','员工工号8','员工姓名8','13823888888','2023-03-05 11:12:21',8);
    187. /*!40000 ALTER TABLE `jinqihuodong` ENABLE KEYS */;
    188. UNLOCK TABLES;
    189.  
    190. --
    191. -- Table structure for table `kefangleixing`
    192. --
    193.  
    194. DROP TABLE IF EXISTS `kefangleixing`;
    195. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    196. /*!40101 SET character_set_client = utf8 */;
    197. CREATE TABLE `kefangleixing` (
    198.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    199.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    200.   `kefangleixing` varchar(200) DEFAULT NULL COMMENT '客房类型',
    201.   PRIMARY KEY (`id`)
    202. ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='客房类型';
    203. /*!40101 SET character_set_client = @saved_cs_client */;
    204.  
    205. --
    206. -- Dumping data for table `kefangleixing`
    207. --
    208.  
    209. LOCK TABLES `kefangleixing` WRITE;
    210. /*!40000 ALTER TABLE `kefangleixing` DISABLE KEYS */;
    211. INSERT INTO `kefangleixing` VALUES (41,'2023-03-05 03:12:21','客房类型1'),(42,'2023-03-05 03:12:21','客房类型2'),(43,'2023-03-05 03:12:21','客房类型3'),(44,'2023-03-05 03:12:21','客房类型4'),(45,'2023-03-05 03:12:21','客房类型5'),(46,'2023-03-05 03:12:21','客房类型6'),(47,'2023-03-05 03:12:21','客房类型7'),(48,'2023-03-05 03:12:21','客房类型8');
    212. /*!40000 ALTER TABLE `kefangleixing` ENABLE KEYS */;
    213. UNLOCK TABLES;
    214.  
    215. --
    216. -- Table structure for table `messages`
    217. --
    218.  
    219. DROP TABLE IF EXISTS `messages`;
    220. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    221. /*!40101 SET character_set_client = utf8 */;
    222. CREATE TABLE `messages` (
    223.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    224.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    225.   `userid` bigint(20) NOT NULL COMMENT '留言人id',
    226.   `username` varchar(200) DEFAULT NULL COMMENT '用户名',
    227.   `avatarurl` longtext COMMENT '头像',
    228.   `content` longtext NOT NULL COMMENT '留言内容',
    229.   `cpicture` longtext COMMENT '留言图片',
    230.   `reply` longtext COMMENT '回复内容',
    231.   `rpicture` longtext COMMENT '回复图片',
    232.   PRIMARY KEY (`id`)
    233. ) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8 COMMENT='留言板';
    234. /*!40101 SET character_set_client = @saved_cs_client */;
    235.  
    236. --
    237. -- Dumping data for table `messages`
    238. --
    239.  
    240. LOCK TABLES `messages` WRITE;
    241. /*!40000 ALTER TABLE `messages` DISABLE KEYS */;
    242. INSERT INTO `messages` VALUES (151,'2023-03-05 03:12:21',1,'用户名1','upload/messages_avatarurl1.jpg','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(152,'2023-03-05 03:12:21',2,'用户名2','upload/messages_avatarurl2.jpg','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(153,'2023-03-05 03:12:21',3,'用户名3','upload/messages_avatarurl3.jpg','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(154,'2023-03-05 03:12:21',4,'用户名4','upload/messages_avatarurl4.jpg','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(155,'2023-03-05 03:12:21',5,'用户名5','upload/messages_avatarurl5.jpg','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(156,'2023-03-05 03:12:21',6,'用户名6','upload/messages_avatarurl6.jpg','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg'),(157,'2023-03-05 03:12:21',7,'用户名7','upload/messages_avatarurl7.jpg','留言内容7','upload/messages_cpicture7.jpg','回复内容7','upload/messages_rpicture7.jpg'),(158,'2023-03-05 03:12:21',8,'用户名8','upload/messages_avatarurl8.jpg','留言内容8','upload/messages_cpicture8.jpg','回复内容8','upload/messages_rpicture8.jpg');
    243. /*!40000 ALTER TABLE `messages` ENABLE KEYS */;
    244. UNLOCK TABLES;
    245.  
    246. --
    247. -- Table structure for table `minsuyuangong`
    248. --
    249.  
    250. DROP TABLE IF EXISTS `minsuyuangong`;
    251. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    252. /*!40101 SET character_set_client = utf8 */;
    253. CREATE TABLE `minsuyuangong` (
    254.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    255.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    256.   `yuangonggonghao` varchar(200) NOT NULL COMMENT '员工工号',
    257.   `mima` varchar(200) NOT NULL COMMENT '密码',
    258.   `yuangongxingming` varchar(200) NOT NULL COMMENT '员工姓名',
    259.   `touxiang` longtext COMMENT '头像',
    260.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    261.   `nianling` int(11) DEFAULT NULL COMMENT '年龄',
    262.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    263.   `minsumingcheng` varchar(200) DEFAULT NULL COMMENT '民宿名称',
    264.   PRIMARY KEY (`id`),
    265.   UNIQUE KEY `yuangonggonghao` (`yuangonggonghao`)
    266. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='民宿员工';
    267. /*!40101 SET character_set_client = @saved_cs_client */;
    268.  
    269. --
    270. -- Table structure for table `news`
    271. --
    272.  
    273. DROP TABLE IF EXISTS `news`;
    274. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    275. /*!40101 SET character_set_client = utf8 */;
    276. CREATE TABLE `news` (
    277.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    278.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    279.   `title` varchar(200) NOT NULL COMMENT '标题',
    280.   `introduction` longtext COMMENT '简介',
    281.   `picture` longtext NOT NULL COMMENT '图片',
    282.   `content` longtext NOT NULL COMMENT '内容',
    283.   PRIMARY KEY (`id`)
    284. ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='新闻资讯';
    285. /*!40101 SET character_set_client = @saved_cs_client */;
    286.  
    287.  
    288. --
    289. -- Table structure for table `remenkefang`
    290. --
    291.  
    292. DROP TABLE IF EXISTS `remenkefang`;
    293. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    294. /*!40101 SET character_set_client = utf8 */;
    295. CREATE TABLE `remenkefang` (
    296.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    297.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    298.   `kefangbianhao` varchar(200) DEFAULT NULL COMMENT '客房编号',
    299.   `kefangmingcheng` varchar(200) DEFAULT NULL COMMENT '客房名称',
    300.   `kefangtupian` longtext COMMENT '客房图片',
    301.   `kefangleixing` varchar(200) DEFAULT NULL COMMENT '客房类型',
    302.   `kefangzhuangtai` varchar(200) DEFAULT NULL COMMENT '客房状态',
    303.   `yiwanjiage` int(11) NOT NULL COMMENT '一晚价格',
    304.   `fuwuxiangmu` longtext COMMENT '服务项目',
    305.   `peitaosheshi` longtext COMMENT '配套设施',
    306.   `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
    307.   `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
    308.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    309.   `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
    310.   `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
    311.   `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
    312.   `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
    313.   PRIMARY KEY (`id`),
    314.   UNIQUE KEY `kefangbianhao` (`kefangbianhao`)
    315. ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='热门客房';
    316. /*!40101 SET character_set_client = @saved_cs_client */;
    317.  
    318. --
    319. -- Dumping data for table `remenkefang`
    320. --
    321.  
    322. LOCK TABLES `remenkefang` WRITE;
    323. /*!40000 ALTER TABLE `remenkefang` DISABLE KEYS */;
    324. INSERT INTO `remenkefang` VALUES (51,'2023-03-05 03:12:21','客房编号1','客房名称1','upload/remenkefang_kefangtupian1.jpg,upload/remenkefang_kefangtupian2.jpg,upload/remenkefang_kefangtupian3.jpg','客房类型1','己预定',1,'服务项目1','配套设施1','员工工号1','员工姓名1','联系电话1',1,1,'2023-03-05 11:12:21',1),(52,'2023-03-05 03:12:21','客房编号2','客房名称2','upload/remenkefang_kefangtupian2.jpg,upload/remenkefang_kefangtupian3.jpg,upload/remenkefang_kefangtupian4.jpg','客房类型2','己预定',2,'服务项目2','配套设施2','员工工号2','员工姓名2','联系电话2',2,2,'2023-03-05 11:12:21',2),(53,'2023-03-05 03:12:21','客房编号3','客房名称3','upload/remenkefang_kefangtupian3.jpg,upload/remenkefang_kefangtupian4.jpg,upload/remenkefang_kefangtupian5.jpg','客房类型3','己预定',3,'服务项目3','配套设施3','员工工号3','员工姓名3','联系电话3',3,3,'2023-03-05 11:12:21',3),(54,'2023-03-05 03:12:21','客房编号4','客房名称4','upload/remenkefang_kefangtupian4.jpg,upload/remenkefang_kefangtupian5.jpg,upload/remenkefang_kefangtupian6.jpg','客房类型4','己预定',4,'服务项目4','配套设施4','员工工号4','员工姓名4','联系电话4',4,4,'2023-03-05 11:12:21',4),(55,'2023-03-05 03:12:21','客房编号5','客房名称5','upload/remenkefang_kefangtupian5.jpg,upload/remenkefang_kefangtupian6.jpg,upload/remenkefang_kefangtupian7.jpg','客房类型5','己预定',5,'服务项目5','配套设施5','员工工号5','员工姓名5','联系电话5',5,5,'2023-03-05 11:12:21',5),(56,'2023-03-05 03:12:21','客房编号6','客房名称6','upload/remenkefang_kefangtupian6.jpg,upload/remenkefang_kefangtupian7.jpg,upload/remenkefang_kefangtupian8.jpg','客房类型6','己预定',6,'服务项目6','配套设施6','员工工号6','员工姓名6','联系电话6',6,6,'2023-03-05 11:12:21',6),(57,'2023-03-05 03:12:21','客房编号7','客房名称7','upload/remenkefang_kefangtupian7.jpg,upload/remenkefang_kefangtupian8.jpg,upload/remenkefang_kefangtupian9.jpg','客房类型7','己预定',7,'服务项目7','配套设施7','员工工号7','员工姓名7','联系电话7',7,7,'2023-03-05 11:12:21',7),(58,'2023-03-05 03:12:21','客房编号8','客房名称8','upload/remenkefang_kefangtupian8.jpg,upload/remenkefang_kefangtupian9.jpg,upload/remenkefang_kefangtupian10.jpg','客房类型8','己预定',8,'服务项目8','配套设施8','员工工号8','员工姓名8','联系电话8',8,8,'2023-03-05 11:12:21',8);
    325. /*!40000 ALTER TABLE `remenkefang` ENABLE KEYS */;
    326. UNLOCK TABLES;
    327.  
    328. --
    329. -- Table structure for table `storeup`
    330. --
    331.  
    332. DROP TABLE IF EXISTS `storeup`;
    333. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    334. /*!40101 SET character_set_client = utf8 */;
    335. CREATE TABLE `storeup` (
    336.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    337.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    338.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    339.   `refid` bigint(20) DEFAULT NULL COMMENT '商品id',
    340.   `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
    341.   `name` varchar(200) NOT NULL COMMENT '名称',
    342.   `picture` longtext NOT NULL COMMENT '图片',
    343.   `type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',
    344.   `inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
    345.   `remark` varchar(200) DEFAULT NULL COMMENT '备注',
    346.   PRIMARY KEY (`id`)
    347. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
    348. /*!40101 SET character_set_client = @saved_cs_client */;
    349.  
    350. --
    351. -- Dumping data for table `storeup`
    352. --
    353.  
    354. LOCK TABLES `storeup` WRITE;
    355. /*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
    356. /*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
    357. UNLOCK TABLES;
    358.  
    359. --
    360. -- Table structure for table `systemintro`
    361. --
    362.  
    363. DROP TABLE IF EXISTS `systemintro`;
    364. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    365. /*!40101 SET character_set_client = utf8 */;
    366. CREATE TABLE `systemintro` (
    367.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    368.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    369.   `title` varchar(200) NOT NULL COMMENT '标题',
    370.   `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题',
    371.   `content` longtext NOT NULL COMMENT '内容',
    372.   `picture1` longtext COMMENT '图片1',
    373.   `picture2` longtext COMMENT '图片2',
    374.   `picture3` longtext COMMENT '图片3',
    375.   PRIMARY KEY (`id`)
    376. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
    377. /*!40101 SET character_set_client = @saved_cs_client */;
    378.  
    379. --
    380. -- Dumping data for table `systemintro`
    381. --
    382.  
    383. LOCK TABLES `systemintro` WRITE;
    384. /*!40000 ALTER TABLE `systemintro` DISABLE KEYS */;
    385. INSERT INTO `systemintro` VALUES (1,'2023-03-05 03:12:21','系统简介','SYSTEM INTRODUCTION','当遇到挫折或失败，你是看见失败还是看见机会?挫折是我们每个人成长的必经之路，它不是你想有就有，想没有就没有的。有句名言说的好，如果你想一生摆脱苦难，你就得是神或者是死尸。这句话形象地说明了挫折是伴随着人生的，是谁都逃不掉的。人生在世，从古到今，不分天子平民，机遇虽有不同，但总不免有身陷困境或遭遇难题之处，这时候唯有通权达变，才能使人转危为安，甚至反败为胜。大部分的人，一生当中，最痛苦的经验是失去所爱的人，其次是丢掉一份工作。其实，经得起考验的人，就算是被开除也不会惊慌，要学会面对。','upload/systemintro_picture1.jpg','upload/systemintro_picture2.jpg','upload/systemintro_picture3.jpg');
    386. /*!40000 ALTER TABLE `systemintro` ENABLE KEYS */;
    387. UNLOCK TABLES;
    388.  
    389. --
    390. -- Table structure for table `token`
    391. --
    392.  
    393. DROP TABLE IF EXISTS `token`;
    394. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    395. /*!40101 SET character_set_client = utf8 */;
    396. CREATE TABLE `token` (
    397.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    398.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    399.   `username` varchar(100) NOT NULL COMMENT '用户名',
    400.   `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
    401.   `role` varchar(100) DEFAULT NULL COMMENT '角色',
    402.   `token` varchar(200) NOT NULL COMMENT '密码',
    403.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    404.   `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
    405.   PRIMARY KEY (`id`)
    406. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='token表';
    407. /*!40101 SET character_set_client = @saved_cs_client */;
    408.  
    409. --
    410. -- Dumping data for table `token`
    411. --
    412.  
    413. LOCK TABLES `token` WRITE;
    414. /*!40000 ALTER TABLE `token` DISABLE KEYS */;
    415. /*!40000 ALTER TABLE `token` ENABLE KEYS */;
    416. UNLOCK TABLES;
    417.  
    418. --
    419. -- Table structure for table `tousufankui`
    420. --
    421.  
    422. DROP TABLE IF EXISTS `tousufankui`;
    423. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    424. /*!40101 SET character_set_client = utf8 */;
    425. CREATE TABLE `tousufankui` (
    426.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    427.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    428.   `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
    429.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    430.   `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
    431.   `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
    432.   `fankuiyijian` longtext COMMENT '反馈意见',
    433.   `pingjiayijian` longtext COMMENT '评价意见',
    434.   `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
    435.   `shhf` longtext COMMENT '审核回复',
    436.   PRIMARY KEY (`id`)
    437. ) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='投诉反馈';
    438. /*!40101 SET character_set_client = @saved_cs_client */;
    439.  
    440. --
    441. -- Dumping data for table `tousufankui`
    442. --
    443.  
    444. LOCK TABLES `tousufankui` WRITE;
    445. /*!40000 ALTER TABLE `tousufankui` DISABLE KEYS */;
    446. INSERT INTO `tousufankui` VALUES (91,'2023-03-05 03:12:21','用户账号1','用户姓名1','手机1','身份证号1','反馈意见1','评价意见1','是',''),(92,'2023-03-05 03:12:21','用户账号2','用户姓名2','手机2','身份证号2','反馈意见2','评价意见2','是',''),(93,'2023-03-05 03:12:21','用户账号3','用户姓名3','手机3','身份证号3','反馈意见3','评价意见3','是',''),(94,'2023-03-05 03:12:21','用户账号4','用户姓名4','手机4','身份证号4','反馈意见4','评价意见4','是',''),(95,'2023-03-05 03:12:21','用户账号5','用户姓名5','手机5','身份证号5','反馈意见5','评价意见5','是',''),(96,'2023-03-05 03:12:21','用户账号6','用户姓名6','手机6','身份证号6','反馈意见6','评价意见6','是',''),(97,'2023-03-05 03:12:21','用户账号7','用户姓名7','手机7','身份证号7','反馈意见7','评价意见7','是',''),(98,'2023-03-05 03:12:21','用户账号8','用户姓名8','手机8','身份证号8','反馈意见8','评价意见8','是','');
    447. /*!40000 ALTER TABLE `tousufankui` ENABLE KEYS */;
    448. UNLOCK TABLES;
    449.  
    450. --
    451. -- Table structure for table `tuifangjiezhang`
    452. --
    453.  
    454. DROP TABLE IF EXISTS `tuifangjiezhang`;
    455. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    456. /*!40101 SET character_set_client = utf8 */;
    457. CREATE TABLE `tuifangjiezhang` (
    458.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    459.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    460.   `kefangbianhao` varchar(200) DEFAULT NULL COMMENT '客房编号',
    461.   `kefangmingcheng` varchar(200) DEFAULT NULL COMMENT '客房名称',
    462.   `kefangleixing` varchar(200) DEFAULT NULL COMMENT '客房类型',
    463.   `yiwanjiage` float DEFAULT NULL COMMENT '一晚价格',
    464.   `ruzhutianshu` int(11) DEFAULT NULL COMMENT '入住天数',
    465.   `feiyongzongji` float DEFAULT NULL COMMENT '费用总计',
    466.   `ruzhushijian` date DEFAULT NULL COMMENT '入住时间',
    467.   `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
    468.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    469.   `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
    470.   `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
    471.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    472.   `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
    473.   `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
    474.   `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
    475.   PRIMARY KEY (`id`)
    476. ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='退房结账';
    477. /*!40101 SET character_set_client = @saved_cs_client */;
    478.  
    479. --
    480. -- Dumping data for table `tuifangjiezhang`
    481. --
    482.  
    483. LOCK TABLES `tuifangjiezhang` WRITE;
    484. /*!40000 ALTER TABLE `tuifangjiezhang` DISABLE KEYS */;
    485. INSERT INTO `tuifangjiezhang` VALUES (81,'2023-03-05 03:12:21','客房编号1','客房名称1','客房类型1',1,1,1,'2023-03-05','用户账号1','用户姓名1','员工工号1','员工姓名1','联系电话1',1,1,'未支付'),(82,'2023-03-05 03:12:21','客房编号2','客房名称2','客房类型2',2,2,2,'2023-03-05','用户账号2','用户姓名2','员工工号2','员工姓名2','联系电话2',2,2,'未支付'),(83,'2023-03-05 03:12:21','客房编号3','客房名称3','客房类型3',3,3,3,'2023-03-05','用户账号3','用户姓名3','员工工号3','员工姓名3','联系电话3',3,3,'未支付'),(84,'2023-03-05 03:12:21','客房编号4','客房名称4','客房类型4',4,4,4,'2023-03-05','用户账号4','用户姓名4','员工工号4','员工姓名4','联系电话4',4,4,'未支付'),(85,'2023-03-05 03:12:21','客房编号5','客房名称5','客房类型5',5,5,5,'2023-03-05','用户账号5','用户姓名5','员工工号5','员工姓名5','联系电话5',5,5,'未支付'),(86,'2023-03-05 03:12:21','客房编号6','客房名称6','客房类型6',6,6,6,'2023-03-05','用户账号6','用户姓名6','员工工号6','员工姓名6','联系电话6',6,6,'未支付'),(87,'2023-03-05 03:12:21','客房编号7','客房名称7','客房类型7',7,7,7,'2023-03-05','用户账号7','用户姓名7','员工工号7','员工姓名7','联系电话7',7,7,'未支付'),(88,'2023-03-05 03:12:21','客房编号8','客房名称8','客房类型8',8,8,8,'2023-03-05','用户账号8','用户姓名8','员工工号8','员工姓名8','联系电话8',8,8,'未支付');
    486. /*!40000 ALTER TABLE `tuifangjiezhang` ENABLE KEYS */;
    487. UNLOCK TABLES;
    488.  
    489. --
    490. -- Table structure for table `users`
    491. --
    492.  
    493. DROP TABLE IF EXISTS `users`;
    494. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    495. /*!40101 SET character_set_client = utf8 */;
    496. CREATE TABLE `users` (
    497.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    498.   `username` varchar(100) NOT NULL COMMENT '用户名',
    499.   `password` varchar(100) NOT NULL COMMENT '密码',
    500.   `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
    501.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    502.   PRIMARY KEY (`id`)
    503. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
    504. /*!40101 SET character_set_client = @saved_cs_client */;
    505.  
    506. --
    507. -- Dumping data for table `users`
    508. --
    509.  
    510. LOCK TABLES `users` WRITE;
    511. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
    512. INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-03-05 03:12:21');
    513. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
    514. UNLOCK TABLES;
    515.  
    516. --
    517. -- Table structure for table `yonghu`
    518. --
    519.  
    520. DROP TABLE IF EXISTS `yonghu`;
    521. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    522. /*!40101 SET character_set_client = utf8 */;
    523. CREATE TABLE `yonghu` (
    524.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    525.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    526.   `yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
    527.   `mima` varchar(200) NOT NULL COMMENT '密码',
    528.   `yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',
    529.   `touxiang` longtext COMMENT '头像',
    530.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    531.   `nianling` int(11) DEFAULT NULL COMMENT '年龄',
    532.   `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
    533.   `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
    534.   PRIMARY KEY (`id`),
    535.   UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`),
    536.   UNIQUE KEY `shenfenzhenghao` (`shenfenzhenghao`)
    537. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户';
    538. /*!40101 SET character_set_client = @saved_cs_client */;
    539.  
    540. --
    541. -- Dumping data for table `yonghu`
    542. --
    543.  
    544. LOCK TABLES `yonghu` WRITE;
    545. /*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
    546. INSERT INTO `yonghu` VALUES (11,'2023-03-05 03:12:21','用户账号1','123456','用户姓名1','upload/yonghu_touxiang1.jpg','男',1,'13823888881','440300199101010001'),(12,'2023-03-05 03:12:21','用户账号2','123456','用户姓名2','upload/yonghu_touxiang2.jpg','男',2,'13823888882','440300199202020002'),(13,'2023-03-05 03:12:21','用户账号3','123456','用户姓名3','upload/yonghu_touxiang3.jpg','男',3,'13823888883','440300199303030003'),(14,'2023-03-05 03:12:21','用户账号4','123456','用户姓名4','upload/yonghu_touxiang4.jpg','男',4,'13823888884','440300199404040004'),(15,'2023-03-05 03:12:21','用户账号5','123456','用户姓名5','upload/yonghu_touxiang5.jpg','男',5,'13823888885','440300199505050005'),(16,'2023-03-05 03:12:21','用户账号6','123456','用户姓名6','upload/yonghu_touxiang6.jpg','男',6,'13823888886','440300199606060006'),(17,'2023-03-05 03:12:21','用户账号7','123456','用户姓名7','upload/yonghu_touxiang7.jpg','男',7,'13823888887','440300199707070007'),(18,'2023-03-05 03:12:21','用户账号8','123456','用户姓名8','upload/yonghu_touxiang8.jpg','男',8,'13823888888','440300199808080008');
    547. /*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
    548. UNLOCK TABLES;
    549.  
    550. --
    551. -- Table structure for table `yuyuefuwu`
    552. --
    553.  
    554. DROP TABLE IF EXISTS `yuyuefuwu`;
    555. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    556. /*!40101 SET character_set_client = utf8 */;
    557. CREATE TABLE `yuyuefuwu` (
    558.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    559.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    560.   `kefangbianhao` varchar(200) DEFAULT NULL COMMENT '客房编号',
    561.   `kefangmingcheng` varchar(200) DEFAULT NULL COMMENT '客房名称',
    562.   `shijian` date DEFAULT NULL COMMENT '时间',
    563.   `fuwuxiangmu` longtext COMMENT '服务项目',
    564.   `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
    565.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    566.   `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
    567.   `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
    568.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    569.   `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
    570.   `shhf` longtext COMMENT '审核回复',
    571.   PRIMARY KEY (`id`)
    572. ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='预约服务';
    573. /*!40101 SET character_set_client = @saved_cs_client */;
    574.  
    575. --
    576. -- Dumping data for table `yuyuefuwu`
    577. --
    578.  
    579. LOCK TABLES `yuyuefuwu` WRITE;
    580. /*!40000 ALTER TABLE `yuyuefuwu` DISABLE KEYS */;
    581. INSERT INTO `yuyuefuwu` VALUES (71,'2023-03-05 03:12:21','客房编号1','客房名称1','2023-03-05','服务项目1','用户账号1','用户姓名1','员工工号1','员工姓名1','联系电话1','是',''),(72,'2023-03-05 03:12:21','客房编号2','客房名称2','2023-03-05','服务项目2','用户账号2','用户姓名2','员工工号2','员工姓名2','联系电话2','是',''),(73,'2023-03-05 03:12:21','客房编号3','客房名称3','2023-03-05','服务项目3','用户账号3','用户姓名3','员工工号3','员工姓名3','联系电话3','是',''),(74,'2023-03-05 03:12:21','客房编号4','客房名称4','2023-03-05','服务项目4','用户账号4','用户姓名4','员工工号4','员工姓名4','联系电话4','是',''),(75,'2023-03-05 03:12:21','客房编号5','客房名称5','2023-03-05','服务项目5','用户账号5','用户姓名5','员工工号5','员工姓名5','联系电话5','是',''),(76,'2023-03-05 03:12:21','客房编号6','客房名称6','2023-03-05','服务项目6','用户账号6','用户姓名6','员工工号6','员工姓名6','联系电话6','是',''),(77,'2023-03-05 03:12:21','客房编号7','客房名称7','2023-03-05','服务项目7','用户账号7','用户姓名7','员工工号7','员工姓名7','联系电话7','是',''),(78,'2023-03-05 03:12:21','客房编号8','客房名称8','2023-03-05','服务项目8','用户账号8','用户姓名8','员工工号8','员工姓名8','联系电话8','是','');
    582. /*!40000 ALTER TABLE `yuyuefuwu` ENABLE KEYS */;
    583. UNLOCK TABLES;
    584. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    585.  
    586. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    587. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    588. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    589. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    590. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    591. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    592. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    593.  
    594. -- Dump completed on 2023-03-05 14:00:38

    五.关键代码

    1. package com.controller;
    2. import java.util.Arrays;
    3. import java.util.Calendar;
    4. import java.util.Date;
    5. import java.util.Map;
    6. import javax.servlet.http.HttpServletRequest;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.web.bind.annotation.GetMapping;
    10. import org.springframework.web.bind.annotation.PathVariable;
    11. import org.springframework.web.bind.annotation.PostMapping;
    12. import org.springframework.web.bind.annotation.RequestBody;
    13. import org.springframework.web.bind.annotation.RequestMapping;
    14. import org.springframework.web.bind.annotation.RequestParam;
    15. import org.springframework.web.bind.annotation.ResponseBody;
    16. import org.springframework.web.bind.annotation.RestController;
    17. import com.annotation.IgnoreAuth;
    18. import com.baomidou.mybatisplus.mapper.EntityWrapper;
    19. import com.entity.TokenEntity;
    20. import com.entity.UserEntity;
    21. import com.service.TokenService;
    22. import com.service.UserService;
    23. import com.utils.CommonUtil;
    24. import com.utils.MD5Util;
    25. import com.utils.MPUtil;
    26. import com.utils.PageUtils;
    27. import com.utils.R;
    28. import com.utils.ValidatorUtils;
    29.  
    30. /**
    31.  * 登录相关
    32.  */
    33. @RequestMapping("users")
    34. @RestController
    35. public class UserController{
    36. 	
    37. 	@Autowired
    38. 	private UserService userService;
    39. 	
    40. 	@Autowired
    41. 	private TokenService tokenService;
    42.  
    43. 	/**
    44. 	 * 登录
    45. 	 */
    46. 	@IgnoreAuth
    47. 	@PostMapping(value = "/login")
    48. 	public R login(String username, String password, String captcha, HttpServletRequest request) {
    49. 		UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
    50. 		if(user==null || !user.getPassword().equals(password)) {
    51. 			return R.error("账号或密码不正确");
    52. 		}
    53. 		String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
    54. 		return R.ok().put("token", token);
    55. 	}
    56. 	
    57. 	/**
    58. 	 * 注册
    59. 	 */
    60. 	@IgnoreAuth
    61. 	@PostMapping(value = "/register")
    62. 	public R register(@RequestBody UserEntity user){
    63. //    	ValidatorUtils.validateEntity(user);
    64.     	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    65.     		return R.error("用户已存在");
    66.     	}
    67.         userService.insert(user);
    68.         return R.ok();
    69.     }
    70.  
    71. 	/**
    72. 	 * 退出
    73. 	 */
    74. 	@GetMapping(value = "logout")
    75. 	public R logout(HttpServletRequest request) {
    76. 		request.getSession().invalidate();
    77. 		return R.ok("退出成功");
    78. 	}
    79. 	
    80. 	/**
    81.      * 密码重置
    82.      */
    83.     @IgnoreAuth
    84. 	@RequestMapping(value = "/resetPass")
    85.     public R resetPass(String username, HttpServletRequest request){
    86.     	UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
    87.     	if(user==null) {
    88.     		return R.error("账号不存在");
    89.     	}
    90.     	user.setPassword("123456");
    91.         userService.update(user,null);
    92.         return R.ok("密码已重置为：123456");
    93.     }
    94. 	
    95. 	/**
    96.      * 列表
    97.      */
    98.     @RequestMapping("/page")
    99.     public R page(@RequestParam Map params,UserEntity user){
    100.         EntityWrapper ew = new EntityWrapper();
    101.     	PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
    102.         return R.ok().put("data", page);
    103.     }
    104.  
    105. 	/**
    106.      * 列表
    107.      */
    108.     @RequestMapping("/list")
    109.     public R list( UserEntity user){
    110.        	EntityWrapper ew = new EntityWrapper();
    111.       	ew.allEq(MPUtil.allEQMapPre( user, "user")); 
    112.         return R.ok().put("data", userService.selectListView(ew));
    113.     }
    114.  
    115.     /**
    116.      * 信息
    117.      */
    118.     @RequestMapping("/info/{id}")
    119.     public R info(@PathVariable("id") String id){
    120.         UserEntity user = userService.selectById(id);
    121.         return R.ok().put("data", user);
    122.     }
    123.     
    124.     /**
    125.      * 获取用户的session用户信息
    126.      */
    127.     @RequestMapping("/session")
    128.     public R getCurrUser(HttpServletRequest request){
    129.     	Long id = (Long)request.getSession().getAttribute("userId");
    130.         UserEntity user = userService.selectById(id);
    131.         return R.ok().put("data", user);
    132.     }
    133.  
    134.     /**
    135.      * 保存
    136.      */
    137.     @PostMapping("/save")
    138.     public R save(@RequestBody UserEntity user){
    139. //    	ValidatorUtils.validateEntity(user);
    140.     	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    141.     		return R.error("用户已存在");
    142.     	}
    143.         userService.insert(user);
    144.         return R.ok();
    145.     }
    146.  
    147.     /**
    148.      * 修改
    149.      */
    150.     @RequestMapping("/update")
    151.     public R update(@RequestBody UserEntity user){
    152. //        ValidatorUtils.validateEntity(user);
    153.     	UserEntity u = userService.selectOne(new EntityWrapper().eq("username", user.getUsername()));
    154.     	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    155.     		return R.error("用户名已存在。");
    156.     	}
    157.         userService.updateById(user);//全部更新
    158.         return R.ok();
    159.     }
    160.  
    161.     /**
    162.      * 删除
    163.      */
    164.     @RequestMapping("/delete")
    165.     public R delete(@RequestBody Long[] ids){
    166.         userService.deleteBatchIds(Arrays.asList(ids));
    167.         return R.ok();
    168.     }
    169. }

    六.论文目录参考

    七.源码获取

    感谢大家的阅读，如有不懂的问题可以评论区交流或私聊！

    喜欢文章可以点赞、收藏、关注、评论啦

    获取源码请私信

  • 相关阅读:
    6、PostgreSQL 数据类型之一：数字类型和货币类型
    Linux 线程调度策略简介分析 SCHED_OTHER SCHED_FIFO SCHED_RR
    systemd服务管理与单元实例化详解
    HTML基础-表单标签,button按钮，select下拉菜单
    JAVA整理学习实例（三）数组和其内存结构
    RV1126 DSI 调试
    文件传输、文件挂载MOUNT：NFS、CIFS、ADB、SAMBA
    git 常用命令
    EasyCVR视频监控+AI智能分析网关如何助力木材厂安全生产？
    C++版本的OpenCV实现二维图像的卷积定理(通过傅里叶变换实现二维图像的卷积过程，附代码！！)
  • 原文地址：https://blog.csdn.net/qq_35219282/article/details/133437129