基于springboot的在線小說(shuō)閱讀平臺(tái)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Java
框架：springboot
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)代碼：
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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993771583 DEFAULT CHARSET=utf8 COMMENT='小說(shuō)信息評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(82,'2022-05-08 07:03:01',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(83,'2022-05-08 07:03:01',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(84,'2022-05-08 07:03:01',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(85,'2022-05-08 07:03:01',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(86,'2022-05-08 07:03:01',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標(biāo)題',
? `content` longtext NOT NULL COMMENT '帖子內(nèi)容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點(diǎn)id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `isdone` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? 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','帖子標(biāo)題1','帖子內(nèi)容1',0,1,'用戶名1','開(kāi)放'),(52,'2022-05-08 07:03:01','帖子標(biāo)題2','帖子內(nèi)容2',0,2,'用戶名2','開(kāi)放'),(53,'2022-05-08 07:03:01','帖子標(biāo)題3','帖子內(nèi)容3',0,3,'用戶名3','開(kāi)放'),(54,'2022-05-08 07:03:01','帖子標(biāo)題4','帖子內(nèi)容4',0,4,'用戶名4','開(kāi)放'),(55,'2022-05-08 07:03:01','帖子標(biāo)題5','帖子內(nèi)容5',0,5,'用戶名5','開(kāi)放'),(56,'2022-05-08 07:03:01','帖子標(biāo)題6','帖子內(nèi)容6',0,6,'用戶名6','開(kāi)放'),(1651993745867,'2022-05-08 07:09:05','交流','<p>請(qǐng)輸入內(nèi)容22</p>',0,1651993560872,'111','開(kāi)放'),(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 '創(chuàng)建時(shí)間',
? `huiyuanzhanghao` varchar(200) NOT NULL COMMENT '會(huì)員賬號(hào)',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `huiyuanxingming` varchar(200) NOT NULL COMMENT '會(huì)員姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `huiyuandianhua` varchar(200) DEFAULT NULL COMMENT '會(huì)員電話',
? `touxiang` varchar(200) DEFAULT NULL COMMENT '頭像',
? PRIMARY KEY (`id`),
? UNIQUE KEY `huiyuanzhanghao` (`huiyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993560873 DEFAULT CHARSET=utf8 COMMENT='會(huì)員';
/*!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','會(huì)員賬號(hào)1','123456','會(huì)員姓名1','男','13823888881','upload/huiyuan_touxiang1.jpg'),(12,'2022-05-08 07:03:01','會(huì)員賬號(hào)2','123456','會(huì)員姓名2','男','13823888882','upload/huiyuan_touxiang2.jpg'),(13,'2022-05-08 07:03:01','會(huì)員賬號(hào)3','123456','會(huì)員姓名3','男','13823888883','upload/huiyuan_touxiang3.jpg'),(14,'2022-05-08 07:03:01','會(huì)員賬號(hào)4','123456','會(huì)員姓名4','男','13823888884','upload/huiyuan_touxiang4.jpg'),(15,'2022-05-08 07:03:01','會(huì)員賬號(hào)5','123456','會(huì)員姓名5','男','13823888885','upload/huiyuan_touxiang5.jpg'),(16,'2022-05-08 07:03:01','會(huì)員賬號(hào)6','123456','會(huì)員姓名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 '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡(jiǎn)介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? 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 '創(chuàng)建時(shí)間',
? `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 '新增時(shí)間',
? `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '過(guò)期時(shí)間',
? 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','會(huì)員','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 '新增時(shí)間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用戶表';
/*!40101 SET character_set_client = @saved_cs_client */;
