基于springboot的在线小说阅读平台计算机毕业设计源码LW文档
开发语言:Java
框架:springboot
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
数据库代码:
DROP TABLE IF EXISTS `discussxiaoshuoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxiaoshuoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",
`refid` bigint(20) NOT NULL COMMENT "关联表id",
`userid` bigint(20) NOT NULL COMMENT "用户id",
`nickname` varchar(200) DEFAULT NULL COMMENT "用户名",
`content` longtext NOT NULL COMMENT "评论内容",
`reply` longtext COMMENT "回复内容",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993771583 DEFAULT CHARSET=utf8 COMMENT="小说信息评论表";
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussxiaoshuoxinxi`
--
LOCK TABLES `discussxiaoshuoxinxi` WRITE;
/*!40000 ALTER TABLE `discussxiaoshuoxinxi` DISABLE KEYS */;
INSERT INTO `discussxiaoshuoxinxi` VALUES (81,"2022-05-08 07:03:01",1,1,"用户名1","评论内容1","回复内容1"),(82,"2022-05-08 07:03:01",2,2,"用户名2","评论内容2","回复内容2"),(83,"2022-05-08 07:03:01",3,3,"用户名3","评论内容3","回复内容3"),(84,"2022-05-08 07:03:01",4,4,"用户名4","评论内容4","回复内容4"),(85,"2022-05-08 07:03:01",5,5,"用户名5","评论内容5","回复内容5"),(86,"2022-05-08 07:03:01",6,6,"用户名6","评论内容6","回复内容6"),(1651993771582,"2022-05-08 07:09:31",1651993640777,1651993560872,"111","4352345","67567");
/*!40000 ALTER TABLE `discussxiaoshuoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",
`title` varchar(200) DEFAULT NULL COMMENT "帖子标题",
`content` longtext NOT NULL COMMENT "帖子内容",
`parentid` bigint(20) DEFAULT NULL COMMENT "父节点id",
`userid` bigint(20) NOT NULL COMMENT "用户id",
`username` varchar(200) DEFAULT NULL COMMENT "用户名",
`isdone` varchar(200) DEFAULT NULL COMMENT "状态",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993754603 DEFAULT CHARSET=utf8 COMMENT="交流论坛";
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (51,"2022-05-08 07:03:01","帖子标题1","帖子内容1",0,1,"用户名1","开放"),(52,"2022-05-08 07:03:01","帖子标题2","帖子内容2",0,2,"用户名2","开放"),(53,"2022-05-08 07:03:01","帖子标题3","帖子内容3",0,3,"用户名3","开放"),(54,"2022-05-08 07:03:01","帖子标题4","帖子内容4",0,4,"用户名4","开放"),(55,"2022-05-08 07:03:01","帖子标题5","帖子内容5",0,5,"用户名5","开放"),(56,"2022-05-08 07:03:01","帖子标题6","帖子内容6",0,6,"用户名6","开放"),(1651993745867,"2022-05-08 07:09:05","交流","
请输入内容22",0,1651993560872,"111","开放"),(1651993754602,"2022-05-08 07:09:13",NULL,"而他也容易吐",51,1651993560872,"111",NULL);
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huiyuan`
--
DROP TABLE IF EXISTS `huiyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huiyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",
`huiyuanzhanghao` varchar(200) NOT NULL COMMENT "会员账号",
`mima` varchar(200) NOT NULL COMMENT "密码",
`huiyuanxingming` varchar(200) NOT NULL COMMENT "会员姓名",
`xingbie` varchar(200) DEFAULT NULL COMMENT "性别",
`huiyuandianhua` varchar(200) DEFAULT NULL COMMENT "会员电话",
`touxiang` varchar(200) DEFAULT NULL COMMENT "头像",
PRIMARY KEY (`id`),
UNIQUE KEY `huiyuanzhanghao` (`huiyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993560873 DEFAULT CHARSET=utf8 COMMENT="会员";
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huiyuan`
--
LOCK TABLES `huiyuan` WRITE;
/*!40000 ALTER TABLE `huiyuan` DISABLE KEYS */;
INSERT INTO `huiyuan` VALUES (11,"2022-05-08 07:03:01","会员账号1","123456","会员姓名1","男","13823888881","upload/huiyuan_touxiang1.jpg"),(12,"2022-05-08 07:03:01","会员账号2","123456","会员姓名2","男","13823888882","upload/huiyuan_touxiang2.jpg"),(13,"2022-05-08 07:03:01","会员账号3","123456","会员姓名3","男","13823888883","upload/huiyuan_touxiang3.jpg"),(14,"2022-05-08 07:03:01","会员账号4","123456","会员姓名4","男","13823888884","upload/huiyuan_touxiang4.jpg"),(15,"2022-05-08 07:03:01","会员账号5","123456","会员姓名5","男","13823888885","upload/huiyuan_touxiang5.jpg"),(16,"2022-05-08 07:03:01","会员账号6","123456","会员姓名6","男","13823888886","upload/huiyuan_touxiang6.jpg"),(1651993560872,"2022-05-08 07:06:00","111","111","张宇","女","13655555526","upload/1651993560320.jpg");
/*!40000 ALTER TABLE `huiyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",
`title` varchar(200) NOT NULL COMMENT "标题",
`introduction` longtext COMMENT "简介",
`picture` varchar(200) NOT NULL COMMENT "图片",
`content` longtext NOT NULL COMMENT "内容",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993705748 DEFAULT CHARSET=utf8 COMMENT="公告资讯";
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",
`userid` bigint(20) NOT NULL COMMENT "用户id",
`refid` bigint(20) DEFAULT NULL COMMENT "收藏id",
`tablename` varchar(200) DEFAULT NULL COMMENT "表名",
`name` varchar(200) NOT NULL COMMENT "收藏名称",
`picture` varchar(200) NOT NULL COMMENT "收藏图片",
`type` varchar(200) DEFAULT "1" COMMENT "类型(1:收藏,21:赞,22:踩)",
`inteltype` varchar(200) DEFAULT NULL COMMENT "推荐类型",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993763052 DEFAULT CHARSET=utf8 COMMENT="收藏表";
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
INSERT INTO `storeup` VALUES (1651993763051,"2022-05-08 07:09:22",1651993560872,1651993640777,"xiaoshuoxinxi","杀神","upload/1651993586756.png","1",NULL);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`userid` bigint(20) NOT NULL COMMENT "用户id",
`username` varchar(100) NOT NULL COMMENT "用户名",
`tablename` varchar(100) DEFAULT NULL COMMENT "表名",
`role` varchar(100) DEFAULT NULL COMMENT "角色",
`token` varchar(200) NOT NULL COMMENT "密码",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "新增时间",
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "过期时间",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT="token表";
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1,"abo","users","管理员","jevka6rnge8q6ucf8yyeqstq7a4pglb7","2022-05-08 07:05:43","2022-05-08 08:10:31"),(2,1651993560872,"111","huiyuan","会员","bhrxdgq754fe1a8flolih3ifgu17hi8p","2022-05-08 07:08:50","2022-05-08 08:10:48");
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键",
`username` varchar(100) NOT NULL COMMENT "用户名",
`password` varchar(100) NOT NULL COMMENT "密码",
`role` varchar(100) DEFAULT "管理员" COMMENT "角色",
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "新增时间",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT="用户表";
/*!40101 SET character_set_client = @saved_cs_client */;
神木不当公告撤回背后货车司机的生存之痛也应引起重视卡车之家原创日前,陕西省神木市市场监督管理局一纸公告一律不准向大车司机提供吃饭住宿购物等需求将自己推上风口浪尖。尽管最后不当公告撤回,相关负责人被立案调查,但我们不得不考虑的一个重
澳门冠军赛再爆大冷门!世界冠军三局完胜,张本智和一轮游WTT澳门冠军赛十六强争夺战继续进行,在早场结束的比赛中,国乒核心王曼昱以2比3不敌袁嘉楠,爆出了开赛以来最大冷门,也是第二位出局的国乒球员,同时也是第一个输掉外战的,但比赛就会有
孙颖莎独守上半区,冠军赛单打16强全部产生10月20日澳门冠军赛第二个比赛日,男女单打均爆出不少冷门,让球迷直呼不愧是冠军赛,真强手如林。女单方面,王曼昱苦战五局23不敌法国一姐袁嘉楠,这样国乒上半区仅剩孙颖莎。袁嘉楠的超
降价至少400,还赠送89元物品,红米K50迎来双十一,真香一年一度的双十一马上又要到来,手机厂商之间的销量竞争又会是一场好戏。每年双十一,小米总是大赢家,因为小米的主要销量来源就是线上市场,而线上市场的销量巅峰就是每年的双十一和六一八。在
十年小红书,疲态独角兽作者云磐来源商业人物(IDbizleaders)不知不觉就来到了今年的最后一个季度,去年开始传得沸沸扬扬要上市的小红书,随后便没了消息,日前CFO杨若的离职,让观望其年底上市的一些
火箭在小波特身上的付出,终于看到了点回报火箭赛季第一场虽然还是输了,但刚续约的小波特确实打出了点门道,有了那么点领袖和核心控卫的意思。虽然数据和上个赛季的区别不大,得分和助攻也没有什么涨幅,而且失望也不少,但比赛气质确实
山西晋城的皇城相府地下文物看陕西,地上文物看山西,某次出差郑州的时候,绕着郑州在河南的北部走了一圈,离焦作市不远的地方就是山西的晋城市,于是又一溜烟的开车过去瞧瞧。这是我第一次踏足山西的地界,直到发
日常生活中怎么预防扁桃体炎扁桃体炎一种常见的咽喉科疾病,扁桃体炎一般不会给人体造成极大的危害,但是如果不及时的治疗会引起很多的并发症,所以对于这种疾病,应该及时的做好治疗和预防措施。下面就带大家了解一下扁桃
火箭葬送好局迎首败!老鹰4人20,申京表现低迷,探花郎177新赛季NBA常规赛全面打响,老鹰坐镇主场迎战火箭。火箭在季前赛中3胜1负,今年的17顺位新秀伊森,表现特别抢眼,而2天前火箭也和波特完成了4年8250万美元的续约,未来几年,火箭的
10,阿利森扑点,努涅斯制胜,利物浦终结对手5场不败反超曼联赛前排名第8的利物浦队迎来了英超联赛第12轮的较量,利物浦队此役坐镇自己的主场PK赛前排名第13的西汉姆联队。利物浦最近5次主场对阵西汉姆队保持全胜,所以赛前有超过80的人都看好主
00!切尔西爆冷,丢掉2分,5连胜被终结,凯帕屡次神扑救险北京时间10月20日凌晨230,英超第12轮的一场比赛展开争夺,切尔西做客挑战布伦特福德。上半场,伊万托尼两记极具威胁的头球攻门都被凯帕化解,阿斯皮利奎塔远射被扑出。下半场,姆贝乌