基于nodejs的面向圖書共享設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語言：nodejs
框架：Express
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：VS code/HBuilder X
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫：
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `name` varchar(100) NOT NULL COMMENT '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dianzixinxiziyuan`
--
DROP TABLE IF EXISTS `dianzixinxiziyuan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianzixinxiziyuan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `ziyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '資源名稱',
? `ziyuanleixing` varchar(200) DEFAULT NULL COMMENT '資源類型',
? `ziyuantupian` varchar(200) DEFAULT NULL COMMENT '資源圖片',
? `ziyuanwenjian` varchar(200) DEFAULT NULL COMMENT '資源文件',
? `ziyuanjieshao` longtext COMMENT '資源介紹',
? `faburiqi` date DEFAULT NULL COMMENT '發(fā)布日期',
? `yonghuming` varchar(200) DEFAULT NULL COMMENT '用戶名',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='電子信息資源';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dianzixinxiziyuan`
--
LOCK TABLES `dianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `dianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `dianzixinxiziyuan` VALUES (51,'2022-04-07 13:08:48','資源名稱1','資源類型1','upload/dianzixinxiziyuan_ziyuantupian1.jpg','','資源介紹1','2022-04-07','用戶名1'),(52,'2022-04-07 13:08:48','資源名稱2','資源類型2','upload/dianzixinxiziyuan_ziyuantupian2.jpg','','資源介紹2','2022-04-07','用戶名2'),(53,'2022-04-07 13:08:48','資源名稱3','資源類型3','upload/dianzixinxiziyuan_ziyuantupian3.jpg','','資源介紹3','2022-04-07','用戶名3'),(54,'2022-04-07 13:08:48','資源名稱4','資源類型4','upload/dianzixinxiziyuan_ziyuantupian4.jpg','','資源介紹4','2022-04-07','用戶名4'),(55,'2022-04-07 13:08:48','資源名稱5','資源類型5','upload/dianzixinxiziyuan_ziyuantupian5.jpg','','資源介紹5','2022-04-07','用戶名5'),(56,'2022-04-07 13:08:48','資源名稱6','資源類型6','upload/dianzixinxiziyuan_ziyuantupian6.jpg','','資源介紹6','2022-04-07','用戶名6');
/*!40000 ALTER TABLE `dianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussdianzixinxiziyuan`
--
DROP TABLE IF EXISTS `discussdianzixinxiziyuan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdianzixinxiziyuan` (
? `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 '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='電子信息資源評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussdianzixinxiziyuan`
--
LOCK TABLES `discussdianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `discussdianzixinxiziyuan` VALUES (131,'2022-04-07 13:08:48',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(132,'2022-04-07 13:08:48',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(133,'2022-04-07 13:08:48',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(134,'2022-04-07 13:08:48',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(135,'2022-04-07 13:08:48',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(136,'2022-04-07 13:08:48',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusstushuxinxi`
--
DROP TABLE IF EXISTS `discusstushuxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusstushuxinxi` (
? `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 '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='圖書信息評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusstushuxinxi`
--
LOCK TABLES `discusstushuxinxi` WRITE;
/*!40000 ALTER TABLE `discusstushuxinxi` DISABLE KEYS */;
INSERT INTO `discusstushuxinxi` VALUES (111,'2022-04-07 13:08:48',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(112,'2022-04-07 13:08:48',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(113,'2022-04-07 13:08:48',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(114,'2022-04-07 13:08:48',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(115,'2022-04-07 13:08:48',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(116,'2022-04-07 13:08:48',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discusstushuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussyonghufenxiang`
--
DROP TABLE IF EXISTS `discussyonghufenxiang`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyonghufenxiang` (
? `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 '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='用戶分享評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussyonghufenxiang`
--
LOCK TABLES `discussyonghufenxiang` WRITE;
/*!40000 ALTER TABLE `discussyonghufenxiang` DISABLE KEYS */;
INSERT INTO `discussyonghufenxiang` VALUES (121,'2022-04-07 13:08:48',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(122,'2022-04-07 13:08:48',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(123,'2022-04-07 13:08:48',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(124,'2022-04-07 13:08:48',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(125,'2022-04-07 13:08:48',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(126,'2022-04-07 13:08:48',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discussyonghufenxiang` 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=77 DEFAULT CHARSET=utf8 COMMENT='社區(qū)交流';
/*!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 (71,'2022-04-07 13:08:48','帖子標(biāo)題1','帖子內(nèi)容1',0,1,'用戶名1','開放'),(72,'2022-04-07 13:08:48','帖子標(biāo)題2','帖子內(nèi)容2',0,2,'用戶名2','開放'),(73,'2022-04-07 13:08:48','帖子標(biāo)題3','帖子內(nèi)容3',0,3,'用戶名3','開放'),(74,'2022-04-07 13:08:48','帖子標(biāo)題4','帖子內(nèi)容4',0,4,'用戶名4','開放'),(75,'2022-04-07 13:08:48','帖子標(biāo)題5','帖子內(nèi)容5',0,5,'用戶名5','開放'),(76,'2022-04-07 13:08:48','帖子標(biāo)題6','帖子內(nèi)容6',0,6,'用戶名6','開放');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
? `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',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '留言內(nèi)容',
? `cpicture` varchar(200) DEFAULT NULL COMMENT '留言圖片',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? `rpicture` varchar(200) DEFAULT NULL COMMENT '回復(fù)圖片',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='聯(lián)系我們';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (101,'2022-04-07 13:08:48',1,'用戶名1','留言內(nèi)容1','upload/messages_cpicture1.jpg','回復(fù)內(nèi)容1','upload/messages_rpicture1.jpg'),(102,'2022-04-07 13:08:48',2,'用戶名2','留言內(nèi)容2','upload/messages_cpicture2.jpg','回復(fù)內(nèi)容2','upload/messages_rpicture2.jpg'),(103,'2022-04-07 13:08:48',3,'用戶名3','留言內(nèi)容3','upload/messages_cpicture3.jpg','回復(fù)內(nèi)容3','upload/messages_rpicture3.jpg'),(104,'2022-04-07 13:08:48',4,'用戶名4','留言內(nèi)容4','upload/messages_cpicture4.jpg','回復(fù)內(nèi)容4','upload/messages_rpicture4.jpg'),(105,'2022-04-07 13:08:48',5,'用戶名5','留言內(nèi)容5','upload/messages_cpicture5.jpg','回復(fù)內(nèi)容5','upload/messages_rpicture5.jpg'),(106,'2022-04-07 13:08:48',6,'用戶名6','留言內(nèi)容6','upload/messages_cpicture6.jpg','回復(fù)內(nèi)容6','upload/messages_rpicture6.jpg');
/*!40000 ALTER TABLE `messages` 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 '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
